A couple of newbie questions (SUMMARY)

[Erich Schroeder]

Many thanks to Ken and Jason. My mapfile snippets for the two questions I
had look like:
LAYER
   NAME survey
   TYPE POLYGON
   STATUS DEFAULT
   DATA iasplot/sangamon/survey
   CLASS
     NAME  "Survey Areas"
     EXPRESSION ([SURVEY_ID] > 0)
     SYMBOL 1
     COLOR 32 201 32
     OUTLINECOLOR 0 0 0
   END
END #survey layer

and
LAYER
   NAME site
   TYPE POLYGON
   STATUS DEFAULT
   DATA iasplot/sangamon/cty
   CLASS
     SYMBOL 0
     COLOR 255 30 2
      OUTLINECOLOR 0 0 0
   END
   QUERYITEM "INDEX"
   QUERY
     EXPRESSION ([INDEX] > 0)
     template site_detail.html
     JOIN
       table "iasplot/sangamon/iasdata.dbf"
       from "INDEX"
       to "INDEX"
     END # join
   END # query  
END

Works like a dream.

Erich

---------------------------------------------------------------------
Erich Schroeder                    Phone: (217)785-0033
Curator, Information Technologies  FAX:   (217)785-2857
Illinois State Museum GIS Lab      Internet: erich at museum.state.il.us
http://www.museum.state.il.us/ismdepts/anthro/staff/erich/erich.html
---------------------------------------------------------------------

---------- Forwarded message ----------
Date: Thu, 17 Feb 2000 11:51:46 +0000 (/etc/localtime)
From: Erich Schroeder <erich at museum.state.il.us>
To: mapserver-users at lists.gis.umn.edu
Subject: A couple of newbie questions

Hi,
  Last weekend I finally got my own Mapserver application to work, at
least to allow zooming and panning. I'm confused on quering and other
things, still.

First:
One of my layers (areas where archaeological surveys have been done) has
internal polygons which are actually unsurveyed. Within the dbf file the
value of SURVEY_ID for these is 0, all "real" polygons have a numeric code
relating to a document number describing the survey.

Could someone show me a mapfile snippet that will only display polygons
with SURVEY_ID > 0?

One of the other layers is the locations of reported archaeological sites,
digitized as polygons. My users will want to be able to click on a site
and get the information associated. The information is in a separate dbf
file that can be linked to the coverage by a index number. 

What is the combination of mapfile information and html code that will
make it possible for a user to click on a polygon, and get a listing of
the associated record?

I hope these are simple...

Erich

---------------------------------------------------------------------
Erich Schroeder                    Phone: (217)785-0033
Curator, Information Technologies  FAX:   (217)785-2857
Illinois State Museum GIS Lab      Internet: erich at museum.state.il.us
http://www.museum.state.il.us/ismdepts/anthro/staff/erich/erich.html
---------------------------------------------------------------------