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

2020-02-11 Thread 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

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

2020-02-10 Thread Martin Davis
The column names are truncated because the DBF format used by Shapefiles has a limit of 10 characters for field names [1]. With shp2pgsql there is an option to provide a mapping file to map to longer names for table columns. [2] You should say which utility generates the warning. Does the PostGIS

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

2020-02-10 Thread Diego Vargas
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 th