PostGIS Day 2014

PostGIS Day London 20th Nov 2014

Start	What	Who
9:30	Registration/Coffee	n/a
10:00	Quick Intro	Jo
10:15	PostGIS at the Ordnance Survey	Tim Martin
10:45	AWS for Megadata	Andrew Zolnai
11:15	Oracle Foreign Data Wrappers	Aileen Heal
11:45	Using PostGIS to power an interactive dashboard	Stephen Knox
12:15	Towards a true 3D GIS	Claire Ellul
13:00	Lunch	n/a
14:00	Merging Vector Geometries with Rasters	Dave Barter
14:15	Map My Article	Kevin Daniells
14:30	Loading...	Matt Walker
14:45	Architecture and Triggers for data creation and management	Simon Miles
15:00	Coffee	n/a
15:15	How to build an audit in PostGIS	Andy Bailey
15:30	Metadata in PostGIS	Claire Ellul
15:45	Discussion - useful utilities and where to get help	Jo/Matt
16.30	End	n/a

PostGIS & Postgres utilities
- pgtune
  - Suggest sensible config based on memory, cores etc.
- pgbench
  - Benchmark SQL
- csvkit
  - Manipulate CSV incl. loading into PostgreSQL
- mdb2postgresql
  - Load Access MDB into PostgreSQL
- pl/pgsql debugger
  - pgAdmin plugin for debugging PL/SQL
- pgAgent
  - A job scheduling agent for PostgreSQL, capable of running multi-step batch/shell and SQL tasks on complex schedules
- Pyrseas
  - Database migrations for PostgreSQL
- GeoTools
  - Access to PostGIS data in Java (used by GeoServer)
- ppygis
  - Adds support for PostGIS geometry to psycopg
- pgRouting
  - Extends the PostGIS / PostgreSQL geospatial database to provide geospatial routing functionality. Articles. Docs
- PortableGIS
  - GIS on a USB stick with QGIS, PostGIS etc.
Awesome PostGIS functions
PostGIS & Postgres resources
General Discussion
- shp2pgsql-gui on a Mac
Link to OSM boundary vector data (suffers from demand problems)
- https://osm.wno-edv-service.de/boundaries/