cityofnewyork-us/construction-demolition-registrants-cspg-yi7g
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 3 days ago
Indexed 5 hours ago

Construction Demolition Registrants

Companies listed as of the most recent export date have been issued registrations by the Business Integrity Commission authorizing them to collect, and remove only waste materials resulting from building demolition, construction, alteration or excavation.

This data is collected on the entities that apply with the commission to operate as Class 2 C&D Registrants

Each record represents an entity that is approved to operate in the City of New York by the Commission.

The Application Type field denotes the class of application 'CL2-Exempt' noting the type of applicant which is a C&D Registrant They are able to pickup only waste resulting from demolition, construction alteration or excavation processes throughout the city.

The BIC Number field is unique to every company that applies to the Commission.

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/construction-demolition-registrants-cspg-yi7g\".\"construction_demolition_registrants\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • construction_demolition_registrants
     
     
     
     
     
Upstream Metadata