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

See the Splitgraph documentation for more information.