{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 0, "name": "End Structures - State", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "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", "field1": "TYPE", "defaultSymbol": { "type": "esriPMS", "url": "5778f576012037a72587da922bb74f06", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABoAAAAWCAYAAADeiIy1AAAACXBIWXMAAA7EAAAOxAGVKw4bAAABZklEQVRIic2VMW6DQBBFp+AGLiw4ACUp1g0XoFrKlAkdTm2RKgWbIlVQ+qWzOAJUuUAqGpc+ABEFd4i+5bUIYnEc1lG+hARL8ebPfAaL/kjWfwaVRMSIyLkmKHQWS46bpmsFEYlrgVLuBxTzO1o9BCkR5WCaBsXM9ZjcvB4emOtRvd8BtjYJwkyEiJLTQflSkHN7Ex9d1aZAcGOjbUr2YnloYV4VkohWJkBwE/fdKOEsrwq8D49pnAUSqLzvRgmuABPbTM4FxYgzQDqlUULlx7td73dqXheD8EHGgCBhUxJRQuHTvfwtiCPOqPicuB+ouEtd3HUgDFiOBUAnucnwEWvjrgOJ0A9GA6ATc73JuFsaN/wnLZuIOxu6snRxPheAMfXiXg63uzWyAfglsxkKncirwm669lvcrbE4o7I5SqOE1m+PQgfCf4Y9bzPCZUA2ClewPggHn03XmoAondbScEaT+2qOvgAmYXRkheK2tgAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 19, "height": 16, "angle": 0, "xoffset": 0, "yoffset": 0 }, "defaultLabel": "No Type", "uniqueValueGroups": [ { "heading": "Type", "classes": [ { "label": "Catch Basin", "description": "Catch Basin", "symbol": { "type": "esriSMS", "style": "esriSMSSquare", "color": [ 85, 255, 0, 255 ], "size": 15, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "values": [ [ "Catch Basin" ] ] }, { "label": "Half Height Headwall", "description": "Half Height Headwall", "symbol": { "type": "esriSMS", "style": "esriSMSSquare", "color": [ 255, 255, 0, 255 ], "size": 15, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.75 } }, "values": [ [ "Half Height Headwall" ] ] }, { "label": "Headwall", "description": "Headwall", "symbol": { "type": "esriSMS", "style": "esriSMSSquare", "color": [ 78, 78, 78, 255 ], "size": 15, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 255, 255, 0, 255 ], "width": 0.75 } }, "values": [ [ "Headwall" ] ] }, { "label": "Inlet", "description": "Inlet", "symbol": { "type": "esriSMS", "style": "esriSMSSquare", "color": [ 0, 197, 255, 255 ], "size": 15, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.75 } }, "values": [ [ "Inlet" ] ] }, { "label": "Manhole", "description": "Manhole", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 76, 230, 0, 255 ], "size": 18, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "values": [ [ "Manhole" ] ] }, { "label": "Pipe end - daylight-open", "description": "Pipe end - daylight-open", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 255, 255, 255, 255 ], "size": 18, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "values": [ [ "Pipe end - daylight-open" ] ] }, { "label": "Stand Pipe", "description": "Stand Pipe", "symbol": { "type": "esriSMS", "style": "esriSMSSquare", "color": [ 197, 0, 255, 255 ], "size": 15, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.75 } }, "values": [ [ "Stand Pipe" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriSMS", "style": "esriSMSSquare", "color": [ 85, 255, 0, 255 ], "size": 15, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "value": "Catch Basin", "label": "Catch Basin" }, { "symbol": { "type": "esriSMS", "style": "esriSMSSquare", "color": [ 255, 255, 0, 255 ], "size": 15, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.75 } }, "value": "Half Height Headwall", "label": "Half Height Headwall" }, { "symbol": { "type": "esriSMS", "style": "esriSMSSquare", "color": [ 78, 78, 78, 255 ], "size": 15, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 255, 255, 0, 255 ], "width": 0.75 } }, "value": "Headwall", "label": "Headwall" }, { "symbol": { "type": "esriSMS", "style": "esriSMSSquare", "color": [ 0, 197, 255, 255 ], "size": 15, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.75 } }, "value": "Inlet", "label": "Inlet" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 76, 230, 0, 255 ], "size": 18, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "value": "Manhole", "label": "Manhole" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 255, 255, 255, 255 ], "size": 18, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "value": "Pipe end - daylight-open", "label": "Pipe end - daylight-open" }, { "symbol": { "type": "esriSMS", "style": "esriSMSSquare", "color": [ 197, 0, 255, 255 ], "size": 15, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.75 } }, "value": "Stand Pipe", "label": "Stand Pipe" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 249, 215, 255 ], "toColor": [ 252, 249, 215, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 241, 179, 252, 255 ], "toColor": [ 241, 179, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 216, 252, 255 ], "toColor": [ 179, 216, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 180, 179, 255 ], "toColor": [ 252, 180, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 252, 185, 255 ], "toColor": [ 182, 252, 185, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 189, 252, 248, 255 ], "toColor": [ 189, 252, 248, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 212, 242, 255 ], "toColor": [ 252, 212, 242, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 188, 182, 252, 255 ], "toColor": [ 188, 182, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 212, 189, 255 ], "toColor": [ 252, 212, 189, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 237, 252, 182, 255 ], "toColor": [ 237, 252, 182, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 224, 199, 252, 255 ], "toColor": [ 224, 199, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 212, 240, 252, 255 ], "toColor": [ 212, 240, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 194, 252, 218, 255 ], "toColor": [ 194, 252, 218, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -9440277.8022, "ymin": 4941019.649599999, "xmax": -9072001.6037, "ymax": 5120861.603699997, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "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": "TYPE", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "NLFID", "type": "esriFieldTypeString", "alias": "NLFID", "length": 14, "domain": null }, { "name": "CRS", "type": "esriFieldTypeString", "alias": "CRS", "length": 17, "domain": null }, { "name": "ODOT_DISTRICT", "type": "esriFieldTypeString", "alias": "ODOT District", "length": 2, "domain": null }, { "name": "COUNTY", "type": "esriFieldTypeString", "alias": "County", "length": 20, "domain": null }, { "name": "COUNTY_CD", "type": "esriFieldTypeString", "alias": "COUNTY_CD", "length": 3, "domain": null }, { "name": "ROUTE_TYPE", "type": "esriFieldTypeString", "alias": "Route Type", "length": 2, "domain": null }, { "name": "ROUTE_NBR", "type": "esriFieldTypeString", "alias": "Route Number", "length": 5, "domain": null }, { "name": "ROUTE_SUFFIX", "type": "esriFieldTypeString", "alias": "Route Suffix", "length": 1, "domain": null }, { "name": "FILE_NUMBER", "type": "esriFieldTypeString", "alias": "FN", "length": 13, "domain": null }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "Type", "length": 25, "domain": { "type": "codedValue", "name": "D_DSI_PT_TYPE", "description": "Type of End structure", "codedValues": [ { "name": "Catch Basin", "code": "Catch Basin" }, { "name": "Manhole", "code": "Manhole" }, { "name": "Headwall", "code": "Headwall" }, { "name": "Half Height Headwall", "code": "Half Height Headwall" }, { "name": "Stand Pipe", "code": "Stand Pipe" }, { "name": "Pipe end - daylight-open", "code": "Pipe end - daylight-open" }, { "name": "Inlet", "code": "Inlet" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "length": 10, "domain": { "type": "codedValue", "name": "D_STATUS", "description": "Asset Status", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Retired", "code": "Retired" }, { "name": "Proposed", "code": "Proposed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "length": 52, "domain": { "type": "codedValue", "name": "D_DSI_PT_MATERIAL", "description": "End Structure Material", "codedValues": [ { "name": "Block", "code": "Block" }, { "name": "Brick", "code": "Brick" }, { "name": "Clay-Vertical Stand Pipe", "code": "Clay-Vertical Stand Pipe" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Concrete-Vertical Stand Pipe", "code": "Concrete-Vertical Stand Pipe" }, { "name": "Corrugated Plastic-Vertical Stand Pipe", "code": "Corrugated Plastic-Vertical Stand Pipe" }, { "name": "Smooth Wall Corrugated Plastic-Vertical Stand Pipe", "code": "Smooth Wall Corrugated Plastic-Vertical Stand Pipe" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SIZE_OF_STRUCTURE", "type": "esriFieldTypeString", "alias": "Size of Structure", "length": 31, "domain": { "type": "codedValue", "name": "D_DSI_PT_SIZE", "description": "Size of structure", "codedValues": [ { "name": "1x1", "code": "1x1" }, { "name": "2x2", "code": "2x2" }, { "name": "3x3", "code": "3x3" }, { "name": "4x4", "code": "4x4" }, { "name": "5x5", "code": "5x5" }, { "name": "6x6", "code": "6x6" }, { "name": "7x7", "code": "7x7" }, { "name": "8x8", "code": "8x8" }, { "name": "9x9", "code": "9x9" }, { "name": "10x10", "code": "10x10" }, { "name": "4\"-10\"", "code": "4\"-10\"" }, { "name": "12\"-18\"", "code": "12\"-18\"" }, { "name": ">24\"", "code": ">24\"" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STRUCTURE_DEPTH", "type": "esriFieldTypeString", "alias": "Depth", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_PT_DEPTH", "description": "Depth of End Structure", "codedValues": [ { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" }, { "name": "5-8", "code": "5-8" }, { "name": ">8", "code": ">8" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INSTALL_YEAR", "type": "esriFieldTypeString", "alias": "Install Year", "length": 8, "domain": null }, { "name": "DATE_LAST_CLEANED", "type": "esriFieldTypeDate", "alias": "Date Last Cleaned", "length": 8, "domain": null }, { "name": "PIPE_TO_THE_NORTH", "type": "esriFieldTypeString", "alias": "Pipe size to the north", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_LN_DIAMETER", "description": "Size of pipe", "codedValues": [ { "name": "96", "code": "96" }, { "name": "84", "code": "84" }, { "name": "78", "code": "78" }, { "name": "72", "code": "72" }, { "name": "66", "code": "66" }, { "name": "60", "code": "60" }, { "name": "54", "code": "54" }, { "name": "48", "code": "48" }, { "name": "42", "code": "42" }, { "name": "36", "code": "36" }, { "name": "33", "code": "33" }, { "name": "30", "code": "30" }, { "name": "27", "code": "27" }, { "name": "24", "code": "24" }, { "name": "21", "code": "21" }, { "name": "20", "code": "20" }, { "name": "18", "code": "18" }, { "name": "15", "code": "15" }, { "name": "12", "code": "12" }, { "name": "10", "code": "10" }, { "name": "08", "code": "08" }, { "name": "06", "code": "06" }, { "name": "04", "code": "04" }, { "name": "120", "code": "120" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAT_N", "type": "esriFieldTypeString", "alias": "Material to north", "length": 50, "domain": { "type": "codedValue", "name": "D_DSI_LN_MATERIAL", "description": "Pipe Material", "codedValues": [ { "name": "Clay", "code": "Clay" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Corrugated Metal", "code": "Corrugated Metal" }, { "name": "Corrugated Plastic", "code": "Corrugated Plastic" }, { "name": "Smooth Wall Corrugated Plastic", "code": "Smooth Wall Corrugated Plastic" }, { "name": "Polyvinyl Chloride/SDR", "code": "Polyvinyl Chloride/SDR" }, { "name": "Unknown", "code": "Unknown" }, { "name": "None", "code": "None" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAT_NE", "type": "esriFieldTypeString", "alias": "Material to north east", "length": 50, "domain": { "type": "codedValue", "name": "D_DSI_LN_MATERIAL", "description": "Pipe Material", "codedValues": [ { "name": "Clay", "code": "Clay" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Corrugated Metal", "code": "Corrugated Metal" }, { "name": "Corrugated Plastic", "code": "Corrugated Plastic" }, { "name": "Smooth Wall Corrugated Plastic", "code": "Smooth Wall Corrugated Plastic" }, { "name": "Polyvinyl Chloride/SDR", "code": "Polyvinyl Chloride/SDR" }, { "name": "Unknown", "code": "Unknown" }, { "name": "None", "code": "None" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAT_E", "type": "esriFieldTypeString", "alias": "Material to east", "length": 50, "domain": { "type": "codedValue", "name": "D_DSI_LN_MATERIAL", "description": "Pipe Material", "codedValues": [ { "name": "Clay", "code": "Clay" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Corrugated Metal", "code": "Corrugated Metal" }, { "name": "Corrugated Plastic", "code": "Corrugated Plastic" }, { "name": "Smooth Wall Corrugated Plastic", "code": "Smooth Wall Corrugated Plastic" }, { "name": "Polyvinyl Chloride/SDR", "code": "Polyvinyl Chloride/SDR" }, { "name": "Unknown", "code": "Unknown" }, { "name": "None", "code": "None" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAT_SE", "type": "esriFieldTypeString", "alias": "Material to south east", "length": 50, "domain": { "type": "codedValue", "name": "D_DSI_LN_MATERIAL", "description": "Pipe Material", "codedValues": [ { "name": "Clay", "code": "Clay" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Corrugated Metal", "code": "Corrugated Metal" }, { "name": "Corrugated Plastic", "code": "Corrugated Plastic" }, { "name": "Smooth Wall Corrugated Plastic", "code": "Smooth Wall Corrugated Plastic" }, { "name": "Polyvinyl Chloride/SDR", "code": "Polyvinyl Chloride/SDR" }, { "name": "Unknown", "code": "Unknown" }, { "name": "None", "code": "None" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAT_S", "type": "esriFieldTypeString", "alias": "Material to south", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_LN_MATERIAL", "description": "Pipe Material", "codedValues": [ { "name": "Clay", "code": "Clay" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Corrugated Metal", "code": "Corrugated Metal" }, { "name": "Corrugated Plastic", "code": "Corrugated Plastic" }, { "name": "Smooth Wall Corrugated Plastic", "code": "Smooth Wall Corrugated Plastic" }, { "name": "Polyvinyl Chloride/SDR", "code": "Polyvinyl Chloride/SDR" }, { "name": "Unknown", "code": "Unknown" }, { "name": "None", "code": "None" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAT_SW", "type": "esriFieldTypeString", "alias": "Material to south west", "length": 50, "domain": { "type": "codedValue", "name": "D_DSI_LN_MATERIAL", "description": "Pipe Material", "codedValues": [ { "name": "Clay", "code": "Clay" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Corrugated Metal", "code": "Corrugated Metal" }, { "name": "Corrugated Plastic", "code": "Corrugated Plastic" }, { "name": "Smooth Wall Corrugated Plastic", "code": "Smooth Wall Corrugated Plastic" }, { "name": "Polyvinyl Chloride/SDR", "code": "Polyvinyl Chloride/SDR" }, { "name": "Unknown", "code": "Unknown" }, { "name": "None", "code": "None" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAT_W", "type": "esriFieldTypeString", "alias": "Material to west", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_LN_MATERIAL", "description": "Pipe Material", "codedValues": [ { "name": "Clay", "code": "Clay" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Corrugated Metal", "code": "Corrugated Metal" }, { "name": "Corrugated Plastic", "code": "Corrugated Plastic" }, { "name": "Smooth Wall Corrugated Plastic", "code": "Smooth Wall Corrugated Plastic" }, { "name": "Polyvinyl Chloride/SDR", "code": "Polyvinyl Chloride/SDR" }, { "name": "Unknown", "code": "Unknown" }, { "name": "None", "code": "None" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAT_NW", "type": "esriFieldTypeString", "alias": "Material to north west", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_LN_MATERIAL", "description": "Pipe Material", "codedValues": [ { "name": "Clay", "code": "Clay" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Corrugated Metal", "code": "Corrugated Metal" }, { "name": "Corrugated Plastic", "code": "Corrugated Plastic" }, { "name": "Smooth Wall Corrugated Plastic", "code": "Smooth Wall Corrugated Plastic" }, { "name": "Polyvinyl Chloride/SDR", "code": "Polyvinyl Chloride/SDR" }, { "name": "Unknown", "code": "Unknown" }, { "name": "None", "code": "None" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMMENT", "type": "esriFieldTypeString", "alias": "Comment", "length": 1000, "domain": null }, { "name": "SOURCE", "type": "esriFieldTypeString", "alias": "Source", "length": 50, "domain": { "type": "codedValue", "name": "D_DSI_SOURCE", "description": "Source of data", "codedValues": [ { "name": "Field Verified", "code": "Field Verified" }, { "name": "Plan Set", "code": "Plan Set" }, { "name": "Survey Data", "code": "Survey Data" }, { "name": "Unknown", "code": "Unknown" }, { "name": "County Knowledge", "code": "County Knowledge" }, { "name": "Aerial Imagery", "code": "Aerial Imagery" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COUNTY_RESPON", "type": "esriFieldTypeString", "alias": "County Responsible", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_D2_COUNTY_RESP", "description": "Lets us assign a county to the maintenance of the asset due to NOP being included in county maintenance and not being a selectable county in our other domains", "codedValues": [ { "name": "Fulton", "code": "Fulton" }, { "name": "Henry", "code": "Henry" }, { "name": "Lucas", "code": "Lucas" }, { "name": "Northwood", "code": "Northwood" }, { "name": "Ottawa", "code": "Ottawa" }, { "name": "Sandusky", "code": "Sandusky" }, { "name": "Seneca", "code": "Seneca" }, { "name": "Williams", "code": "Williams" }, { "name": "Wood", "code": "Wood" }, { "name": "Defiance", "code": "Defiance" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAINTENANCE_RESPONSIBILITY", "type": "esriFieldTypeString", "alias": "Maintenance Responsible", "length": 15, "domain": { "type": "codedValue", "name": "D_DSI_MAINTRESPON", "description": "Who is responsible for the item", "codedValues": [ { "name": "ODOT", "code": "ODOT" }, { "name": "County", "code": "County" }, { "name": "City", "code": "City" }, { "name": "Township", "code": "Township" }, { "name": "Village", "code": "Village" }, { "name": "ODNR", "code": "ODNR" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ASSOC_W_UNDR_DR", "type": "esriFieldTypeString", "alias": "Associated with Underdrain", "length": 255, "domain": { "type": "codedValue", "name": "D_YESNO", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ASSOC_W_CULVE", "type": "esriFieldTypeString", "alias": "Associated with Culvert", "length": 255, "domain": { "type": "codedValue", "name": "D_YESNO", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RISER", "type": "esriFieldTypeString", "alias": "Riser", "length": 8, "domain": { "type": "codedValue", "name": "D_YESNULL", "description": "Yes", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RISER1", "type": "esriFieldTypeString", "alias": "Riser 1", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_PT_RISER", "description": "Riser yes or no with sizes", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes - 4\"", "code": "Yes - 4\"" }, { "name": "Yes - 6\"", "code": "Yes - 6\"" }, { "name": "Yes - 12\"", "code": "Yes - 12\"" }, { "name": "Slant Top", "code": "Slant Top" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RISER2", "type": "esriFieldTypeString", "alias": "Riser 2", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_PT_RISER", "description": "Riser yes or no with sizes", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes - 4\"", "code": "Yes - 4\"" }, { "name": "Yes - 6\"", "code": "Yes - 6\"" }, { "name": "Yes - 12\"", "code": "Yes - 12\"" }, { "name": "Slant Top", "code": "Slant Top" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RISER3", "type": "esriFieldTypeString", "alias": "Riser 3", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_PT_RISER", "description": "Riser yes or no with sizes", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes - 4\"", "code": "Yes - 4\"" }, { "name": "Yes - 6\"", "code": "Yes - 6\"" }, { "name": "Yes - 12\"", "code": "Yes - 12\"" }, { "name": "Slant Top", "code": "Slant Top" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GRATE_CLEANING", "type": "esriFieldTypeString", "alias": "Grate Cleaning", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_GRATE_COND", "description": "Grate cleaning and maintenance needed", "codedValues": [ { "name": "Grate was cleaned", "code": "Grate was cleaned" }, { "name": "Grate needs cleaned", "code": "Grate needs cleaned" }, { "name": "Maintenance needed", "code": "Maintenance needed" }, { "name": "Maintenance complete", "code": "Maintenance complete" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "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": "sys_updated_date", "type": "esriFieldTypeDate", "alias": "sys_updated_date", "length": 8, "domain": null }, { "name": "CTL_BEGIN_NBR", "type": "esriFieldTypeDouble", "alias": "CTL_BEGIN_NBR", "domain": null }, { "name": "LATITUDE_DD_BEGIN", "type": "esriFieldTypeDouble", "alias": "LATITUDE_DD_BEGIN", "domain": null }, { "name": "LONGITUDE_DD_BEGIN", "type": "esriFieldTypeDouble", "alias": "LONGITUDE_DD_BEGIN", "domain": null }, { "name": "STL_BEGIN_NBR", "type": "esriFieldTypeDouble", "alias": "STL_BEGIN_NBR", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PIPE_TO_THE_EAST", "type": "esriFieldTypeString", "alias": "Pipe size to the east", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_LN_DIAMETER", "description": "Size of pipe", "codedValues": [ { "name": "96", "code": "96" }, { "name": "84", "code": "84" }, { "name": "78", "code": "78" }, { "name": "72", "code": "72" }, { "name": "66", "code": "66" }, { "name": "60", "code": "60" }, { "name": "54", "code": "54" }, { "name": "48", "code": "48" }, { "name": "42", "code": "42" }, { "name": "36", "code": "36" }, { "name": "33", "code": "33" }, { "name": "30", "code": "30" }, { "name": "27", "code": "27" }, { "name": "24", "code": "24" }, { "name": "21", "code": "21" }, { "name": "20", "code": "20" }, { "name": "18", "code": "18" }, { "name": "15", "code": "15" }, { "name": "12", "code": "12" }, { "name": "10", "code": "10" }, { "name": "08", "code": "08" }, { "name": "06", "code": "06" }, { "name": "04", "code": "04" }, { "name": "120", "code": "120" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PIPE_TO_THE_SOUTH_EAST", "type": "esriFieldTypeString", "alias": "Pipe size to the south east", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_LN_DIAMETER", "description": "Size of pipe", "codedValues": [ { "name": "96", "code": "96" }, { "name": "84", "code": "84" }, { "name": "78", "code": "78" }, { "name": "72", "code": "72" }, { "name": "66", "code": "66" }, { "name": "60", "code": "60" }, { "name": "54", "code": "54" }, { "name": "48", "code": "48" }, { "name": "42", "code": "42" }, { "name": "36", "code": "36" }, { "name": "33", "code": "33" }, { "name": "30", "code": "30" }, { "name": "27", "code": "27" }, { "name": "24", "code": "24" }, { "name": "21", "code": "21" }, { "name": "20", "code": "20" }, { "name": "18", "code": "18" }, { "name": "15", "code": "15" }, { "name": "12", "code": "12" }, { "name": "10", "code": "10" }, { "name": "08", "code": "08" }, { "name": "06", "code": "06" }, { "name": "04", "code": "04" }, { "name": "120", "code": "120" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PIPE_TO_THE_SOUTH", "type": "esriFieldTypeString", "alias": "Pipe size to the south", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_LN_DIAMETER", "description": "Size of pipe", "codedValues": [ { "name": "96", "code": "96" }, { "name": "84", "code": "84" }, { "name": "78", "code": "78" }, { "name": "72", "code": "72" }, { "name": "66", "code": "66" }, { "name": "60", "code": "60" }, { "name": "54", "code": "54" }, { "name": "48", "code": "48" }, { "name": "42", "code": "42" }, { "name": "36", "code": "36" }, { "name": "33", "code": "33" }, { "name": "30", "code": "30" }, { "name": "27", "code": "27" }, { "name": "24", "code": "24" }, { "name": "21", "code": "21" }, { "name": "20", "code": "20" }, { "name": "18", "code": "18" }, { "name": "15", "code": "15" }, { "name": "12", "code": "12" }, { "name": "10", "code": "10" }, { "name": "08", "code": "08" }, { "name": "06", "code": "06" }, { "name": "04", "code": "04" }, { "name": "120", "code": "120" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PIPE_TO_THE_SOUTH_WEST", "type": "esriFieldTypeString", "alias": "Pipe size to the south west", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_LN_DIAMETER", "description": "Size of pipe", "codedValues": [ { "name": "96", "code": "96" }, { "name": "84", "code": "84" }, { "name": "78", "code": "78" }, { "name": "72", "code": "72" }, { "name": "66", "code": "66" }, { "name": "60", "code": "60" }, { "name": "54", "code": "54" }, { "name": "48", "code": "48" }, { "name": "42", "code": "42" }, { "name": "36", "code": "36" }, { "name": "33", "code": "33" }, { "name": "30", "code": "30" }, { "name": "27", "code": "27" }, { "name": "24", "code": "24" }, { "name": "21", "code": "21" }, { "name": "20", "code": "20" }, { "name": "18", "code": "18" }, { "name": "15", "code": "15" }, { "name": "12", "code": "12" }, { "name": "10", "code": "10" }, { "name": "08", "code": "08" }, { "name": "06", "code": "06" }, { "name": "04", "code": "04" }, { "name": "120", "code": "120" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PIPE_TO_THE_WEST", "type": "esriFieldTypeString", "alias": "Pipe size to the west", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_LN_DIAMETER", "description": "Size of pipe", "codedValues": [ { "name": "96", "code": "96" }, { "name": "84", "code": "84" }, { "name": "78", "code": "78" }, { "name": "72", "code": "72" }, { "name": "66", "code": "66" }, { "name": "60", "code": "60" }, { "name": "54", "code": "54" }, { "name": "48", "code": "48" }, { "name": "42", "code": "42" }, { "name": "36", "code": "36" }, { "name": "33", "code": "33" }, { "name": "30", "code": "30" }, { "name": "27", "code": "27" }, { "name": "24", "code": "24" }, { "name": "21", "code": "21" }, { "name": "20", "code": "20" }, { "name": "18", "code": "18" }, { "name": "15", "code": "15" }, { "name": "12", "code": "12" }, { "name": "10", "code": "10" }, { "name": "08", "code": "08" }, { "name": "06", "code": "06" }, { "name": "04", "code": "04" }, { "name": "120", "code": "120" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PIPE_TO_THE_NORTH_WEST", "type": "esriFieldTypeString", "alias": "Pipe size to the north west", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_LN_DIAMETER", "description": "Size of pipe", "codedValues": [ { "name": "96", "code": "96" }, { "name": "84", "code": "84" }, { "name": "78", "code": "78" }, { "name": "72", "code": "72" }, { "name": "66", "code": "66" }, { "name": "60", "code": "60" }, { "name": "54", "code": "54" }, { "name": "48", "code": "48" }, { "name": "42", "code": "42" }, { "name": "36", "code": "36" }, { "name": "33", "code": "33" }, { "name": "30", "code": "30" }, { "name": "27", "code": "27" }, { "name": "24", "code": "24" }, { "name": "21", "code": "21" }, { "name": "20", "code": "20" }, { "name": "18", "code": "18" }, { "name": "15", "code": "15" }, { "name": "12", "code": "12" }, { "name": "10", "code": "10" }, { "name": "08", "code": "08" }, { "name": "06", "code": "06" }, { "name": "04", "code": "04" }, { "name": "120", "code": "120" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PIPE_TO_THE_NORTH_EAST", "type": "esriFieldTypeString", "alias": "Pipe size to the north east", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_LN_DIAMETER", "description": "Size of pipe", "codedValues": [ { "name": "96", "code": "96" }, { "name": "84", "code": "84" }, { "name": "78", "code": "78" }, { "name": "72", "code": "72" }, { "name": "66", "code": "66" }, { "name": "60", "code": "60" }, { "name": "54", "code": "54" }, { "name": "48", "code": "48" }, { "name": "42", "code": "42" }, { "name": "36", "code": "36" }, { "name": "33", "code": "33" }, { "name": "30", "code": "30" }, { "name": "27", "code": "27" }, { "name": "24", "code": "24" }, { "name": "21", "code": "21" }, { "name": "20", "code": "20" }, { "name": "18", "code": "18" }, { "name": "15", "code": "15" }, { "name": "12", "code": "12" }, { "name": "10", "code": "10" }, { "name": "08", "code": "08" }, { "name": "06", "code": "06" }, { "name": "04", "code": "04" }, { "name": "120", "code": "120" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NEED_MAINTENANCE", "type": "esriFieldTypeString", "alias": "Needs Maintenance", "length": 255, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "UUID_309", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "gdb_ct3_309", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S145_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "TAMCOLLECTOR.DSI_ENDSTRUCTURE_DATELASTCLEANED", "relatedTableId": 9, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{5EB60B92-A109-49EB-B584-2169353AE624}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": 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, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1748964362000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 3, "name": "Storm Mains - State", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 2, "mTolerance": 2, "falseX": -20037700, "falseY": -30241100, "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": "esriSLS", "style": "esriSLSSolid", "color": [ 85, 255, 0, 255 ], "width": 5 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -9436473.2564, "ymin": 4962092.380999997, "xmax": -9072001.6037, "ymax": 5120487.395800002, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "STATUS", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "length": 10, "domain": { "type": "codedValue", "name": "D_STATUS", "description": "Asset Status", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Retired", "code": "Retired" }, { "name": "Proposed", "code": "Proposed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DIAMETER", "type": "esriFieldTypeString", "alias": "Diameter", "length": 8, "domain": { "type": "codedValue", "name": "D_DSI_LN_DIAMETER", "description": "Size of pipe", "codedValues": [ { "name": "96", "code": "96" }, { "name": "84", "code": "84" }, { "name": "78", "code": "78" }, { "name": "72", "code": "72" }, { "name": "66", "code": "66" }, { "name": "60", "code": "60" }, { "name": "54", "code": "54" }, { "name": "48", "code": "48" }, { "name": "42", "code": "42" }, { "name": "36", "code": "36" }, { "name": "33", "code": "33" }, { "name": "30", "code": "30" }, { "name": "27", "code": "27" }, { "name": "24", "code": "24" }, { "name": "21", "code": "21" }, { "name": "20", "code": "20" }, { "name": "18", "code": "18" }, { "name": "15", "code": "15" }, { "name": "12", "code": "12" }, { "name": "10", "code": "10" }, { "name": "08", "code": "08" }, { "name": "06", "code": "06" }, { "name": "04", "code": "04" }, { "name": "120", "code": "120" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHAPE_OF_PIPE", "type": "esriFieldTypeString", "alias": "Shape Of Pipe", "length": 31, "domain": { "type": "codedValue", "name": "D_DSI_LN_SHAPE", "description": "Shape of main", "codedValues": [ { "name": "Circular", "code": "Circular" }, { "name": "Elliptical-Horizontal", "code": "Elliptical-Horizontal" }, { "name": "Elliptical-Vertical", "code": "Elliptical-Vertical" }, { "name": "Other(twin pipe, box, slab top)", "code": "Other(twin pipe, box, slab top)" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "length": 52, "domain": { "type": "codedValue", "name": "D_DSI_LN_MATERIAL", "description": "Pipe Material", "codedValues": [ { "name": "Clay", "code": "Clay" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Corrugated Metal", "code": "Corrugated Metal" }, { "name": "Corrugated Plastic", "code": "Corrugated Plastic" }, { "name": "Smooth Wall Corrugated Plastic", "code": "Smooth Wall Corrugated Plastic" }, { "name": "Polyvinyl Chloride/SDR", "code": "Polyvinyl Chloride/SDR" }, { "name": "Unknown", "code": "Unknown" }, { "name": "None", "code": "None" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INSTALL_YEAR", "type": "esriFieldTypeString", "alias": "Install Year", "length": 8, "domain": null }, { "name": "DATE_LAST_CLEANED", "type": "esriFieldTypeDate", "alias": "Date Last Cleaned", "length": 8, "domain": null }, { "name": "COMMENT", "type": "esriFieldTypeString", "alias": "Comment", "length": 1000, "domain": null }, { "name": "REPLACE", "type": "esriFieldTypeString", "alias": "Replace", "length": 8, "domain": { "type": "codedValue", "name": "D_YESNULL", "description": "Yes", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REPAIR", "type": "esriFieldTypeString", "alias": "Repair", "length": 8, "domain": { "type": "codedValue", "name": "D_YESNULL", "description": "Yes", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAINTENANCE_RESPONSIBILITY", "type": "esriFieldTypeString", "alias": "Maintenance Responsibility", "length": 15, "domain": { "type": "codedValue", "name": "D_DSI_MAINTRESPON", "description": "Who is responsible for the item", "codedValues": [ { "name": "ODOT", "code": "ODOT" }, { "name": "County", "code": "County" }, { "name": "City", "code": "City" }, { "name": "Township", "code": "Township" }, { "name": "Village", "code": "Village" }, { "name": "ODNR", "code": "ODNR" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LET_PLANS_URL", "type": "esriFieldTypeString", "alias": "URL", "length": 150, "domain": null }, { "name": "STORM_MAIN_FILE_NUMBER", "type": "esriFieldTypeString", "alias": "SMFN", "length": 11, "domain": null }, { "name": "ODOT_DISTRICT", "type": "esriFieldTypeString", "alias": "District", "length": 2, "domain": null }, { "name": "COUNTY", "type": "esriFieldTypeString", "alias": "County", "length": 10, "domain": null }, { "name": "ROUTE_TYPE", "type": "esriFieldTypeString", "alias": "Route Type", "length": 2, "domain": null }, { "name": "ROUTE_NBR", "type": "esriFieldTypeString", "alias": "Route Number", "length": 5, "domain": null }, { "name": "ROUTE_SUFFIX", "type": "esriFieldTypeString", "alias": "Route Suffix", "length": 1, "domain": null }, { "name": "CTL_BEGIN_NBR", "type": "esriFieldTypeDouble", "alias": "CTL Begin Number", "domain": null }, { "name": "CTL_END_NBR", "type": "esriFieldTypeDouble", "alias": "CTL End Number", "domain": null }, { "name": "STL_BEGIN_NBR", "type": "esriFieldTypeDouble", "alias": "STL Begin Number", "domain": null }, { "name": "STL_END_NBR", "type": "esriFieldTypeDouble", "alias": "STL End Number", "domain": null }, { "name": "LATITUDE_DD_BEGIN", "type": "esriFieldTypeDouble", "alias": "Latitude DD Begin", "domain": null }, { "name": "LONGITUDE_DD_BEGIN", "type": "esriFieldTypeDouble", "alias": "Longitude DD Begin", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "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": "FITTING_ON_TILE", "type": "esriFieldTypeString", "alias": "Fitting on Tile", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_FITTING", "description": "Type of fitting on tile", "codedValues": [ { "name": "Tee", "code": "Tee" }, { "name": "Pipe Guard (aminal guard)", "code": "Pipe Guard" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "KNOWN_FLOW", "type": "esriFieldTypeString", "alias": "Flow Direction Known", "length": 255, "domain": { "type": "codedValue", "name": "D_YESNULL", "description": "Yes", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SOURCE", "type": "esriFieldTypeString", "alias": "Source", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_SOURCE", "description": "Source of data", "codedValues": [ { "name": "Field Verified", "code": "Field Verified" }, { "name": "Plan Set", "code": "Plan Set" }, { "name": "Survey Data", "code": "Survey Data" }, { "name": "Unknown", "code": "Unknown" }, { "name": "County Knowledge", "code": "County Knowledge" }, { "name": "Aerial Imagery", "code": "Aerial Imagery" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COUNTY_RESPON", "type": "esriFieldTypeString", "alias": "County Responsible", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_D2_COUNTY_RESP", "description": "Lets us assign a county to the maintenance of the asset due to NOP being included in county maintenance and not being a selectable county in our other domains", "codedValues": [ { "name": "Fulton", "code": "Fulton" }, { "name": "Henry", "code": "Henry" }, { "name": "Lucas", "code": "Lucas" }, { "name": "Northwood", "code": "Northwood" }, { "name": "Ottawa", "code": "Ottawa" }, { "name": "Sandusky", "code": "Sandusky" }, { "name": "Seneca", "code": "Seneca" }, { "name": "Williams", "code": "Williams" }, { "name": "Wood", "code": "Wood" }, { "name": "Defiance", "code": "Defiance" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSOC_W_UNDR_DRN", "type": "esriFieldTypeString", "alias": "Associated with underdrain", "length": 255, "domain": { "type": "codedValue", "name": "D_YESNO", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ASSOC_W_CULVE", "type": "esriFieldTypeString", "alias": "Associated with culvert", "length": 255, "domain": { "type": "codedValue", "name": "D_YESNO", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CRS", "type": "esriFieldTypeString", "alias": "CRS", "length": 17, "domain": null }, { "name": "NLF_ID", "type": "esriFieldTypeString", "alias": "NLF_ID", "length": 14, "domain": null }, { "name": "sys_updated_date", "type": "esriFieldTypeDate", "alias": "sys_updated_date", "length": 8, "domain": null }, { "name": "COUNTY_CD", "type": "esriFieldTypeString", "alias": "COUNTY_CD", "length": 3, "domain": null }, { "name": "NEED_MAINTENANCE", "type": "esriFieldTypeString", "alias": "Needs Maintenance", "length": 255, "domain": null }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "Type", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_STM_MAIN_TYPE", "description": "Storm Main Type", "codedValues": [ { "name": "Storm Main", "code": "Storm Main" }, { "name": "Underdrain", "code": "Underdrain" }, { "name": "Culvert", "code": "Culvert" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LENGTH_OF_PIPE", "type": "esriFieldTypeDouble", "alias": "Length of Pipe", "domain": null }, { "name": "SLOPE_OF_PIPE", "type": "esriFieldTypeDouble", "alias": "Slope of Pipe", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "UUID_183", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "gdb_ct3_183", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S84_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "TAMCOLLECTOR.DSI_STORMMAIN_DATELASTCLEANED", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{3ABC42D2-DD89-4C62-BF11-5BA7A03511FC}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape.STLength()", "units": "esriMeters", "mapUnits": {"uwkid": 9001} }, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645120918000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "Ditches - State", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 2, "mTolerance": 2, "falseX": -20037700, "falseY": -30241100, "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": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 255, 0, 255 ], "width": 5 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -9423594.6462, "ymin": 5021872.262400001, "xmax": -9072142.3115, "ymax": 5132314.279299997, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "TYPE", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "TYPE", "type": "esriFieldTypeString", "alias": "Type", "length": 20, "domain": { "type": "codedValue", "name": "D_DSI_DITCH_TYPE", "description": "Type of ditch", "codedValues": [ { "name": "V Ditch", "code": "V Ditch" }, { "name": "Rounded Ditch", "code": "Rounded Ditch" }, { "name": "Flat Bottom", "code": "Flat Bottom" }, { "name": "Rounded/Flat Bottom", "code": "Rounded/Flat Bottom" }, { "name": "Swale", "code": "Swale" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "length": 10, "domain": { "type": "codedValue", "name": "D_STATUS", "description": "Asset Status", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Retired", "code": "Retired" }, { "name": "Proposed", "code": "Proposed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DATE_LAST_CLEANED", "type": "esriFieldTypeDate", "alias": "Date Last Cleaned", "length": 8, "domain": null }, { "name": "MAINTENANCE_RESPONSIBILITY", "type": "esriFieldTypeString", "alias": "Maintenance Responsibility", "length": 15, "domain": { "type": "codedValue", "name": "D_DSI_MAINTRESPON", "description": "Who is responsible for the item", "codedValues": [ { "name": "ODOT", "code": "ODOT" }, { "name": "County", "code": "County" }, { "name": "City", "code": "City" }, { "name": "Township", "code": "Township" }, { "name": "Village", "code": "Village" }, { "name": "ODNR", "code": "ODNR" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INSTALL_YEAR", "type": "esriFieldTypeString", "alias": "Install Year", "length": 8, "domain": null }, { "name": "FLOW_DIRECTION", "type": "esriFieldTypeString", "alias": "Flow Direction", "length": 2, "domain": { "type": "codedValue", "name": "D_GEO_DIRECTION", "description": "D_GEO_DIRECTION", "codedValues": [ { "name": "North", "code": "N" }, { "name": "South", "code": "S" }, { "name": "East", "code": "E" }, { "name": "West", "code": "W" }, { "name": "Northeast", "code": "NE" }, { "name": "Northwest", "code": "NW" }, { "name": "Southeast", "code": "SE" }, { "name": "Southwest", "code": "SW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LET_PLANS_URL", "type": "esriFieldTypeString", "alias": "URL", "length": 150, "domain": null }, { "name": "COMMENT", "type": "esriFieldTypeString", "alias": "Comment", "length": 1000, "domain": null }, { "name": "DITCH_FILE_NUMBER", "type": "esriFieldTypeString", "alias": "DFN", "length": 11, "domain": null }, { "name": "ODOT_DISTRICT", "type": "esriFieldTypeString", "alias": "District", "length": 2, "domain": { "type": "codedValue", "name": "D_DSI_DISTRICT", "description": "District Number", "codedValues": [ { "name": "01", "code": "01" }, { "name": "02", "code": "02" }, { "name": "03", "code": "03" }, { "name": "04", "code": "04" }, { "name": "05", "code": "05" }, { "name": "06", "code": "06" }, { "name": "07", "code": "07" }, { "name": "08", "code": "08" }, { "name": "09", "code": "09" }, { "name": "10", "code": "10" }, { "name": "11", "code": "11" }, { "name": "12", "code": "12" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COUNTY", "type": "esriFieldTypeString", "alias": "County", "length": 10, "domain": null }, { "name": "ROUTE_TYPE", "type": "esriFieldTypeString", "alias": "Route Type", "length": 2, "domain": null }, { "name": "ROUTE_NBR", "type": "esriFieldTypeString", "alias": "Route Number", "length": 5, "domain": null }, { "name": "ROUTE_SUFFIX", "type": "esriFieldTypeString", "alias": "Route Suffix", "length": 1, "domain": null }, { "name": "CTL_BEGIN_NBR", "type": "esriFieldTypeDouble", "alias": "CTL Begin Number", "domain": null }, { "name": "CTL_END_NBR", "type": "esriFieldTypeDouble", "alias": "CTL End Number", "domain": null }, { "name": "STL_BEGIN_NBR", "type": "esriFieldTypeDouble", "alias": "STL Begin Number", "domain": null }, { "name": "STL_END_NBR", "type": "esriFieldTypeDouble", "alias": "STL End Number", "domain": null }, { "name": "LATITUDE_DD_BEGIN", "type": "esriFieldTypeDouble", "alias": "Latitude DD Begin", "domain": null }, { "name": "LONGITUDE_DD_BEGIN", "type": "esriFieldTypeDouble", "alias": "Longitude DD Begin", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "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": "SOURCE", "type": "esriFieldTypeString", "alias": "Source", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_SOURCE", "description": "Source of data", "codedValues": [ { "name": "Field Verified", "code": "Field Verified" }, { "name": "Plan Set", "code": "Plan Set" }, { "name": "Survey Data", "code": "Survey Data" }, { "name": "Unknown", "code": "Unknown" }, { "name": "County Knowledge", "code": "County Knowledge" }, { "name": "Aerial Imagery", "code": "Aerial Imagery" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "KNOWN_FLOW", "type": "esriFieldTypeString", "alias": "Flow Direction Known", "length": 255, "domain": { "type": "codedValue", "name": "D_YESNULL", "description": "Yes", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COUNTY_RESPON", "type": "esriFieldTypeString", "alias": "County Responsible", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_D2_COUNTY_RESP", "description": "Lets us assign a county to the maintenance of the asset due to NOP being included in county maintenance and not being a selectable county in our other domains", "codedValues": [ { "name": "Fulton", "code": "Fulton" }, { "name": "Henry", "code": "Henry" }, { "name": "Lucas", "code": "Lucas" }, { "name": "Northwood", "code": "Northwood" }, { "name": "Ottawa", "code": "Ottawa" }, { "name": "Sandusky", "code": "Sandusky" }, { "name": "Seneca", "code": "Seneca" }, { "name": "Williams", "code": "Williams" }, { "name": "Wood", "code": "Wood" }, { "name": "Defiance", "code": "Defiance" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "INVENTORY_INITIALS", "type": "esriFieldTypeString", "alias": "Initials of person inputting data", "length": 255, "domain": null }, { "name": "CRS", "type": "esriFieldTypeString", "alias": "CRS", "length": 17, "domain": null }, { "name": "NLF_ID", "type": "esriFieldTypeString", "alias": "NLF_ID", "length": 14, "domain": null }, { "name": "sys_updated_date", "type": "esriFieldTypeDate", "alias": "sys_updated_date", "length": 8, "domain": null }, { "name": "COUNTY_CD", "type": "esriFieldTypeString", "alias": "COUNTY_CD", "length": 3, "domain": null }, { "name": "NEED_MAINTENANCE", "type": "esriFieldTypeString", "alias": "Needs Maintenance", "length": 255, "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "UUID_184", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "gdb_ct3_184", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S85_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "TAMCOLLECTOR.DSI_DITCH_DATELASTCLEANED", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{7B641389-1D5D-457D-8C44-5809090D56C3}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape.STLength()", "units": "esriMeters", "mapUnits": {"uwkid": 9001} }, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645120492000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 4, "name": "End Structures - Non-State", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "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": "esriSMS", "style": "esriSMSSquare", "color": [ 230, 0, 0, 255 ], "size": 13, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": -9440277.8022, "ymin": 4941019.649599999, "xmax": -9072001.6037, "ymax": 5120861.603699997, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "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": "TYPE", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "NLFID", "type": "esriFieldTypeString", "alias": "NLFID", "length": 14, "domain": null }, { "name": "CRS", "type": "esriFieldTypeString", "alias": "CRS", "length": 17, "domain": null }, { "name": "ODOT_DISTRICT", "type": "esriFieldTypeString", "alias": "ODOT District", "length": 2, "domain": null }, { "name": "COUNTY", "type": "esriFieldTypeString", "alias": "County", "length": 20, "domain": null }, { "name": "COUNTY_CD", "type": "esriFieldTypeString", "alias": "COUNTY_CD", "length": 3, "domain": null }, { "name": "ROUTE_TYPE", "type": "esriFieldTypeString", "alias": "Route Type", "length": 2, "domain": null }, { "name": "ROUTE_NBR", "type": "esriFieldTypeString", "alias": "Route Number", "length": 5, "domain": null }, { "name": "ROUTE_SUFFIX", "type": "esriFieldTypeString", "alias": "Route Suffix", "length": 1, "domain": null }, { "name": "FILE_NUMBER", "type": "esriFieldTypeString", "alias": "FN", "length": 13, "domain": null }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "Type", "length": 25, "domain": { "type": "codedValue", "name": "D_DSI_PT_TYPE", "description": "Type of End structure", "codedValues": [ { "name": "Catch Basin", "code": "Catch Basin" }, { "name": "Manhole", "code": "Manhole" }, { "name": "Headwall", "code": "Headwall" }, { "name": "Half Height Headwall", "code": "Half Height Headwall" }, { "name": "Stand Pipe", "code": "Stand Pipe" }, { "name": "Pipe end - daylight-open", "code": "Pipe end - daylight-open" }, { "name": "Inlet", "code": "Inlet" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "length": 10, "domain": { "type": "codedValue", "name": "D_STATUS", "description": "Asset Status", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Retired", "code": "Retired" }, { "name": "Proposed", "code": "Proposed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "length": 52, "domain": { "type": "codedValue", "name": "D_DSI_PT_MATERIAL", "description": "End Structure Material", "codedValues": [ { "name": "Block", "code": "Block" }, { "name": "Brick", "code": "Brick" }, { "name": "Clay-Vertical Stand Pipe", "code": "Clay-Vertical Stand Pipe" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Concrete-Vertical Stand Pipe", "code": "Concrete-Vertical Stand Pipe" }, { "name": "Corrugated Plastic-Vertical Stand Pipe", "code": "Corrugated Plastic-Vertical Stand Pipe" }, { "name": "Smooth Wall Corrugated Plastic-Vertical Stand Pipe", "code": "Smooth Wall Corrugated Plastic-Vertical Stand Pipe" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SIZE_OF_STRUCTURE", "type": "esriFieldTypeString", "alias": "Size of Structure", "length": 31, "domain": { "type": "codedValue", "name": "D_DSI_PT_SIZE", "description": "Size of structure", "codedValues": [ { "name": "1x1", "code": "1x1" }, { "name": "2x2", "code": "2x2" }, { "name": "3x3", "code": "3x3" }, { "name": "4x4", "code": "4x4" }, { "name": "5x5", "code": "5x5" }, { "name": "6x6", "code": "6x6" }, { "name": "7x7", "code": "7x7" }, { "name": "8x8", "code": "8x8" }, { "name": "9x9", "code": "9x9" }, { "name": "10x10", "code": "10x10" }, { "name": "4\"-10\"", "code": "4\"-10\"" }, { "name": "12\"-18\"", "code": "12\"-18\"" }, { "name": ">24\"", "code": ">24\"" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STRUCTURE_DEPTH", "type": "esriFieldTypeString", "alias": "Depth", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_PT_DEPTH", "description": "Depth of End Structure", "codedValues": [ { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" }, { "name": "5-8", "code": "5-8" }, { "name": ">8", "code": ">8" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INSTALL_YEAR", "type": "esriFieldTypeString", "alias": "Install Year", "length": 8, "domain": null }, { "name": "DATE_LAST_CLEANED", "type": "esriFieldTypeDate", "alias": "Date Last Cleaned", "length": 8, "domain": null }, { "name": "PIPE_TO_THE_NORTH", "type": "esriFieldTypeString", "alias": "Pipe size to the north", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_LN_DIAMETER", "description": "Size of pipe", "codedValues": [ { "name": "96", "code": "96" }, { "name": "84", "code": "84" }, { "name": "78", "code": "78" }, { "name": "72", "code": "72" }, { "name": "66", "code": "66" }, { "name": "60", "code": "60" }, { "name": "54", "code": "54" }, { "name": "48", "code": "48" }, { "name": "42", "code": "42" }, { "name": "36", "code": "36" }, { "name": "33", "code": "33" }, { "name": "30", "code": "30" }, { "name": "27", "code": "27" }, { "name": "24", "code": "24" }, { "name": "21", "code": "21" }, { "name": "20", "code": "20" }, { "name": "18", "code": "18" }, { "name": "15", "code": "15" }, { "name": "12", "code": "12" }, { "name": "10", "code": "10" }, { "name": "08", "code": "08" }, { "name": "06", "code": "06" }, { "name": "04", "code": "04" }, { "name": "120", "code": "120" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAT_N", "type": "esriFieldTypeString", "alias": "Material to north", "length": 50, "domain": { "type": "codedValue", "name": "D_DSI_LN_MATERIAL", "description": "Pipe Material", "codedValues": [ { "name": "Clay", "code": "Clay" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Corrugated Metal", "code": "Corrugated Metal" }, { "name": "Corrugated Plastic", "code": "Corrugated Plastic" }, { "name": "Smooth Wall Corrugated Plastic", "code": "Smooth Wall Corrugated Plastic" }, { "name": "Polyvinyl Chloride/SDR", "code": "Polyvinyl Chloride/SDR" }, { "name": "Unknown", "code": "Unknown" }, { "name": "None", "code": "None" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAT_NE", "type": "esriFieldTypeString", "alias": "Material to northeast", "length": 50, "domain": { "type": "codedValue", "name": "D_DSI_LN_MATERIAL", "description": "Pipe Material", "codedValues": [ { "name": "Clay", "code": "Clay" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Corrugated Metal", "code": "Corrugated Metal" }, { "name": "Corrugated Plastic", "code": "Corrugated Plastic" }, { "name": "Smooth Wall Corrugated Plastic", "code": "Smooth Wall Corrugated Plastic" }, { "name": "Polyvinyl Chloride/SDR", "code": "Polyvinyl Chloride/SDR" }, { "name": "Unknown", "code": "Unknown" }, { "name": "None", "code": "None" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAT_E", "type": "esriFieldTypeString", "alias": "Material to east", "length": 50, "domain": { "type": "codedValue", "name": "D_DSI_LN_MATERIAL", "description": "Pipe Material", "codedValues": [ { "name": "Clay", "code": "Clay" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Corrugated Metal", "code": "Corrugated Metal" }, { "name": "Corrugated Plastic", "code": "Corrugated Plastic" }, { "name": "Smooth Wall Corrugated Plastic", "code": "Smooth Wall Corrugated Plastic" }, { "name": "Polyvinyl Chloride/SDR", "code": "Polyvinyl Chloride/SDR" }, { "name": "Unknown", "code": "Unknown" }, { "name": "None", "code": "None" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAT_SE", "type": "esriFieldTypeString", "alias": "Material to southeast", "length": 50, "domain": { "type": "codedValue", "name": "D_DSI_LN_MATERIAL", "description": "Pipe Material", "codedValues": [ { "name": "Clay", "code": "Clay" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Corrugated Metal", "code": "Corrugated Metal" }, { "name": "Corrugated Plastic", "code": "Corrugated Plastic" }, { "name": "Smooth Wall Corrugated Plastic", "code": "Smooth Wall Corrugated Plastic" }, { "name": "Polyvinyl Chloride/SDR", "code": "Polyvinyl Chloride/SDR" }, { "name": "Unknown", "code": "Unknown" }, { "name": "None", "code": "None" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAT_S", "type": "esriFieldTypeString", "alias": "Material to south", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_LN_MATERIAL", "description": "Pipe Material", "codedValues": [ { "name": "Clay", "code": "Clay" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Corrugated Metal", "code": "Corrugated Metal" }, { "name": "Corrugated Plastic", "code": "Corrugated Plastic" }, { "name": "Smooth Wall Corrugated Plastic", "code": "Smooth Wall Corrugated Plastic" }, { "name": "Polyvinyl Chloride/SDR", "code": "Polyvinyl Chloride/SDR" }, { "name": "Unknown", "code": "Unknown" }, { "name": "None", "code": "None" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAT_SW", "type": "esriFieldTypeString", "alias": "Material to southwest", "length": 50, "domain": { "type": "codedValue", "name": "D_DSI_LN_MATERIAL", "description": "Pipe Material", "codedValues": [ { "name": "Clay", "code": "Clay" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Corrugated Metal", "code": "Corrugated Metal" }, { "name": "Corrugated Plastic", "code": "Corrugated Plastic" }, { "name": "Smooth Wall Corrugated Plastic", "code": "Smooth Wall Corrugated Plastic" }, { "name": "Polyvinyl Chloride/SDR", "code": "Polyvinyl Chloride/SDR" }, { "name": "Unknown", "code": "Unknown" }, { "name": "None", "code": "None" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAT_W", "type": "esriFieldTypeString", "alias": "Material to west", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_LN_MATERIAL", "description": "Pipe Material", "codedValues": [ { "name": "Clay", "code": "Clay" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Corrugated Metal", "code": "Corrugated Metal" }, { "name": "Corrugated Plastic", "code": "Corrugated Plastic" }, { "name": "Smooth Wall Corrugated Plastic", "code": "Smooth Wall Corrugated Plastic" }, { "name": "Polyvinyl Chloride/SDR", "code": "Polyvinyl Chloride/SDR" }, { "name": "Unknown", "code": "Unknown" }, { "name": "None", "code": "None" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAT_NW", "type": "esriFieldTypeString", "alias": "Material to northwest", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_LN_MATERIAL", "description": "Pipe Material", "codedValues": [ { "name": "Clay", "code": "Clay" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Corrugated Metal", "code": "Corrugated Metal" }, { "name": "Corrugated Plastic", "code": "Corrugated Plastic" }, { "name": "Smooth Wall Corrugated Plastic", "code": "Smooth Wall Corrugated Plastic" }, { "name": "Polyvinyl Chloride/SDR", "code": "Polyvinyl Chloride/SDR" }, { "name": "Unknown", "code": "Unknown" }, { "name": "None", "code": "None" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMMENT", "type": "esriFieldTypeString", "alias": "Comment", "length": 1000, "domain": null }, { "name": "SOURCE", "type": "esriFieldTypeString", "alias": "Source", "length": 50, "domain": { "type": "codedValue", "name": "D_DSI_SOURCE", "description": "Source of data", "codedValues": [ { "name": "Field Verified", "code": "Field Verified" }, { "name": "Plan Set", "code": "Plan Set" }, { "name": "Survey Data", "code": "Survey Data" }, { "name": "Unknown", "code": "Unknown" }, { "name": "County Knowledge", "code": "County Knowledge" }, { "name": "Aerial Imagery", "code": "Aerial Imagery" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COUNTY_RESPON", "type": "esriFieldTypeString", "alias": "County Responsible", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_D2_COUNTY_RESP", "description": "Lets us assign a county to the maintenance of the asset due to NOP being included in county maintenance and not being a selectable county in our other domains", "codedValues": [ { "name": "Fulton", "code": "Fulton" }, { "name": "Henry", "code": "Henry" }, { "name": "Lucas", "code": "Lucas" }, { "name": "Northwood", "code": "Northwood" }, { "name": "Ottawa", "code": "Ottawa" }, { "name": "Sandusky", "code": "Sandusky" }, { "name": "Seneca", "code": "Seneca" }, { "name": "Williams", "code": "Williams" }, { "name": "Wood", "code": "Wood" }, { "name": "Defiance", "code": "Defiance" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAINTENANCE_RESPONSIBILITY", "type": "esriFieldTypeString", "alias": "Maintenance Responsible", "length": 15, "domain": { "type": "codedValue", "name": "D_DSI_MAINTRESPON", "description": "Who is responsible for the item", "codedValues": [ { "name": "ODOT", "code": "ODOT" }, { "name": "County", "code": "County" }, { "name": "City", "code": "City" }, { "name": "Township", "code": "Township" }, { "name": "Village", "code": "Village" }, { "name": "ODNR", "code": "ODNR" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ASSOC_W_UNDR_DR", "type": "esriFieldTypeString", "alias": "Associated with Underdrain", "length": 255, "domain": { "type": "codedValue", "name": "D_YESNO", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ASSOC_W_CULVE", "type": "esriFieldTypeString", "alias": "Associated with Culvert", "length": 255, "domain": { "type": "codedValue", "name": "D_YESNO", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RISER", "type": "esriFieldTypeString", "alias": "Riser", "length": 8, "domain": { "type": "codedValue", "name": "D_YESNULL", "description": "Yes", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RISER1", "type": "esriFieldTypeString", "alias": "Riser 1", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_PT_RISER", "description": "Riser yes or no with sizes", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes - 4\"", "code": "Yes - 4\"" }, { "name": "Yes - 6\"", "code": "Yes - 6\"" }, { "name": "Yes - 12\"", "code": "Yes - 12\"" }, { "name": "Slant Top", "code": "Slant Top" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RISER2", "type": "esriFieldTypeString", "alias": "Riser 2", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_PT_RISER", "description": "Riser yes or no with sizes", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes - 4\"", "code": "Yes - 4\"" }, { "name": "Yes - 6\"", "code": "Yes - 6\"" }, { "name": "Yes - 12\"", "code": "Yes - 12\"" }, { "name": "Slant Top", "code": "Slant Top" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RISER3", "type": "esriFieldTypeString", "alias": "Riser 3", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_PT_RISER", "description": "Riser yes or no with sizes", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes - 4\"", "code": "Yes - 4\"" }, { "name": "Yes - 6\"", "code": "Yes - 6\"" }, { "name": "Yes - 12\"", "code": "Yes - 12\"" }, { "name": "Slant Top", "code": "Slant Top" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GRATE_CLEANING", "type": "esriFieldTypeString", "alias": "Grate Cleaning", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_GRATE_COND", "description": "Grate cleaning and maintenance needed", "codedValues": [ { "name": "Grate was cleaned", "code": "Grate was cleaned" }, { "name": "Grate needs cleaned", "code": "Grate needs cleaned" }, { "name": "Maintenance needed", "code": "Maintenance needed" }, { "name": "Maintenance complete", "code": "Maintenance complete" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "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": "sys_updated_date", "type": "esriFieldTypeDate", "alias": "sys_updated_date", "length": 8, "domain": null }, { "name": "CTL_BEGIN_NBR", "type": "esriFieldTypeDouble", "alias": "CTL_BEGIN_NBR", "domain": null }, { "name": "LATITUDE_DD_BEGIN", "type": "esriFieldTypeDouble", "alias": "LATITUDE_DD_BEGIN", "domain": null }, { "name": "LONGITUDE_DD_BEGIN", "type": "esriFieldTypeDouble", "alias": "LONGITUDE_DD_BEGIN", "domain": null }, { "name": "STL_BEGIN_NBR", "type": "esriFieldTypeDouble", "alias": "STL_BEGIN_NBR", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PIPE_TO_THE_NORTH_EAST", "type": "esriFieldTypeString", "alias": "Pipe size to the northeast", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_LN_DIAMETER", "description": "Size of pipe", "codedValues": [ { "name": "96", "code": "96" }, { "name": "84", "code": "84" }, { "name": "78", "code": "78" }, { "name": "72", "code": "72" }, { "name": "66", "code": "66" }, { "name": "60", "code": "60" }, { "name": "54", "code": "54" }, { "name": "48", "code": "48" }, { "name": "42", "code": "42" }, { "name": "36", "code": "36" }, { "name": "33", "code": "33" }, { "name": "30", "code": "30" }, { "name": "27", "code": "27" }, { "name": "24", "code": "24" }, { "name": "21", "code": "21" }, { "name": "20", "code": "20" }, { "name": "18", "code": "18" }, { "name": "15", "code": "15" }, { "name": "12", "code": "12" }, { "name": "10", "code": "10" }, { "name": "08", "code": "08" }, { "name": "06", "code": "06" }, { "name": "04", "code": "04" }, { "name": "120", "code": "120" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PIPE_TO_THE_EAST", "type": "esriFieldTypeString", "alias": "Pipe size to the east", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_LN_DIAMETER", "description": "Size of pipe", "codedValues": [ { "name": "96", "code": "96" }, { "name": "84", "code": "84" }, { "name": "78", "code": "78" }, { "name": "72", "code": "72" }, { "name": "66", "code": "66" }, { "name": "60", "code": "60" }, { "name": "54", "code": "54" }, { "name": "48", "code": "48" }, { "name": "42", "code": "42" }, { "name": "36", "code": "36" }, { "name": "33", "code": "33" }, { "name": "30", "code": "30" }, { "name": "27", "code": "27" }, { "name": "24", "code": "24" }, { "name": "21", "code": "21" }, { "name": "20", "code": "20" }, { "name": "18", "code": "18" }, { "name": "15", "code": "15" }, { "name": "12", "code": "12" }, { "name": "10", "code": "10" }, { "name": "08", "code": "08" }, { "name": "06", "code": "06" }, { "name": "04", "code": "04" }, { "name": "120", "code": "120" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PIPE_TO_THE_SOUTH_EAST", "type": "esriFieldTypeString", "alias": "Pipe size to the southeast", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_LN_DIAMETER", "description": "Size of pipe", "codedValues": [ { "name": "96", "code": "96" }, { "name": "84", "code": "84" }, { "name": "78", "code": "78" }, { "name": "72", "code": "72" }, { "name": "66", "code": "66" }, { "name": "60", "code": "60" }, { "name": "54", "code": "54" }, { "name": "48", "code": "48" }, { "name": "42", "code": "42" }, { "name": "36", "code": "36" }, { "name": "33", "code": "33" }, { "name": "30", "code": "30" }, { "name": "27", "code": "27" }, { "name": "24", "code": "24" }, { "name": "21", "code": "21" }, { "name": "20", "code": "20" }, { "name": "18", "code": "18" }, { "name": "15", "code": "15" }, { "name": "12", "code": "12" }, { "name": "10", "code": "10" }, { "name": "08", "code": "08" }, { "name": "06", "code": "06" }, { "name": "04", "code": "04" }, { "name": "120", "code": "120" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PIPE_TO_THE_SOUTH", "type": "esriFieldTypeString", "alias": "Pipe size to the south", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_LN_DIAMETER", "description": "Size of pipe", "codedValues": [ { "name": "96", "code": "96" }, { "name": "84", "code": "84" }, { "name": "78", "code": "78" }, { "name": "72", "code": "72" }, { "name": "66", "code": "66" }, { "name": "60", "code": "60" }, { "name": "54", "code": "54" }, { "name": "48", "code": "48" }, { "name": "42", "code": "42" }, { "name": "36", "code": "36" }, { "name": "33", "code": "33" }, { "name": "30", "code": "30" }, { "name": "27", "code": "27" }, { "name": "24", "code": "24" }, { "name": "21", "code": "21" }, { "name": "20", "code": "20" }, { "name": "18", "code": "18" }, { "name": "15", "code": "15" }, { "name": "12", "code": "12" }, { "name": "10", "code": "10" }, { "name": "08", "code": "08" }, { "name": "06", "code": "06" }, { "name": "04", "code": "04" }, { "name": "120", "code": "120" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PIPE_TO_THE_SOUTH_WEST", "type": "esriFieldTypeString", "alias": "Pipe size to the southwest", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_LN_DIAMETER", "description": "Size of pipe", "codedValues": [ { "name": "96", "code": "96" }, { "name": "84", "code": "84" }, { "name": "78", "code": "78" }, { "name": "72", "code": "72" }, { "name": "66", "code": "66" }, { "name": "60", "code": "60" }, { "name": "54", "code": "54" }, { "name": "48", "code": "48" }, { "name": "42", "code": "42" }, { "name": "36", "code": "36" }, { "name": "33", "code": "33" }, { "name": "30", "code": "30" }, { "name": "27", "code": "27" }, { "name": "24", "code": "24" }, { "name": "21", "code": "21" }, { "name": "20", "code": "20" }, { "name": "18", "code": "18" }, { "name": "15", "code": "15" }, { "name": "12", "code": "12" }, { "name": "10", "code": "10" }, { "name": "08", "code": "08" }, { "name": "06", "code": "06" }, { "name": "04", "code": "04" }, { "name": "120", "code": "120" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PIPE_TO_THE_WEST", "type": "esriFieldTypeString", "alias": "Pipe size to the west", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_LN_DIAMETER", "description": "Size of pipe", "codedValues": [ { "name": "96", "code": "96" }, { "name": "84", "code": "84" }, { "name": "78", "code": "78" }, { "name": "72", "code": "72" }, { "name": "66", "code": "66" }, { "name": "60", "code": "60" }, { "name": "54", "code": "54" }, { "name": "48", "code": "48" }, { "name": "42", "code": "42" }, { "name": "36", "code": "36" }, { "name": "33", "code": "33" }, { "name": "30", "code": "30" }, { "name": "27", "code": "27" }, { "name": "24", "code": "24" }, { "name": "21", "code": "21" }, { "name": "20", "code": "20" }, { "name": "18", "code": "18" }, { "name": "15", "code": "15" }, { "name": "12", "code": "12" }, { "name": "10", "code": "10" }, { "name": "08", "code": "08" }, { "name": "06", "code": "06" }, { "name": "04", "code": "04" }, { "name": "120", "code": "120" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PIPE_TO_THE_NORTH_WEST", "type": "esriFieldTypeString", "alias": "Pipe size to the northwest", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_LN_DIAMETER", "description": "Size of pipe", "codedValues": [ { "name": "96", "code": "96" }, { "name": "84", "code": "84" }, { "name": "78", "code": "78" }, { "name": "72", "code": "72" }, { "name": "66", "code": "66" }, { "name": "60", "code": "60" }, { "name": "54", "code": "54" }, { "name": "48", "code": "48" }, { "name": "42", "code": "42" }, { "name": "36", "code": "36" }, { "name": "33", "code": "33" }, { "name": "30", "code": "30" }, { "name": "27", "code": "27" }, { "name": "24", "code": "24" }, { "name": "21", "code": "21" }, { "name": "20", "code": "20" }, { "name": "18", "code": "18" }, { "name": "15", "code": "15" }, { "name": "12", "code": "12" }, { "name": "10", "code": "10" }, { "name": "08", "code": "08" }, { "name": "06", "code": "06" }, { "name": "04", "code": "04" }, { "name": "120", "code": "120" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NEED_MAINTENANCE", "type": "esriFieldTypeString", "alias": "Needs Maintenance", "length": 255, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "UUID_309", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "gdb_ct3_309", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S145_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "TAMCOLLECTOR.DSI_ENDSTRUCTURE_DATELASTCLEANED", "relatedTableId": 9, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{5EB60B92-A109-49EB-B584-2169353AE624}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": 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, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1748964362000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 5, "name": "Storm Mains - Not State", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 2, "mTolerance": 2, "falseX": -20037700, "falseY": -30241100, "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": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 0, 0, 255 ], "width": 4 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": -9436473.2564, "ymin": 4962092.380999997, "xmax": -9072001.6037, "ymax": 5120487.395800002, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "STATUS", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "length": 10, "domain": { "type": "codedValue", "name": "D_STATUS", "description": "Asset Status", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Retired", "code": "Retired" }, { "name": "Proposed", "code": "Proposed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DIAMETER", "type": "esriFieldTypeString", "alias": "Diameter", "length": 8, "domain": { "type": "codedValue", "name": "D_DSI_LN_DIAMETER", "description": "Size of pipe", "codedValues": [ { "name": "96", "code": "96" }, { "name": "84", "code": "84" }, { "name": "78", "code": "78" }, { "name": "72", "code": "72" }, { "name": "66", "code": "66" }, { "name": "60", "code": "60" }, { "name": "54", "code": "54" }, { "name": "48", "code": "48" }, { "name": "42", "code": "42" }, { "name": "36", "code": "36" }, { "name": "33", "code": "33" }, { "name": "30", "code": "30" }, { "name": "27", "code": "27" }, { "name": "24", "code": "24" }, { "name": "21", "code": "21" }, { "name": "20", "code": "20" }, { "name": "18", "code": "18" }, { "name": "15", "code": "15" }, { "name": "12", "code": "12" }, { "name": "10", "code": "10" }, { "name": "08", "code": "08" }, { "name": "06", "code": "06" }, { "name": "04", "code": "04" }, { "name": "120", "code": "120" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHAPE_OF_PIPE", "type": "esriFieldTypeString", "alias": "Shape Of Pipe", "length": 31, "domain": { "type": "codedValue", "name": "D_DSI_LN_SHAPE", "description": "Shape of main", "codedValues": [ { "name": "Circular", "code": "Circular" }, { "name": "Elliptical-Horizontal", "code": "Elliptical-Horizontal" }, { "name": "Elliptical-Vertical", "code": "Elliptical-Vertical" }, { "name": "Other(twin pipe, box, slab top)", "code": "Other(twin pipe, box, slab top)" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "length": 52, "domain": { "type": "codedValue", "name": "D_DSI_LN_MATERIAL", "description": "Pipe Material", "codedValues": [ { "name": "Clay", "code": "Clay" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Corrugated Metal", "code": "Corrugated Metal" }, { "name": "Corrugated Plastic", "code": "Corrugated Plastic" }, { "name": "Smooth Wall Corrugated Plastic", "code": "Smooth Wall Corrugated Plastic" }, { "name": "Polyvinyl Chloride/SDR", "code": "Polyvinyl Chloride/SDR" }, { "name": "Unknown", "code": "Unknown" }, { "name": "None", "code": "None" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INSTALL_YEAR", "type": "esriFieldTypeString", "alias": "Install Year", "length": 8, "domain": null }, { "name": "DATE_LAST_CLEANED", "type": "esriFieldTypeDate", "alias": "Date Last Cleaned", "length": 8, "domain": null }, { "name": "COMMENT", "type": "esriFieldTypeString", "alias": "Comment", "length": 1000, "domain": null }, { "name": "REPLACE", "type": "esriFieldTypeString", "alias": "Replace", "length": 8, "domain": { "type": "codedValue", "name": "D_YESNULL", "description": "Yes", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REPAIR", "type": "esriFieldTypeString", "alias": "Repair", "length": 8, "domain": { "type": "codedValue", "name": "D_YESNULL", "description": "Yes", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAINTENANCE_RESPONSIBILITY", "type": "esriFieldTypeString", "alias": "Maintenance Responsibility", "length": 15, "domain": { "type": "codedValue", "name": "D_DSI_MAINTRESPON", "description": "Who is responsible for the item", "codedValues": [ { "name": "ODOT", "code": "ODOT" }, { "name": "County", "code": "County" }, { "name": "City", "code": "City" }, { "name": "Township", "code": "Township" }, { "name": "Village", "code": "Village" }, { "name": "ODNR", "code": "ODNR" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LET_PLANS_URL", "type": "esriFieldTypeString", "alias": "URL", "length": 150, "domain": null }, { "name": "STORM_MAIN_FILE_NUMBER", "type": "esriFieldTypeString", "alias": "SMFN", "length": 11, "domain": null }, { "name": "ODOT_DISTRICT", "type": "esriFieldTypeString", "alias": "District", "length": 2, "domain": null }, { "name": "COUNTY", "type": "esriFieldTypeString", "alias": "County", "length": 10, "domain": null }, { "name": "ROUTE_TYPE", "type": "esriFieldTypeString", "alias": "Route Type", "length": 2, "domain": null }, { "name": "ROUTE_NBR", "type": "esriFieldTypeString", "alias": "Route Number", "length": 5, "domain": null }, { "name": "ROUTE_SUFFIX", "type": "esriFieldTypeString", "alias": "Route Suffix", "length": 1, "domain": null }, { "name": "CTL_BEGIN_NBR", "type": "esriFieldTypeDouble", "alias": "CTL Begin Number", "domain": null }, { "name": "CTL_END_NBR", "type": "esriFieldTypeDouble", "alias": "CTL End Number", "domain": null }, { "name": "STL_BEGIN_NBR", "type": "esriFieldTypeDouble", "alias": "STL Begin Number", "domain": null }, { "name": "STL_END_NBR", "type": "esriFieldTypeDouble", "alias": "STL End Number", "domain": null }, { "name": "LATITUDE_DD_BEGIN", "type": "esriFieldTypeDouble", "alias": "Latitude DD Begin", "domain": null }, { "name": "LONGITUDE_DD_BEGIN", "type": "esriFieldTypeDouble", "alias": "Longitude DD Begin", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "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": "FITTING_ON_TILE", "type": "esriFieldTypeString", "alias": "Fitting on Tile", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_FITTING", "description": "Type of fitting on tile", "codedValues": [ { "name": "Tee", "code": "Tee" }, { "name": "Pipe Guard (aminal guard)", "code": "Pipe Guard" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "KNOWN_FLOW", "type": "esriFieldTypeString", "alias": "Flow Direction Known", "length": 255, "domain": { "type": "codedValue", "name": "D_YESNULL", "description": "Yes", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SOURCE", "type": "esriFieldTypeString", "alias": "Source", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_SOURCE", "description": "Source of data", "codedValues": [ { "name": "Field Verified", "code": "Field Verified" }, { "name": "Plan Set", "code": "Plan Set" }, { "name": "Survey Data", "code": "Survey Data" }, { "name": "Unknown", "code": "Unknown" }, { "name": "County Knowledge", "code": "County Knowledge" }, { "name": "Aerial Imagery", "code": "Aerial Imagery" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COUNTY_RESPON", "type": "esriFieldTypeString", "alias": "County Responsible", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_D2_COUNTY_RESP", "description": "Lets us assign a county to the maintenance of the asset due to NOP being included in county maintenance and not being a selectable county in our other domains", "codedValues": [ { "name": "Fulton", "code": "Fulton" }, { "name": "Henry", "code": "Henry" }, { "name": "Lucas", "code": "Lucas" }, { "name": "Northwood", "code": "Northwood" }, { "name": "Ottawa", "code": "Ottawa" }, { "name": "Sandusky", "code": "Sandusky" }, { "name": "Seneca", "code": "Seneca" }, { "name": "Williams", "code": "Williams" }, { "name": "Wood", "code": "Wood" }, { "name": "Defiance", "code": "Defiance" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSOC_W_UNDR_DRN", "type": "esriFieldTypeString", "alias": "Associated with underdrain", "length": 255, "domain": { "type": "codedValue", "name": "D_YESNO", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ASSOC_W_CULVE", "type": "esriFieldTypeString", "alias": "Associated with culvert", "length": 255, "domain": { "type": "codedValue", "name": "D_YESNO", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CRS", "type": "esriFieldTypeString", "alias": "CRS", "length": 17, "domain": null }, { "name": "NLF_ID", "type": "esriFieldTypeString", "alias": "NLF_ID", "length": 14, "domain": null }, { "name": "sys_updated_date", "type": "esriFieldTypeDate", "alias": "sys_updated_date", "length": 8, "domain": null }, { "name": "COUNTY_CD", "type": "esriFieldTypeString", "alias": "COUNTY_CD", "length": 3, "domain": null }, { "name": "NEED_MAINTENANCE", "type": "esriFieldTypeString", "alias": "Needs Maintenance", "length": 255, "domain": null }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "Type", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_STM_MAIN_TYPE", "description": "Storm Main Type", "codedValues": [ { "name": "Storm Main", "code": "Storm Main" }, { "name": "Underdrain", "code": "Underdrain" }, { "name": "Culvert", "code": "Culvert" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LENGTH_OF_PIPE", "type": "esriFieldTypeDouble", "alias": "Length of Pipe", "domain": null }, { "name": "SLOPE_OF_PIPE", "type": "esriFieldTypeDouble", "alias": "Slope of Pipe", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "UUID_183", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "gdb_ct3_183", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S84_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "TAMCOLLECTOR.DSI_STORMMAIN_DATELASTCLEANED", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{3ABC42D2-DD89-4C62-BF11-5BA7A03511FC}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape.STLength()", "units": "esriMeters", "mapUnits": {"uwkid": 9001} }, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645120918000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 11, "name": "Ditches - Not State", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 2, "mTolerance": 2, "falseX": -20037700, "falseY": -30241100, "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": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 127, 127, 255 ], "width": 4 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": -9423594.6462, "ymin": 5021872.262400001, "xmax": -9072142.3115, "ymax": 5132314.279299997, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "TYPE", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "TYPE", "type": "esriFieldTypeString", "alias": "Type", "length": 20, "domain": { "type": "codedValue", "name": "D_DSI_DITCH_TYPE", "description": "Type of ditch", "codedValues": [ { "name": "V Ditch", "code": "V Ditch" }, { "name": "Rounded Ditch", "code": "Rounded Ditch" }, { "name": "Flat Bottom", "code": "Flat Bottom" }, { "name": "Rounded/Flat Bottom", "code": "Rounded/Flat Bottom" }, { "name": "Swale", "code": "Swale" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "length": 10, "domain": { "type": "codedValue", "name": "D_STATUS", "description": "Asset Status", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Retired", "code": "Retired" }, { "name": "Proposed", "code": "Proposed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DATE_LAST_CLEANED", "type": "esriFieldTypeDate", "alias": "Date Last Cleaned", "length": 8, "domain": null }, { "name": "MAINTENANCE_RESPONSIBILITY", "type": "esriFieldTypeString", "alias": "Maintenance Responsibility", "length": 15, "domain": { "type": "codedValue", "name": "D_DSI_MAINTRESPON", "description": "Who is responsible for the item", "codedValues": [ { "name": "ODOT", "code": "ODOT" }, { "name": "County", "code": "County" }, { "name": "City", "code": "City" }, { "name": "Township", "code": "Township" }, { "name": "Village", "code": "Village" }, { "name": "ODNR", "code": "ODNR" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INSTALL_YEAR", "type": "esriFieldTypeString", "alias": "Install Year", "length": 8, "domain": null }, { "name": "FLOW_DIRECTION", "type": "esriFieldTypeString", "alias": "Flow Direction", "length": 2, "domain": { "type": "codedValue", "name": "D_GEO_DIRECTION", "description": "D_GEO_DIRECTION", "codedValues": [ { "name": "North", "code": "N" }, { "name": "South", "code": "S" }, { "name": "East", "code": "E" }, { "name": "West", "code": "W" }, { "name": "Northeast", "code": "NE" }, { "name": "Northwest", "code": "NW" }, { "name": "Southeast", "code": "SE" }, { "name": "Southwest", "code": "SW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LET_PLANS_URL", "type": "esriFieldTypeString", "alias": "URL", "length": 150, "domain": null }, { "name": "COMMENT", "type": "esriFieldTypeString", "alias": "Comment", "length": 1000, "domain": null }, { "name": "DITCH_FILE_NUMBER", "type": "esriFieldTypeString", "alias": "DFN", "length": 11, "domain": null }, { "name": "ODOT_DISTRICT", "type": "esriFieldTypeString", "alias": "District", "length": 2, "domain": { "type": "codedValue", "name": "D_DSI_DISTRICT", "description": "District Number", "codedValues": [ { "name": "01", "code": "01" }, { "name": "02", "code": "02" }, { "name": "03", "code": "03" }, { "name": "04", "code": "04" }, { "name": "05", "code": "05" }, { "name": "06", "code": "06" }, { "name": "07", "code": "07" }, { "name": "08", "code": "08" }, { "name": "09", "code": "09" }, { "name": "10", "code": "10" }, { "name": "11", "code": "11" }, { "name": "12", "code": "12" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COUNTY", "type": "esriFieldTypeString", "alias": "County", "length": 10, "domain": null }, { "name": "ROUTE_TYPE", "type": "esriFieldTypeString", "alias": "Route Type", "length": 2, "domain": null }, { "name": "ROUTE_NBR", "type": "esriFieldTypeString", "alias": "Route Number", "length": 5, "domain": null }, { "name": "ROUTE_SUFFIX", "type": "esriFieldTypeString", "alias": "Route Suffix", "length": 1, "domain": null }, { "name": "CTL_BEGIN_NBR", "type": "esriFieldTypeDouble", "alias": "CTL Begin Number", "domain": null }, { "name": "CTL_END_NBR", "type": "esriFieldTypeDouble", "alias": "CTL End Number", "domain": null }, { "name": "STL_BEGIN_NBR", "type": "esriFieldTypeDouble", "alias": "STL Begin Number", "domain": null }, { "name": "STL_END_NBR", "type": "esriFieldTypeDouble", "alias": "STL End Number", "domain": null }, { "name": "LATITUDE_DD_BEGIN", "type": "esriFieldTypeDouble", "alias": "Latitude DD Begin", "domain": null }, { "name": "LONGITUDE_DD_BEGIN", "type": "esriFieldTypeDouble", "alias": "Longitude DD Begin", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "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": "SOURCE", "type": "esriFieldTypeString", "alias": "Source", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_SOURCE", "description": "Source of data", "codedValues": [ { "name": "Field Verified", "code": "Field Verified" }, { "name": "Plan Set", "code": "Plan Set" }, { "name": "Survey Data", "code": "Survey Data" }, { "name": "Unknown", "code": "Unknown" }, { "name": "County Knowledge", "code": "County Knowledge" }, { "name": "Aerial Imagery", "code": "Aerial Imagery" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "KNOWN_FLOW", "type": "esriFieldTypeString", "alias": "Flow Direction Known", "length": 255, "domain": { "type": "codedValue", "name": "D_YESNULL", "description": "Yes", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COUNTY_RESPON", "type": "esriFieldTypeString", "alias": "County Responsible", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_D2_COUNTY_RESP", "description": "Lets us assign a county to the maintenance of the asset due to NOP being included in county maintenance and not being a selectable county in our other domains", "codedValues": [ { "name": "Fulton", "code": "Fulton" }, { "name": "Henry", "code": "Henry" }, { "name": "Lucas", "code": "Lucas" }, { "name": "Northwood", "code": "Northwood" }, { "name": "Ottawa", "code": "Ottawa" }, { "name": "Sandusky", "code": "Sandusky" }, { "name": "Seneca", "code": "Seneca" }, { "name": "Williams", "code": "Williams" }, { "name": "Wood", "code": "Wood" }, { "name": "Defiance", "code": "Defiance" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "INVENTORY_INITIALS", "type": "esriFieldTypeString", "alias": "Initials of person inputting data", "length": 255, "domain": null }, { "name": "CRS", "type": "esriFieldTypeString", "alias": "CRS", "length": 17, "domain": null }, { "name": "NLF_ID", "type": "esriFieldTypeString", "alias": "NLF_ID", "length": 14, "domain": null }, { "name": "sys_updated_date", "type": "esriFieldTypeDate", "alias": "sys_updated_date", "length": 8, "domain": null }, { "name": "COUNTY_CD", "type": "esriFieldTypeString", "alias": "COUNTY_CD", "length": 3, "domain": null }, { "name": "NEED_MAINTENANCE", "type": "esriFieldTypeString", "alias": "Needs Maintenance", "length": 255, "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "UUID_184", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "gdb_ct3_184", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S85_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "TAMCOLLECTOR.DSI_DITCH_DATELASTCLEANED", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{7B641389-1D5D-457D-8C44-5809090D56C3}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape.STLength()", "units": "esriMeters", "mapUnits": {"uwkid": 9001} }, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645120492000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 8, "name": "Ditch Date Last Cleaned ", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "DATELASTCLEANED", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "DATELASTCLEANED", "type": "esriFieldTypeDate", "alias": "Date last cleaned", "length": 8, "domain": null }, { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "length": 38, "domain": null }, { "name": "COMMENT", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "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": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "UUID_239", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "gdb_ct3_239", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_4193_REL_GLO", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "TAMCOLLECTOR.DSI_DITCH", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "REL_GLOBALID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{7B641389-1D5D-457D-8C44-5809090D56C3}" }, { "id": 5, "name": "TAMCOLLECTOR.DSI_DITCH", "relatedTableId": 11, "role": "esriRelRoleDestination", "keyField": "REL_GLOBALID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{7B641389-1D5D-457D-8C44-5809090D56C3}" } ], "capabilities": "Map,Query,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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1660237222000 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 9, "name": "End Structure Date Last Cleaned", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "DATE_LAST_CLEANED_VAC", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "DATE_LAST_CLEANED_VAC", "type": "esriFieldTypeDate", "alias": "Date Last Cleaned with Vactor", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "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": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "REL GLOBALID", "length": 38, "domain": null }, { "name": "GRATE_CLEANING_DATE", "type": "esriFieldTypeDate", "alias": "Grate Cleaning Date", "length": 8, "domain": null }, { "name": "GRATE_CLEAN_EMPLOYEE", "type": "esriFieldTypeString", "alias": "Employee who cleaned grate", "length": 255, "domain": { "type": "codedValue", "name": "D_DSI_NOP_NAMES", "description": "Names from NOP", "codedValues": [ { "name": "Mike Sass", "code": "Mike Sass" }, { "name": "John Paul", "code": "John Paul" }, { "name": "Cody Alt", "code": "Cody Alt" }, { "name": "Mark Weber", "code": "Mark Weber" }, { "name": "Tom Morris", "code": "Tom Morris" }, { "name": "Don Shinaver", "code": "Don Shinaver" }, { "name": "Mary Rich", "code": "Mary Rich" }, { "name": "Dan Taylor", "code": "Dan Taylor" }, { "name": "Jerry Stutts", "code": "Jerry Stutts" }, { "name": "Mike Roberts", "code": "Mike Roberts" }, { "name": "Matt Rosenbrook", "code": "Matt Rosenbrook" }, { "name": "Dan Marlowe", "code": "Dan Marlowe" }, { "name": "Sam Ellithorp", "code": "Sam Ellithorp" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "UUID_234", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "gdb_ct3_234", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_3786_REL_GLO", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "TAMCOLLECTOR.DSI_ENDSTRUCTURE", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "REL_GLOBALID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{5EB60B92-A109-49EB-B584-2169353AE624}" }, { "id": 3, "name": "TAMCOLLECTOR.DSI_ENDSTRUCTURE", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "REL_GLOBALID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{5EB60B92-A109-49EB-B584-2169353AE624}" } ], "capabilities": "Map,Query,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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1660224678000 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 10, "name": "Storm Mains Date Last Cleaned", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "COMMENTS", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "length": 38, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "DATELASTCLEANED", "type": "esriFieldTypeDate", "alias": "Date last cleaned", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "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": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "UUID_238", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "gdb_ct3_238", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_4192_REL_GLO", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "TAMCOLLECTOR.DSI_STORMMAIN", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "REL_GLOBALID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{3ABC42D2-DD89-4C62-BF11-5BA7A03511FC}" }, { "id": 4, "name": "TAMCOLLECTOR.DSI_STORMMAIN", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "REL_GLOBALID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{3ABC42D2-DD89-4C62-BF11-5BA7A03511FC}" } ], "capabilities": "Map,Query,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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1660237533000 } } ] }