We'll look at 10 problems commonly solved with PostGIS. The focus will be the use of PostGIS 3.1+ and PostgreSQL 13+..
Examples will be in areas of proximity analysis, geocoding, aggregation of spatial statistics, web mapping, and some unconventional uses of PostGIS.

In this talk we'll explore the following PostGIS related extensions and how they can be used to load and analyze data.
We'll also highlight new features in newer versions of PostGIS that simplify solving of problems.
Extension coverage will be: * postgs the core extension * postgis_raster extension packaged with postgis for raster analysis * postgis_topology postgis extension commonly used for data cleanup * postgis_sfcgal postgis extension with advanced processing and 3D support * ogrfdw a PostgreSQL spatial foreign data wrapper extension

Authors and Affiliations –
Regina Obe is a cofounder of Paragon Corporation, a Bostonbased PostgreSQL/PostGIS consulting company. She is a member of the PostGIS, GEOS, and pgRouting project steering committees and development teams. She is also a member of the OSGeo System Administration team,

She is the maintainer of the PostGIS application stackbuilder Windows Bundle. She has also coauthored several books on PostGIS, pgRouting, and PostgreSQL with her husband, Leo Hsu.

Track –
Use cases & applications

Topic –
Data visualization: spatial analysis, manipulation and visualization

Level –
2 Basic. General basic knowledge is required.

Language of the Presentation –
English