Post Content
Video of a conference talk about the open source geospatial community presented by Regina Obe at POSETTE: An Event for Postgres 2024. PostGIS, introduced in 2001, is one of the oldest Postgres extensions around. But PostGIS is not just built on Postgres. PostGIS is a love child, born of the Postgres community and the vibrant open source geospatial community.
Today many geospatial applications house their data in Postgres, because of PostGIS.
And PostGIS is usually one of the first data sources to be supported by new geospatial tools, whether open source or proprietary. More importantly, folks who know little about spatial can get up to speed with PostGIS quickly and build geospatial applications—with nothing but an application layer that understands how to work with SQL.
In this talk you’ll learn how (and why) PostGIS came about, and how the open source geospatial community has huge bodies of data that will continue to place demands on PostGIS and Postgres into the future.
Regina Obe is President and co-founder of Paragon Corporation, a Boston-based PostgreSQL/PostGIS consulting company. She is a member of the PostGIS, pgRouting, and GEOS project steering committees, as well as a development team member of several geospatial projects and Open Source Geospatial Foundation (OSGeo) System Administration team.
She is the maintainer of the PostGIS application stackbuilder Windows Bundle.
Regina has also co-authored several popular books on PostGIS, pgRouting, and PostgreSQL with her husband, Leo Hsu. Most recent editions are PostGIS In Action 3rd Edition, SQL in a Nutshell 4th edtion, pgRouting: a practical guide (2nd edition in development), PostgreSQL: Up and Running 3rd edition.
Chapters:
00:00 Introduction
01:26 What is PostGIS?
02:33 Spatial Standards & SQL
03:48 History of Relational vs. Spatial
05:33 PostGIS wasn’t only spatial extension
06:27 PostGIS’s desktop tool friends
07:25 What makes up PostGIS?
08:57 OpenStreetMap project
11:31 Example PostGIS queries
12:14 PostGIS raises the bar for RDBMS
14:12 Flat, round, matrix, relational
17:51 Related Postgres extensions
? Everything you need to know about POSETTE: An Event for Postgres 2024 can be found at: https://aka.ms/posette
✅ Learn more:
Watch more POSETTE talks: https://aka.ms/posette-playlist
? Let’s connect:
X – @PosetteConf https://x.com/PosetteConf
Mastodon – @posetteconf https://mastodon.social/@posetteconf
Threads – @posetteconf https://www.threads.net/@posetteconf
? Subscribe to the POSETTE News: https://aka.ms/posette-subscribe
#PosetteConf #PostgreSQL #PostGIS
Presenters:
Regina Obe, Paragon Corporation, PostGIS PSC
Connect:
Regina Obe: https://mapstodon.space/@robe, https://twitter.com/reginaobe, https://www.linkedin.com/in/regina-obe-2000057/ Read More Microsoft Developer
+ There are no comments
Add yours