{
"layers": [
{
"currentVersion": 10.91,
"cimVersion": "2.9.0",
"id": 0,
"name": "Cuts without Inspection",
"type": "Feature Layer",
"description": "",
"geometryType": "esriGeometryPoint",
"sourceSpatialReference": {
"wkid": 26913,
"latestWkid": 26913,
"xyTolerance": 0.001,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -5120900,
"falseY": -9998100,
"xyUnits": 10000,
"falseZ": 0,
"zUnits": 1,
"falseM": 0,
"mUnits": 1
},
"copyrightText": "",
"parentLayer": null,
"subLayers": [],
"minScale": 0,
"maxScale": 0,
"referenceScale": 0.0,
"drawingInfo": {
"renderer": {
"type": "simple",
"symbol": {
"type": "esriPMS",
"url": "26bdec00bcd6fc191db8b98ccd3aee9c",
"imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABpUlEQVQ4jbXTPUhbURjG8b8aSf0kGKNxkLQNImLSCA5VkEi0IIIgLQhOUrSIDgqi0HYpTurW0oZS7dRBDAgRguBQQ4II1taoxU7KVUGEaCx+ES8mubGDH/HmGiyID5zlHJ4fL5xzVNwxqvsB2tYNCJN9RENFRKUwmXoPFS12+pNCtwM2u53tH+0UN6eSpjvf+/ungdmvb7CNvMLT7koMVA18prCmk5wSOao1gdakQ5gYo2qwkdm300qg/LWZ3LJWRfl6jM/TWfzwHjDfMEGkm4f1alnhaBPUmvN1GcOzUopeWFlzzsiBjIJ8WXljElyN8EALL1djiNaURLKqGogDJCksAw4EOIuCuAen+/IpwuLVbcSAg9U1GfCkA6IR0Bgh+1Fs/2Q3yM78ohJYH3cS6GpCZ3kMQIoayntRZOXLNMFdjxIQj37i7vxGk7uHlDSNsgn4F36x9PETEFECAP65QRyVIWqH69A/tQLJFyeHLNunmHs3yum++3ol/iWGCfwewlHxnSyjmTxLHpIYYsvrRxK9gD9+qESfycex4ONYSHB8O/Df+QfSP3++niJh9wAAAABJRU5ErkJggg==",
"contentType": "image/png",
"width": 12,
"height": 12,
"angle": 0,
"xoffset": 0,
"yoffset": 0
}
},
"scaleSymbols": true,
"transparency": 0,
"labelingInfo": null
},
"defaultVisibility": true,
"extent": {
"xmin": 509720.0187,
"ymin": 5554738.6682,
"xmax": 574380.3604,
"ymax": 5598459.6735,
"spatialReference": {
"wkid": 26913,
"latestWkid": 26913,
"xyTolerance": 0.001,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -5120900,
"falseY": -9998100,
"xyUnits": 10000,
"falseZ": -100000,
"zUnits": 10000,
"falseM": -100000,
"mUnits": 10000
}
},
"hasAttachments": true,
"attachmentProperties": [
{
"name": "id",
"fieldName": "ATTACHMENTID",
"isEnabled": true
},
{
"name": "globalid",
"fieldName": "GLOBALID",
"isEnabled": true
},
{
"name": "keywords",
"fieldName": "KEYWORDS",
"isEnabled": false
},
{
"name": "name",
"fieldName": "ATT_NAME",
"isEnabled": true
},
{
"name": "contentType",
"fieldName": "CONTENT_TYPE",
"isEnabled": true
},
{
"name": "size",
"fieldName": "DATA_SIZE",
"isEnabled": true
},
{
"name": "exifInfo",
"fieldName": "EXIFINFO",
"isEnabled": false
}
],
"attachmentFields": [
{
"name": "ATTACHMENTID",
"type": "esriFieldTypeOID",
"alias": "ATTACHMENTID",
"editable": false,
"nullable": false,
"length": 4,
"domain": null
},
{
"name": "GLOBALID",
"type": "esriFieldTypeGlobalID",
"alias": "GLOBALID",
"editable": false,
"nullable": false,
"length": 38,
"domain": null
},
{
"name": "ATT_NAME",
"type": "esriFieldTypeString",
"alias": "ATT_NAME",
"editable": true,
"nullable": false,
"length": 250,
"domain": null
},
{
"name": "CONTENT_TYPE",
"type": "esriFieldTypeString",
"alias": "CONTENT_TYPE",
"editable": true,
"nullable": false,
"length": 150,
"domain": null
},
{
"name": "DATA_SIZE",
"type": "esriFieldTypeInteger",
"alias": "DATA_SIZE",
"editable": true,
"nullable": false,
"length": 4,
"domain": null
}
],
"htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
"displayField": "GIS.RoadwaysCutsDB_2_1.DISPATCH_ID_SR_NO",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "GIS.RoadwaysCutsDB_2_1.OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.DISPATCH_ID_SR_NO",
"type": "esriFieldTypeString",
"alias": "DISPATCH_ID_SR_No.",
"length": 50,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.STATUS",
"type": "esriFieldTypeString",
"alias": "STATUS",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Status",
"description": "What is the status of a cut",
"codedValues": [
{
"name": "Open",
"code": "Open"
},
{
"name": "Hold",
"code": "Hold"
},
{
"name": "Closed",
"code": "Closed"
},
{
"name": "Buyout Closed",
"code": "Buyout Closed"
},
{
"name": "Capital Closed",
"code": "Capital Closed"
},
{
"name": "Contractor Open",
"code": "Contractor Open"
},
{
"name": "Contractor Closed",
"code": "Contractor Closed"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.PROGRAM",
"type": "esriFieldTypeString",
"alias": "PROGRAM",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Program",
"description": "",
"codedValues": [
{
"name": "Cuts",
"code": "Cuts"
},
{
"name": "Maintenance",
"code": "Maintenance"
},
{
"name": "WFPP",
"code": "WFPP"
},
{
"name": "Accessibility",
"code": "Accessibility"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.LOCATION_1",
"type": "esriFieldTypeString",
"alias": "LOCATION",
"length": 255,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.LOCATION",
"type": "esriFieldTypeString",
"alias": "LOCATION DESCRIPTION",
"length": 255,
"domain": {
"type": "codedValue",
"name": "RCUTS_Location",
"description": "Location of the cut",
"codedValues": [
{
"name": "In The Alley",
"code": "In The Alley"
},
{
"name": "In Front Of",
"code": "In Front Of"
},
{
"name": "Adjacent To",
"code": "Adjacent To"
},
{
"name": "Across From",
"code": "Across From"
},
{
"name": "In The Boulevard",
"code": "In The Boulevard"
},
{
"name": "NW Corner",
"code": "NW Corner"
},
{
"name": "NE Corner",
"code": "NE Corner"
},
{
"name": "SW Corner",
"code": "SW Corner"
},
{
"name": "SE Corner",
"code": "SE Corner"
},
{
"name": "Easements",
"code": "Easements"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.OPENED_DATE",
"type": "esriFieldTypeDate",
"alias": "OPENED_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.CLOSED_DATE",
"type": "esriFieldTypeDate",
"alias": "CLOSED_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.CUT_TYPE_OR_REPAIR_TYPE",
"type": "esriFieldTypeString",
"alias": "CUT_TYPE_OR REPAIR_TYPE",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Type",
"description": "The type of cut",
"codedValues": [
{
"name": "Brick",
"code": "Brick"
},
{
"name": "Pavement",
"code": "Pavement"
},
{
"name": "Lawn",
"code": "Lawn"
},
{
"name": "Easement",
"code": "Easement"
},
{
"name": "Gravel",
"code": "Gravel"
},
{
"name": "Concrete",
"code": "Concrete"
},
{
"name": "Other",
"code": "Other"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.ITEMS_IN_WORK_AREA",
"type": "esriFieldTypeString",
"alias": "ITEMS_IN_WORK_AREA",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Items",
"description": "A list of the types of cuts items",
"codedValues": [
{
"name": "Catch Basin",
"code": "Catch Basin"
},
{
"name": "Cleanout",
"code": "Cleanout"
},
{
"name": "Coldmix",
"code": "Coldmix"
},
{
"name": "Curb Box",
"code": "Curb Box"
},
{
"name": "Curb Box and Cleanout",
"code": "Curb Box and Cleanout"
},
{
"name": "Hydrant Replacement",
"code": "Hydrant Replacement"
},
{
"name": "Irrigation",
"code": "Irrigation"
},
{
"name": "Manhole",
"code": "Manhole"
},
{
"name": "Thawrod",
"code": "Thawrod"
},
{
"name": "Valve",
"code": "Valve"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.ITEMS_IN_WORK_AREA_2",
"type": "esriFieldTypeString",
"alias": "ITEMS_IN_WORK_AREA_2",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Items",
"description": "A list of the types of cuts items",
"codedValues": [
{
"name": "Catch Basin",
"code": "Catch Basin"
},
{
"name": "Cleanout",
"code": "Cleanout"
},
{
"name": "Coldmix",
"code": "Coldmix"
},
{
"name": "Curb Box",
"code": "Curb Box"
},
{
"name": "Curb Box and Cleanout",
"code": "Curb Box and Cleanout"
},
{
"name": "Hydrant Replacement",
"code": "Hydrant Replacement"
},
{
"name": "Irrigation",
"code": "Irrigation"
},
{
"name": "Manhole",
"code": "Manhole"
},
{
"name": "Thawrod",
"code": "Thawrod"
},
{
"name": "Valve",
"code": "Valve"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.SHAPE",
"type": "esriFieldTypeGeometry",
"alias": "SHAPE",
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.CREATED_USER",
"type": "esriFieldTypeString",
"alias": "CREATED_USER",
"length": 255,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.CREATED_DATE",
"type": "esriFieldTypeDate",
"alias": "CREATED_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.LAST_EDITED_USER",
"type": "esriFieldTypeString",
"alias": "LAST_EDITED_USER",
"length": 255,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.LAST_EDITED_DATE",
"type": "esriFieldTypeDate",
"alias": "LAST_EDITED_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.YC",
"type": "esriFieldTypeDouble",
"alias": "GIS.RoadwaysCutsDB_2_1.YC",
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.XC",
"type": "esriFieldTypeDouble",
"alias": "GIS.RoadwaysCutsDB_2_1.XC",
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.XC_1",
"type": "esriFieldTypeDouble",
"alias": "GIS.RoadwaysCutsDB_2_1.XC_1",
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.POINT_X",
"type": "esriFieldTypeDouble",
"alias": "GIS.RoadwaysCutsDB_2_1.POINT_X",
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.POINT_Y",
"type": "esriFieldTypeDouble",
"alias": "GIS.RoadwaysCutsDB_2_1.POINT_Y",
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.LOCATE_TYPE",
"type": "esriFieldTypeString",
"alias": "Locate Type",
"length": 50,
"domain": {
"type": "codedValue",
"name": "LRFormWorkDetails",
"description": "Locate Request Form Work Details",
"codedValues": [
{
"name": "Regular Ticket (up to 1000 sq meters)",
"code": "Regular Ticket (up to 1000 sq meters)"
},
{
"name": "Project (1000 sq meters to 60, 000 sq meters)",
"code": "Project (1000 sq meters to 60, 000 sq meters)"
},
{
"name": "Large Project (60,000 sq meters to 800,000 sq meters)",
"code": "Large Project (60,000 sq meters to 800,000 sq meters)"
},
{
"name": "Planning (Preparation only, no lines will be marked, not valid for digging purposes)",
"code": "Planning (Preparation only, no lines will be marked, not valid for digging purposes)"
},
{
"name": "Short Notice",
"code": "Short Notice"
},
{
"name": "Emergency Locate - call Infrastructure Delivery at 306-777-7558",
"code": "Emergency Locate - call Infrastructure Delivery at 306-777-7558"
},
{
"name": "Priority Locate \u2013 submit form and call Infrastructure Delivery at 306-777-7558",
"code": "Priority Locate \u2013 submit form and call Infrastructure Delivery at 306-777-7558"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.CUTSIDNUM",
"type": "esriFieldTypeDouble",
"alias": "GIS.RoadwaysCutsDB_2_1.CUTSIDNUM",
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.CAPITAL_WORK",
"type": "esriFieldTypeString",
"alias": "CAPITAL WORK",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Yes_No",
"description": "",
"codedValues": [
{
"name": "No",
"code": "N"
},
{
"name": "Yes",
"code": "Y"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.HIGH_VOLTAGE",
"type": "esriFieldTypeString",
"alias": "GIS.RoadwaysCutsDB_2_1.HIGH_VOLTAGE",
"length": 50,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.LR_EXPIRE_DATE",
"type": "esriFieldTypeDate",
"alias": "GIS.RoadwaysCutsDB_2_1.LR_EXPIRE_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.Cuts_Inspections.OBJECTID",
"type": "esriFieldTypeInteger",
"alias": "OBJECTID",
"domain": null
},
{
"name": "GIS.Cuts_Inspections.MADEBY",
"type": "esriFieldTypeString",
"alias": "MadeBy",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Made_By",
"description": "Who made the cut",
"codedValues": [
{
"name": "Access Communications",
"code": "Access Communications"
},
{
"name": "SaskEnergy",
"code": "SaskEnergy"
},
{
"name": "SaskPower",
"code": "SaskPower"
},
{
"name": "SaskTel",
"code": "SaskTel"
},
{
"name": "Boyd Excavating",
"code": "Boyd Excavating"
},
{
"name": "Cary's Trenching",
"code": "Cary's Trenching"
},
{
"name": "Ed's Backhoe",
"code": "Ed's Backhoe"
},
{
"name": "Erican Construction",
"code": "Erican Construction"
},
{
"name": "Hundseth",
"code": "Hundseth"
},
{
"name": "Jordan Excavating",
"code": "Jordan Excavating"
},
{
"name": "Traffic",
"code": "Traffic"
},
{
"name": "Unknown",
"code": "Unknown"
},
{
"name": "Ryko Telecommunications",
"code": "Ryko Telecommunications"
},
{
"name": "Ames Construction",
"code": "Ames Construction"
},
{
"name": "Brian Anderson Construction",
"code": "Brian Anderson Construction"
},
{
"name": "Carson Energy",
"code": "Carson Energy"
},
{
"name": "Earth Drilling",
"code": "Earth Drilling"
},
{
"name": "Graham Construction",
"code": "Graham Construction"
},
{
"name": "KMS Construction",
"code": "KMS Construction"
},
{
"name": "MD Construction",
"code": "MD Construction"
},
{
"name": "NIS Contractors",
"code": "NIS Contractors"
},
{
"name": "Northridge Developments",
"code": "Northridge Developments"
},
{
"name": "Nova Paving",
"code": "Nova Paving"
},
{
"name": "PCL Construction",
"code": "PCL Construction"
},
{
"name": "Remcon",
"code": "Remcon"
},
{
"name": "Site Management Services",
"code": "Site Management Services"
},
{
"name": "SNC Lavalin",
"code": "SNC Lavalin"
},
{
"name": "Tiefenbach",
"code": "Tiefenbach"
},
{
"name": "Wappel Construction",
"code": "Wappel Construction"
},
{
"name": "West 25th Concrete & Construction",
"code": "West 25th Concrete & Construction"
},
{
"name": "Westridge Construction",
"code": "Westridge Construction"
},
{
"name": "Zaryski Construction",
"code": "Zaryski Construction"
},
{
"name": "CBS Contracting/CanBobCat",
"code": "CBS Contracting/CanBobCat"
},
{
"name": "Zayo",
"code": "Zayo"
},
{
"name": "Water",
"code": "Water"
},
{
"name": "Sewer",
"code": "Sewer"
},
{
"name": "Water and Sewer",
"code": "Water and Sewer"
},
{
"name": "LSCMP",
"code": "LSCMP"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.Cuts_Inspections.DISTRICT",
"type": "esriFieldTypeSmallInteger",
"alias": "District",
"domain": null
},
{
"name": "GIS.Cuts_Inspections.MONTHCHECKED",
"type": "esriFieldTypeDate",
"alias": "MonthChecked",
"length": 8,
"domain": null
},
{
"name": "GIS.Cuts_Inspections.DATEOPENED",
"type": "esriFieldTypeDate",
"alias": "DateOpened",
"length": 8,
"domain": null
},
{
"name": "GIS.Cuts_Inspections.CUTTYPE",
"type": "esriFieldTypeString",
"alias": "CutType",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Type",
"description": "The type of cut",
"codedValues": [
{
"name": "Brick",
"code": "Brick"
},
{
"name": "Pavement",
"code": "Pavement"
},
{
"name": "Lawn",
"code": "Lawn"
},
{
"name": "Easement",
"code": "Easement"
},
{
"name": "Gravel",
"code": "Gravel"
},
{
"name": "Concrete",
"code": "Concrete"
},
{
"name": "Other",
"code": "Other"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.Cuts_Inspections.INTERNAL_EXTERNAL",
"type": "esriFieldTypeString",
"alias": "Internal_External",
"length": 50,
"domain": null
},
{
"name": "GIS.Cuts_Inspections.ADDRESS",
"type": "esriFieldTypeString",
"alias": "Address",
"length": 50,
"domain": null
},
{
"name": "GIS.Cuts_Inspections.WHERELOCATION",
"type": "esriFieldTypeString",
"alias": "Where",
"length": 50,
"domain": null
},
{
"name": "GIS.Cuts_Inspections.REPORTL",
"type": "esriFieldTypeString",
"alias": "ReportL",
"length": 50,
"domain": null
},
{
"name": "GIS.Cuts_Inspections.REPORTW",
"type": "esriFieldTypeString",
"alias": "ReportW",
"length": 50,
"domain": null
},
{
"name": "GIS.Cuts_Inspections.COMMENTS",
"type": "esriFieldTypeString",
"alias": "Comments",
"length": 50,
"domain": null
},
{
"name": "GIS.Cuts_Inspections.DATEINSECTION",
"type": "esriFieldTypeDate",
"alias": "DateInsection",
"length": 8,
"domain": null
},
{
"name": "GIS.Cuts_Inspections.C_F",
"type": "esriFieldTypeString",
"alias": "C/F",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Inspection",
"description": "",
"codedValues": [
{
"name": "Checked",
"code": "CHECKED"
},
{
"name": "Filled",
"code": "FILLED"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.Cuts_Inspections.UNITNO",
"type": "esriFieldTypeString",
"alias": "UnitNo",
"length": 50,
"domain": null
},
{
"name": "GIS.Cuts_Inspections.CREATED_USER",
"type": "esriFieldTypeString",
"alias": "CREATED_USER",
"length": 255,
"domain": null
},
{
"name": "GIS.Cuts_Inspections.CREATED_DATE",
"type": "esriFieldTypeDate",
"alias": "CREATED_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.Cuts_Inspections.LAST_EDITED_USER",
"type": "esriFieldTypeString",
"alias": "LAST_EDITED_USER",
"length": 255,
"domain": null
},
{
"name": "GIS.Cuts_Inspections.LAST_EDITED_DATE",
"type": "esriFieldTypeDate",
"alias": "LAST_EDITED_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.Cuts_Inspections.INS_ID",
"type": "esriFieldTypeInteger",
"alias": "Ins_ID",
"domain": null
},
{
"name": "GIS.Cuts_Inspections.TRUCKS_NO",
"type": "esriFieldTypeSmallInteger",
"alias": "TRUCKS_NO",
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.EXCAVATION_METHOD",
"type": "esriFieldTypeString",
"alias": "Excavation Method",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_ExcavationMethod",
"description": "Excavation Method values from Cuts to Locate Request",
"codedValues": [
{
"name": "Hydro Vacuum",
"code": "Hydro Vacuum"
},
{
"name": "Machine Digging",
"code": "Machine Digging"
},
{
"name": "None",
"code": "None"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.WORKING_ON",
"type": "esriFieldTypeString",
"alias": "Working On",
"length": 50,
"domain": {
"type": "codedValue",
"name": "LRFormWorkingOn",
"description": "LRFormWorkingOn",
"codedValues": [
{
"name": "Public Property Only",
"code": "Public Property Only"
},
{
"name": "Public and Private Property",
"code": "Public and Private Property"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.EXP_START_DATE",
"type": "esriFieldTypeDate",
"alias": "Expected Start Date",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.ACTIVELEAK_GUID",
"type": "esriFieldTypeGUID",
"alias": "ACTIVELEAK_GUID",
"length": 38,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.RP_INSP_GUID",
"type": "esriFieldTypeGUID",
"alias": "RP_INSP_GUID",
"length": 38,
"domain": null
}
],
"geometryField": {
"name": "GIS.RoadwaysCutsDB_2_1.SHAPE",
"type": "esriFieldTypeGeometry",
"alias": "SHAPE"
},
"indexes": [
{
"name": "R368798_SDE_ROWID_UK",
"fields": "GIS.RoadwaysCutsDB_2_1.OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "A4326_IX1",
"fields": "GIS.RoadwaysCutsDB_2_1.SHAPE",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "G85877INS_ID",
"fields": "GIS.Cuts_Inspections.INS_ID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "R368796_SDE_ROWID_UK",
"fields": "GIS.Cuts_Inspections.OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"subtypes": [],
"relationships": [
{
"id": 0,
"name": "Cuts_Inspections",
"relatedTableId": 2,
"role": "esriRelRoleOrigin",
"keyField": "OBJECTID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": false
}
],
"canModifyLayer": true,
"canScaleSymbols": false,
"hasLabels": false,
"capabilities": "Map,Query,Data",
"maxRecordCount": 1000,
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"isDataVersioned": false,
"ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true},
"useStandardizedQueries": true,
"supportedSpatialRelationships": [
"esriSpatialRelIntersects",
"esriSpatialRelContains",
"esriSpatialRelCrosses",
"esriSpatialRelEnvelopeIntersects",
"esriSpatialRelIndexIntersects",
"esriSpatialRelOverlaps",
"esriSpatialRelTouches",
"esriSpatialRelWithin",
"esriSpatialRelRelation"
],
"advancedQueryCapabilities": {
"useStandardizedQueries": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsPagination": true,
"supportsLod": false,
"supportsQueryWithLodSR": false,
"supportsTrueCurve": true,
"supportsQueryWithDatumTransformation": true,
"supportsReturningQueryExtent": true,
"supportsQueryWithDistance": true,
"supportsSqlExpression": true,
"supportsTimeRelation": true,
"supportsSqlFormat": false,
"supportsQueryAttachments": true,
"supportsQueryAttachmentsWithReturnUrl": true,
"supportsQueryAnalytic": true
},
"supportsDatumTransformation": 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
},
"supportsCoordinatesQuantization": true,
"supportsDynamicLegends": true
},
{
"currentVersion": 10.91,
"cimVersion": "2.9.0",
"id": 1,
"name": "Cuts Last Inspections",
"type": "Feature Layer",
"description": "",
"geometryType": "esriGeometryPoint",
"sourceSpatialReference": {
"wkid": 26913,
"latestWkid": 26913,
"xyTolerance": 0.001,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -5120900,
"falseY": -9998100,
"xyUnits": 10000,
"falseZ": 0,
"zUnits": 1,
"falseM": 0,
"mUnits": 1
},
"copyrightText": "",
"parentLayer": null,
"subLayers": [],
"minScale": 0,
"maxScale": 0,
"referenceScale": 0.0,
"drawingInfo": {
"renderer": {
"type": "uniqueValue",
"valueExpression": "var days = DateDiff(Now(), $feature['GIS.CUTS_INSPEC_V.DATEINSECTION'], \"days\");\nif (days < 14) {\n return \"Inspected within 2 weeks\";\n}else if ((days >= 14) && (days < 30)) {\n return \"Inspected within 3-4 weeks\";\n}else if (days >= 30) {\n return \"Inspected over 4 weeks\";\n}",
"valueExpressionTitle": "Custom",
"uniqueValueInfos": [
{
"symbol": {
"type": "esriPMS",
"url": "2ff6e6a1430cc8c52656d7f523a51630",
"imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABU0lEQVQ4jbXTP0jUYRgH8I9ycdgUhP8mKXEI7zg3c1GIQIJACoImhxDJwUAMrKWxczPykNLJQRqCC0JoSFFc1NQgaDJOGkWEoyAO7rxoubj7/X4cHYRfeJfn4fnwwPu+Mf+Z2PkAR7qseqyoR1lJhw2jMpoU/w1kZOwYd98FrZXaV7cteWLRmHHv6wPPLbhhwrUQmkBCq3feSBvx1FoUmJHU50FkuDZ3XPTCHJJR4Mwjt8QDA99xqXL+5qZedw3K2goCndoDw6sYwWUc1iAJTWKGCANlpQCQw2+cIh/aolC9jSpw6FsAeIgzdONKTf3EL7s+R4G3sibdk3IVxDEtmlfWnNiIAj99MmHZuiktgYWr2bfnpfnKbiEAtqUNKHptWL9BNFc6P2R88MyKvPXakfBLLPli1nUfdUtKaVNQtOlYwSaOw0vV+0wHcg7k6nQbABrOH+rnUxYDx5/vAAAAAElFTkSuQmCC",
"contentType": "image/png",
"width": 12,
"height": 12,
"angle": 0,
"xoffset": 0,
"yoffset": 0
},
"value": "Inspected within 2 weeks",
"label": "Inspected within 2 weeks"
},
{
"symbol": {
"type": "esriPMS",
"url": "b5bd0ff9ee0fbfde3139b7f8be7ce345",
"imageData": "iVBORw0KGgoAAAANSUhEUgAAAA8AAAAPCAYAAAA71pVKAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABYUlEQVQoka3TP0hCURyG4Zfwz1TXqwQiSUFTWy1NtrQYEY6CYAhOgg4hgm4STSIt4ayIIiKWaJYQhgkOTi0ROAgRNGSD3pCg5VaDZOq1FvvgwOGc88D3G46KGaL6V/z6ij6T4UQU2dJqEd/f6fZ63DgcHIgi0q84mWQzm+XS4cAgCMPjeUnClc2yG4+z43Zzq8C1Gqr7e069XgyTbXQ68HhYjMU4y+VYtduRx3CpRCgcZumvGZ1Olo+OCACRMWwysT5SlUoFolEIBsFq/WlgNLKhqK3RjM8fiUC9Pth/YwC1GrUCPz/zNIr9fpBlCATGq3c6P++GuFCgFgyyLwgsANhsgzUaSaKXz3OtwK0WBZ+P7VQKDzCHMrLXS6rd5lyBgY90msN+n7dEgj1RZO37otvlzuXiolzmGPichgFeikVCej1Vi4UVsxnh4YFes8kjUB2F0zDAB3DVaEy5mchMH+ML2nxqgLfkl0EAAAAASUVORK5CYII=",
"contentType": "image/png",
"width": 11,
"height": 11,
"angle": 0,
"xoffset": 0,
"yoffset": 0
},
"value": "Inspected within 3-4 weeks",
"label": "Inspected within 3-4 weeks"
},
{
"symbol": {
"type": "esriPMS",
"url": "8af4fcd03d9de17d86bb6356d4485c7d",
"imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABV0lEQVQ4jbXTT0jTYRzH8ZcxCTsFMstTlHiQNvRWXQwiCCGQgsCTh4jRDgliYF06tm6JjSg9dZAOgUEIHZooXbK/EHSaLDyOIUhBDLYmHrbGs98P8SB94Hv5PnzefL7P83wTDqnEfwH85NQKd2sMNqifZG2SfBe1AwF58htkJuhOtno/uLrIvQVuZXizL+AhTy+RHYpAU81KvuZljvH7FGKAWdIj3IyaQ13j2ByPkY4B/jI1xtHQsIXjrfqny5y9zugy7zsA/ZwIzSsYRy+KASRFV4KLooAG9RBQwi62sRNJUQ1eow0oshkCbjfHMoDTQb/Cn498iwFesXyHG8OcoXkZM+J6RqHCWgzwm09ZXqwy3dOZuK0vfJ7nSStcJwA+kLtA7TlXzjGKI62jX3nePmBph9XQE/2J9e88Os+7AdLD9FWprVOuso5yNNV+y/S11KwDdeht3AMX7lMW0vXayAAAAABJRU5ErkJggg==",
"contentType": "image/png",
"width": 12,
"height": 12,
"angle": 0,
"xoffset": 0,
"yoffset": 0
},
"value": "Inspected over 4 weeks",
"label": "Inspected over 4 weeks"
}
],
"fieldDelimiter": ",",
"authoringInfo": {
"colorRamp": {
"type": "multipart",
"colorRamps": [
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
240,
204,
252,
255
],
"toColor": [
240,
204,
252,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
194,
252,
179,
255
],
"toColor": [
194,
252,
179,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
184,
249,
252,
255
],
"toColor": [
184,
249,
252,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
252,
227,
194,
255
],
"toColor": [
252,
227,
194,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
252,
182,
189,
255
],
"toColor": [
252,
182,
189,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
249,
252,
182,
255
],
"toColor": [
249,
252,
182,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
210,
225,
252,
255
],
"toColor": [
210,
225,
252,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
182,
191,
252,
255
],
"toColor": [
182,
191,
252,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
212,
252,
215,
255
],
"toColor": [
212,
252,
215,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
252,
179,
250,
255
],
"toColor": [
252,
179,
250,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
214,
182,
252,
255
],
"toColor": [
214,
182,
252,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
252,
212,
212,
255
],
"toColor": [
252,
212,
212,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
252,
182,
223,
255
],
"toColor": [
252,
182,
223,
255
]
}
]
}
}
},
"scaleSymbols": true,
"transparency": 0,
"labelingInfo": null
},
"defaultVisibility": true,
"extent": {
"xmin": 509720.0187,
"ymin": 5554738.6682,
"xmax": 574380.3604,
"ymax": 5598459.6735,
"spatialReference": {
"wkid": 26913,
"latestWkid": 26913,
"xyTolerance": 0.001,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -5120900,
"falseY": -9998100,
"xyUnits": 10000,
"falseZ": -100000,
"zUnits": 10000,
"falseM": -100000,
"mUnits": 10000
}
},
"hasAttachments": true,
"attachmentProperties": [
{
"name": "id",
"fieldName": "ATTACHMENTID",
"isEnabled": true
},
{
"name": "globalid",
"fieldName": "GLOBALID",
"isEnabled": true
},
{
"name": "keywords",
"fieldName": "KEYWORDS",
"isEnabled": false
},
{
"name": "name",
"fieldName": "ATT_NAME",
"isEnabled": true
},
{
"name": "contentType",
"fieldName": "CONTENT_TYPE",
"isEnabled": true
},
{
"name": "size",
"fieldName": "DATA_SIZE",
"isEnabled": true
},
{
"name": "exifInfo",
"fieldName": "EXIFINFO",
"isEnabled": false
}
],
"attachmentFields": [
{
"name": "ATTACHMENTID",
"type": "esriFieldTypeOID",
"alias": "ATTACHMENTID",
"editable": false,
"nullable": false,
"length": 4,
"domain": null
},
{
"name": "GLOBALID",
"type": "esriFieldTypeGlobalID",
"alias": "GLOBALID",
"editable": false,
"nullable": false,
"length": 38,
"domain": null
},
{
"name": "ATT_NAME",
"type": "esriFieldTypeString",
"alias": "ATT_NAME",
"editable": true,
"nullable": false,
"length": 250,
"domain": null
},
{
"name": "CONTENT_TYPE",
"type": "esriFieldTypeString",
"alias": "CONTENT_TYPE",
"editable": true,
"nullable": false,
"length": 150,
"domain": null
},
{
"name": "DATA_SIZE",
"type": "esriFieldTypeInteger",
"alias": "DATA_SIZE",
"editable": true,
"nullable": false,
"length": 4,
"domain": null
}
],
"htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
"displayField": "GIS.RoadwaysCutsDB_2_1.DISPATCH_ID_SR_NO",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "GIS.RoadwaysCutsDB_2_1.OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.DISPATCH_ID_SR_NO",
"type": "esriFieldTypeString",
"alias": "DISPATCH_ID_SR_No.",
"length": 50,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.STATUS",
"type": "esriFieldTypeString",
"alias": "STATUS",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Status",
"description": "What is the status of a cut",
"codedValues": [
{
"name": "Open",
"code": "Open"
},
{
"name": "Hold",
"code": "Hold"
},
{
"name": "Closed",
"code": "Closed"
},
{
"name": "Buyout Closed",
"code": "Buyout Closed"
},
{
"name": "Capital Closed",
"code": "Capital Closed"
},
{
"name": "Contractor Open",
"code": "Contractor Open"
},
{
"name": "Contractor Closed",
"code": "Contractor Closed"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.PROGRAM",
"type": "esriFieldTypeString",
"alias": "PROGRAM",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Program",
"description": "",
"codedValues": [
{
"name": "Cuts",
"code": "Cuts"
},
{
"name": "Maintenance",
"code": "Maintenance"
},
{
"name": "WFPP",
"code": "WFPP"
},
{
"name": "Accessibility",
"code": "Accessibility"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.LOCATION",
"type": "esriFieldTypeString",
"alias": "LOCATION",
"length": 255,
"domain": {
"type": "codedValue",
"name": "RCUTS_Location",
"description": "Location of the cut",
"codedValues": [
{
"name": "In The Alley",
"code": "In The Alley"
},
{
"name": "In Front Of",
"code": "In Front Of"
},
{
"name": "Adjacent To",
"code": "Adjacent To"
},
{
"name": "Across From",
"code": "Across From"
},
{
"name": "In The Boulevard",
"code": "In The Boulevard"
},
{
"name": "NW Corner",
"code": "NW Corner"
},
{
"name": "NE Corner",
"code": "NE Corner"
},
{
"name": "SW Corner",
"code": "SW Corner"
},
{
"name": "SE Corner",
"code": "SE Corner"
},
{
"name": "Easements",
"code": "Easements"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.OPENED_DATE",
"type": "esriFieldTypeDate",
"alias": "OPENED_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.CLOSED_DATE",
"type": "esriFieldTypeDate",
"alias": "CLOSED_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.CUT_TYPE_OR_REPAIR_TYPE",
"type": "esriFieldTypeString",
"alias": "CUT_TYPE_OR REPAIR_TYPE",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Type",
"description": "The type of cut",
"codedValues": [
{
"name": "Brick",
"code": "Brick"
},
{
"name": "Pavement",
"code": "Pavement"
},
{
"name": "Lawn",
"code": "Lawn"
},
{
"name": "Easement",
"code": "Easement"
},
{
"name": "Gravel",
"code": "Gravel"
},
{
"name": "Concrete",
"code": "Concrete"
},
{
"name": "Other",
"code": "Other"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.MADE_BY",
"type": "esriFieldTypeString",
"alias": "MADE_BY",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Made_By",
"description": "Who made the cut",
"codedValues": [
{
"name": "Access Communications",
"code": "Access Communications"
},
{
"name": "SaskEnergy",
"code": "SaskEnergy"
},
{
"name": "SaskPower",
"code": "SaskPower"
},
{
"name": "SaskTel",
"code": "SaskTel"
},
{
"name": "Boyd Excavating",
"code": "Boyd Excavating"
},
{
"name": "Cary's Trenching",
"code": "Cary's Trenching"
},
{
"name": "Ed's Backhoe",
"code": "Ed's Backhoe"
},
{
"name": "Erican Construction",
"code": "Erican Construction"
},
{
"name": "Hundseth",
"code": "Hundseth"
},
{
"name": "Jordan Excavating",
"code": "Jordan Excavating"
},
{
"name": "Traffic",
"code": "Traffic"
},
{
"name": "Unknown",
"code": "Unknown"
},
{
"name": "Ryko Telecommunications",
"code": "Ryko Telecommunications"
},
{
"name": "Ames Construction",
"code": "Ames Construction"
},
{
"name": "Brian Anderson Construction",
"code": "Brian Anderson Construction"
},
{
"name": "Carson Energy",
"code": "Carson Energy"
},
{
"name": "Earth Drilling",
"code": "Earth Drilling"
},
{
"name": "Graham Construction",
"code": "Graham Construction"
},
{
"name": "KMS Construction",
"code": "KMS Construction"
},
{
"name": "MD Construction",
"code": "MD Construction"
},
{
"name": "NIS Contractors",
"code": "NIS Contractors"
},
{
"name": "Northridge Developments",
"code": "Northridge Developments"
},
{
"name": "Nova Paving",
"code": "Nova Paving"
},
{
"name": "PCL Construction",
"code": "PCL Construction"
},
{
"name": "Remcon",
"code": "Remcon"
},
{
"name": "Site Management Services",
"code": "Site Management Services"
},
{
"name": "SNC Lavalin",
"code": "SNC Lavalin"
},
{
"name": "Tiefenbach",
"code": "Tiefenbach"
},
{
"name": "Wappel Construction",
"code": "Wappel Construction"
},
{
"name": "West 25th Concrete & Construction",
"code": "West 25th Concrete & Construction"
},
{
"name": "Westridge Construction",
"code": "Westridge Construction"
},
{
"name": "Zaryski Construction",
"code": "Zaryski Construction"
},
{
"name": "CBS Contracting/CanBobCat",
"code": "CBS Contracting/CanBobCat"
},
{
"name": "Zayo",
"code": "Zayo"
},
{
"name": "Water",
"code": "Water"
},
{
"name": "Sewer",
"code": "Sewer"
},
{
"name": "Water and Sewer",
"code": "Water and Sewer"
},
{
"name": "LSCMP",
"code": "LSCMP"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.UNREPORTED",
"type": "esriFieldTypeString",
"alias": "UNREPORTED",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Yes_No",
"description": "",
"codedValues": [
{
"name": "No",
"code": "N"
},
{
"name": "Yes",
"code": "Y"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.ORIGINATING_WO",
"type": "esriFieldTypeString",
"alias": "ORIGINATING_WO",
"length": 50,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.ORIGINATING_TASK",
"type": "esriFieldTypeString",
"alias": "ORIGINATING_TASK",
"length": 50,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.REPORTED_SIZE_IN_SQ_M",
"type": "esriFieldTypeDouble",
"alias": "REPORTED_SIZE_in_SQ_M",
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.ITEMS_IN_WORK_AREA",
"type": "esriFieldTypeString",
"alias": "ITEMS_IN_WORK_AREA",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Items",
"description": "A list of the types of cuts items",
"codedValues": [
{
"name": "Catch Basin",
"code": "Catch Basin"
},
{
"name": "Cleanout",
"code": "Cleanout"
},
{
"name": "Coldmix",
"code": "Coldmix"
},
{
"name": "Curb Box",
"code": "Curb Box"
},
{
"name": "Curb Box and Cleanout",
"code": "Curb Box and Cleanout"
},
{
"name": "Hydrant Replacement",
"code": "Hydrant Replacement"
},
{
"name": "Irrigation",
"code": "Irrigation"
},
{
"name": "Manhole",
"code": "Manhole"
},
{
"name": "Thawrod",
"code": "Thawrod"
},
{
"name": "Valve",
"code": "Valve"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.ITEMS_IN_WORK_AREA_2",
"type": "esriFieldTypeString",
"alias": "ITEMS_IN_WORK_AREA_2",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Items",
"description": "A list of the types of cuts items",
"codedValues": [
{
"name": "Catch Basin",
"code": "Catch Basin"
},
{
"name": "Cleanout",
"code": "Cleanout"
},
{
"name": "Coldmix",
"code": "Coldmix"
},
{
"name": "Curb Box",
"code": "Curb Box"
},
{
"name": "Curb Box and Cleanout",
"code": "Curb Box and Cleanout"
},
{
"name": "Hydrant Replacement",
"code": "Hydrant Replacement"
},
{
"name": "Irrigation",
"code": "Irrigation"
},
{
"name": "Manhole",
"code": "Manhole"
},
{
"name": "Thawrod",
"code": "Thawrod"
},
{
"name": "Valve",
"code": "Valve"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.REPAIR_METHOD",
"type": "esriFieldTypeString",
"alias": "REPAIR_METHOD",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Method",
"description": "What type of method use for fixing the repair.",
"codedValues": [
{
"name": "Concrete Replacement",
"code": "Concrete Replacement"
},
{
"name": "Concrete Patching",
"code": "Concrete Patching"
},
{
"name": "Bricks",
"code": "Bricks"
},
{
"name": "Asphalt Capping",
"code": "Asphalt Capping"
},
{
"name": "Mudjacking",
"code": "Mudjacking"
},
{
"name": "Gutter Patch",
"code": "Gutter Patch"
},
{
"name": "Grinding",
"code": "Grinding"
},
{
"name": "CS Soil and Seed",
"code": "CS Soil and Seed"
},
{
"name": "CS Landscape Extras",
"code": "CS Landscape Extras"
},
{
"name": "Manhole Repair",
"code": "Manhole Repair"
},
{
"name": "Asphalt Crew",
"code": "Asphalt Crew"
},
{
"name": "Portapatcher Crew",
"code": "Portapatcher Crew"
},
{
"name": "MG-Krete Resurfacing",
"code": "MG-Krete Resurfacing"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.REPAIR_SIZE",
"type": "esriFieldTypeDouble",
"alias": "REPAIR_SIZE",
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.COMMENTS",
"type": "esriFieldTypeString",
"alias": "COMMENTS",
"length": 255,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.VEHICLE_CROSSING",
"type": "esriFieldTypeString",
"alias": "VEHICLE_CROSSING",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Yes_No",
"description": "",
"codedValues": [
{
"name": "No",
"code": "N"
},
{
"name": "Yes",
"code": "Y"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.REPAIR_AREA_MARKED",
"type": "esriFieldTypeString",
"alias": "REPAIR_AREA_MARKED",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Yes_No",
"description": "",
"codedValues": [
{
"name": "No",
"code": "N"
},
{
"name": "Yes",
"code": "Y"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.LOCATED_DATE",
"type": "esriFieldTypeDate",
"alias": "LOCATED_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.SAWCUT_DATE",
"type": "esriFieldTypeDate",
"alias": "SAWCUT_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.MJ_B_REPLACE_NEEDED",
"type": "esriFieldTypeString",
"alias": "MJ_B_REPLACE_NEEDED",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Yes_No",
"description": "",
"codedValues": [
{
"name": "No",
"code": "N"
},
{
"name": "Yes",
"code": "Y"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.MUDJACKED_DATE",
"type": "esriFieldTypeDate",
"alias": "MUDJACKED_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.REPLACE_AFTER_MJ",
"type": "esriFieldTypeString",
"alias": "REPLACE_AFTER_MJ",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Yes_No",
"description": "",
"codedValues": [
{
"name": "No",
"code": "N"
},
{
"name": "Yes",
"code": "Y"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.EXCAVATED_DATE",
"type": "esriFieldTypeDate",
"alias": "EXCAVATED_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.BASE_PREP_NEEDED",
"type": "esriFieldTypeString",
"alias": "BASE_PREP_NEEDED",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Yes_No",
"description": "",
"codedValues": [
{
"name": "No",
"code": "N"
},
{
"name": "Yes",
"code": "Y"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.BASE_PREP_DATE",
"type": "esriFieldTypeDate",
"alias": "BASE_PREP_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.CBMH_REPAIR_NEEDED",
"type": "esriFieldTypeString",
"alias": "CBMH_REPAIR_NEEDED",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Yes_No",
"description": "",
"codedValues": [
{
"name": "No",
"code": "N"
},
{
"name": "Yes",
"code": "Y"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.CBMH_REPAIR_DATE",
"type": "esriFieldTypeDate",
"alias": "CBMH_REPAIR_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.TREE_ROOT_TRIMMING",
"type": "esriFieldTypeString",
"alias": "TREE_ROOT_TRIMMING",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Yes_No",
"description": "",
"codedValues": [
{
"name": "No",
"code": "N"
},
{
"name": "Yes",
"code": "Y"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.TREE_ROOT_TRIMMING_DATE",
"type": "esriFieldTypeDate",
"alias": "TREE_ROOT_TRIMMING_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.FORMED_DATE",
"type": "esriFieldTypeDate",
"alias": "FORMED_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.POURED_DATE",
"type": "esriFieldTypeDate",
"alias": "POURED_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.STRIPPED_DATE",
"type": "esriFieldTypeDate",
"alias": "STRIPPED_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.GUTTER_PATCH",
"type": "esriFieldTypeString",
"alias": "GUTTER_PATCH",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Yes_No",
"description": "",
"codedValues": [
{
"name": "No",
"code": "N"
},
{
"name": "Yes",
"code": "Y"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.GUTTER_PATCH_DATE",
"type": "esriFieldTypeDate",
"alias": "GUTTER_PATCH_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.BRICK_REPAIR",
"type": "esriFieldTypeString",
"alias": "BRICK_REPAIR",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Yes_No",
"description": "",
"codedValues": [
{
"name": "No",
"code": "N"
},
{
"name": "Yes",
"code": "Y"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.BRICK_REPAIR_DATE",
"type": "esriFieldTypeDate",
"alias": "BRICK_REPAIR_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.SOIL_SEED",
"type": "esriFieldTypeString",
"alias": "SOIL_SEED",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Yes_No",
"description": "",
"codedValues": [
{
"name": "No",
"code": "N"
},
{
"name": "Yes",
"code": "Y"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.SOIL_SEED_DATE",
"type": "esriFieldTypeDate",
"alias": "SOIL_SEED_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.LANDSCAPE_EXTRAS",
"type": "esriFieldTypeString",
"alias": "LANDSCAPE_EXTRAS",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Yes_No",
"description": "",
"codedValues": [
{
"name": "No",
"code": "N"
},
{
"name": "Yes",
"code": "Y"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.LANDSCAPE_EXTRAS_DATE",
"type": "esriFieldTypeDate",
"alias": "LANDSCAPE_EXTRAS_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.LANDSCAPE_TRADES",
"type": "esriFieldTypeString",
"alias": "LANDSCAPE_TRADES",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Yes_No",
"description": "",
"codedValues": [
{
"name": "No",
"code": "N"
},
{
"name": "Yes",
"code": "Y"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.LANDSCAPE_TRADES_DATE",
"type": "esriFieldTypeDate",
"alias": "LANDSCAPE_TRADES_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.OILING_DATE",
"type": "esriFieldTypeDate",
"alias": "OILING_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.ASPHALT_CAPPING_DATE",
"type": "esriFieldTypeDate",
"alias": "ASPHALT_CAPPING_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.SURVEYING_NEEDED",
"type": "esriFieldTypeString",
"alias": "SURVEYING_NEEDED",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Yes_No",
"description": "",
"codedValues": [
{
"name": "No",
"code": "N"
},
{
"name": "Yes",
"code": "Y"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.SURVEYED_DATE",
"type": "esriFieldTypeDate",
"alias": "SURVEYED_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.MG_KRETE_RESURFACING_DATE",
"type": "esriFieldTypeDate",
"alias": "MG_KRETE_RESURFACING_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.GLOBALID",
"type": "esriFieldTypeGlobalID",
"alias": "GLOBALID",
"length": 38,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.SHAPE",
"type": "esriFieldTypeGeometry",
"alias": "SHAPE",
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.LOCATION_1",
"type": "esriFieldTypeString",
"alias": "LOCATION",
"length": 255,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.REPAIR_CREW",
"type": "esriFieldTypeString",
"alias": "REPAIR_CREW",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_REP_CREW",
"description": "REPAIR CREW",
"codedValues": [
{
"name": "Sawcutting - Crew 1",
"code": "Sawcutting Crew 1"
},
{
"name": "Sawcutting - Crew 2",
"code": "Sawcutting Crew 2"
},
{
"name": "Sawcutting - Crew 3 (Spare)",
"code": "Sawcutting Crew 3 (Spare)"
},
{
"name": "Mudjacking - Crew 1",
"code": "Mudjacking Crew 1"
},
{
"name": "Mudjacking - Crew 2 (Contractor)",
"code": "Mudjacking Crew 2 (Contractor)"
},
{
"name": "Excavation - Crew 1",
"code": "Excavation Crew 1"
},
{
"name": "Excavation - Crew 2",
"code": "Excavation Crew 2"
},
{
"name": "Excavation - Crew 3 (Spare)",
"code": "Excavation Crew 3 (Spare)"
},
{
"name": "Concrete Replacement - Crew 1",
"code": "Concrete Replacement Crew 1"
},
{
"name": "Concrete Replacement - Crew 2",
"code": "Concrete Replacement Crew 2"
},
{
"name": "Concrete Replacement - Crew 3",
"code": "Concrete Replacement Crew 3"
},
{
"name": "Concrete Replacement - Crew 4",
"code": "Concrete Replacement Crew 4"
},
{
"name": "Concrete Replacement - Crew 5",
"code": "Concrete Replacement Crew 5"
},
{
"name": "Concrete Replacement - Crew 6",
"code": "Concrete Replacement Crew 6"
},
{
"name": "Concrete Replacement - Crew 7",
"code": "Concrete Replacement Crew 7"
},
{
"name": "Concrete Replacement - Crew 8",
"code": "Concrete Replacement Crew 8"
},
{
"name": "Concrete Replacement - Crew 9",
"code": "Concrete Replacement Crew 9"
},
{
"name": "Concrete Replacement - Crew 10 (Contractor)",
"code": "Concrete Replacement Crew 10 (Contractor)"
},
{
"name": "Sidewalk Asphalt Capping Crew",
"code": "Sidewalk Asphalt Capping Crew"
},
{
"name": "Sidewalk Resurfacing Crew",
"code": "Sidewalk Resurfacing Crew"
},
{
"name": "Gutter Patching - Crew 1",
"code": "Gutter Patching Crew 1"
},
{
"name": "Gutter Patching - Crew 2 (Contractor)",
"code": "Gutter Patching Crew 2 (Contractor)"
},
{
"name": "Paving Stones Crew",
"code": "Paving Stones Crew"
},
{
"name": "Concrete Patching Crew",
"code": "Concrete Patching Crew"
},
{
"name": "Grinding/Cutting - Crew 1",
"code": "Grinding/Cutting Crew 1"
},
{
"name": "Grinding/Cutting - Crew 2 (Contractor)",
"code": "Grinding/Cutting Crew 2 (Contractor)"
},
{
"name": "Landscaping - Crew 1",
"code": "Landscaping Crew 1"
},
{
"name": "Landscaping - Crew 2 (Spare)",
"code": "Landscaping Crew 2 (Spare)"
},
{
"name": "Landscaping (Base Prep) - Crew 3",
"code": "Landscaping (Base Prep) Crew 3"
},
{
"name": "Catchbasin/Manhole Crew",
"code": "Catchbasin/Manhole Crew"
},
{
"name": "Cuts & Patching - NW Crew",
"code": "Cuts & Patching NW Crew"
},
{
"name": "Cuts & Patching - South Crew",
"code": "Cuts & Patching South Crew"
},
{
"name": "Cuts & Patching - NE Crew",
"code": "Cuts & Patching - NE Crew"
},
{
"name": "Thinlift Spreader Crew",
"code": "Thinlift Spreader Crew"
},
{
"name": "Portapatch - NW Crew",
"code": "Portapatch NW Crew"
},
{
"name": "Portpatch - NE Crew",
"code": "Portpatch NE Crew"
},
{
"name": "Portapatch - SW Crew",
"code": "Portapatch SW Crew"
},
{
"name": "Portapatch - SE Crew",
"code": "Portapatch SE Crew"
},
{
"name": "Portapatch - Spare",
"code": "Portapatch Spare"
},
{
"name": "Bobcat Planer Crew",
"code": "Bobcat Planer Crew"
},
{
"name": "Capital Crew",
"code": "Capital Crew"
},
{
"name": "Inspector",
"code": "Inspector"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.LOCATION_12",
"type": "esriFieldTypeString",
"alias": "LOCATION_12",
"length": 50,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.REPAIR_WO_NO_1",
"type": "esriFieldTypeString",
"alias": "REPAIR_WO_NO_1",
"length": 50,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.READY_FOR_FORMING",
"type": "esriFieldTypeString",
"alias": "Ready for Forming",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Ready for Forming",
"description": "Y or N",
"codedValues": [
{
"name": "No",
"code": "N"
},
{
"name": "Yes",
"code": "Y"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.DATE_LOCATES_SUBMITTED",
"type": "esriFieldTypeDate",
"alias": "DATE_LOCATES_SUBMITTED",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.CONCRETE_PATCH_DATE",
"type": "esriFieldTypeDate",
"alias": "CONCRETE_PATCH_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.GRINDING_DATE",
"type": "esriFieldTypeDate",
"alias": "GRINDING_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.TARP_INSTALLED",
"type": "esriFieldTypeString",
"alias": "TARP_INSTALLED",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Yes_No",
"description": "",
"codedValues": [
{
"name": "No",
"code": "N"
},
{
"name": "Yes",
"code": "Y"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.MAINTENANCE_ADDITION_SIZE__M2",
"type": "esriFieldTypeDouble",
"alias": "MAINTENANCE_ADDITION_SIZE__M2",
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.FORESTRY_SECTOR",
"type": "esriFieldTypeSmallInteger",
"alias": "FORESTRY_SECTOR",
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.WEEK_OF",
"type": "esriFieldTypeDate",
"alias": "WEEK_OF",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.DISTRICT",
"type": "esriFieldTypeString",
"alias": "DISTRICT",
"length": 50,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.SERVICE_REQUEST",
"type": "esriFieldTypeString",
"alias": "Service Request",
"length": 7,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.CUT_RPT_SUBMIT_DATE",
"type": "esriFieldTypeDate",
"alias": "CUT_RPT_SUBMIT_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.CREATEDATE",
"type": "esriFieldTypeDate",
"alias": "CREATEDATE",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.CREATED_USER",
"type": "esriFieldTypeString",
"alias": "CREATED_USER",
"length": 255,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.CREATED_DATE",
"type": "esriFieldTypeDate",
"alias": "CREATED_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.LAST_EDITED_USER",
"type": "esriFieldTypeString",
"alias": "LAST_EDITED_USER",
"length": 255,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.LAST_EDITED_DATE",
"type": "esriFieldTypeDate",
"alias": "LAST_EDITED_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.YC",
"type": "esriFieldTypeDouble",
"alias": "YC",
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.XC",
"type": "esriFieldTypeDouble",
"alias": "XC",
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.XC_1",
"type": "esriFieldTypeDouble",
"alias": "XC_1",
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.POINT_X",
"type": "esriFieldTypeDouble",
"alias": "POINT_X",
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.POINT_Y",
"type": "esriFieldTypeDouble",
"alias": "POINT_Y",
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.LOCATE_TYPE",
"type": "esriFieldTypeString",
"alias": "Locate Type",
"length": 50,
"domain": {
"type": "codedValue",
"name": "LRFormWorkDetails",
"description": "Locate Request Form Work Details",
"codedValues": [
{
"name": "Regular Ticket (up to 1000 sq meters)",
"code": "Regular Ticket (up to 1000 sq meters)"
},
{
"name": "Project (1000 sq meters to 60, 000 sq meters)",
"code": "Project (1000 sq meters to 60, 000 sq meters)"
},
{
"name": "Large Project (60,000 sq meters to 800,000 sq meters)",
"code": "Large Project (60,000 sq meters to 800,000 sq meters)"
},
{
"name": "Planning (Preparation only, no lines will be marked, not valid for digging purposes)",
"code": "Planning (Preparation only, no lines will be marked, not valid for digging purposes)"
},
{
"name": "Short Notice",
"code": "Short Notice"
},
{
"name": "Emergency Locate - call Infrastructure Delivery at 306-777-7558",
"code": "Emergency Locate - call Infrastructure Delivery at 306-777-7558"
},
{
"name": "Priority Locate \u2013 submit form and call Infrastructure Delivery at 306-777-7558",
"code": "Priority Locate \u2013 submit form and call Infrastructure Delivery at 306-777-7558"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.CUTSIDNUM",
"type": "esriFieldTypeDouble",
"alias": "CUTSIDNUM",
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.CAPITAL_WORK",
"type": "esriFieldTypeString",
"alias": "CAPITAL WORK",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Yes_No",
"description": "",
"codedValues": [
{
"name": "No",
"code": "N"
},
{
"name": "Yes",
"code": "Y"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.HIGH_VOLTAGE",
"type": "esriFieldTypeString",
"alias": "GIS.RoadwaysCutsDB_2_1.HIGH_VOLTAGE",
"length": 50,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.LR_EXPIRE_DATE",
"type": "esriFieldTypeDate",
"alias": "GIS.RoadwaysCutsDB_2_1.LR_EXPIRE_DATE",
"length": 8,
"domain": null
},
{
"name": "GIS.CUTS_INSPEC_V.INS_ID",
"type": "esriFieldTypeInteger",
"alias": "INS_ID",
"domain": null
},
{
"name": "GIS.CUTS_INSPEC_V.DATEINSECTION",
"type": "esriFieldTypeDate",
"alias": "DATEINSECTION",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.EXCAVATION_METHOD",
"type": "esriFieldTypeString",
"alias": "Excavation Method",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_ExcavationMethod",
"description": "Excavation Method values from Cuts to Locate Request",
"codedValues": [
{
"name": "Hydro Vacuum",
"code": "Hydro Vacuum"
},
{
"name": "Machine Digging",
"code": "Machine Digging"
},
{
"name": "None",
"code": "None"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.WORKING_ON",
"type": "esriFieldTypeString",
"alias": "Working On",
"length": 50,
"domain": {
"type": "codedValue",
"name": "LRFormWorkingOn",
"description": "LRFormWorkingOn",
"codedValues": [
{
"name": "Public Property Only",
"code": "Public Property Only"
},
{
"name": "Public and Private Property",
"code": "Public and Private Property"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GIS.RoadwaysCutsDB_2_1.EXP_START_DATE",
"type": "esriFieldTypeDate",
"alias": "Expected Start Date",
"length": 8,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.ACTIVELEAK_GUID",
"type": "esriFieldTypeGUID",
"alias": "ACTIVELEAK_GUID",
"length": 38,
"domain": null
},
{
"name": "GIS.RoadwaysCutsDB_2_1.RP_INSP_GUID",
"type": "esriFieldTypeGUID",
"alias": "RP_INSP_GUID",
"length": 38,
"domain": null
}
],
"geometryField": {
"name": "GIS.RoadwaysCutsDB_2_1.SHAPE",
"type": "esriFieldTypeGeometry",
"alias": "SHAPE"
},
"indexes": [
{
"name": "R368798_SDE_ROWID_UK",
"fields": "GIS.RoadwaysCutsDB_2_1.OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "UUID_368798",
"fields": "GIS.RoadwaysCutsDB_2_1.GLOBALID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "A4326_IX1",
"fields": "GIS.RoadwaysCutsDB_2_1.SHAPE",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"subtypes": [],
"relationships": [
{
"id": 1,
"name": "Cuts_Inspections",
"relatedTableId": 2,
"role": "esriRelRoleOrigin",
"keyField": "OBJECTID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": false
}
],
"canModifyLayer": true,
"canScaleSymbols": false,
"hasLabels": false,
"capabilities": "Map,Query,Data",
"maxRecordCount": 1000,
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"isDataVersioned": false,
"ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true},
"useStandardizedQueries": true,
"supportedSpatialRelationships": [
"esriSpatialRelIntersects",
"esriSpatialRelContains",
"esriSpatialRelCrosses",
"esriSpatialRelEnvelopeIntersects",
"esriSpatialRelIndexIntersects",
"esriSpatialRelOverlaps",
"esriSpatialRelTouches",
"esriSpatialRelWithin",
"esriSpatialRelRelation"
],
"advancedQueryCapabilities": {
"useStandardizedQueries": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsPagination": true,
"supportsLod": false,
"supportsQueryWithLodSR": false,
"supportsTrueCurve": true,
"supportsQueryWithDatumTransformation": true,
"supportsReturningQueryExtent": true,
"supportsQueryWithDistance": true,
"supportsSqlExpression": true,
"supportsTimeRelation": true,
"supportsSqlFormat": false,
"supportsQueryAttachments": true,
"supportsQueryAttachmentsWithReturnUrl": true,
"supportsQueryAnalytic": true
},
"supportsDatumTransformation": 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
},
"supportsCoordinatesQuantization": true,
"supportsDynamicLegends": true
}
],
"tables": [
{
"currentVersion": 10.91,
"cimVersion": "2.9.0",
"id": 2,
"name": "Cuts_Inspections",
"type": "Table",
"description": null,
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"displayField": "MADEBY",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
},
{
"name": "MADEBY",
"type": "esriFieldTypeString",
"alias": "MadeBy",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Made_By",
"description": "Who made the cut",
"codedValues": [
{
"name": "Access Communications",
"code": "Access Communications"
},
{
"name": "SaskEnergy",
"code": "SaskEnergy"
},
{
"name": "SaskPower",
"code": "SaskPower"
},
{
"name": "SaskTel",
"code": "SaskTel"
},
{
"name": "Boyd Excavating",
"code": "Boyd Excavating"
},
{
"name": "Cary's Trenching",
"code": "Cary's Trenching"
},
{
"name": "Ed's Backhoe",
"code": "Ed's Backhoe"
},
{
"name": "Erican Construction",
"code": "Erican Construction"
},
{
"name": "Hundseth",
"code": "Hundseth"
},
{
"name": "Jordan Excavating",
"code": "Jordan Excavating"
},
{
"name": "Traffic",
"code": "Traffic"
},
{
"name": "Unknown",
"code": "Unknown"
},
{
"name": "Ryko Telecommunications",
"code": "Ryko Telecommunications"
},
{
"name": "Ames Construction",
"code": "Ames Construction"
},
{
"name": "Brian Anderson Construction",
"code": "Brian Anderson Construction"
},
{
"name": "Carson Energy",
"code": "Carson Energy"
},
{
"name": "Earth Drilling",
"code": "Earth Drilling"
},
{
"name": "Graham Construction",
"code": "Graham Construction"
},
{
"name": "KMS Construction",
"code": "KMS Construction"
},
{
"name": "MD Construction",
"code": "MD Construction"
},
{
"name": "NIS Contractors",
"code": "NIS Contractors"
},
{
"name": "Northridge Developments",
"code": "Northridge Developments"
},
{
"name": "Nova Paving",
"code": "Nova Paving"
},
{
"name": "PCL Construction",
"code": "PCL Construction"
},
{
"name": "Remcon",
"code": "Remcon"
},
{
"name": "Site Management Services",
"code": "Site Management Services"
},
{
"name": "SNC Lavalin",
"code": "SNC Lavalin"
},
{
"name": "Tiefenbach",
"code": "Tiefenbach"
},
{
"name": "Wappel Construction",
"code": "Wappel Construction"
},
{
"name": "West 25th Concrete & Construction",
"code": "West 25th Concrete & Construction"
},
{
"name": "Westridge Construction",
"code": "Westridge Construction"
},
{
"name": "Zaryski Construction",
"code": "Zaryski Construction"
},
{
"name": "CBS Contracting/CanBobCat",
"code": "CBS Contracting/CanBobCat"
},
{
"name": "Zayo",
"code": "Zayo"
},
{
"name": "Water",
"code": "Water"
},
{
"name": "Sewer",
"code": "Sewer"
},
{
"name": "Water and Sewer",
"code": "Water and Sewer"
},
{
"name": "LSCMP",
"code": "LSCMP"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "DISTRICT",
"type": "esriFieldTypeSmallInteger",
"alias": "District",
"domain": null
},
{
"name": "MONTHCHECKED",
"type": "esriFieldTypeDate",
"alias": "MonthChecked",
"length": 8,
"domain": null
},
{
"name": "DATEOPENED",
"type": "esriFieldTypeDate",
"alias": "DateOpened",
"length": 8,
"domain": null
},
{
"name": "CUTTYPE",
"type": "esriFieldTypeString",
"alias": "CutType",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Type",
"description": "The type of cut",
"codedValues": [
{
"name": "Brick",
"code": "Brick"
},
{
"name": "Pavement",
"code": "Pavement"
},
{
"name": "Lawn",
"code": "Lawn"
},
{
"name": "Easement",
"code": "Easement"
},
{
"name": "Gravel",
"code": "Gravel"
},
{
"name": "Concrete",
"code": "Concrete"
},
{
"name": "Other",
"code": "Other"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "INTERNAL_EXTERNAL",
"type": "esriFieldTypeString",
"alias": "Internal_External",
"length": 50,
"domain": null
},
{
"name": "ADDRESS",
"type": "esriFieldTypeString",
"alias": "Address",
"length": 50,
"domain": null
},
{
"name": "WHERELOCATION",
"type": "esriFieldTypeString",
"alias": "Where",
"length": 50,
"domain": null
},
{
"name": "REPORTL",
"type": "esriFieldTypeString",
"alias": "ReportL",
"length": 50,
"domain": null
},
{
"name": "REPORTW",
"type": "esriFieldTypeString",
"alias": "ReportW",
"length": 50,
"domain": null
},
{
"name": "COMMENTS",
"type": "esriFieldTypeString",
"alias": "Comments",
"length": 50,
"domain": null
},
{
"name": "DATEINSECTION",
"type": "esriFieldTypeDate",
"alias": "DateInsection",
"length": 8,
"domain": null
},
{
"name": "C_F",
"type": "esriFieldTypeString",
"alias": "C/F",
"length": 50,
"domain": {
"type": "codedValue",
"name": "RCUTS_Inspection",
"description": "",
"codedValues": [
{
"name": "Checked",
"code": "CHECKED"
},
{
"name": "Filled",
"code": "FILLED"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "UNITNO",
"type": "esriFieldTypeString",
"alias": "UnitNo",
"length": 50,
"domain": null
},
{
"name": "CREATED_USER",
"type": "esriFieldTypeString",
"alias": "CREATED_USER",
"length": 255,
"domain": null
},
{
"name": "CREATED_DATE",
"type": "esriFieldTypeDate",
"alias": "CREATED_DATE",
"length": 8,
"domain": null
},
{
"name": "LAST_EDITED_USER",
"type": "esriFieldTypeString",
"alias": "LAST_EDITED_USER",
"length": 255,
"domain": null
},
{
"name": "LAST_EDITED_DATE",
"type": "esriFieldTypeDate",
"alias": "LAST_EDITED_DATE",
"length": 8,
"domain": null
},
{
"name": "INS_ID",
"type": "esriFieldTypeInteger",
"alias": "Ins_ID",
"domain": null
},
{
"name": "TRUCKS_NO",
"type": "esriFieldTypeSmallInteger",
"alias": "TRUCKS_NO",
"domain": null
}
],
"indexes": [
{
"name": "G85877INS_ID",
"fields": "INS_ID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "R368796_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"subtypes": [],
"relationships": [
{
"id": 0,
"name": "RoadwaysCutsDB_2_1",
"relatedTableId": 0,
"role": "esriRelRoleDestination",
"keyField": "INS_ID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": false
},
{
"id": 1,
"name": "RoadwaysCutsDB_2_1",
"relatedTableId": 1,
"role": "esriRelRoleDestination",
"keyField": "INS_ID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": false
}
],
"capabilities": "Map,Query,Data",
"maxRecordCount": 1000,
"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
}
},
{
"currentVersion": 10.91,
"cimVersion": "2.9.0",
"id": 3,
"name": "CUTS_INSPEC_V",
"type": "Table",
"description": null,
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"displayField": "DATEINSECTION",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "INS_ID",
"type": "esriFieldTypeOID",
"alias": "INS_ID",
"domain": null
},
{
"name": "DATEINSECTION",
"type": "esriFieldTypeDate",
"alias": "DATEINSECTION",
"length": 8,
"domain": null
}
],
"indexes": null,
"subtypes": [],
"relationships": [],
"capabilities": "Map,Query,Data",
"maxRecordCount": 1000,
"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
}
}
]
}