Inserting Data into PostGIS

We cover inserting data into PostGIS using GeoPandas and GDAL's ogr2ogr.
Please feel free to ask questions about anything that wasn't clear, or you'd like to see more of!
Code from the video can be found here:
github.com/Geo...
The data used is from Flight Radar 24:
www.flightrada...
The data was pulled using the FlightRadarAPI python library
github.com/Jea...
GeoPandas to_postgis() documentation
geopandas.org/...
GDAL's ogr2ogr documentation
gdal.org/progr...

[@JeanExtreme002]

Hey, this is a nice project! Your videos are really good :D

[@felixschwarz4699]

I tried it with a different dataset and get a ValueError: geometry (geometry(MULTIPOLYGON,4326)) not a string when doing the to_postgis. Does anyone have an idea why?

[@peterwjacko]

Hey man, I saw your post on r/gis a few weeks ago and I only got around to watching a couple of your vids today. I'm looking into migrating my geospatial data into a postgis database but I couldn't find any resources that I really like, they're either too high level or low level for my current knowledge, the audio isn't great, or the content is outdated. You keep it simple and concise with nice clear audio, great explanations, and perfect pace (not too much content per video and not too slow). The only bit of feedback I have is that sometimes your mouse cursor disappears and it can be hard to follow what is going on - maybe just an OBS issue? Do you have a Twitter handle or anything? Anyway, I'm looking forward to more!

[@geospatial_programming]

I'm really glad this is immediately relevant to you! I'll check OBS and ensure the mouse is on.

[@bawonos024]

I couldn't find any csv dataset in the github repo you shared. Do you have any tutorial on how to retrieve flightradar data?

[@geospatial_programming]

Sorry about that, I definitely thought I had uploaded them. They're up there now: github.com/GeospatialProgramming/PostGIS/blob/main/Inserting%20Data%20into%20Postgis/fr24.7z

[@EnKarlinaturen]

Hey, thanks for good videos! Do you know of any other similar dataset that is easy accesible to test what you are doing in the videos? I have been able to setup everything, but haven't had the time or the knowledge to retrieve the Flight data you been able to retrieve. Thanks!

[@geospatial_programming]

Sorry for the late reply - I'd check Kaggle, any dataset of points with a Lat and Lon should work