I think I may have figured out the problem. I tried the file. It doesn't load
into a UTF-8 encoded database. You need to use the -W switch if you have a
UTF-8 encoded database.
Try
shp2pgsql -g the_geom -s 32648 -I -W "latin1" LopGiaoThong LopGiaoThong | psql
-U postgres -d postgis
Hope that helps,
Regina
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of vinh nguyenquang
Sent: Wednesday, November 12, 2008 12:36 PM
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!
Re: I still can not load LopGiaoThong.shp to postgis. Even though, I tried with
-s parameter: 32648, 4326, 3405. I really can not find the correct SRID's value
of my data. I really appreciated if anyone can help me do it.
Thanks!
________________________________
Nước nào thường cho nhiều học bổng du học? Khám phá tại Yahoo! Hỏi & Đáp
<http://sg.rd.yahoo.com/mail/vn/footer/def/*http:/vn.answers.yahoo.com>
________________________________
The substance of this message, including any attachments, may be confidential,
legally privileged and/or exempt from disclosure pursuant to Massachusetts law.
It is intended solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
________________________________
Help make the earth a greener place. If at all possible resist printing this
email and join us in saving paper.
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer._______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
