[postgis-users] problem with shp2pgsql / psql import
stefanzweig1881 at web.de
Tue Jul 31 02:58:32 PDT 2007
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...
Size: 101434 bytes
Desc: not available
More information about the postgis-users