<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:D="DAV:" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.5pt;
font-family:Consolas;}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:Consolas;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoPlainText>Have been think about this and just wanted to run this
passed anyone that is listening. For my GPS tracking I am using an ovf file to
grab XY coordinates from a database and plot them in my app.<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>I was wondering if I could do a similar thing, where I
write to the database in PHP every time the query is run. This will populate a
table with the PID values I need highlighted.<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>Then Classify in the Map file the color and outline that
I am after.<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>Could I use a filter on the Map file then to just show
records in the database?<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>Is this even possible or make sense?<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText><b>OVF File (but select the PID values from the table)<o:p></o:p></b></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText><span style='font-size:9.0pt;color:#632423'><OGRVRTDataSource>
<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt;color:#632423'>
<OGRVRTLayer name="Coordinatedata"><o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt;color:#632423'>
<SrcDataSource>MYSQL:coordinates_database,user=Jay,password=Passw0rd,host=127.0.0.1,port=3306,tables=coordinates</SrcDataSource>
<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt;color:#632423'>
<SrcSQL>SELECT X,Y FROM coordinates</SrcSQL> <o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt;color:#632423'>
<GeometryType>wkbPoint</GeometryType><o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt;color:#632423'> <GeometryField
encoding="PointFromColumns" x="X" y="Y"/> <o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt;color:#632423'> </OGRVRTLayer><o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt;color:#632423'></OGRVRTDataSource><o:p></o:p></span></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText><b>MAP FILE<o:p></o:p></b></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText><span style='font-size:9.0pt;color:#632423'>LAYER #
Points from the MySQL Database<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt;color:#632423'> NAME
Database<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt;color:#632423'> STATUS
DEFAULT<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt;color:#632423'> TYPE
POLYGON<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt;color:#632423'>
CONNECTIONTYPE OGR <o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt;color:#632423'> CONNECTION
'./Coordinatedata1.ovf'<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt;color:#632423'> DATA
'Coordinatedata'<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt;color:#632423'> CLASS <o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt;color:#632423'> #NAME
"ID"<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt;color:#632423'>
STYLE<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt;color:#632423'>
OUTLINECOLOR 204 204 204<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt;color:#632423'>
WIDTH 1<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt;color:#632423'>
END<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt;color:#632423'> END<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt;color:#632423'>END<o:p></o:p></span></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>-----Original Message-----<br>
From: Steve Lime [mailto:Steve.Lime@dnr.state.mn.us] <br>
Sent: Tuesday, April 14, 2009 4:18 PM<br>
To: Jay Kapalczynski; mapserver-users@lists.osgeo.org; Paul T.' 'Moen; David'
'Fawcett<br>
Subject: RE: [mapserver-users] RE: Highlight<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>This is an example of how to highlight a feature (click
on a dot in the application I sent) without<o:p></o:p></p>
<p class=MsoPlainText>doing query maps or anything like that. You're
manipulating a layer filter on-the-fly based on your<o:p></o:p></p>
<p class=MsoPlainText>search result. This can work with multiple results but is
best suited to just a few results. With more<o:p></o:p></p>
<p class=MsoPlainText>than that you really need to look at some other way to
cache features- a queryfile or some sort<o:p></o:p></p>
<p class=MsoPlainText>of a temp table.<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>Sorry if I've confused things.<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>Steve<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>>>> On 4/14/2009 at 3:23 PM, in message<o:p></o:p></p>
<p class=MsoPlainText><D7A5EAC385604446AB1DD24BF4F5A9184FB90EE805@MG-Mail.ci.maple-grove.mn.us>,
Jay<o:p></o:p></p>
<p class=MsoPlainText>Kapalczynski <jkapalczynski@ci.maple-grove.mn.us>
wrote:<o:p></o:p></p>
<p class=MsoPlainText>> I am having a hard time trying to understand how
that applies to what I am <o:p></o:p></p>
<p class=MsoPlainText>> doing....I do appreciate the help here.<o:p></o:p></p>
<p class=MsoPlainText>> Just trying to find a solution here...<o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>>>From my main page I run a query in PHP that
returns specific records<o:p></o:p></p>
<p class=MsoPlainText>> I then move to a different web page that has a
couple frames.<o:p></o:p></p>
<p class=MsoPlainText>> I display the map in one frame and build a table in
the 2nd frame that shows <o:p></o:p></p>
<p class=MsoPlainText>> the results.<o:p></o:p></p>
<p class=MsoPlainText>> In the table I have a field that will zoom to and
identify that feature in <o:p></o:p></p>
<p class=MsoPlainText>> the main map<o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> The only thing I am missing is after I run the query
none of the parcels are <o:p></o:p></p>
<p class=MsoPlainText>> highlighted in the map...<o:p></o:p></p>
<p class=MsoPlainText>> I want to create the table and highlight the
returned parcels in the map...<o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> Getting pretty confused right now...dont know the
best way to accomplish <o:p></o:p></p>
<p class=MsoPlainText>> this...going in 4 different directions right now..<o:p></o:p></p>
<p class=MsoPlainText>> The Query is being done in PHP, so I somehow need to
take that result (comma <o:p></o:p></p>
<p class=MsoPlainText>> delimited string) and get a the PID values from that
to show up highlighted <o:p></o:p></p>
<p class=MsoPlainText>> in my map..<o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> Before I go on does anyone have a suggestion as to
what would be the best <o:p></o:p></p>
<p class=MsoPlainText>> course of action...<o:p></o:p></p>
<p class=MsoPlainText>> Like Steve said, Like I am doing...<o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> Thanks Guys...you help is appreciated...<o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> -----Original Message-----<o:p></o:p></p>
<p class=MsoPlainText>> From: Fawcett, David
[mailto:David.Fawcett@state.mn.us] <o:p></o:p></p>
<p class=MsoPlainText>> Sent: Tuesday, April 14, 2009 2:39 PM<o:p></o:p></p>
<p class=MsoPlainText>> To: Jay Kapalczynski; Steve Lime;
mapserver-users@lists.osgeo.org; Paul T.' <o:p></o:p></p>
<p class=MsoPlainText>> 'Moen<o:p></o:p></p>
<p class=MsoPlainText>> Subject: RE: [mapserver-users] RE: Highlight<o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> Steve is using CGI MapServer instead of php. <o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> When you click on a station, you will notice that
the outline of the<o:p></o:p></p>
<p class=MsoPlainText>> station turns yellow. <o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> Here is the URL to a tile with a highlighted symbol
on it:<o:p></o:p></p>
<p class=MsoPlainText>>
http://maps.dnr.state.mn.us/cgi-bin/mapserv52?map=/usr/local/mapserver/a <o:p></o:p></p>
<p class=MsoPlainText>>
pps/waters/csg/csg.map&layers=active_site&map_transparent=true&id=0&mode<o:p></o:p></p>
<p class=MsoPlainText>>
=map&map_imagetype=png&station=63023001&mapext=-27687.5+4793250+941687.5<o:p></o:p></p>
<p class=MsoPlainText>> +5480750&imgext=-27687.5+4793250+941687.5+5480750&map_size=705+500&imgx=<o:p></o:p></p>
<p class=MsoPlainText>> 352.5&imgy=250&imgxy=705+500<o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> Notice that he has a layer called 'active_site' and
he is passing in the<o:p></o:p></p>
<p class=MsoPlainText>> station ID use in a class in that layer to turn only
that feature<o:p></o:p></p>
<p class=MsoPlainText>> yellow. <o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> When no station is selected, no stations are drawn
in the 'active_site'<o:p></o:p></p>
<p class=MsoPlainText>> layer.<o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> David.<o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> -----Original Message-----<o:p></o:p></p>
<p class=MsoPlainText>> From: mapserver-users-bounces@lists.osgeo.org <o:p></o:p></p>
<p class=MsoPlainText>> [mailto:mapserver-users-bounces@lists.osgeo.org] On
Behalf Of Jay<o:p></o:p></p>
<p class=MsoPlainText>> Kapalczynski<o:p></o:p></p>
<p class=MsoPlainText>> Sent: Tuesday, April 14, 2009 2:30 PM<o:p></o:p></p>
<p class=MsoPlainText>> To: 'Steve Lime'; mapserver-users@lists.osgeo.org;
Paul T.' 'Moen<o:p></o:p></p>
<p class=MsoPlainText>> Subject: RE: [mapserver-users] RE: Highlight<o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> Thanks....but little confused as to what I am look
at...<o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> How is this working?<o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> -----Original Message-----<o:p></o:p></p>
<p class=MsoPlainText>> From: Steve Lime [mailto:Steve.Lime@dnr.state.mn.us]
<o:p></o:p></p>
<p class=MsoPlainText>> Sent: Tuesday, April 14, 2009 1:02 PM<o:p></o:p></p>
<p class=MsoPlainText>> To: Jay Kapalczynski;
mapserver-users@lists.osgeo.org; Paul T.' 'Moen<o:p></o:p></p>
<p class=MsoPlainText>> Subject: RE: [mapserver-users] RE: Highlight<o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> This is probably too late to be of use but I've been
using a highlight<o:p></o:p></p>
<p class=MsoPlainText>> layer to achieve this. The layer takes input from a
URL so that layer<o:p></o:p></p>
<p class=MsoPlainText>> filter allows just the desired feature through.
Works quite nicely and<o:p></o:p></p>
<p class=MsoPlainText>> is relatively simple to implement. Here's an
OpenLayers site that uses<o:p></o:p></p>
<p class=MsoPlainText>> this:<o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>>
http://www.dnr.state.mn.us/waters/csg/index_copy.html <o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> In this case the highlight is a separate layer but
you could just as<o:p></o:p></p>
<p class=MsoPlainText>> easily return a single map.<o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>> Steve<o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>>>>> On 4/13/2009 at 11:17 AM, in message<o:p></o:p></p>
<p class=MsoPlainText>>
<D7A5EAC385604446AB1DD24BF4F5A91841F1A74D7A@MG-Mail.ci.maple-grove.mn.us <o:p></o:p></p>
<p class=MsoPlainText>>>, Jay Kapalczynski
<jkapalczynski@ci.maple-grove.mn.us> wrote:<o:p></o:p></p>
<p class=MsoPlainText>>> So say I have a Database that I am querying...<o:p></o:p></p>
<p class=MsoPlainText>>> I get the results back with a PID number
(unique)<o:p></o:p></p>
<p class=MsoPlainText>>> This number exists in the Parcels Shapefile so I
can go after that <o:p></o:p></p>
<p class=MsoPlainText>>> field. I have a map file that is set up for the
Parcels, but this is <o:p></o:p></p>
<p class=MsoPlainText>>> just there to draw the Parcels... I assume that
I would have to modify<o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>>> this one for this to work?<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> I am just a bit confused on how to get this to
work...<o:p></o:p></p>
<p class=MsoPlainText>>> When I run the code that creates the Table below
I want the parcels to<o:p></o:p></p>
<p class=MsoPlainText>> <o:p></o:p></p>
<p class=MsoPlainText>>> also<o:p></o:p></p>
<p class=MsoPlainText>>> highlight in the map....<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> Attached is my code that I am using to get the
resulting PID Values, <o:p></o:p></p>
<p class=MsoPlainText>>> build<o:p></o:p></p>
<p class=MsoPlainText>>> the table, and populate the last frame showing
the Comma Delimited<o:p></o:p></p>
<p class=MsoPlainText>> String.<o:p></o:p></p>
<p class=MsoPlainText>>> I just don't know how to apply that to my map?<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> I attached my code from my PHP page which I hope
that someone can at <o:p></o:p></p>
<p class=MsoPlainText>>> least<o:p></o:p></p>
<p class=MsoPlainText>>> put their eyes on...<o:p></o:p></p>
<p class=MsoPlainText>>> Towards to bottom you will see highlighted in
RED the code that I am <o:p></o:p></p>
<p class=MsoPlainText>>> building a comma delimited string to populate a
variable with all the<o:p></o:p></p>
<p class=MsoPlainText>> PID <o:p></o:p></p>
<p class=MsoPlainText>>> numbers...<o:p></o:p></p>
<p class=MsoPlainText>>> I assume that I would not need the comma
delimited string as I could<o:p></o:p></p>
<p class=MsoPlainText>> place <o:p></o:p></p>
<p class=MsoPlainText>>> the highlighting code inside the while loop to
get the parcels<o:p></o:p></p>
<p class=MsoPlainText>> highlighted...<o:p></o:p></p>
<p class=MsoPlainText>>> I don't really know...<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> Any thoughts?<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> Thanks<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> This inside the while loop????<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> $map = ms_newMapObj(PATH TO YOU MAPFILE);<o:p></o:p></p>
<p class=MsoPlainText>>> $qlayer = $map->$map->getLayerByName(NAME
OF PARCEL LAYER); <o:p></o:p></p>
<p class=MsoPlainText>>> $qlayer->queryByAttributes('PID','PID IN (MY
COMMA DELIMITED STRING <o:p></o:p></p>
<p class=MsoPlainText>>> VARIABLE')',MS_MULTIPLE); $img =
$map->drawQuery();<o:p></o:p></p>
<p class=MsoPlainText>>> header('Content-Type: image/jpeg');<o:p></o:p></p>
<p class=MsoPlainText>>> $img->saveImage("");<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> [cid:image001.jpg@01C9BC29.7A1ECE10] <o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> From: mapserver-users-bounces@lists.osgeo.org <o:p></o:p></p>
<p class=MsoPlainText>>> [mailto:mapserver-users-bounces@lists.osgeo.org]
On Behalf Of Moen,<o:p></o:p></p>
<p class=MsoPlainText>> Paul T.<o:p></o:p></p>
<p class=MsoPlainText>>> Sent: Thursday, April 09, 2009 3:15 PM<o:p></o:p></p>
<p class=MsoPlainText>>> To: mapserver-users@lists.osgeo.org <o:p></o:p></p>
<p class=MsoPlainText>>> Subject: Re: [mapserver-users] RE: Highlight<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> If the database that you are querying has the
same attributes as the <o:p></o:p></p>
<p class=MsoPlainText>>> shape<o:p></o:p></p>
<p class=MsoPlainText>>> file, you can query the Layer that points to the
shape file and<o:p></o:p></p>
<p class=MsoPlainText>> display the <o:p></o:p></p>
<p class=MsoPlainText>>> highlighted results on your map. I know nothing
about GeoMOOSE but I<o:p></o:p></p>
<p class=MsoPlainText>> know it <o:p></o:p></p>
<p class=MsoPlainText>>> can be done with php-mapscript.<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> Regardless of what you are using, you need a map
file layer for the <o:p></o:p></p>
<p class=MsoPlainText>>> shape<o:p></o:p></p>
<p class=MsoPlainText>>> file with the parcels.<o:p></o:p></p>
<p class=MsoPlainText>>> You will then need to use php-mapscript to query
that layer with<o:p></o:p></p>
<p class=MsoPlainText>> something <o:p></o:p></p>
<p class=MsoPlainText>>> like<o:p></o:p></p>
<p class=MsoPlainText>>> $map = ms_newMapObj(PATH TO YOU MAPFILE);<o:p></o:p></p>
<p class=MsoPlainText>>> $qlayer = $map->$map->getLayerByName(NAME
OF PARCEL LAYER);<o:p></o:p></p>
<p class=MsoPlainText>>> $qlayer->queryByAttributes('PID','PID IN (1,<o:p></o:p></p>
<p class=MsoPlainText>> 2,7,9,23,87)',MS_MULTIPLE);<o:p></o:p></p>
<p class=MsoPlainText>>> You will then need to create the output image
from query using<o:p></o:p></p>
<p class=MsoPlainText>> something <o:p></o:p></p>
<p class=MsoPlainText>>> like<o:p></o:p></p>
<p class=MsoPlainText>>> $img = $map->drawQuery();<o:p></o:p></p>
<p class=MsoPlainText>>> header('Content-Type: image/jpeg');<o:p></o:p></p>
<p class=MsoPlainText>>> $img->saveImage("");<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> I can't give you specifics without knowing how
GeoMOOSE works, so the <o:p></o:p></p>
<p class=MsoPlainText>>> best<o:p></o:p></p>
<p class=MsoPlainText>>> thing is to look at the documentation for
GeoMOOSE if that is what you<o:p></o:p></p>
<p class=MsoPlainText>> are <o:p></o:p></p>
<p class=MsoPlainText>>> using.<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> On 4/9/09 2:17 PM, "Jay Kapalczynski" <o:p></o:p></p>
<p class=MsoPlainText>>> <jkapalczynski@ci.maple-grove.mn.us><o:p></o:p></p>
<p class=MsoPlainText>>> wrote:<o:p></o:p></p>
<p class=MsoPlainText>>> Dang I misspoke...I am sorry...<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> I am querying a Database for records, these
records have a PID (unique<o:p></o:p></p>
<p class=MsoPlainText>>> Number).<o:p></o:p></p>
<p class=MsoPlainText>>> These are the records that show up in the Table.<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> As this happens I have to take the results and
run the query against <o:p></o:p></p>
<p class=MsoPlainText>>> the<o:p></o:p></p>
<p class=MsoPlainText>>> parcels to get the features in the Shapefile,
then highlight..<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> If that makes any sense...<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> If I am in a PHP file and have the records
returned from the query<o:p></o:p></p>
<p class=MsoPlainText>>> (database)...what would I have to do next to
take those records and<o:p></o:p></p>
<p class=MsoPlainText>> run a <o:p></o:p></p>
<p class=MsoPlainText>>> query to highlight the parcels (PID to PID)?<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> Can all of this be accomplished in the PHP file?<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> Thanks...and sorry for my ignorance...<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> From: mapserver-users-bounces@lists.osgeo.org <o:p></o:p></p>
<p class=MsoPlainText>>> [mailto:mapserver-users-bounces@lists.osgeo.org]
On Behalf Of Moen,<o:p></o:p></p>
<p class=MsoPlainText>> Paul T.<o:p></o:p></p>
<p class=MsoPlainText>>> Sent: Thursday, April 09, 2009 1:57 PM<o:p></o:p></p>
<p class=MsoPlainText>>> To: mapserver-users@lists.osgeo.org <o:p></o:p></p>
<p class=MsoPlainText>>> Subject: Re: [mapserver-users] RE: Highlight<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> Set the mapfile QUERYMAP style to highlight <o:p></o:p></p>
<p class=MsoPlainText>>> http://mapserver.org/mapfile/querymap.html.
Draw the map using<o:p></o:p></p>
<p class=MsoPlainText>> drawQuery() <o:p></o:p></p>
<p class=MsoPlainText>>> instead of draw().<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> $img = $map->drawQuery();<o:p></o:p></p>
<p class=MsoPlainText>>> header('Content-Type: image/jpeg');<o:p></o:p></p>
<p class=MsoPlainText>>> $img->saveImage("");<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> On 4/9/09 1:31 PM, "Jay Kapalczynski" <o:p></o:p></p>
<p class=MsoPlainText>>> <jkapalczynski@ci.maple-grove.mn.us><o:p></o:p></p>
<p class=MsoPlainText>>> wrote:<o:p></o:p></p>
<p class=MsoPlainText>>> Basically what I have is a query that runs on a
shapefile...<o:p></o:p></p>
<p class=MsoPlainText>>> It returns the records into a table, which I
then have the option to<o:p></o:p></p>
<p class=MsoPlainText>> zoom <o:p></o:p></p>
<p class=MsoPlainText>>> to.<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> I am looking for a bit more....after I run the
query (php) I want the<o:p></o:p></p>
<p class=MsoPlainText>>> returned records to highlight in the map...<o:p></o:p></p>
<p class=MsoPlainText>>> I can get the Unique identifier but don't know
if I can write some<o:p></o:p></p>
<p class=MsoPlainText>> code in <o:p></o:p></p>
<p class=MsoPlainText>>> PHP to highlight those features<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> I don't even know where to start here...<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> The query and returning records into the table,
as well as, the zoom <o:p></o:p></p>
<p class=MsoPlainText>>> to work<o:p></o:p></p>
<p class=MsoPlainText>>> great...just need the highlight part<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> Thanks<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> From: Jay Kapalczynski<o:p></o:p></p>
<p class=MsoPlainText>>> Sent: Thursday, April 09, 2009 1:03 PM<o:p></o:p></p>
<p class=MsoPlainText>>> To:
'mapserver-users@lists.osgeo.org<mapserver-users@lists.osgeo.org><o:p></o:p></p>
<p class=MsoPlainText>>> <mapserver-users@lists.osgeo.org> '<o:p></o:p></p>
<p class=MsoPlainText>>> Subject: Highlight<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> Any way to highlight a feature in my map in PHP?<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> I can grab a unique identifier but can figure
out how to highlight <o:p></o:p></p>
<p class=MsoPlainText>>> it...<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> THanks<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> Paul<o:p></o:p></p>
<p class=MsoPlainText>>> <o:p></o:p></p>
<p class=MsoPlainText>>> Paul<o:p></o:p></p>
<p class=MsoPlainText>> _______________________________________________<o:p></o:p></p>
<p class=MsoPlainText>> mapserver-users mailing list<o:p></o:p></p>
<p class=MsoPlainText>> mapserver-users@lists.osgeo.org <o:p></o:p></p>
<p class=MsoPlainText>>
http://lists.osgeo.org/mailman/listinfo/mapserver-users <o:p></o:p></p>
<p class=MsoPlainText>> _______________________________________________<o:p></o:p></p>
<p class=MsoPlainText>> mapserver-users mailing list<o:p></o:p></p>
<p class=MsoPlainText>> mapserver-users@lists.osgeo.org <o:p></o:p></p>
<p class=MsoPlainText>>
http://lists.osgeo.org/mailman/listinfo/mapserver-users<o:p></o:p></p>
</div>
</body>
</html>