{ "currentVersion": 10.51, "id": 6, "name": "STREET NAME TABLE", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FULL_NAME", "typeIdField": null, "subtypeFieldName": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PRE_DIR_TX", "type": "esriFieldTypeString", "alias": "Prefix Directional", "length": 16, "domain": { "type": "codedValue", "name": "StreetDirection", "codedValues": [ { "name": "NORTH", "code": "NORTH" }, { "name": "SOUTH", "code": "SOUTH" }, { "name": "EAST", "code": "EAST" }, { "name": "WEST", "code": "WEST" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PRE_TYPE_T", "type": "esriFieldTypeString", "alias": "Prefix Type", "length": 16, "domain": { "type": "codedValue", "name": "StreetType", "codedValues": [ { "name": "ALLEY", "code": "ALY" }, { "name": "AVENUE", "code": "AVE" }, { "name": "BOULEVARD", "code": "BLVD" }, { "name": "CIRCLE", "code": "CIR" }, { "name": "CIRCUIT", "code": "CIRCUIT" }, { "name": "CLOSE", "code": "CLOSE" }, { "name": "COMMON", "code": "COMMON" }, { "name": "CRAG", "code": "CRAG" }, { "name": "CROSSING", "code": "CROSSING" }, { "name": "COURT", "code": "CT" }, { "name": "CUTOFF", "code": "CUTOFF" }, { "name": "DRIVE", "code": "DR" }, { "name": "GARDENS", "code": "GDNS" }, { "name": "HEIGHTS", "code": "HTS" }, { "name": "KNOLL", "code": "KNOLL" }, { "name": "LANE", "code": "LN" }, { "name": "PATH", "code": "PATH" }, { "name": "PARKWAY", "code": "PKWY" }, { "name": "PLACE", "code": "PL" }, { "name": "ROAD", "code": "RD" }, { "name": "RIGHT OF WAY", "code": "ROW" }, { "name": "SITE", "code": "SITE" }, { "name": "SQUARE", "code": "SQ" }, { "name": "STREET", "code": "ST" }, { "name": "TERRACE", "code": "TER" }, { "name": "TRAIL", "code": "TRAIL" }, { "name": "UNDERPASS", "code": "UP" }, { "name": "WAY", "code": "WAY" }, { "name": "PASSWAY", "code": "PSWY" }, { "name": "EXTENSION", "code": "EXT" }, { "name": "INTERSTATE", "code": "INTERSTATE" }, { "name": "STATE ROUTE", "code": "ROUTE" }, { "name": "COVE", "code": "COVE" }, { "name": "PLAZA", "code": "PLZ" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "NAME_TX", "type": "esriFieldTypeString", "alias": "Street Name", "length": 50, "domain": null }, { "name": "SUF_TYPE_T", "type": "esriFieldTypeString", "alias": "Suffix Type", "length": 16, "domain": { "type": "codedValue", "name": "StreetType", "codedValues": [ { "name": "ALLEY", "code": "ALY" }, { "name": "AVENUE", "code": "AVE" }, { "name": "BOULEVARD", "code": "BLVD" }, { "name": "CIRCLE", "code": "CIR" }, { "name": "CIRCUIT", "code": "CIRCUIT" }, { "name": "CLOSE", "code": "CLOSE" }, { "name": "COMMON", "code": "COMMON" }, { "name": "CRAG", "code": "CRAG" }, { "name": "CROSSING", "code": "CROSSING" }, { "name": "COURT", "code": "CT" }, { "name": "CUTOFF", "code": "CUTOFF" }, { "name": "DRIVE", "code": "DR" }, { "name": "GARDENS", "code": "GDNS" }, { "name": "HEIGHTS", "code": "HTS" }, { "name": "KNOLL", "code": "KNOLL" }, { "name": "LANE", "code": "LN" }, { "name": "PATH", "code": "PATH" }, { "name": "PARKWAY", "code": "PKWY" }, { "name": "PLACE", "code": "PL" }, { "name": "ROAD", "code": "RD" }, { "name": "RIGHT OF WAY", "code": "ROW" }, { "name": "SITE", "code": "SITE" }, { "name": "SQUARE", "code": "SQ" }, { "name": "STREET", "code": "ST" }, { "name": "TERRACE", "code": "TER" }, { "name": "TRAIL", "code": "TRAIL" }, { "name": "UNDERPASS", "code": "UP" }, { "name": "WAY", "code": "WAY" }, { "name": "PASSWAY", "code": "PSWY" }, { "name": "EXTENSION", "code": "EXT" }, { "name": "INTERSTATE", "code": "INTERSTATE" }, { "name": "STATE ROUTE", "code": "ROUTE" }, { "name": "COVE", "code": "COVE" }, { "name": "PLAZA", "code": "PLZ" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SUF_DIR_TX", "type": "esriFieldTypeString", "alias": "Suffix Directional", "length": 16, "domain": { "type": "codedValue", "name": "StreetDirection", "codedValues": [ { "name": "NORTH", "code": "NORTH" }, { "name": "SOUTH", "code": "SOUTH" }, { "name": "EAST", "code": "EAST" }, { "name": "WEST", "code": "WEST" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SUFFIX_TX", "type": "esriFieldTypeString", "alias": "Suffix", "length": 16, "domain": { "type": "codedValue", "name": "StreetType", "codedValues": [ { "name": "ALLEY", "code": "ALY" }, { "name": "AVENUE", "code": "AVE" }, { "name": "BOULEVARD", "code": "BLVD" }, { "name": "CIRCLE", "code": "CIR" }, { "name": "CIRCUIT", "code": "CIRCUIT" }, { "name": "CLOSE", "code": "CLOSE" }, { "name": "COMMON", "code": "COMMON" }, { "name": "CRAG", "code": "CRAG" }, { "name": "CROSSING", "code": "CROSSING" }, { "name": "COURT", "code": "CT" }, { "name": "CUTOFF", "code": "CUTOFF" }, { "name": "DRIVE", "code": "DR" }, { "name": "GARDENS", "code": "GDNS" }, { "name": "HEIGHTS", "code": "HTS" }, { "name": "KNOLL", "code": "KNOLL" }, { "name": "LANE", "code": "LN" }, { "name": "PATH", "code": "PATH" }, { "name": "PARKWAY", "code": "PKWY" }, { "name": "PLACE", "code": "PL" }, { "name": "ROAD", "code": "RD" }, { "name": "RIGHT OF WAY", "code": "ROW" }, { "name": "SITE", "code": "SITE" }, { "name": "SQUARE", "code": "SQ" }, { "name": "STREET", "code": "ST" }, { "name": "TERRACE", "code": "TER" }, { "name": "TRAIL", "code": "TRAIL" }, { "name": "UNDERPASS", "code": "UP" }, { "name": "WAY", "code": "WAY" }, { "name": "PASSWAY", "code": "PSWY" }, { "name": "EXTENSION", "code": "EXT" }, { "name": "INTERSTATE", "code": "INTERSTATE" }, { "name": "STATE ROUTE", "code": "ROUTE" }, { "name": "COVE", "code": "COVE" }, { "name": "PLAZA", "code": "PLZ" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FULL_NAME", "type": "esriFieldTypeString", "alias": "Full Street Name", "length": 50, "domain": null }, { "name": "NEW_NM_ID", "type": "esriFieldTypeInteger", "alias": "Street Name ID", "domain": null } ], "indexes": [ { "name": "R186_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "NewNamId", "fields": "NEW_NM_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true } }