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
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
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