Schema
North American Rail Network Nodes / North American Rail Network Nodes / v1.0.0
Schema from north-american-rail-network-nodes.parquet, gcp-portolan-published, v1.0.0.
The North American Rail Network (NARN) Rail Nodes 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 Nodes dataset is a database of 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. The dataset holds topology of the network and provides geographic location information.
| Column | Type | Nullable | Nulls | Unique | Description | Examples / Values |
|---|---|---|---|---|---|---|
| geometry | geometry | No | 0 | — | — Range: —Length: — | Examples: — Values: — |
| FRANODEID | integer | No | 0 | — | — Range: 300000 to 602470Length: — | Examples: 300398, 601935, 602376, 302279, 600127 Values: — |
| COUNTRY | string | No | 0 | — | — Range: —Length: 2 | Examples: US, CA, CA, US, CA Values: CA, US |
| STATE | string | No | 0 | — | — Range: —Length: 2 | Examples: AK, BC, BC, CA, BC Values: AK, BC, CA, HI, OR, WA, YT |
| STFIPS | string | Yes | 2,469 | — | — Range: —Length: 2 | Examples: 02, 41, 41, 02, 41 Values: 02, 06, 15, 41, 53 |
| CTYFIPS | string | Yes | 2,469 | — | — Range: —Length: 3 | Examples: 090, 039, 043, 020, 053 Values: — |
| STCYFIPS | string | Yes | 2,469 | — | — Range: —Length: 5 | Examples: 02090, 41039, 41043, 02020, 41053 Values: — |
| FRADISTRCT | integer | No | 0 | — | — Range: 7 to 99Length: — | Examples: 8, 99, 99, 7, 99 Values: — |
| PASSNGR | string | Yes | 4,996 | — | — Range: —Length: 1 | Examples: A, A, A, A Values: A |
| PASSNGRSTN | string | Yes | 4,996 | — | — Range: —Length: 9 | Examples: Salem, Centralia, Eugene, Albany Values: Albany, Centralia, Eugene, Salem |
| BNDRY | integer | No | 0 | — | — Range: 0 to 3Length: — | Examples: 0, 0, 0, 0, 0 Values: — |