Back to file

Schema

Railroads / Railroads / v1.0.0

View metadata

Schema from railroads.parquet, gcp-portolan-published, v1.0.0.

Railroad includes spur lines, rail yards, mass transit rail lines such as carlines, streetcar tracks, monorail or other mass transit rail, and special purpose rail lines such as cog rail lines, incline rail lines and trams.Download: https://www2.census.gov/geo/tiger/TGRGDB24/tlgdb_2024_a_us_rails.gdb.zipMetadata: https://meta.geo.census.gov/data/existing/decennial/GEO/GPMB/TIGERline/Current_19115/series_tl_2023_roads.shp.iso.xml

Columns
9 columns
Features
113,047
Geometry
LineString
ColumnTypeNullableNullsUniqueDescriptionExamples / Values
geometrygeometryNo0——
Range: —Length: —
Examples: —
Values: —
OIDstringNo0——
Range: —Length: 11
Examples: 11020439069, 11075939383, 11082083090, 11081526175, 11020439474
Values: —
SUFTYPfloatYes2,765——
Range: 374 to 634Length: —
Examples: 505.0, 505.0, 505.0, 505.0, 505.0
Values: —
SUFTYPEABRstringYes2,765——
Range: —Length: 9
Examples: RR, RR, RR, RR, RR
Values: Line, RR, Rail Link, Rlwy, Spur, Tunl
BASENAMEstringYes2,699——
Range: —Length: 34
Examples: Norfolk Southern, Seaboard Coast Line, Missouri Pacific, Seaboard Coast Line, Naval Yard
Values: —
NAMEstringYes2,699——
Range: —Length: 39
Examples: Norfolk Southern Rlwy, Seaboard Coast Line RR, Missouri Pacific RR, Seaboard Coast Line RR, Naval Yard RR
Values: —
MTFCCstringNo0——
Range: —Length: 5
Examples: R1011, R1011, R1011, R1011, R1011
Values: R1011
OBJECTIDintegerNo0——
Range: 1 to 5000Length: —
Examples: 399, 3834, 4837, 4573, 637
Values: —
idintegerNo0——
Range: 1 to 5000Length: —
Examples: 399, 3834, 4837, 4573, 637
Values: —
Quality checks: Passed
Invalid geometry count: 0
Columns hash: f0d2b50ec8a331f57052683552ce2842550ede0ba433cc4ec49a4933c7228536