You rule Regina.
Robert W. Burgholzer Surface Water Modeler Office of Water Supply and Planning Virginia Department of Environmental Quality [EMAIL PROTECTED] 804-698-4405 Open Source Modeling Tools: http://sourceforge.net/projects/npsource/ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Obe, Regina Sent: Friday, November 14, 2008 10:21 AM To: PostGIS Users Discussion; [EMAIL PROTECTED] 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: [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. _____ Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper.
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
