Icon for Socrata external plugin
Open repository in Console
Updated 14 hours ago
Indexed 4 hours ago

Large Utility Excavation Permits

Large excavation permits issued by SF Public Works that are currently active or approved plus permits whose end date passed within the last year. This is a special data set created for the Dig Once Program. Large excavation permits are 1000 square feet in size or larger.

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" \
{"sql": "
    SELECT *
    FROM \"sfgov/large-utility-excavation-permits-i926-ujnc\".\"large_utility_excavation_permits\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • large_utility_excavation_permits
Upstream Metadata