[postgis-users] Problem in migrating shapefile to postgis

[Burgholzer,Robert]

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

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 Burgholzer,Robert
Sent: Wednesday, November 12, 2008 12:53 PM
To: nguyenquangvinh20052005 at yahoo.com; 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

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 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> 

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