Leo Hsu and Regina Obe
Co-Founder at Paragon Corporation
Regina Obe and Leo Hsu are co-founders of Paragon Corporation, a database and web application consulting company based in Boston. They have extensive experience with PostGIS and PostgreSQL. They are co-authors of PostGIS in Action (1st and 2nd editions) (publisher Manning) and PostgreSQL: Up and Running (1st and 2nd editions) (publisher O'Reilly).
They are currently working on more books, pgRouting: a Practical Guide, (publisher LocatePress) and PostgreSQL: Up and Running (3rd edition).
Upcoming presentations
No upcoming presentations...
Past presentations
If you want to follow along on your laptop, you should already have PostGIS 2.3 and PostgreSQL 9.6 installed as well as QGIS desktop software. For those who don't have time to prep but still want to follow along, we'll have a test server available with ability to run queries using pgAdmin4. This workshop will cover the following topics: Overview of the 2 core vector types geometry and geography...
Mar 28 2017
We'll cover 10 problems where we've found PostGIS to be the easiest and fastest tool for the job. Areas covered will be: Proximity Analysis Statistical aggregation of data by location Mapping Routing Geocoding Unlikely uses for PostGIS -- non-spatial problems solved by re-imagining the problem as a spatial one. Extra focus on new tricks made possible by PostGIS 2.3+ and PostgreSQL 9.6+.
We'll cover 10 problems where we've found PostGIS to be the easiest and fastest tool for the job. Areas covered will be: Proximity Analysis Statistical aggregation of data by location Mapping Routing Geocoding Unlikely uses for PostGIS -- non-spatial problems solved by re-imagining the problem as a spatial one.
All attendees will receive a free copy of our PostGIS In Action 2e http://www.postgis.us/chapters_edition_2 If you want to follow along on your laptop, you should already have PostGIS 2.2 and PostgreSQL 9.5 installed on your laptop as well as QGIS desktop software. This workshop will cover the following topics: What is PostGIS? and How to install it and spatially enable a database. Fundamentals...
What is PostGIS? How to install it. Fundamentals of the 3 core types geometry, geography including both 2D and 3D subtypes, and raster. How to load data in geography and geometry. How you can use PostGIS for spatial analysis to help answer questions about where and how far using spatial SQL. Visualizing answers to spatial questions with Open Source desktop spatial tools.