Presented by:


Leo Hsu

Paragon Corporation

Leo Hsu is a master database architect with extensive experience building business intelligence and automation applications for flight management, labor unions, and economic optimization apps. He has over 20 years professional experience working for non-profits and Dot coms developing automated pricing and process applications and devising workflow strategies.

He is a PostgreSQL aficionado and author. He is a co-author with his wife, Regina Obe, on several PostgreSQL related books: PostGIS In Action (now in it's 2nd edition with 3rd edition in the works) (Manning Publications), PostgreSQL Up and Running (now in 3rd edition)(O'Reilly Media), pgRouting: A Practical Guide (Locate Press, 2nd edition in works), and upcoming big book of PostgreSQL in the works (No Starch Press).

No video of the event yet, sorry!

This training will teach you how to use PostGIS related extensions with main focus on the postgis, pgrouting and ogr_fdw spatial extensions. We will also cover techniques for getting the most performance out of your spatial queries. Though most queries will also work on lower versions, we will be using PostgreSQL 11+, PostGIS 2.5+ , and pgRouting 2.6+. We will highlight functions/spatial tricks not available in lower versions of these tools.

What is PostGIS?

  • Introduction to different spatial types geometry (2D and nD), geography, raster, topogeometry
  • Spatial coordinate transformations
  • Where to get Free data
  • Creating spatial tables and populating with SQL Loading spatial data with psql, ogr_fdw, raster2pgsql, shp2pgsql, and ogr2ogr
  • Making non-spatial data spatial (Where as the universal key)
  • What is pgRouting? Creating routing and node tables using SQL Using osm2pgrouting
  • Prepping other spatial data for routing pgRouting algorithms and what each is used for. Viewing results.
  • Spatial queries Viewing query results with OpenJump, pgAdmin4, and QGIS.

Time permitting, we'll demonstrate creating a web app using Leaflet and what's coming in PostGIS 3.0

2019 March 19 09:00 EDT
50 min
Sutton Place
Postgres Conference