<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
<META content="MSHTML 6.00.6000.16735" name=GENERATOR>
<STYLE>@font-face {
font-family: Tahoma;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.emailstyle17 {
COLOR: navy; FONT-FAMILY: Arial
}
SPAN.EmailStyle18 {
COLOR: navy; FONT-FAMILY: Arial
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=blue link=blue>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff
size=2></FONT> </DIV>
<DIV class=Section1>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN
class=438031915-14112008><FONT face=Arial color=#0000ff size=2>I think I may
have figured out the problem. I tried the file. It doesn't load into
a UTF-8 encoded database. You need to use the -W switch if you have a
UTF-8 encoded database.</FONT></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN
class=438031915-14112008><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN
class=438031915-14112008><FONT face=Arial color=#0000ff
size=2>Try</FONT></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN
class=438031915-14112008><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN
class=438031915-14112008><FONT face=Arial color=#0000ff size=2>shp2pgsql -g
the_geom -s 32648 -I -W "latin1" LopGiaoThong LopGiaoThong | psql -U
postgres -d postgis</FONT></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN
class=438031915-14112008><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN
class=438031915-14112008><FONT face=Arial color=#0000ff size=2>Hope that
helps,</FONT></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN
class=438031915-14112008><FONT face=Arial color=#0000ff
size=2>Regina</FONT></SPAN></P></DIV>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original
Message-----<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B><SPAN
style="FONT-WEIGHT: bold">On Behalf Of </SPAN></B>vinh nguyenquang<BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Wednesday, November 12, 2008 12:36
PM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B>
postgis-users@postgis.refractions.net<BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> [postgis-users] Problem in
migrating shapefile to postgis</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<TABLE class=MsoNormalTable style="MARGIN-LEFT: 1in; WIDTH: 6in" cellSpacing=0
cellPadding=0 width=576 border=0>
<TBODY>
<TR>
<TD
style="PADDING-RIGHT: 0in; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; PADDING-TOP: 0in"
vAlign=top>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">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>Re: I still can not load
LopGiaoThong.shp to postgis. Even though, I tried with -s parameter:
32648, 4326, 3405. I really can not find the correct SRID's value of my
data. I really appreciated if anyone can help me do
it.<BR>Thanks!</SPAN></FONT></P></TD></TR></TBODY></TABLE>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<DIV style="MARGIN-LEFT: 0.5in">
<DIV class=MsoNormal style="MARGIN-LEFT: 0.5in; TEXT-ALIGN: center"
align=center><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">
<HR align=center width="100%" SIZE=1>
</SPAN></FONT></DIV></DIV>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Nước nào thường cho nhiều học bổng
du học? Khám phá tại <A
href="http://sg.rd.yahoo.com/mail/vn/footer/def/*http:/vn.answers.yahoo.com">Yahoo!
Hỏi & Đáp</A></SPAN></FONT></P></DIV>
<P>
<HR SIZE=1>
<P></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>
<P>
<HR SIZE=1>
<P></P>
<P><STRONG><FONT color=#339900 size=2>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></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>