{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "TA Alias Names", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ST_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "NAME_ID", "type": "esriFieldTypeInteger", "alias": "Name ID", "domain": null }, { "name": "PRE_MODIFIER", "type": "esriFieldTypeString", "alias": "Pfx Mod", "length": 15, "domain": { "type": "codedValue", "name": "Name_Pfx_Mod", "description": "Name prefix modifiers", "codedValues": [ { "name": "OLD", "code": "OLD" }, { "name": "NEW", "code": "NEW" }, { "name": "THE", "code": "THE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PRE_DIRECTION", "type": "esriFieldTypeString", "alias": "Pfx Dir", "length": 9, "domain": { "type": "codedValue", "name": "Name_Dir", "description": "Name directionals", "codedValues": [ { "name": "NORTH", "code": "NORTH" }, { "name": "SOUTH", "code": "SOUTH" }, { "name": "EAST", "code": "EAST" }, { "name": "WEST", "code": "WEST" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PRE_TYPE", "type": "esriFieldTypeString", "alias": "Pfx Type", "length": 50, "domain": { "type": "codedValue", "name": "Name_Pfx_Type", "description": "Name prefix types", "codedValues": [ { "name": "AVENUE", "code": "AVENUE" }, { "name": "HIGHWAY", "code": "HIGHWAY" }, { "name": "THEATER", "code": "THEATER" }, { "name": "PLAZA", "code": "PLAZA" }, { "name": "ISLE", "code": "ISLE" }, { "name": "ALLEY", "code": "ALLEY" }, { "name": "STATE ROAD", "code": "STATE ROAD" }, { "name": "UNITED STATES", "code": "UNITED STATES" }, { "name": "COUNTY ROAD", "code": "COUNTY ROAD" }, { "name": "INTERSTATE", "code": "INTERSTATE" }, { "name": "SOUTH CAROLINA", "code": "SOUTH CAROLINA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PRE_TYPE_SEP", "type": "esriFieldTypeString", "alias": "Pfx Type Sep", "length": 20, "domain": { "type": "codedValue", "name": "Name_Pfx_Type_Sep", "description": "Name prefix type separators", "codedValues": [ { "name": "OF THE", "code": "OF THE" }, { "name": "OF", "code": "OF" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ST_NAME", "type": "esriFieldTypeString", "alias": "Name", "length": 60, "domain": null }, { "name": "POST_TYPE", "type": "esriFieldTypeString", "alias": "Sfx Type", "length": 50, "domain": { "type": "codedValue", "name": "Name_Sfx_Type", "description": "Name suffix types", "codedValues": [ { "name": "RIDGE", "code": "RIDGE" }, { "name": "LANDING", "code": "LANDING" }, { "name": "CROSSING", "code": "CROSSING" }, { "name": "CREST", "code": "CREST" }, { "name": "ALLEY", "code": "ALLEY" }, { "name": "AVENUE", "code": "AVENUE" }, { "name": "BOULEVARD", "code": "BOULEVARD" }, { "name": "CIRCLE", "code": "CIRCLE" }, { "name": "COURT", "code": "COURT" }, { "name": "COVE", "code": "COVE" }, { "name": "DRIVE", "code": "DRIVE" }, { "name": "EXPRESSWAY", "code": "EXPRESSWAY" }, { "name": "HIGHWAY", "code": "HIGHWAY" }, { "name": "LANE", "code": "LANE" }, { "name": "LOOP", "code": "LOOP" }, { "name": "PLACE", "code": "PLACE" }, { "name": "POINT", "code": "POINT" }, { "name": "PARKWAY", "code": "PARKWAY" }, { "name": "PLAZA", "code": "PLAZA" }, { "name": "ROAD", "code": "ROAD" }, { "name": "RUN", "code": "RUN" }, { "name": "RAMP", "code": "RAMP" }, { "name": "ROW", "code": "ROW" }, { "name": "SQUARE", "code": "SQUARE" }, { "name": "STREET", "code": "STREET" }, { "name": "TRAIL", "code": "TRAIL" }, { "name": "TERRACE", "code": "TERRACE" }, { "name": "WAY", "code": "WAY" }, { "name": "BEACH", "code": "BEACH" }, { "name": "BEND", "code": "BEND" }, { "name": "BLUFF", "code": "BLUFF" }, { "name": "CLUB", "code": "CLUB" }, { "name": "HILL", "code": "HILL" }, { "name": "ISLE", "code": "ISLE" }, { "name": "KEY", "code": "KEY" }, { "name": "PASS", "code": "PASS" }, { "name": "PATH", "code": "PATH" }, { "name": "SHORE", "code": "SHORE" }, { "name": "TURNPIKE", "code": "TURNPIKE" }, { "name": "VALE", "code": "VALE" }, { "name": "PARK", "code": "PARK" }, { "name": "BRANCH", "code": "BRANCH" }, { "name": "CURVE", "code": "CURVE" }, { "name": "CUT", "code": "CUT" }, { "name": "CORNER", "code": "CORNER" }, { "name": "GAP", "code": "GAP" }, { "name": "GATE", "code": "GATE" }, { "name": "GROVE", "code": "GROVE" }, { "name": "HALL", "code": "HALL" }, { "name": "HEIGHTS", "code": "HEIGHTS" }, { "name": "KNOLL", "code": "KNOLL" }, { "name": "MANOR", "code": "MANOR" }, { "name": "SPUR", "code": "SPUR" }, { "name": "TRACE", "code": "TRACE" }, { "name": "VIEW", "code": "VIEW" }, { "name": "WALK", "code": "WALK" }, { "name": "RANGE", "code": "RANGE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "POST_DIRECTION", "type": "esriFieldTypeString", "alias": "Sfx Dir", "length": 9, "domain": { "type": "codedValue", "name": "Name_Dir", "description": "Name directionals", "codedValues": [ { "name": "NORTH", "code": "NORTH" }, { "name": "SOUTH", "code": "SOUTH" }, { "name": "EAST", "code": "EAST" }, { "name": "WEST", "code": "WEST" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "POST_MODIFIER", "type": "esriFieldTypeString", "alias": "Sfx Mod", "length": 25, "domain": { "type": "codedValue", "name": "Name_Sfx_Mod", "description": "Name suffix modifiers", "codedValues": [ { "name": "CUTOFF", "code": "CUTOFF" }, { "name": "BYPASS", "code": "BYPASS" }, { "name": "FRONTAGE", "code": "FRONTAGE" }, { "name": "SERVICE", "code": "SERVICE" }, { "name": "EXTENSION", "code": "EXTENSION" }, { "name": "ALTERNATE", "code": "ALTERNATE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PFX_DIR_LEG", "type": "esriFieldTypeString", "alias": "Pfx Dir (Leg)", "length": 2, "domain": { "type": "codedValue", "name": "Name_Dir_Leg", "description": "Name directionals (legacy)", "codedValues": [ { "name": "N", "code": "N" }, { "name": "S", "code": "S" }, { "name": "E", "code": "E" }, { "name": "W", "code": "W" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NAME_LEG", "type": "esriFieldTypeString", "alias": "Name (Leg)", "length": 100, "domain": null }, { "name": "SFX_TYPE_LEG", "type": "esriFieldTypeString", "alias": "Sfx Type (Leg)", "length": 6, "domain": { "type": "codedValue", "name": "Name_Sfx_Type_Leg", "description": "Name suffix types (legacy)", "codedValues": [ { "name": "RDG", "code": "RDG" }, { "name": "CRST", "code": "CRST" }, { "name": "ALY", "code": "ALY" }, { "name": "AVE", "code": "AVE" }, { "name": "BLVD", "code": "BLVD" }, { "name": "CIR", "code": "CIR" }, { "name": "CT", "code": "CT" }, { "name": "CV", "code": "CV" }, { "name": "DR", "code": "DR" }, { "name": "EXPY", "code": "EXPY" }, { "name": "HWY", "code": "HWY" }, { "name": "LN", "code": "LN" }, { "name": "LOOP", "code": "LOOP" }, { "name": "PL", "code": "PL" }, { "name": "PT", "code": "PT" }, { "name": "PKWY", "code": "PKWY" }, { "name": "PLZ", "code": "PLZ" }, { "name": "RD", "code": "RD" }, { "name": "RUN", "code": "RUN" }, { "name": "RAMP", "code": "RAMP" }, { "name": "ROW", "code": "ROW" }, { "name": "SQ", "code": "SQ" }, { "name": "ST", "code": "ST" }, { "name": "TRL", "code": "TRL" }, { "name": "TER", "code": "TER" }, { "name": "WAY", "code": "WAY" }, { "name": "BCH", "code": "BCH" }, { "name": "BND", "code": "BND" }, { "name": "BLF", "code": "BLF" }, { "name": "CLB", "code": "CLB" }, { "name": "HL", "code": "HL" }, { "name": "ISLE", "code": "ISLE" }, { "name": "KY", "code": "KY" }, { "name": "PASS", "code": "PASS" }, { "name": "PATH", "code": "PATH" }, { "name": "SHR", "code": "SHR" }, { "name": "TPKE", "code": "TPKE" }, { "name": "CRSG", "code": "CRSG" }, { "name": "XING", "code": "XING" }, { "name": "EXT", "code": "EXT" }, { "name": "LNDG", "code": "LNDG" }, { "name": "WALK", "code": "WALK" }, { "name": "VW", "code": "VW" }, { "name": "TRCE", "code": "TRCE" }, { "name": "SPUR", "code": "SPUR" }, { "name": "MNR", "code": "MNR" }, { "name": "KNL", "code": "KNL" }, { "name": "GAP", "code": "GAP" }, { "name": "HTS", "code": "HTS" }, { "name": "HALL", "code": "HALL" }, { "name": "GRV", "code": "GRV" }, { "name": "GATE", "code": "GATE" }, { "name": "CRES", "code": "CRES" }, { "name": "CURV", "code": "CURV" }, { "name": "COR", "code": "COR" }, { "name": "BR", "code": "BR" }, { "name": "RNGE", "code": "RNGE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SFX_DIR_LEG", "type": "esriFieldTypeString", "alias": "Sfx Dir (Leg)", "length": 2, "domain": { "type": "codedValue", "name": "Name_Dir_Leg", "description": "Name directionals (legacy)", "codedValues": [ { "name": "N", "code": "N" }, { "name": "S", "code": "S" }, { "name": "E", "code": "E" }, { "name": "W", "code": "W" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LABEL", "type": "esriFieldTypeString", "alias": "Label", "length": 200, "domain": null }, { "name": "CREATE_DATE", "type": "esriFieldTypeDate", "alias": "Create Date", "length": 8, "domain": null }, { "name": "CREATE_USER", "type": "esriFieldTypeString", "alias": "Create User", "length": 50, "domain": null }, { "name": "EDIT_DATE", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "EDIT_USER", "type": "esriFieldTypeString", "alias": "Last Edit User", "length": 50, "domain": null }, { "name": "SEGMENT_ID", "type": "esriFieldTypeInteger", "alias": "SEGMENT_ID", "domain": null }, { "name": "ALIAS_ID", "type": "esriFieldTypeInteger", "alias": "ALIAS_ID", "domain": null }, { "name": "NGUID", "type": "esriFieldTypeString", "alias": "NGUID", "length": 255, "domain": null }, { "name": "FULL_STREETNAME", "type": "esriFieldTypeString", "alias": "Full Name (Leg)", "length": 100, "domain": null } ], "indexes": [ { "name": "R94_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "ats_sid", "fields": "SEGMENT_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "sde.SDE.RoadCenterlines", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "SEGMENT_ID", "cardinality": "esriRelCardinalityOneToOne", "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, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "a833377aaa014cbebded8f46a22ef628" }