You should still be able to load this data into postgis, it will default to SRID -1 if you do not include the –s switch.
Once inside postgis, you can then gain at least some information about the data by querying the extent(the_geom) of the table. That will tell you if it is in some sort of lat/lon projection (coords between -180 and +180), or if it is some sort of metric system (very large numbers). If it is in a lat/lon system, then you should be able to get it to work approximately, with some lat/lon projection that works in your area. HTH, r.b. 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 Burgholzer,Robert Sent: Wednesday, November 12, 2008 12:53 PM To: [EMAIL PROTECTED]; PostGIS Users Discussion Subject: RE: [postgis-users] Problem in migrating shapefile to postgis First place to start to find the proper SRID is look for a metadata file for your shape. If you have that, you may post on the list, perhaps someone can help. r.b. 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 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>
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
