Backup data formats

Initial data processing from OS Addressbase and OS MasterMap is scripted in etl to produce CSV text files (without header lines).

Geometries

Output as geoms.csv

Column	Type	Notes
geometry_id	integer	Colouring London unique id for geometry
source_id	string	Ordnance Survey MasterMap TOID
geometry	string	Well-Known Text representation of geometry

e.g.

1,osgb01,"POLYGON ((-0.1 51.6, -0.2 51.7, ...))"
2,osgb99,"POLYGON ((-0.1 51.7, -0.1 51.6, ...))"

Buildings

Output as buildings.csv

Column	Type	Notes
geometry_id	integer	Colouring London unique id for geometry
uprns	string	Unique Property Reference Numbers (parse as a list of integers) which fall within the building footprint
min_uprn	integer	UPRN with smallest integer value

e.g.

1,[3],3
2,"[6,7]",6