[postgis-users] Problem in migrating shapefile to postgis

[Burgholzer,Robert]

You rule Regina.

 

Robert W. Burgholzer

Surface Water Modeler

Office of Water Supply and Planning

Virginia Department of Environmental Quality

rwburgholzer at deq.virginia.gov

804-698-4405

Open Source Modeling Tools:

http://sourceforge.net/projects/npsource/

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Obe, Regina
Sent: Friday, November 14, 2008 10:21 AM
To: PostGIS Users Discussion; nguyenquangvinh20052005 at yahoo.com
Subject: RE: [postgis-users] Problem in migrating shapefile to postgis

 

 

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. 

  _____  

Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper. 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081114/4787270c/attachment.html>