{ "currentVersion": 10.91, "id": 60, "name": "LongviewGIS.DBO.Traffic_Sign", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SIGN_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "BARCODE", "type": "esriFieldTypeString", "alias": "BARCODE", "length": 20, "domain": null }, { "name": "POLE_BARCODE", "type": "esriFieldTypeString", "alias": "POLE_BARCODE", "length": 20, "domain": null }, { "name": "SIGN_TYPE", "type": "esriFieldTypeString", "alias": "SIGN_TYPE", "length": 50, "domain": { "type": "codedValue", "name": "SignTypes", "description": "Sign Types", "codedValues": [ { "name": "D11-1 Bike Route", "code": "D11-1 Bike Route" }, { "name": "D42 Superior Water System", "code": "D42 Superior Water System" }, { "name": "D9-2 Hostpital", "code": "D9-2 Hostpital" }, { "name": "I-5 Airport", "code": "I-5 Airport" }, { "name": "I-7 Train Station", "code": "I-7 Train Station" }, { "name": "I14TL Post Office Left", "code": "I14TL Post Office Left" }, { "name": "I14TR Post Office Right", "code": "I14TR Post Office Right" }, { "name": "OM1-1 Object Marker Diamond", "code": "OM1-1 Object Marker Diamond" }, { "name": "OM1-2 Object Marker Diamond", "code": "OM1-2 Object Marker Diamond" }, { "name": "OM1-3 Object Marker Diamond", "code": "OM1-3 Object Marker Diamond" }, { "name": "OM3C Object Marker Combo", "code": "OM3C Object Marker Combo" }, { "name": "OM3L Object Marker Left", "code": "OM3L Object Marker Left" }, { "name": "OM3R Object Marker Right", "code": "OM3R Object Marker Right" }, { "name": "OM4-1 Object Marker Red", "code": "OM4-1 Object Marker Red" }, { "name": "OM4-2 Object Marker Red", "code": "OM4-2 Object Marker Red" }, { "name": "OM4-3 Object Marker Red", "code": "OM4-3 Object Marker Red" }, { "name": "R1-1 Stop", "code": "R1-1 Stop" }, { "name": "R1-2 Yield", "code": "R1-2 Yield" }, { "name": "R1-4 All Way", "code": "R1-4 All Way" }, { "name": "R10-10L Left Turn Signal", "code": "R10-10L Left Turn Signal" }, { "name": "R10-11 No Turn on Red", "code": "R10-11 No Turn on Red" }, { "name": "R10-12 Left Turn Yield on Green Ball", "code": "R10-12 Left Turn Yield on Green Ball" }, { "name": "R10-19T Photo Enforced", "code": "R10-19T Photo Enforced" }, { "name": "R14-1 Truck Route", "code": "R14-1 Truck Route" }, { "name": "R19-5 No Dumping", "code": "R19-5 No Dumping" }, { "name": "R2-1 (20) Speed", "code": "R2-1 (20) Speed" }, { "name": "R2-1 (25) Speed", "code": "R2-1 (25) Speed" }, { "name": "R2-1 (30) Speed", "code": "R2-1 (30) Speed" }, { "name": "R2-1 (35) Speed", "code": "R2-1 (35) Speed" }, { "name": "R2-1 (40) Speed", "code": "R2-1 (40) Speed" }, { "name": "R2-1 (45) Speed", "code": "R2-1 (45) Speed" }, { "name": "R2-1 (50) Speed", "code": "R2-1 (50) Speed" }, { "name": "R2-1 (55) Speed", "code": "R2-1 (55) Speed" }, { "name": "R2-1 (60) Speed", "code": "R2-1 (60) Speed" }, { "name": "R3-1 No Right Turn", "code": "R3-1 No Right Turn" }, { "name": "R3-2 No Left Turn", "code": "R3-2 No Left Turn" }, { "name": "R3-4 No U Turn", "code": "R3-4 No U Turn" }, { "name": "R3-8 No Turns", "code": "R3-8 No Turns" }, { "name": "R4-7 Keep Right", "code": "R4-7 Keep Right" }, { "name": "R5-1 Do Not Enter", "code": "R5-1 Do Not Enter" }, { "name": "R5-1a Wrong Way", "code": "R5-1a Wrong Way" }, { "name": "R5-2 No Trucks", "code": "R5-2 No Trucks" }, { "name": "R5-4a No Engine Brake", "code": "R5-4a No Engine Brake" }, { "name": "R6-1L One Way Left", "code": "R6-1L One Way Left" }, { "name": "R6-1R One Way Right", "code": "R6-1R One Way Right" }, { "name": "R6-2L One Way Left", "code": "R6-2L One Way Left" }, { "name": "R6-2R One Way Right", "code": "R6-2R One Way Right" }, { "name": "R7-1DBL NPA Both", "code": "R7-1DBL NPA Both" }, { "name": "R7-1L NPA Left", "code": "R7-1L NPA Left" }, { "name": "R7-1R NPA Right", "code": "R7-1R NPA Right" }, { "name": "R7-8b Van", "code": "R7-8b Van" }, { "name": "R7-8T Handicapped Parking", "code": "R7-8T Handicapped Parking" }, { "name": "S1-1 School Ped Crossing", "code": "S1-1 School Ped Crossing" }, { "name": "S3-1 School Bus Stop Ahead", "code": "S3-1 School Bus Stop Ahead" }, { "name": "S4-1 School Zone Times", "code": "S4-1 School Zone Times" }, { "name": "S4-1a School Zone Times", "code": "S4-1a School Zone Times" }, { "name": "S4-2 When Children Present", "code": "S4-2 When Children Present" }, { "name": "S4-3 School", "code": "S4-3 School" }, { "name": "S4-4 When Flashing", "code": "S4-4 When Flashing" }, { "name": "S4-6 School Days", "code": "S4-6 School Days" }, { "name": "S5-1 School Assembly", "code": "S5-1 School Assembly" }, { "name": "S5-2 End School Zone", "code": "S5-2 End School Zone" }, { "name": "S5-2a Small End School Zone", "code": "S5-2a Small End School Zone" }, { "name": "S6-1 Overhead School Assembly", "code": "S6-1 Overhead School Assembly" }, { "name": "S7-1T Cell Phone", "code": "S7-1T Cell Phone" }, { "name": "SNS Guide Sign", "code": "SNS Guide Sign" }, { "name": "SW16-7pL School Here Arrow Left", "code": "SW16-7pL School Here Arrow Left" }, { "name": "SW16-7pR School Here Arrow Right", "code": "SW16-7pR School Here Arrow Right" }, { "name": "SW16-9p School Ahead", "code": "SW16-9p School Ahead" }, { "name": "W1-10 Double Arrow with Bars", "code": "W1-10 Double Arrow with Bars" }, { "name": "W1-1L Left Sharp Curve", "code": "W1-1L Left Sharp Curve" }, { "name": "W1-1R Right Sharp Curve", "code": "W1-1R Right Sharp Curve" }, { "name": "W1-2L Left Curve", "code": "W1-2L Left Curve" }, { "name": "W1-2R Right Curve", "code": "W1-2R Right Curve" }, { "name": "W1-3L Left Sharp Double Curve", "code": "W1-3L Left Sharp Double Curve" }, { "name": "W1-3R Right Sharp Double Curve", "code": "W1-3R Right Sharp Double Curve" }, { "name": "W1-4L Left Double Curve", "code": "W1-4L Left Double Curve" }, { "name": "W1-4R Right Double Curve", "code": "W1-4R Right Double Curve" }, { "name": "W1-5L Left Curvy Road", "code": "W1-5L Left Curvy Road" }, { "name": "W1-5R Right Curvy Road", "code": "W1-5R Right Curvy Road" }, { "name": "W1-6L Left Arrow", "code": "W1-6L Left Arrow" }, { "name": "W1-6R Right Arrow", "code": "W1-6R Right Arrow" }, { "name": "W1-7 Double Arrow", "code": "W1-7 Double Arrow" }, { "name": "W1-8L Left Chevron", "code": "W1-8L Left Chevron" }, { "name": "W1-8R Right Chevron", "code": "W1-8R Right Chevron" }, { "name": "W1-9L Left Arrow with Bars", "code": "W1-9L Left Arrow with Bars" }, { "name": "W1-9R Right Arrow with Bars", "code": "W1-9R Right Arrow with Bars" }, { "name": "W10-1 Rail Road Cirlce", "code": "W10-1 Rail Road Cirlce" }, { "name": "W10-2L Rail to Left of Intersection", "code": "W10-2L Rail to Left of Intersection" }, { "name": "W10-2R Rail to Right of Intersection", "code": "W10-2R Rail to Right of Intersection" }, { "name": "W10-3L Rail to Left of T Intersection", "code": "W10-3L Rail to Left of T Intersection" }, { "name": "W10-3R Rail to Right of T Intersection", "code": "W10-3R Rail to Right of T Intersection" }, { "name": "W10-9 No Train Horn", "code": "W10-9 No Train Horn" }, { "name": "W11-1 Bycycle", "code": "W11-1 Bycycle" }, { "name": "W11-10L Truck Entrance Left", "code": "W11-10L Truck Entrance Left" }, { "name": "W11-10R Truck Entrance Right", "code": "W11-10R Truck Entrance Right" }, { "name": "W11-2 Pedestrian-Not School", "code": "W11-2 Pedestrian-Not School" }, { "name": "W11-3 Deer Crossing", "code": "W11-3 Deer Crossing" }, { "name": "W11-8L Fire Station Left", "code": "W11-8L Fire Station Left" }, { "name": "W11-8R Fire Station Right", "code": "W11-8R Fire Station Right" }, { "name": "W12-2T Clearance Diamond", "code": "W12-2T Clearance Diamond" }, { "name": "W12-3T Clearance Rectangle", "code": "W12-3T Clearance Rectangle" }, { "name": "W12-5 Load Zoned Bridge", "code": "W12-5 Load Zoned Bridge" }, { "name": "W13-1 Speed Advisory", "code": "W13-1 Speed Advisory" }, { "name": "W14-1 Dead End Diamond", "code": "W14-1 Dead End Diamond" }, { "name": "W14-1aL Dead End Left", "code": "W14-1aL Dead End Left" }, { "name": "W14-1aR Dead End Right", "code": "W14-1aR Dead End Right" }, { "name": "W14-2 No Outlet Diamond", "code": "W14-2 No Outlet Diamond" }, { "name": "W14-2aL No Outlet Rectangle Left", "code": "W14-2aL No Outlet Rectangle Left" }, { "name": "W14-2aR No Outlet Rectangle Right", "code": "W14-2aR No Outlet Rectangle Right" }, { "name": "W15-1 Playground", "code": "W15-1 Playground" }, { "name": "W16-10 Photo Enforced Warning", "code": "W16-10 Photo Enforced Warning" }, { "name": "W16-2 Distance Advisory 2 line", "code": "W16-2 Distance Advisory 2 line" }, { "name": "W16-3a Distance Advisory 1 line", "code": "W16-3a Distance Advisory 1 line" }, { "name": "W16-7pL Here Arrow Left", "code": "W16-7pL Here Arrow Left" }, { "name": "W16-7pR Here Arrow Right", "code": "W16-7pR Here Arrow Right" }, { "name": "W16-9p Ahead Rectangle", "code": "W16-9p Ahead Rectangle" }, { "name": "W19-7 Hostpital", "code": "W19-7 Hostpital" }, { "name": "W19-8 Church", "code": "W19-8 Church" }, { "name": "W2-1 Intersection Ahead", "code": "W2-1 Intersection Ahead" }, { "name": "W2-1aL Offset Intersection Left", "code": "W2-1aL Offset Intersection Left" }, { "name": "W2-1aR Offset Intersection Right", "code": "W2-1aR Offset Intersection Right" }, { "name": "W2-2L T Intersection Left", "code": "W2-2L T Intersection Left" }, { "name": "W2-2R T Intersection Right", "code": "W2-2R T Intersection Right" }, { "name": "W2-3L Y Intersetion Left", "code": "W2-3L Y Intersetion Left" }, { "name": "W2-3R Y Intersetion Right", "code": "W2-3R Y Intersetion Right" }, { "name": "W2-4 T Intersection", "code": "W2-4 T Intersection" }, { "name": "W20-7b Be Prepared to Stop", "code": "W20-7b Be Prepared to Stop" }, { "name": "W3-1 Stop Ahead", "code": "W3-1 Stop Ahead" }, { "name": "W3-3 Signal Ahead", "code": "W3-3 Signal Ahead" }, { "name": "W3-5 Speed Zone Ahead", "code": "W3-5 Speed Zone Ahead" }, { "name": "W4-4 Cross Traffic Does Not Stop", "code": "W4-4 Cross Traffic Does Not Stop" }, { "name": "W6-1 Divided Highway", "code": "W6-1 Divided Highway" }, { "name": "W6-3 Two Way Traffic", "code": "W6-3 Two Way Traffic" }, { "name": "W8-1 Bump", "code": "W8-1 Bump" }, { "name": "W8-15 Watch for Water on Road", "code": "W8-15 Watch for Water on Road" }, { "name": "W8-2 DIP", "code": "W8-2 DIP" }, { "name": "W9-1L Left Lane Ends", "code": "W9-1L Left Lane Ends" }, { "name": "W9-1R Right Lane Ends", "code": "W9-1R Right Lane Ends" }, { "name": "W9-2L Merge Left", "code": "W9-2L Merge Left" }, { "name": "W9-2R Merge Right", "code": "W9-2R Merge Right" }, { "name": "Wayfinding Motorist", "code": "Wayfind Motor" }, { "name": "Wayfinding Pedestrian", "code": "Wayfind Ped" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SIGN_SIZE", "type": "esriFieldTypeString", "alias": "SIGN_SIZE", "length": 15, "domain": { "type": "codedValue", "name": "SignSizes", "description": "Sizes for Traffic_Signs", "codedValues": [ { "name": "12x6", "code": "12x6" }, { "name": "18x12", "code": "18x12" }, { "name": "18x24", "code": "18x24" }, { "name": "18x30", "code": "18x30" }, { "name": "18x9", "code": "18x9" }, { "name": "24x12", "code": "24x12" }, { "name": "24x24", "code": "24x24" }, { "name": "24x30", "code": "24x30" }, { "name": "24x36", "code": "24x36" }, { "name": "24x48", "code": "24x48" }, { "name": "24x8", "code": "24x8" }, { "name": "24x9", "code": "24x9" }, { "name": "30x12", "code": "30x12" }, { "name": "30x15", "code": "30x15" }, { "name": "30x24", "code": "30x24" }, { "name": "30x30", "code": "30x30" }, { "name": "30x36", "code": "30x36" }, { "name": "30x42", "code": "30x42" }, { "name": "30x60", "code": "30x60" }, { "name": "30x8", "code": "30x8" }, { "name": "36x12", "code": "36x12" }, { "name": "36x15", "code": "36x15" }, { "name": "36x18", "code": "36x18" }, { "name": "36x24", "code": "36x24" }, { "name": "36x30", "code": "36x30" }, { "name": "36x36", "code": "36x36" }, { "name": "36x48", "code": "36x48" }, { "name": "36x54", "code": "36x54" }, { "name": "36x60", "code": "36x60" }, { "name": "36x72", "code": "36x72" }, { "name": "42x24", "code": "42x24" }, { "name": "48x16", "code": "48x16" }, { "name": "48x18", "code": "48x18" }, { "name": "48x20", "code": "48x20" }, { "name": "48x24", "code": "48x24" }, { "name": "48x30", "code": "48x30" }, { "name": "48x36", "code": "48x36" }, { "name": "48x48", "code": "48x48" }, { "name": "48x60", "code": "48x60" }, { "name": "48x72", "code": "48x72" }, { "name": "48x84", "code": "48x84" }, { "name": "48x96", "code": "48x96" }, { "name": "54x18", "code": "54x18" }, { "name": "60x36", "code": "60x36" }, { "name": "84x48", "code": "84x48" }, { "name": "96x48", "code": "96x48" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DATE_INSTALLED", "type": "esriFieldTypeDate", "alias": "DATE_INSTALLED", "length": 8, "domain": null }, { "name": "DIRECTION", "type": "esriFieldTypeString", "alias": "DIRECTION", "length": 5, "domain": { "type": "codedValue", "name": "StreetDir", "description": "", "codedValues": [ { "name": "EAST", "code": "E" }, { "name": "NORTH", "code": "N" }, { "name": "NORTHEAST", "code": "NE" }, { "name": "NORTHWEST", "code": "NW" }, { "name": "SOUTH", "code": "S" }, { "name": "SOUTHEAST", "code": "SE" }, { "name": "SOUTHWEST", "code": "SW" }, { "name": "WEST", "code": "W" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SHEETING", "type": "esriFieldTypeString", "alias": "SHEETING", "length": 50, "domain": { "type": "codedValue", "name": "SheetingType", "description": "", "codedValues": [ { "name": "0", "code": "0" }, { "name": "HIGH INTENSITY PRISMATIC", "code": "HIP" }, { "name": "DIAMOND GRADE", "code": "DIAMOND" }, { "name": "ENGINEER GRADE", "code": "ENG" }, { "name": "EC FILM", "code": "EC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REPLACED", "type": "esriFieldTypeInteger", "alias": "REPLACED", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "0", "code": 0 }, { "name": "YES", "code": 1 }, { "name": "NO", "code": 2 }, { "name": "NA", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 250, "domain": null }, { "name": "LF_SIGN_EID", "type": "esriFieldTypeString", "alias": "LF SIGN ENTRY ID", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "LINKED_IMAGES", "type": "esriFieldTypeString", "alias": "LINKED_IMAGES", "length": 100, "domain": null }, { "name": "SIGN_NAME", "type": "esriFieldTypeString", "alias": "SIGN NAME", "length": 75, "domain": null }, { "name": "GUID", "type": "esriFieldTypeGUID", "alias": "GUID", "length": 38, "domain": null } ], "indexes": [ { "name": "R1887_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1887", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G5993POLE_BARCOD", "fields": "POLE_BARCODE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G5993LF_SIGN_EID", "fields": "LF_SIGN_EID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G5993GUID", "fields": "GUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_1887", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "name": "Traffic_Pole", "relatedTableId": 40, "role": "esriRelRoleDestination", "keyField": "GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "serviceItemId": "345dfc055c934c3999f7599728892ba1" }