I’ll again offer a half-day Spatial SQL Workshop at the upcoming GPN MAC Conference at Hard Rock Atlantic City. Packed into a few hours, you will hear about database basics, get a SQL language introduction. We will be using PostGIS to perform spatial analysis. Finally, we will be hands-on with materialized views and foreign data wrappers to pull in GIS data from the Internet.

Conference Agenda: Spatial SQL Workshop

If you’re attending the workshop, it is BYOD. The details on preparing your laptop are available on our Getting Started page.

I’ll be presenting a half-day Spatial SQL Workshop at the upcoming MAC URISA 2024 Conference.

The workshop will be updated from what was offered in 2022 to cover new concepts and scenarios not previously covered. We will be hands-on with materialized views and foreign data wrappers to pull in GIS data from the Internet.

Conference Agenda: Spatial SQL Workshop

GIS users deal with large, complex data. However, many GIS users still rely on shapefiles or other antiquated forms of vector data. Even ESRI’s “new” file geodatabase lacks the functionality you get from a true DBMS. Creating your own database server can be a daunting task. Even if you set one up and load your data, you are just scratching the surface of what is possible.

Learn Spatial SQL will help guide you through implementing your own database system, as well as demonstrating how much of your regular GIS workflow can be incorporated directly into your database, using SQL.

While many DBMSs are expensive, one of the best, fully-featured database systems today is the free and open source PostgreSQL. Coupled with the PostGIS extension, you can manage immense data sets and perform complicated tasks all through SQL.

Beginners, fear not. While we will go into advanced topics, this blog will strive to be as approachable and inclusive as possible.

Check back often and feel free to reach out to the author via Twitter or other social media.