Street Construction Permits - Cranes

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.

If cranes are associated with a permit, they are listed here. Most permits do not have cranes.

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-cranes-hcv3-zacv\".\"street_construction_permits_cranes\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.