Rail Intercity Stations

<div><font color="#112e51" face="Helvetica"><span style="font-size:16px;">Intercity passenger rail services provide transportation between metropolitan areas, to rural areas of California, and to points beyond California’s borders. California’s intercity rail services can be divided into two groups: 1) state-supported routes, which are funded by the State and serve California travel markets; and 2) Amtrak long-distance routes, which are funded by Amtrak and serve California and interstate markets. This feature class represents three state-supported intercity passenger rail stations: Pacific Surfliner Route (San Luis Obispo – Los Angeles – San Diego), San Joaquin Route (Bay Area/Sacramento – Stockton – Bakersfield), and Capitol Corridor (San Jose – Oakland – Sacramento – Roseville/Auburn).</span></font><br /></div><div><br /></div>

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 \"bayareametro-gov/rail-intercity-stations-xqi3-r8e5\".\"rail_intercity_stations\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.