Back to fileView metadata
Schema
Ferry Routes / Ferry Routes / v1.0.0
Schema from ferry-routes-1.parquet, gcp-portolan-published, v1.0.0.
The National Census of Ferry Operators (NCFO) Routes dataset was collected through December 31, 2020 and compiled on October 16, 2024 from the Bureau of Transportation Statistics (BTS) and is part of the U.S. Department of Transportation (USDOT)/Bureau of Transportation Statistics (BTS) National Transportation Atlas Database (NTAD). The Ferry Routes dataset represents all ferry routes from operators that provided responses to the 2020 National Census of Ferry Operators. Areas covered by the dataset include the 50 states as well as the territories of Puerto Rico, the United States Virgin Island, and American Samoa. Each segment in the dataset connects to two terminals from the Ferry Terminals dataset, describing the route ferries travel between them. Route geometries were determined using GPS points from Automatic Identification System data, as well existing government datasets from the Census Bureau, the US Geological Survey, the National Oceanic and Atmospheric Association, and the US Army Corps of Engineers. Other routes were determined using least-cost analysis.
Columns
55 columns
Features
964
Geometry
MultiLineString
| Column | Type | Nullable | Nulls | Unique | Description | Examples / Values |
|---|---|---|---|---|---|---|
| geometry | geometry | No | 0 | — | — Range: —Length: — | Examples: — Values: — |
| operator_id | string | No | 0 | — | — Range: —Length: 3 | Examples: 487, 143, 5, 32, 226 Values: — |
| segment_id | string | No | 0 | — | — Range: —Length: 4 | Examples: 3365, 2096, 431, 952, 1075 Values: — |
| seg_length | float | Yes | 41 | — | — Range: 0.02 to 595Length: — | Examples: 6.0, 32.0, 0.2, 97.0, 0.13 Values: — |
| average_trip_time | float | Yes | 35 | — | — Range: 0 to 2448Length: — | Examples: 25.0, 25.0, 450.0, 15.0, 45.0 Values: — |
| segment_season_start | string | No | 0 | — | — Range: —Length: 5 | Examples: 01/01, 01/01, 01/01, 05/15, 01/01 Values: — |
| segment_season_end | string | No | 0 | — | — Range: —Length: 5 | Examples: 12/31, 12/31, 12/31, 10/24, 12/31 Values: — |
| trips_per_year | float | Yes | 14 | — | — Range: 0 to 85665Length: — | Examples: 3760.0, 11986.0, 5402.0, 20000.0, 429.0 Values: — |
| route_rates_regulated | integer | No | 0 | — | — Range: 0 to 2Length: — | Examples: 0, 1, 1, 0, 0 Values: — |
| route_rate_regulator | string | No | 0 | — | — Range: —Length: 59 | Examples: , Hampton Roads Transit, California Public Utilities Commission, , Values: — |
| most_used_vessel_id | float | Yes | 14 | — | — Range: 5 to 1545Length: — | Examples: 1282.0, 1437.0, 1287.0, 609.0, 346.0 Values: — |
| vessel1_id | float | Yes | 96 | — | — Range: 1 to 1545Length: — | Examples: 967.0, 1279.0, 284.0, 344.0, 457.0 Values: — |
| vessel2_id | float | Yes | 382 | — | — Range: 5 to 1540Length: — | Examples: 524.0, 833.0, 1399.0, 1201.0, 179.0 Values: — |
| vessel3_id | float | Yes | 572 | — | — Range: 74 to 1540Length: — | Examples: 784.0, 1344.0, 185.0, 613.0, 819.0 Values: — |
| vessel4_id | string | Yes | 721 | — | — Range: —Length: 4 | Examples: 353, 185, 1470, 1110, 370 Values: — |
| vessel5_id | string | Yes | 809 | — | — Range: —Length: 4 | Examples: 219, 1436, 1534, 197, 185 Values: — |
| vessel6_id | string | Yes | 846 | — | — Range: —Length: 4 | Examples: 229, 236, 219, 1095, 905 Values: — |
| vessel7_id | string | Yes | 883 | — | — Range: —Length: 4 | Examples: 1460, 370, 1172, 754, 1224 Values: — |
| vessel8_id | string | Yes | 885 | — | — Range: —Length: 4 | Examples: 1493, 371, 371, 1393, 371 Values: — |
| vessel9_id | string | Yes | 905 | — | — Range: —Length: 4 | Examples: 1224, 1511, 109, 1224, 1468 Values: 109, 1166, 1215, 1224, 1354, 1365, 1403, 1440, 1468, 1505, 1511, 1520, 1521, 1525, 755, 92, 962, 964, 965 |
| vessel10_id | string | Yes | 923 | — | — Range: —Length: 4 | Examples: 1261, 1166, 1442, 963, 1261 Values: 109, 1166, 1261, 1404, 1442, 1460, 1520, 1521, 962, 963, 965 |
| vessel11_id | string | Yes | 931 | — | — Range: —Length: 4 | Examples: 1265, 1265, 1265, 1265, 964 Values: 1166, 1265, 1443, 1468, 963, 964 |
| vessel12_id | string | Yes | 953 | — | — Range: —Length: 4 | Examples: 964, 965, 965, 964, 1444 Values: 1444, 1515, 964, 965 |
| vessel13_id | string | Yes | 959 | — | — Range: —Length: 4 | Examples: 1445, 965, 1538, 1445, 1445 Values: 1445, 1538, 965 |
| vessel14_id | string | Yes | 961 | — | — Range: —Length: 4 | Examples: 1446, 1446, 1446 Values: 1446 |
| vessel15_id | string | Yes | 961 | — | — Range: —Length: 4 | Examples: 1447, 1447, 1447 Values: 1447 |
| vessel16_id | string | Yes | 961 | — | — Range: —Length: 4 | Examples: 1448, 1448, 1448 Values: 1448 |
| vessel17_id | string | Yes | 961 | — | — Range: —Length: 4 | Examples: 1486, 1486, 1486 Values: 1486 |
| vessel18_id | string | Yes | 961 | — | — Range: —Length: 4 | Examples: 1507, 1507, 1507 Values: 1507 |
| vessel19_id | string | Yes | 961 | — | — Range: —Length: 4 | Examples: 1522, 1522, 1522 Values: 1522 |
| vessel20_id | string | Yes | 961 | — | — Range: —Length: 4 | Examples: 1480, 1480, 1480 Values: 1480 |
| vessel21_id | string | Yes | 961 | — | — Range: —Length: 4 | Examples: 1516, 1516, 1516 Values: 1516 |
| vessel22_id | string | Yes | 961 | — | — Range: —Length: 4 | Examples: 1537, 1537, 1537 Values: 1537 |
| vessel23_id | string | Yes | 961 | — | — Range: —Length: 4 | Examples: 1535, 1535, 1535 Values: 1535 |
| vessel24_id | string | Yes | 961 | — | — Range: —Length: 4 | Examples: 1492, 1492, 1492 Values: 1492 |
| vessel25_id | string | Yes | 961 | — | — Range: —Length: 4 | Examples: 1487, 1487, 1487 Values: 1487 |
| vessel26_id | string | Yes | 961 | — | — Range: —Length: 4 | Examples: 1484, 1484, 1484 Values: 1484 |
| passengers | float | Yes | 303 | — | — Range: 0 to 11467672Length: — | Examples: 13175.0, 117914.0, 56367.0, 4745.0, 16252.0 Values: — |
| vehicles | float | Yes | 303 | — | — Range: 0 to 1138484Length: — | Examples: 0.0, 37218.0, 30520.0, 2711.0, 0.0 Values: — |
| avg_daily_brd_pax | float | Yes | 346 | — | — Range: 0 to 8511Length: — | Examples: 189.0, 300.0, 86.0, 1.0, 1338.0 Values: — |
| avg_daily_brd_veh | float | Yes | 353 | — | — Range: 0 to 3119Length: — | Examples: 0.0, 0.0, 286.0, 13.0, 0.0 Values: — |
| census_year | integer | No | 0 | — | — Range: 2020 to 2020Length: — | Examples: 2020, 2020, 2020, 2020, 2020 Values: — |
| data_year | integer | No | 0 | — | — Range: 2019 to 2019Length: — | Examples: 2019, 2019, 2019, 2019, 2019 Values: — |
| operator_name | string | No | 0 | — | — Range: —Length: 91 | Examples: Pirate Water Taxi, Transportation District Commission of Hampton Roads, The Catalina Flyer, SeaStreak LLC, Woods Hole Marthas Vineyard and Nantucket Steamship Authority Values: — |
| segment_name | string | No | 0 | — | — Range: —Length: 91 | Examples: Manor Riverwalk #11 - Curtis Hixon Waterfront Park #12, Waterside Norfolk - High Street Landing Portsmouth, Avalon - Balboa Pavilion, , Nantucket - Hyannis Values: — |
| seg_terminal1_id | string | No | 0 | — | — Range: —Length: 4 | Examples: 1052, 514, 75, 266, 265 Values: — |
| seg_terminal2_id | string | No | 0 | — | — Range: —Length: 4 | Examples: 1040, 500, 88, 267, 259 Values: — |
| trip_purpose_commuter_transit | integer | No | 0 | — | — Range: 0 to 1Length: — | Examples: 0, 1, 1, 1, 1 Values: — |
| trip_purpose_pleasure | integer | No | 0 | — | — Range: 0 to 1Length: — | Examples: 1, 1, 1, 1, 1 Values: — |
| trip_purpose_emergency | integer | No | 0 | — | — Range: 0 to 1Length: — | Examples: 0, 0, 0, 1, 0 Values: — |
| trip_purpose_roadway_conn | integer | No | 0 | — | — Range: 0 to 1Length: — | Examples: 0, 0, 0, 0, 0 Values: — |
| trip_purpose_lifeline | integer | No | 0 | — | — Range: 0 to 1Length: — | Examples: 0, 0, 0, 1, 1 Values: — |
| trip_purpose_nps | integer | No | 0 | — | — Range: 0 to 1Length: — | Examples: 0, 0, 0, 0, 0 Values: — |
| trip_purpose_other | integer | No | 0 | — | — Range: 0 to 1Length: — | Examples: 0, 0, 0, 0, 0 Values: — |
| SHAPE_Length | float | No | 0 | — | — Range: 0.0004243143085990358 to 12.933602788844658Length: — | Examples: 0.00467751933674741, 0.009741100470843688, 0.5384409904620067, 0.4327822208169827, 0.43862511382848834 Values: — |
Quality checks: Passed
Invalid geometry count: 0
Columns hash: 03172cd3d36e59ad4f6ad89fbef7419d9289e15e8fb62a3ec9efa4b897b62165