<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7653.38">
<TITLE>RE: [postgis-users] Problem in migrating shapefile to postgis</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>vinh nguyenquang,<BR>
<BR>
Where did you get this data from? According to the .prj it is in 4326 (WGS 84 degree) like<BR>
others have mentioned, but if you actually look at the data, there is no<BR>
way it is in degrees since it has points like<BR>
<BR>
484344.9842453949 1480036.13293874<BR>
<BR>
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<BR>
<BR>
SELECT ST_AsText(ST_Transform(ST_GeomFromText('POINT(484344.9842453949 1480036.13293874)',32648),4326))<BR>
<BR>
Gives me "POINT(104.855408409113 13.3878890725056)" in WGS 84 degree (4326)<BR>
<BR>
Which is somewhere in Cambodia which sounds about right.<BR>
<BR>
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.<BR>
<BR>
Thanks,<BR>
Regina<BR>
<BR>
<BR>
<BR>
-----Original Message-----<BR>
From: postgis-users-bounces@postgis.refractions.net on behalf of Lê Vi?t Thanh<BR>
Sent: Tue 11/11/2008 9:29 AM<BR>
To: PostGIS Users Discussion<BR>
Subject: Re: [postgis-users] Problem in migrating shapefile to postgis<BR>
<BR>
But there are some problems to this data, do not based on the information in<BR>
PRJ to say that SRID is 4326. This guy doesnt know any thing about<BR>
geographic/coordinate system (IMO). With my knowledge and location of this<BR>
data, the SRID must be 32648 or WGS 84 / UTM zone 48N.<BR>
<BR>
On Tue, Nov 11, 2008 at 9:09 PM, Ervin Ramonllari <<BR>
ervin.ramonllari@hotmail.com> wrote:<BR>
<BR>
> Hi,<BR>
><BR>
> You are trying to load some data to a PostGIS and your data are in lat/long<BR>
> (according to .prj file).<BR>
> This means that the SRID to be used is 4326 (the value for -s parameter).<BR>
><BR>
> I don't know if you really need the other parameters (-i, -D), but if you<BR>
> don't need them, better don't use.<BR>
> First try with few parameters, like :<BR>
> shp2pgsql -s 4326 LopGiaoThong.shp LopGiaoThong > LopGiaoThong.sql<BR>
> psql -d postgis -h dbhost -U postgres -f LopGiaoThong.sql where<BR>
> dbhost is the host machine of your database.<BR>
><BR>
> hope that helps!<BR>
><BR>
> ------------------------------<BR>
> Date: Tue, 11 Nov 2008 20:14:18 +0800<BR>
> From: nguyenquangvinh20052005@yahoo.com<BR>
> To: postgis-users@postgis.refractions.net<BR>
> Subject: [postgis-users] Problem in migrating shapefile to postgis<BR>
><BR>
><BR>
> Hi, everyone<BR>
> Can you help me load LopGiaoThong.shp vao trong postgis? I have problem<BR>
> with SRID or something else i don't know.<BR>
> I do it in this way: shp2pgsql -i -D -s LopGiaoThong.shp LopGiaoThong ><BR>
> LopGiaoThong.sql<BR>
> psql -d postgis -U postgres -f LopGiaoThong.sql<BR>
> I do not know the parameter -s: what value it is to load LopGiaoThong.shp<BR>
> Can you show mw how to find the value of -s parameter (SRID) of my data or<BR>
> how to load my data to postgis?<BR>
> Thank you very much!<BR>
><BR>
><BR>
><BR>
><BR>
> ------------------------------<BR>
> 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<BR>
> Nam Music<BR>
> ------------------------------<BR>
> Connect to the next generation of MSN Messenger Get it now!<BR>
> <<A HREF="http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=wlmailtagline">http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=wlmailtagline</A>><BR>
><BR>
> _______________________________________________<BR>
> postgis-users mailing list<BR>
> postgis-users@postgis.refractions.net<BR>
> <A HREF="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR>
><BR>
><BR>
<BR>
<BR>
--<BR>
Thanh Le Viet<BR>
GIS Specialist<BR>
Oxford University Clinical Research Unit<BR>
78 Giai Phong - Ha Noi<BR>
<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
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.
</STRONG></P></BODY></HTML>
<P><hr size=1></P>
<P><STRONG><font size="2" color="339900"> Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper. </p> <p> </font></STRONG></P>