{ "currentVersion": 10.91, "id": 6, "name": "AddressOne.BURKE.STREET_DICT", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "STREET_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PREDIR", "type": "esriFieldTypeString", "alias": "PreDirection", "length": 10, "domain": { "type": "codedValue", "name": "WS2_DirectionCode", "description": "Street Directional", "codedValues": [ { "name": "N", "code": "N" }, { "name": "S", "code": "S" }, { "name": "E", "code": "E" }, { "name": "W", "code": "W" }, { "name": "NW", "code": "NW" }, { "name": "SW", "code": "SW" }, { "name": "NE", "code": "NE" }, { "name": "SE", "code": "SE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STREET_NAME", "type": "esriFieldTypeString", "alias": "Street Name", "length": 50, "domain": null }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "Street Type", "length": 10, "domain": { "type": "codedValue", "name": "WS2_StreetTypeCode", "description": "Street Type Codes", "codedValues": [ { "name": "ALLEY", "code": "ALY" }, { "name": "BOULEVARD", "code": "BLVD" }, { "name": "CIRCLE", "code": "CIR" }, { "name": "CREST", "code": "CRST" }, { "name": "COURT", "code": "CT" }, { "name": "COVE", "code": "CV" }, { "name": "DRIVE", "code": "DR" }, { "name": "ESTATE", "code": "EST" }, { "name": "EXTENSION", "code": "EXT" }, { "name": "FIELD", "code": "FLD" }, { "name": "FIELDS", "code": "FLDS" }, { "name": "FOREST", "code": "FRST" }, { "name": "HILL", "code": "HL" }, { "name": "HOLLOW", "code": "HOLW" }, { "name": "HEIGHTS", "code": "HTS" }, { "name": "HAVEN", "code": "HVN" }, { "name": "JOG", "code": "JOG" }, { "name": "KNOLL", "code": "KNL" }, { "name": "KNOLLS", "code": "KNLS" }, { "name": "LODGE", "code": "LDG" }, { "name": "LANE", "code": "LN" }, { "name": "LANDING", "code": "LNDG" }, { "name": "LOOP", "code": "LOOP" }, { "name": "MEADOWS", "code": "MDWS" }, { "name": "PASS", "code": "PASS" }, { "name": "PATH", "code": "PATH" }, { "name": "PARKWAY", "code": "PKWY" }, { "name": "PLACE", "code": "PL" }, { "name": "POINT", "code": "PT" }, { "name": "ROAD", "code": "RD" }, { "name": "RIDGE", "code": "RDG" }, { "name": "RUN", "code": "RUN" }, { "name": "SHOALS", "code": "SHLS" }, { "name": "SPRING", "code": "SPG" }, { "name": "SPRINGS", "code": "SPGS" }, { "name": "SPUR", "code": "SPUR" }, { "name": "STREET", "code": "ST" }, { "name": "TERRACE", "code": "TER" }, { "name": "TRACE", "code": "TRCE" }, { "name": "TRAIL", "code": "TRL" }, { "name": "VISTA", "code": "VIS" }, { "name": "VALLEY", "code": "VLY" }, { "name": "VIEW", "code": "VW" }, { "name": "WAY", "code": "WAY" }, { "name": "CROSSING", "code": "XING" }, { "name": "BEND", "code": "BND" }, { "name": "FORK", "code": "FRK" }, { "name": "AVENUE", "code": "AVE" }, { "name": "MOUNTAIN", "code": "MTN" }, { "name": "SUMMIT", "code": "SMT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "POSTDIR", "type": "esriFieldTypeString", "alias": "PostDirection", "length": 10, "domain": { "type": "codedValue", "name": "WS2_DirectionCode", "description": "Street Directional", "codedValues": [ { "name": "N", "code": "N" }, { "name": "S", "code": "S" }, { "name": "E", "code": "E" }, { "name": "W", "code": "W" }, { "name": "NW", "code": "NW" }, { "name": "SW", "code": "SW" }, { "name": "NE", "code": "NE" }, { "name": "SE", "code": "SE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CITY", "type": "esriFieldTypeString", "alias": "City", "length": 50, "domain": { "type": "codedValue", "name": "WS2_POCityCode", "description": "Postal City Codes", "codedValues": [ { "name": "Bostic", "code": "Bostic" }, { "name": "Casar", "code": "Casar" }, { "name": "Collettsville", "code": "Collettsville" }, { "name": "Connelly Springs", "code": "Connelly Springs" }, { "name": "Granite Falls", "code": "Granite Falls" }, { "name": "Hickory", "code": "Hickory" }, { "name": "Hildebran", "code": "Hildebran" }, { "name": "Hudson", "code": "Hudson" }, { "name": "Lawndale", "code": "Lawndale" }, { "name": "Lenoir", "code": "Lenoir" }, { "name": "Marion", "code": "Marion" }, { "name": "Morganton", "code": "Morganton" }, { "name": "Nebo", "code": "Nebo" }, { "name": "Newland", "code": "Newland" }, { "name": "Valdese", "code": "Valdese" }, { "name": "Vale", "code": "Vale" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COUNTY", "type": "esriFieldTypeString", "alias": "County", "length": 50, "domain": { "type": "codedValue", "name": "WS2_CountyCode", "description": "County Codes", "codedValues": [ { "name": "Burke", "code": "BURKE" }, { "name": "Avery", "code": "AVERY" }, { "name": "Caldwell", "code": "CALDWELL" }, { "name": "Catawba", "code": "CATAWBA" }, { "name": "Lincoln", "code": "LINCOLN" }, { "name": "Cleveland", "code": "CLEVELAND" }, { "name": "Rutherford", "code": "RUTHERFORD" }, { "name": "McDowell", "code": "MCDOWELL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STATE", "type": "esriFieldTypeString", "alias": "State", "length": 2, "domain": { "type": "codedValue", "name": "WS2_StateCode", "description": "State Codes", "codedValues": [ { "name": "North Carolina", "code": "NC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMMENT", "type": "esriFieldTypeString", "alias": "Comment", "length": 2000, "domain": null }, { "name": "STREET_ID", "type": "esriFieldTypeInteger", "alias": "Street ID", "domain": null }, { "name": "EFFECTIVE_STATUS", "type": "esriFieldTypeString", "alias": "Status", "length": 10, "domain": { "type": "codedValue", "name": "WS2_StreetStatusCode", "description": "Street Status Codes", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "PRELIM", "code": "PRELIM" }, { "name": "RETIRE", "code": "RETIRE" }, { "name": "REVIEW", "code": "REVIEW" }, { "name": "PLACEHOLDER", "code": "PH" }, { "name": "RESERVED", "code": "RESERVED" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ALIAS_ONLY", "type": "esriFieldTypeString", "alias": "Is Alias", "length": 1, "domain": null }, { "name": "FEATURE_KEY", "type": "esriFieldTypeInteger", "alias": "FEATURE_KEY", "domain": null }, { "name": "EDIT_DATE", "type": "esriFieldTypeDate", "alias": "Edit Date", "length": 8, "domain": null }, { "name": "EDIT_USER", "type": "esriFieldTypeString", "alias": "Edit User", "length": 50, "domain": null }, { "name": "DUP_STREET_ID", "type": "esriFieldTypeInteger", "alias": "DUP_STREET_ID", "domain": null }, { "name": "PRE_MODIFIER", "type": "esriFieldTypeString", "alias": "Pre Modifier", "length": 20, "domain": { "type": "codedValue", "name": "WS2_PreModifier", "description": "Premodifier", "codedValues": [ { "name": "Old", "code": "OLD" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PRE_TYPE", "type": "esriFieldTypeString", "alias": "Pre Type", "length": 20, "domain": { "type": "codedValue", "name": "WS2_PreType", "description": "PreType", "codedValues": [ { "name": "Old", "code": "OLD" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "POST_MODIFIER", "type": "esriFieldTypeString", "alias": "Post Modifier", "length": 20, "domain": { "type": "codedValue", "name": "WS2_PreModifier", "description": "Premodifier", "codedValues": [ { "name": "Old", "code": "OLD" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "METAPHONE", "type": "esriFieldTypeString", "alias": "METAPHONE", "length": 20, "domain": null }, { "name": "ENFORCE_VALIDATION", "type": "esriFieldTypeString", "alias": "Enforce Validation", "length": 1, "domain": null } ], "indexes": [ { "name": "R29_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I60PREDIR4", "fields": "PREDIR,STREET_NAME,TYPE,POSTDIR,CITY,COUNTY,STATE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I60STREET_ID", "fields": "STREET_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I60FEATURE_KEY", "fields": "FEATURE_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I60EDIT_DATE", "fields": "EDIT_DATE", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "AddressOne.BURKE.Centerlines", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "STREET_ID", "cardinality": "esriRelCardinalityManyToMany", "composite": false, "relationshipTableId": 8, "keyFieldInRelationshipTable": "STREET_ID" } ], "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 }