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 <bpanu...@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@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users