Learn Spatial SQL: Import Data to PostGIS

📖 My Spatial SQL book is out now! ➡️ spatial-sql.com/ ⬅️
Welcome to 🌍 Learn Spatial SQL! These videos will help you learn spatial SQL to use in your modern GIS workflows. This first series focuses on SQL basics to help you get up to speed with SQL as fast as possible. This video will cover several methods of importing data to PostGIS, one of the most widely used spatial databases.
For additional resources discussed in the video check out this link: forrest.nyc/sql-basics-for-sp...
40+ Spatial SQL Resources and Guides: forrest.nyc/40-spatial-sql-re...
Learn Spatial SQL Guides: forrest.nyc/learn-spatial-sql/

[@lucabaggi3951]

I was confused a bit by the -f flag in ogr2ogr because I automatically interpreted it as "from" - while it means "file", i.e. the destination

[@MattForrest]

Whoops! It means format not file. I think I was using another service prior and had that stuck in my head - good catch!

[@gomesygmn]

Great content Matt, do you have any content on the integration of PostgreSQL/PostGIS with ArcGIS Pro and Online? that would also be of great value to the GIS professionals.

[@MattForrest]

I do not as I have been using open source since 2010 but I found this video which may help - m.czcams.com/video/Z1I7bBk9g6g/video.html