Intercity Air, Bus, and Rail Transportation Facilities

Airports with scheduled service and intercity bus and intercity rail (Amtrak/Alaska rail) facilities for years 2006, 2012, 2018, and 2021. Used to find rural areas with access to one or more of these transportation modes: https://data.transportation.gov/Research-and-Statistics/Access-to-Intercity-Transportation-in-Rural-Areas/29cj-8s4a .

Airports with scheduled service and intercity bus and intercity rail (Amtrak/Alaska rail) facilities for years 2006, 2012, 2018, and 2023. Used to find rural areas with access to one or more of these transportation modes: https://data.transportation.gov/Research-and-Statistics/Access-to-Intercity-Transportation-in-Rural-Areas/29cj-8s4a . In 2021, bus stops are from the Intercity Bus Atlas (https://geodata.bts.gov/datasets/usdot::intercity-bus-atlas-stops/explore). To allow the use of the Intercity Bus Atlas (ICBA) datasets, intercity bus providers grant the USDOT a Creative Commons Attribution – Non-commercial 4.0 International (CC-BY-NC 4.0) license. The CC-BY-NC 4.0 license is available at, https://creativecommons.org/licenses/by-nc/4.0/legalcode. For more information about the memorandum of understanding between partner intercity bus providers and BTS underlying the ICBA, please consult https://www.bts.gov/national-intercity-bus-atlas-partnerships. ICBA data are permitted and encouraged for research, analysis, and planning. The data are not intended for trip planning, scheduling, navigation, or any real-time or near real-time use by passengers, transportation operators, service providers, or transportation planners. Commercial and all other reuse of the data is prohibited. As part of the license agreement for the data, BTS are also not permitted to make substantive material alterations to the submitted GTFS data. All other uses or re-uses of the data are prohibited. Finally, BTS expressly disclaims all liability for the unauthorized use of or misuse of any data collected as a part of this effort by third parties. BTS furthermore does not guarantee the real-time or near real-time accuracy or quality of the data as route service information, bus stop location information and other data collected may change over time.

Interactive map showing access to intercity transportation in rural areas:

https://datahub.transportation.gov/stories/s/Rural-Access-to-Intercity-Transportation/gr9y-9gjq/edit

Methodology:

https://datahub.transportation.gov/stories/s/dbb4-pr2c

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"bts-gov/intercity-air-bus-and-rail-transportation-xnub-2sc4\".\"intercity_air_bus_and_rail_transportation\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.