<html st="" repl="http://schemas.microsoft.com/repl/" ss="urn:schemas-microsoft-com:office:spreadsheet" z="urn:schemas-microsoft-com:" sp="http://schemas.microsoft.com/sharepoint/" x="urn:schemas-microsoft-com:office:excel" w="urn:schemas-microsoft-com:office:word" xsi="http://www.w3.org/2001/XMLSchema-instance" v="urn:schemas-microsoft-com:vml" xmlns="http://www.w3.org/TR/REC-html40" s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xsd="http://www.w3.org/2001/XMLSchema" q="http://schemas.xmlsoap.org/soap/envelope/" p="urn:schemas-microsoft-com:office:powerpoint" o="urn:schemas-microsoft-com:office:office" oa="urn:schemas-microsoft-com:office:activation" m="http://schemas.microsoft.com/office/2004/12/omml" wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" d="DAV:" c="urn:schemas-microsoft-com:office:component:spreadsheet" pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" b="urn:schemas-microsoft-com:office:publisher" a="urn:schemas-microsoft-com:office:access" dir="http://schemas.microsoft.com/sharepoint/soap/directory/" rs="urn:schemas-microsoft-com:rowset" rtc="http://microsoft.com/officenet/conferencing" x2="http://schemas.microsoft.com/office/excel/2003/xml" dsss="http://schemas.microsoft.com/office/2006/digsig-setup" dsp="http://schemas.microsoft.com/sharepoint/dsp" ex12t="http://schemas.microsoft.com/exchange/services/2006/types" dssi="http://schemas.microsoft.com/office/2006/digsig" spwp="http://microsoft.com/sharepoint/webpartpages" sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" udc="http://schemas.microsoft.com/data/udc" udcxf="http://schemas.microsoft.com/data/udc/xmlfile" ois="http://schemas.microsoft.com/sharepoint/soap/ois/" udcp2p="http://schemas.microsoft.com/data/udc/parttopart" sps="http://schemas.microsoft.com/sharepoint/soap/" ec="http://www.w3.org/2001/04/xmlenc#" dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" ds="http://www.w3.org/2000/09/xmldsig#" mrels="http://schemas.openxmlformats.org/package/2006/relationships" odc="urn:schemas-microsoft-com:office:odc" mver="http://schemas.openxmlformats.org/markup-compatibility/2006" ppda="http://www.passport.com/NameSpace.xsd" udcs="http://schemas.microsoft.com/data/udc/soap" html="http://www.w3.org/TR/REC-html40">
<head>
<style type="text/css">
<!--
body { margin-right: 4px; font-variant: normal; margin-left: 4px; margin-bottom: 1px; line-height: normal; margin-top: 4px }
li.msonormal { margin-right: 0in; margin-left: 0in; font-size: 11.0pt; font-family: Calibri,sans-serif; margin-bottom: .0001pt; margin-top: 0in }
span.plaintextchar { font-family: Consolas }
a:visited { color: purple; text-decoration: underline }
p { margin-bottom: 0; margin-top: 0 }
span.msohyperlink { color: blue; text-decoration: underline }
span.msohyperlinkfollowed { color: purple; text-decoration: underline }
p.msoplaintext { margin-right: 0in; margin-left: 0in; font-size: 10.5pt; font-family: Consolas; margin-bottom: .0001pt; margin-top: 0in }
li.msoplaintext { margin-right: 0in; margin-left: 0in; font-size: 10.5pt; font-family: Consolas; margin-bottom: .0001pt; margin-top: 0in }
a:link { color: blue; text-decoration: underline }
p.msonormal { margin-right: 0in; margin-left: 0in; font-size: 11.0pt; font-family: Calibri,sans-serif; margin-bottom: .0001pt; margin-top: 0in }
div.msonormal { margin-right: 0in; margin-left: 0in; font-size: 11.0pt; font-family: Calibri,sans-serif; margin-bottom: .0001pt; margin-top: 0in }
div.msoplaintext { margin-right: 0in; margin-left: 0in; font-size: 10.5pt; font-family: Consolas; margin-bottom: .0001pt; margin-top: 0in }
-->
</style>
</head>
<body link="blue" lang="EN-US" vlink="purple">
<p style="margin-bottom: 0; margin-top: 0">
<font size="3" face="Comic Sans MS">Don't know if it matters, but you have a LASTWEEK and LASTWEEKS in there. Should they both be one or the other?</font> </p>
<br>
<p style="margin-bottom: 0; margin-top: 0">
<font size="3" face="Comic Sans MS">bobb</font> </p>
<br> <br>
<p style="margin-bottom: 0; margin-top: 0">
<br>
<br>
>>> Jay Kapalczynski <jkapalczynski@ci.maple-grove.mn.us> wrote:<br> </p>
<div style="margin-right: 0; border-left: solid 1px #050505; background-color: #f3f3f3; margin-left: 15px; padding-left: 7px; margin-bottom: 0; margin-top: 0">
<div class="wordsection1">
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
I thank you for your response....greatly appreciated as I cannot figure this out....<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
I know that I have 4 features in the dataset that have a value of 20100916 that’s 13 days ago....so with the expression below those 4 or 5 features should show up....but nothing shows up<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
<o p="#DEFAULT">
</o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
IncidentDa is the field (long integer)<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
Param type is specifying YYYYMMDD my data has values of 20100916 (13 days)<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
<o p="#DEFAULT">
</o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
I have no idea what could be wrong…Thank you all for your help….<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
<o p="#DEFAULT">
</o> </p>
<br>
<div style="color: black; font-size: 9.0pt">
<p style="margin-bottom: 0; margin-top: 0">
.XML file<o p="#DEFAULT"></o> </p>
</div>
<br>
<div style="color: #632423; font-size: 9.0pt">
<p style="margin-bottom: 0; margin-top: 0">
<map-source name="Burglaries" type="mapserver"><o p="#DEFAULT"></o> </p>
</div>
<br>
<div style="color: #632423; font-size: 9.0pt">
<p style="margin-bottom: 0; margin-top: 0">
<file>./maple_grove_datasets/police/Burglaries.map</file><o p="#DEFAULT"></o> </p>
</div>
<br>
<div style="color: #632423; font-size: 9.0pt">
<p style="margin-bottom: 0; margin-top: 0">
<param type="today" offset="-90" name="LASTNINTY" format="%4Y%2M%2D" /><o p="#DEFAULT"></o> </p>
</div>
<br>
<div style="color: #632423; font-size: 9.0pt">
<p style="margin-bottom: 0; margin-top: 0">
<param type="today" offset="-30" name="LASTTHIRTY" format="%4Y%2M%2D" /><o p="#DEFAULT"></o> </p>
</div>
<br>
<div style="color: #632423; font-size: 9.0pt">
<p style="margin-bottom: 0; margin-top: 0">
<param type="today" offset="-14" name="LASTTWOWEEKS" format="%4Y%2M%2D" /><o p="#DEFAULT"></o> </p>
</div>
<br>
<div style="color: #632423; font-size: 9.0pt">
<p style="margin-bottom: 0; margin-top: 0">
<param type="today" offset="-7" name="LASTWEEK" format="%4Y%2M%2D" /><o p="#DEFAULT"></o> </p>
</div>
<br>
<div style="color: #632423; font-size: 9.0pt">
<p style="margin-bottom: 0; margin-top: 0">
<param type="today" offset="0" name="TODAY" format="%4Y%2M%2D" /><o p="#DEFAULT"></o> </p>
</div>
<br>
<div style="color: #632423; font-size: 9.0pt">
<p style="margin-bottom: 0; margin-top: 0">
<layer name="Burglaries"/><o p="#DEFAULT"></o> </p>
</div>
<br>
<div style="color: #632423; font-size: 9.0pt">
<p style="margin-bottom: 0; margin-top: 0">
</map-source><o p="#DEFAULT"></o> </p>
</div>
<br>
<div style="color: #632423; font-size: 9.0pt">
<p style="margin-bottom: 0; margin-top: 0">
<o p="#DEFAULT">
</o> </p>
</div>
<br>
<div style="color: black; font-size: 9.0pt">
<p style="margin-bottom: 0; margin-top: 0">
.MAP file<o p="#DEFAULT"></o> </p>
</div>
<br>
<div style="color: #632423; font-size: 9.0pt">
<p style="margin-bottom: 0; margin-top: 0">
CLASS<o p="#DEFAULT"></o> </p>
</div>
<br>
<div style="color: #632423; font-size: 9.0pt">
<p style="margin-bottom: 0; margin-top: 0">
NAME 'Last Weeks'<o p="#DEFAULT"></o> </p>
</div>
<br>
<div style="color: #632423; font-size: 9.0pt">
<p style="margin-bottom: 0; margin-top: 0">
EXPRESSION ('[IncidentDa]' > '%LASTTWOWEEKS%' && '[IncidentDa]' < '%LASTWEEK%')<o p="#DEFAULT"></o> </p>
</div>
<br>
<div style="color: #632423; font-size: 9.0pt">
<p style="margin-bottom: 0; margin-top: 0">
STYLE<o p="#DEFAULT"></o> </p>
</div>
<br>
<div style="color: #632423; font-size: 9.0pt">
<p style="margin-bottom: 0; margin-top: 0">
COLOR 0 100 50 <o p="#DEFAULT"></o> </p>
</div>
<br>
<div style="color: #632423; font-size: 9.0pt">
<p style="margin-bottom: 0; margin-top: 0">
SYMBOL "bike" <o p="#DEFAULT"></o> </p>
</div>
<br>
<div style="color: #632423; font-size: 9.0pt">
<p style="margin-bottom: 0; margin-top: 0">
SIZE 12<o p="#DEFAULT"></o> </p>
</div>
<br>
<div style="color: #632423; font-size: 9.0pt">
<p style="margin-bottom: 0; margin-top: 0">
END <o p="#DEFAULT"></o> </p>
</div>
<br>
<div style="color: #632423; font-size: 9.0pt">
<p style="margin-bottom: 0; margin-top: 0">
END<o p="#DEFAULT"></o> </p>
</div>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
<o p="#DEFAULT">
</o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
=======================================<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
<o p="#DEFAULT">
</o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
BUT if I simply place this in there I get all the points…so something is weird here because most of the dates are older than 7 days.<o p="#DEFAULT"></o> </p>
<br>
<div style="color: #632423; font-size: 9.0pt; font-family: Consolas">
<p style="margin-bottom: 0; margin-top: 0">
CLASS<o p="#DEFAULT"></o> </p>
</div>
<br>
<div style="color: #632423; font-size: 9.0pt; font-family: Consolas">
<p style="margin-bottom: 0; margin-top: 0">
NAME 'Last Weeks'<o p="#DEFAULT"></o> </p>
</div>
<br>
<div style="color: #632423; font-size: 9.0pt; font-family: Consolas">
<p style="margin-bottom: 0; margin-top: 0">
EXPRESSION ('[IncidentDa]' > '%LASTWEEK%’)<o p="#DEFAULT"></o> </p>
</div>
<br>
<div style="color: #632423; font-size: 9.0pt; font-family: Consolas">
<p style="margin-bottom: 0; margin-top: 0">
STYLE<o p="#DEFAULT"></o> </p>
</div>
<br>
<div style="color: #632423; font-size: 9.0pt; font-family: Consolas">
<p style="margin-bottom: 0; margin-top: 0">
COLOR 0 0 0 <o p="#DEFAULT"></o> </p>
</div>
<br>
<div style="color: #632423; font-size: 9.0pt; font-family: Consolas">
<p style="margin-bottom: 0; margin-top: 0">
SYMBOL "tent" <o p="#DEFAULT"></o> </p>
</div>
<br>
<div style="color: #632423; font-size: 9.0pt; font-family: Consolas">
<p style="margin-bottom: 0; margin-top: 0">
SIZE 12<o p="#DEFAULT"></o> </p>
</div>
<br>
<div style="color: #632423; font-size: 9.0pt; font-family: Consolas">
<p style="margin-bottom: 0; margin-top: 0">
END <o p="#DEFAULT"></o> </p>
</div>
<br>
<div style="color: #632423; font-size: 9.0pt; font-family: Consolas">
<p style="margin-bottom: 0; margin-top: 0">
#END<o p="#DEFAULT"></o> </p>
</div>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
<o p="#DEFAULT">
</o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
<o p="#DEFAULT">
</o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
-----Original Message-----<br>From: mapserver-users-bounces@lists.osgeo.org [mailto:mapserver-users-bounces@lists.osgeo.org] On Behalf Of Stephen Woodbridge<br>Sent: Wednesday, September 29, 2010 8:19 AM<br>To: mapserver-users@lists.osgeo.org<br>Subject: Re: [mapserver-users] Expressions<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
<o p="#DEFAULT">
</o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
In EXPRESSIONS you can evaluate any of the following:<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
<o p="#DEFAULT">
</o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
1. Regular expressions treating the value as a string<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
2. numeric expressions using booleans like ==,<,>,<=,>=<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
3. string expressions like ==, !=, and I think strlen()<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
<o p="#DEFAULT">
</o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
So if you converted you dates into a format like YYYYMMDD then it would <o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
be easy to use a numeric expression like:<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
<o p="#DEFAULT">
</o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
EXPRESSION ('[dateValues]' > '%STARTDATE%' && '[dateValues]' < '%ENDDATE%')<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
<o p="#DEFAULT">
</o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
or<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
<o p="#DEFAULT">
</o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
EXPRESSION ('[dateValues]' > '%STARTDATE%')<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
<o p="#DEFAULT">
</o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
where STARTDATE is the YYYYMMDD value of two weeks ago and ENDDATE would <o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
be in the same format and allow you to extract record betwee any two <o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
start and end dates.<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
<o p="#DEFAULT">
</o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
Or you might be able to figure out a complex regular expression the <o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
represents the last two weeks like:<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
<o p="#DEFAULT">
</o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
EXPRESSION ('[dateValues]' =~ '/%LASTTWOWEEKS%/')<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
<o p="#DEFAULT">
</o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
I'm not sure what you would need for the regular expression.<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
<o p="#DEFAULT">
</o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
-Steve W<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
<o p="#DEFAULT">
</o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
On 9/28/2010 4:23 PM, Jay Kapalczynski wrote:<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> Anyone have anymore ideas about this….<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> I have a string field with values<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> And the code below. The expression does not seem to be running…if I only<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> use LASTTWOWEEKS it still draws all the points….and I know there are<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> values in there from 2008<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> Thanks<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> *From:* mapserver-users-bounces@lists.osgeo.org<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> [mailto:mapserver-users-bounces@lists.osgeo.org] *On Behalf Of *Jay<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> Kapalczynski<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> *Sent:* Tuesday, September 21, 2010 9:51 AM<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> *To:* 'Bob Basques'; mapserver-users@lists.osgeo.org<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> *Subject:* RE: [mapserver-users] Expressions<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> My major question is can I do this with a String/text field? Its the<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> only way I can see keeping things in a %2Y%2M%2D format ex. 092110 (Sept<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> 21^st 2010), otherwise the 0 will get removed in a numeric field<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> Can I use the format Year, Month, Day? Or do I have to use Month, Day, Year?<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> In this example I eliminated two expressions and focused on one<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> Expression to see if it is working.<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> *_I kept this_*<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> <map-source name="Burglaries" type="mapserver"><o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> <file>./maple_grove_datasets/police/Burglaries.map</file><o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> <param type="today" offset="-7" name="LASTWEEK" format="%2Y%2M%2D" /><o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> <param type="today" offset="-14" name="LASTTWOWEEKS" format="%2Y%2M%2D" /><o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> <param type="today" offset="-30" name="LASTTHIRTY" format="%2Y%2M%2D" /><o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> <param type="today" offset="-90" name="LASTNINTY" format="%2Y%2M%2D" /><o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> <layer name="Burglaries"/><o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> </map-source><o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> *_In my map file I used _**_ONLY_**_ this_*<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> CLASS<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> NAME 'Last Weeks'<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> EXPRESSION ('[dateValues]' > '%LASTTWOWEEKS%')<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> STYLE<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> COLOR 0 100 50<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> SYMBOL "bike"<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> SIZE 12<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> END<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> END<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> Now in my data I have these values (below), although every symbol was<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> displayed in the map<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> NOTE THIS IS A TEXT FIELD<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> 081204, 081225,090118<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> These values (above) for the Year, Month, Day format specified in the<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> map source are clearly less than the “last two weeks”, Where as they are<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> older than the last 14 days….so none of them should show up, but they do<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> Any thoughts<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> *From:* mapserver-users-bounces@lists.osgeo.org<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> [mailto:mapserver-users-bounces@lists.osgeo.org] *On Behalf Of *Bob Basques<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> *Sent:* Friday, September 17, 2010 9:25 PM<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> *To:* mapserver-users@lists.osgeo.org<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> *Subject:* Re: [mapserver-users] Expressions<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> A first stab at seeing more than one class, might be to try and switch<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> them around order wise, one filter may be overwriting the other for example.<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> bobb<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> On 9/17/2010 8:20 AM, Jay Kapalczynski wrote:<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> I am using GeoMoose but feel this is more a question for Map Server.<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> I am trying to sort my points by dates using the code below….I think<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> that I can do this but not sure<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> Is this a viable format “2Y%2M%2D” ?<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> As for the field in the shapefile…If I use an integer it removes the 0<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> from the 092110, (sept 21^st 2010)<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> If I use a date then there are “/” … 9/21/10<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> The only way I can see this happening is using a text field with retains<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> the 0 in 092110<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> When I use the textfield “dateValues” as seen below I can get the stars<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> to draw but only the LASTWEEK…for some reason the LASTTWOWEEKS does not<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> show and I know that I have a few records with dates in the last 14 days…<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> Thoughts?<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> THANKS….all your help is very appreciated….<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> Main .xml file<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> <map-source name="Burglaries" type="mapserver"><o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> <file>./maple_grove_datasets/police/Burglaries.map</file><o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> <param type="today" offset="-7" name="LASTWEEK" format="%2Y%2M%2D" /><o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> <param type="today" offset="-14" name="LASTTWOWEEKS" format="%2Y%2M%2D" /><o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> <param type="today" offset="-30" name="LASTTHIRTY" format="%2Y%2M%2D" /><o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> <param type="today" offset="-90" name="LASTNINTY" format="%2Y%2M%2D" /><o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> <layer name="Burglaries"/><o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> </map-source><o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> .map file<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> CLASS<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> NAME 'Last Weeks'<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> EXPRESSION ('[dateValues]' > '%LASTWEEK%')<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> STYLE<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> COLOR 0 0 0<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> SYMBOL "star"<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> SIZE 12<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> END<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> END<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> CLASS<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> NAME 'Last Two Weeks'<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> EXPRESSION ('[dateValues]' > '%LASTTWOWEEKS%')<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> STYLE<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> COLOR 0 100 50<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> SYMBOL "star"<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> SIZE 12<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> END<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> END<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> _______________________________________________<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> mapserver-users mailing list<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> mapserver-users@lists.osgeo.org <mailto:mapserver-users@lists.osgeo.org><o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> http://lists.osgeo.org/mailman/listinfo/mapserver-users<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
><o p="#DEFAULT"> </o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> _______________________________________________<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> mapserver-users mailing list<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> mapserver-users@lists.osgeo.org<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
> http://lists.osgeo.org/mailman/listinfo/mapserver-users<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
<o p="#DEFAULT">
</o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
_______________________________________________<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
mapserver-users mailing list<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
mapserver-users@lists.osgeo.org<o p="#DEFAULT"></o> </p>
<p style="margin-bottom: 0; margin-top: 0" class="msoplaintext">
http://lists.osgeo.org/mailman/listinfo/mapserver-users<o p="#DEFAULT"></o>
</p>
</div>
</div>
</body>
</html>