FOSS4G NA 2024

Using PostGIS
09-09, 13:00–16:00 (America/Chicago), South Classroom

Learn how to use PostGIS and it's family of extensions. How to load and query data (geometry, geography, raster).
Time permitting we'll cover topology.


Basics

  • Installing PostGIS
  • Overview of basic PostGIS types - geometry, geography, raster, topology

Working with geometry and geography data

  • Creating data with functions input functions
  • Loading data from various file formats
  • Using foreign data wrappers (ogr_fdw, postgres_fdw, file_fdw)
  • Viewing data in OpenJump, QGIS, and pgAdmin4
  • Proximity Queries - find top 10 closest things, pois within a distance of me,
  • Geometric Processing - Buffers, Unions, and More
  • Geocoding using postgis_tiger_geocoder extension

Advanced Topics (time permitting)

  • Loading raster data with raster2pgsql
  • Using geometry and raster in single query
  • Using postgis_sfcgal extension for 3D operations
  • Using postgis_topology for data management
This speaker also appears in: