[postgis-users] Spaces in numeric fields output by shp2pgsql

[Paul Ramsey]

You’re going to want to create a ticket and attach the shape file in a zip. You’ve just got some extra funky data.
P

> On Feb 19, 2023, at 1:51 PM, Brian Panulla <bpanulla at gmail.com> wrote:
> 
> I'm trying to load some shapefiles to a PostgreSQL 12/PostGIS 3.1
> database server. The shapefiles in question have a point geometry
> field as well as the latitude and longitude as numeric values in the
> metadata. When I try to pipe the output of shp2pgsql to psql I get
> invalid input errors relating to the longitude and latitude metadata
> fields:
> 
> 16651: ERROR:  invalid input syntax for type numeric: "-117.830583 00000000"
> CONTEXT:  COPY _41001_point_temp, line 1, column longitude:
> "-117.830583 00000000"
> 
> Capturing the output from shp2pgsql, it seems that the longitude and
> latitude values have a space in the middle:
> 
> -117.830583 00000000
> 
> But shp2pgsql seems to see the field as a type FTDouble:
> 
> Field longitude is an FTDouble with width 31 and precision 15
> Field latitude is an FTDouble with width 31 and precision 15
> 
> When I view the shapefile metadata in QGis it doesn't have a space,
> but it does have an extra digit!
> 
> -117.830583000000004
> 
> I've tried both shp2pgsql 3.0 and 3.2 just to make sure it wasn't a
> bug in 3.0, but the output is the same.
> 
> Any idea what I'm looking at here?
> 
> -B
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users