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

[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 data
have a spatial reference defined?  What is it?

[1] https://en.wikipedia.org/wiki/Shapefile#Data_storage
[2]
https://postgis.net/docs/manual-3.0/using_postgis_dbmanagement.html#shp2pgsql_usage

On Mon, Feb 10, 2020 at 3:02 PM Diego Vargas <diegov at karbondb.com> 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…
>
> Also, the column name gets truncated/renamed, is there a way to avoid
> that?
>
> Thanks in advance,
> Diego
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200210/6ce23bb2/attachment.html>