{ "layers": [], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "Signs", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 50, "domain": null }, { "name": "ATTACHID", "type": "esriFieldTypeString", "alias": "Attachment ID", "length": 50, "domain": null }, { "name": "SIGNTYPE", "type": "esriFieldTypeString", "alias": "Sign Type", "length": 50, "domain": { "type": "codedValue", "name": "SignType", "description": "The type of street sign", "codedValues": [ { "name": "Regulatory", "code": "Regulatory" }, { "name": "Warning", "code": "Warning" }, { "name": "Guide", "code": "Guide" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SIGNSIZE", "type": "esriFieldTypeString", "alias": "Sign Size", "length": 20, "domain": { "type": "codedValue", "name": "SignSize", "description": "The valid list of sign sizes", "codedValues": [ { "name": "3\" x 30\"", "code": "3\" x 30\"" }, { "name": "4\" x 10\"", "code": "4\" x 10\"" }, { "name": "4\" x 12\"", "code": "4\" x 12\"" }, { "name": "4\" x 24\"", "code": "4\" x 24\"" }, { "name": "4\" x 30\"", "code": "4\" x 30\"" }, { "name": "6\" x 8\"", "code": "6\" x 8\"" }, { "name": "6\" x 9\"", "code": "6\" x 9\"" }, { "name": "6\" x 10\"", "code": "6\" x 10\"" }, { "name": "6\" x 12\"", "code": "6\" x 12\"" }, { "name": "6\" x 18\"", "code": "6\" x 18\"" }, { "name": "6\" x 24\"", "code": "6\" x 24\"" }, { "name": "6\" x 30\"", "code": "6\" x 30\"" }, { "name": "6\" x 36\"", "code": "6\" x 36\"" }, { "name": "6\" x 40\"", "code": "6\" x 40\"" }, { "name": "6\" x 42\"", "code": "6\" x 42\"" }, { "name": "8\" x 10\"", "code": "8\" x 10\"" }, { "name": "8\" x 12\"", "code": "8\" x 12\"" }, { "name": "8\" x 24\"", "code": "8\" x 24\"" }, { "name": "8\" x 30\"", "code": "8\" x 30\"" }, { "name": "8\" x 36\"", "code": "8\" x 36\"" }, { "name": "8\" x 40\"", "code": "8\" x 40\"" }, { "name": "8\" x 42\"", "code": "8\" x 42\"" }, { "name": "9\" x 10\"", "code": "9\" x 10\"" }, { "name": "9\" x 12\"", "code": "9\" x 12\"" }, { "name": "9\" x 18\"", "code": "9\" x 18\"" }, { "name": "9\" x 30\"", "code": "9\" x 30\"" }, { "name": "10\" x 13\"", "code": "10\" x 13\"" }, { "name": "10\" x 18\"", "code": "10\" x 18\"" }, { "name": "10\" x 24\"", "code": "10\" x 24\"" }, { "name": "10\" x 30\"", "code": "10\" x 30\"" }, { "name": "10\" x 36\"", "code": "10\" x 36\"" }, { "name": "10\" x 40\"", "code": "10\" x 40\"" }, { "name": "10\" x 48\"", "code": "10\" x 48\"" }, { "name": "12\" x 12\"", "code": "12\" x 12\"" }, { "name": "12\" x 16\"", "code": "12\" x 16\"" }, { "name": "12\" x 18\"", "code": "12\" x 18\"" }, { "name": "12\" x 24\"", "code": "12\" x 24\"" }, { "name": "12\" x 30\"", "code": "12\" x 30\"" }, { "name": "12\" x 36\"", "code": "12\" x 36\"" }, { "name": "12\" x 42\"", "code": "12\" x 42\"" }, { "name": "12\" x 46\"", "code": "12\" x 46\"" }, { "name": "12\" x 48\"", "code": "12\" x 48\"" }, { "name": "12\" x 52\"", "code": "12\" x 52\"" }, { "name": "12\" x 60\"", "code": "12\" x 60\"" }, { "name": "12\" x 66\"", "code": "12\" x 66\"" }, { "name": "16\" x 24\"", "code": "16\" x 24\"" }, { "name": "16\" x 30\"", "code": "16\" x 30\"" }, { "name": "16\" x 72\"", "code": "16\" x 72\"" }, { "name": "18\" x 18\"", "code": "18\" x 18\"" }, { "name": "18\" x 20\"", "code": "18\" x 20\"" }, { "name": "18\" x 24\"", "code": "18\" x 24\"" }, { "name": "18\" x 26\"", "code": "18\" x 26\"" }, { "name": "18\" x 30\"", "code": "18\" x 30\"" }, { "name": "18\" x 36\"", "code": "18\" x 36\"" }, { "name": "18\" x 48\"", "code": "18\" x 48\"" }, { "name": "18\" x 60\"", "code": "18\" x 60\"" }, { "name": "18\" x 72\"", "code": "18\" x 72\"" }, { "name": "18\" x 84\"", "code": "18\" x 84\"" }, { "name": "18\" x 96\"", "code": "18\" x 96\"" }, { "name": "20\" x 40\"", "code": "20\" x 40\"" }, { "name": "24\" x 24\"", "code": "24\" x 24\"" }, { "name": "24\" x 30\"", "code": "24\" x 30\"" }, { "name": "24\" x 36\"", "code": "24\" x 36\"" }, { "name": "24\" x 28\"", "code": "24\" x 28\"" }, { "name": "30\" x 30\"", "code": "30\" x 30\"" }, { "name": "30\" x 36\"", "code": "30\" x 36\"" }, { "name": "30\" x 40\"", "code": "30\" x 40\"" }, { "name": "30\" x 42\"", "code": "30\" x 42\"" }, { "name": "30\" x 46\"", "code": "30\" x 46\"" }, { "name": "30\" x 48\"", "code": "30\" x 48\"" }, { "name": "30\" x 54\"", "code": "30\" x 54\"" }, { "name": "30\" x 66\"", "code": "30\" x 66\"" }, { "name": "36\" x 36\"", "code": "36\" x 36\"" }, { "name": "36\" x 48\"", "code": "36\" x 48\"" }, { "name": "41\" x 41\"", "code": "41\" x 41\"" }, { "name": "42\" x 42\"", "code": "42\" x 42\"" }, { "name": "48\" x 48\"", "code": "48\" x 48\"" }, { "name": "49\" x 49\"", "code": "49\" x 49\"" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SIGNSTYLE", "type": "esriFieldTypeString", "alias": "Style", "length": 130, "domain": { "type": "codedValue", "name": "SignCode", "description": "The codes assigned to the sign types", "codedValues": [ { "name": "Stop Sign", "code": "R1-1" }, { "name": "Yield", "code": "R1-2" }, { "name": "3 Way Stop", "code": "R1-3W" }, { "name": "4 Way Stop", "code": "R1-4W" }, { "name": "Speed Limit", "code": "R2-1" }, { "name": "Speed Zone Ahead", "code": "R2-5C" }, { "name": "No Right Turn (Symbol)", "code": "R3-1" }, { "name": "No Left Turn (Symbol)", "code": "R3-2" }, { "name": "Mandatory Movement Lane Control (Left)", "code": "R3-5L" }, { "name": "Mandatory Movement Lane Control (Right)", "code": "R3-5R" }, { "name": "Mandatory Movement (Ahead)", "code": "R3-5a" }, { "name": "Mandatory Movement Lane Control (Turn Left)", "code": "R3-7L" }, { "name": "Mandatory Movement Lane Control (Turn Right)", "code": "R3-7R" }, { "name": "Bike Lane Ahead", "code": "R3-16" }, { "name": "Keep Right (with horizontal arrow)", "code": "R4-7a" }, { "name": "Keep Right (with oblique arrow)", "code": "R4-7b" }, { "name": "Do Not Enter", "code": "R5-1" }, { "name": "Wrong Way", "code": "R5-1a" }, { "name": "No Trucks (symbol)", "code": "R5-2" }, { "name": "No Trucks", "code": "R5-2a" }, { "name": "One Way (enclosed in right arrow)", "code": "R6-1(R)" }, { "name": "One Way (enclosed in left arrow)", "code": "R6-1(L)" }, { "name": "One Way (with right arrow)", "code": "R6-2(R)" }, { "name": "No Parking", "code": "R8-3" }, { "name": "Stop Here on Red", "code": "R10-6" }, { "name": "No Turn on Red", "code": "R10-11" }, { "name": "No Turn on Red", "code": "R10-11b" }, { "name": "Left Turn Yield on Green Ball", "code": "R10-12" }, { "name": "Road Closed", "code": "R11-2" }, { "name": "Road Closed 10 Miles Ahead Local Traffic Only", "code": "R11-3a" }, { "name": "Road Closed to Thru Traffic", "code": "R11-4" }, { "name": "Weight Limit 8 T (symbol) 12 T (symbol) 16 T (symbol)", "code": "R12-5" }, { "name": "Curve (90 degree - Left )", "code": "W1-1L" }, { "name": "Curve (90 degree - Right )", "code": "W1-1R" }, { "name": "Curve (left)", "code": "W1-2L" }, { "name": "Curve (right)", "code": "W1-2R" }, { "name": "Reverse Turn (left)", "code": "W1-3L" }, { "name": "Reverse Turn (right)", "code": "W1-3R" }, { "name": "Reverse Curve (left)", "code": "W1-4L" }, { "name": "Reverse Curve (right)", "code": "W1-4R" }, { "name": "Winding Road (left)", "code": "W1-5L" }, { "name": "Winding Road (right)", "code": "W1-5R" }, { "name": "Large Arrow (Left Turn)", "code": "W1-6L" }, { "name": "Large Arrow (Right Turn)", "code": "W1-6R" }, { "name": "Large Arrow (2-directions)", "code": "W1-7" }, { "name": "Chevron Alignment (left)", "code": "W1-8L" }, { "name": "Chevron Alignment (right)", "code": "W1-8R" }, { "name": "Cross Road", "code": "W2-1" }, { "name": "Side Road (perpendicular)", "code": "W2-2L" }, { "name": "Side Road (perpendicular)", "code": "W2-2R" }, { "name": "T Symbol", "code": "W2-4" }, { "name": "Stop Ahead (symbol)", "code": "W3-1" }, { "name": "Yield Ahead (symbol)", "code": "W3-2" }, { "name": "Signal Ahead (symbol)", "code": "W3-3" }, { "name": "Entering Roadway Merge", "code": "W4-5" }, { "name": "Divided Highway (Road) (symbol)", "code": "W6-1" }, { "name": "Divided Highway (Road) Ends (symbol)", "code": "W6-2" }, { "name": "Two Way Traffic (symbol)", "code": "W6-3" }, { "name": "Slippery When Wet (symbol)", "code": "W8-5" }, { "name": "Low Shoulder", "code": "W8-9" }, { "name": "Right (Left) Lane Ends", "code": "W9-1" }, { "name": "Lane Ends Merge Left (Right)", "code": "W9-2" }, { "name": "Lane Ends Merge Left (Right) Alt", "code": "W9-2 alternate" }, { "name": "Highway-Rail Grade Crossing (advance warning)", "code": "W10-1" }, { "name": "Pedestrian (symbol)", "code": "W11-2" }, { "name": "Emergency Vehicle (symbol)", "code": "W11-8" }, { "name": "Advisory Speed", "code": "W13-1" }, { "name": "Dead End", "code": "W14-1" }, { "name": "No Outlet", "code": "W14-2" }, { "name": "Speed Hump", "code": "W17-1" }, { "name": "Detour (Ahead, 500FT, 1000 FT, 1/2 Mile)", "code": "W20-2" }, { "name": "Road (Street) Closed (Ahead, 500 FT, 1000 FT, 1/2 Mile)", "code": "W20-3" }, { "name": "Workers (symbol)", "code": "W21-1a" }, { "name": "End Road Work", "code": "G20-2" }, { "name": "End Detour Marker", "code": "M4-8a" }, { "name": "Detour Sign (with arrow) (right)", "code": "M4-9R" }, { "name": "Detour Sign (with arrow) (left)", "code": "M4-9L" }, { "name": "U.S. Route Marker (for guide sign use)", "code": "M1-4" }, { "name": "State Route Marker", "code": "M1-5" }, { "name": "Junction Marker", "code": "M2-1" }, { "name": "Cardinal Directional Marker - North", "code": "M3-1" }, { "name": "Cardinal Directional Marker - East", "code": "M3-2" }, { "name": "Cardinal Directional Marker - South", "code": "M3-3" }, { "name": "Cardinal Directional Marker - West", "code": "M3-4" }, { "name": "To Marker", "code": "M4-5" }, { "name": "Advance Turn Arrow (Left)", "code": "M5-1L" }, { "name": "Advance Turn Arrow (Right)", "code": "M5-1R" }, { "name": "Advance Turn Arrow (Left Diagonal)", "code": "M5-2L" }, { "name": "Advance Turn Arrow (Right Diagonal)", "code": "M5-2R" }, { "name": "Advance Turn Arrow (Left Horizontal)", "code": "M6-1L" }, { "name": "Advance Turn Arrow (Right Horizontal)", "code": "M6-1R" }, { "name": "Advance Turn Arrow (45 degree Left )", "code": "M6-2L" }, { "name": "Advance Turn Arrow (45 degree Right)", "code": "M6-2R" }, { "name": "Directional Arrow (straight ahead)", "code": "M6-3" }, { "name": "Directional Arrow (turn right or left)", "code": "M6-4" }, { "name": "Right Turn 90 degree / Straight Ahead Arrow", "code": "M6-6R" }, { "name": "Left Turn 90 degree / Straight Ahead Arrow", "code": "M6-6L" }, { "name": "Straight Ahead Arrow / 45 degree turn right", "code": "M6-7R" }, { "name": "Straight Ahead Arrow / 45 degree turn left", "code": "M6-7L" }, { "name": "Straight Ahead / 90 degree turn", "code": "M6-8" }, { "name": "T - Left or Right Turn", "code": "M6-9" }, { "name": "Street Name Blade", "code": "D1-1c" }, { "name": "Rocky Mountain National Park 6 Miles", "code": "D7-1" }, { "name": "Rocky Mountain National Park", "code": "D7-2" }, { "name": "Hospital (symbol)", "code": "D9-2" }, { "name": "International Symbol of Access for the Handicapped", "code": "D9-6" }, { "name": "Police Assistance", "code": "D9-14" }, { "name": "Bus Station (symbol)", "code": "I-5" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FACING", "type": "esriFieldTypeString", "alias": "Facing Direction", "length": 20, "domain": { "type": "codedValue", "name": "Direction", "description": "The direction the sign is facing", "codedValues": [ { "name": "East", "code": "East" }, { "name": "North", "code": "North" }, { "name": "South", "code": "South" }, { "name": "West", "code": "West" }, { "name": "Northeast", "code": "Northeast" }, { "name": "Northwest", "code": "Northwest" }, { "name": "Southeast", "code": "Southeast" }, { "name": "Southwest", "code": "Southwest" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "HORIZCLEAR", "type": "esriFieldTypeString", "alias": "Horizontal Clearance", "length": 12, "domain": null }, { "name": "HORIZFROM", "type": "esriFieldTypeString", "alias": "Horizontal From", "length": 12, "domain": null }, { "name": "VERTFROM", "type": "esriFieldTypeString", "alias": "Vertical From", "length": 12, "domain": null }, { "name": "ANGLE", "type": "esriFieldTypeSmallInteger", "alias": "Angle (Degrees)", "domain": null }, { "name": "REFLCOAT", "type": "esriFieldTypeString", "alias": "Reflective Coating", "length": 15, "domain": null }, { "name": "SUPMATERIAL", "type": "esriFieldTypeString", "alias": "Supplemental Materials", "length": 30, "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "CONDITION", "type": "esriFieldTypeString", "alias": "Condition", "length": 50, "domain": { "type": "codedValue", "name": "Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ROTATION", "type": "esriFieldTypeDouble", "alias": "Rotation", "domain": null }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "length": 8, "domain": null }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R1715_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1715", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G6409ATTACHID", "fields": "ATTACHID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G6409FACILITYID", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } } ] }