CBRM_Buildings

The dataset contains the building footprints of all buildings in the CBRM as polygons. Along with the spatial information, the dataset also includes specific attributes of the buildings such as building description, class, and building name.

Attribute descriptions:

THE_GEOM: Building polygon geometry

CODE1: Identifies the building uses

CODE2: Identifies the building uses if more than 1

CODE3: Identifies the building uses if more than 2

CODE4: Identifies the building uses if more than 3

CODE5: Identifies the building uses if more than 4

CODE6: Identifies the building uses if more than 5

CODE7: Identifies the building uses if more than 6

CODE8: Identifies the building uses if more than 7

CODE9: Identifies the building uses if more than 8

CODE10: Identifies the building uses if more than 9

DESCRIP1: Description of building

DESCRIP2: Description of building if more than 1

DESCRIP3: Description of building if more than 2

NAME: Name of building if exists

GEN_CLASS: General class of building

GEN_CLASS2: Secondary general class of building

DB_UPDATED: Last date the attributes were updated

GR_UPDATED: Last date the geometry was updated

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 \"thedatazone-ca/cbrmbuildings-sb2f-wrrc\".\"cbrmbuildings\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.