rubberbox / postgis-demo

PostGIS on Greenplum demo

postgis-demo

Demo material to showcase use of PostGIS on top of Pivotal Greenplum Database. The original demo was build upon the work our friends at Boundless have done in the past, yet as of 25 May 2018, it has been updated and extended to utilize and present data available and for the area of Greater London, UK.

Bill of Materials

Software

• Greenplum Database Sandbox OVA for VMWare (available to download from Pivotal Network)
• PostGIS 2.1.5+pivotal.1 for RHEL 6 extension package (also available to download from Pivotal Network)

Data

Two separate datasets are used throughout this demo, the original Boundless demo dataset for New York City (shapefiles) and the new dataset from Ordnance Survey Open Data and TfL free Transport Data Service for London.

Detailed information for each dataset is available here.

Disclaimer

• Use of Ordnance Survey data is subject to terms at www.ordnancesurvey.co.uk/opendata/licence. Contains Ordnance Survey data © Crown copyright and database right 2018. Contains Royal Mail data © Royal Mail copyright and database right 2018. Contains National Statistics data © Crown copyright and database right 2018.
• TfL free Transport Data Service is 'Powered by TfL Open Data' and 'contains OS data © Crown copyright and database rights 2016'.
• All the software in the package is open source, and freely redistributable.
• This workshop is licensed as Creative Commons “share alike with attribution”, and is freely redistributable under the terms of that license.

Instructions & Background Info

Greenplum Database

Read Welcome to Pivotal Greenplum Database page for information on Greenplum Database.

Greenplum PostGIS Extension

Read About PostGIS page for information on PostGIS Extension for Greenplum.

Geometries

Read Geometries page for background information and better understanding on how a real world object is represented using PostGIS & SQL.

How to Load GIS (Vector) Data

Find generic information on how to load GIS data into a Pivotal Greenplum database here page.

About the Demo Dataset

Read About the demo dataset page for information on number of records and table attributes for the datasets used in this demo.

Loading the Demo Data into a Pivotal Greenplum Database

Follow the detailed instructions available here, on how to load the demo GIS datasets into a Pivotal Greenplum database.

Modules/Exercises included in this demo

• Simple SQL exercises
• Geo/PostGIS SQL