<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:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" 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:Tahoma;
panose-1:2 11 6 4 3 5 4 4 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:12.0pt;
font-family:"Times New Roman","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
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
-->
</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=WordSection1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Yea I have firebug….but while in the console nothing
appears when you turn on a layer or turn one off….<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>And the response tab simply displays the .xml file….<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>I cant see where to go to see the effect the expression is
having<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>I really appreciate this all….<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Can any of my issues be related to Windows 7 64 bit computer?<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> david.bitner@gmail.com
[mailto:david.bitner@gmail.com] <b>On Behalf Of </b>David William Bitner<br>
<b>Sent:</b> Wednesday, September 29, 2010 11:03 AM<br>
<b>To:</b> Jay Kapalczynski<br>
<b>Cc:</b> Stephen Woodbridge; mapserver-users@lists.osgeo.org<br>
<b>Subject:</b> Re: [mapserver-users] Expressions<o:p></o:p></span></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Jay,<o:p></o:p></p>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>I am not exactly sure how the params work in GeoMoose.
One tip in general to be able to isolate the problem to either GeoMoose
or MapServer is to look at the actual requests that are being made to
MapServer. One of the easiest ways to do this is to either use the FireBug
extension in FireFox or the Javascript Console in Chrome. With this take a look
at the URL that is being sent to MapServer and see what is in the parameter
&LASTWEEK=.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-bottom:12.0pt'>David<o:p></o:p></p>
<div>
<p class=MsoNormal>On Wed, Sep 29, 2010 at 10:49 AM, Jay Kapalczynski <<a
href="mailto:jkapalczynski@ci.maple-grove.mn.us">jkapalczynski@ci.maple-grove.mn.us</a>>
wrote:<o:p></o:p></p>
<div>
<div>
<p>I thank you for your response....greatly appreciated as I cannot figure this
out....<o:p></o:p></p>
<p>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></o:p></p>
<p> <o:p></o:p></p>
<p>IncidentDa is the field (long integer)<o:p></o:p></p>
<p>Param type is specifying YYYYMMDD my data has values of 20100916 (13 days)<o:p></o:p></p>
<p> <o:p></o:p></p>
<p>I have no idea what could be wrong…Thank you all for your help….<o:p></o:p></p>
<p> <o:p></o:p></p>
<p><b><span style='font-size:9.0pt;color:black'>.XML file</span></b><o:p></o:p></p>
<div>
<p><span style='font-size:9.0pt;color:#632423'> <map-source
name="Burglaries" type="mapserver"></span><o:p></o:p></p>
<p><span style='font-size:9.0pt;color:#632423'>
<file>./maple_grove_datasets/police/Burglaries.map</file></span><o:p></o:p></p>
</div>
<p><span style='font-size:9.0pt;color:#632423'> <param
type="today" offset="-90" name="LASTNINTY"
format="%4Y%2M%2D" /></span><o:p></o:p></p>
<p><span style='font-size:9.0pt;color:#632423'> <param
type="today" offset="-30" name="LASTTHIRTY"
format="%4Y%2M%2D" /></span><o:p></o:p></p>
<p><b><span style='font-size:9.0pt;color:#632423'> <param
type="today" offset="-14" name="LASTTWOWEEKS"
format="%4Y%2M%2D" /></span></b><o:p></o:p></p>
<p><b><span style='font-size:9.0pt;color:#632423'> <param
type="today" offset="-7" name="LASTWEEK"
format="%4Y%2M%2D" /></span></b><o:p></o:p></p>
<p><span style='font-size:9.0pt;color:#632423'> <param
type="today" offset="0" name="TODAY"
format="%4Y%2M%2D" /></span><o:p></o:p></p>
<div>
<p><span style='font-size:9.0pt;color:#632423'> <layer
name="Burglaries"/></span><o:p></o:p></p>
<p><span style='font-size:9.0pt;color:#632423'> </map-source></span><o:p></o:p></p>
<p><span style='font-size:9.0pt;color:#632423'> </span><o:p></o:p></p>
</div>
<p><b><span style='font-size:9.0pt;color:black'>.MAP file</span></b><o:p></o:p></p>
<p><span style='font-size:9.0pt;color:#632423'>CLASS</span><o:p></o:p></p>
<p><span style='font-size:9.0pt;color:#632423'>
NAME 'Last Weeks'</span><o:p></o:p></p>
<p><span style='font-size:9.0pt;color:#632423'>
EXPRESSION ('[IncidentDa]' > '%LASTTWOWEEKS%' && '[IncidentDa]' <
'%LASTWEEK%')</span><o:p></o:p></p>
<div>
<p><span style='font-size:9.0pt;color:#632423'>
STYLE</span><o:p></o:p></p>
<p><span style='font-size:9.0pt;color:#632423'>
COLOR 0 100 50 </span><o:p></o:p></p>
<p><span style='font-size:9.0pt;color:#632423'>
SYMBOL "bike" </span><o:p></o:p></p>
<p><span style='font-size:9.0pt;color:#632423'>
SIZE 12</span><o:p></o:p></p>
<p><span style='font-size:9.0pt;color:#632423'>
END </span><o:p></o:p></p>
<p><span style='font-size:9.0pt;color:#632423'>END</span><o:p></o:p></p>
<p> <o:p></o:p></p>
</div>
<p>=======================================<o:p></o:p></p>
<p> <o:p></o:p></p>
<p>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></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
text-autospace:none'><span style='font-size:9.0pt;font-family:Consolas;
color:#632423'>CLASS</span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
text-autospace:none'><span style='font-size:9.0pt;font-family:Consolas;
color:#632423'> NAME 'Last Weeks'</span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
text-autospace:none'><span style='font-size:9.0pt;font-family:Consolas;
color:#632423'> EXPRESSION ('[IncidentDa]'
> '%LASTWEEK%’)</span><o:p></o:p></p>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
text-autospace:none'><span style='font-size:9.0pt;font-family:Consolas;
color:#632423'> STYLE</span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
text-autospace:none'><span style='font-size:9.0pt;font-family:Consolas;
color:#632423'>
COLOR 0 0 0 </span><o:p></o:p></p>
</div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
text-autospace:none'><span style='font-size:9.0pt;font-family:Consolas;
color:#632423'>
SYMBOL "tent" </span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
text-autospace:none'><span style='font-size:9.0pt;font-family:Consolas;
color:#632423'>
SIZE 12</span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
text-indent:.5in;text-autospace:none'><span style='font-size:9.0pt;font-family:
Consolas;color:#632423'>END </span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
text-autospace:none'><span style='font-size:9.0pt;font-family:Consolas;
color:#632423'>#END</span><o:p></o:p></p>
<div>
<div>
<p> <o:p></o:p></p>
<p> <o:p></o:p></p>
<p>-----Original Message-----<br>
From: <a href="mailto:mapserver-users-bounces@lists.osgeo.org" target="_blank">mapserver-users-bounces@lists.osgeo.org</a>
[mailto:<a href="mailto:mapserver-users-bounces@lists.osgeo.org" target="_blank">mapserver-users-bounces@lists.osgeo.org</a>]
On Behalf Of Stephen Woodbridge<br>
Sent: Wednesday, September 29, 2010 8:19 AM<br>
To: <a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br>
Subject: Re: [mapserver-users] Expressions<o:p></o:p></p>
<p> <o:p></o:p></p>
<p>In EXPRESSIONS you can evaluate any of the following:<o:p></o:p></p>
<p> <o:p></o:p></p>
<p>1. Regular expressions treating the value as a string<o:p></o:p></p>
<p>2. numeric expressions using booleans like ==,<,>,<=,>=<o:p></o:p></p>
<p>3. string expressions like ==, !=, and I think strlen()<o:p></o:p></p>
<p> <o:p></o:p></p>
<p>So if you converted you dates into a format like YYYYMMDD then it would <o:p></o:p></p>
<p>be easy to use a numeric expression like:<o:p></o:p></p>
<p> <o:p></o:p></p>
<p>EXPRESSION ('[dateValues]' > '%STARTDATE%' && '[dateValues]' <
'%ENDDATE%')<o:p></o:p></p>
<p> <o:p></o:p></p>
<p>or<o:p></o:p></p>
<p> <o:p></o:p></p>
<p>EXPRESSION ('[dateValues]' > '%STARTDATE%')<o:p></o:p></p>
<p> <o:p></o:p></p>
<p>where STARTDATE is the YYYYMMDD value of two weeks ago and ENDDATE would <o:p></o:p></p>
<p>be in the same format and allow you to extract record betwee any two <o:p></o:p></p>
<p>start and end dates.<o:p></o:p></p>
<p> <o:p></o:p></p>
<p>Or you might be able to figure out a complex regular expression the <o:p></o:p></p>
<p>represents the last two weeks like:<o:p></o:p></p>
<p> <o:p></o:p></p>
<p>EXPRESSION ('[dateValues]' =~ '/%LASTTWOWEEKS%/')<o:p></o:p></p>
<p> <o:p></o:p></p>
<p>I'm not sure what you would need for the regular expression.<o:p></o:p></p>
<p> <o:p></o:p></p>
<p>-Steve W<o:p></o:p></p>
<p> <o:p></o:p></p>
<p>On 9/28/2010 4:23 PM, Jay Kapalczynski wrote:<o:p></o:p></p>
<p>> Anyone have anymore ideas about this….<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> I have a string field with values<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> And the code below. The expression does not seem to be running…if
I only<o:p></o:p></p>
<p>> use LASTTWOWEEKS it still draws all the points….and I know there
are<o:p></o:p></p>
<p>> values in there from 2008<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> Thanks<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> *From:* <a href="mailto:mapserver-users-bounces@lists.osgeo.org"
target="_blank">mapserver-users-bounces@lists.osgeo.org</a><o:p></o:p></p>
<p>> [mailto:<a href="mailto:mapserver-users-bounces@lists.osgeo.org"
target="_blank">mapserver-users-bounces@lists.osgeo.org</a>] *On Behalf Of *Jay<o:p></o:p></p>
<p>> Kapalczynski<o:p></o:p></p>
<p>> *Sent:* Tuesday, September 21, 2010 9:51 AM<o:p></o:p></p>
<p>> *To:* 'Bob Basques'; <a href="mailto:mapserver-users@lists.osgeo.org"
target="_blank">mapserver-users@lists.osgeo.org</a><o:p></o:p></p>
<p>> *Subject:* RE: [mapserver-users] Expressions<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> My major question is can I do this with a String/text field? Its the<o:p></o:p></p>
<p>> only way I can see keeping things in a %2Y%2M%2D format ex. 092110
(Sept<o:p></o:p></p>
<p>> 21^st 2010), otherwise the 0 will get removed in a numeric field<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> Can I use the format Year, Month, Day? Or do I have to use Month, Day,
Year?<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> In this example I eliminated two expressions and focused on one<o:p></o:p></p>
<p>> Expression to see if it is working.<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> *_I kept this_*<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> <map-source name="Burglaries"
type="mapserver"><o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> <file>./maple_grove_datasets/police/Burglaries.map</file><o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> <param type="today" offset="-7"
name="LASTWEEK" format="%2Y%2M%2D" /><o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> <param type="today" offset="-14"
name="LASTTWOWEEKS" format="%2Y%2M%2D" /><o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> <param type="today" offset="-30"
name="LASTTHIRTY" format="%2Y%2M%2D" /><o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> <param type="today" offset="-90"
name="LASTNINTY" format="%2Y%2M%2D" /><o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> <layer name="Burglaries"/><o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> </map-source><o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> *_In my map file I used _**_ONLY_**_ this_*<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> CLASS<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> NAME 'Last Weeks'<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> EXPRESSION ('[dateValues]' > '%LASTTWOWEEKS%')<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> STYLE<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> COLOR 0 100 50<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> SYMBOL "bike"<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> SIZE 12<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> END<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> END<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> Now in my data I have these values (below), although every symbol was<o:p></o:p></p>
<p>> displayed in the map<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> NOTE THIS IS A TEXT FIELD<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> 081204, 081225,090118<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> These values (above) for the Year, Month, Day format specified in the<o:p></o:p></p>
<p>> map source are clearly less than the “last two weeks”,
Where as they are<o:p></o:p></p>
<p>> older than the last 14 days….so none of them should show up, but
they do<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> Any thoughts<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> *From:* <a href="mailto:mapserver-users-bounces@lists.osgeo.org"
target="_blank">mapserver-users-bounces@lists.osgeo.org</a><o:p></o:p></p>
<p>> [mailto:<a href="mailto:mapserver-users-bounces@lists.osgeo.org"
target="_blank">mapserver-users-bounces@lists.osgeo.org</a>] *On Behalf Of *Bob
Basques<o:p></o:p></p>
<p>> *Sent:* Friday, September 17, 2010 9:25 PM<o:p></o:p></p>
<p>> *To:* <a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><o:p></o:p></p>
<p>> *Subject:* Re: [mapserver-users] Expressions<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> A first stab at seeing more than one class, might be to try and switch<o:p></o:p></p>
<p>> them around order wise, one filter may be overwriting the other for
example.<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> bobb<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> On 9/17/2010 8:20 AM, Jay Kapalczynski wrote:<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> I am using GeoMoose but feel this is more a question for Map Server.<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> I am trying to sort my points by dates using the code below….I
think<o:p></o:p></p>
<p>> that I can do this but not sure<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> Is this a viable format “2Y%2M%2D” ?<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> As for the field in the shapefile…If I use an integer it removes
the 0<o:p></o:p></p>
<p>> from the 092110, (sept 21^st 2010)<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> If I use a date then there are “/” … 9/21/10<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> The only way I can see this happening is using a text field with
retains<o:p></o:p></p>
<p>> the 0 in 092110<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> When I use the textfield “dateValues” as seen below I can
get the stars<o:p></o:p></p>
<p>> to draw but only the LASTWEEK…for some reason the LASTTWOWEEKS
does not<o:p></o:p></p>
<p>> show and I know that I have a few records with dates in the last 14
days…<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> Thoughts?<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> THANKS….all your help is very appreciated….<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> Main .xml file<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> <map-source name="Burglaries"
type="mapserver"><o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> <file>./maple_grove_datasets/police/Burglaries.map</file><o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> <param type="today" offset="-7"
name="LASTWEEK" format="%2Y%2M%2D" /><o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> <param type="today" offset="-14"
name="LASTTWOWEEKS" format="%2Y%2M%2D" /><o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> <param type="today" offset="-30"
name="LASTTHIRTY" format="%2Y%2M%2D" /><o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> <param type="today" offset="-90"
name="LASTNINTY" format="%2Y%2M%2D" /><o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> <layer name="Burglaries"/><o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> </map-source><o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> .map file<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> CLASS<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> NAME 'Last Weeks'<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> EXPRESSION ('[dateValues]' > '%LASTWEEK%')<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> STYLE<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> COLOR 0 0 0<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> SYMBOL "star"<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> SIZE 12<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> END<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> END<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> CLASS<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> NAME 'Last Two Weeks'<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> EXPRESSION ('[dateValues]' > '%LASTTWOWEEKS%')<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> STYLE<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> COLOR 0 100 50<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> SYMBOL "star"<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> SIZE 12<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> END<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> END<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> _______________________________________________<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> mapserver-users mailing list<o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> <a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>
<mailto:<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>><o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> <a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users"
target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> <o:p></o:p></p>
<p>> _______________________________________________<o:p></o:p></p>
<p>> mapserver-users mailing list<o:p></o:p></p>
<p>> <a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><o:p></o:p></p>
<p>> <a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users"
target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><o:p></o:p></p>
<p> <o:p></o:p></p>
<p>_______________________________________________<o:p></o:p></p>
<p>mapserver-users mailing list<o:p></o:p></p>
<p><a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><o:p></o:p></p>
<p><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users"
target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><o:p></o:p></p>
</div>
</div>
</div>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><br>
_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users"
target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><o:p></o:p></p>
</div>
<p class=MsoNormal><br>
<br clear=all>
<br>
-- <br>
************************************<br>
David William Bitner<o:p></o:p></p>
</div>
</div>
</body>
</html>