[postgis-users] Problem in migrating shapefile to postgis

[Ervin Ramonllari]

Hi,

You are trying to load some data to a PostGIS and your data are in lat/long (according to .prj file).
This means that the SRID to be used is 4326 (the value for -s parameter).

I don't know if you really need the other parameters (-i, -D), but if you don't need them, better don't use.
First try with few parameters, like :
shp2pgsql -s 4326 LopGiaoThong.shp LopGiaoThong > LopGiaoThong.sql
psql -d postgis -h dbhost -U postgres -f LopGiaoThong.sql        where dbhost is the host machine of your database.

hope that helps!

Date: Tue, 11 Nov 2008 20:14:18 +0800
From: nguyenquangvinh20052005 at yahoo.com
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Problem in migrating shapefile to postgis

Hi, everyone
Can you help me load LopGiaoThong.shp vao trong postgis? I have problem with SRID or something else i don't know.
I do it in this way: shp2pgsql -i -D -s LopGiaoThong.shp LopGiaoThong > LopGiaoThong.sql
                           psql -d postgis -U postgres -f LopGiaoThong.sql
I do not know the parameter -s: what value it is to load LopGiaoThong.shp
Can you show mw how to find the value of -s parameter (SRID) of my data or how to load my data to postgis?
Thank you very much!
 




       Bạn có ý kiến về Mỹ Tâm? Hãy cùng chia sẻ với mọi người tại Yahoo! Việt Nam Music 
_________________________________________________________________
Connect to the next generation of MSN Messenger 
http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=wlmailtagline
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081111/9c87190e/attachment.html>