11-03, 09:00–12:00 (America/New_York), Regency Ballroom B
Spatial SQL is a power tool for GIS analysis, learn the basics using PostGIS.
PostGIS is the industry standard for spatial data storage and analysis. This workshop introduces attendees to the basics of GIS modelling and analysis using spatial SQL. Creating tables, inserting data, and most importantly, forming spatial queries to answer your spatial questions. The workshop assumes some minor familiarity with GIS and database concepts, but should be easy to follow by any attendee with basic experience in programming or scripting (creating a script or program and running it to get a result).
Paul Ramsey co-founded PostGIS in 2001, and has been developing and promoting open source geospatial software solutions ever since. He currently works as a Executive Engineer for Crunchy Data, supporting their many customers and continuing to improve PostGIS and other associated projects.
Leo is a co-author of several books on PostGIS, pgRouting, PostgreSQL, and SQL.
He is a lecturer at Tufts University and teaches a master's course on SQL and database design.
He is a co-founder of Paragon Corporation, a consulting company in Boston, MA, USA specializing in PostGIS and PostgreSQL support.