vinh nguyenquang,
Where did you get this data from? According to the .prj it is in 4326 (WGS 84
degree) like
others have mentioned, but if you actually look at the data, there is no
way it is in degrees since it has points like
484344.9842453949 1480036.13293874
So there is no way that is 4326. So Lê Vit Thanh is probably right that this
is 32648 because doing a quick spot check
SELECT ST_AsText(ST_Transform(ST_GeomFromText('POINT(484344.9842453949
1480036.13293874)',32648),4326))
Gives me "POINT(104.855408409113 13.3878890725056)" in WGS 84 degree (4326)
Which is somewhere in Cambodia which sounds about right.
Anyrate if this is a public source or a departmental one, I would complain to
the people that gave this data that their .prj file is wrong. People rely on
that file if its there and its very annoying to have that give misinformation.
That's worse than no information at all.
Thanks,
Regina
-----Original Message-----
From: [EMAIL PROTECTED] on behalf of Lê Vi?t Thanh
Sent: Tue 11/11/2008 9:29 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Problem in migrating shapefile to postgis
But there are some problems to this data, do not based on the information in
PRJ to say that SRID is 4326. This guy doesnt know any thing about
geographic/coordinate system (IMO). With my knowledge and location of this
data, the SRID must be 32648 or WGS 84 / UTM zone 48N.
On Tue, Nov 11, 2008 at 9:09 PM, Ervin Ramonllari <
[EMAIL PROTECTED]> wrote:
> Hi,
>
> You are trying to load some data to a PostGIS and your data are in lat/long
> (according to .prj file).
> This means that the SRID to be used is 4326 (the value for -s parameter).
>
> I don't know if you really need the other parameters (-i, -D), but if you
> don't need them, better don't use.
> First try with few parameters, like :
> shp2pgsql -s 4326 LopGiaoThong.shp LopGiaoThong > LopGiaoThong.sql
> psql -d postgis -h dbhost -U postgres -f LopGiaoThong.sql where
> dbhost is the host machine of your database.
>
> hope that helps!
>
> ------------------------------
> Date: Tue, 11 Nov 2008 20:14:18 +0800
> From: [EMAIL PROTECTED]
> 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!
>
>
>
>
> ------------------------------
> B?n có ý ki?n v? M? Tâm? Hãy cùng chia s? v?i m?i ngu?i t?i Yahoo! Vi?t
> Nam Music
> ------------------------------
> Connect to the next generation of MSN Messenger Get it now!
> <http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=wlmailtagline>
>
> _______________________________________________
> postgis-users mailing list
> [email protected]
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
--
Thanh Le Viet
GIS Specialist
Oxford University Clinical Research Unit
78 Giai Phong - Ha Noi
-----------------------------------------
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
