<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2873" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=961455416-30052006><FONT face=Arial color=#0000ff size=2>Sarah,
</FONT></SPAN></DIV>
<DIV><SPAN class=961455416-30052006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=961455416-30052006><FONT face=Arial color=#0000ff size=2>You
can accomplish the 'clickable-ness' in one of two ways. You can do a point
query to return attribute information about a point or points within the
tolerance distance. The other way to do it is with imagemaps. Take a
look at the imagemap Howto: <A
href="http://mapserver.gis.umn.edu/docs/howto/imagemaps">http://mapserver.gis.umn.edu/docs/howto/imagemaps</A></FONT></SPAN></DIV>
<DIV><SPAN class=961455416-30052006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=961455416-30052006><FONT face=Arial color=#0000ff size=2>I
think that you are actually looking for more than just a simple imagemap
though. It sounds like you want to a 'sticky' selector so you can select
multiple points before running the query. This is going to most likely
require some client-side javascript. Luckily for you, Steve Lime has done
something similar with polygons. Take a look at his example at:
</FONT></SPAN></DIV>
<DIV><SPAN class=961455416-30052006><FONT face=Arial color=#0000ff size=2><A
href="http://maps.dnr.state.mn.us/cgi-bin/mapserv48?map=/usr/local/www/docs_maps/eco/rsg/search/search_example.map&qlayer=county&mode=nquery&searchmap=true">http://maps.dnr.state.mn.us/cgi-bin/mapserv48?map=/usr/local/www/docs_maps/eco/rsg/search/search_example.map&qlayer=county&mode=nquery&searchmap=true</A> </FONT></SPAN></DIV>
<DIV><SPAN class=961455416-30052006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=961455416-30052006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=961455416-30052006><FONT face=Arial color=#0000ff size=2>As for
querying based on attributes in a joined MySQL database, I am not sure of the
status of the join functionality. It it is possible, it would be done
using MapServer compiled with OGR. </FONT></SPAN></DIV>
<DIV><SPAN class=961455416-30052006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=961455416-30052006><FONT face=Arial color=#0000ff size=2>If
your attribute data is already in MySQL, and you are just plotting points, you
not just store your point locations in MySQL as well? That way, you could
just query the points that you want. Take a look at: <A
href="http://mapserver.gis.umn.edu/docs/howto/ogrmysql">http://mapserver.gis.umn.edu/docs/howto/ogrmysql</A></FONT></SPAN></DIV>
<DIV><SPAN class=961455416-30052006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=961455416-30052006><FONT face=Arial color=#0000ff size=2>You
need a relatively recent MapServer/OGR compile to do this. Probably within
the past year on Windows, but last month or two on 'nix.
</FONT></SPAN></DIV>
<DIV><SPAN class=961455416-30052006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=961455416-30052006><FONT face=Arial color=#0000ff
size=2>David.</FONT></SPAN></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> UMN MapServer
Users List [mailto:MAPSERVER-USERS@LISTS.UMN.EDU] <B>On Behalf Of </B>Sarah
Parrott<BR><B>Sent:</B> Tuesday, May 30, 2006 11:25 AM<BR><B>To:</B>
MAPSERVER-USERS@LISTS.UMN.EDU<BR><B>Subject:</B> [UMN_MAPSERVER-USERS] Make
points on a map clickable + use criteria from
MySQL<BR><BR></FONT></DIV>Hi,<BR><BR> Is there a way to make points on a
map clickable? Basically I want the user to be able to look at the map and
then select a subset of the points on it by clicking on them and then use this
'list' of points somewhere else. The points are stored in a shapefile which is
displayed on top of a raster layer. <BR><BR> Also, with the same points
in the shapefile, can I display them differently depending on a value in a
mysql database? Each user will have their own data about that point - mainly
whether or not they have been there - and I want to be able to show points
they have visited in a different way to points they haven't.
<BR><BR>Thanks!<BR><BR>Sparrott :)<BR></BLOCKQUOTE></BODY></HTML>