{ "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 2, "name": "MOSQ.MaintenanceFieldwork", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "TECHNICIAN", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "TECHNICIAN", "type": "esriFieldTypeString", "alias": "TECHNICIAN", "length": 50, "domain": { "type": "codedValue", "name": "Mosq_Technicians", "description": "List of Technicians", "codedValues": [ { "name": "Bruce Murray", "code": "Bruce Murray" }, { "name": "Mike McLeod", "code": "Mike McLeod" }, { "name": "Liesel Polichette", "code": "Liesel Polichette" }, { "name": "Ty VanNosdal", "code": "Ty VanNosdal" }, { "name": "Kevin Diehl", "code": "Kevin Diehl" }, { "name": "Evan Nielson", "code": "Evan Nielson" }, { "name": "Cory VanNosdal", "code": "Cory VanNosdal" }, { "name": "Brendan Willoughby", "code": "Brendan Willoughby" }, { "name": "Tyler Mower", "code": "Tyler Mower" }, { "name": "David Cox", "code": "David Cox" }, { "name": "David Eagar", "code": "David Eagar" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REL_SPOTID", "type": "esriFieldTypeInteger", "alias": "Related Spot ID", "domain": null }, { "name": "SAMPLETAKEN", "type": "esriFieldTypeString", "alias": "Sample Taken", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SAMPLEID", "type": "esriFieldTypeInteger", "alias": "Sample ID", "domain": null }, { "name": "WORKDATE", "type": "esriFieldTypeDate", "alias": "Date of Work", "length": 8, "domain": null }, { "name": "CHEMICAL_GRANULAR", "type": "esriFieldTypeString", "alias": "Granular Chemical", "length": 50, "domain": { "type": "codedValue", "name": "Mosq_Chemical_Granular", "description": "Granulated chemicals for Mosquito Abatement", "codedValues": [ { "name": "VectoBac CG (Bti)", "code": "VectoBac CG (Bti)" }, { "name": "Abate/Pro Vect", "code": "Abate/Pro Vect" }, { "name": "VectoLex CG", "code": "VectoLex CG" }, { "name": "VectoMax FG", "code": "VectoMax FG" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHMAMT_GRAN", "type": "esriFieldTypeString", "alias": "Chemical Amt in lbs", "length": 10, "domain": null }, { "name": "CHEMICAL_PACKET", "type": "esriFieldTypeString", "alias": "Chemical Packet", "length": 50, "domain": { "type": "codedValue", "name": "Mosq_Chemicals_Packet", "description": "Chemical packets for Mosquito Abatement", "codedValues": [ { "name": "Altosid WSP", "code": "Altosid WSP" }, { "name": "VectoLex WSP", "code": "VectoLex WSP" }, { "name": "None", "code": "None" }, { "name": "Fourstar", "code": "Fourstar" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHMAMT_PACK", "type": "esriFieldTypeString", "alias": "Number of Packets", "length": 10, "domain": null }, { "name": "CHEMICAL_LIQUID", "type": "esriFieldTypeString", "alias": "Liquid Chemical", "length": 50, "domain": { "type": "codedValue", "name": "Mosq_Chemicals_Liquid", "description": "Liquid chemicals for Mosquito Abatement", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Control Oil", "code": "Control Oil" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHMAMT_LIQ", "type": "esriFieldTypeString", "alias": "Chemical Amt in Ounces", "length": 10, "domain": null }, { "name": "A_VEXANS", "type": "esriFieldTypeString", "alias": "A vexans", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "A_FREEBORNI", "type": "esriFieldTypeString", "alias": "A freeborni", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "C_ERYTHROTHORAX", "type": "esriFieldTypeString", "alias": "C erythrothorax", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "C_PIPIENS", "type": "esriFieldTypeString", "alias": "C pipiens", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "C_TARSALIS", "type": "esriFieldTypeString", "alias": "C tarsalis", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "C_INCIDENS", "type": "esriFieldTypeString", "alias": "C incidens", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "C_INORNATA", "type": "esriFieldTypeString", "alias": "C inornata", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "O_CAMPESTRIS", "type": "esriFieldTypeString", "alias": "O campestris", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "O_DORSALIS", "type": "esriFieldTypeString", "alias": "O dorsalis", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "O_FITCHII", "type": "esriFieldTypeString", "alias": "O fitchii", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "O_FLAVESCENS", "type": "esriFieldTypeString", "alias": "O flavescens", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "O_INCREPITUS", "type": "esriFieldTypeString", "alias": "O increpitus", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "O_NIGROMACULIS", "type": "esriFieldTypeString", "alias": "O nigromaculis", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "O_NIPHADOPSIS", "type": "esriFieldTypeString", "alias": "O niphadopsis", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "O_SIERRENSIS", "type": "esriFieldTypeString", "alias": "O sierrensis", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHEMICAL", "type": "esriFieldTypeString", "alias": "Chemical Treatment", "length": 50, "domain": { "type": "codedValue", "name": "Mosq_Chemicals", "description": "Treatment Chemicals for Mosquito Abatement", "codedValues": [ { "name": "VectoBac CG (Bti)", "code": "VectoBac CG (Bti)" }, { "name": "Altosid WSP", "code": "Altosid WSP" }, { "name": "Aqnique", "code": "Aqnique" }, { "name": "Abate/Pro Vect", "code": "Abate/Pro Vect" }, { "name": "VectoLex CG", "code": "VectoLex CG" }, { "name": "Agnique & Abate/ProVect", "code": "Agnique & Abate/ProVect" }, { "name": "Agnique & VectoLex CG", "code": "Agnique & VectoLex CG" }, { "name": "Agnique & VectoBac CG (Bti)", "code": "Agnique & VectoBac CG (Bti)" }, { "name": "VectoLex WSP", "code": "VectoLex WSP" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CHEMICALAMOUNT", "type": "esriFieldTypeString", "alias": "Chemical Amount", "length": 10, "domain": null }, { "name": "DURATION", "type": "esriFieldTypeDouble", "alias": "Treatment Duration", "domain": null }, { "name": "TEMPERATURE", "type": "esriFieldTypeDouble", "alias": "Temperature in F", "domain": null }, { "name": "WINDSPEED", "type": "esriFieldTypeString", "alias": "Wind Velocity", "length": 50, "domain": { "type": "codedValue", "name": "Mosq_WindSpeed", "description": "Wind speed during treatment for Mosquito Abatement", "codedValues": [ { "name": "0-5 mph (calm to breezy)", "code": "0-5 mph (calm to breezy)" }, { "name": "6-15 mph mph (windy)", "code": "6-15 mph mph (windy)" }, { "name": "16-30 mph (very windy)", "code": "16-30 mph (very windy)" }, { "name": "31+ mph (gales)", "code": "31+ mph (gales)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WINDDIRECTION", "type": "esriFieldTypeString", "alias": "Wind Direction", "length": 20, "domain": { "type": "codedValue", "name": "Mosq_WindDirection", "description": "Wind Direction during treatment for Mosquito Abatement", "codedValues": [ { "name": "None", "code": "None" }, { "name": "North", "code": "North" }, { "name": "Northeast", "code": "Northeast" }, { "name": "Northwest", "code": "Northwest" }, { "name": "South", "code": "South" }, { "name": "Southeast", "code": "Southeast" }, { "name": "Southwest", "code": "Southwest" }, { "name": "East", "code": "East" }, { "name": "West", "code": "West" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TIMESTART", "type": "esriFieldTypeDate", "alias": "Start Time", "length": 8, "domain": null }, { "name": "TIMEEND", "type": "esriFieldTypeDate", "alias": "End Time", "length": 8, "domain": null }, { "name": "REL_TRACKID", "type": "esriFieldTypeInteger", "alias": "Track ID", "domain": null }, { "name": "INSTAR", "type": "esriFieldTypeString", "alias": "Instar", "length": 20, "domain": { "type": "codedValue", "name": "Mosq_Instar", "description": "Classification of mosquito larvae maturity", "codedValues": [ { "name": "First", "code": "First" }, { "name": "Second", "code": "Second" }, { "name": "Third", "code": "Third" }, { "name": "Fourth", "code": "Fourth" }, { "name": "Pupa", "code": "Pupa" }, { "name": "Adult", "code": "Adult" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DIP_COUNT", "type": "esriFieldTypeString", "alias": "Dip Count", "length": 12, "domain": { "type": "codedValue", "name": "Mosq_DipCount", "description": "The number of mosquitos found in a single sample dip", "codedValues": [ { "name": "0", "code": "0" }, { "name": "1-5", "code": "1-5" }, { "name": "6-10", "code": "6-10" }, { "name": "11-15", "code": "11-15" }, { "name": "16-20", "code": "16-20" }, { "name": "21-50", "code": "21-50" }, { "name": "51+", "code": "51+" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "UNIDEN", "type": "esriFieldTypeString", "alias": "No species, smashed, pupa, etc.", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WATERDEPTH", "type": "esriFieldTypeString", "alias": "Water Depth", "length": 25, "domain": { "type": "codedValue", "name": "Mosq_WaterDepth", "description": "The depth of the water at mosquito spots", "codedValues": [ { "name": "0-3 inches", "code": "0-3 inches" }, { "name": "1-6 inches", "code": "1-6 inches" }, { "name": "1-9 inches", "code": "1-9 inches" }, { "name": "1-12+ inches", "code": "1-12+ inches" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WATERCHARACTER", "type": "esriFieldTypeString", "alias": "Water Characteristics", "length": 50, "domain": { "type": "codedValue", "name": "Mosq_WaterCharacteristics", "description": "Description of the water in water spots", "codedValues": [ { "name": "Permanent (exists throughout season)", "code": "Permanent (exists throughout season)" }, { "name": "Temporary (alternating dry periods)", "code": "Temporary (alternating dry periods)" }, { "name": "Permanent but fluctuating size", "code": "Permanent but fluctuating size" }, { "name": "Fresh (recently flooded)", "code": "Fresh (recently flooded)" }, { "name": "Clear", "code": "Clear" }, { "name": "Turbid", "code": "Turbid" }, { "name": "Treehole", "code": "Treehole" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DRYORWET", "type": "esriFieldTypeString", "alias": "Dry or Wet", "length": 50, "domain": { "type": "codedValue", "name": "Mosq_DryOrWet", "description": "Relative dryness of mosquito spot", "codedValues": [ { "name": "Dry", "code": "Dry" }, { "name": "Soil Moist (muddy, etc.)", "code": "Soil Moist (muddy, etc.)" }, { "name": "Water level decreasing (drying up)", "code": "Water level decreasing (drying up)" }, { "name": "No obvious change in water level", "code": "No obvious change in water level" }, { "name": "Water level increasing", "code": "Water level increasing" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FISH", "type": "esriFieldTypeString", "alias": "Fish", "length": 20, "domain": { "type": "codedValue", "name": "Mosq_Fish", "description": "Presence of fish in mosquito spots", "codedValues": [ { "name": "Gambusia", "code": "Gambusia" }, { "name": "Other fish present", "code": "Other fish present" }, { "name": "Gambusia planted", "code": "Gambusia planted" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FIELDWORKID", "type": "esriFieldTypeInteger", "alias": "Fieldwork ID", "domain": null }, { "name": "TREATMENT", "type": "esriFieldTypeString", "alias": "Treatment Method", "length": 50, "domain": { "type": "codedValue", "name": "Mosq_Treatment", "description": "Treatment method for Mosquito Abatment", "codedValues": [ { "name": "Hand", "code": "Hand" }, { "name": "ATV", "code": "ATV" }, { "name": "Ground (ULV)", "code": "Ground (ULV)" }, { "name": "Air", "code": "Air" }, { "name": "Drained", "code": "Drained" }, { "name": "Not Treated", "code": "Not treated" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LAB_COMP", "type": "esriFieldTypeString", "alias": "Lab Work Completed", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REL_SERVICEID", "type": "esriFieldTypeInteger", "alias": "Related Service ID", "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null }, { "name": "INSPECTIONAREA", "type": "esriFieldTypeDouble", "alias": "Inspection Area", "domain": null }, { "name": "TREATMENTAREA", "type": "esriFieldTypeDouble", "alias": "Treatment Area", "domain": null }, { "name": "WATERSOURCE", "type": "esriFieldTypeString", "alias": "Source of Water", "length": 30, "domain": { "type": "codedValue", "name": "Mosq_WaterSource", "description": "Water source of mosquito spots", "codedValues": [ { "name": "Precipitation", "code": "Precipitation" }, { "name": "Irrigation", "code": "Irrigation" }, { "name": "Seepage", "code": "Seepage" }, { "name": "Well water", "code": "Well water" }, { "name": "Sewage associated water", "code": "Sewage associated water" }, { "name": "Spring", "code": "Spring" }, { "name": "Pond", "code": "Pond" }, { "name": "Edges of canal, river, etc.", "code": "Edges of canal, river, etc." }, { "name": "Gutters & catch basins", "code": "Gutters & catch basins" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TECHCOMMENTS", "type": "esriFieldTypeString", "alias": "Technician Comments", "length": 255, "domain": null }, { "name": "DISTRICT", "type": "esriFieldTypeSmallInteger", "alias": "District Number", "domain": null }, { "name": "AREA_CHECKED", "type": "esriFieldTypeString", "alias": "Area Checked", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "G103727REL_SPOTI", "fields": "REL_SPOTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G103727REL_TRACK", "fields": "REL_TRACKID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R6812_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_6812", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 6000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Mountain Standard Time", "timeZoneIANA": "America/Denver", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }