query postgis through wms

[Steven De Vriendt]

Jorn,

I have the following columns:

gid
capakey
percid
capaty
shape_area
the_geom

Thanks for helping out !

Steven

On Nov 19, 2007 2:21 PM, Jørn Vegard Røsnes <jorn at spacetec.no> wrote:

> Hi,
>
> do you have a column named oid with integer type in your table?
>
> cheers
> Jørn Vegard
>
> On Monday 19 November 2007 09:48, Steven De Vriendt wrote:
> > Hi folks,
> >
> > I'm trying to query a postgis-layer through wms. Yet, I do not get any
> > query results.
> > Can anyone have a look at my mapfile. I have tried to label my features
> > too, using
> > a field of the postgis-table, but that doesn't seem to work too. So, my
> > guess it should
> > be something wrong in my map-file. Thanks for helping out !
> >
> > #
> > # Start of map file
> > #
> > # Sample map file for a chameleon app.
> > #
> > NAME DEMO
> > STATUS ON
> > SIZE 600 500
> > SYMBOLSET symbols.sym
> > EXTENT 77336.359625 189988.500250 90937.297125 201812.968625
> > UNITS METERS
> > SHAPEPATH "../data"
> > IMAGECOLOR 255 255 255
> > FONTSET fonts.txt
> > TRANSPARENT FALSE
> >
> >
> > WEB
> >   IMAGEPATH "etc/mapserver/tmp/ms_tmp"
> >   IMAGEURL "/tmp/"
> >
> >  METADATA
> >   "wms_title" "Aalter_WMS"
> >   "wms_onlineresource" "
> >   "wms_srs" "EPSG:31300"
> >
> >  END
> > END
> >
> >
> > OUTPUTFORMAT
> > NAME png
> > DRIVER "GD/PNG"
> > MIMETYPE "image/png"
> > IMAGEMODE PC256
> > EXTENSION "png"
> > END
> >
> >
> > SCALEBAR
> >   IMAGECOLOR 255 255 255
> >   LABEL
> >     COLOR 0 0 0
> >     SIZE SMALL
> >   END
> >   SIZE 150 5
> >   COLOR 255 255 255
> >   BACKGROUNDCOLOR 0 0 0
> >   OUTLINECOLOR 0 0 0
> >   UNITS meters
> >   INTERVALS 5
> >   STATUS ON
> > END
> >
> > QUERYMAP
> >   STATUS ON
> >   SIZE 200 200
> >   STYLE HILITE
> >   COLOR 255 0 0
> > END
> >
> > PROJECTION
> >     "init=epsg:31300"
> > END
> >
> > LAYER
> >    NAME "Grens"
> >    METADATA
> >      "wms_title" "gemeentegrens"
> >      "gml_include_items" "all"
> >    END
> >    CONNECTIONTYPE postgis
> >    CONNECTION "host=""
> >    DATA "the_geom from alr_gemline"
> >    DUMP TRUE
> >    TEMPLATE "ttt"
> >
> >    TYPE LINE
> >     CLASS
> >     NAME "KadScan"
> >     OUTLINECOLOR 208 208 208
> >   END
> >     PROJECTION
> >     "init=epsg:31300"
> >     END
> > END
> >
> >    LAYER
> >    NAME "Percelen"
> >
> >    CONNECTIONTYPE postgis
> >    CONNECTION "host="" <http://192.168.102.100/>
> >    DATA "the_geom from b_capa_percid"
> >    TEMPLATE "ttt"
> >    LABELITEM 'capakey'
> >   TYPE POLYGON
> >     CLASS
> >     NAME "KadScan"
> >
> >     OUTLINECOLOR 208 208 208
> >   END
> >     METADATA
> >      "wms_title" "percelen"
> >      "gml_include_items" "all"
> >    END
> >
> >     PROJECTION
> >     "init=epsg:31300"
> >
> >    END
> > END
> >
> >
> > END # Map File
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20071119/953dee23/attachment.html