Street Construction Permits - Stipulations

For the list of permit stipulations for the 2013-2019, please refer to <a href="https://data.cityofnewyork.us/d/pbk5-6r7z">this link</a>.

DOT issues over 150 different types of sidewalk and roadway construction permits to utilities, contractors, government agencies and homeowners. Permits cover activities such as street openings, sidewalk construction and installing canopies over sidewalks.

Stipulations are rules that apply to a permit. One permit may have multiple stipulations.

For the list of permit stipulations for the 2013-2019, please refer to <a href="https://data.cityofnewyork.us/d/pbk5-6r7z">this link</a>.

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 \"cityofnewyork-us/street-construction-permits-stipulations-gsgx-6efw\".\"street_construction_permits_stipulations\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.