[postgis-users] problem with shp2pgsql / psql import

[Stefan Zweig]

hi list,

i have a problem with converting some data from *.shp to *.sql and importing it into my postgis

i did the following:

shp2pgsql -s 4326 -d -w -I myshapefile.shp public._g2793 > _g2793.sql
psql -d mapdata -f _g2793.sql


but after i have run them both i get lots of null geometry in my column the_geom when selecting with
select id, name, astext(the_geom) from _g2793. if a view the shapefile with a shapefile viewer it looks alright.


i have attached an excerpt of the _g2793.sql which creates the table and imports one geometry row. maybe anybody can try importing this in his/her postgis and see whether postgis gives as well a null geometry after

select id, name, astext(the_geom) from _g2793


i have no idea what is wrong with the INSERT statement. is there something like a geometry/WKT-validator?


i appreciate any help,

thanks in advance, stefan
__________________________________________________________________________
Erweitern Sie FreeMail zu einem noch leistungsstärkeren E-Mail-Postfach!		
Mehr Infos unter http://produkte.web.de/club/?mc=021131

-------------- next part --------------
A non-text attachment was scrubbed...
Name: import.sql
Type: application/octet-stream
Size: 101434 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070731/e6f001b1/attachment.obj>