Geopandas to postgis example

gpd_to_postgis_example.py

# Load pkgs and data
import geopandas as gpd
data = gpd.read_file("https://gist.githubusercontent.com/HTenkanen/456ec4611a943955823a65729c9cf2aa/raw/be56f5e1e5c06c33cd51e89f823a7d770d8769b5/ykr_basegrid.geojson")
world = gpd.read_file(gpd.datasets.get_path('naturalearth_lowres'))

# Subset argentina as single ply
argentina = world[world['name'] == 'Argentina' ]
                  
# Define engine
engine = create_engine("postgresql+psycopg2://[user]:[password]@localhost:5432/[my_db]")
# Copy to postgis
copy_to_postgis(data, engine, table='my_table1', schema='my_schema', if_exists='replace')
# Copy to postgis
copy_to_postgis(world, engine, table='my_table2', schema='my_schema', if_exists='replace')
                  
# Copy to postgis
copy_to_postgis(argentina, engine, table='my_table3', schema='my_schema', if_exists='replace')