My Spatial SQL book is out now! ➡ http://spatialsql.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:
https://forrest.nyc/loadgeospatiald...
Practice your SQL skills with Stratascratch: https://stratascratch.com/?via=matthew
Learn SQL with the best tutorials at LearnSQL: https://learnsql.com/?ref=matthewforrest
Running PostGIS on Docker: https://alexurquhart.com/post/setup...
Postgres.app: https://postgresapp.com/
FREE CARTO Account for Students: https://docs.carto.com/faqs/categorie...
Check out some other posts and resources here:
Learn Spatial SQL: https://forrest.nyc/learnspatialsql/
40+ Resources for Spatial SQL: https://forrest.nyc/40spatialsqlre...
75+ Geospatial Python and Spatial Data Science Resources and Guides: https://forrest.nyc/75geospatialpyt...
#sql #geospatial #gis
➕ Follow me on LinkedIn: / mbforr
Check out the Modern GIS episode on the MapScaping Podcast: https://mapscaping.com/podcast/whati...
Modern GIS Newsletter on LinkedIn: / theguidetomoderngis6881258721524236288
My personal website: https://forrest.nyc
My top links and resources: https://forrest.nyc/linksandguides...