Back to fileView metadata
Schema
Secondary Roads Interstates and US Highways / Secondary Roads Interstates and US Highways / v1.0.0
Schema from secondary-roads-interstates-and-us-highways-2.parquet, gcs-hifld-next-datasets-prod, v1.0.0.
Secondary roads are main arteries, usually in the U.S. Highway, State Highway, or County Highway system. These roads have one or more lanes of traffic in each direction, may or may not be divided, and usually have at-grade intersections with many other roads and driveways. They often have both a local name and a route number.Download: https://www2.census.gov/geo/tiger/TGRGDB24/tlgdb_2024_a_us_roads.gdb.zipMetadata: https://meta.geo.census.gov/data/existing/decennial/GEO/GPMB/TIGERline/Current_19115/series_tl_2023_roads.shp.iso.xml
Columns
20 columns
Features
31,068
Geometry
LineString
| Column | Type | Nullable | Nulls | Unique | Description | Examples / Values |
|---|---|---|---|---|---|---|
| geometry | geometry | No | 0 | — | — Range: —Length: — | Examples: — Values: — |
| BASENAME | string | No | 0 | — | — Range: —Length: 13 | Examples: 165, 221, 90, 169, 231 Values: — |
| MTFCC | string | No | 0 | — | — Range: —Length: 5 | Examples: S1200, S1200, S1200, S1200, S1200 Values: S1200 |
| NAME | string | No | 0 | — | — Range: —Length: 22 | Examples: US Hwy 165 Bus, US Hwy 221, US Hwy 90 Alt, US Hwy 169, US Hwy 231 Values: — |
| OBJECTID | integer | No | 0 | — | — Range: 1 to 58248Length: — | Examples: 4218, 45401, 56958, 54561, 6462 Values: — |
| OID | string | No | 0 | — | — Range: —Length: 12 | Examples: 11081557356, 110434951831, 110455526828, 110453141822, 110139911527 Values: — |
| PREDIR | string | Yes | 4,804 | — | — Range: —Length: 2 | Examples: 11, 13, 11, 11, 13 Values: 11, 12, 13, 14, 18 |
| PREDIRABRV | string | Yes | 4,804 | — | — Range: —Length: 2 | Examples: N, E, N, N, E Values: E, N, S, SW, W |
| PREQUAL | string | Yes | 4,954 | — | — Range: —Length: 2 | Examples: 20, 20, 20, 20, 20 Values: 13, 20 |
| PREQUALABR | string | Yes | 4,954 | — | — Range: —Length: 3 | Examples: Old, Old, Old, Old, Old Values: Bus, Old |
| PRETYP | float | Yes | 1 | — | — Range: 344 to 641Length: — | Examples: 640.0, 640.0, 640.0, 640.0, 640.0 Values: — |
| PRETYPEABR | string | Yes | 1 | — | — Range: —Length: 6 | Examples: US Hwy, US Hwy, US Hwy, US Hwy, US Hwy Values: I-, US Hwy, US Rte |
| RTTYP | string | No | 0 | — | — Range: —Length: 1 | Examples: U, U, U, U, U Values: I, U |
| SUFDIR | float | Yes | 4,753 | — | — Range: 11 to 17Length: — | Examples: 12.0, 14.0, 11.0, 11.0, 12.0 Values: — |
| SUFDIRABRV | string | Yes | 4,753 | — | — Range: —Length: 2 | Examples: S, W, N, N, S Values: E, N, NE, S, SE, W |
| SUFQUAL | float | Yes | 4,321 | — | — Range: 12 to 24Length: — | Examples: 13.0, 13.0, 14.0, 13.0, 13.0 Values: — |
| SUFQUALABR | string | Yes | 4,321 | — | — Range: —Length: 3 | Examples: Bus, Bus, Byp, Bus, Bus Values: Alt, Bus, Byp, Con, Exd, Lp, Scn, Spr |
| SUFTYP | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| SUFTYPEABR | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| id | integer | No | 0 | — | — Range: 1 to 58248Length: — | Examples: 4218, 45401, 56958, 54561, 6462 Values: — |
Quality checks: Passed
Invalid geometry count: 0
Columns hash: 087909c8b8de89db8bbf4f9d5a15908913bc025f75c7bf389ba7bcdc289fbaba