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.