<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:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>I’ve been using MapServer with shapefiles for some time. I’m trying to convert a site to PostGIS, and I’m having problems.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I’ve successfully installed PostGIS on my Ubunto 10.04 box, and copied a number of shapefiles into it, using shp2pgsql. I can view the new tables using qGIS, so I’m sure the data is right.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>So now I’ve copies a mapfile that was working against the original shapefiles, and I’m trying to convert it to use PostGIS. I’m working on just one layer, and I’m trying to test that layer with shp2img.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I’ve added to the LAYER definition:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='text-indent:.5in'>LAYER<o:p></o:p></p><p class=MsoNormal> NAME “countyboundaries”<o:p></o:p></p><p class=MsoNormal> CONNECTIONTYPE postgis<o:p></o:p></p><p class=MsoNormal> CONNECTION “host=localhost dbname=test_db user=gis password=xxxxx”<o:p></o:p></p><p class=MsoNormal> DATA “the_geom from gis_schema.county”<o:p></o:p></p><p class=MsoNormal> […]<o:p></o:p></p><p class=MsoNormal> END<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>As I said, I know the data is in the database, because I can load it as a PostGIS layer from qGIS. Column and table names are right, because when I run “select the_geom from gis_schema.county” in the query tool I get the data.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>But when I run shp2img from the commandline, I get an error:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='text-indent:.5in'>$ shp2img -m test.map -o test.gif -i GIF -l countyboundaries<o:p></o:p></p><p class=MsoNormal style='text-indent:.5in'>msDrawMap(): Image handling error. Failed to draw layer named ‘countyboundaries’.<o:p></o:p></p><p class=MsoNormal style='text-indent:.5in'>msPostGISParseData(): Query error. Error parsing PostGIS DATA variable. Must contain ‘geometry <o:p></o:p></p><p class=MsoNormal style='margin-left:.5in;text-indent:.5in'>from table’ or ‘geometry from (subselect) as foo’. County<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>shp2img is MapServer version 5.6.6, and the output from -v does contain “INPUT=POSTGIS”.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Any ideas? I’m trying to keep things simple, and it’s frustrating when simple doesn’t work.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>