{ "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 12, "name": "Road Sign Detail", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 1, "name": "PW.WASHOE.Road_Sign_Condition", "relatedTableId": 13, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{707C96EC-8723-426C-92EC-76964F4144D4}" }, { "id": 0, "name": "PW.WASHOE.Road_Sign_Location", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "asset_guid", "composite": false, "catalogID": "{EBC46335-DA7B-4EF3-9E55-8CA3167E877A}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "NAME" }, { "name": "AGENCY", "type": "esriFieldTypeString", "alias": "AGENCY", "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" }, "editable": true, "nullable": true, "length": 22, "defaultValue": "WASHOE COUNTY", "modelName": "AGENCY" }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "TYPE", "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" }, "editable": true, "nullable": true, "length": 22, "defaultValue": null, "modelName": "TYPE" }, { "name": "GUIDE_SYMBOL", "type": "esriFieldTypeString", "alias": "GUIDE_SYMBOL", "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" }, "editable": true, "nullable": true, "length": 22, "defaultValue": "N/A", "modelName": "GUIDE_SYMBOL" }, { "name": "WARNING_SYMBOL", "type": "esriFieldTypeString", "alias": "WARNING_SYMBOL", "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" }, "editable": true, "nullable": true, "length": 22, "defaultValue": "N/A", "modelName": "WARNING_SYMBOL" }, { "name": "REGULATORY_SYMBOL", "type": "esriFieldTypeString", "alias": "REGULATORY_SYMBOL", "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" }, "editable": true, "nullable": true, "length": 22, "defaultValue": "N/A", "modelName": "REGULATORY_SYMBOL" }, { "name": "MARKER", "type": "esriFieldTypeString", "alias": "MARKER", "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" }, "editable": true, "nullable": true, "length": 22, "defaultValue": "N/A", "modelName": "MARKER" }, { "name": "SIGN_TEXT", "type": "esriFieldTypeString", "alias": "SIGN_TEXT", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SIGN_TEXT" }, { "name": "SIGN_TEXT_DETAILS", "type": "esriFieldTypeString", "alias": "SIGN_TEXT_DETAILS", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "SIGN_TEXT_DETAILS" }, { "name": "NOTE", "type": "esriFieldTypeString", "alias": "NOTE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NOTE" }, { "name": "SOURCE", "type": "esriFieldTypeString", "alias": "SOURCE", "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" }, "editable": true, "nullable": true, "length": 22, "defaultValue": "FIELD", "modelName": "SOURCE" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "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" }, "editable": true, "nullable": true, "length": 22, "defaultValue": "FOUND", "modelName": "STATUS" }, { "name": "asset_guid", "type": "esriFieldTypeGUID", "alias": "asset_guid", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "asset_guid" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "SIGN_LENGTH", "type": "esriFieldTypeInteger", "alias": "SIGN_LENGTH", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SIGN_LENGTH" }, { "name": "SIGN_WIDTH", "type": "esriFieldTypeInteger", "alias": "SIGN_WIDTH", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SIGN_WIDTH" }, { "name": "inspect_freq_yrs", "type": "esriFieldTypeSmallInteger", "alias": "inspect_freq_yrs", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "inspect_freq_yrs" }, { "name": "criticality", "type": "esriFieldTypeSmallInteger", "alias": "criticality", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "criticality" }, { "name": "Orientation", "type": "esriFieldTypeDouble", "alias": "Orientation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Orientation" }, { "name": "Life_Status", "type": "esriFieldTypeString", "alias": "Life_Status", "domain": { "type": "codedValue", "name": "Life Status", "description": "Life Status", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Retired", "code": "Retired" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30, "defaultValue": "Active", "modelName": "Life_Status" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Road Sign Detail", "description": "", "prototype": { "attributes": { "Orientation": null, "Life_Status": "Active", "NAME": null, "AGENCY": "WASHOE COUNTY", "TYPE": null, "GUIDE_SYMBOL": "N/A", "WARNING_SYMBOL": "N/A", "REGULATORY_SYMBOL": "N/A", "MARKER": "N/A", "SIGN_TEXT": null, "SIGN_TEXT_DETAILS": null, "NOTE": null, "SOURCE": "FIELD", "STATUS": "FOUND", "asset_guid": null, "criticality": null, "inspect_freq_yrs": null, "SIGN_WIDTH": null, "SIGN_LENGTH": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,Extract", "bigIntegerRestrictedTo53Bits": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }