DOB Sign Application Filings

Outdoor advertising regulations and zoning laws reduce visual clutter and protect people from dangerous and illegally installed signs. Signs must comply with regulations outlined in the NYC Construction Codes and the NYC Zoning Resolution. This dataset lists all sign applications filed in New York City.

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/dob-sign-application-filings-nyis-y4yr\".\"dob_sign_application_filings\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.