<html><body bgcolor="#FFFFFF"><div>You will either need to add the layer name explicitly in the request URL, or set the layer status to DEFAULT.</div><div><br></div><div>David<br><br><div><br></div></div><div><br>On Aug 17, 2011, at 3:09 PM, Vishal Mehta <<a href="mailto:vishal.mehta@sei-us.org">vishal.mehta@sei-us.org</a>> wrote:<br><br></div><div></div><blockquote type="cite"><div><div class="WordSection1"><p class="MsoNormal">Hi all,<o:p></o:p></p><p class="MsoNormal"><o:p> </o:p></p><p class="MsoNormal">I am testing out mapserver-postgis and a simple test is returning an empty map. Here is my map file<o:p></o:p></p><p class="MsoNormal"><o:p> </o:p></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt">MAP<o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"> IMAGETYPE PNG<o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"> EXTENT 77.5 12.95 77.7 13.01<o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"> SIZE 550 450<o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"> IMAGECOLOR 255 255 255<o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"> SHAPEPATH "../data"<o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"> # Start of LAYER DEFINITIONS-------------------------------<o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"> LAYER <o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"> CONNECTIONTYPE POSTGIS<o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"> NAME "wards"<o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"> # Connect to a remote spatial database<o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"> CONNECTION "host=localhost port=5432 dbname=empty user=postgres password=xxx"<o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"> # Get the lines from the 'geom' column of the 'wards' table <o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"> DATA 'geom from "myschema.wards198" using srid=4326 using unique gid'<o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"> STATUS ON<o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"> TYPE POLYGON <o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"><o:p> </o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"> CLASS<o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"> NAME "wards" <o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"> STYLE<o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"> OUTLINECOLOR 255 0 0<o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"> END<o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"> END<o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"> END <o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"> <o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"> # End of LAYER DEFINITIONS -------------------------------<o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt">END<o:p></o:p></span></p><p class="MsoNormal"><span style="font-size:10.0pt">-------------------<o:p></o:p></span></p><p class="MsoNormal">And the html that calls it<o:p></o:p></p><p class="MsoNormal">--------------<o:p></o:p></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"><html><o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"><head><o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"> <title>my postgis map</title><o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"></head><o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"><body bgcolor=white><o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"><center><o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"><br><o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"><table width=570><o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"><tr><o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"> <td><o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"> <br><o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"> <img width=550 height=450<o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"> src=/cgi-bin/mapserv.exe?map=C:\OSGeo4W/apps/mapserver-tutorial/mytests/example.map&mode=map<o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"> border=1><o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"> </td><o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"></tr><o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"></table><o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"><br><o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"></body><o:p></o:p></span></p><p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt"></html><o:p></o:p></span></p><p class="MsoNormal">----------------------------------------------------<o:p></o:p></p><p class="MsoNormal">Other info:<o:p></o:p></p><p class="MsoNormal">Platform: <o:p></o:p></p><p class="MsoListParagraph" style="text-indent:-.25in;mso-list:l0 level1 lfo1"><span style="mso-list:Ignore">-<span style="font:7.0pt "Times New Roman""> </span></span>Windows 7, postgresql9 , postgis 2.0 <o:p></o:p></p><p class="MsoListParagraph" style="text-indent:-.25in;mso-list:l0 level1 lfo1"><span style="mso-list:Ignore">-<span style="font:7.0pt "Times New Roman""> </span></span>I installed Mapserver separately through the OSGEO4 installer. <o:p></o:p></p><p class="MsoListParagraph" style="text-indent:-.25in;mso-list:l0 level1 lfo1"><span style="mso-list:Ignore">-<span style="font:7.0pt "Times New Roman""> </span></span>I can connect to the same database through php<o:p></o:p></p><p class="MsoListParagraph" style="text-indent:-.25in;mso-list:l0 level1 lfo1"><span style="mso-list:Ignore">-<span style="font:7.0pt "Times New Roman""> </span></span>I can create simple mapserver apps using shapefiles etc alright (e.g. same map file above, calling a shapefile, works fine)<o:p></o:p></p><p class="MsoListParagraph" style="text-indent:-.25in;mso-list:l0 level1 lfo1"><span style="mso-list:Ignore">-<span style="font:7.0pt "Times New Roman""> </span></span>Mapserv.exe –v shows that it was installed with postgis support. <o:p></o:p></p><p class="MsoListParagraph" style="text-indent:-.25in;mso-list:l0 level1 lfo1"><span style="mso-list:Ignore">-<span style="font:7.0pt "Times New Roman""> </span></span>Also can Mapserver handle postgis Mulipolygon geometry ok?<o:p></o:p></p><p class="MsoNormal"><o:p> </o:p></p><p class="MsoNormal">I did check most of the points here which seemed ok ( i did not check those in this list that I don’t really know how to in Windows ).<o:p></o:p></p><p class="MsoNormal"><a href="http://trac.osgeo.org/mapserver/wiki/PostGIS"><a href="http://trac.osgeo.org/mapserver/wiki/PostGIS">http://trac.osgeo.org/mapserver/wiki/PostGIS</a></a><o:p></o:p></p><p class="MsoNormal"><o:p> </o:p></p><p class="MsoNormal">I realize this might be a mapserver mailing list qn, but thought that some of you might know the answer…it might be a simple syntax problem that I’ve missed…<o:p></o:p></p><p class="MsoNormal"><o:p> </o:p></p><p class="MsoNormal">Thanks,<o:p></o:p></p><p class="MsoNormal">Vishal<o:p></o:p></p><p class="MsoNormal"><i><o:p> </o:p></i></p><p class="MsoNormal"><o:p> </o:p></p><p class="MsoNormal"><o:p> </o:p></p></div></div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span>postgis-users mailing list</span><br><span><a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a></span><br><span><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a></span><br></div></blockquote></body></html>