[postgis-users] Shp2pgsql problem

Stefan Hahmann s.hahmann at mapchart.com
Wed Apr 18 01:16:23 PDT 2007


Hi,

I have the following problem while trying to import a shapefile into
postgis with shp2psql

I have run this command:


/usr/local/pgsql/bin/shp2pgsql -s 4326 -i -a -I -D -k theshapefile.shp
public._g24 > _g24.sql | /usr/local/pgsql/bin/psql -d mapdata -f
_g24.sql -s

And got this errormessage:

psql:_g24.sql:743: ERROR:  syntax error at or near "512760001147050" at
character 1
psql:_g24.sql:743: LINE 1: 512760001147050 4110 0 512760200017359 0
512760200947163 0 0...
psql:_g24.sql:743:         ^

After googling around and looking the postgis-users forum i could not
get a solution for that.

I would appreciate any help.

Thanks in advance.



More information about the postgis-users mailing list