Detailed Building Permit Data

City of Winnipeg building permits issued since 2010, containing most information about the permit with the exception of declared construction value. For definitions of the building permit status, please see https://ppdportal.winnipeg.ca/Permits/PropertyPermitSearch/SearchFAQ.jsp

To see aggregate declared construction value of permits, see this dataset: https://data.winnipeg.ca/Development-Approvals-Building-Permits-Inspections/Aggregate-Building-Permit-Data/p5sy-gt7y/data

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 \"winnipeg-ca/detailed-building-permit-data-it4w-cpf4\".\"detailed_building_permit_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.