<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PlaceType"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceName"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>It looks like you have the command syntax
wrong. What is the ‘26911’ part of the command? I’ve used
the loader quite a bit and here’s how it has worked for me<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Shp2pgsql input_shapefile.shp
database.schema > output.sql<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I’ve been using the following link
as a guide…<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><a
href="http://postgis.refractions.net/docs/ch04.html#id2899793">http://postgis.refractions.net/docs/ch04.html#id2899793</a><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I hope this helps.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>EH<o:p></o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <b><span
style='font-weight:bold'>On Behalf Of </span></b>henok tadesse<br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, December 28, 2005
8:37 AM<br>
<b><span style='font-weight:bold'>To:</span></b> PostGIS Users Discussion<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [postgis-users]
problem with shp2pgsql</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div id=RTEContent>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Thanks for the hint... but i now have corrected the path problems but i
continue to have problems. i am actually working in linux and the
shapefile is in the same folder as the shp2pgsql. <br>
<br>
./shp2pgsql -s 26911 <st1:place w:st="on"><st1:PlaceName
w:st="on">River.shp</st1:PlaceName> <st1:PlaceType w:st="on">River</st1:PlaceType></st1:place>
> River.sql<br>
<br>
or i have also tried this one...<br>
<br>
/shp2pgsql -s 26911 <st1:place w:st="on"><st1:PlaceName
w:st="on">River.shp</st1:PlaceName> <st1:PlaceType w:st="on">River</st1:PlaceType></st1:place>
| psql myRiverdb.sql<br>
<br>
I am using the shapefile and tutorial from carto.net just to first test
if it works but in<br>
both cases, it returns River.shp: shape (.shp) or index files (.shx) can not be
opened.<br>
<br>
I really do understand this. why it cannot be opened? <br>
<br>
with thanks in advance,<br>
<br>
<br>
<b><i><span style='font-weight:bold;font-style:italic'>Barend Köbben
<kobben@itc.nl></span></i></b> wrote:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>What they mean is: If the sha pefile is in the "loader
directory" (ie the directory the shp2pgsql executable is in) you only need
to specify the shapefiles name, otherwise make sure you state the full path:<br>
<br>
eg. for windows: <br>
shp2pgsql.exe C:\mydirectory\asubdirectory\myshapefile.shp mytable myDB<br>
<br>
____________________________ <br>
Barend Köbben <br>
International Institute for Geo-information Sciences and Earth Observation
(ITC) <br>
PO Box 6, 7500AA Enschede (The Netherlands) <br>
ph: +31-(0)534874253; fax: +31-(0)534874335 <br>
_____________________________ <br>
<br>
________________________________<br>
<br>
From: postgis-users-bounces@postgis.refractions.net on behalf of henok tadesse<br>
Sent: Tue 27.12.2005 20:15<br>
To: postgis-users@postgis.refractions.net<br>
Subject: [postgis-users] problem with shp2pgsql<br>
<br>
<br>
hello,<br>
<br>
I was trying to load a shape file into my postgis database. Some body in this
forum once said the shapefile should be put in the loader directory. But i
could not really find out where the loader directory is although i used this
command to load the dumper!<br>
<br>
<br>
<br>
# cd postgis-1.1.0/loader <br>
# make<br>
# make install<br>
<br>
Should the shape file necessarily be in the loader dirctory to be used in
shp2pgsql? if yes, where can i find it?<br>
<br>
thanks in advance,<br>
<br>
henok<br>
<br>
<br>
________________________________<br>
<br>
Yahoo! Photos <http:>- NEW, now offering a quality print service <http:>from
just 8p a photo.<br>
_______________________________________________<br>
postgis-users mailing list<br>
postgis-users@postgis.refractions.net<br>
http://postgis.refractions.net/mailman/listinfo/postgis-users<br>
<br>
<o:p></o:p></span></font></p>
</http:></http:>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=1 width="100%" align=center>
</span></font></div>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>To help you stay safe and secure online, we've developed the
all new <a
href="http://us.rd.yahoo.com/mail/uk/taglines/default/security_centre/*http:/uk.security.yahoo.com/"><b><span
style='font-weight:bold'>Yahoo! Security Centre</span></b></a>.</span></font><o:p></o:p></p>
</div>
</body>
</html>