{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 284, "name": "SignType", "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": 20, "domain": null }, { "name": "SIGNTYPE", "type": "esriFieldTypeSmallInteger", "alias": "Sign Type", "domain": null }, { "name": "SIGNSTYLE", "type": "esriFieldTypeString", "alias": "Style", "length": 130, "domain": { "type": "codedValue", "name": "WS2_SignRegulatory_1", "description": "List of Regulatory sign types", "codedValues": [ { "name": "Stop Sign", "code": "R1-1" }, { "name": "Yield", "code": "R1-2" }, { "name": "To Oncoming Traffic (plaque)", "code": "R1-2aP" }, { "name": "3 Way Stop", "code": "R1-3W" }, { "name": "4 Way Stop", "code": "R1-4W" }, { "name": "Yield Here to Pedestrians", "code": "R1-5,5a" }, { "name": "In-Street Pedestrian Crossing", "code": "R1-6" }, { "name": "Speed Limit", "code": "R2-1" }, { "name": "Minimum Speed Limit (plaque)", "code": "R2-4P" }, { "name": "Speed Zone Ahead", "code": "R2-5C" }, { "name": "Unless Otherwise Posted (plaque)", "code": "R2-5P" }, { "name": "No Right Turn (Symbol)", "code": "R3-1" }, { "name": "No Left Turn (Symbol)", "code": "R3-2" }, { "name": "No Turns", "code": "R3-3" }, { "name": "No U-Turns (symbol)", "code": "R3-4" }, { "name": "Left Turn Only", "code": "R3-5L" }, { "name": "Right Turn Only", "code": "R3-5R" }, { "name": "Straight Ahead Only", "code": "R3-5a" }, { "name": "Left Turn or Straight Ahead Only (symbol)", "code": "R3-6" }, { "name": "Left Lane Must Turn Left", "code": "R3-7L" }, { "name": "Right Lane Must Turn Right", "code": "R3-7R" }, { "name": "Advance Intersection Lane Control", "code": "R3-8,8a,8b" }, { "name": "Center Lane turn only", "code": "R3-9a,9b" }, { "name": "Begin (plaque)", "code": "R3-9cP" }, { "name": "End (plaque)", "code": "R3-9dP" }, { "name": "Bike Lane Ahead", "code": "R3-16" }, { "name": "Do Not Pass", "code": "R4-1" }, { "name": "Keep Right", "code": "R4-7a,7b,7c" }, { "name": "Keep Left", "code": "R4-8a,8b,8c" }, { "name": "Do Not Drive on Shoulder", "code": "R4-17" }, { "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": "No Motor Vehicles", "code": "R5-3" }, { "name": "No Commercial Vehicles", "code": "R5-4" }, { "name": "No Bicycles", "code": "R5-6" }, { "name": "Authorized Vehicles Only", "code": "R5-11(V)" }, { "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": "Divided Highway Crossing", "code": "R6-3,3a" }, { "name": "Parking Restrictions", "code": "R7-1(various)" }, { "name": "Van Accessible (plaque)", "code": "R7-8P" }, { "name": "Tow Away Zone (plaque)", "code": "R7-201P" }, { "name": "Tow Away Zone Penalty $100-$500 Fine (plaque)", "code": "R7-VP1" }, { "name": "No Parking", "code": "R8-3" }, { "name": "On Bridge (plaque)", "code": "R8-3dP" }, { "name": "On Tracks (plaque", "code": "R8-3eP" }, { "name": "Loading Zone (plaque)", "code": "R8-3gP" }, { "name": "Times of Day (plaque)", "code": "R8-3hP" }, { "name": "Unattended Vehicles Subject to Towing at Owners Expense (plaque)", "code": "R8-VP1" }, { "name": "Cross Only at Crosswalks", "code": "R9-2" }, { "name": "Use Crosswalk (plaque)", "code": "R9-3bP" }, { "name": "Pedestrian Signs", "code": "R10-2,3,4" }, { "name": "Stop Here on Red", "code": "R10-6" }, { "name": "Do Not Block Intersection", "code": "R10-7" }, { "name": "No Turn on Red", "code": "R10-11" }, { "name": "No Turn on Red (11b)", "code": "R10-11b" }, { "name": "Left Turn Yield on Green", "code": "R10-12" }, { "name": "Turning Vehicles Yield to Pedestrians", "code": "R10-15" }, { "name": "Left Turn Yield On Flashing Yellow", "code": "R10-VP1" }, { "name": "Road Closed", "code": "R11-2" }, { "name": "Road Closed to Thru Traffic", "code": "R11-4" }, { "name": "Weight Limit (symbol)", "code": "R12-V1" }, { "name": "Bridge", "code": "R12-VP1" }, { "name": "Truck Route", "code": "R14-1" }, { "name": "Lights On When Using Wipers or Raining", "code": "R16-7" }, { "name": "No Dumping", "code": "R0-V1" }, { "name": "Littering Is Illegal", "code": "R0-V2" }, { "name": "No Fishing From Bridge", "code": "R9-V1" }, { "name": "When Wet (plaque)", "code": "W8-5P" }, { "name": "Trail X-ing (plaque)", "code": "W11-15P" }, { "name": "Advisory Speed Plate (plaque)", "code": "W13-1P" }, { "name": "Share the Road (plaque)", "code": "W16-1P" }, { "name": "Supplemental Arrow (plaque)", "code": "W19-5P, 6P" }, { "name": "Ahead (plaque)", "code": "W19-9P" }, { "name": "When Flashing (plaque)", "code": "W19-13P" }, { "name": "No Jumping From Bridge", "code": "COS_001" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" }, { "name": "RR Crossing", "code": "W10-1" }, { "name": "No Train Horn", "code": "W10-9" }, { "name": "Push Left", "code": "OM-3L" }, { "name": "Push Center", "code": "OM-3C" }, { "name": "Push Right", "code": "OM-3R" }, { "name": "Lane ends - Merge Left", "code": "W9-2" }, { "name": "Street Assembly", "code": "D3-1" }, { "name": "Watch For Turning Vehicles", "code": "W11-V3" }, { "name": "Dead End", "code": "W14-1" }, { "name": "School Crossing", "code": "S1-1" }, { "name": "Chevron Right", "code": "W1-8R" }, { "name": "Chevron Left", "code": "W1-8L" }, { "name": "No Outlet", "code": "W14-2" }, { "name": "Signal Ahead", "code": "W3-3" }, { "name": "Oncoming traffic does not stop", "code": "W4-4bP" }, { "name": "Intersection Ahead", "code": "W2-1" }, { "name": "Interstate Ahead", "code": "M1-1" }, { "name": "Straight Ahead", "code": "M6-3" }, { "name": "Curve", "code": "W1-1" }, { "name": "Arrow", "code": "W1-6" }, { "name": "No Parking Here to Corner", "code": "R7-11" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SIGNSIZE", "type": "esriFieldTypeString", "alias": "SIGNSIZE", "length": 255, "domain": { "type": "codedValue", "name": "WS2_SignSize_3", "description": "List of different street sign sizes", "codedValues": [ { "name": "3\" x 30\"", "code": "Size_3\" x 30\"" }, { "name": "4\" x 10\"", "code": "Size_4\" x 10\"" }, { "name": "4\" x 12\"", "code": "Size_4\" x 12\"" }, { "name": "4\" x 24\"", "code": "Size_4\" x 24\"" }, { "name": "4\" x 30\"", "code": "Size_4\" x 30\"" }, { "name": "6\" x 8\"", "code": "Size_6\" x 8\"" }, { "name": "6\" x 9\"", "code": "Size_6\" x 9\"" }, { "name": "6\" x 10\"", "code": "Size_6\" x 10\"" }, { "name": "6\" x 12\"", "code": "Size_6\" x 12\"" }, { "name": "6\" x 18\"", "code": "Size_6\" x 18\"" }, { "name": "6\" x 24\"", "code": "Size_6\" x 24\"" }, { "name": "6\" x 30\"", "code": "Size_6\" x 30\"" }, { "name": "6\" x 36\"", "code": "Size_6\" x 36\"" }, { "name": "6\" x 40\"", "code": "Size_6\" x 40\"" }, { "name": "6\" x 42\"", "code": "Size_6\" x 42\"" }, { "name": "8\" x 10\"", "code": "Size_8\" x 10\"" }, { "name": "8\" x 12\"", "code": "Size_8\" x 12\"" }, { "name": "8\" x 24\"", "code": "Size_8\" x 24\"" }, { "name": "8\" x 30\"", "code": "Size_8\" x 30\"" }, { "name": "8\" x 36\"", "code": "Size_8\" x 36\"" }, { "name": "8\" x 40\"", "code": "Size_8\" x 40\"" }, { "name": "8\" x 42\"", "code": "Size_8\" x 42\"" }, { "name": "9\" x 10\"", "code": "Size_9\" x 10\"" }, { "name": "9\" x 12\"", "code": "Size_9\" x 12\"" }, { "name": "9\" x 18\"", "code": "Size_9\" x 18\"" }, { "name": "9\" x 30\"", "code": "Size_9\" x 30\"" }, { "name": "10\" x 13\"", "code": "Size_10\" x 13\"" }, { "name": "10\" x 18\"", "code": "Size_10\" x 18\"" }, { "name": "10\" x 24\"", "code": "Size_10\" x 24\"" }, { "name": "10\" x 30\"", "code": "Size_10\" x 30\"" }, { "name": "10\" x 36\"", "code": "Size_10\" x 36\"" }, { "name": "10\" x 40\"", "code": "Size_10\" x 40\"" }, { "name": "10\" x 48\"", "code": "Size_10\" x 48\"" }, { "name": "12\" x 12\"", "code": "Size_12\" x 12\"" }, { "name": "12\" x 16\"", "code": "Size_12\" x 16\"" }, { "name": "12\" x 18\"", "code": "Size_12\" x 18\"" }, { "name": "12\" x 24\"", "code": "Size_12\" x 24\"" }, { "name": "12\" x 30\"", "code": "Size_12\" x 30\"" }, { "name": "12\" x 36\"", "code": "Size_12\" x 36\"" }, { "name": "12\" x 42\"", "code": "Size_12\" x 42\"" }, { "name": "12\" x 46\"", "code": "Size_12\" x 46\"" }, { "name": "12\" x 48\"", "code": "Size_12\" x 48\"" }, { "name": "12\" x 52\"", "code": "Size_12\" x 52\"" }, { "name": "12\" x 60\"", "code": "Size_12\" x 60\"" }, { "name": "12\" x 66\"", "code": "Size_12\" x 66\"" }, { "name": "16\" x 24\"", "code": "Size_16\" x 24\"" }, { "name": "16\" x 30\"", "code": "Size_16\" x 30\"" }, { "name": "16\" x 72\"", "code": "Size_16\" x 72\"" }, { "name": "18\" x 18\"", "code": "Size_18\" x 18\"" }, { "name": "18\" x 20\"", "code": "Size_18\" x 20\"" }, { "name": "18\" x 24\"", "code": "Size_18\" x 24\"" }, { "name": "18\" x 26\"", "code": "Size_18\" x 26\"" }, { "name": "18\" x 30\"", "code": "Size_18\" x 30\"" }, { "name": "18\" x 36\"", "code": "Size_18\" x 36\"" }, { "name": "18\" x 48\"", "code": "Size_18\" x 48\"" }, { "name": "18\" x 60\"", "code": "Size_18\" x 60\"" }, { "name": "18\" x 72\"", "code": "Size_18\" x 72\"" }, { "name": "18\" x 84\"", "code": "Size_18\" x 84\"" }, { "name": "18\" x 96\"", "code": "Size_18\" x 96\"" }, { "name": "20\" x 40\"", "code": "Size_20\" x 40\"" }, { "name": "24\" x 24\"", "code": "Size_24\" x 24\"" }, { "name": "24\" x 30\"", "code": "Size_24\" x 30\"" }, { "name": "24\" x 36\"", "code": "Size_24\" x 36\"" }, { "name": "24\" x 28\"", "code": "Size_24\" x 28\"" }, { "name": "30\" x 30\"", "code": "Size_30\" x 30\"" }, { "name": "30\" x 36\"", "code": "Size_30\" x 36\"" }, { "name": "30\" x 40\"", "code": "Size_30\" x 40\"" }, { "name": "30\" x 42\"", "code": "Size_30\" x 42\"" }, { "name": "30\" x 46\"", "code": "Size_30\" x 46\"" }, { "name": "30\" x 48\"", "code": "Size_30\" x 48\"" }, { "name": "30\" x 54\"", "code": "Size_30\" x 54\"" }, { "name": "30\" x 66\"", "code": "Size_30\" x 66\"" }, { "name": "36\" x 36\"", "code": "Size_36\" x 36\"" }, { "name": "36\" x 48\"", "code": "Size_36\" x 48\"" }, { "name": "41\" x 41\"", "code": "Size_41\" x 41\"" }, { "name": "42\" x 42\"", "code": "Size_42\" x 42\"" }, { "name": "48\" x 48\"", "code": "Size_48\" x 48\"" }, { "name": "49\" x 49\"", "code": "Size_49\" x 49\"" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" }, { "name": "6\" x 48\"", "code": "Size_6\" x 48\"" }, { "name": "15\" x 21\"", "code": "Size_15\" x 21\" " }, { "name": "42\" x 48\"", "code": "Size_42\" x 48\"" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SIGNTEXT", "type": "esriFieldTypeString", "alias": "Text", "length": 100, "domain": null }, { "name": "FACING", "type": "esriFieldTypeString", "alias": "Facing Direction", "length": 30, "domain": { "type": "codedValue", "name": "WS2_Direction", "description": "A general description of cardinal direction", "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" }, { "name": "North/South", "code": "North/South" }, { "name": "East/West", "code": "East/West" }, { "name": "Northeast/Northwest", "code": "Northeast/Northwest" }, { "name": "Southeast/Southwest", "code": "Southeast/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": "DISTTOTOP", "type": "esriFieldTypeDouble", "alias": "Distance to Top of Pole", "domain": null }, { "name": "REFLCOAT", "type": "esriFieldTypeString", "alias": "Reflective Coating", "length": 50, "domain": null }, { "name": "SHEETING", "type": "esriFieldTypeString", "alias": "Sheeting Type", "length": 50, "domain": { "type": "codedValue", "name": "WS2_SignSheetType", "description": "The type of sheeting used on the sign", "codedValues": [ { "name": "Type I (Engineer Grade)", "code": "Type I (Engineer Grade)" }, { "name": "Type II (Super Engineer Grade)", "code": "Type II (Super Engineer Grade)" }, { "name": "Type III (High Intensity)", "code": "Type III (High Intensity)" }, { "name": "Type IV (Multi-Layer Sheeting)", "code": "Type IV (Multi-Layer Sheeting)" }, { "name": "Type V (Metallized Microprismatic)", "code": "Type V (Metallized Microprismatic)" }, { "name": "Type VI (Vinyl Backed Microprismatic)", "code": "Type VI (Vinyl Backed Microprismatic)" }, { "name": "Type VII (Microprismatic)", "code": "Type VII (Microprismatic)" }, { "name": "Type VIII (Microprismatic- Distinguishing)", "code": "Type VIII (Microprismatic- Distinguishing)" }, { "name": "Type IX (Fine Grain Microprisms)", "code": "Type IX (Fine Grain Microprisms)" }, { "name": "Type X (Microprismatic - Similar to Types VII-IX)", "code": "Type X (Microprismatic - Similar to Types VII-IX)" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "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": "WS2_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": "WS2_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": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "SignID", "type": "esriFieldTypeString", "alias": "SignID", "length": 50, "domain": null } ], "indexes": [ { "name": "R6732_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_99428_FACILI", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_99428_SignID", "fields": "SignID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "28f1b6ad7f3a4ef293bc851c4eb5b407" }