2010-2016 Building Permit Listing

LISTING OF BUILDING PERMITS FOR NEW CONSTRUCTION, DEMOLITION AND ADDITIONS/ALTERATIONS/REPAIRS AND THEIR CHARACTERISTICS - Before 2009, files capture permits only for basic structural work. From 2009 onward, they also capture permits for plumbing, electrical, etc. This results in higher dollar figures and numbers of permits for Additions, Alterations and Repairs and for New Construction. There is no change in how housing units are counted.

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 \"kcmo/20102016-building-permit-listing-yazt-9xgq\".\"20102016_building_permit_listing\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.