The Open Source Geospatial Community, PostGIS, & Postgres | POSETTE 2024
Key Takeaways
Introduces the open-source geospatial community, PostGIS, and its relation to Postgres
Original Description
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 quer
Watch on YouTube ↗
(saves to browser)
Sign in to unlock AI tutor explanation · ⚡30
Playlist
Uploads from Microsoft Developer · Microsoft Developer · 0 of 60
← Previous
Next →
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
Prepare for the DP-300 exam & the Azure Database Administrator Associate cert | Data Exposed
Microsoft Developer
What I Wish I Knew ... about landing a job in tech
Microsoft Developer
Igniting Developer Innovation with Vector Search
Microsoft Developer
Combining the power of vector search with Azure OpenAI then revolutionize image search with vectors!
Microsoft Developer
What I Wish I Knew ... about finding your place in tech
Microsoft Developer
Fluent UI React Insights: Accessible by default
Microsoft Developer
Signing Container Images with Notary Project
Microsoft Developer
What I Wish I Knew ... about finding your place in tech
Microsoft Developer
What programming languages does GitHub Copilot support?
Microsoft Developer
What I Wish I Knew ... about how much your job can change
Microsoft Developer
What I Wish I Knew ... about how much your job can change
Microsoft Developer
How do I become more confident about AI?
Microsoft Developer
How do I become more confident about AI?
Microsoft Developer
Performance Demos of SQL’s Intelligent Query Processing Feedback capabilities | Data Exposed
Microsoft Developer
What I Wish I Knew ... about coming to Microsoft
Microsoft Developer
What I Wish I Knew ... about coming to Microsoft
Microsoft Developer
Revolutionizing Image Search with Vectors
Microsoft Developer
Igniting developer innovation with Vector search and Azure OpenAI
Microsoft Developer
Getting Started with Azure AI Studio's Prompt Flow - Part 2
Microsoft Developer
What I Wish I Knew ... about finding my career path
Microsoft Developer
What I Wish I Knew ... about finding my career path
Microsoft Developer
Windows Terminal's journey to Open Source
Microsoft Developer
Can I trust the code that GitHub Copilot generates?
Microsoft Developer
What I Wish I Knew ... about interviewing
Microsoft Developer
What I Wish I Knew ... about interviewing
Microsoft Developer
What is the Microsoft TechSpark Program?
Microsoft Developer
SQL Server 2022: Accelerate query performance while reducing query compile time - w/ no code changes
Microsoft Developer
What I Wish I Knew ... about discovering computer science
Microsoft Developer
What I Wish I Knew ... about discovering computer science
Microsoft Developer
Call center transcription and analysis using Azure AI
Microsoft Developer
How to use Text Analytics for health in Azure AI Language
Microsoft Developer
Azure OpenAI-powered summarization in Azure AI Language
Microsoft Developer
Accelerate data labeling using Azure OpenAI and Azure AI Language
Microsoft Developer
Building a Private ChatGPT with Azure OpenAI
Microsoft Developer
What I Wish I Knew ... about how to interview
Microsoft Developer
What I Wish I Knew ... about how to interview
Microsoft Developer
Getting Started with Azure AI Studio's Prompt Flow - Part 3
Microsoft Developer
Intelligent Apps with Azure Kubernetes Service (AKS)
Microsoft Developer
Getting Started with Azure Blob Storage | Data Exposed: MVP Edition
Microsoft Developer
Chat + Your Data + Plugins
Microsoft Developer
What I Wish I Knew ... about different career paths
Microsoft Developer
What I Wish I Knew ... about different career paths
Microsoft Developer
Advanced Dev Tunnels Features | OD122
Microsoft Developer
Learn Live - Manage performance and availability in Azure Cosmos DB for PostgreSQL
Microsoft Developer
Plan your SQL Migration to Azure with confidence | Data Exposed
Microsoft Developer
What I Wish I Knew ... about social skills in a tech career
Microsoft Developer
What I Wish I Knew ... about social skills in a tech career
Microsoft Developer
All About Vectors, Search, and Function Calling in Azure OpenAI - Labor Day Special
Microsoft Developer
Introduction to project ORAS
Microsoft Developer
What I Wish I Knew ... about finding the right major
Microsoft Developer
What I Wish I Knew ... about finding the right major
Microsoft Developer
What I Wish I Knew ... about how to approach programming
Microsoft Developer
What I Wish I Knew ... about how to approach programming
Microsoft Developer
Learn Live - Scale from a single node to multiple nodes with Azure Cosmos DB for PostgreSQL
Microsoft Developer
What I Wish I Knew ... about diversity in tech #1
Microsoft Developer
What I Wish I Knew ... about diversity in tech #1
Microsoft Developer
Get started with SQL Server AGs across Windows, Linux and Container Replicas | Data Exposed
Microsoft Developer
Writing LLM Apps with Azure AI and PromptFlow
Microsoft Developer
What I Wish I Knew ... about how cool working in tech could be
Microsoft Developer
Open Source foundation models in Azure Machine Learning & optimization techniques behind the scenes
Microsoft Developer
More on: Staying Current in AI
View skill →
Related Reads
Chapters (9)
Introduction
1:26
What is PostGIS?
2:33
Spatial Standards & SQL
3:48
History of Relational vs. Spatial
5:33
PostGIS wasn't only spatial extension
6:27
PostGIS's desktop tool friends
7:25
What makes up PostGIS?
8:57
OpenStreetMap project
11:31
Example PostGIS quer
🎓
Tutor Explanation
DeepCamp AI