query postgis through wms

[Steven De Vriendt]

Jorn,

I have tried to add the following:

DATA "the_geom from b_capa_percid AS foo USING UNIQUE gid using SRD=31300"
but that turns other errors.

When I try to do your suggestions, the query takes forever to run...

Steven

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

> Hi,
>
> try to add the column to the tables
> alter table <table> add column oid integer;
>
>
>
> On Monday 19 November 2007 14:27, Steven De Vriendt wrote:
> > 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/f4d109a8/attachment.htm>