{ "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 12, "name": "Road Sign Detail", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Name", "length": 10, "domain": null }, { "name": "AGENCY", "type": "esriFieldTypeString", "alias": "AGENCY", "length": 22, "domain": { "type": "codedValue", "name": "AGENCY", "description": "", "codedValues": [ { "name": "WASHOE COUNTY", "code": "WASHOE COUNTY" }, { "name": "RENO", "code": "RENO" }, { "name": "SPARKS", "code": "SPARKS" }, { "name": "FERNLEY", "code": "FERLEY" }, { "name": "LYON COUNTY", "code": "LYON COUNTY" }, { "name": "NDOT", "code": "NDOT" }, { "name": "PRIVATE", "code": "PRIVATE" }, { "name": "UNKNOWN", "code": "UNKNOWN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "TYPE", "length": 22, "domain": { "type": "codedValue", "name": "SIGN_TYPE", "description": "", "codedValues": [ { "name": "GUIDE", "code": "GUIDE" }, { "name": "HIGHWAY", "code": "HIGHWAY" }, { "name": "MARKER", "code": "MARKER" }, { "name": "REGULATORY", "code": "REGULATORY" }, { "name": "SPEED", "code": "SPEED" }, { "name": "STOP", "code": "STOP" }, { "name": "STREET", "code": "STREET" }, { "name": "STREET & STOP", "code": "STREET & STOP" }, { "name": "WARNING", "code": "WARNING" }, { "name": "OTHER", "code": "OTHER" }, { "name": "N/A", "code": "N/A" }, { "name": "YIELD", "code": "YIELD" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GUIDE_SYMBOL", "type": "esriFieldTypeString", "alias": "GUIDE_SYMBOL", "length": 22, "domain": { "type": "codedValue", "name": "GUIDE_SYM", "description": "", "codedValues": [ { "name": "BIKE ROUTE", "code": "BIKE ROUTE" }, { "name": "BOAT RAMP", "code": "BOAT RAMP" }, { "name": "CAMPGROUND", "code": "CAMPGROUND" }, { "name": "FISHING", "code": "FISHING" }, { "name": "HANDICAPPED", "code": "HANDICAPPED" }, { "name": "HIKING", "code": "HIKING" }, { "name": "PARK & RIDE", "code": "PARK & RIDE" }, { "name": "PARKING", "code": "PARKING" }, { "name": "PICNIC TABLE", "code": "PICNIC TABLE" }, { "name": "PLAYGROUND", "code": "PLAYGROUND" }, { "name": "SCENIC VIEW", "code": "SCENIC VIEW" }, { "name": "SKI AREA", "code": "SKI AREA" }, { "name": "SWIMMING", "code": "SWIMMING" }, { "name": "TRASH CAN", "code": "TRASH CAN" }, { "name": "OTHER", "code": "OTHER" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WARNING_SYMBOL", "type": "esriFieldTypeString", "alias": "WARNING_SYMBOL", "length": 22, "domain": { "type": "codedValue", "name": "WARN_SYM", "description": "", "codedValues": [ { "name": "PLAYGROUND", "code": "PLAYGROUND" }, { "name": "OTHER", "code": "OTHER" }, { "name": "HANDICAPPED", "code": "HANDICAPPED" }, { "name": "N/A", "code": "N/A" }, { "name": "45 REVERSE TURN", "code": "45 REVERSE TURN" }, { "name": "45 TURN", "code": "45 TURN" }, { "name": "90 REVERSE TURN", "code": "90 REVERSE TURN" }, { "name": "90 TURN", "code": "90 TURN" }, { "name": "BICYCLE CROSSING", "code": "BICYCLE CROSSING" }, { "name": "DEER CROSSING", "code": "DEER CROSSING" }, { "name": "DIVIDED HIGHWAY", "code": "DIVIDED HIGHWAY" }, { "name": "DOUBLE ARROW", "code": "DOUBLE ARROW" }, { "name": "EQUESTRIAN", "code": "EQUESTRIAN" }, { "name": "FIRE STATION", "code": "FIRE STATION" }, { "name": "HILL", "code": "HILL" }, { "name": "MERGING LANE", "code": "MERGING LANE" }, { "name": "OPEN RANGE", "code": "OPEN RANGE" }, { "name": "PED XING", "code": "PED XING" }, { "name": "ROUND-A-BOUT", "code": "ROUND-A-BOUT" }, { "name": "SCHOOL PED XING", "code": "SCHOOL PED XING" }, { "name": "SIDE ROAD", "code": "SIDE ROAD" }, { "name": "SINGLE ARROW", "code": "SINGLE ARROW" }, { "name": "SPEED ZONE", "code": "SPEED ZONE" }, { "name": "STEEP GRADE", "code": "STEEP GRADE" }, { "name": "STOP AHEAD", "code": "STOP AHEAD" }, { "name": "T INTERSECTION", "code": "T INTERSECTION" }, { "name": "WINDING", "code": "WINDING" }, { "name": "X INTERSECTION", "code": "X INTERSECTION" }, { "name": "Y INTERSECTION", "code": "Y INTERSECTION" }, { "name": "YIELD AHEAD", "code": "YIELD AHEAD" }, { "name": "KEEP LEFT", "code": "KEEP LEFT" }, { "name": "KEEP RIGHT", "code": "KEEP RIGHT" }, { "name": "INTERSECTION AHEAD", "code": "INTERSECTION AHEAD" }, { "name": "LEFT TURN", "code": "LEFT TURN" }, { "name": "LEFT TURN 35 MPH", "code": "LEFT TURN 35 MPH" }, { "name": "LEFT TURN 45 MPH", "code": "LEFT TURN 45 MPH" }, { "name": "SLIPPERY WHEN WET", "code": "SLIPPERY WHEN WET" }, { "name": "RIGHT TURN", "code": "RIGHT TURN" }, { "name": "RIGHT TURN 35 MPH", "code": "RIGHT TURN 35 MPH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REGULATORY_SYMBOL", "type": "esriFieldTypeString", "alias": "REGULATORY_SYMBOL", "length": 22, "domain": { "type": "codedValue", "name": "REG_SYM", "description": "", "codedValues": [ { "name": "SCHOOL SPEED 1", "code": "SCHOOL SPEED 1" }, { "name": "SCHOOL SPEED 2", "code": "SCHOOL SPEED 2" }, { "name": "SCHOOL SPEED 3", "code": "SCHOOL SPEED 3" }, { "name": "BIKE LAND ENDS", "code": "BIKE LAND ENDS" }, { "name": "BIKE LANE", "code": "BIKE LANE" }, { "name": "BIKE LANE AHEAD", "code": "BIKE LANE AHEAD" }, { "name": "KEEP RIGHT", "code": "KEEP RIGHT" }, { "name": "NO BICYCLES", "code": "NO BICYCLES" }, { "name": "NO LEFT TURN", "code": "NO LEFT TURN" }, { "name": "NO PARKING", "code": "NO PARKING" }, { "name": "NO PARKING/BIKE LANE", "code": "NO PARKING/BIKE LANE" }, { "name": "NO PARKING/BUS", "code": "NO PARKING/BUS" }, { "name": "NO RIGHT TURN", "code": "NO RIGHT TURN" }, { "name": "NO TRUCKS", "code": "NO TRUCKS" }, { "name": "NO U TURN", "code": "NO U TURN" }, { "name": "OTHER", "code": "OTHER" }, { "name": "WEIGHT LIMIT", "code": "WEIGHT LIMIT" }, { "name": "STOP FOR PED", "code": "STOP FOR PED" }, { "name": "YIELD HERE TO PED", "code": "YIELD HERE TO PED" }, { "name": "NO PED", "code": "NO PED" }, { "name": "YIELD TO PED", "code": "YIELD TO PED" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MARKER", "type": "esriFieldTypeString", "alias": "MARKER", "length": 22, "domain": { "type": "codedValue", "name": "MARKER", "description": "", "codedValues": [ { "name": "DELINEATOR", "code": "DELINEATOR" }, { "name": "END OF ROAD", "code": "END OF ROAD" }, { "name": "TYPE 3", "code": "TYPE 3" }, { "name": "CHEVRON", "code": "CHEVRON" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SIGN_TEXT", "type": "esriFieldTypeString", "alias": "SIGN_TEXT", "length": 50, "domain": null }, { "name": "SIGN_TEXT_DETAILS", "type": "esriFieldTypeString", "alias": "SIGN_TEXT_DETAILS", "length": 150, "domain": null }, { "name": "NOTE", "type": "esriFieldTypeString", "alias": "NOTE", "length": 255, "domain": null }, { "name": "SOURCE", "type": "esriFieldTypeString", "alias": "SOURCE", "length": 22, "domain": { "type": "codedValue", "name": "SOURCE", "description": "", "codedValues": [ { "name": "GPS", "code": "GPS" }, { "name": "HANDHELD GPS", "code": "HANDHELD GPS" }, { "name": "MAPPING GPS", "code": "MAPPING GPS" }, { "name": "TERRESTRIAL", "code": "TERRESTRIAL" }, { "name": "CAD", "code": "CAD" }, { "name": "CALCULATED OFFSET", "code": "CALCULATED OFFSET" }, { "name": "ROADS DIV UPDATE", "code": "ROADS DIV UPDATE" }, { "name": "SKETCH", "code": "SKETCH" }, { "name": "ECF", "code": "ECF" }, { "name": "AS BUILT", "code": "AS BUILT" }, { "name": "IMAGERY", "code": "IMAGERY" }, { "name": "FIELD", "code": "FIELD" }, { "name": "REDLINE", "code": "REDLINE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 22, "domain": { "type": "codedValue", "name": "STATUS", "description": "", "codedValues": [ { "name": "FOUND", "code": "FOUND" }, { "name": "RETIRED", "code": "RETIRED" }, { "name": "NOT FOUND", "code": "NOT FOUND" }, { "name": "PLAN", "code": "PLAN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "asset_guid", "type": "esriFieldTypeGUID", "alias": "asset_guid", "length": 38, "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": "SIGN_LENGTH", "type": "esriFieldTypeInteger", "alias": "SIGN_LENGTH", "domain": null }, { "name": "SIGN_WIDTH", "type": "esriFieldTypeInteger", "alias": "SIGN_WIDTH", "domain": null }, { "name": "inspect_freq_yrs", "type": "esriFieldTypeSmallInteger", "alias": "inspect_freq_yrs", "domain": null }, { "name": "criticality", "type": "esriFieldTypeSmallInteger", "alias": "criticality", "domain": null }, { "name": "Orientation", "type": "esriFieldTypeDouble", "alias": "Orientation", "domain": null }, { "name": "Life_Status", "type": "esriFieldTypeString", "alias": "Life_Status", "length": 30, "domain": { "type": "codedValue", "name": "Life Status", "description": "Life Status", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Retired", "code": "Retired" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R858_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_858", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_74852_asset_", "fields": "asset_guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_858", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "PW.WASHOE.Road_Sign_Condition", "relatedTableId": 13, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{707C96EC-8723-426C-92EC-76964F4144D4}" }, { "id": 0, "name": "PW.WASHOE.Road_Sign_Location", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "asset_guid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{EBC46335-DA7B-4EF3-9E55-8CA3167E877A}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "advancedQueryCapabilities": { "useStandardizedQueries": false, "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": true, "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 } }