🎓 Learn modern GIS with my new courses! ➡️ https://moderngis.xyz ⬅️
🎉 My modern GIS community is open - Spatial Lab ➡️ https://www.spatialstack.ai/ ⬅️
📖 My Spatial SQL book is out now! ➡️ http://spatial-sql.com/ ⬅️
📰 Get the best tech news and support this channel - subscribe to TLDR ➡️ https://tldr.tech/signup?utm_source=MattForrest&utm_campaign=MattForrest-cpa-campaign&utm_medium=newsletter-sponsorship ⬅️
📖 My Spatial SQL book is out now! ➡️ http://spatial-sql.com/ ⬅️
Explore the ultimate guide to Spatial SQL tools! In this video, we dive into every tool designed for spatial analytics, data storage, and geospatial data processing. Whether you're working with spatial databases, data warehouses, processing tools, or analytics engines, this comprehensive overview will help you understand the unique features of each tool and how to choose the right ones for your workflow. Learn how to leverage Spatial SQL for geospatial analytics, identify the best tools for specific tasks, and discover tips to maximize efficiency with spatial data. If you're ready to master Spatial SQL and take your spatial analysis skills to the next level, this video is your one-stop resource!
0:00 Intro
1:35 Spatial SQL Categories
2:27 Relational Databases (PostGIS)
5:18 SpatiaLite/SQLite
7:03 DuckDB
9:56 Data Warehouses (BigQuery, Snowflake)
14:03 Spark & Distributed Computing
16:01 Databricks for Geospatial
17:03 Apache Sedona
18:13 Wherobots
18:50 Apache Iceberg for Geospatial
20:33 Remote Raster Data in Wherobots
22:10 Distributed Query Engines (Trino)
24:19 GPU Accelerated Databases (Heavy AI, Kinetica)
25:42 User Based Analytics (Apache Pinot)
26:30 Clickhouse?
27:23 Final Rankings
Thanks for watching! You can support this channel in a few different ways:
🎓 Learn more and earn certificates in GIS, spatial data science, and data science (affiliate links):
Geographic Information Systems (GIS) Specialization from UC Davis: https://imp.i384100.net/n1Kyxo
Spatial Data Science and Applications from Yonsei University: https://imp.i384100.net/9W6E6W
Python for Everybody from University of Michigan: https://imp.i384100.net/BX3P31
Remote Sensing Image Acquisition, Analysis and Applications: https://imp.i384100.net/Xxe4Ay
📰 I run a weekly newsletter on modern GIS on Substack! Check it out and subscribe here: https://mattforrest.substack.com/
🖥️ Start your 7-day Setapp trial here to access 240+ Mac apps using one subscript https://setapp.sjv.io/c/3493413/343321/5114
Check out some other posts and resources here:
Learn Spatial SQL: https://forrest.nyc/learn-spatial-sql/
40+ Resources for Spatial SQL: https://forrest.nyc/40-spatial-sql-resources-and-guides/
75+ Geospatial Python and Spatial Data Science Resources and Guides: https://forrest.nyc/75-geospatial-python-and-spatial-data-science-resources-and-guides/
#gis #geospatial #spatialsql
➕ Follow me on LinkedIn: http://linkedin.com/in/mbforr/
🎙️Check out the Modern GIS episode on the MapScaping Podcast: https://mapscaping.com/podcast/what-is-modern-gis/
🌐 My personal website: https://forrest.nyc
🚀 My top links and resources: https://forrest.nyc/links-and-guides-for-modern-gis/