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

preview_player
Показать описание

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:

Check out some other posts and resources here:

#sql #geospatial #gis

Рекомендации по теме
Комментарии
Автор

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! 😊

bc
Автор

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

reygaji