{ "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 113, "name": "Street Signs", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Project", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Project", "type": "esriFieldTypeString", "alias": "Project", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 50, "domain": { "type": "codedValue", "name": "Sign_type", "description": "Sign Type", "codedValues": [ { "name": "2 Way Traffic", "code": "2 Way Traffic" }, { "name": "20 Minute Limit", "code": "20 Minute Limit" }, { "name": "2hr Consecutive Parking", "code": "2hr Consecutive Parking" }, { "name": "2hr Parking", "code": "2hr Parking" }, { "name": "3- Way Stop", "code": "3- Way" }, { "name": "30 Minute Parking", "code": "30 Minute Parking" }, { "name": "Adopt a Street", "code": "Adopt a Street" }, { "name": "Advisory Speed", "code": "Advisory Speed" }, { "name": "Ahead", "code": "Ahead" }, { "name": "Arrow", "code": "Arrow" }, { "name": "Austic Child Area", "code": "Austic Child Area" }, { "name": "Authorized Vehicles Only", "code": "Authorized Vehicles Only" }, { "name": "Begin", "code": "Begin" }, { "name": "Begin Center Lane", "code": "Begin Center Lane" }, { "name": "Bike Route", "code": "Bike Route" }, { "name": "Bike Route Arrow", "code": "Bike Route Arrow" }, { "name": "Blind Child Area", "code": "Blind Child Area" }, { "name": "Boat Ramp", "code": "Boat Ramp" }, { "name": "Center Lane Tun Only", "code": "Center Lane Tun Only" }, { "name": "Chevron", "code": "Chevron" }, { "name": "Children at Play", "code": "Children at Play" }, { "name": "Circular Intersection", "code": "Circular Intersection" }, { "name": "City Limits", "code": "City Limits" }, { "name": "Clean up Pets", "code": "Clean up Pets" }, { "name": "Complementary Parking", "code": "Complementary Parking" }, { "name": "Crime Watch", "code": "Crime Watch" }, { "name": "Cross Street Symbol", "code": "Cross Street Symbol" }, { "name": "Cross Traffic Does Not Stop", "code": "Cross Traffic Does Not Stop" }, { "name": "Cross Walk", "code": "Cross Walk" }, { "name": "CSO", "code": "CSO" }, { "name": "Curve Arrow", "code": "Curve Arrow" }, { "name": "Dare", "code": "Dare" }, { "name": "Dead End", "code": "Dead End" }, { "name": "Deaf Child Area", "code": "Deaf Child Area" }, { "name": "Decorative 2hr Parking", "code": "Decorative 2hr Parking" }, { "name": "Deer Xing Symbol", "code": "Deer Xing Symbol" }, { "name": "Dileneator- Left", "code": "Dileneator- Left" }, { "name": "Dileneator- Right", "code": "Dileneator- Right" }, { "name": "Direction Arrows", "code": "Direction Arrows" }, { "name": "Divided Highway", "code": "Divided Highway" }, { "name": "Do Not Enter", "code": "Do Not Enter" }, { "name": "Do not Mow or Spray", "code": "Do not Mow or Spray" }, { "name": "Do Not Pass", "code": "Do Not Pass" }, { "name": "Double Arrow", "code": "Double Arrow" }, { "name": "Dual Turn Lane Arrow", "code": "Dual Turn Lane Arrow" }, { "name": "End", "code": "End" }, { "name": "End Center Lane", "code": "End Center Lane" }, { "name": "End Road Markers", "code": "End Road Markers" }, { "name": "End School Zone", "code": "End School Zone" }, { "name": "Fire Truck Symbol", "code": "Fire Truck Symbol" }, { "name": "Gateway", "code": "Gateway" }, { "name": "Golf Cart", "code": "Golf Cart" }, { "name": "Handicap Parking", "code": "Handicap Parking" }, { "name": "Hidden Drive", "code": "Hidden Drive" }, { "name": "High Water", "code": "High Water" }, { "name": "Historic Downtown", "code": "Historic Downtown" }, { "name": "Horse Xing", "code": "Horse Xing" }, { "name": "I69 Shield", "code": "I69 Shield" }, { "name": "Information", "code": "Information" }, { "name": "Keep Right", "code": "Keep Right" }, { "name": "Keep Right Arrow", "code": "Keep Right Arrow" }, { "name": "Kiosk", "code": "Kiosk" }, { "name": "Lane Control", "code": "Lane Control" }, { "name": "Left Lane Must Turn Left", "code": "Left Lane Must Turn Left" }, { "name": "Ln Ends Mrg Left", "code": "Ln Ends Mrg Left" }, { "name": "Ln Ends Mrg Right", "code": "Ln Ends Mrg Right" }, { "name": "Merging & Passing", "code": "Merging & Passing" }, { "name": "Narrow Bridge", "code": "Narrow Bridge" }, { "name": "Neighborhood Watch", "code": "Neighborhood Watch" }, { "name": "No Construction Parking", "code": "No Construction Parking" }, { "name": "No Handicap Access", "code": "No Handicap Access" }, { "name": "No Left Turn", "code": "No Left Turn" }, { "name": "No Motor Vehicles", "code": "No Motor Vehicles" }, { "name": "No Outlet", "code": "No Outlet" }, { "name": "No Parking", "code": "No Parking" }, { "name": "No Parking Between Signs", "code": "No Parking Between Signs" }, { "name": "No Parking Here to Corner", "code": "No Parking Here to Corner" }, { "name": "No Parking this side", "code": "No Parking this side" }, { "name": "No Passing Zone", "code": "No Passing Zone" }, { "name": "No Right Turn", "code": "No Right Turn" }, { "name": "No Soliciting", "code": "No Soliciting" }, { "name": "No Through Street", "code": "No Through Street" }, { "name": "No Trucks Symbol", "code": "No Trucks Symbol" }, { "name": "Object Markers", "code": "Object Markers" }, { "name": "One Way", "code": "One Way" }, { "name": "One Way Arrow- Lrg", "code": "One Way Arrow- Lrg" }, { "name": "One Way Arrow- Small", "code": "One Way Arrow- Small" }, { "name": "Parking w/ Arrow", "code": "Parking w/ Arrow" }, { "name": "Ped Xing Sign", "code": "Ped Xing Sign" }, { "name": "Ped Xing Symbol", "code": "Ped Xing Symbol" }, { "name": "Permit Parking", "code": "Permit Parking" }, { "name": "Preserve America", "code": "Preserve America" }, { "name": "Public Parking", "code": "Public Parking" }, { "name": "Railroad Xing", "code": "Railroad Xing" }, { "name": "Railroad Xing Rnd", "code": "Railroad Xing Rnd" }, { "name": "Reverse Curve", "code": "Reverse Curve" }, { "name": "Reverse Turn", "code": "Reverse Turn" }, { "name": "Right Lane Ends", "code": "Right Lane Ends" }, { "name": "Road Narrows", "code": "Road Narrows" }, { "name": "Rough Pavement Ahead", "code": "Rough Pavement Ahead" }, { "name": "Round-a-bout", "code": "Round-a-bout" }, { "name": "Round-a-bout Directional", "code": "Round-a-bout Directional" }, { "name": "Rt Lane Must Turn Right", "code": "Rt Lane Must Turn Right" }, { "name": "Rt Turn Only Arrow", "code": "Rt Turn Only Arrow" }, { "name": "Schl Bus Stop Ahead", "code": "Schl Bus Stop Ahead" }, { "name": "School Zone Arrow", "code": "School Zone Arrow" }, { "name": "School Zone Flasher", "code": "School Zone Flasher" }, { "name": "School Zone Sign", "code": "School Zone Sign" }, { "name": "Shared Street", "code": "Shared Street" }, { "name": "Sharp Curve", "code": "Sharp Curve" }, { "name": "Signal Ahead", "code": "Signal Ahead" }, { "name": "Signal Ahead Symbol", "code": "Signal Ahead Symbol" }, { "name": "Signs of significance", "code": "Signs of significance" }, { "name": "Slow Down Kids Playing", "code": "Slow Down" }, { "name": "Speed Cushion", "code": "Speed Cushion" }, { "name": "Speed Limit", "code": "Speed Limit" }, { "name": "Steve Wariner", "code": "Steve Wariner" }, { "name": "Stop", "code": "Stop" }, { "name": "Stop- All Way", "code": "Stop- All Way" }, { "name": "Stop- Four Way", "code": "Stop- Four Way" }, { "name": "Stop Ahead", "code": "Stop Ahead" }, { "name": "Stop Ahead Symbol", "code": "Stop Ahead Symbol" }, { "name": "Street ID", "code": "Street ID" }, { "name": "T- Street Symbol", "code": "T- Street Symbol" }, { "name": "To", "code": "To" }, { "name": "Warning Deep Water", "code": "Warning Deep Water" }, { "name": "Watch Ice Bridge", "code": "Watch Ice Bridge" }, { "name": "Waterway ID", "code": "Waterway ID" }, { "name": "Way Finder", "code": "Way Finder" }, { "name": "Weight Limit", "code": "Weight Limit" }, { "name": "Wrong Way", "code": "Wrong Way" }, { "name": "Yield", "code": "Yield" }, { "name": "Push Button", "code": "Push Button" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MUTCD_TYPE", "type": "esriFieldTypeString", "alias": "MUTCD_TYPE", "length": 50, "domain": null }, { "name": "Source", "type": "esriFieldTypeString", "alias": "Source", "length": 20, "domain": { "type": "codedValue", "name": "Sign_Source", "description": "Source", "codedValues": [ { "name": "GPS", "code": "GPS" }, { "name": "Electronic Asbuilts", "code": "Electronic Asbuilts" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Install_Date", "type": "esriFieldTypeDate", "alias": "Install_Date", "length": 8, "domain": null }, { "name": "Sign_size", "type": "esriFieldTypeString", "alias": "Sign_size", "length": 20, "domain": null }, { "name": "Sign_shape", "type": "esriFieldTypeString", "alias": "Sign_shape", "length": 20, "domain": { "type": "codedValue", "name": "Shape", "description": "Shape", "codedValues": [ { "name": "Rectangular", "code": "Rectangular" }, { "name": "Diamond", "code": "Diamond" }, { "name": "Circular", "code": "Circular" }, { "name": "Pennant", "code": "Pennant" }, { "name": "Square", "code": "Square" }, { "name": "Other", "code": "Other" }, { "name": "Octagon", "code": "Octagon" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Sign_condition", "type": "esriFieldTypeString", "alias": "Sign_condition", "length": 10, "domain": { "type": "codedValue", "name": "Condition", "description": "Condition", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "New", "code": "New" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Legend_Color", "type": "esriFieldTypeString", "alias": "Legend_Color", "length": 10, "domain": { "type": "codedValue", "name": "Legend Color", "description": "Legend Color", "codedValues": [ { "name": "Red", "code": "Red" }, { "name": "White", "code": "White" }, { "name": "Black", "code": "Black" }, { "name": "Blue", "code": "Blue" }, { "name": "Green", "code": "Green" }, { "name": "Brown", "code": "Brown" }, { "name": "Purple", "code": "Purple" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Background", "type": "esriFieldTypeString", "alias": "Background", "length": 10, "domain": { "type": "codedValue", "name": "Background", "description": "Background Color", "codedValues": [ { "name": "Blue", "code": "Blue" }, { "name": "Brown", "code": "Brown" }, { "name": "FYG", "code": "FYG" }, { "name": "Green", "code": "Green" }, { "name": "Red", "code": "Red" }, { "name": "White", "code": "White" }, { "name": "Yellow", "code": "Yellow" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Post_style", "type": "esriFieldTypeString", "alias": "Post_style", "length": 20, "domain": { "type": "codedValue", "name": "Post Style", "description": "Post Style", "codedValues": [ { "name": "Green Square", "code": "Green Square" }, { "name": "Round", "code": "Round" }, { "name": "Square", "code": "Square" }, { "name": "U-Channel", "code": "U-Channel" }, { "name": "Street Light", "code": "Street Light" }, { "name": "Traffic Signal", "code": "Traffic Signal" }, { "name": "2 Fluted Black Post", "code": "2 Fluted Black Post" }, { "name": "Black Square", "code": "Black Square" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Post_Condition", "type": "esriFieldTypeString", "alias": "Post_Condition", "length": 10, "domain": { "type": "codedValue", "name": "Condition", "description": "Condition", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "New", "code": "New" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 20, "domain": null }, { "name": "LocationID", "type": "esriFieldTypeString", "alias": "LocationID", "length": 20, "domain": null }, { "name": "Series", "type": "esriFieldTypeString", "alias": "Series", "length": 20, "domain": { "type": "codedValue", "name": "Series", "description": "Series", "codedValues": [ { "name": "Regulatory", "code": "Regulatory" }, { "name": "Warning", "code": "Warning" }, { "name": "Construction", "code": "Construction" }, { "name": "GUIDE", "code": "GUIDE" }, { "name": "School", "code": "School" }, { "name": "Street", "code": "Street" }, { "name": "Fire Safety", "code": "Fire Safety" }, { "name": "Industrial", "code": "Industrial" }, { "name": "ID", "code": "ID" }, { "name": "Emergency", "code": "Emergency" }, { "name": "Railroad", "code": "Railroad" }, { "name": "OSHA", "code": "OSHA" }, { "name": "Traffic Prohibition", "code": "Traffic Prohibition" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Speed", "type": "esriFieldTypeSmallInteger", "alias": "Speed", "domain": null }, { "name": "Date_Mapped", "type": "esriFieldTypeDate", "alias": "Date_Mapped", "length": 8, "domain": null }, { "name": "Route", "type": "esriFieldTypeString", "alias": "Route", "length": 30, "domain": null }, { "name": "Dir_Travel", "type": "esriFieldTypeString", "alias": "Dir_Travel", "length": 10, "domain": { "type": "codedValue", "name": "Dir_Travel", "description": "Dir_Travel", "codedValues": [ { "name": "NB", "code": "NB" }, { "name": "SB", "code": "SB" }, { "name": "WB", "code": "WB" }, { "name": "EB", "code": "EB" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Side_Rd", "type": "esriFieldTypeString", "alias": "Side_Rd", "length": 10, "domain": { "type": "codedValue", "name": "Side", "description": "Side of Road", "codedValues": [ { "name": "Left", "code": "Left" }, { "name": "Right", "code": "Right" }, { "name": "Center", "code": "Center" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Lat_Offset", "type": "esriFieldTypeSmallInteger", "alias": "Lat_Offset", "domain": null }, { "name": "Height", "type": "esriFieldTypeSmallInteger", "alias": "Height", "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 50, "domain": null }, { "name": "Hyperlink", "type": "esriFieldTypeString", "alias": "Hyperlink", "length": 100, "domain": null }, { "name": "RelateID", "type": "esriFieldTypeString", "alias": "RelateID", "length": 20, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "Field_ID", "type": "esriFieldTypeSmallInteger", "alias": "Field_ID", "domain": null }, { "name": "Owner", "type": "esriFieldTypeString", "alias": "Owner", "length": 20, "domain": null } ], "indexes": [ { "name": "R129_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_190_RelateID", "fields": "RelateID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "post", "relatedTableId": 9, "role": "esriRelRoleDestination", "keyField": "RelateID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{B9A77B82-B726-4947-8BC3-7867E5CF1BD8}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "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": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "3851bab8efe546559ebe463362a3c376" }