{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 113, "name": "SIGNS", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "UNITID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "UNITID", "type": "esriFieldTypeString", "alias": "Primary Key Id", "length": 20, "domain": null }, { "name": "COMPTYPE", "type": "esriFieldTypeSmallInteger", "alias": "Hansen Asset Type", "domain": null }, { "name": "COMPKEY", "type": "esriFieldTypeInteger", "alias": "Hansen Asset Key", "domain": null }, { "name": "INSTDATE", "type": "esriFieldTypeDate", "alias": "Installation Date", "length": 8, "domain": null }, { "name": "SUPPID", "type": "esriFieldTypeString", "alias": "Post ID (Child)", "length": 20, "domain": null }, { "name": "SOURCE", "type": "esriFieldTypeString", "alias": "Source", "length": 5, "domain": { "type": "codedValue", "name": "WS5_transSOURCE", "description": "Mapping Source", "codedValues": [ { "name": "Survey Control", "code": "SC" }, { "name": "Mapping Grade", "code": "MG" }, { "name": "On-Screen Digitized", "code": "OSD" }, { "name": "CAD Conversion", "code": "CAD" }, { "name": "GPS", "code": "GPS" }, { "name": "GPS but Cartographically Moved", "code": "GPSCM" }, { "name": "Other", "code": "OTH" }, { "name": "High Accuracy GPS", "code": "HAGPS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SignText", "type": "esriFieldTypeString", "alias": "Sign Text", "length": 255, "domain": null }, { "name": "UNITTYPE", "type": "esriFieldTypeString", "alias": "Sign Unit Type", "length": 50, "domain": null }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "Owner", "length": 10, "domain": { "type": "codedValue", "name": "WS5_transOWNER", "description": "Owner", "codedValues": [ { "name": "Private", "code": "PRVT" }, { "name": "Clean Water Services", "code": "CWS" }, { "name": "Washington County", "code": "WASCO" }, { "name": "ODOT", "code": "ODOT" }, { "name": "Railroad", "code": "RR" }, { "name": "City of Tigard", "code": "COT" }, { "name": "City of Beaverton", "code": "COB" }, { "name": "TRIMET", "code": "TRIMT" }, { "name": "Metro", "code": "METRO" }, { "name": "City of Portland", "code": "PDX" }, { "name": "Other", "code": "OTHER" }, { "name": "Multnomah County", "code": "MULT" }, { "name": "Clackamas County", "code": "CLACK" }, { "name": "City of Durham", "code": "DUR" }, { "name": "City of Tualatin", "code": "TUAL" }, { "name": "King City", "code": "KING" }, { "name": "City of Sherwood", "code": "SHER" }, { "name": "City of West Linn", "code": "WEST" }, { "name": "City of Wilsonville", "code": "WILS" }, { "name": "City of Lake Oswego", "code": "LAKE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "CreateUser", "type": "esriFieldTypeString", "alias": "CreateUser", "length": 255, "domain": null }, { "name": "CreateDate", "type": "esriFieldTypeDate", "alias": "CreateDate", "length": 8, "domain": null }, { "name": "LastEditUser", "type": "esriFieldTypeString", "alias": "LastEditUser", "length": 255, "domain": null }, { "name": "LastEditDate", "type": "esriFieldTypeDate", "alias": "LastEditDate", "length": 8, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FDO_GlobalID", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G412SUPPID", "fields": "SUPPID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "SignPosts", "relatedTableId": 68, "role": "esriRelRoleDestination", "keyField": "SUPPID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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 }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "7b459dc4ee0e464c9f80c74b8781ed33" }