Back to fileView metadata
Schema
Ferry Routes / ferry-routes-1 / v1.0.0
Schema from GeoParquet, GCS hifld-next-datasets-prod, v1.0.0.
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: — |
Invalid geometry count: 0
Columns hash: 03172cd3d36e59ad4f6ad89fbef7419d9289e15e8fb62a3ec9efa4b897b62165