Time: 09:00 - 12:00
Room: Ft. Worth 1
This workshop will cover the following topics:
What is PostGIS?
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 also go over new features coming in PostGIS 2.3.
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.