pgBuiltForm

Example routines for extracting metrics of built form from a PostGIS database of building polygons.

Description

This repository contains example SQL queries for extracting metrics about buildings from a PostGIS database. It aims to show how a database can be used to determine attributes on the form and geometry of 2D building footprints. It has been tested on Ordnance Survey MasterMap Topography Layer data and GeoPlace AddressBase Plus.

Journal article:

Beck, A., Long, G., Boyd, D.S., Rosser, J.F., Morley, J., Duffield, R., Sanderson, M., Robinson, D. 2018. Automated classification metrics for energy modelling of residential buildings in the UK with open algorithms. Environment and Planning B: Urban Analytics and City Science

Typeset article: http://journals.sagepub.com/eprint/h489ZksJJ9RKMEbFYNRj/full

Open access (before type-setting) article: http://eprints.nottingham.ac.uk/49693/

Built form extraction and exterior wall ratio

In the code, a PostGIS schema.table derivedinfo.buildingsandheights contains the building footprints (MasterMap) footprints which have been spatially joined to a dataset of address points (AddressBase). A PostGIS topology has been defined over derivedinfo.buildingsandheights.

• The query built_form_classification.sql shows adding a field form_based_on_addressgeometry defining the built form (i.e. detached | semi-detached | mid-terrace | end-terrace | complex).

• The query compute_exterior_wall_ratio_normal_tables.sql shows creation of a table derivedinfo.external_wall_ratio_test containing the length of exterior edges, the length of shared edges and the external wall ratio.

Licence

This work is licensed under a Creative Commons Attribution 4.0 License.

Acknowledgements

This work was supported by the Leverhulme Trust (grant number RP 2013-SL-015).

Additional support was provided by Ordnance Survey and 1Spatial.