{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 46, "name": "Alternate Street Names", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "primary_full_street_name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "primary_id", "type": "esriFieldTypeString", "alias": "Primary ID", "length": 6, "domain": null }, { "name": "primary_full_street_name", "type": "esriFieldTypeString", "alias": "Primary Full Street Name", "length": 178, "domain": null }, { "name": "type", "type": "esriFieldTypeString", "alias": "Type", "length": 9, "domain": null }, { "name": "st_pre_mod", "type": "esriFieldTypeString", "alias": "Pre Modifier", "length": 15, "domain": null }, { "name": "st_pre_dir", "type": "esriFieldTypeString", "alias": "Pre Directional", "length": 9, "domain": { "type": "codedValue", "name": "StreetDirectional", "description": "Street directional.", "codedValues": [ { "name": "North", "code": "North" }, { "name": "South", "code": "South" }, { "name": "East", "code": "East" }, { "name": "West", "code": "West" }, { "name": "Northeast", "code": "Northeast" }, { "name": "Southeast", "code": "Southeast" }, { "name": "Southwest", "code": "Southwest" }, { "name": "Northwest", "code": "Northwest" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "st_pre_typ", "type": "esriFieldTypeString", "alias": "Pre Type", "length": 35, "domain": { "type": "codedValue", "name": "StreetPreType", "description": "Street pre-type.", "codedValues": [ { "name": "United States Highway", "code": "United States Highway" }, { "name": "United States Forest Service Road", "code": "United States Forest Service Road" }, { "name": "Taxiway", "code": "Taxiway" }, { "name": "State Road", "code": "State Road" }, { "name": "State Highway", "code": "State Highway" }, { "name": "Loop", "code": "Loop" }, { "name": "Lane", "code": "Lane" }, { "name": "Interstate", "code": "Interstate" }, { "name": "Highway", "code": "Highway" }, { "name": "Forest Road", "code": "Forest Road" }, { "name": "Forest Highway", "code": "Forest Highway" }, { "name": "County State Aid Highway", "code": "County State Aid Highway" }, { "name": "County Road", "code": "County Road" }, { "name": "County Highway", "code": "County Highway" }, { "name": "Avenue", "code": "Avenue" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "st_pre_sep", "type": "esriFieldTypeString", "alias": "Pre Separator", "length": 20, "domain": { "type": "codedValue", "name": "StreetPreSeparator", "description": "Street pre-separator.", "codedValues": [ { "name": "at", "code": "at" }, { "name": "de las", "code": "de las" }, { "name": "des", "code": "des" }, { "name": "in the", "code": "in the" }, { "name": "of", "code": "of" }, { "name": "of the", "code": "of the" }, { "name": "on the", "code": "on the" }, { "name": "to", "code": "to" }, { "name": "to the", "code": "to the" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "st_name", "type": "esriFieldTypeString", "alias": "Name", "length": 60, "domain": null }, { "name": "st_pos_typ", "type": "esriFieldTypeString", "alias": "Post Type", "length": 15, "domain": { "type": "codedValue", "name": "StreetPostType", "description": "Street post-type.", "codedValues": [ { "name": "Abbey", "code": "Abbey" }, { "name": "Alcove", "code": "Alcove" }, { "name": "Alley", "code": "Alley" }, { "name": "Annex", "code": "Annex" }, { "name": "Arcade", "code": "Arcade" }, { "name": "Avenue", "code": "Avenue" }, { "name": "Bay", "code": "Bay" }, { "name": "Bayou", "code": "Bayou" }, { "name": "Beach", "code": "Beach" }, { "name": "Bend", "code": "Bend" }, { "name": "Bluff", "code": "Bluff" }, { "name": "Bluffs", "code": "Bluffs" }, { "name": "Bottom", "code": "Bottom" }, { "name": "Boulevard", "code": "Boulevard" }, { "name": "Branch", "code": "Branch" }, { "name": "Bridge", "code": "Bridge" }, { "name": "Brook", "code": "Brook" }, { "name": "Brooks", "code": "Brooks" }, { "name": "Burg", "code": "Burg" }, { "name": "Burgs", "code": "Burgs" }, { "name": "Bypass", "code": "Bypass" }, { "name": "Camp", "code": "Camp" }, { "name": "Canyon", "code": "Canyon" }, { "name": "Cape", "code": "Cape" }, { "name": "Causeway", "code": "Causeway" }, { "name": "Center", "code": "Center" }, { "name": "Centers", "code": "Centers" }, { "name": "Chase", "code": "Chase" }, { "name": "Circle", "code": "Circle" }, { "name": "Circles", "code": "Circles" }, { "name": "Cliff", "code": "Cliff" }, { "name": "Cliffs", "code": "Cliffs" }, { "name": "Close", "code": "Close" }, { "name": "Club", "code": "Club" }, { "name": "Common", "code": "Common" }, { "name": "Commons", "code": "Commons" }, { "name": "Connection", "code": "Connection" }, { "name": "Connector", "code": "Connector" }, { "name": "Corner", "code": "Corner" }, { "name": "Corners", "code": "Corners" }, { "name": "Course", "code": "Course" }, { "name": "Court", "code": "Court" }, { "name": "Courte", "code": "Courte" }, { "name": "Courts", "code": "Courts" }, { "name": "Cove", "code": "Cove" }, { "name": "Creek", "code": "Creek" }, { "name": "Crescent", "code": "Crescent" }, { "name": "Crest", "code": "Crest" }, { "name": "Cross", "code": "Cross" }, { "name": "Crossing", "code": "Crossing" }, { "name": "Crossings", "code": "Crossings" }, { "name": "Crossroad", "code": "Crossroad" }, { "name": "Crossroads", "code": "Crossroads" }, { "name": "Curve", "code": "Curve" }, { "name": "Cutoff", "code": "Cutoff" }, { "name": "Dale", "code": "Dale" }, { "name": "Dam", "code": "Dam" }, { "name": "Divide", "code": "Divide" }, { "name": "Down", "code": "Down" }, { "name": "Downs", "code": "Downs" }, { "name": "Draw", "code": "Draw" }, { "name": "Drive", "code": "Drive" }, { "name": "Drives", "code": "Drives" }, { "name": "Echo", "code": "Echo" }, { "name": "Edge", "code": "Edge" }, { "name": "Entrance", "code": "Entrance" }, { "name": "Entry", "code": "Entry" }, { "name": "Estate", "code": "Estate" }, { "name": "Estates", "code": "Estates" }, { "name": "Expressway", "code": "Expressway" }, { "name": "Extension", "code": "Extension" }, { "name": "Extensions", "code": "Extensions" }, { "name": "Fall", "code": "Fall" }, { "name": "Falls", "code": "Falls" }, { "name": "Ferry", "code": "Ferry" }, { "name": "Field", "code": "Field" }, { "name": "Fields", "code": "Fields" }, { "name": "Flat", "code": "Flat" }, { "name": "Flats", "code": "Flats" }, { "name": "Ford", "code": "Ford" }, { "name": "Fords", "code": "Fords" }, { "name": "Forest", "code": "Forest" }, { "name": "Forest Road", "code": "Forest Road" }, { "name": "Forge", "code": "Forge" }, { "name": "Forges", "code": "Forges" }, { "name": "Fork", "code": "Fork" }, { "name": "Forks", "code": "Forks" }, { "name": "Fort", "code": "Fort" }, { "name": "Freeway", "code": "Freeway" }, { "name": "Frontage Road", "code": "Frontage Road" }, { "name": "Gables", "code": "Gables" }, { "name": "Garden", "code": "Garden" }, { "name": "Gardens", "code": "Gardens" }, { "name": "Gate", "code": "Gate" }, { "name": "Gateway", "code": "Gateway" }, { "name": "Glade", "code": "Glade" }, { "name": "Glen", "code": "Glen" }, { "name": "Grade", "code": "Grade" }, { "name": "Green", "code": "Green" }, { "name": "Greenway", "code": "Greenway" }, { "name": "Grove", "code": "Grove" }, { "name": "Groves", "code": "Groves" }, { "name": "Harbor", "code": "Harbor" }, { "name": "Harbors", "code": "Harbors" }, { "name": "Haul Road", "code": "Haul Road" }, { "name": "Haven", "code": "Haven" }, { "name": "Heights", "code": "Heights" }, { "name": "Highway", "code": "Highway" }, { "name": "Hill", "code": "Hill" }, { "name": "Hills", "code": "Hills" }, { "name": "Hollow", "code": "Hollow" }, { "name": "Horn", "code": "Horn" }, { "name": "Inlet", "code": "Inlet" }, { "name": "Island", "code": "Island" }, { "name": "Islands", "code": "Islands" }, { "name": "Isle", "code": "Isle" }, { "name": "Junction", "code": "Junction" }, { "name": "Junctions", "code": "Junctions" }, { "name": "Key", "code": "Key" }, { "name": "Keys", "code": "Keys" }, { "name": "Knoll", "code": "Knoll" }, { "name": "Knolls", "code": "Knolls" }, { "name": "Lake", "code": "Lake" }, { "name": "Lakes", "code": "Lakes" }, { "name": "Land", "code": "Land" }, { "name": "Landing", "code": "Landing" }, { "name": "Lane", "code": "Lane" }, { "name": "Light", "code": "Light" }, { "name": "Lights", "code": "Lights" }, { "name": "Line", "code": "Line" }, { "name": "Loaf", "code": "Loaf" }, { "name": "Lock", "code": "Lock" }, { "name": "Locks", "code": "Locks" }, { "name": "Lodge", "code": "Lodge" }, { "name": "Lookout", "code": "Lookout" }, { "name": "Loop", "code": "Loop" }, { "name": "Mall", "code": "Mall" }, { "name": "Manor", "code": "Manor" }, { "name": "Manors", "code": "Manors" }, { "name": "Meadow", "code": "Meadow" }, { "name": "Meadows", "code": "Meadows" }, { "name": "Mews", "code": "Mews" }, { "name": "Mill", "code": "Mill" }, { "name": "Mills", "code": "Mills" }, { "name": "Mission", "code": "Mission" }, { "name": "Motorway", "code": "Motorway" }, { "name": "Mount", "code": "Mount" }, { "name": "Mountain", "code": "Mountain" }, { "name": "Mountains", "code": "Mountains" }, { "name": "Neck", "code": "Neck" }, { "name": "Orchard", "code": "Orchard" }, { "name": "Oval", "code": "Oval" }, { "name": "Overlook", "code": "Overlook" }, { "name": "Overpass", "code": "Overpass" }, { "name": "Park", "code": "Park" }, { "name": "Parks", "code": "Parks" }, { "name": "Parkway", "code": "Parkway" }, { "name": "Parkways", "code": "Parkways" }, { "name": "Pass", "code": "Pass" }, { "name": "Passage", "code": "Passage" }, { "name": "Path", "code": "Path" }, { "name": "Pike", "code": "Pike" }, { "name": "Pine", "code": "Pine" }, { "name": "Pines", "code": "Pines" }, { "name": "Place", "code": "Place" }, { "name": "Plain", "code": "Plain" }, { "name": "Plains", "code": "Plains" }, { "name": "Plaza", "code": "Plaza" }, { "name": "Point", "code": "Point" }, { "name": "Pointe", "code": "Pointe" }, { "name": "Points", "code": "Points" }, { "name": "Port", "code": "Port" }, { "name": "Ports", "code": "Ports" }, { "name": "Prairie", "code": "Prairie" }, { "name": "Promenade", "code": "Promenade" }, { "name": "Radial", "code": "Radial" }, { "name": "Ramp", "code": "Ramp" }, { "name": "Ranch", "code": "Ranch" }, { "name": "Rapid", "code": "Rapid" }, { "name": "Rapids", "code": "Rapids" }, { "name": "Rest", "code": "Rest" }, { "name": "Ridge", "code": "Ridge" }, { "name": "Ridges", "code": "Ridges" }, { "name": "Rise", "code": "Rise" }, { "name": "River", "code": "River" }, { "name": "Road", "code": "Road" }, { "name": "Roads", "code": "Roads" }, { "name": "Route", "code": "Route" }, { "name": "Row", "code": "Row" }, { "name": "Rue", "code": "Rue" }, { "name": "Run", "code": "Run" }, { "name": "Shoal", "code": "Shoal" }, { "name": "Shoals", "code": "Shoals" }, { "name": "Shore", "code": "Shore" }, { "name": "Shores", "code": "Shores" }, { "name": "Skies", "code": "Skies" }, { "name": "Skyway", "code": "Skyway" }, { "name": "Spring", "code": "Spring" }, { "name": "Springs", "code": "Springs" }, { "name": "Spur", "code": "Spur" }, { "name": "Spurs", "code": "Spurs" }, { "name": "Square", "code": "Square" }, { "name": "Squares", "code": "Squares" }, { "name": "Station", "code": "Station" }, { "name": "Stravenue", "code": "Stravenue" }, { "name": "Stream", "code": "Stream" }, { "name": "Street", "code": "Street" }, { "name": "Streets", "code": "Streets" }, { "name": "Summit", "code": "Summit" }, { "name": "Terrace", "code": "Terrace" }, { "name": "Throughway", "code": "Throughway" }, { "name": "Trace", "code": "Trace" }, { "name": "Track", "code": "Track" }, { "name": "Trafficway", "code": "Trafficway" }, { "name": "Trail", "code": "Trail" }, { "name": "Trailer", "code": "Trailer" }, { "name": "Truck Trail", "code": "Truck Trail" }, { "name": "Tunnel", "code": "Tunnel" }, { "name": "Turn", "code": "Turn" }, { "name": "Turnpike", "code": "Turnpike" }, { "name": "Underpass", "code": "Underpass" }, { "name": "Union", "code": "Union" }, { "name": "Unions", "code": "Unions" }, { "name": "Valley", "code": "Valley" }, { "name": "Valleys", "code": "Valleys" }, { "name": "Viaduct", "code": "Viaduct" }, { "name": "View", "code": "View" }, { "name": "Views", "code": "Views" }, { "name": "Village", "code": "Village" }, { "name": "Villages", "code": "Villages" }, { "name": "Ville", "code": "Ville" }, { "name": "Vista", "code": "Vista" }, { "name": "Walk", "code": "Walk" }, { "name": "Walks", "code": "Walks" }, { "name": "Wall", "code": "Wall" }, { "name": "Way", "code": "Way" }, { "name": "Ways", "code": "Ways" }, { "name": "Well", "code": "Well" }, { "name": "Wells", "code": "Wells" }, { "name": "Woods", "code": "Woods" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "st_pos_dir", "type": "esriFieldTypeString", "alias": "Post Directional", "length": 9, "domain": { "type": "codedValue", "name": "StreetDirectional", "description": "Street directional.", "codedValues": [ { "name": "North", "code": "North" }, { "name": "South", "code": "South" }, { "name": "East", "code": "East" }, { "name": "West", "code": "West" }, { "name": "Northeast", "code": "Northeast" }, { "name": "Southeast", "code": "Southeast" }, { "name": "Southwest", "code": "Southwest" }, { "name": "Northwest", "code": "Northwest" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "st_pos_mod", "type": "esriFieldTypeString", "alias": "Post Modifier", "length": 15, "domain": null }, { "name": "st_concat", "type": "esriFieldTypeString", "alias": "Full Street Name", "length": 178, "domain": null }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "globalid", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "gdb_73416_primar", "fields": "primary_id", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r1425_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "uuid_1425", "fields": "globalid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "uuid_oid_1425", "fields": "globalid,objectid", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 6, "name": "geo.sde.Street_Centerline", "relatedTableId": 9, "role": "esriRelRoleDestination", "keyField": "primary_id", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A14FF732-8EDE-4057-94BB-B765E00D6BC3}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": false }, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": true }, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1736787342000 }, "serviceItemId": "93f4133f1b8b4877a19d556df37ebf9e" }