{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 2, "name": "WinterPlowRoutes_Records", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "DATE_TIME", "typeIdField": "ACTIVITY", "subtypeFieldName": "ACTIVITY", "subtypeField": "ACTIVITY", "defaultSubtypeCode": 2, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "DATE_TIME", "type": "esriFieldTypeDate", "alias": "Date_Time", "length": 8, "domain": null }, { "name": "CLEARING_METHOD", "type": "esriFieldTypeString", "alias": "Clearing_Method", "length": 255, "domain": null }, { "name": "PARENT_ROAD_ID", "type": "esriFieldTypeInteger", "alias": "PARENT_ROAD_ID", "domain": null }, { "name": "PARENT_GLOBALID_DEV", "type": "esriFieldTypeGUID", "alias": "PARENT_GLOBALID_DEV", "length": 38, "domain": null }, { "name": "SHIFT", "type": "esriFieldTypeString", "alias": "Shift", "length": 1, "domain": { "type": "codedValue", "name": "PLOW_ROUTES_SHIFT", "description": "Shift for Plow Route Records", "codedValues": [ { "name": "A", "code": "A" }, { "name": "B", "code": "B" }, { "name": "C", "code": "C" }, { "name": "D", "code": "D" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "ACTIVITY_TYPE", "type": "esriFieldTypeInteger", "alias": "Activity_Type", "domain": { "type": "codedValue", "name": "PLOW_ROUTES_ACTY_TYP", "description": "Activity Type for Plow Route Records", "codedValues": [ { "name": "0-Checked", "code": 0 }, { "name": "1-ClearingNeeded", "code": 1 }, { "name": "2-Remove", "code": 2 }, { "name": "3-Cleared", "code": 3 }, { "name": "4-InspectionFailed", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "UNIT_NUMBER", "type": "esriFieldTypeString", "alias": "Unit_Number_Grader", "length": 255, "domain": null }, { "name": "UNIT_NUMBER_ADD", "type": "esriFieldTypeString", "alias": "Unit_Number_PlowTruck", "length": 255, "domain": null }, { "name": "WINTER_PROGRAM", "type": "esriFieldTypeSmallInteger", "alias": "Winter_Program", "domain": { "type": "codedValue", "name": "WINTER_PROGRAM", "description": "Winter_Program", "codedValues": [ { "name": "AfterSnowEventClearing", "code": 1 }, { "name": "SystematicClearing", "code": 2 }, { "name": "RoutineMaintenance", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ACTIVITY", "type": "esriFieldTypeInteger", "alias": "Activity", "domain": { "type": "codedValue", "name": "WINTER_ACTIVITY", "description": "Winter Activity", "codedValues": [ { "name": "Plowing", "code": 2 }, { "name": "IceShaving", "code": 3 }, { "name": "Removal", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "UNIT_NUMBER_BLW", "type": "esriFieldTypeString", "alias": "Unit_Number_Blower", "length": 255, "domain": null } ], "indexes": [ { "name": "GDB_182198_PAREN", "fields": "PARENT_GLOBALID_DEV", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R2542209_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "types": [ { "domains": { "SHIFT": {"type": "inherited"}, "ACTIVITY_TYPE": {"type": "inherited"}, "WINTER_PROGRAM": {"type": "inherited"} }, "id": 1, "name": "SandBoxing" }, { "domains": { "SHIFT": {"type": "inherited"}, "ACTIVITY_TYPE": {"type": "inherited"}, "UNIT_NUMBER": { "type": "codedValue", "name": "GRADERS", "description": "Graders", "codedValues": [ { "name": "25436", "code": "25436" }, { "name": "25437", "code": "25437" }, { "name": "25438", "code": "25438" }, { "name": "25439", "code": "25439" }, { "name": "25440", "code": "25440" }, { "name": "25441", "code": "25441" }, { "name": "25442", "code": "25442" }, { "name": "25443", "code": "25443" }, { "name": "25444", "code": "25444" }, { "name": "25445", "code": "25445" }, { "name": "25446", "code": "25446" }, { "name": "25447", "code": "25447" }, { "name": "25448", "code": "25448" }, { "name": "25449", "code": "25449" }, { "name": "25450", "code": "25450" }, { "name": "25451", "code": "25451" }, { "name": "CONTRACTOR", "code": "CONTRACTOR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "WINTER_PROGRAM": {"type": "inherited"} }, "id": 2, "name": "Plowing" }, { "domains": { "SHIFT": {"type": "inherited"}, "ACTIVITY_TYPE": {"type": "inherited"}, "UNIT_NUMBER": { "type": "codedValue", "name": "GRADERS", "description": "Graders", "codedValues": [ { "name": "25436", "code": "25436" }, { "name": "25437", "code": "25437" }, { "name": "25438", "code": "25438" }, { "name": "25439", "code": "25439" }, { "name": "25440", "code": "25440" }, { "name": "25441", "code": "25441" }, { "name": "25442", "code": "25442" }, { "name": "25443", "code": "25443" }, { "name": "25444", "code": "25444" }, { "name": "25445", "code": "25445" }, { "name": "25446", "code": "25446" }, { "name": "25447", "code": "25447" }, { "name": "25448", "code": "25448" }, { "name": "25449", "code": "25449" }, { "name": "25450", "code": "25450" }, { "name": "25451", "code": "25451" }, { "name": "CONTRACTOR", "code": "CONTRACTOR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "UNIT_NUMBER_ADD": { "type": "codedValue", "name": "PLOW_TRUCKS", "description": "Plow Trucks", "codedValues": [ { "name": "13029", "code": "13029" }, { "name": "13030", "code": "13030" }, { "name": "13031", "code": "13031" }, { "name": "13032", "code": "13032" }, { "name": "13033", "code": "13033" }, { "name": "13034", "code": "13034" }, { "name": "13035", "code": "13035" }, { "name": "13036", "code": "13036" }, { "name": "13037", "code": "13037" }, { "name": "13038", "code": "13038" }, { "name": "13039", "code": "13039" }, { "name": "13053", "code": "13053" }, { "name": "13054", "code": "13054" }, { "name": "13055", "code": "13055" }, { "name": "13056", "code": "13056" }, { "name": "13057", "code": "13057" }, { "name": "13058", "code": "13058" }, { "name": "13061", "code": "13061" }, { "name": "13061", "code": "13062" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "WINTER_PROGRAM": {"type": "inherited"} }, "id": 3, "name": "IceShaving" }, { "domains": { "SHIFT": {"type": "inherited"}, "ACTIVITY_TYPE": {"type": "inherited"}, "UNIT_NUMBER": { "type": "codedValue", "name": "BLOWERS", "description": "Blowers", "codedValues": [ { "name": "28009", "code": "28009" }, { "name": "28010", "code": "28010" }, { "name": "28011", "code": "28011" }, { "name": "28012", "code": "28012" }, { "name": "28013", "code": "28013" }, { "name": "CONTRACTOR", "code": "CONTRACTOR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "WINTER_PROGRAM": {"type": "inherited"} }, "id": 4, "name": "Removal" } ], "subtypes": [ { "domains": { "SHIFT": {"type": "inherited"}, "ACTIVITY_TYPE": {"type": "inherited"}, "WINTER_PROGRAM": {"type": "inherited"} }, "defaultValues": { "DATE_TIME": null, "CLEARING_METHOD": null, "PARENT_ROAD_ID": null, "PARENT_GLOBALID_DEV": null, "SHIFT": null, "COMMENTS": null, "ACTIVITY_TYPE": 3, "UNIT_NUMBER": null, "UNIT_NUMBER_ADD": null, "WINTER_PROGRAM": null, "ACTIVITY": null, "UNIT_NUMBER_BLW": null }, "code": 1, "name": "SandBoxing" }, { "domains": { "SHIFT": {"type": "inherited"}, "ACTIVITY_TYPE": {"type": "inherited"}, "UNIT_NUMBER": { "type": "codedValue", "name": "GRADERS", "description": "Graders", "codedValues": [ { "name": "25436", "code": "25436" }, { "name": "25437", "code": "25437" }, { "name": "25438", "code": "25438" }, { "name": "25439", "code": "25439" }, { "name": "25440", "code": "25440" }, { "name": "25441", "code": "25441" }, { "name": "25442", "code": "25442" }, { "name": "25443", "code": "25443" }, { "name": "25444", "code": "25444" }, { "name": "25445", "code": "25445" }, { "name": "25446", "code": "25446" }, { "name": "25447", "code": "25447" }, { "name": "25448", "code": "25448" }, { "name": "25449", "code": "25449" }, { "name": "25450", "code": "25450" }, { "name": "25451", "code": "25451" }, { "name": "CONTRACTOR", "code": "CONTRACTOR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "WINTER_PROGRAM": {"type": "inherited"} }, "defaultValues": { "DATE_TIME": null, "CLEARING_METHOD": null, "PARENT_ROAD_ID": null, "PARENT_GLOBALID_DEV": null, "SHIFT": null, "COMMENTS": null, "ACTIVITY_TYPE": 3, "UNIT_NUMBER": null, "UNIT_NUMBER_ADD": null, "WINTER_PROGRAM": null, "ACTIVITY": null, "UNIT_NUMBER_BLW": null }, "code": 2, "name": "Plowing" }, { "domains": { "SHIFT": {"type": "inherited"}, "ACTIVITY_TYPE": {"type": "inherited"}, "UNIT_NUMBER": { "type": "codedValue", "name": "GRADERS", "description": "Graders", "codedValues": [ { "name": "25436", "code": "25436" }, { "name": "25437", "code": "25437" }, { "name": "25438", "code": "25438" }, { "name": "25439", "code": "25439" }, { "name": "25440", "code": "25440" }, { "name": "25441", "code": "25441" }, { "name": "25442", "code": "25442" }, { "name": "25443", "code": "25443" }, { "name": "25444", "code": "25444" }, { "name": "25445", "code": "25445" }, { "name": "25446", "code": "25446" }, { "name": "25447", "code": "25447" }, { "name": "25448", "code": "25448" }, { "name": "25449", "code": "25449" }, { "name": "25450", "code": "25450" }, { "name": "25451", "code": "25451" }, { "name": "CONTRACTOR", "code": "CONTRACTOR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "UNIT_NUMBER_ADD": { "type": "codedValue", "name": "PLOW_TRUCKS", "description": "Plow Trucks", "codedValues": [ { "name": "13029", "code": "13029" }, { "name": "13030", "code": "13030" }, { "name": "13031", "code": "13031" }, { "name": "13032", "code": "13032" }, { "name": "13033", "code": "13033" }, { "name": "13034", "code": "13034" }, { "name": "13035", "code": "13035" }, { "name": "13036", "code": "13036" }, { "name": "13037", "code": "13037" }, { "name": "13038", "code": "13038" }, { "name": "13039", "code": "13039" }, { "name": "13053", "code": "13053" }, { "name": "13054", "code": "13054" }, { "name": "13055", "code": "13055" }, { "name": "13056", "code": "13056" }, { "name": "13057", "code": "13057" }, { "name": "13058", "code": "13058" }, { "name": "13061", "code": "13061" }, { "name": "13061", "code": "13062" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "WINTER_PROGRAM": {"type": "inherited"} }, "defaultValues": { "DATE_TIME": null, "CLEARING_METHOD": null, "PARENT_ROAD_ID": null, "PARENT_GLOBALID_DEV": null, "SHIFT": null, "COMMENTS": null, "ACTIVITY_TYPE": 3, "UNIT_NUMBER": null, "UNIT_NUMBER_ADD": null, "WINTER_PROGRAM": null, "ACTIVITY": null, "UNIT_NUMBER_BLW": null }, "code": 3, "name": "IceShaving" }, { "domains": { "SHIFT": {"type": "inherited"}, "ACTIVITY_TYPE": {"type": "inherited"}, "UNIT_NUMBER": { "type": "codedValue", "name": "BLOWERS", "description": "Blowers", "codedValues": [ { "name": "28009", "code": "28009" }, { "name": "28010", "code": "28010" }, { "name": "28011", "code": "28011" }, { "name": "28012", "code": "28012" }, { "name": "28013", "code": "28013" }, { "name": "CONTRACTOR", "code": "CONTRACTOR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "WINTER_PROGRAM": {"type": "inherited"} }, "defaultValues": { "DATE_TIME": null, "CLEARING_METHOD": null, "PARENT_ROAD_ID": null, "PARENT_GLOBALID_DEV": null, "SHIFT": null, "COMMENTS": null, "ACTIVITY_TYPE": 3, "UNIT_NUMBER": null, "UNIT_NUMBER_ADD": null, "WINTER_PROGRAM": null, "ACTIVITY": null, "UNIT_NUMBER_BLW": null }, "code": 4, "name": "Removal" } ], "relationships": [ { "id": 0, "name": "GIS.WinterPlowRoutes_SR", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "PARENT_GLOBALID_DEV", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Canada Central Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }