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: [EMAIL PROTECTED]
To: [email protected]
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_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
