{
"layers": [
{
"currentVersion": 11.3,
"cimVersion": "3.3.0",
"id": 0,
"name": "Maintenance Needed",
"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": "esriPMS",
"url": "278a3b0901eef6104518d4bc3df4d3ba",
"imageData": "iVBORw0KGgoAAAANSUhEUgAAACIAAAAiCAYAAAA6RwvCAAAACXBIWXMAAA7EAAAOxAGVKw4bAAADU0lEQVRYhdWYPW/aUBSGzzXQABtMtTslTG2yuVPVLpXapbhdIhKHnfyN8DPq3SGxWBrUpZW6tOpUtnwsTTLVzlKsLCEqim/13mDLENtxElylr4QwYHMfn3s+XsjTPVGe7ony9L+DmJal5iincu4p/nucWJ8zz242Gv1MQUzLUiXONEZSnXOucuJExILPccS4RJvbXYdx6hEftXVdt2cGYgLAYxvEWb1UKpIiy1QqlUhRHlK1UgnOGw7PyXYcOjw8lgeu2yJWaHW2ukYaoHwaCMalHjGSawvzVKvNTyweFiDFOQvz4vXu3gHt7u23OCtopmVpSVuWCLK53dUYpx0svLT4mBRFppvo8pqH9PXbd3k4PP9hWtbTOJh8ciRIQLx4/kzcrS/Pc0iS0kHh+nfaG/r0+QsNXDcWJp+0HdUICGgw0Khcbonj0agvjgsFNRHo9auXAua36/aISEkFIiExGckI7TSEr9PT9eD47MygXE6hubl6ELFKZefKNbipD72Pcmer+15fXV5PBDEtS0V1IOFukhMXF7YAggCVlMyHR8ct07KM8BZdAZE408QFtcvMn7WWFp8AhNAMiSgehJFUR5+IK9G7yo/Kz6PjDSIyIkFMy1LRMdGsstQjRUZU5E6no/iNbgIkh9lBXNR+liqOC4DlHtT9qEyAcDHAWGbb4ivq+289fcvlVtA/UC14oKeEy/g6hSf3rUGKRS1oYj5UWmE4Tmtya4j12fjEuEY2S2G9aBDm2fATGOX+BM1C+H5/vUiQZqPRh6mBn8gS5JftwFI5iZ2VceoJU5ORBq5Ltu2IdcLvX01WPmrDWcHUYOjNWrZ9Ip49yTMSQXRdt2Hv4KymreAsorG7t48sNZork54kunz5qA17B2cFUzM7iANicPr8T3v680gQXddteEzYO5gZmJqwqtXerSCQG5yovRZhpGMbWrPR6MPWwd4BJuzU0trECIi3ayvLkXeR2FmbYxjYOzgrlDT8RJpmd1kdJyInxHYgEjEQ14JA41pXYO/grGBqAIRRjinqJ7PfttGs0CcQASFOBnIiajvCSj1r9NXlddg7WAWYGviJuHPRrNAnUKLT1XFnkFB08DBgasZ+Ipii/+y3L4U0dlYTTekuujd/S/wFV9mvMuZq7jgAAAAASUVORK5CYII=",
"contentType": "image/png",
"width": 25,
"height": 25,
"angle": 0,
"xoffset": 0,
"yoffset": 0
}
},
"scaleSymbols": true,
"transparency": 0,
"labelingInfo": null
},
"defaultVisibility": false,
"extent": {
"xmin": -9442114.5212,
"ymin": 4637280.771700002,
"xmax": -8963335.3149,
"ymax": 5185718.554300003,
"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": "STREET_NAME",
"fields": [
{
"name": "Shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape"
},
{
"name": "NLFID",
"type": "esriFieldTypeString",
"alias": "NLFID",
"length": 14
},
{
"name": "CRS",
"type": "esriFieldTypeString",
"alias": "CRS",
"length": 17
},
{
"name": "ODOT_DISTRICT",
"type": "esriFieldTypeString",
"alias": "ODOT District",
"length": 2
},
{
"name": "COUNTY",
"type": "esriFieldTypeString",
"alias": "County",
"length": 10
},
{
"name": "COUNTY_CD",
"type": "esriFieldTypeString",
"alias": "County CD",
"length": 3
},
{
"name": "ROUTE_TYPE",
"type": "esriFieldTypeString",
"alias": "Route Type",
"length": 2
},
{
"name": "ROUTE_NBR",
"type": "esriFieldTypeString",
"alias": "Route Number",
"length": 5
},
{
"name": "ROUTE_SUFFIX",
"type": "esriFieldTypeString",
"alias": "Route Suffix",
"length": 1
},
{
"name": "STREET_NAME",
"type": "esriFieldTypeString",
"alias": "Street Name",
"length": 100
},
{
"name": "CTL_BEGIN_NBR",
"type": "esriFieldTypeDouble",
"alias": "CTL Begin Number"
},
{
"name": "STL_BEGIN_NBR",
"type": "esriFieldTypeDouble",
"alias": "STL Begin Number"
},
{
"name": "LATITUDE_DD_BEGIN",
"type": "esriFieldTypeDouble",
"alias": "Latitude DD Begin"
},
{
"name": "LONGITUDE_DD_BEGIN",
"type": "esriFieldTypeDouble",
"alias": "Longitude DD Begin"
},
{
"name": "PERP_DATE",
"type": "esriFieldTypeDate",
"alias": "PERP Date",
"length": 8
},
{
"name": "STATUS",
"type": "esriFieldTypeString",
"alias": "Status",
"length": 1
},
{
"name": "INSTALLATION_DATE",
"type": "esriFieldTypeDate",
"alias": "Installation Date (Support)",
"length": 8
},
{
"name": "PID",
"type": "esriFieldTypeInteger",
"alias": "PID"
},
{
"name": "END_CONSTRUCTION_DATE",
"type": "esriFieldTypeDate",
"alias": "End of Construction Date",
"length": 8
},
{
"name": "LET_PLANS_URL",
"type": "esriFieldTypeString",
"alias": "Let Plans URL",
"length": 150
},
{
"name": "MAINTAIN_RESPONSIBLE",
"type": "esriFieldTypeString",
"alias": "Maintenance Responsibility",
"length": 1
},
{
"name": "INTERSECTION_ID",
"type": "esriFieldTypeString",
"alias": "Intersection ID",
"length": 36
},
{
"name": "CROSS_ROUTE_LEG_ID",
"type": "esriFieldTypeString",
"alias": "Approach ID",
"length": 36
},
{
"name": "SUPPORT_FILE_NUMBER",
"type": "esriFieldTypeString",
"alias": "Support File Number",
"length": 10
},
{
"name": "OLD_SUPPORT_ID",
"type": "esriFieldTypeString",
"alias": "Old Support ID",
"length": 25
},
{
"name": "SUPPORT_OWNER",
"type": "esriFieldTypeString",
"alias": "Support Owner",
"length": 10
},
{
"name": "LOCATION_DESCRIPTION",
"type": "esriFieldTypeString",
"alias": "Location Description",
"length": 255
},
{
"name": "PROJECT_NAME",
"type": "esriFieldTypeString",
"alias": "Project Name",
"length": 32
},
{
"name": "PROJECT_NUMBER",
"type": "esriFieldTypeString",
"alias": "Project Number",
"length": 10
},
{
"name": "ROUTE_DESIGNATION",
"type": "esriFieldTypeString",
"alias": "Route Designation",
"length": 8
},
{
"name": "SUPPORT_CATEGORY",
"type": "esriFieldTypeString",
"alias": "Support Category",
"length": 14
},
{
"name": "SUPPORT_STYLE",
"type": "esriFieldTypeInteger",
"alias": "Support Style"
},
{
"name": "SUPPORT_TYPE",
"type": "esriFieldTypeString",
"alias": "Support Type",
"length": 20
},
{
"name": "DESIGN_NUMBER",
"type": "esriFieldTypeString",
"alias": "Design Number",
"length": 2
},
{
"name": "SUPPORT_SIZE",
"type": "esriFieldTypeString",
"alias": "Support Size",
"length": 50
},
{
"name": "NUM_OF_SUPPORTS",
"type": "esriFieldTypeInteger",
"alias": "Number of Supports"
},
{
"name": "NUM_OF_SIGNS",
"type": "esriFieldTypeInteger",
"alias": "Number of Signs"
},
{
"name": "BRIDGE_MOUNTED",
"type": "esriFieldTypeString",
"alias": "Mounted On Bridge",
"length": 1
},
{
"name": "MEDIAN_WALL_PLATES",
"type": "esriFieldTypeString",
"alias": "Median Wall Plates",
"length": 1
},
{
"name": "BREAKAWAY_MECHANISM",
"type": "esriFieldTypeString",
"alias": "Breakaway Mechanism",
"length": 1
},
{
"name": "FLANGE_TYPE",
"type": "esriFieldTypeString",
"alias": "Flange Type",
"length": 15
},
{
"name": "REFLECTOR_STRIP",
"type": "esriFieldTypeString",
"alias": "Reflector Strip",
"length": 1
},
{
"name": "OVERHEAD_SPAN_LENGTH",
"type": "esriFieldTypeDouble",
"alias": "Overhead Span Length (ft)"
},
{
"name": "ATTACHMENTS",
"type": "esriFieldTypeString",
"alias": "Attachments",
"length": 1
},
{
"name": "ATTACHMENT_COMMENTS",
"type": "esriFieldTypeString",
"alias": "Attachment Comments",
"length": 2500
},
{
"name": "PAINTED",
"type": "esriFieldTypeString",
"alias": "Painted",
"length": 1
},
{
"name": "SIGN_SUPPORT_REPLACE",
"type": "esriFieldTypeString",
"alias": "Sign/Support Replacement",
"length": 25
},
{
"name": "REPLACEMENT_DATE",
"type": "esriFieldTypeDate",
"alias": "Replacement Date",
"length": 8
},
{
"name": "REPLACEMENT_PID",
"type": "esriFieldTypeInteger",
"alias": "Replacement PID"
},
{
"name": "ACCESS_CONTROL",
"type": "esriFieldTypeInteger",
"alias": "Access Control"
},
{
"name": "PATH_WEB_VIEWER",
"type": "esriFieldTypeString",
"alias": "Path Web Viewer",
"length": 500
},
{
"name": "MAINTAIN_RECOMMEND",
"type": "esriFieldTypeString",
"alias": "Maintenance Recommended",
"length": 1
},
{
"name": "INSPECTION_DUE",
"type": "esriFieldTypeString",
"alias": "Inspection Due",
"length": 28
},
{
"name": "SUPPORT_INV_COMMENTS",
"type": "esriFieldTypeString",
"alias": "Support Inventory Comments",
"length": 2500
},
{
"name": "created_user",
"type": "esriFieldTypeString",
"alias": "created_user",
"length": 255
},
{
"name": "created_date",
"type": "esriFieldTypeDate",
"alias": "created_date",
"length": 8
},
{
"name": "last_edited_user",
"type": "esriFieldTypeString",
"alias": "last_edited_user",
"length": 255
},
{
"name": "last_edited_date",
"type": "esriFieldTypeDate",
"alias": "last_edited_date",
"length": 8
},
{
"name": "sys_updated_date",
"type": "esriFieldTypeDate",
"alias": "sys_updated_date",
"length": 8
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"length": 38
},
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID"
}
],
"geometryField": {
"name": "Shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape"
},
"indexes": [
{
"name": "UUID_19",
"fields": "GlobalID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "I160ODOT_DISTRIC",
"fields": "ODOT_DISTRICT,COUNTY,COUNTY_CD",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "gdb_ct3_19",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "S6_idx",
"fields": "Shape",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"relationships": [
{
"id": 0,
"name": "SIGNS_SUPPORT_INSPECTION",
"relatedTableId": 10,
"role": "esriRelRoleOrigin",
"keyField": "GlobalID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": true,
"catalogID": "{21C7204C-0D9B-4F93-8A0A-891E86D412DA}"
},
{
"id": 1,
"name": "SIGNS_SIGN_INVENTORY",
"relatedTableId": 9,
"role": "esriRelRoleOrigin",
"keyField": "GlobalID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": true,
"catalogID": "{54E0BAB0-4470-476E-8FB9-FF77461BAF13}"
}
],
"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": 1707605414000
},
"supportsCoordinatesQuantization": true,
"supportsDynamicLegends": true
},
{
"currentVersion": 11.3,
"cimVersion": "3.3.0",
"id": 2,
"name": "Needs Inspected this Fiscal Year",
"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": "INSPECTION_DUE",
"uniqueValueGroups": [
{
"heading": "Inspection Due",
"classes": [
{
"label": "Inspection Past Due",
"description": "Inspection Past Due",
"symbol": {
"type": "esriPMS",
"url": "eb7cceb4e5a95571bb8e08b3e4826d5b",
"imageData": "iVBORw0KGgoAAAANSUhEUgAAABsAAAAbCAYAAACN1PRVAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAgUlEQVRIiWNhoCNgGSjLNjMwMEjSwI6zDAwM6eiWgSwyZqBnMD6jouFShCyjJWAZtYxuwfgSinEBPWpadomBgSEej/wOIi0cTSBUASzUMYY4MMIt02NgYFiIR16cmpaBDHMl0sChFYzUAiwjxzIpOll2lkZ2nMVmGbi5RUtA1zgDAPNHCy3kGuxLAAAAAElFTkSuQmCC",
"contentType": "image/png",
"width": 20,
"height": 20,
"angle": 0,
"xoffset": 0,
"yoffset": 0
},
"values": [
[
"Inspection Past Due"
]
]
},
{
"label": "Needs Inspected this Fiscal Year",
"description": "Needs Inspected this Fiscal Year",
"symbol": {
"type": "esriSMS",
"style": "esriSMSSquare",
"color": [
230,
0,
0,
255
],
"size": 17,
"angle": 0,
"xoffset": 0,
"yoffset": 0,
"outline": {
"color": [
0,
0,
0,
255
],
"width": 1
}
},
"values": [
[
"Needs Inspected this FY"
]
]
}
]
}
],
"uniqueValueInfos": [
{
"symbol": {
"type": "esriPMS",
"url": "eb7cceb4e5a95571bb8e08b3e4826d5b",
"imageData": "iVBORw0KGgoAAAANSUhEUgAAABsAAAAbCAYAAACN1PRVAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAgUlEQVRIiWNhoCNgGSjLNjMwMEjSwI6zDAwM6eiWgSwyZqBnMD6jouFShCyjJWAZtYxuwfgSinEBPWpadomBgSEej/wOIi0cTSBUASzUMYY4MMIt02NgYFiIR16cmpaBDHMl0sChFYzUAiwjxzIpOll2lkZ2nMVmGbi5RUtA1zgDAPNHCy3kGuxLAAAAAElFTkSuQmCC",
"contentType": "image/png",
"width": 20,
"height": 20,
"angle": 0,
"xoffset": 0,
"yoffset": 0
},
"value": "Inspection Past Due",
"label": "Inspection Past Due"
},
{
"symbol": {
"type": "esriSMS",
"style": "esriSMSSquare",
"color": [
230,
0,
0,
255
],
"size": 17,
"angle": 0,
"xoffset": 0,
"yoffset": 0,
"outline": {
"color": [
0,
0,
0,
255
],
"width": 1
}
},
"value": "Needs Inspected this FY",
"label": "Needs Inspected this Fiscal Year"
}
],
"fieldDelimiter": ",",
"authoringInfo": {
"colorRamp": {
"type": "multipart",
"colorRamps": [
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
252,
187,
251,
255
],
"toColor": [
252,
187,
251,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
190,
252,
187,
255
],
"toColor": [
190,
252,
187,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
199,
237,
252,
255
],
"toColor": [
199,
237,
252,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
252,
207,
182,
255
],
"toColor": [
252,
207,
182,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
179,
184,
252,
255
],
"toColor": [
179,
184,
252,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
252,
247,
189,
255
],
"toColor": [
252,
247,
189,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
252,
184,
207,
255
],
"toColor": [
252,
184,
207,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
182,
252,
236,
255
],
"toColor": [
182,
252,
236,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
222,
215,
252,
255
],
"toColor": [
222,
215,
252,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
225,
252,
215,
255
],
"toColor": [
225,
252,
215,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
252,
210,
242,
255
],
"toColor": [
252,
210,
242,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
223,
252,
182,
255
],
"toColor": [
223,
252,
182,
255
]
},
{
"type": "algorithmic",
"algorithm": "esriCIELabAlgorithm",
"fromColor": [
252,
212,
213,
255
],
"toColor": [
252,
212,
213,
255
]
}
]
}
}
},
"scaleSymbols": true,
"transparency": 0,
"labelingInfo": null
},
"defaultVisibility": false,
"extent": {
"xmin": -9442114.5212,
"ymin": 4637280.771700002,
"xmax": -8963335.3149,
"ymax": 5185718.554300003,
"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": "STREET_NAME",
"fields": [
{
"name": "Shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape"
},
{
"name": "NLFID",
"type": "esriFieldTypeString",
"alias": "NLFID",
"length": 14
},
{
"name": "CRS",
"type": "esriFieldTypeString",
"alias": "CRS",
"length": 17
},
{
"name": "ODOT_DISTRICT",
"type": "esriFieldTypeString",
"alias": "ODOT District",
"length": 2
},
{
"name": "COUNTY",
"type": "esriFieldTypeString",
"alias": "County",
"length": 10
},
{
"name": "COUNTY_CD",
"type": "esriFieldTypeString",
"alias": "County CD",
"length": 3
},
{
"name": "ROUTE_TYPE",
"type": "esriFieldTypeString",
"alias": "Route Type",
"length": 2
},
{
"name": "ROUTE_NBR",
"type": "esriFieldTypeString",
"alias": "Route Number",
"length": 5
},
{
"name": "ROUTE_SUFFIX",
"type": "esriFieldTypeString",
"alias": "Route Suffix",
"length": 1
},
{
"name": "STREET_NAME",
"type": "esriFieldTypeString",
"alias": "Street Name",
"length": 100
},
{
"name": "CTL_BEGIN_NBR",
"type": "esriFieldTypeDouble",
"alias": "CTL Begin Number"
},
{
"name": "STL_BEGIN_NBR",
"type": "esriFieldTypeDouble",
"alias": "STL Begin Number"
},
{
"name": "LATITUDE_DD_BEGIN",
"type": "esriFieldTypeDouble",
"alias": "Latitude DD Begin"
},
{
"name": "LONGITUDE_DD_BEGIN",
"type": "esriFieldTypeDouble",
"alias": "Longitude DD Begin"
},
{
"name": "PERP_DATE",
"type": "esriFieldTypeDate",
"alias": "PERP Date",
"length": 8
},
{
"name": "STATUS",
"type": "esriFieldTypeString",
"alias": "Status",
"length": 1
},
{
"name": "INSTALLATION_DATE",
"type": "esriFieldTypeDate",
"alias": "Installation Date (Support)",
"length": 8
},
{
"name": "PID",
"type": "esriFieldTypeInteger",
"alias": "PID"
},
{
"name": "END_CONSTRUCTION_DATE",
"type": "esriFieldTypeDate",
"alias": "End of Construction Date",
"length": 8
},
{
"name": "LET_PLANS_URL",
"type": "esriFieldTypeString",
"alias": "Let Plans URL",
"length": 150
},
{
"name": "MAINTAIN_RESPONSIBLE",
"type": "esriFieldTypeString",
"alias": "Maintenance Responsibility",
"length": 1
},
{
"name": "INTERSECTION_ID",
"type": "esriFieldTypeString",
"alias": "Intersection ID",
"length": 36
},
{
"name": "CROSS_ROUTE_LEG_ID",
"type": "esriFieldTypeString",
"alias": "Approach ID",
"length": 36
},
{
"name": "SUPPORT_FILE_NUMBER",
"type": "esriFieldTypeString",
"alias": "Support File Number",
"length": 10
},
{
"name": "OLD_SUPPORT_ID",
"type": "esriFieldTypeString",
"alias": "Old Support ID",
"length": 25
},
{
"name": "SUPPORT_OWNER",
"type": "esriFieldTypeString",
"alias": "Support Owner",
"length": 10
},
{
"name": "LOCATION_DESCRIPTION",
"type": "esriFieldTypeString",
"alias": "Location Description",
"length": 255
},
{
"name": "PROJECT_NAME",
"type": "esriFieldTypeString",
"alias": "Project Name",
"length": 32
},
{
"name": "PROJECT_NUMBER",
"type": "esriFieldTypeString",
"alias": "Project Number",
"length": 10
},
{
"name": "ROUTE_DESIGNATION",
"type": "esriFieldTypeString",
"alias": "Route Designation",
"length": 8
},
{
"name": "SUPPORT_CATEGORY",
"type": "esriFieldTypeString",
"alias": "Support Category",
"length": 14
},
{
"name": "SUPPORT_STYLE",
"type": "esriFieldTypeInteger",
"alias": "Support Style"
},
{
"name": "SUPPORT_TYPE",
"type": "esriFieldTypeString",
"alias": "Support Type",
"length": 20
},
{
"name": "DESIGN_NUMBER",
"type": "esriFieldTypeString",
"alias": "Design Number",
"length": 2
},
{
"name": "SUPPORT_SIZE",
"type": "esriFieldTypeString",
"alias": "Support Size",
"length": 50
},
{
"name": "NUM_OF_SUPPORTS",
"type": "esriFieldTypeInteger",
"alias": "Number of Supports"
},
{
"name": "NUM_OF_SIGNS",
"type": "esriFieldTypeInteger",
"alias": "Number of Signs"
},
{
"name": "BRIDGE_MOUNTED",
"type": "esriFieldTypeString",
"alias": "Mounted On Bridge",
"length": 1
},
{
"name": "MEDIAN_WALL_PLATES",
"type": "esriFieldTypeString",
"alias": "Median Wall Plates",
"length": 1
},
{
"name": "BREAKAWAY_MECHANISM",
"type": "esriFieldTypeString",
"alias": "Breakaway Mechanism",
"length": 1
},
{
"name": "FLANGE_TYPE",
"type": "esriFieldTypeString",
"alias": "Flange Type",
"length": 15
},
{
"name": "REFLECTOR_STRIP",
"type": "esriFieldTypeString",
"alias": "Reflector Strip",
"length": 1
},
{
"name": "OVERHEAD_SPAN_LENGTH",
"type": "esriFieldTypeDouble",
"alias": "Overhead Span Length (ft)"
},
{
"name": "ATTACHMENTS",
"type": "esriFieldTypeString",
"alias": "Attachments",
"length": 1
},
{
"name": "ATTACHMENT_COMMENTS",
"type": "esriFieldTypeString",
"alias": "Attachment Comments",
"length": 2500
},
{
"name": "PAINTED",
"type": "esriFieldTypeString",
"alias": "Painted",
"length": 1
},
{
"name": "SIGN_SUPPORT_REPLACE",
"type": "esriFieldTypeString",
"alias": "Sign/Support Replacement",
"length": 25
},
{
"name": "REPLACEMENT_DATE",
"type": "esriFieldTypeDate",
"alias": "Replacement Date",
"length": 8
},
{
"name": "REPLACEMENT_PID",
"type": "esriFieldTypeInteger",
"alias": "Replacement PID"
},
{
"name": "ACCESS_CONTROL",
"type": "esriFieldTypeInteger",
"alias": "Access Control"
},
{
"name": "PATH_WEB_VIEWER",
"type": "esriFieldTypeString",
"alias": "Path Web Viewer",
"length": 500
},
{
"name": "MAINTAIN_RECOMMEND",
"type": "esriFieldTypeString",
"alias": "Maintenance Recommended",
"length": 1
},
{
"name": "INSPECTION_DUE",
"type": "esriFieldTypeString",
"alias": "Inspection Due",
"length": 28
},
{
"name": "SUPPORT_INV_COMMENTS",
"type": "esriFieldTypeString",
"alias": "Support Inventory Comments",
"length": 2500
},
{
"name": "created_user",
"type": "esriFieldTypeString",
"alias": "created_user",
"length": 255
},
{
"name": "created_date",
"type": "esriFieldTypeDate",
"alias": "created_date",
"length": 8
},
{
"name": "last_edited_user",
"type": "esriFieldTypeString",
"alias": "last_edited_user",
"length": 255
},
{
"name": "last_edited_date",
"type": "esriFieldTypeDate",
"alias": "last_edited_date",
"length": 8
},
{
"name": "sys_updated_date",
"type": "esriFieldTypeDate",
"alias": "sys_updated_date",
"length": 8
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"length": 38
},
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID"
}
],
"geometryField": {
"name": "Shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape"
},
"indexes": [
{
"name": "UUID_19",
"fields": "GlobalID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "I160ODOT_DISTRIC",
"fields": "ODOT_DISTRICT,COUNTY,COUNTY_CD",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "gdb_ct3_19",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "S6_idx",
"fields": "Shape",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"relationships": [
{
"id": 2,
"name": "SIGNS_SUPPORT_INSPECTION",
"relatedTableId": 10,
"role": "esriRelRoleOrigin",
"keyField": "GlobalID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": true,
"catalogID": "{21C7204C-0D9B-4F93-8A0A-891E86D412DA}"
},
{
"id": 3,
"name": "SIGNS_SIGN_INVENTORY",
"relatedTableId": 9,
"role": "esriRelRoleOrigin",
"keyField": "GlobalID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": true,
"catalogID": "{54E0BAB0-4470-476E-8FB9-FF77461BAF13}"
}
],
"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": 1707605414000
},
"supportsCoordinatesQuantization": true,
"supportsDynamicLegends": true
},
{
"currentVersion": 11.3,
"cimVersion": "3.3.0",
"id": 3,
"name": "Needs Inspected next Fiscal Year",
"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": [
255,
170,
0,
255
],
"size": 17,
"angle": 0,
"xoffset": 0,
"yoffset": 0,
"outline": {
"color": [
0,
0,
0,
255
],
"width": 1
}
}
},
"scaleSymbols": true,
"transparency": 0,
"labelingInfo": null
},
"defaultVisibility": false,
"extent": {
"xmin": -9442114.5212,
"ymin": 4637280.771700002,
"xmax": -8963335.3149,
"ymax": 5185718.554300003,
"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": "STREET_NAME",
"fields": [
{
"name": "Shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape"
},
{
"name": "NLFID",
"type": "esriFieldTypeString",
"alias": "NLFID",
"length": 14
},
{
"name": "CRS",
"type": "esriFieldTypeString",
"alias": "CRS",
"length": 17
},
{
"name": "ODOT_DISTRICT",
"type": "esriFieldTypeString",
"alias": "ODOT District",
"length": 2
},
{
"name": "COUNTY",
"type": "esriFieldTypeString",
"alias": "County",
"length": 10
},
{
"name": "COUNTY_CD",
"type": "esriFieldTypeString",
"alias": "County CD",
"length": 3
},
{
"name": "ROUTE_TYPE",
"type": "esriFieldTypeString",
"alias": "Route Type",
"length": 2
},
{
"name": "ROUTE_NBR",
"type": "esriFieldTypeString",
"alias": "Route Number",
"length": 5
},
{
"name": "ROUTE_SUFFIX",
"type": "esriFieldTypeString",
"alias": "Route Suffix",
"length": 1
},
{
"name": "STREET_NAME",
"type": "esriFieldTypeString",
"alias": "Street Name",
"length": 100
},
{
"name": "CTL_BEGIN_NBR",
"type": "esriFieldTypeDouble",
"alias": "CTL Begin Number"
},
{
"name": "STL_BEGIN_NBR",
"type": "esriFieldTypeDouble",
"alias": "STL Begin Number"
},
{
"name": "LATITUDE_DD_BEGIN",
"type": "esriFieldTypeDouble",
"alias": "Latitude DD Begin"
},
{
"name": "LONGITUDE_DD_BEGIN",
"type": "esriFieldTypeDouble",
"alias": "Longitude DD Begin"
},
{
"name": "PERP_DATE",
"type": "esriFieldTypeDate",
"alias": "PERP Date",
"length": 8
},
{
"name": "STATUS",
"type": "esriFieldTypeString",
"alias": "Status",
"length": 1
},
{
"name": "INSTALLATION_DATE",
"type": "esriFieldTypeDate",
"alias": "Installation Date (Support)",
"length": 8
},
{
"name": "PID",
"type": "esriFieldTypeInteger",
"alias": "PID"
},
{
"name": "END_CONSTRUCTION_DATE",
"type": "esriFieldTypeDate",
"alias": "End of Construction Date",
"length": 8
},
{
"name": "LET_PLANS_URL",
"type": "esriFieldTypeString",
"alias": "Let Plans URL",
"length": 150
},
{
"name": "MAINTAIN_RESPONSIBLE",
"type": "esriFieldTypeString",
"alias": "Maintenance Responsibility",
"length": 1
},
{
"name": "INTERSECTION_ID",
"type": "esriFieldTypeString",
"alias": "Intersection ID",
"length": 36
},
{
"name": "CROSS_ROUTE_LEG_ID",
"type": "esriFieldTypeString",
"alias": "Approach ID",
"length": 36
},
{
"name": "SUPPORT_FILE_NUMBER",
"type": "esriFieldTypeString",
"alias": "Support File Number",
"length": 10
},
{
"name": "OLD_SUPPORT_ID",
"type": "esriFieldTypeString",
"alias": "Old Support ID",
"length": 25
},
{
"name": "SUPPORT_OWNER",
"type": "esriFieldTypeString",
"alias": "Support Owner",
"length": 10
},
{
"name": "LOCATION_DESCRIPTION",
"type": "esriFieldTypeString",
"alias": "Location Description",
"length": 255
},
{
"name": "PROJECT_NAME",
"type": "esriFieldTypeString",
"alias": "Project Name",
"length": 32
},
{
"name": "PROJECT_NUMBER",
"type": "esriFieldTypeString",
"alias": "Project Number",
"length": 10
},
{
"name": "ROUTE_DESIGNATION",
"type": "esriFieldTypeString",
"alias": "Route Designation",
"length": 8
},
{
"name": "SUPPORT_CATEGORY",
"type": "esriFieldTypeString",
"alias": "Support Category",
"length": 14
},
{
"name": "SUPPORT_STYLE",
"type": "esriFieldTypeInteger",
"alias": "Support Style"
},
{
"name": "SUPPORT_TYPE",
"type": "esriFieldTypeString",
"alias": "Support Type",
"length": 20
},
{
"name": "DESIGN_NUMBER",
"type": "esriFieldTypeString",
"alias": "Design Number",
"length": 2
},
{
"name": "SUPPORT_SIZE",
"type": "esriFieldTypeString",
"alias": "Support Size",
"length": 50
},
{
"name": "NUM_OF_SUPPORTS",
"type": "esriFieldTypeInteger",
"alias": "Number of Supports"
},
{
"name": "NUM_OF_SIGNS",
"type": "esriFieldTypeInteger",
"alias": "Number of Signs"
},
{
"name": "BRIDGE_MOUNTED",
"type": "esriFieldTypeString",
"alias": "Mounted On Bridge",
"length": 1
},
{
"name": "MEDIAN_WALL_PLATES",
"type": "esriFieldTypeString",
"alias": "Median Wall Plates",
"length": 1
},
{
"name": "BREAKAWAY_MECHANISM",
"type": "esriFieldTypeString",
"alias": "Breakaway Mechanism",
"length": 1
},
{
"name": "FLANGE_TYPE",
"type": "esriFieldTypeString",
"alias": "Flange Type",
"length": 15
},
{
"name": "REFLECTOR_STRIP",
"type": "esriFieldTypeString",
"alias": "Reflector Strip",
"length": 1
},
{
"name": "OVERHEAD_SPAN_LENGTH",
"type": "esriFieldTypeDouble",
"alias": "Overhead Span Length (ft)"
},
{
"name": "ATTACHMENTS",
"type": "esriFieldTypeString",
"alias": "Attachments",
"length": 1
},
{
"name": "ATTACHMENT_COMMENTS",
"type": "esriFieldTypeString",
"alias": "Attachment Comments",
"length": 2500
},
{
"name": "PAINTED",
"type": "esriFieldTypeString",
"alias": "Painted",
"length": 1
},
{
"name": "SIGN_SUPPORT_REPLACE",
"type": "esriFieldTypeString",
"alias": "Sign/Support Replacement",
"length": 25
},
{
"name": "REPLACEMENT_DATE",
"type": "esriFieldTypeDate",
"alias": "Replacement Date",
"length": 8
},
{
"name": "REPLACEMENT_PID",
"type": "esriFieldTypeInteger",
"alias": "Replacement PID"
},
{
"name": "ACCESS_CONTROL",
"type": "esriFieldTypeInteger",
"alias": "Access Control"
},
{
"name": "PATH_WEB_VIEWER",
"type": "esriFieldTypeString",
"alias": "Path Web Viewer",
"length": 500
},
{
"name": "MAINTAIN_RECOMMEND",
"type": "esriFieldTypeString",
"alias": "Maintenance Recommended",
"length": 1
},
{
"name": "INSPECTION_DUE",
"type": "esriFieldTypeString",
"alias": "Inspection Due",
"length": 28
},
{
"name": "SUPPORT_INV_COMMENTS",
"type": "esriFieldTypeString",
"alias": "Support Inventory Comments",
"length": 2500
},
{
"name": "created_user",
"type": "esriFieldTypeString",
"alias": "created_user",
"length": 255
},
{
"name": "created_date",
"type": "esriFieldTypeDate",
"alias": "created_date",
"length": 8
},
{
"name": "last_edited_user",
"type": "esriFieldTypeString",
"alias": "last_edited_user",
"length": 255
},
{
"name": "last_edited_date",
"type": "esriFieldTypeDate",
"alias": "last_edited_date",
"length": 8
},
{
"name": "sys_updated_date",
"type": "esriFieldTypeDate",
"alias": "sys_updated_date",
"length": 8
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"length": 38
},
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID"
}
],
"geometryField": {
"name": "Shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape"
},
"indexes": [
{
"name": "UUID_19",
"fields": "GlobalID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "I160ODOT_DISTRIC",
"fields": "ODOT_DISTRICT,COUNTY,COUNTY_CD",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "gdb_ct3_19",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "S6_idx",
"fields": "Shape",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"relationships": [
{
"id": 4,
"name": "SIGNS_SUPPORT_INSPECTION",
"relatedTableId": 10,
"role": "esriRelRoleOrigin",
"keyField": "GlobalID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": true,
"catalogID": "{21C7204C-0D9B-4F93-8A0A-891E86D412DA}"
},
{
"id": 5,
"name": "SIGNS_SIGN_INVENTORY",
"relatedTableId": 9,
"role": "esriRelRoleOrigin",
"keyField": "GlobalID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": true,
"catalogID": "{54E0BAB0-4470-476E-8FB9-FF77461BAF13}"
}
],
"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": 1707605414000
},
"supportsCoordinatesQuantization": true,
"supportsDynamicLegends": true
},
{
"currentVersion": 11.3,
"cimVersion": "3.3.0",
"id": 4,
"name": "Needs Inspected in 2 Fiscal Years",
"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": [
255,
255,
0,
255
],
"size": 17,
"angle": 0,
"xoffset": 0,
"yoffset": 0,
"outline": {
"color": [
0,
0,
0,
255
],
"width": 1
}
}
},
"scaleSymbols": true,
"transparency": 0,
"labelingInfo": null
},
"defaultVisibility": false,
"extent": {
"xmin": -9442114.5212,
"ymin": 4637280.771700002,
"xmax": -8963335.3149,
"ymax": 5185718.554300003,
"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": "STREET_NAME",
"fields": [
{
"name": "Shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape"
},
{
"name": "NLFID",
"type": "esriFieldTypeString",
"alias": "NLFID",
"length": 14
},
{
"name": "CRS",
"type": "esriFieldTypeString",
"alias": "CRS",
"length": 17
},
{
"name": "ODOT_DISTRICT",
"type": "esriFieldTypeString",
"alias": "ODOT District",
"length": 2
},
{
"name": "COUNTY",
"type": "esriFieldTypeString",
"alias": "County",
"length": 10
},
{
"name": "COUNTY_CD",
"type": "esriFieldTypeString",
"alias": "County CD",
"length": 3
},
{
"name": "ROUTE_TYPE",
"type": "esriFieldTypeString",
"alias": "Route Type",
"length": 2
},
{
"name": "ROUTE_NBR",
"type": "esriFieldTypeString",
"alias": "Route Number",
"length": 5
},
{
"name": "ROUTE_SUFFIX",
"type": "esriFieldTypeString",
"alias": "Route Suffix",
"length": 1
},
{
"name": "STREET_NAME",
"type": "esriFieldTypeString",
"alias": "Street Name",
"length": 100
},
{
"name": "CTL_BEGIN_NBR",
"type": "esriFieldTypeDouble",
"alias": "CTL Begin Number"
},
{
"name": "STL_BEGIN_NBR",
"type": "esriFieldTypeDouble",
"alias": "STL Begin Number"
},
{
"name": "LATITUDE_DD_BEGIN",
"type": "esriFieldTypeDouble",
"alias": "Latitude DD Begin"
},
{
"name": "LONGITUDE_DD_BEGIN",
"type": "esriFieldTypeDouble",
"alias": "Longitude DD Begin"
},
{
"name": "PERP_DATE",
"type": "esriFieldTypeDate",
"alias": "PERP Date",
"length": 8
},
{
"name": "STATUS",
"type": "esriFieldTypeString",
"alias": "Status",
"length": 1
},
{
"name": "INSTALLATION_DATE",
"type": "esriFieldTypeDate",
"alias": "Installation Date (Support)",
"length": 8
},
{
"name": "PID",
"type": "esriFieldTypeInteger",
"alias": "PID"
},
{
"name": "END_CONSTRUCTION_DATE",
"type": "esriFieldTypeDate",
"alias": "End of Construction Date",
"length": 8
},
{
"name": "LET_PLANS_URL",
"type": "esriFieldTypeString",
"alias": "Let Plans URL",
"length": 150
},
{
"name": "MAINTAIN_RESPONSIBLE",
"type": "esriFieldTypeString",
"alias": "Maintenance Responsibility",
"length": 1
},
{
"name": "INTERSECTION_ID",
"type": "esriFieldTypeString",
"alias": "Intersection ID",
"length": 36
},
{
"name": "CROSS_ROUTE_LEG_ID",
"type": "esriFieldTypeString",
"alias": "Approach ID",
"length": 36
},
{
"name": "SUPPORT_FILE_NUMBER",
"type": "esriFieldTypeString",
"alias": "Support File Number",
"length": 10
},
{
"name": "OLD_SUPPORT_ID",
"type": "esriFieldTypeString",
"alias": "Old Support ID",
"length": 25
},
{
"name": "SUPPORT_OWNER",
"type": "esriFieldTypeString",
"alias": "Support Owner",
"length": 10
},
{
"name": "LOCATION_DESCRIPTION",
"type": "esriFieldTypeString",
"alias": "Location Description",
"length": 255
},
{
"name": "PROJECT_NAME",
"type": "esriFieldTypeString",
"alias": "Project Name",
"length": 32
},
{
"name": "PROJECT_NUMBER",
"type": "esriFieldTypeString",
"alias": "Project Number",
"length": 10
},
{
"name": "ROUTE_DESIGNATION",
"type": "esriFieldTypeString",
"alias": "Route Designation",
"length": 8
},
{
"name": "SUPPORT_CATEGORY",
"type": "esriFieldTypeString",
"alias": "Support Category",
"length": 14
},
{
"name": "SUPPORT_STYLE",
"type": "esriFieldTypeInteger",
"alias": "Support Style"
},
{
"name": "SUPPORT_TYPE",
"type": "esriFieldTypeString",
"alias": "Support Type",
"length": 20
},
{
"name": "DESIGN_NUMBER",
"type": "esriFieldTypeString",
"alias": "Design Number",
"length": 2
},
{
"name": "SUPPORT_SIZE",
"type": "esriFieldTypeString",
"alias": "Support Size",
"length": 50
},
{
"name": "NUM_OF_SUPPORTS",
"type": "esriFieldTypeInteger",
"alias": "Number of Supports"
},
{
"name": "NUM_OF_SIGNS",
"type": "esriFieldTypeInteger",
"alias": "Number of Signs"
},
{
"name": "BRIDGE_MOUNTED",
"type": "esriFieldTypeString",
"alias": "Mounted On Bridge",
"length": 1
},
{
"name": "MEDIAN_WALL_PLATES",
"type": "esriFieldTypeString",
"alias": "Median Wall Plates",
"length": 1
},
{
"name": "BREAKAWAY_MECHANISM",
"type": "esriFieldTypeString",
"alias": "Breakaway Mechanism",
"length": 1
},
{
"name": "FLANGE_TYPE",
"type": "esriFieldTypeString",
"alias": "Flange Type",
"length": 15
},
{
"name": "REFLECTOR_STRIP",
"type": "esriFieldTypeString",
"alias": "Reflector Strip",
"length": 1
},
{
"name": "OVERHEAD_SPAN_LENGTH",
"type": "esriFieldTypeDouble",
"alias": "Overhead Span Length (ft)"
},
{
"name": "ATTACHMENTS",
"type": "esriFieldTypeString",
"alias": "Attachments",
"length": 1
},
{
"name": "ATTACHMENT_COMMENTS",
"type": "esriFieldTypeString",
"alias": "Attachment Comments",
"length": 2500
},
{
"name": "PAINTED",
"type": "esriFieldTypeString",
"alias": "Painted",
"length": 1
},
{
"name": "SIGN_SUPPORT_REPLACE",
"type": "esriFieldTypeString",
"alias": "Sign/Support Replacement",
"length": 25
},
{
"name": "REPLACEMENT_DATE",
"type": "esriFieldTypeDate",
"alias": "Replacement Date",
"length": 8
},
{
"name": "REPLACEMENT_PID",
"type": "esriFieldTypeInteger",
"alias": "Replacement PID"
},
{
"name": "ACCESS_CONTROL",
"type": "esriFieldTypeInteger",
"alias": "Access Control"
},
{
"name": "PATH_WEB_VIEWER",
"type": "esriFieldTypeString",
"alias": "Path Web Viewer",
"length": 500
},
{
"name": "MAINTAIN_RECOMMEND",
"type": "esriFieldTypeString",
"alias": "Maintenance Recommended",
"length": 1
},
{
"name": "INSPECTION_DUE",
"type": "esriFieldTypeString",
"alias": "Inspection Due",
"length": 28
},
{
"name": "SUPPORT_INV_COMMENTS",
"type": "esriFieldTypeString",
"alias": "Support Inventory Comments",
"length": 2500
},
{
"name": "created_user",
"type": "esriFieldTypeString",
"alias": "created_user",
"length": 255
},
{
"name": "created_date",
"type": "esriFieldTypeDate",
"alias": "created_date",
"length": 8
},
{
"name": "last_edited_user",
"type": "esriFieldTypeString",
"alias": "last_edited_user",
"length": 255
},
{
"name": "last_edited_date",
"type": "esriFieldTypeDate",
"alias": "last_edited_date",
"length": 8
},
{
"name": "sys_updated_date",
"type": "esriFieldTypeDate",
"alias": "sys_updated_date",
"length": 8
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"length": 38
},
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID"
}
],
"geometryField": {
"name": "Shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape"
},
"indexes": [
{
"name": "UUID_19",
"fields": "GlobalID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "I160ODOT_DISTRIC",
"fields": "ODOT_DISTRICT,COUNTY,COUNTY_CD",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "gdb_ct3_19",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "S6_idx",
"fields": "Shape",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"relationships": [
{
"id": 6,
"name": "SIGNS_SUPPORT_INSPECTION",
"relatedTableId": 10,
"role": "esriRelRoleOrigin",
"keyField": "GlobalID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": true,
"catalogID": "{21C7204C-0D9B-4F93-8A0A-891E86D412DA}"
},
{
"id": 7,
"name": "SIGNS_SIGN_INVENTORY",
"relatedTableId": 9,
"role": "esriRelRoleOrigin",
"keyField": "GlobalID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": true,
"catalogID": "{54E0BAB0-4470-476E-8FB9-FF77461BAF13}"
}
],
"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": 1707605414000
},
"supportsCoordinatesQuantization": true,
"supportsDynamicLegends": true
},
{
"currentVersion": 11.3,
"cimVersion": "3.3.0",
"id": 5,
"name": "Needs Inspected in 3 Fiscal Years",
"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": [
169,
0,
230,
255
],
"size": 17,
"angle": 0,
"xoffset": 0,
"yoffset": 0,
"outline": {
"color": [
0,
0,
0,
255
],
"width": 1
}
}
},
"scaleSymbols": true,
"transparency": 0,
"labelingInfo": null
},
"defaultVisibility": false,
"extent": {
"xmin": -9442114.5212,
"ymin": 4637280.771700002,
"xmax": -8963335.3149,
"ymax": 5185718.554300003,
"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": "STREET_NAME",
"fields": [
{
"name": "Shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape"
},
{
"name": "NLFID",
"type": "esriFieldTypeString",
"alias": "NLFID",
"length": 14
},
{
"name": "CRS",
"type": "esriFieldTypeString",
"alias": "CRS",
"length": 17
},
{
"name": "ODOT_DISTRICT",
"type": "esriFieldTypeString",
"alias": "ODOT District",
"length": 2
},
{
"name": "COUNTY",
"type": "esriFieldTypeString",
"alias": "County",
"length": 10
},
{
"name": "COUNTY_CD",
"type": "esriFieldTypeString",
"alias": "County CD",
"length": 3
},
{
"name": "ROUTE_TYPE",
"type": "esriFieldTypeString",
"alias": "Route Type",
"length": 2
},
{
"name": "ROUTE_NBR",
"type": "esriFieldTypeString",
"alias": "Route Number",
"length": 5
},
{
"name": "ROUTE_SUFFIX",
"type": "esriFieldTypeString",
"alias": "Route Suffix",
"length": 1
},
{
"name": "STREET_NAME",
"type": "esriFieldTypeString",
"alias": "Street Name",
"length": 100
},
{
"name": "CTL_BEGIN_NBR",
"type": "esriFieldTypeDouble",
"alias": "CTL Begin Number"
},
{
"name": "STL_BEGIN_NBR",
"type": "esriFieldTypeDouble",
"alias": "STL Begin Number"
},
{
"name": "LATITUDE_DD_BEGIN",
"type": "esriFieldTypeDouble",
"alias": "Latitude DD Begin"
},
{
"name": "LONGITUDE_DD_BEGIN",
"type": "esriFieldTypeDouble",
"alias": "Longitude DD Begin"
},
{
"name": "PERP_DATE",
"type": "esriFieldTypeDate",
"alias": "PERP Date",
"length": 8
},
{
"name": "STATUS",
"type": "esriFieldTypeString",
"alias": "Status",
"length": 1
},
{
"name": "INSTALLATION_DATE",
"type": "esriFieldTypeDate",
"alias": "Installation Date (Support)",
"length": 8
},
{
"name": "PID",
"type": "esriFieldTypeInteger",
"alias": "PID"
},
{
"name": "END_CONSTRUCTION_DATE",
"type": "esriFieldTypeDate",
"alias": "End of Construction Date",
"length": 8
},
{
"name": "LET_PLANS_URL",
"type": "esriFieldTypeString",
"alias": "Let Plans URL",
"length": 150
},
{
"name": "MAINTAIN_RESPONSIBLE",
"type": "esriFieldTypeString",
"alias": "Maintenance Responsibility",
"length": 1
},
{
"name": "INTERSECTION_ID",
"type": "esriFieldTypeString",
"alias": "Intersection ID",
"length": 36
},
{
"name": "CROSS_ROUTE_LEG_ID",
"type": "esriFieldTypeString",
"alias": "Approach ID",
"length": 36
},
{
"name": "SUPPORT_FILE_NUMBER",
"type": "esriFieldTypeString",
"alias": "Support File Number",
"length": 10
},
{
"name": "OLD_SUPPORT_ID",
"type": "esriFieldTypeString",
"alias": "Old Support ID",
"length": 25
},
{
"name": "SUPPORT_OWNER",
"type": "esriFieldTypeString",
"alias": "Support Owner",
"length": 10
},
{
"name": "LOCATION_DESCRIPTION",
"type": "esriFieldTypeString",
"alias": "Location Description",
"length": 255
},
{
"name": "PROJECT_NAME",
"type": "esriFieldTypeString",
"alias": "Project Name",
"length": 32
},
{
"name": "PROJECT_NUMBER",
"type": "esriFieldTypeString",
"alias": "Project Number",
"length": 10
},
{
"name": "ROUTE_DESIGNATION",
"type": "esriFieldTypeString",
"alias": "Route Designation",
"length": 8
},
{
"name": "SUPPORT_CATEGORY",
"type": "esriFieldTypeString",
"alias": "Support Category",
"length": 14
},
{
"name": "SUPPORT_STYLE",
"type": "esriFieldTypeInteger",
"alias": "Support Style"
},
{
"name": "SUPPORT_TYPE",
"type": "esriFieldTypeString",
"alias": "Support Type",
"length": 20
},
{
"name": "DESIGN_NUMBER",
"type": "esriFieldTypeString",
"alias": "Design Number",
"length": 2
},
{
"name": "SUPPORT_SIZE",
"type": "esriFieldTypeString",
"alias": "Support Size",
"length": 50
},
{
"name": "NUM_OF_SUPPORTS",
"type": "esriFieldTypeInteger",
"alias": "Number of Supports"
},
{
"name": "NUM_OF_SIGNS",
"type": "esriFieldTypeInteger",
"alias": "Number of Signs"
},
{
"name": "BRIDGE_MOUNTED",
"type": "esriFieldTypeString",
"alias": "Mounted On Bridge",
"length": 1
},
{
"name": "MEDIAN_WALL_PLATES",
"type": "esriFieldTypeString",
"alias": "Median Wall Plates",
"length": 1
},
{
"name": "BREAKAWAY_MECHANISM",
"type": "esriFieldTypeString",
"alias": "Breakaway Mechanism",
"length": 1
},
{
"name": "FLANGE_TYPE",
"type": "esriFieldTypeString",
"alias": "Flange Type",
"length": 15
},
{
"name": "REFLECTOR_STRIP",
"type": "esriFieldTypeString",
"alias": "Reflector Strip",
"length": 1
},
{
"name": "OVERHEAD_SPAN_LENGTH",
"type": "esriFieldTypeDouble",
"alias": "Overhead Span Length (ft)"
},
{
"name": "ATTACHMENTS",
"type": "esriFieldTypeString",
"alias": "Attachments",
"length": 1
},
{
"name": "ATTACHMENT_COMMENTS",
"type": "esriFieldTypeString",
"alias": "Attachment Comments",
"length": 2500
},
{
"name": "PAINTED",
"type": "esriFieldTypeString",
"alias": "Painted",
"length": 1
},
{
"name": "SIGN_SUPPORT_REPLACE",
"type": "esriFieldTypeString",
"alias": "Sign/Support Replacement",
"length": 25
},
{
"name": "REPLACEMENT_DATE",
"type": "esriFieldTypeDate",
"alias": "Replacement Date",
"length": 8
},
{
"name": "REPLACEMENT_PID",
"type": "esriFieldTypeInteger",
"alias": "Replacement PID"
},
{
"name": "ACCESS_CONTROL",
"type": "esriFieldTypeInteger",
"alias": "Access Control"
},
{
"name": "PATH_WEB_VIEWER",
"type": "esriFieldTypeString",
"alias": "Path Web Viewer",
"length": 500
},
{
"name": "MAINTAIN_RECOMMEND",
"type": "esriFieldTypeString",
"alias": "Maintenance Recommended",
"length": 1
},
{
"name": "INSPECTION_DUE",
"type": "esriFieldTypeString",
"alias": "Inspection Due",
"length": 28
},
{
"name": "SUPPORT_INV_COMMENTS",
"type": "esriFieldTypeString",
"alias": "Support Inventory Comments",
"length": 2500
},
{
"name": "created_user",
"type": "esriFieldTypeString",
"alias": "created_user",
"length": 255
},
{
"name": "created_date",
"type": "esriFieldTypeDate",
"alias": "created_date",
"length": 8
},
{
"name": "last_edited_user",
"type": "esriFieldTypeString",
"alias": "last_edited_user",
"length": 255
},
{
"name": "last_edited_date",
"type": "esriFieldTypeDate",
"alias": "last_edited_date",
"length": 8
},
{
"name": "sys_updated_date",
"type": "esriFieldTypeDate",
"alias": "sys_updated_date",
"length": 8
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"length": 38
},
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID"
}
],
"geometryField": {
"name": "Shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape"
},
"indexes": [
{
"name": "UUID_19",
"fields": "GlobalID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "I160ODOT_DISTRIC",
"fields": "ODOT_DISTRICT,COUNTY,COUNTY_CD",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "gdb_ct3_19",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "S6_idx",
"fields": "Shape",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"relationships": [
{
"id": 8,
"name": "SIGNS_SUPPORT_INSPECTION",
"relatedTableId": 10,
"role": "esriRelRoleOrigin",
"keyField": "GlobalID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": true,
"catalogID": "{21C7204C-0D9B-4F93-8A0A-891E86D412DA}"
},
{
"id": 9,
"name": "SIGNS_SIGN_INVENTORY",
"relatedTableId": 9,
"role": "esriRelRoleOrigin",
"keyField": "GlobalID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": true,
"catalogID": "{54E0BAB0-4470-476E-8FB9-FF77461BAF13}"
}
],
"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": 1707605414000
},
"supportsCoordinatesQuantization": true,
"supportsDynamicLegends": true
},
{
"currentVersion": 11.3,
"cimVersion": "3.3.0",
"id": 6,
"name": "Needs Inspected in 4 Fiscal Years",
"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": [
0,
112,
255,
255
],
"size": 17,
"angle": 0,
"xoffset": 0,
"yoffset": 0,
"outline": {
"color": [
0,
0,
0,
255
],
"width": 1
}
}
},
"scaleSymbols": true,
"transparency": 0,
"labelingInfo": null
},
"defaultVisibility": false,
"extent": {
"xmin": -9442114.5212,
"ymin": 4637280.771700002,
"xmax": -8963335.3149,
"ymax": 5185718.554300003,
"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": "STREET_NAME",
"fields": [
{
"name": "Shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape"
},
{
"name": "NLFID",
"type": "esriFieldTypeString",
"alias": "NLFID",
"length": 14
},
{
"name": "CRS",
"type": "esriFieldTypeString",
"alias": "CRS",
"length": 17
},
{
"name": "ODOT_DISTRICT",
"type": "esriFieldTypeString",
"alias": "ODOT District",
"length": 2
},
{
"name": "COUNTY",
"type": "esriFieldTypeString",
"alias": "County",
"length": 10
},
{
"name": "COUNTY_CD",
"type": "esriFieldTypeString",
"alias": "County CD",
"length": 3
},
{
"name": "ROUTE_TYPE",
"type": "esriFieldTypeString",
"alias": "Route Type",
"length": 2
},
{
"name": "ROUTE_NBR",
"type": "esriFieldTypeString",
"alias": "Route Number",
"length": 5
},
{
"name": "ROUTE_SUFFIX",
"type": "esriFieldTypeString",
"alias": "Route Suffix",
"length": 1
},
{
"name": "STREET_NAME",
"type": "esriFieldTypeString",
"alias": "Street Name",
"length": 100
},
{
"name": "CTL_BEGIN_NBR",
"type": "esriFieldTypeDouble",
"alias": "CTL Begin Number"
},
{
"name": "STL_BEGIN_NBR",
"type": "esriFieldTypeDouble",
"alias": "STL Begin Number"
},
{
"name": "LATITUDE_DD_BEGIN",
"type": "esriFieldTypeDouble",
"alias": "Latitude DD Begin"
},
{
"name": "LONGITUDE_DD_BEGIN",
"type": "esriFieldTypeDouble",
"alias": "Longitude DD Begin"
},
{
"name": "PERP_DATE",
"type": "esriFieldTypeDate",
"alias": "PERP Date",
"length": 8
},
{
"name": "STATUS",
"type": "esriFieldTypeString",
"alias": "Status",
"length": 1
},
{
"name": "INSTALLATION_DATE",
"type": "esriFieldTypeDate",
"alias": "Installation Date (Support)",
"length": 8
},
{
"name": "PID",
"type": "esriFieldTypeInteger",
"alias": "PID"
},
{
"name": "END_CONSTRUCTION_DATE",
"type": "esriFieldTypeDate",
"alias": "End of Construction Date",
"length": 8
},
{
"name": "LET_PLANS_URL",
"type": "esriFieldTypeString",
"alias": "Let Plans URL",
"length": 150
},
{
"name": "MAINTAIN_RESPONSIBLE",
"type": "esriFieldTypeString",
"alias": "Maintenance Responsibility",
"length": 1
},
{
"name": "INTERSECTION_ID",
"type": "esriFieldTypeString",
"alias": "Intersection ID",
"length": 36
},
{
"name": "CROSS_ROUTE_LEG_ID",
"type": "esriFieldTypeString",
"alias": "Approach ID",
"length": 36
},
{
"name": "SUPPORT_FILE_NUMBER",
"type": "esriFieldTypeString",
"alias": "Support File Number",
"length": 10
},
{
"name": "OLD_SUPPORT_ID",
"type": "esriFieldTypeString",
"alias": "Old Support ID",
"length": 25
},
{
"name": "SUPPORT_OWNER",
"type": "esriFieldTypeString",
"alias": "Support Owner",
"length": 10
},
{
"name": "LOCATION_DESCRIPTION",
"type": "esriFieldTypeString",
"alias": "Location Description",
"length": 255
},
{
"name": "PROJECT_NAME",
"type": "esriFieldTypeString",
"alias": "Project Name",
"length": 32
},
{
"name": "PROJECT_NUMBER",
"type": "esriFieldTypeString",
"alias": "Project Number",
"length": 10
},
{
"name": "ROUTE_DESIGNATION",
"type": "esriFieldTypeString",
"alias": "Route Designation",
"length": 8
},
{
"name": "SUPPORT_CATEGORY",
"type": "esriFieldTypeString",
"alias": "Support Category",
"length": 14
},
{
"name": "SUPPORT_STYLE",
"type": "esriFieldTypeInteger",
"alias": "Support Style"
},
{
"name": "SUPPORT_TYPE",
"type": "esriFieldTypeString",
"alias": "Support Type",
"length": 20
},
{
"name": "DESIGN_NUMBER",
"type": "esriFieldTypeString",
"alias": "Design Number",
"length": 2
},
{
"name": "SUPPORT_SIZE",
"type": "esriFieldTypeString",
"alias": "Support Size",
"length": 50
},
{
"name": "NUM_OF_SUPPORTS",
"type": "esriFieldTypeInteger",
"alias": "Number of Supports"
},
{
"name": "NUM_OF_SIGNS",
"type": "esriFieldTypeInteger",
"alias": "Number of Signs"
},
{
"name": "BRIDGE_MOUNTED",
"type": "esriFieldTypeString",
"alias": "Mounted On Bridge",
"length": 1
},
{
"name": "MEDIAN_WALL_PLATES",
"type": "esriFieldTypeString",
"alias": "Median Wall Plates",
"length": 1
},
{
"name": "BREAKAWAY_MECHANISM",
"type": "esriFieldTypeString",
"alias": "Breakaway Mechanism",
"length": 1
},
{
"name": "FLANGE_TYPE",
"type": "esriFieldTypeString",
"alias": "Flange Type",
"length": 15
},
{
"name": "REFLECTOR_STRIP",
"type": "esriFieldTypeString",
"alias": "Reflector Strip",
"length": 1
},
{
"name": "OVERHEAD_SPAN_LENGTH",
"type": "esriFieldTypeDouble",
"alias": "Overhead Span Length (ft)"
},
{
"name": "ATTACHMENTS",
"type": "esriFieldTypeString",
"alias": "Attachments",
"length": 1
},
{
"name": "ATTACHMENT_COMMENTS",
"type": "esriFieldTypeString",
"alias": "Attachment Comments",
"length": 2500
},
{
"name": "PAINTED",
"type": "esriFieldTypeString",
"alias": "Painted",
"length": 1
},
{
"name": "SIGN_SUPPORT_REPLACE",
"type": "esriFieldTypeString",
"alias": "Sign/Support Replacement",
"length": 25
},
{
"name": "REPLACEMENT_DATE",
"type": "esriFieldTypeDate",
"alias": "Replacement Date",
"length": 8
},
{
"name": "REPLACEMENT_PID",
"type": "esriFieldTypeInteger",
"alias": "Replacement PID"
},
{
"name": "ACCESS_CONTROL",
"type": "esriFieldTypeInteger",
"alias": "Access Control"
},
{
"name": "PATH_WEB_VIEWER",
"type": "esriFieldTypeString",
"alias": "Path Web Viewer",
"length": 500
},
{
"name": "MAINTAIN_RECOMMEND",
"type": "esriFieldTypeString",
"alias": "Maintenance Recommended",
"length": 1
},
{
"name": "INSPECTION_DUE",
"type": "esriFieldTypeString",
"alias": "Inspection Due",
"length": 28
},
{
"name": "SUPPORT_INV_COMMENTS",
"type": "esriFieldTypeString",
"alias": "Support Inventory Comments",
"length": 2500
},
{
"name": "created_user",
"type": "esriFieldTypeString",
"alias": "created_user",
"length": 255
},
{
"name": "created_date",
"type": "esriFieldTypeDate",
"alias": "created_date",
"length": 8
},
{
"name": "last_edited_user",
"type": "esriFieldTypeString",
"alias": "last_edited_user",
"length": 255
},
{
"name": "last_edited_date",
"type": "esriFieldTypeDate",
"alias": "last_edited_date",
"length": 8
},
{
"name": "sys_updated_date",
"type": "esriFieldTypeDate",
"alias": "sys_updated_date",
"length": 8
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"length": 38
},
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID"
}
],
"geometryField": {
"name": "Shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape"
},
"indexes": [
{
"name": "UUID_19",
"fields": "GlobalID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "I160ODOT_DISTRIC",
"fields": "ODOT_DISTRICT,COUNTY,COUNTY_CD",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "gdb_ct3_19",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "S6_idx",
"fields": "Shape",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"relationships": [
{
"id": 10,
"name": "SIGNS_SUPPORT_INSPECTION",
"relatedTableId": 10,
"role": "esriRelRoleOrigin",
"keyField": "GlobalID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": true,
"catalogID": "{21C7204C-0D9B-4F93-8A0A-891E86D412DA}"
},
{
"id": 11,
"name": "SIGNS_SIGN_INVENTORY",
"relatedTableId": 9,
"role": "esriRelRoleOrigin",
"keyField": "GlobalID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": true,
"catalogID": "{54E0BAB0-4470-476E-8FB9-FF77461BAF13}"
}
],
"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": 1707605414000
},
"supportsCoordinatesQuantization": true,
"supportsDynamicLegends": true
},
{
"currentVersion": 11.3,
"cimVersion": "3.3.0",
"id": 7,
"name": "Needs Inspected in 5 Fiscal Years",
"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": [
76,
230,
0,
255
],
"size": 17,
"angle": 0,
"xoffset": 0,
"yoffset": 0,
"outline": {
"color": [
0,
0,
0,
255
],
"width": 1
}
}
},
"scaleSymbols": true,
"transparency": 0,
"labelingInfo": null
},
"defaultVisibility": false,
"extent": {
"xmin": -9442114.5212,
"ymin": 4637280.771700002,
"xmax": -8963335.3149,
"ymax": 5185718.554300003,
"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": "STREET_NAME",
"fields": [
{
"name": "Shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape"
},
{
"name": "NLFID",
"type": "esriFieldTypeString",
"alias": "NLFID",
"length": 14
},
{
"name": "CRS",
"type": "esriFieldTypeString",
"alias": "CRS",
"length": 17
},
{
"name": "ODOT_DISTRICT",
"type": "esriFieldTypeString",
"alias": "ODOT District",
"length": 2
},
{
"name": "COUNTY",
"type": "esriFieldTypeString",
"alias": "County",
"length": 10
},
{
"name": "COUNTY_CD",
"type": "esriFieldTypeString",
"alias": "County CD",
"length": 3
},
{
"name": "ROUTE_TYPE",
"type": "esriFieldTypeString",
"alias": "Route Type",
"length": 2
},
{
"name": "ROUTE_NBR",
"type": "esriFieldTypeString",
"alias": "Route Number",
"length": 5
},
{
"name": "ROUTE_SUFFIX",
"type": "esriFieldTypeString",
"alias": "Route Suffix",
"length": 1
},
{
"name": "STREET_NAME",
"type": "esriFieldTypeString",
"alias": "Street Name",
"length": 100
},
{
"name": "CTL_BEGIN_NBR",
"type": "esriFieldTypeDouble",
"alias": "CTL Begin Number"
},
{
"name": "STL_BEGIN_NBR",
"type": "esriFieldTypeDouble",
"alias": "STL Begin Number"
},
{
"name": "LATITUDE_DD_BEGIN",
"type": "esriFieldTypeDouble",
"alias": "Latitude DD Begin"
},
{
"name": "LONGITUDE_DD_BEGIN",
"type": "esriFieldTypeDouble",
"alias": "Longitude DD Begin"
},
{
"name": "PERP_DATE",
"type": "esriFieldTypeDate",
"alias": "PERP Date",
"length": 8
},
{
"name": "STATUS",
"type": "esriFieldTypeString",
"alias": "Status",
"length": 1
},
{
"name": "INSTALLATION_DATE",
"type": "esriFieldTypeDate",
"alias": "Installation Date (Support)",
"length": 8
},
{
"name": "PID",
"type": "esriFieldTypeInteger",
"alias": "PID"
},
{
"name": "END_CONSTRUCTION_DATE",
"type": "esriFieldTypeDate",
"alias": "End of Construction Date",
"length": 8
},
{
"name": "LET_PLANS_URL",
"type": "esriFieldTypeString",
"alias": "Let Plans URL",
"length": 150
},
{
"name": "MAINTAIN_RESPONSIBLE",
"type": "esriFieldTypeString",
"alias": "Maintenance Responsibility",
"length": 1
},
{
"name": "INTERSECTION_ID",
"type": "esriFieldTypeString",
"alias": "Intersection ID",
"length": 36
},
{
"name": "CROSS_ROUTE_LEG_ID",
"type": "esriFieldTypeString",
"alias": "Approach ID",
"length": 36
},
{
"name": "SUPPORT_FILE_NUMBER",
"type": "esriFieldTypeString",
"alias": "Support File Number",
"length": 10
},
{
"name": "OLD_SUPPORT_ID",
"type": "esriFieldTypeString",
"alias": "Old Support ID",
"length": 25
},
{
"name": "SUPPORT_OWNER",
"type": "esriFieldTypeString",
"alias": "Support Owner",
"length": 10
},
{
"name": "LOCATION_DESCRIPTION",
"type": "esriFieldTypeString",
"alias": "Location Description",
"length": 255
},
{
"name": "PROJECT_NAME",
"type": "esriFieldTypeString",
"alias": "Project Name",
"length": 32
},
{
"name": "PROJECT_NUMBER",
"type": "esriFieldTypeString",
"alias": "Project Number",
"length": 10
},
{
"name": "ROUTE_DESIGNATION",
"type": "esriFieldTypeString",
"alias": "Route Designation",
"length": 8
},
{
"name": "SUPPORT_CATEGORY",
"type": "esriFieldTypeString",
"alias": "Support Category",
"length": 14
},
{
"name": "SUPPORT_STYLE",
"type": "esriFieldTypeInteger",
"alias": "Support Style"
},
{
"name": "SUPPORT_TYPE",
"type": "esriFieldTypeString",
"alias": "Support Type",
"length": 20
},
{
"name": "DESIGN_NUMBER",
"type": "esriFieldTypeString",
"alias": "Design Number",
"length": 2
},
{
"name": "SUPPORT_SIZE",
"type": "esriFieldTypeString",
"alias": "Support Size",
"length": 50
},
{
"name": "NUM_OF_SUPPORTS",
"type": "esriFieldTypeInteger",
"alias": "Number of Supports"
},
{
"name": "NUM_OF_SIGNS",
"type": "esriFieldTypeInteger",
"alias": "Number of Signs"
},
{
"name": "BRIDGE_MOUNTED",
"type": "esriFieldTypeString",
"alias": "Mounted On Bridge",
"length": 1
},
{
"name": "MEDIAN_WALL_PLATES",
"type": "esriFieldTypeString",
"alias": "Median Wall Plates",
"length": 1
},
{
"name": "BREAKAWAY_MECHANISM",
"type": "esriFieldTypeString",
"alias": "Breakaway Mechanism",
"length": 1
},
{
"name": "FLANGE_TYPE",
"type": "esriFieldTypeString",
"alias": "Flange Type",
"length": 15
},
{
"name": "REFLECTOR_STRIP",
"type": "esriFieldTypeString",
"alias": "Reflector Strip",
"length": 1
},
{
"name": "OVERHEAD_SPAN_LENGTH",
"type": "esriFieldTypeDouble",
"alias": "Overhead Span Length (ft)"
},
{
"name": "ATTACHMENTS",
"type": "esriFieldTypeString",
"alias": "Attachments",
"length": 1
},
{
"name": "ATTACHMENT_COMMENTS",
"type": "esriFieldTypeString",
"alias": "Attachment Comments",
"length": 2500
},
{
"name": "PAINTED",
"type": "esriFieldTypeString",
"alias": "Painted",
"length": 1
},
{
"name": "SIGN_SUPPORT_REPLACE",
"type": "esriFieldTypeString",
"alias": "Sign/Support Replacement",
"length": 25
},
{
"name": "REPLACEMENT_DATE",
"type": "esriFieldTypeDate",
"alias": "Replacement Date",
"length": 8
},
{
"name": "REPLACEMENT_PID",
"type": "esriFieldTypeInteger",
"alias": "Replacement PID"
},
{
"name": "ACCESS_CONTROL",
"type": "esriFieldTypeInteger",
"alias": "Access Control"
},
{
"name": "PATH_WEB_VIEWER",
"type": "esriFieldTypeString",
"alias": "Path Web Viewer",
"length": 500
},
{
"name": "MAINTAIN_RECOMMEND",
"type": "esriFieldTypeString",
"alias": "Maintenance Recommended",
"length": 1
},
{
"name": "INSPECTION_DUE",
"type": "esriFieldTypeString",
"alias": "Inspection Due",
"length": 28
},
{
"name": "SUPPORT_INV_COMMENTS",
"type": "esriFieldTypeString",
"alias": "Support Inventory Comments",
"length": 2500
},
{
"name": "created_user",
"type": "esriFieldTypeString",
"alias": "created_user",
"length": 255
},
{
"name": "created_date",
"type": "esriFieldTypeDate",
"alias": "created_date",
"length": 8
},
{
"name": "last_edited_user",
"type": "esriFieldTypeString",
"alias": "last_edited_user",
"length": 255
},
{
"name": "last_edited_date",
"type": "esriFieldTypeDate",
"alias": "last_edited_date",
"length": 8
},
{
"name": "sys_updated_date",
"type": "esriFieldTypeDate",
"alias": "sys_updated_date",
"length": 8
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"length": 38
},
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID"
}
],
"geometryField": {
"name": "Shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape"
},
"indexes": [
{
"name": "UUID_19",
"fields": "GlobalID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "I160ODOT_DISTRIC",
"fields": "ODOT_DISTRICT,COUNTY,COUNTY_CD",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "gdb_ct3_19",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "S6_idx",
"fields": "Shape",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"relationships": [
{
"id": 12,
"name": "SIGNS_SUPPORT_INSPECTION",
"relatedTableId": 10,
"role": "esriRelRoleOrigin",
"keyField": "GlobalID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": true,
"catalogID": "{21C7204C-0D9B-4F93-8A0A-891E86D412DA}"
},
{
"id": 13,
"name": "SIGNS_SIGN_INVENTORY",
"relatedTableId": 9,
"role": "esriRelRoleOrigin",
"keyField": "GlobalID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": true,
"catalogID": "{54E0BAB0-4470-476E-8FB9-FF77461BAF13}"
}
],
"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": 1707605414000
},
"supportsCoordinatesQuantization": true,
"supportsDynamicLegends": true
},
{
"currentVersion": 11.3,
"cimVersion": "3.3.0",
"id": 8,
"name": "Sign Needs Replaced",
"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": -100000,
"zUnits": 10000,
"falseM": 0,
"mUnits": 1
},
"copyrightText": "",
"parentLayer": null,
"subLayers": [],
"minScale": 0,
"maxScale": 0,
"referenceScale": 0.0,
"drawingInfo": {
"renderer": {
"type": "simple",
"symbol": {
"type": "esriSMS",
"style": "esriSMSCircle",
"color": [
230,
0,
0,
255
],
"size": 14,
"angle": 0,
"xoffset": 0,
"yoffset": 0,
"outline": {
"color": [
0,
0,
0,
255
],
"width": 1
}
}
},
"scaleSymbols": true,
"transparency": 0,
"labelingInfo": null
},
"defaultVisibility": false,
"extent": {
"xmin": -9409924.2189,
"ymin": 4639237.9036,
"xmax": -8963670.4416,
"ymax": 5150467.7535,
"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": "ODOT_DISTRICT",
"fields": [
{
"name": "Shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape"
},
{
"name": "ODOT_DISTRICT",
"type": "esriFieldTypeString",
"alias": "ODOT District",
"length": 2
},
{
"name": "COUNTY_CD",
"type": "esriFieldTypeString",
"alias": "County CD",
"length": 3
},
{
"name": "ROUTE_NBR",
"type": "esriFieldTypeString",
"alias": "Route Number",
"length": 5
},
{
"name": "SUPPORT_FILE_NUMBER",
"type": "esriFieldTypeString",
"alias": "Support File Number",
"length": 10
},
{
"name": "LOCATION_DESCRIPTION",
"type": "esriFieldTypeString",
"alias": "Location Description",
"length": 255
},
{
"name": "SUPPORT_CATEGORY",
"type": "esriFieldTypeString",
"alias": "Support Category",
"length": 16
},
{
"name": "SUPPORT_STYLE",
"type": "esriFieldTypeString",
"alias": "Support Style",
"length": 40
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"length": 38
},
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID"
},
{
"name": "CTL_BEGIN_NUMBER",
"type": "esriFieldTypeDouble",
"alias": "CTL Begin Number"
},
{
"name": "SIGN_FILE_NUMBER",
"type": "esriFieldTypeString",
"alias": "Sign File Number",
"length": 10
},
{
"name": "SIGN_CODE",
"type": "esriFieldTypeString",
"alias": "Sign Code",
"length": 150
},
{
"name": "SIGN_INSTALLATION_YEAR",
"type": "esriFieldTypeString",
"alias": "Sign Installation Year",
"length": 4
},
{
"name": "FREEWAY_SIGN",
"type": "esriFieldTypeString",
"alias": "Freeway Sign",
"length": 3
},
{
"name": "MOUNT_POSITION",
"type": "esriFieldTypeString",
"alias": "Mount Position",
"length": 14
},
{
"name": "REPLACE_FREQUENCY",
"type": "esriFieldTypeString",
"alias": "Replace Frequency",
"length": 10
},
{
"name": "SIGN_PHOTO_LINK",
"type": "esriFieldTypeString",
"alias": "Sign Photo Link",
"length": 300
},
{
"name": "SIGN_MAP_CHANNEL",
"type": "esriFieldTypeString",
"alias": "Sign Map Channel",
"length": 300
},
{
"name": "created_user",
"type": "esriFieldTypeString",
"alias": "created_user",
"length": 255
},
{
"name": "created_date",
"type": "esriFieldTypeDate",
"alias": "created_date",
"length": 8
},
{
"name": "last_edited_user",
"type": "esriFieldTypeString",
"alias": "last_edited_user",
"length": 255
},
{
"name": "last_edited_date",
"type": "esriFieldTypeDate",
"alias": "last_edited_date",
"length": 8
}
],
"geometryField": {
"name": "Shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape"
},
"indexes": [
{
"name": "UUID_149",
"fields": "GlobalID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "gdb_ct3_149",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "S64_idx",
"fields": "Shape",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"relationships": [],
"canModifyLayer": true,
"canScaleSymbols": false,
"hasLabels": false,
"capabilities": "Map,Query,Data",
"maxRecordCount": 2000,
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"hasZ": 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,
"hasMetadata": true,
"isDataArchived": true,
"archivingInfo": {
"supportsQueryWithHistoricMoment": true,
"startArchivingMoment": 1707605775000
},
"supportsCoordinatesQuantization": true,
"supportsDynamicLegends": true
}
],
"tables": [
{
"currentVersion": 11.3,
"cimVersion": "3.3.0",
"id": 9,
"name": "Sign Inventory (Active)",
"type": "Table",
"description": null,
"hasAttachments": true,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"displayField": "SIGN_FILE_NUMBER",
"fields": [
{
"name": "STATUS",
"type": "esriFieldTypeString",
"alias": "Status",
"length": 1
},
{
"name": "INSTALLATION_DATE",
"type": "esriFieldTypeDate",
"alias": "Installation Date (Sign)",
"length": 8
},
{
"name": "PID",
"type": "esriFieldTypeInteger",
"alias": "PID"
},
{
"name": "END_CONSTRUCTION_DATE",
"type": "esriFieldTypeDate",
"alias": "End of Construction Date",
"length": 8
},
{
"name": "LET_PLANS_URL",
"type": "esriFieldTypeString",
"alias": "Let Plans URL",
"length": 150
},
{
"name": "MAINTAIN_RESPONSIBLE",
"type": "esriFieldTypeString",
"alias": "Maintenance Responsibility",
"length": 1
},
{
"name": "SIGN_FILE_NUMBER",
"type": "esriFieldTypeString",
"alias": "Sign File Number",
"length": 10
},
{
"name": "OLD_SIGN_FILE_ID",
"type": "esriFieldTypeString",
"alias": "Old Sign File ID",
"length": 25
},
{
"name": "SIGN_OWNER",
"type": "esriFieldTypeString",
"alias": "Sign Owner",
"length": 20
},
{
"name": "SIGN_CATEGORY",
"type": "esriFieldTypeInteger",
"alias": "Sign Category"
},
{
"name": "SIGN_CODE",
"type": "esriFieldTypeString",
"alias": "Sign Code",
"length": 20
},
{
"name": "SIGN_TEXT",
"type": "esriFieldTypeString",
"alias": "Additional Sign Text",
"length": 255
},
{
"name": "MOUNT_POSITION",
"type": "esriFieldTypeString",
"alias": "Mount Position",
"length": 20
},
{
"name": "TRAVEL_DIRECTION",
"type": "esriFieldTypeString",
"alias": "Travel Direction",
"length": 1
},
{
"name": "BLANK_MATERIAL",
"type": "esriFieldTypeString",
"alias": "Blank Material",
"length": 20
},
{
"name": "SIGN_WIDTH_INCHES",
"type": "esriFieldTypeInteger",
"alias": "Sign Width (Inches)"
},
{
"name": "SIGN_HEIGHT_INCHES",
"type": "esriFieldTypeInteger",
"alias": "Sign Height (Inches)"
},
{
"name": "SIGN_AREA_SQFT",
"type": "esriFieldTypeDouble",
"alias": "Sign Area (Sq Ft)"
},
{
"name": "SIGN_BEACON",
"type": "esriFieldTypeString",
"alias": "Sign Beacon",
"length": 1
},
{
"name": "EXTERNAL_LIGHTING",
"type": "esriFieldTypeString",
"alias": "External Lighting",
"length": 1
},
{
"name": "INTERNAL_LIGHTING",
"type": "esriFieldTypeString",
"alias": "Internal Lighting",
"length": 1
},
{
"name": "BLANKOUT",
"type": "esriFieldTypeString",
"alias": "Blank-Out",
"length": 1
},
{
"name": "LED_ENHANCED",
"type": "esriFieldTypeString",
"alias": "LED-Enhanced",
"length": 1
},
{
"name": "VARIABLE_MESSAGE",
"type": "esriFieldTypeString",
"alias": "Variable Message",
"length": 1
},
{
"name": "HINGED",
"type": "esriFieldTypeString",
"alias": "Hinged",
"length": 1
},
{
"name": "EMS_EIMS_NUMBER",
"type": "esriFieldTypeInteger",
"alias": "EMS/EIMS Number"
},
{
"name": "SIGN_REFLECT_MEASURE",
"type": "esriFieldTypeInteger",
"alias": "Sign Reflectivity Measurement"
},
{
"name": "SIGN_REFLECT_MEASUR_DT",
"type": "esriFieldTypeDate",
"alias": "Sign Reflectivity Measurement Date",
"length": 8
},
{
"name": "FREEWAY_SIGN",
"type": "esriFieldTypeString",
"alias": "Freeway Sign",
"length": 1
},
{
"name": "SIGN_INV_COMMENTS",
"type": "esriFieldTypeString",
"alias": "Sign Comments",
"length": 2500
},
{
"name": "REL_GLOBALID",
"type": "esriFieldTypeGUID",
"alias": "REL_GLOBALID",
"length": 38
},
{
"name": "created_user",
"type": "esriFieldTypeString",
"alias": "created_user",
"length": 255
},
{
"name": "created_date",
"type": "esriFieldTypeDate",
"alias": "created_date",
"length": 8
},
{
"name": "last_edited_user",
"type": "esriFieldTypeString",
"alias": "last_edited_user",
"length": 255
},
{
"name": "last_edited_date",
"type": "esriFieldTypeDate",
"alias": "last_edited_date",
"length": 8
},
{
"name": "sys_updated_date",
"type": "esriFieldTypeDate",
"alias": "sys_updated_date",
"length": 8
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"length": 38
},
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID"
}
],
"indexes": [
{
"name": "UUID_21",
"fields": "GlobalID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "G162REL_GLOBALID",
"fields": "REL_GLOBALID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "gdb_ct3_21",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": false,
"description": ""
}
],
"subtypes": [],
"relationships": [
{
"id": 1,
"name": "SIGNS_SUPPORT_INVENTORY",
"relatedTableId": 0,
"role": "esriRelRoleDestination",
"keyField": "REL_GLOBALID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": true,
"catalogID": "{54E0BAB0-4470-476E-8FB9-FF77461BAF13}"
},
{
"id": 3,
"name": "SIGNS_SUPPORT_INVENTORY",
"relatedTableId": 2,
"role": "esriRelRoleDestination",
"keyField": "REL_GLOBALID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": true,
"catalogID": "{54E0BAB0-4470-476E-8FB9-FF77461BAF13}"
},
{
"id": 5,
"name": "SIGNS_SUPPORT_INVENTORY",
"relatedTableId": 3,
"role": "esriRelRoleDestination",
"keyField": "REL_GLOBALID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": true,
"catalogID": "{54E0BAB0-4470-476E-8FB9-FF77461BAF13}"
},
{
"id": 7,
"name": "SIGNS_SUPPORT_INVENTORY",
"relatedTableId": 4,
"role": "esriRelRoleDestination",
"keyField": "REL_GLOBALID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": true,
"catalogID": "{54E0BAB0-4470-476E-8FB9-FF77461BAF13}"
},
{
"id": 9,
"name": "SIGNS_SUPPORT_INVENTORY",
"relatedTableId": 5,
"role": "esriRelRoleDestination",
"keyField": "REL_GLOBALID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": true,
"catalogID": "{54E0BAB0-4470-476E-8FB9-FF77461BAF13}"
},
{
"id": 11,
"name": "SIGNS_SUPPORT_INVENTORY",
"relatedTableId": 6,
"role": "esriRelRoleDestination",
"keyField": "REL_GLOBALID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": true,
"catalogID": "{54E0BAB0-4470-476E-8FB9-FF77461BAF13}"
},
{
"id": 13,
"name": "SIGNS_SUPPORT_INVENTORY",
"relatedTableId": 7,
"role": "esriRelRoleDestination",
"keyField": "REL_GLOBALID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": true,
"catalogID": "{54E0BAB0-4470-476E-8FB9-FF77461BAF13}"
}
],
"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": 1707605200000
}
},
{
"currentVersion": 11.3,
"cimVersion": "3.3.0",
"id": 10,
"name": "Overhead Support Inspection",
"type": "Table",
"description": null,
"hasAttachments": true,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"displayField": "INSPECTION_DATE",
"fields": [
{
"name": "FOUNDATION_CRACKS",
"type": "esriFieldTypeString",
"alias": "Foundation Concrete Cracks",
"length": 10
},
{
"name": "FOUND_SPALLING",
"type": "esriFieldTypeString",
"alias": "Foundation Concrete Spalling",
"length": 1
},
{
"name": "FOUND_SOIL_EROSION",
"type": "esriFieldTypeString",
"alias": "Foundation Soil Erosion",
"length": 1
},
{
"name": "FOUND_COVERED",
"type": "esriFieldTypeString",
"alias": "Foundation Buried/Covered",
"length": 1
},
{
"name": "FOUND_OTHER",
"type": "esriFieldTypeString",
"alias": "Foundation Other",
"length": 1
},
{
"name": "FOUND_COMMENTS",
"type": "esriFieldTypeString",
"alias": "Foundation Comments",
"length": 2500
},
{
"name": "ANCHOR_BOLT_CORROSION",
"type": "esriFieldTypeString",
"alias": "Foundation Anchor Bolts Corrosion",
"length": 25
},
{
"name": "ANCHOR_BOLT_CRACKING",
"type": "esriFieldTypeString",
"alias": "Foundation Anchor Bolts Cracks",
"length": 10
},
{
"name": "ANCHOR_NUTS_CORROSION",
"type": "esriFieldTypeString",
"alias": "Foundation Nuts Corrosion",
"length": 25
},
{
"name": "ANCHOR_NUTS_CRACKING",
"type": "esriFieldTypeString",
"alias": "Foundation Nuts Cracks",
"length": 10
},
{
"name": "ANCHOR_NUTS_LOOSE",
"type": "esriFieldTypeString",
"alias": "Foundation Nuts Loose",
"length": 1
},
{
"name": "MISSING_WASHERS",
"type": "esriFieldTypeString",
"alias": "Foundation Missing Washers",
"length": 1
},
{
"name": "ANC_BOLT_NUTS_COMMENTS",
"type": "esriFieldTypeString",
"alias": "Foundation Anchor Bolts/Nuts Comments",
"length": 2500
},
{
"name": "EF_EP_CORROSION",
"type": "esriFieldTypeString",
"alias": "End Frame/Pole Corrosion",
"length": 25
},
{
"name": "EF_EP_DAMAGE",
"type": "esriFieldTypeString",
"alias": "End Frame/Pole Damage",
"length": 20
},
{
"name": "EF_EP_CRACKING",
"type": "esriFieldTypeString",
"alias": "End Frame/Pole Cracking",
"length": 10
},
{
"name": "EF_EP_WIRE_CAP_MISS",
"type": "esriFieldTypeString",
"alias": "End Frame/Pole Wire Entrance Cap Missing",
"length": 1
},
{
"name": "EF_EP_COVERS_MISSING",
"type": "esriFieldTypeString",
"alias": "End Frame/Pole Handhole Covers Missing",
"length": 1
},
{
"name": "EF_EP_CAP_MISSING",
"type": "esriFieldTypeString",
"alias": "End Frame/Pole Cap Missing",
"length": 1
},
{
"name": "EF_EP_BOLT_CORROSION",
"type": "esriFieldTypeString",
"alias": "End Frame/Pole Bolt Corrosion",
"length": 25
},
{
"name": "EF_EP_MISSING_BOLTS",
"type": "esriFieldTypeString",
"alias": "End Frame/Pole Missing Bolts",
"length": 1
},
{
"name": "EF_EP_WELD_CORROSION",
"type": "esriFieldTypeString",
"alias": "End Frame/Pole Weld Corrosion",
"length": 25
},
{
"name": "EF_EP_WELD_CRACKING",
"type": "esriFieldTypeString",
"alias": "End Frame/Pole Weld Cracking",
"length": 10
},
{
"name": "EF_EP_OTHER",
"type": "esriFieldTypeString",
"alias": "End Frame/Pole Other",
"length": 1
},
{
"name": "EF_EP_COMMENTS",
"type": "esriFieldTypeString",
"alias": "End Frame/Pole Comments",
"length": 2500
},
{
"name": "CANT_SPAN_CORROSION",
"type": "esriFieldTypeString",
"alias": "Cantilever/Span Corrosion",
"length": 25
},
{
"name": "CANT_SPAN_DAMAGE",
"type": "esriFieldTypeString",
"alias": "Cantilever/Span Damage",
"length": 10
},
{
"name": "CANT_SPAN_CRACKING",
"type": "esriFieldTypeString",
"alias": "Cantilever/Span Cracking",
"length": 10
},
{
"name": "CANT_SPAN_FLANGE_CRACK",
"type": "esriFieldTypeString",
"alias": "Cantilever/Span Flange Cracking",
"length": 10
},
{
"name": "CANT_SPAN_BOLT_CORROS",
"type": "esriFieldTypeString",
"alias": "Cantilever/Span Bolt Corrosion",
"length": 25
},
{
"name": "CANT_SPAN_MISS_BOLTS",
"type": "esriFieldTypeString",
"alias": "Cantilever/Span Missing Bolts",
"length": 1
},
{
"name": "CANT_SPAN_WELD_CORROS",
"type": "esriFieldTypeString",
"alias": "Cantilever/Span Weld Corrosion",
"length": 25
},
{
"name": "CANT_SPAN_WELD_CRACK",
"type": "esriFieldTypeString",
"alias": "Cantilever/Span Weld Cracking",
"length": 10
},
{
"name": "CANT_SPAN_ENDCAPS_MISS",
"type": "esriFieldTypeString",
"alias": "Cantiliver/Span End Caps Missing",
"length": 1
},
{
"name": "CANT_SPAN_OTHER",
"type": "esriFieldTypeString",
"alias": "Cantilever/Span Other",
"length": 1
},
{
"name": "CANT_SPAN_COMMENTS",
"type": "esriFieldTypeString",
"alias": "Cantilever/Span Comments",
"length": 2500
},
{
"name": "SIGN_ATTACH_CORROSION",
"type": "esriFieldTypeString",
"alias": "Sign Attachment Corrosion",
"length": 25
},
{
"name": "SIGN_ATTACH_DEFOR",
"type": "esriFieldTypeString",
"alias": "Sign Attachment Deformations",
"length": 1
},
{
"name": "ATTACH_MISS_HARDWARE",
"type": "esriFieldTypeString",
"alias": "Sign Attachment Missing Hardware",
"length": 1
},
{
"name": "SIGN_DAMAGE",
"type": "esriFieldTypeString",
"alias": "Sign Damage",
"length": 20
},
{
"name": "LIGHTING_MISS_HARDWARE",
"type": "esriFieldTypeString",
"alias": "Sign Lighting Missing Hardware",
"length": 1
},
{
"name": "OBSTRUCTION_OVERGROWTH",
"type": "esriFieldTypeString",
"alias": "Sign Obstruction/Overgrowth",
"length": 1
},
{
"name": "SIGN_INSP_COMMENTS",
"type": "esriFieldTypeString",
"alias": "Sign Comments",
"length": 2500
},
{
"name": "OVERALL_CONDITION",
"type": "esriFieldTypeInteger",
"alias": "Overall Condition"
},
{
"name": "INSPECTION_COMMENTS",
"type": "esriFieldTypeString",
"alias": "Inspection Comments",
"length": 2500
},
{
"name": "INSPECTOR_INITIALS",
"type": "esriFieldTypeString",
"alias": "Inspector Initials",
"length": 255
},
{
"name": "INSPECTION_DATE",
"type": "esriFieldTypeDate",
"alias": "Inspection Date",
"length": 8
},
{
"name": "MAINTENANCE_RECOMMEND",
"type": "esriFieldTypeString",
"alias": "Maintenance Recommended",
"length": 1
},
{
"name": "MAINTENANCE_COMPLETED",
"type": "esriFieldTypeString",
"alias": "Maintenance Completed",
"length": 1
},
{
"name": "MAINTENANCE_COMPLET_DT",
"type": "esriFieldTypeDate",
"alias": "Maintenance Completed Date",
"length": 8
},
{
"name": "MAINTENANCE_COMMENT",
"type": "esriFieldTypeString",
"alias": "Maintenance Comment",
"length": 2500
},
{
"name": "REL_GLOBALID",
"type": "esriFieldTypeGUID",
"alias": "REL_GLOBALID",
"length": 38
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"length": 38
},
{
"name": "created_user",
"type": "esriFieldTypeString",
"alias": "created_user",
"length": 255
},
{
"name": "created_date",
"type": "esriFieldTypeDate",
"alias": "created_date",
"length": 8
},
{
"name": "last_edited_user",
"type": "esriFieldTypeString",
"alias": "last_edited_user",
"length": 255
},
{
"name": "last_edited_date",
"type": "esriFieldTypeDate",
"alias": "last_edited_date",
"length": 8
},
{
"name": "sys_updated_date",
"type": "esriFieldTypeDate",
"alias": "sys_updated_date",
"length": 8
},
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID"
}
],
"indexes": [
{
"name": "UUID_20",
"fields": "GlobalID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "G161REL_GLOBALID",
"fields": "REL_GLOBALID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "gdb_ct3_20",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": false,
"description": ""
}
],
"subtypes": [],
"relationships": [
{
"id": 0,
"name": "SIGNS_SUPPORT_INVENTORY",
"relatedTableId": 0,
"role": "esriRelRoleDestination",
"keyField": "REL_GLOBALID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": true,
"catalogID": "{21C7204C-0D9B-4F93-8A0A-891E86D412DA}"
},
{
"id": 2,
"name": "SIGNS_SUPPORT_INVENTORY",
"relatedTableId": 2,
"role": "esriRelRoleDestination",
"keyField": "REL_GLOBALID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": true,
"catalogID": "{21C7204C-0D9B-4F93-8A0A-891E86D412DA}"
},
{
"id": 4,
"name": "SIGNS_SUPPORT_INVENTORY",
"relatedTableId": 3,
"role": "esriRelRoleDestination",
"keyField": "REL_GLOBALID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": true,
"catalogID": "{21C7204C-0D9B-4F93-8A0A-891E86D412DA}"
},
{
"id": 6,
"name": "SIGNS_SUPPORT_INVENTORY",
"relatedTableId": 4,
"role": "esriRelRoleDestination",
"keyField": "REL_GLOBALID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": true,
"catalogID": "{21C7204C-0D9B-4F93-8A0A-891E86D412DA}"
},
{
"id": 8,
"name": "SIGNS_SUPPORT_INVENTORY",
"relatedTableId": 5,
"role": "esriRelRoleDestination",
"keyField": "REL_GLOBALID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": true,
"catalogID": "{21C7204C-0D9B-4F93-8A0A-891E86D412DA}"
},
{
"id": 10,
"name": "SIGNS_SUPPORT_INVENTORY",
"relatedTableId": 6,
"role": "esriRelRoleDestination",
"keyField": "REL_GLOBALID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": true,
"catalogID": "{21C7204C-0D9B-4F93-8A0A-891E86D412DA}"
},
{
"id": 12,
"name": "SIGNS_SUPPORT_INVENTORY",
"relatedTableId": 7,
"role": "esriRelRoleDestination",
"keyField": "REL_GLOBALID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": true,
"catalogID": "{21C7204C-0D9B-4F93-8A0A-891E86D412DA}"
}
],
"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": 1707605427000
}
}
]
}