[postgis-users] pgsql2shp warning "empty table or unknown spatial ref"

[Sandro Santilli]

On Mon, Feb 10, 2020 at 06:01:40PM -0500, Diego Vargas wrote:
> Hello, I am using pgsql2shp and shp2pgsql to dump and load a table with gis data, and I’m getting the following message:
> 
> "WARNING: Cannot determine spatial reference (empty table or unknown spatial ref). No prj file will be generated."
> 
> Now, there is no problem at the load since it seems that the the whole table is loaded without issue.
> Yet, I wonder if should I concern about the warning or not at all… 
> 

It means pgsql2shp could not determine the SRID of your geometries.
Do they have a SRID defined ? See https://postgis.net/docs/ST_SRID.html

--strk;