Skip to main content

Loading Land registry inspire polygons

Download data​

Downloading a csv file of property price paid data for each of the last three years, postcode coordinates, and land registry cadastral parcels for Stoud.

wget https://use-land-property-
data.service.gov.uk/datasets/inspire/download/Stroud.zip \
&& unzip Stroud.zip
psql -h localhost -p 5432 -U postgres

create table​

CREATE TABLE inspire-polygons-stroud (
  geom geometry(Geometry,4326),
  properties jsonb
);

Import parcels​

Using ogr2ogr 

ogr2ogr -f "PostgreSQL" "PG:host=0.0.0.0 user=postgres dbname=public password=postgres" *.shp -nln inspire-polygons-stroud

Create spatial index​

CREATE INDEX inspire-polygons-stroud-gist ON inspire-polygons-stroud USING GIST (geom);

References​