Schema
Ferry Terminals / Ferry Terminals / v1.0.0
Schema from ferry-terminals.parquet, gcp-portolan-published, v1.0.0.
The National Census of Ferry Operators (NCFO) Terminals 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 Terminals dataset represents all ferry terminals 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. The terminals represent departure and arrival locations for ferry segments in the NCFO. As part of the NCFO questionnaire, respondents were asked terminal name, city, and state. From this information, longitude and latitudes were obtained through open, online searches that include operator websites and map platforms such as Google Maps and Open Street Maps. As a result, termina sometimes do not represent the exact location where ferry vessels dock but may represent other locations such as the operator’s business location or alternative docking locations. However, whenever possible, the terminal locations represent departure and arrival points for that ferry segment. Each terminal contains information about its operation and ownership status, in addition to geographic location and transportation connections, whenever operators provided this information.
| Column | Type | Nullable | Nulls | Unique | Description | Examples / Values |
|---|---|---|---|---|---|---|
| geometry | geometry | No | 0 | — | — Range: —Length: — | Examples: — Values: — |
| TERMINAL_ID | string | No | 0 | — | — Range: —Length: 4 | Examples: 1021, 349, 879, 368, 919 Values: — |
| OPERATOR_ID | string | No | 0 | — | — Range: —Length: 3 | Examples: 472, 142, 106, 147, 400 Values: — |
| TERMINAL_NAME | string | No | 0 | — | — Range: —Length: 51 | Examples: Astoria, Port Liberte, Ouzinkie, Greenport, Soissons Landing Values: — |
| TERM_CITY | string | No | 0 | — | — Range: —Length: 28 | Examples: Queens, Jersey City, Ouzinkie, Greenport, New York Values: — |
| TERM_STATE | string | No | 0 | — | — Range: —Length: 2 | Examples: NY, NJ, AK, NY, NY Values: — |
| TERM_COUNTRY | string | No | 0 | — | — Range: —Length: 14 | Examples: United States, United States, United States, United States, United States Values: American Samoa, Canada, Puerto Rico, United States, Virgin Islands |
| IN_OPERATION | integer | No | 0 | — | — Range: 0 to 1Length: — | Examples: 1, 1, 1, 1, 1 Values: — |
| PARKING | float | Yes | 7 | — | — Range: 0 to 1Length: — | Examples: 1.0, 1.0, 0.0, 1.0, 0.0 Values: — |
| LOCAL_BUS | float | Yes | 7 | — | — Range: 0 to 1Length: — | Examples: 0.0, 0.0, 0.0, 1.0, 0.0 Values: — |
| INTERCITY_BUS | float | Yes | 7 | — | — Range: 0 to 1Length: — | Examples: 0.0, 0.0, 0.0, 0.0, 0.0 Values: — |
| LOCAL_RAIL | float | Yes | 7 | — | — Range: 0 to 1Length: — | Examples: 0.0, 0.0, 0.0, 0.0, 0.0 Values: — |
| INTERCITY_RAIL | float | Yes | 7 | — | — Range: 0 to 1Length: — | Examples: 0.0, 0.0, 0.0, 0.0, 0.0 Values: — |
| BIKE_SHARE | float | Yes | 7 | — | — Range: 0 to 1Length: — | Examples: 0.0, 0.0, 0.0, 1.0, 0.0 Values: — |
| TERMINAL_OWNERSHIP | string | No | 0 | — | — Range: —Length: 7 | Examples: PUBLIC, PRIVATE, PUBLIC, PUBLIC, PRIVATE Values: , BOTH, PRIVATE, PUBLIC |
| TERMINAL_OWNED_BY | string | No | 0 | — | — Range: —Length: 57 | Examples: NYCDSBS, , City of Ouzinkie, MTA-LIRR, Values: — |
| TERMINAL_OPERATION | string | No | 0 | — | — Range: —Length: 7 | Examples: PUBLIC, PRIVATE, PUBLIC, PRIVATE, PRIVATE Values: , BOTH, PRIVATE, PUBLIC |
| TERMINAL_OPERATED_BY | string | No | 0 | — | — Range: —Length: 57 | Examples: NYCEDC, , City of Ouzinkie, , 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: — |
| LATITUDE | float | No | 0 | — | — Range: -14.283394 to 61.123855Length: — | Examples: 40.771683, 40.68734725, 57.921375, 41.100237, 40.693205 Values: — |
| LONGITUDE | float | No | 0 | — | — Range: -170.6819 to -64.617851Length: — | Examples: -73.935773, -74.07517747, -152.500855, -72.361733, -74.01504 Values: — |