FOSS4G - Solving Spatial Problems with PostGIS

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 co-founder of Paragon Corporation, a Boston-based 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 co-authored 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

[@vickyvergara5327]

I might need to run it in 1/2 speed for trying all this

[@nicolasroelandt3586]

Regina barely covers the half of her script ! And most of it is setting the databases / good practices. We should ask for a 1 hour tutorial ! :)

[@geomondego]

The mentioned files are public? Where can we find them?

[@nicolasroelandt3586]

- slides: postgis.us/presentations/FOSS4G2021_SolvingProblemsWithPostGIS.html
- script: postgis.us/presentations/foss4g2021_postgis.sql

[@FOSS4G]

You find the SQL here callforpapers.2021.foss4g.org/foss4g2021/talk/9EPAAQ/