Regulated Storage Tanks in Colorado, Oil & Public Safety

This dataset includes information about storage tanks registered with the State of Colorado, Department of Labor & Employment, Division of Oil & Public Safety. The data are a combination of information provided by the owner and collected during inspection by the State of Colorado, Department of Labor & Employment, Division of Oil & Public Safety. There is no guarantee the data published are 100% accurate, correct, current or complete. This dataset does not include tanks that were applied for installation permit but were denied or never installed. The This information is also publicly accessible at https://socgov18.my.site.com/s/

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 \"colorado-gov/regulated-storage-tanks-in-colorado-oil-public-qszy-xfii\".\"regulated_storage_tanks_in_colorado_oil_public\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.