I suspect Vinh's problem is not only with the SRID. PostGIS to my knowledge
doesn't do any validation of SRID when loading except to check its -1 or the
SRID is in the spatial_ref_sys (I don't think it even does that much where SRID
is concerned). Given that, there should never be a problem with loading the
data unless
the data has grossly invalid geometries (e.g. weird dimensions, not enough
points for a line, invalid geometry type, nonsense numbers like INFINITY)
or the shp2pgsql is not being used right
I have had cases like that where I have had to go in the .sql generated file
and remove clearly invalid geometries that were causing a transaction abort.
Vinh,
What errors are you getting exactly?
Does the .sql file get generated or does it not get that far?
if you can't even generate the .sql file, then you are using shp2pgsql
incorrectly or the executable can't be found.
If it generates the .sql file, but you get a transaction abort, then something
is wrong with some of the geometries in the file
or your database is not spatially enabled.
Make sure you can do
SELECT postgis_full_version()
on your database
Hope that helps,
Regina
________________________________
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Burgholzer,Robert
Sent: Friday, November 14, 2008 9:31 AM
To: PostGIS Users Discussion; [EMAIL PROTECTED]
Subject: RE: [postgis-users] Problem in migrating shapefile to postgis
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>
-----------------------------------------
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._______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
