{ "currentVersion": 10.71, "id": 7, "name": "SentinelGIS.SDE.Inspections", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SiteName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "Object ID", "domain": null }, { "name": "SiteID", "type": "esriFieldTypeString", "alias": "Site ID", "length": 50, "domain": null }, { "name": "InspID", "type": "esriFieldTypeString", "alias": "Inspection ID", "length": 50, "domain": null }, { "name": "SiteName", "type": "esriFieldTypeString", "alias": "Site Name", "length": 50, "domain": null }, { "name": "SiteZone", "type": "esriFieldTypeString", "alias": "Site Zone", "length": 50, "domain": null }, { "name": "InspDate", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "InspTime", "type": "esriFieldTypeString", "alias": "Inspection Time", "length": 20, "domain": null }, { "name": "SiteCond", "type": "esriFieldTypeString", "alias": "Site Condition", "length": 20, "domain": { "type": "codedValue", "name": "WS3_SiteConditions", "description": "Sentinel GIS site conditions picklist domain.", "codedValues": [ { "name": "Dry", "code": "Dry" }, { "name": "Standing Water", "code": "Standing Water" }, { "name": "Flowing", "code": "Flowing" }, { "name": "Pool", "code": "Pool" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "GenusSpec", "type": "esriFieldTypeString", "alias": "GenusSpec", "length": 10, "domain": null }, { "name": "ElapTime", "type": "esriFieldTypeInteger", "alias": "ElapTime", "domain": null }, { "name": "Activity", "type": "esriFieldTypeString", "alias": "Activity", "length": 20, "domain": { "type": "codedValue", "name": "WS3_ActivityCode", "description": "Sentinel GIS activity code picklist domain.", "codedValues": [ { "name": "Inspection", "code": "Inspection" }, { "name": "Larvaciding", "code": "Larvaciding" }, { "name": "Office", "code": "Office" }, { "name": "Equip. Maint", "code": "Equip. Maint" }, { "name": "PR", "code": "PR" }, { "name": "Work Orders", "code": "Work Orders" }, { "name": "Adulticiding", "code": "Adulticiding" }, { "name": "Assist", "code": "Assist" }, { "name": "Calibration", "code": "Calibration" }, { "name": "Fish Maint", "code": "Fish Maint" }, { "name": "Grounds", "code": "Grounds" }, { "name": "Meetings", "code": "Meetings" }, { "name": "Reef Insp", "code": "Reef Insp" }, { "name": "Training", "code": "Training" }, { "name": "Monthly Reports", "code": "Monthly Reports" }, { "name": "Travel", "code": "Travel" }, { "name": "Annual Leave", "code": "Annual Leave" }, { "name": "Sick Leave", "code": "Sick Leave" }, { "name": "Holiday", "code": "Holiday" }, { "name": "Work Break", "code": "Work Break" }, { "name": "Floating Holiday", "code": "Floating Holiday" }, { "name": "State Of Emergency", "code": "State Of Emergency" }, { "name": "Work Mitigation", "code": "Work Mitigation" }, { "name": "Weather Delay", "code": "Weather Delay" }, { "name": "Bees", "code": "Bees" }, { "name": "Mosquito Trap", "code": "Mosquito Trap" }, { "name": "Mitigation", "code": "Mitigation" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "NumDips", "type": "esriFieldTypeInteger", "alias": "Number of Dips", "domain": null }, { "name": "AvgLarv", "type": "esriFieldTypeInteger", "alias": "Average Larvae per Dip", "domain": null }, { "name": "AvgPup", "type": "esriFieldTypeInteger", "alias": "Average Pupae per Dip", "domain": null }, { "name": "LStages", "type": "esriFieldTypeString", "alias": "Larval Stages", "length": 20, "domain": { "type": "codedValue", "name": "WS3_LarvalStages", "description": "Sentinel GIS larval stages picklist domain.", "codedValues": [ { "name": "1st", "code": "1st" }, { "name": "2nd", "code": "2nd" }, { "name": "3rd", "code": "3rd" }, { "name": "4th", "code": "4th" }, { "name": "1st-2nd", "code": "1st-2nd" }, { "name": "1st-3rd", "code": "1st-3rd" }, { "name": "2nd-3rd", "code": "2nd-3rd" }, { "name": "2nd-4th", "code": "2nd-4th" }, { "name": "3rd-4th", "code": "3rd-4th" }, { "name": "All", "code": "All" }, { "name": "Pupae", "code": "Pupae" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SmFish", "type": "esriFieldTypeString", "alias": "Small Fish", "length": 10, "domain": null }, { "name": "BiteRate", "type": "esriFieldTypeString", "alias": "Bite Rate", "length": 20, "domain": { "type": "codedValue", "name": "WS3_BiteRates", "description": "Sentinel GIS bite rates picklist domain.", "codedValues": [ { "name": "Few (<5)", "code": "Few" }, { "name": "Many (6-50)", "code": "Many" }, { "name": "Infestation (> 50)", "code": "Infestation" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FieldTech", "type": "esriFieldTypeString", "alias": "Field Technician", "length": 50, "domain": { "type": "codedValue", "name": "WS3_Employee", "description": "Sentinel GIS employee/field tech picklist domain.", "codedValues": [ { "name": "Brian Shepheard", "code": "Brian Shepheard" }, { "name": "Roger Moll", "code": "Roger Moll" }, { "name": "Ronnie Downey", "code": "rdowney Testing Only" }, { "name": "Daniel DeBord", "code": "Daniel DeBord" }, { "name": "Steve Peacock", "code": "Steve Peacock" }, { "name": "Jimmy Williamson", "code": "Jimmy Williamson" }, { "name": "Matthew Fish", "code": "Matthew Fish" }, { "name": "Eric Evers", "code": "Eric Evers" }, { "name": "Kimberly Steele", "code": "ksteele Testing only" }, { "name": "Terry Kelley", "code": "Terry Kelley" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "GPSX", "type": "esriFieldTypeDouble", "alias": "GPSX", "domain": null }, { "name": "GPSY", "type": "esriFieldTypeDouble", "alias": "GPSY", "domain": null }, { "name": "GPSZ", "type": "esriFieldTypeDouble", "alias": "GPSZ", "domain": null }, { "name": "UPDTCODE", "type": "esriFieldTypeInteger", "alias": "Update Code", "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I35InspID", "fields": "InspID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I35SiteID", "fields": "SiteID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }