Vishal, David has probably nailed this one, but if not or otherwise you might also want to put DEBUG ON into your map and the LAYER definitions (you need both) - the debug output from postgis connections is comprehensive if a little complex initially, but very useful for learning.
It doesn't hurt to explicitly set projections as well, to make sure they match. cheers Ben On 18/08/2011, at 4:09 AM, Vishal Mehta wrote: > Hi all, > > I am testing out mapserver-postgis and a simple test is returning an empty > map. Here is my map file > > MAP > IMAGETYPE PNG > EXTENT 77.5 12.95 77.7 13.01 > SIZE 550 450 > IMAGECOLOR 255 255 255 > SHAPEPATH "../data" > # Start of LAYER DEFINITIONS------------------------------- > LAYER > CONNECTIONTYPE POSTGIS > NAME "wards" > # Connect to a remote spatial database > CONNECTION "host=localhost port=5432 dbname=empty > user=postgres password=xxx" > # Get the lines from the 'geom' column of the 'wards' table > DATA 'geom from "myschema.wards198" using srid=4326 using > unique gid' > STATUS ON > TYPE POLYGON > > CLASS > NAME "wards" > STYLE > OUTLINECOLOR 255 0 0 > END > END > END > > # End of LAYER DEFINITIONS ------------------------------- > END > ------------------- > And the html that calls it > -------------- > <html> > <head> > <title>my postgis map</title> > </head> > <body bgcolor=white> > <center> > <br> > <table width=570> > <tr> > <td> > <br> > <img width=550 height=450 > > src=/cgi-bin/mapserv.exe?map=C:\OSGeo4W/apps/mapserver-tutorial/mytests/example.map&mode=map > border=1> > </td> > </tr> > </table> > <br> > </body> > </html> > ---------------------------------------------------- > Other info: > Platform: > - Windows 7, postgresql9 , postgis 2.0 > - I installed Mapserver separately through the OSGEO4 installer. > - I can connect to the same database through php > - I can create simple mapserver apps using shapefiles etc alright > (e.g. same map file above, calling a shapefile, works fine) > - Mapserv.exe –v shows that it was installed with postgis support. > - Also can Mapserver handle postgis Mulipolygon geometry ok? > > 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 ). > http://trac.osgeo.org/mapserver/wiki/PostGIS > > 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… > > Thanks, > Vishal > > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
