Back to fileView metadata
Schema
North American Rail Network Lines / North American Rail Network Lines / v1.0.0
Schema from north-american-rail-network-lines.parquet, gcp-portolan-published, v1.0.0.
The North American Rail Network (NARN) Rail Lines dataset was created in 2016 and was updated on October 16, 2024 from the Federal Railroad Administration (FRA) and is part of the U.S. Department of Transportation (USDOT)/Bureau of Transportation Statistics (BTS) National Transportation Atlas Database (NTAD). The NARN Rail Lines dataset is a database that provides ownership, trackage rights, type, passenger, STRACNET, and geographic reference for North America's railway system at 1:24,000 or better within the United States. The data set covers all 50 States, the District of Columbia, Mexico, and Canada.
Columns
34 columns
Features
302,638
Geometry
MultiLineString
| Column | Type | Nullable | Nulls | Unique | Description | Examples / Values |
|---|---|---|---|---|---|---|
| geometry | geometry | No | 0 | — | — Range: —Length: — | Examples: — Values: — |
| FRAARCID | integer | No | 0 | — | — Range: 300000 to 537162Length: — | Examples: 300550, 305259, 306462, 306155, 300875 Values: — |
| FRFRANODE | integer | No | 0 | — | — Range: 300004 to 498102Length: — | Examples: 302601, 305208, 318653, 355801, 326963 Values: — |
| TOFRANODE | integer | No | 0 | — | — Range: 300006 to 498101Length: — | Examples: 302585, 305226, 318652, 355833, 327042 Values: — |
| STFIPS | string | No | 0 | — | — Range: —Length: 2 | Examples: 53, 41, 53, 46, 16 Values: 02, 16, 27, 30, 31, 38, 41, 46, 49, 53, 56 |
| CNTYFIPS | string | No | 0 | — | — Range: —Length: 3 | Examples: 015, 005, 025, 025, 009 Values: — |
| STCNTYFIPS | string | No | 0 | — | — Range: —Length: 5 | Examples: 53015, 41005, 53025, 46025, 16009 Values: — |
| STATEAB | string | No | 0 | — | — Range: —Length: 2 | Examples: WA, OR, WA, SD, ID Values: AK, ID, MN, MT, ND, NE, OR, SD, UT, WA, WY |
| COUNTRY | string | No | 0 | — | — Range: —Length: 2 | Examples: US, US, US, US, US Values: US |
| FRADISTRCT | integer | No | 0 | — | — Range: 4 to 8Length: — | Examples: 8, 8, 8, 8, 8 Values: — |
| RROWNER1 | string | Yes | 15 | — | — Range: —Length: 4 | Examples: BNSF, OERR, RCPE, PLV, BNSF Values: — |
| RROWNER2 | string | Yes | 4,985 | — | — Range: —Length: 4 | Examples: BNSF, BNSF, BNSF, BNSF, UP Values: BNSF, UP |
| RROWNER3 | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| TRKRGHTS1 | string | Yes | 4,549 | — | — Range: —Length: 4 | Examples: AMTK, CPRS, UP, PTRC, BNSF Values: — |
| TRKRGHTS2 | string | Yes | 4,964 | — | — Range: —Length: 4 | Examples: CORP, RRVW, MRI, CORP, PNWR Values: CBR, CLC, CORP, EE, MRI, PNWR, RARW, RRVW, UP |
| TRKRGHTS3 | string | Yes | 4,996 | — | — Range: —Length: 4 | Examples: CORP, CORP, CORP, UP Values: CORP, UP |
| TRKRGHTS4 | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| TRKRGHTS5 | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| TRKRGHTS6 | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| TRKRGHTS7 | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| TRKRGHTS8 | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| TRKRGHTS9 | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| DIVISION | string | Yes | 2,450 | — | — Range: —Length: 19 | Examples: WASHINGTON, MONTANA, TWIN CITIES, TWIN CITIES, MIDWEST Values: — |
| SUBDIV | string | Yes | 2,513 | — | — Range: —Length: 29 | Examples: O. E., PRC, SECOND, THIRD, MITCHELL Values: — |
| BRANCH | string | Yes | 2,462 | — | — Range: —Length: 27 | Examples: #N\A, #N\A, OAKES, MAIN LINE, #N\A Values: — |
| YARDNAME | string | Yes | 4,458 | — | — Range: —Length: 24 | Examples: SOUTH KLAMATH FALLS YARD, ANCHORAGE, IDAHO FALLS, COLUMBIA CITY YARD, VANCOUVER Values: — |
| PASSNGR | string | Yes | 4,955 | — | — Range: —Length: 1 | Examples: T, T, T, T, T Values: C, D, T |
| STRACNET | string | Yes | 4,755 | — | — Range: —Length: 1 | Examples: S, C, S, C, S Values: C, S |
| TRACKS | float | Yes | 4 | — | — Range: 0 to 3Length: — | Examples: 1.0, 1.0, 0.0, 1.0, 1.0 Values: — |
| NET | string | No | 0 | — | — Range: —Length: 1 | Examples: S, O, M, M, X Values: I, M, O, R, S, X, Y |
| MILES | float | No | 0 | — | — Range: 0.008109571717428021 to 31.828050163228284Length: — | Examples: 0.321725885176169, 0.22951501816047476, 0.5016263919374633, 0.3722290009997923, 2.076526351301034 Values: — |
| KM | float | No | 0 | — | — Range: 0.01305111668824586 to 51.22238400665847Length: — | Examples: 0.5177686584902735, 0.3693693561251634, 0.8072910386882823, 0.5990457074764247, 3.341851908012028 Values: — |
| TIMEZONE | string | No | 0 | — | — Range: —Length: 1 | Examples: P, P, P, C, P Values: C, K, M, P |
| SHAPE_Length | float | No | 0 | — | — Range: 0.00012431155165963542 to 0.5500212750978662Length: — | Examples: 0.006322186549269919, 0.0044774655907643705, 0.007262079002272289, 0.0066533898898702105, 0.03768680900081028 Values: — |
Quality checks: Passed
Invalid geometry count: 0
Columns hash: 32be93ee5fc5c5d86a7a8938e0ebc65259380a19e595c082acba2914a351d709