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 <span class="Apple-style-span" style="font-family: -webkit-sans-serif; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px; ">WGS 84 / UTM zone 48N.</span><br>
<br><div class="gmail_quote">On Tue, Nov 11, 2008 at 9:09 PM, Ervin Ramonllari <span dir="ltr"><<a href="mailto:ervin.ramonllari@hotmail.com">ervin.ramonllari@hotmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div>
Hi,<br><br>You are trying to load some data to a PostGIS and your data are in lat/long (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 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 dbhost is the host machine of your database.<br>
<br>hope that helps!<br><br><hr>Date: Tue, 11 Nov 2008 20:14:18 +0800<br>From: <a href="mailto:nguyenquangvinh20052005@yahoo.com" target="_blank">nguyenquangvinh20052005@yahoo.com</a><br>To: <a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>
Subject: [postgis-users] Problem in migrating shapefile to postgis<div><div></div><div class="Wj3C7c"><br><br><table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td style="font-family:inherit;font-style:inherit;font-variant:inherit;font-weight:inherit;font-size:inherit;line-height:inherit;font-size-adjust:inherit;font-stretch:inherit" valign="top">
Hi, everyone<br>Can you help me load LopGiaoThong.shp vao trong postgis? I have problem with SRID or something else i don't know.<br>I do it in this way: shp2pgsql -i -D -s LopGiaoThong.shp LopGiaoThong > 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 how to load my data to postgis?<br>
Thank you very much!<br> <br><br><br></td></tr></tbody></table><br>
<hr size="1"> Bạn có ý kiến về Mỹ Tâm?<a> Hãy cùng chia sẻ với mọi người tại Yahoo! Việt Nam Music </a><br></div></div><div class="WgoR0d"><hr>Connect to the next generation of MSN Messenger <a href="http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=wlmailtagline" target="_blank">Get it now! </a></div>
</div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Thanh Le Viet<br>GIS Specialist<br>Oxford University Clinical Research Unit<br>78 Giai Phong - Ha Noi<br>