{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 32, "name": "ArcGIS.GDBO.NAMEALIAS", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "STREETNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PREFIXTYPE", "type": "esriFieldTypeString", "alias": "PREFIXTYPE", "length": 20, "domain": { "type": "codedValue", "name": "rStreetType", "description": "Street Suffix Type", "codedValues": [ { "name": "Avenue", "code": "AVE" }, { "name": "Alley", "code": "ALY" }, { "name": "Boulevard", "code": "BLVD" }, { "name": "Bypass", "code": "BYP" }, { "name": "Circle", "code": "CIR" }, { "name": "Court", "code": "CT" }, { "name": "Drive", "code": "DR" }, { "name": "Expressway", "code": "EXPY" }, { "name": "Extension", "code": "EXT" }, { "name": "Freeway", "code": "FWY" }, { "name": "Glen", "code": "GLN" }, { "name": "Highway", "code": "HWY" }, { "name": "Junction", "code": "JCT" }, { "name": "Lane", "code": "LN" }, { "name": "Loop", "code": "LOOP" }, { "name": "Place", "code": "PL" }, { "name": "Road", "code": "RD" }, { "name": "Row", "code": "ROW" }, { "name": "Street", "code": "ST" }, { "name": "Terrace", "code": "TER" }, { "name": "Turnpike", "code": "TPKE" }, { "name": "Trace", "code": "TRCE" }, { "name": "Unknown", "code": "UNK" }, { "name": "Way", "code": "WAY" }, { "name": "End", "code": "END" }, { "name": "Hills", "code": "HLS" }, { "name": "Hollow", "code": "HOLW" }, { "name": "Pass", "code": "PASS" }, { "name": "Plaza", "code": "PLZ" }, { "name": "Point", "code": "PT" }, { "name": "Ramp", "code": "RAMP" }, { "name": "Bluff", "code": "BLF" }, { "name": "Crescent", "code": "CRES" }, { "name": "Forest", "code": "FRST" }, { "name": "Knoll", "code": "KL" }, { "name": "Ridge", "code": "RDG" }, { "name": "Woods", "code": "WDS" }, { "name": "Trail", "code": "TRL" }, { "name": "Creek", "code": "CRK" }, { "name": "Grove", "code": "GRV" }, { "name": "Haven", "code": "HVN" }, { "name": "Meadow", "code": "MDW" }, { "name": "Pines", "code": "PNES" }, { "name": "Parkway", "code": "PKWY" }, { "name": "Cove", "code": "CV" }, { "name": "Center", "code": "CTR" }, { "name": "Promenade", "code": "PROM" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PREFIXDIRE", "type": "esriFieldTypeString", "alias": "PREFIXDIRE", "length": 4, "domain": { "type": "codedValue", "name": "rDirection", "description": "Suffix Direction", "codedValues": [ { "name": "North", "code": "N" }, { "name": "South", "code": "S" }, { "name": "East", "code": "E" }, { "name": "West", "code": "W" }, { "name": "Northeast", "code": "NE" }, { "name": "Northwest", "code": "NW" }, { "name": "Southeast", "code": "SE" }, { "name": "Southwest", "code": "SW" }, { "name": "East / West", "code": "East / West" }, { "name": "West / East", "code": "West / East" }, { "name": "North / South", "code": "North / South" }, { "name": "South / North", "code": "South / North" }, { "name": "Northwest / Southeast", "code": "Northwest / Southeast" }, { "name": "Southeast / Northwest", "code": "Southeast / Northwest" }, { "name": "Northeast / Southwest", "code": "Northeast / Southwest" }, { "name": "Southwest / Northeast", "code": "Southwest / Northeast" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SUFFIXTYPE", "type": "esriFieldTypeString", "alias": "SUFFIXTYPE", "length": 20, "domain": { "type": "codedValue", "name": "rStreetType", "description": "Street Suffix Type", "codedValues": [ { "name": "Avenue", "code": "AVE" }, { "name": "Alley", "code": "ALY" }, { "name": "Boulevard", "code": "BLVD" }, { "name": "Bypass", "code": "BYP" }, { "name": "Circle", "code": "CIR" }, { "name": "Court", "code": "CT" }, { "name": "Drive", "code": "DR" }, { "name": "Expressway", "code": "EXPY" }, { "name": "Extension", "code": "EXT" }, { "name": "Freeway", "code": "FWY" }, { "name": "Glen", "code": "GLN" }, { "name": "Highway", "code": "HWY" }, { "name": "Junction", "code": "JCT" }, { "name": "Lane", "code": "LN" }, { "name": "Loop", "code": "LOOP" }, { "name": "Place", "code": "PL" }, { "name": "Road", "code": "RD" }, { "name": "Row", "code": "ROW" }, { "name": "Street", "code": "ST" }, { "name": "Terrace", "code": "TER" }, { "name": "Turnpike", "code": "TPKE" }, { "name": "Trace", "code": "TRCE" }, { "name": "Unknown", "code": "UNK" }, { "name": "Way", "code": "WAY" }, { "name": "End", "code": "END" }, { "name": "Hills", "code": "HLS" }, { "name": "Hollow", "code": "HOLW" }, { "name": "Pass", "code": "PASS" }, { "name": "Plaza", "code": "PLZ" }, { "name": "Point", "code": "PT" }, { "name": "Ramp", "code": "RAMP" }, { "name": "Bluff", "code": "BLF" }, { "name": "Crescent", "code": "CRES" }, { "name": "Forest", "code": "FRST" }, { "name": "Knoll", "code": "KL" }, { "name": "Ridge", "code": "RDG" }, { "name": "Woods", "code": "WDS" }, { "name": "Trail", "code": "TRL" }, { "name": "Creek", "code": "CRK" }, { "name": "Grove", "code": "GRV" }, { "name": "Haven", "code": "HVN" }, { "name": "Meadow", "code": "MDW" }, { "name": "Pines", "code": "PNES" }, { "name": "Parkway", "code": "PKWY" }, { "name": "Cove", "code": "CV" }, { "name": "Center", "code": "CTR" }, { "name": "Promenade", "code": "PROM" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SUFFIXDIRE", "type": "esriFieldTypeString", "alias": "SUFFIXDIRE", "length": 4, "domain": { "type": "codedValue", "name": "rDirection", "description": "Suffix Direction", "codedValues": [ { "name": "North", "code": "N" }, { "name": "South", "code": "S" }, { "name": "East", "code": "E" }, { "name": "West", "code": "W" }, { "name": "Northeast", "code": "NE" }, { "name": "Northwest", "code": "NW" }, { "name": "Southeast", "code": "SE" }, { "name": "Southwest", "code": "SW" }, { "name": "East / West", "code": "East / West" }, { "name": "West / East", "code": "West / East" }, { "name": "North / South", "code": "North / South" }, { "name": "South / North", "code": "South / North" }, { "name": "Northwest / Southeast", "code": "Northwest / Southeast" }, { "name": "Southeast / Northwest", "code": "Southeast / Northwest" }, { "name": "Northeast / Southwest", "code": "Northeast / Southwest" }, { "name": "Southwest / Northeast", "code": "Southwest / Northeast" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STREETNAME", "type": "esriFieldTypeString", "alias": "STREETNAME", "length": 50, "domain": null }, { "name": "ALIAS", "type": "esriFieldTypeString", "alias": "ALIAS", "length": 74, "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "length": 20, "domain": null } ], "indexes": [ { "name": "R236_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G509FACILITYID", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "RRoad", "relatedTableId": 12, "role": "esriRelRoleDestination", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 3, "name": "RRoad", "relatedTableId": 13, "role": "esriRelRoleDestination", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 4, "name": "RRoad", "relatedTableId": 14, "role": "esriRelRoleDestination", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 5, "name": "RRoad", "relatedTableId": 15, "role": "esriRelRoleDestination", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 6, "name": "RRoad", "relatedTableId": 16, "role": "esriRelRoleDestination", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 7, "name": "RRoad", "relatedTableId": 20, "role": "esriRelRoleDestination", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "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": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }