Hi there... I need to push a geojson file to Postg...
# ask-communityd
Dean Magee
08/12/2022, 12:59 AMHi there... I need to push a geojson file to Postgres (PostGIS). What is the most efficient way to do this?
One option is to write a shell command (using ogr2ogr) within a task. Is there a recommended way to do this?
✅ 1
Dean Magee
08/12/2022, 1:01 AMFYI, ive tried using Geopandas to_postgis method but that is way too slow.
a
Andrew Huang
08/12/2022, 1:13 AMPerhaps using the collection prefect-shell if you need to write a shell command within a task?
🙌 1
12 Views