{ "currentVersion": 10.71, "id": 13, "name": "Fogger_Log_Relate", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "UserName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ObjectID", "type": "esriFieldTypeOID", "alias": "ObjectID", "domain": null }, { "name": "SesnID", "type": "esriFieldTypeString", "alias": "Session ID", "length": 50, "domain": null }, { "name": "SesnDate", "type": "esriFieldTypeDate", "alias": "Session Date", "length": 8, "domain": null }, { "name": "UserName", "type": "esriFieldTypeString", "alias": "Employee Name", "length": 50, "domain": { "type": "codedValue", "name": "WS8_UserName", "description": "Sentinel GIS UserName domain", "codedValues": [ { "name": "Fernando Arellano Jr", "code": "Fernando Arellano Jr" }, { "name": "Willie Gonzalez", "code": "Willie Gonzalez" }, { "name": "Fred Barnes", "code": "Fred Barnes" }, { "name": "Pedro Montana", "code": "Pedro Montana" }, { "name": "Jesse Rodriguez", "code": "Jesse Rodriguez" }, { "name": "Maria Torres", "code": "Maria Torres" }, { "name": "Joanna Marroquin", "code": "Joanna Marroquin" }, { "name": "Daniel Hernandez", "code": "Daniel Hernandez" }, { "name": "Carolina Kavalasis", "code": "Carolina Kavalasis" }, { "name": "Frank Reyes", "code": "Frank Reyes" }, { "name": "Norma Rodriguez", "code": "Norma Rodriguez" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "TruckID", "type": "esriFieldTypeString", "alias": "Truck ID", "length": 50, "domain": { "type": "codedValue", "name": "WS8_TruckID", "description": "Sentinel GIS TruckID domain", "codedValues": [ { "name": "Truck 1 535-282", "code": "Truck 1 535-282" }, { "name": "Truck 2 535-477", "code": "Truck 2 535-477" }, { "name": "Truck 4 532-10000", "code": "Truck 4 532-10000" }, { "name": "Truck 6 532-288", "code": "Truck 6 532-288" }, { "name": "Truck 7 532-972", "code": "Truck 7 532-972" }, { "name": "Truck 8 532-9154", "code": "Truck 8 532-9154" }, { "name": "Truck 3 535-476", "code": "Truck 3 535-476" }, { "name": "GATOR 532-9264", "code": "GATOR 532-9264" }, { "name": "Truck 5 532-241", "code": "Truck 5 532-241" }, { "name": "GATOR 532-10141", "code": "GATOR 532-10141" }, { "name": "GATOR 532-10140", "code": "GATOR 532-10140" }, { "name": "Truck 9 535-10001", "code": "Truck 9 535-10001" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "AssignArea", "type": "esriFieldTypeString", "alias": "Fog Area", "length": 50, "domain": { "type": "codedValue", "name": "WS8_FogAreas", "description": "Sentinel GIS Fog Area Domain", "codedValues": [ { "name": "2", "code": "2" }, { "name": "1", "code": "1" }, { "name": "11", "code": "11" }, { "name": "10", "code": "10" }, { "name": "8", "code": "8" }, { "name": "9", "code": "9" }, { "name": "3", "code": "3" }, { "name": "5", "code": "5" }, { "name": "4", "code": "4" }, { "name": "7", "code": "7" }, { "name": "21", "code": "21" }, { "name": "23", "code": "23" }, { "name": "6", "code": "6" }, { "name": "13", "code": "13" }, { "name": "12", "code": "12" }, { "name": "14", "code": "14" }, { "name": "15", "code": "15" }, { "name": "16", "code": "16" }, { "name": "17", "code": "17" }, { "name": "18", "code": "18" }, { "name": "19", "code": "19" }, { "name": "20", "code": "20" }, { "name": "22", "code": "22" }, { "name": "24", "code": "24" }, { "name": "26", "code": "26" }, { "name": "27", "code": "27" }, { "name": "28", "code": "28" }, { "name": "29", "code": "29" }, { "name": "31", "code": "31" }, { "name": "25", "code": "25" }, { "name": "32", "code": "32" }, { "name": "33", "code": "33" }, { "name": "30", "code": "30" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FogRoute", "type": "esriFieldTypeString", "alias": "Fog Route", "length": 50, "domain": { "type": "codedValue", "name": "WS8_FogRoutes", "description": "Sentinel GIS Fog Route Domain", "codedValues": [], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LogInTime", "type": "esriFieldTypeString", "alias": "Log In Time", "length": 50, "domain": null }, { "name": "LogOutTime", "type": "esriFieldTypeString", "alias": "Log Out Time", "length": 50, "domain": null }, { "name": "TimeInArea", "type": "esriFieldTypeString", "alias": "Session Duration (HH:MM:SS)", "length": 50, "domain": null }, { "name": "SecsInArea", "type": "esriFieldTypeInteger", "alias": "Session Duration (seconds)", "domain": null }, { "name": "Chemical", "type": "esriFieldTypeString", "alias": "Chemical Used", "length": 50, "domain": { "type": "codedValue", "name": "WS8_Chemical", "description": "Sentinel GIS Chemical domain", "codedValues": [ { "name": "BioMist 1.5+7.5", "code": "BioMist 1.5+7.5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "AI", "type": "esriFieldTypeDouble", "alias": "Active Ingredient", "domain": null }, { "name": "MixRate", "type": "esriFieldTypeDouble", "alias": "Mix Rate", "domain": null }, { "name": "Equip", "type": "esriFieldTypeString", "alias": "Equipment Used", "length": 100, "domain": { "type": "codedValue", "name": "WS8_Equipment", "description": "Sentinel GIS Equipment domain", "codedValues": [ { "name": "Clarke SmartFlow 1", "code": "Clarke SmartFlow 1" }, { "name": "Clarke SmartFlow 2", "code": "Clarke SmartFlow 2" }, { "name": "Clarke SmartFlow 3", "code": "Clarke SmartFlow 3" }, { "name": "Clarke SmartFlow 4", "code": "Clarke SmartFlow 4" }, { "name": "Clarke SmartFlow 5", "code": "Clarke SmartFlow 5" }, { "name": "Clarke SmartFlow 6", "code": "Clarke SmartFlow 6" }, { "name": "Clarke SmartFlow 7", "code": "Clarke SmartFlow 7" }, { "name": "Clarke SmartFlow 8", "code": "Clarke SmartFlow 8" }, { "name": "Clarke SmartFlow Gator", "code": "Clarke SmartFlow Gator" }, { "name": "Clarke SmartFlow 9", "code": "Clarke SmartFlow 9" }, { "name": "Clarke SmartFlow Gator 10140", "code": "Clarke SmartFlow Gator 10140" }, { "name": "Clarke SmartFlow Gator 10141", "code": "Clarke SmartFlow Gator 10141" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CalValue", "type": "esriFieldTypeDouble", "alias": "Calibration Value", "domain": null }, { "name": "MtrCntSum", "type": "esriFieldTypeDouble", "alias": "Motor Count Sum", "domain": null }, { "name": "Activity", "type": "esriFieldTypeString", "alias": "Activity", "length": 50, "domain": { "type": "codedValue", "name": "WS8_Activity", "description": "Sentinel GIS Activity domain", "codedValues": [ { "name": "Fogging", "code": "Fogging" }, { "name": "Drive To Fog Area", "code": "Drive To Fog Area" }, { "name": "Drive To Shop", "code": "Drive To Shop" }, { "name": "Break", "code": "Break" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "WindSpeed", "type": "esriFieldTypeString", "alias": "Wind Speed (mph)", "length": 10, "domain": { "type": "codedValue", "name": "WS8_WindSpeed", "description": "Sentinel GIS WindSpeed domain", "codedValues": [ { "name": "< 5", "code": "< 5" }, { "name": "6-10", "code": "6-10" }, { "name": "11-15", "code": "11-15" }, { "name": "16-20", "code": "16-20" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "WindDir", "type": "esriFieldTypeString", "alias": "Wind Direction", "length": 2, "domain": { "type": "codedValue", "name": "WS8_WindDir", "description": "Sentinel GIS WindDir domain", "codedValues": [ { "name": "North", "code": "N" }, { "name": "Northeast", "code": "NE" }, { "name": "East", "code": "E" }, { "name": "Southeast", "code": "SE" }, { "name": "South", "code": "S" }, { "name": "Southwest", "code": "SW" }, { "name": "West", "code": "W" }, { "name": "Northwest", "code": "NW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Temp_", "type": "esriFieldTypeDouble", "alias": "Temperature", "domain": null }, { "name": "Distance", "type": "esriFieldTypeDouble", "alias": "Session Distance", "domain": null }, { "name": "SprayDist", "type": "esriFieldTypeDouble", "alias": "Spray Distance", "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "UserDef1", "type": "esriFieldTypeString", "alias": "UserDef1", "length": 50, "domain": null }, { "name": "UserDef2", "type": "esriFieldTypeString", "alias": "UserDef2", "length": 50, "domain": null }, { "name": "UserDef3", "type": "esriFieldTypeString", "alias": "UserDef3", "length": 50, "domain": null }, { "name": "UserDef4", "type": "esriFieldTypeString", "alias": "UserDef4", "length": 50, "domain": null }, { "name": "UserDef5", "type": "esriFieldTypeString", "alias": "UserDef5", "length": 50, "domain": null }, { "name": "TotalVol", "type": "esriFieldTypeDouble", "alias": "TotalVol", "domain": null }, { "name": "TVSummed", "type": "esriFieldTypeSmallInteger", "alias": "TVSummed", "domain": null }, { "name": "TreatArea", "type": "esriFieldTypeDouble", "alias": "TreatArea", "domain": null }, { "name": "Processed", "type": "esriFieldTypeSmallInteger", "alias": "Processed", "domain": null } ], "indexes": [ { "name": "FDO_ObjectID", "fields": "ObjectID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I16SesnID", "fields": "SesnID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Fogger_Spray_Line", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "SesnID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 50000, "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 }