[postgis-users] Problem in migrating shapefile to postgis

[Obe, Regina]

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: postgis-users-bounces at postgis.refractions.net 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 <
ervin.ramonllari at hotmail.com> 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: nguyenquangvinh20052005 at yahoo.com
> 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!
>
>
>
>
> ------------------------------
> 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
> postgis-users at postgis.refractions.net
> 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081111/526042a1/attachment.html>