[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    [postgis-users] problem with shp2pgsql / psql import
From:       Stefan Zweig <stefanzweig1881 () web ! de>
Date:       2007-07-31 9:58:32
Message-ID: 159720672 () web ! de
[Download RAW message or body]

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


["import.sql" (application/octet-stream)]

_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


[prev in list] [next in list] [prev in thread] [next in thread]