Load spatial data to PostGIS, BigQuery, Redshift, and Snowflake using spatial SQL!

📖 My Spatial SQL book is out now! ➡️ spatial-sql.com/ ⬅️
Ready to start using spatial SQL? First you will need to upload your spatial data into your database or data warehouse and this video gives you the steps to do so in PostGIS, AWS Redshift, GCP BigQuery, and Snowflake!
0:00 Intro
0:13 Load data to PostGIS
1:40 Turn spatial files to CSV with GDAL
2:37 Load spatial data to Redshift
3:30 Load spatial data to BigQuery
4:03 Load spatial data to BigQuery
5:11 Spatial ELT/ETL with Airbyte
6:21 Load spatial data with dbt
Some of the resources from the video and others to get started:
➡️ Take a look at all the tutorials and links here:
🔗 forrest.nyc/load-geospatial-d...
📓Practice your SQL skills with Stratascratch: stratascratch.com/?via=matthew
🎓 Learn SQL with the best tutorials at LearnSQL: learnsql.com/?ref=matthewforrest
Running PostGIS on Docker: alexurquhart.com/post/set-up-...
Postgres.app: postgresapp.com/
📚 FREE CARTO Account for Students: docs.carto.com/faqs/categorie...
Check out some other posts and resources here:
Learn Spatial SQL: forrest.nyc/learn-spatial-sql/
40+ Resources for Spatial SQL: forrest.nyc/40-spatial-sql-re...
75+ Geospatial Python and Spatial Data Science Resources and Guides: forrest.nyc/75-geospatial-pyt...
#sql #geospatial #gis
➕ Follow me on LinkedIn: / mbforr
🎙️Check out the Modern GIS episode on the MapScaping Podcast: mapscaping.com/podcast/what-i...
🗞️ Modern GIS Newsletter on LinkedIn: / the-guide-to-modern-gi...
🌐 My personal website: forrest.nyc
🚀 My top links and resources: forrest.nyc/links-and-guides-...

[@bc4198]

Woof. They should make it more complicated and arcane. Clearly what's been missing in GIS all these years...
Thanks for walking us through it! 😊

[@MattForrest]

It can be a bit complicated but things like Geoparquet will make life a lot easier. But once you get the data there the analysis speed and scale is awesome.

[@reygaji4001]

pls make some book recommendations to get into Geospatial something like a beginner's guide to advanced/expert :>

[@MattForrest]

Check out Locate Press they have great books on many topics!