<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
</style>
</head>
<body class='hmmessage'>
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 id="stopSpelling">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><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; -x-system-font: none;" 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 /><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='_new'>Get it now! </a></body>
</html>