Overture Maps Foundation[0] is a Joint Development Foundation Project[1] initiated by Amazon, Meta, Microsoft, and tomtom, aiming to create reliable, easy-to-use, and interoperable open map data.

Overture Maps allows us to download open map data, like places of interest, as GeoJSON[2] which we can transform into SQL and ingest into our Postgres database on Supabase.

Using PostGIS we can then programmatically generate vector tiles and serve them to our MapLibre GL client using supabase-js.

- Read the blogpost: https://supabase.link/supa-gis-blog
- Find the code: https://supabase.link/supa-gis-code
- Get started with PostGIS: https://supabase.link/postgis-quickst...
- Self-host Maps: https://supabase.link/protomaps-stora...

Presented by Thor Schaeff (@thorwebdev https://go.thor.bio/x)

[0] https://overturemaps.org/
[1] https://jointdevelopment.org/
[2] https://geojson.org/

CHAPTERS:
00:00 Demo of rendering places on the map
01:44 Intro to Overturemaps Foundation
02:56 Create a new Supabase Project
03:36 Use Overturemaps Python CLI to download places as geojson
04:28 Turn geojson into SQL using GDAL ogr2ogr
05:23 Enable PostGIS extension in Supabase
06:10 Ingest Data into Supabase Database
06:40 Get the database URL from the Supabase dashboard
07:57 Inspect the ingested data in the Supabase dashboard
08:03 Enable row level security on the table
08:51 Create a Postgres Function to generate vector tiles with PostGIS
11:47 Create a website with MapLibre GL and supabase-js
12:40 Add a supabase-js RPC protocol to MapLibre GL
14:10 Conditionally return additional dater based on zoom level
15:23 Use supabase-js to fetch additional data from nested json column
15:58 Serve the website with Python simple web server

💻 Videos to watch next:
▶    • Self-host Maps with Protomaps and Sup...  
▶    • Getting started with PostGIS  
▶    • How to perform geographical queries u...  

👇 Learn more about Supabase 👇

🕸 Website: https://supabase.com/
🏁 Get started: https://app.supabase.com/
📄 Docs: https://supabase.com/docs

🔔 Subscribe for more tutorials and feature updates from Supabase:    / @supabase  

📱 Connect with Us:
🐙 Github: https://www.github.com/supabase
💬 Discord: https://discord.supabase.com/
🐦 Twitter:   / supabase  
▶ Instagram (follow for memes):   / supabasecom  


ABOUT SUPABASE:
Supabase is the open source Firebase alternative. Supabase provides a full Postgres database for every project with pgvector, backups, realtime, and more. Add and manage email and password, passwordless, OAuth, and mobile logins to your project through a suite of identity providers and APIs.

Build in a weekend, scale to millions.

#Supabase #AppDevelopment #RealtimeApps #DeveloperTools #postgres #postgis #gis #geolocation #overturemaps #opensource #openmap