1

I have written a script long time ago which worked with no problem, using GeoPandas in order to read shapefile to my jupyter notebook. Today I have run my script and when I import geopandas I get new warning:

import geopandas as gpd

PROJ: proj_create_from_database: SQLite error on SELECT name, type, coordinate_system_auth_name, coordinate_system_code, datum_auth_name, datum_code, area_of_use_auth_name, area_of_use_code, text_definition, deprecated FROM geodetic_crs WHERE auth_name = ? AND code = ?: no such column: area_of_use_auth_name

seems like the library is being imported, yet I cannot read shapefiles.
This is how I tried to read shapefile:

shapes = gpd.read_file('shapefiles/polygons.shp')  

CRSError: Invalid projection: epsg:4326: (Internal Proj Error: proj_create: SQLite error on SELECT name, type, coordinate_system_auth_name, coordinate_system_code, datum_auth_name, datum_code, area_of_use_auth_name, area_of_use_code, text_definition, deprecated FROM geodetic_crs WHERE auth_name = ? AND code = ?: no such column: area_of_use_auth_name)

I have not changed my script and it worked for long time, so I believe something has changed with the package. I also used to read this specific shapefile, so nothing has changed in the shapefile itself.

Has anyone faced the same issue? is something now different with GeoPandas?how can I read the shapefile?

Edit:
geopandas version : 0.9.0

7
  • What is the Geopandas version ?
    – gene
    May 19, 2021 at 10:08
  • It would be helpful to describe your environment. Is this using pip packages? Conda? Other?
    – Mike T
    May 19, 2021 at 10:09
  • @gene I have edited the original post
    – Reut
    May 19, 2021 at 10:12
  • @MikeT I have added the version i'm using in the original post , but i'm not sure how to answer the other questions, I have install packages with pip3 ,and i'm working on jupyterlab server
    – Reut
    May 19, 2021 at 10:12
  • PyProj version issue e.g github.com/geopandas/geopandas/issues/990
    – ThomasG77
    May 19, 2021 at 10:14

1 Answer 1

3

Just updating if happenns to someone: In the end what worked for me was to uninstall and install again geopandas and pyproj

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.