[postgis-users] Problem in migrating shapefile to postgis

[Obe, Regina]

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: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of vinh nguyenquang
Sent: Wednesday, November 12, 2008 12:36 PM
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!


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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081114/3f2e481a/attachment.html>