{
 "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": "Map,Query,Data",
 "maxRecordCount": 200000,
 "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
 }
}