I have this geopandas geodataframe which I want to write in the postgis/postgreSQL database.
I have followed the steps as shown here by the geopandas docs https://geopandas.readthedocs.io/en/latest/docs/reference/api/geopandas.GeoDataFrame.to_postgis.html
I have the required library installed viz: SQLAlchemy, GeoAlchemy2, and psycopg2 (PostgreSQL Python driver)
But I am getting this error:
AttributeError: 'GeoDataFrame' object has no attribute 'to_postgis'
If somebody knows then, Please tell, how to rectify this.
Or what are the other methods to write/export the spatial data/geopandas data/ ESRI shapefile data to postgreSQL database?
The geodataframe was already written above this codeblock which I want to write in postgreSQL.
The code is as follows:
from sqlalchemy import create_engine from geoalchemy2 import Geometry, WKTElement import pandas as pd import psycopg2 import geopandas as gpd engine = create_engine('postgresql://postgres:imd123#@localhost:5432/abhilash') shapefile_gdf_final.to_postgis(con=engine, name="table_name")