Introduction to PostGIS
Presented by:
Leo Hsu and Regina Obe
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).
No video of the event yet, sorry!
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 of the 2 core vector types geometry and geography including both 2D and 3D subtypes. 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 PostGIS proximity operators and functions including how to utilize new PostgreSQL 9.5 KNN enhancements.for both geometry and geography types Visualizing answers to spatial questions with Open Source desktop spatial tools. Using PostGIS to reshape spatial data. Time permitting, or if enough interest, we'll also do some coverage of PostGIS tiger geocoder, pgRouting, and PostGIS raster. We'll be using PostgreSQL 9.5+ and PostGIS 2.2 for this workshop, but most examples will work with PostGIS 2.1 and lower versions of PostgreSQL.
- Date:
- Duration:
- 30 min
- Room:
- Conference:
- PGConf US 2016 [PgConf.US]
- Language:
- Track:
- Development
- Difficulty:
- Medium