PostGIS: Up and Running
What is PostGIS? How to install it. 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 spatial SQL. Visualizing answers to spatial questions with Open Source desktop spatial tools. How PostGIS is used to shape spatial data.
Time permitting we'll also do some coverage of PostGIS tiger geocoder and pgRouting
If you want to follow along in the workshop, you should have PostGIS 2.1 or above installed on your laptop. Instructions here. We'll be posting content to this workshop page