AMS Pasadena Precipitation Data

The data in this data environment was collected from the Pasadena, California testbed, namely I-210, SR 134, and nearby arterials. The source of these data is from the National Center for Environmental Information – National Oceanic and Atmospheric Administration. Precipitation information from this data source is used in the cluster analysis.

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 \"datahub-transportation-gov/ams-pasadena-precipitation-data-t6ey-ykqh\".\"ams_pasadena_precipitation_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.