<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; "><DIV>Keith,</DIV><DIV><BR class="khtml-block-placeholder"></DIV>We have done this using either of two methods below, where using postgis was not an option.<DIV><BR class="khtml-block-placeholder"></DIV><DIV>to use MapServer directly, the quickest way is to generate the mapfile to match the desired relationships. dynamically create a mapfile (ie in php) to match the query (this is easiest if you load the beginning and end of your standard mapfile, and just add the appropriate layer / class details) and send the mapfile name back to Mapserv.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Alternatively use mapscript to generate either the map image, or a mapfile, and use this. Where there is a larger number of attributes required over a larger area, regenerate the maps during the zoom to show the increasing levels of detail. This is why we are using mapscript now.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>The main limitation to watch out for is when there are more than the allowable number of layers or classes, but any map that is trying to display more than this number of attributes is unlikely to mean much to a reader, so think carefully about this as you develop your initial queries.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>good luck</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Ben</DIV><DIV><BR><DIV> <SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><DIV>-- </DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Ben Madin</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>t/f: 08 9192 5535</DIV><DIV>m: 0448 887 220</DIV><DIV><A href="mailto:ben@remoteinformation.com.au">ben@remoteinformation.com.au</A></DIV><BR class="Apple-interchange-newline"></SPAN> </DIV><BR></DIV></BODY></HTML>