RE: [mapserver-users] Expressions
I changed the format to and using another field ('GEO_TIME' - still numeric)
param type=today offset=-14 name=LASTTWOWEEKS format=%2Y%2M%2D /
Instead of:
param type=today offset=-14 name=LASTTWOWEEKS format=%4Y%2M%2D /
This worked
EXPRESSION ([GEO_TIME] 100916)THIS DRAWS THE CORRECT 5 POINTS
ONLY
EXPRESSION ([GEO_TIME] 090110)THIS DRAWS ALL THE POINTS,
WHICH IS CORRECT... all are than this date
I then tried WITH NO SUCCESS
EXPRESSION ([GEO_TIME] '%LASTTWOWEEKS%') nothing
EXPRESSION ([GEO_TIME] %LASTTWOWEEKS%)nothing
EXPRESSION ([GEO_TIME] LASTTWOWEEKS) nothing
EXPRESSION ('[GEO_TIME]' '%LASTTWOWEEKS%')THIS DRAWS ALL THE POINTS
EXPRESSION ('[GEO_TIME]' %LASTTWOWEEKS%) nothing
EXPRESSION ('[GEO_TIME]' LASTTWOWEEKS)nothing
The crazy thing is that I have this working on GEOMOOSE v1.6 on an XP 32 bit
boxSAME CODE, SAME DATASET..SOMETHING WITH GEOMOOSE 2?
With something like this
EXPRESSION ('[GEO_SIMPLE]' = 'BURGLARY' AND '[GEO_TIME]' '%LASTWEEK%')
-Original Message-
From: Stephen Woodbridge [mailto:wood...@swoodbridge.com]
Sent: Wednesday, September 29, 2010 12:51 PM
To: Jay Kapalczynski
Cc: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] Expressions
First lets get rid of the parameter substitution to make sure we have a
syntax correct. So in your mapfile try:
EXPRESSION ([IncidentDa] 20100816)
I set this to Aug 16th to see if you can pull any records. Also because
this is numeric, I removed the quotes. You can also try it with quotes
to see what works.
If this works then try:
EXPRESSION ([IncidentDa] %LASTTWOWEEKS%)
Again without the quotes or with depending on what worked.
-Steve W
On 9/29/2010 11:49 AM, Jay Kapalczynski wrote:
I thank you for your responsegreatly appreciated as I cannot figure
this out
I know that I have 4 features in the dataset that have a value of
20100916 that's 13 days agoso with the expression below those 4 or 5
features should show upbut nothing shows up
IncidentDa is the field (long integer)
Param type is specifying MMDD my data has values of 20100916 (13 days)
I have no idea what could be wrong...Thank you all for your help
*.XML file*
map-source name=Burglaries type=mapserver
file./maple_grove_datasets/police/Burglaries.map/file
param type=today offset=-90 name=LASTNINTY format=%4Y%2M%2D /
param type=today offset=-30 name=LASTTHIRTY format=%4Y%2M%2D /
* param type=today offset=-14 name=LASTTWOWEEKS
format=%4Y%2M%2D /*
* param type=today offset=-7 name=LASTWEEK format=%4Y%2M%2D /*
param type=today offset=0 name=TODAY format=%4Y%2M%2D /
layer name=Burglaries/
/map-source
*.MAP file*
CLASS
NAME 'Last Weeks'
EXPRESSION ('[IncidentDa]' '%LASTTWOWEEKS%' '[IncidentDa]'
'%LASTWEEK%')
STYLE
COLOR 0 100 50
SYMBOL bike
SIZE 12
END
END
===
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.
CLASS
NAME 'Last Weeks'
EXPRESSION ('[IncidentDa]' '%LASTWEEK%')
STYLE
COLOR 0 0 0
SYMBOL tent
SIZE 12
END
#END
-Original Message-
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Stephen
Woodbridge
Sent: Wednesday, September 29, 2010 8:19 AM
To: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] Expressions
In EXPRESSIONS you can evaluate any of the following:
1. Regular expressions treating the value as a string
2. numeric expressions using booleans like ==,,,=,=
3. string expressions like ==, !=, and I think strlen()
So if you converted you dates into a format like MMDD then it would
be easy to use a numeric expression like:
EXPRESSION ('[dateValues]' '%STARTDATE%' '[dateValues]' '%ENDDATE%')
or
EXPRESSION ('[dateValues]' '%STARTDATE%')
where STARTDATE is the MMDD value of two weeks ago and ENDDATE would
be in the same format and allow you to extract record betwee any two
start and end dates.
Or you might be able to figure out a complex regular expression the
represents the last two weeks like:
EXPRESSION ('[dateValues]' =~ '/%LASTTWOWEEKS%/')
I'm not sure what you would need for the regular expression.
-Steve W
On 9/28/2010 4:23 PM, Jay Kapalczynski wrote:
Anyone have anymore ideas about this
I have a string field with values
And the code below. The expression does not seem to be running...if I only
use LASTTWOWEEKS it still draws all the pointsand I know there are
values in there from 2008
Thanks
*From:* mapserver-users-boun
RE: [mapserver-users] Expressions
Anyone have anymore ideas about this
I have a string field with values
And the code below. The expression does not seem to be running...if I only use
LASTTWOWEEKS it still draws all the pointsand I know there are values in
there from 2008
Thanks
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Jay Kapalczynski
Sent: Tuesday, September 21, 2010 9:51 AM
To: 'Bob Basques'; mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] Expressions
My major question is can I do this with a String/text field? Its the only way
I can see keeping things in a %2Y%2M%2D format ex. 092110 (Sept 21st 2010),
otherwise the 0 will get removed in a numeric field
Can I use the format Year, Month, Day? Or do I have to use Month, Day, Year?
In this example I eliminated two expressions and focused on one Expression to
see if it is working.
I kept this
map-source name=Burglaries type=mapserver
file./maple_grove_datasets/police/Burglaries.map/file
param type=today offset=-7 name=LASTWEEK format=%2Y%2M%2D /
param type=today offset=-14 name=LASTTWOWEEKS format=%2Y%2M%2D /
param type=today offset=-30 name=LASTTHIRTY format=%2Y%2M%2D /
param type=today offset=-90 name=LASTNINTY format=%2Y%2M%2D /
layer name=Burglaries/
/map-source
In my map file I used ONLY this
CLASS
NAME 'Last Weeks'
EXPRESSION ('[dateValues]' '%LASTTWOWEEKS%')
STYLE
COLOR 0 100 50
SYMBOL bike
SIZE 12
END
END
Now in my data I have these values (below), although every symbol was displayed
in the map
NOTE THIS IS A TEXT FIELD
081204, 081225,090118
These values (above) for the Year, Month, Day format specified in the map
source are clearly less than the last two weeks, Where as they are older than
the last 14 daysso none of them should show up, but they do
Any thoughts
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Bob Basques
Sent: Friday, September 17, 2010 9:25 PM
To: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] Expressions
A first stab at seeing more than one class, might be to try and switch them
around order wise, one filter may be overwriting the other for example.
bobb
On 9/17/2010 8:20 AM, Jay Kapalczynski wrote:
I am using GeoMoose but feel this is more a question for Map Server.
I am trying to sort my points by dates using the code belowI think that I
can do this but not sure
Is this a viable format 2Y%2M%2D ?
As for the field in the shapefile...If I use an integer it removes the 0 from
the 092110, (sept 21st 2010)
If I use a date then there are / ... 9/21/10
The only way I can see this happening is using a text field with retains the 0
in 092110
When I use the textfield dateValues as seen below I can get the stars to draw
but only the LASTWEEK...for some reason the LASTTWOWEEKS does not show and I
know that I have a few records with dates in the last 14 days...
Thoughts?
THANKSall your help is very appreciated
Main .xml file
map-source name=Burglaries type=mapserver
file./maple_grove_datasets/police/Burglaries.map/file
param type=today offset=-7 name=LASTWEEK format=%2Y%2M%2D /
param type=today offset=-14 name=LASTTWOWEEKS format=%2Y%2M%2D /
param type=today offset=-30 name=LASTTHIRTY format=%2Y%2M%2D /
param type=today offset=-90 name=LASTNINTY format=%2Y%2M%2D /
layer name=Burglaries/
/map-source
.map file
CLASS
NAME 'Last Weeks'
EXPRESSION ('[dateValues]' '%LASTWEEK%')
STYLE
COLOR 0 0 0
SYMBOL star
SIZE 12
END
END
CLASS
NAME 'Last Two Weeks'
EXPRESSION ('[dateValues]' '%LASTTWOWEEKS%')
STYLE
COLOR 0 100 50
SYMBOL star
SIZE 12
END
END
___
mapserver-users mailing list
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] Expressions
I thank you for your responsegreatly appreciated as I cannot figure this
out
I know that I have 4 features in the dataset that have a value of 20100916
that's 13 days agoso with the expression below those 4 or 5 features should
show upbut nothing shows up
IncidentDa is the field (long integer)
Param type is specifying MMDD my data has values of 20100916 (13 days)
I have no idea what could be wrong...Thank you all for your help
.XML file
map-source name=Burglaries type=mapserver
file./maple_grove_datasets/police/Burglaries.map/file
param type=today offset=-90 name=LASTNINTY format=%4Y%2M%2D /
param type=today offset=-30 name=LASTTHIRTY format=%4Y%2M%2D /
param type=today offset=-14 name=LASTTWOWEEKS format=%4Y%2M%2D /
param type=today offset=-7 name=LASTWEEK format=%4Y%2M%2D /
param type=today offset=0 name=TODAY format=%4Y%2M%2D /
layer name=Burglaries/
/map-source
.MAP file
CLASS
NAME 'Last Weeks'
EXPRESSION ('[IncidentDa]' '%LASTTWOWEEKS%' '[IncidentDa]'
'%LASTWEEK%')
STYLE
COLOR 0 100 50
SYMBOL bike
SIZE 12
END
END
===
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.
CLASS
NAME 'Last Weeks'
EXPRESSION ('[IncidentDa]' '%LASTWEEK%')
STYLE
COLOR 0 0 0
SYMBOL tent
SIZE 12
END
#END
-Original Message-
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Stephen Woodbridge
Sent: Wednesday, September 29, 2010 8:19 AM
To: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] Expressions
In EXPRESSIONS you can evaluate any of the following:
1. Regular expressions treating the value as a string
2. numeric expressions using booleans like ==,,,=,=
3. string expressions like ==, !=, and I think strlen()
So if you converted you dates into a format like MMDD then it would
be easy to use a numeric expression like:
EXPRESSION ('[dateValues]' '%STARTDATE%' '[dateValues]' '%ENDDATE%')
or
EXPRESSION ('[dateValues]' '%STARTDATE%')
where STARTDATE is the MMDD value of two weeks ago and ENDDATE would
be in the same format and allow you to extract record betwee any two
start and end dates.
Or you might be able to figure out a complex regular expression the
represents the last two weeks like:
EXPRESSION ('[dateValues]' =~ '/%LASTTWOWEEKS%/')
I'm not sure what you would need for the regular expression.
-Steve W
On 9/28/2010 4:23 PM, Jay Kapalczynski wrote:
Anyone have anymore ideas about this
I have a string field with values
And the code below. The expression does not seem to be running...if I only
use LASTTWOWEEKS it still draws all the pointsand I know there are
values in there from 2008
Thanks
*From:* mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] *On Behalf Of *Jay
Kapalczynski
*Sent:* Tuesday, September 21, 2010 9:51 AM
*To:* 'Bob Basques'; mapserver-users@lists.osgeo.org
*Subject:* RE: [mapserver-users] Expressions
My major question is can I do this with a String/text field? Its the
only way I can see keeping things in a %2Y%2M%2D format ex. 092110 (Sept
21^st 2010), otherwise the 0 will get removed in a numeric field
Can I use the format Year, Month, Day? Or do I have to use Month, Day, Year?
In this example I eliminated two expressions and focused on one
Expression to see if it is working.
*_I kept this_*
map-source name=Burglaries type=mapserver
file./maple_grove_datasets/police/Burglaries.map/file
param type=today offset=-7 name=LASTWEEK format=%2Y%2M%2D /
param type=today offset=-14 name=LASTTWOWEEKS format=%2Y%2M%2D /
param type=today offset=-30 name=LASTTHIRTY format=%2Y%2M%2D /
param type=today offset=-90 name=LASTNINTY format=%2Y%2M%2D /
layer name=Burglaries/
/map-source
*_In my map file I used _**_ONLY_**_ this_*
CLASS
NAME 'Last Weeks'
EXPRESSION ('[dateValues]' '%LASTTWOWEEKS%')
STYLE
COLOR 0 100 50
SYMBOL bike
SIZE 12
END
END
Now in my data I have these values (below), although every symbol was
displayed in the map
NOTE THIS IS A TEXT FIELD
081204, 081225,090118
These values (above) for the Year, Month, Day format specified in the
map source are clearly less than the last two weeks, Where as they are
older than the last 14 daysso none of them should show up, but they do
Any thoughts
*From:* mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] *On Behalf Of *Bob Basques
*Sent:* Friday, September 17, 2010 9:25 PM
*To:* mapserver-users@lists.osgeo.org
*Subject:* Re: [mapserver
RE: [mapserver-users] Expressions
Yea I have firebugbut while in the console nothing appears when you turn on
a layer or turn one off
And the response tab simply displays the .xml file
I cant see where to go to see the effect the expression is having
I really appreciate this all
Can any of my issues be related to Windows 7 64 bit computer?
From: david.bit...@gmail.com [mailto:david.bit...@gmail.com] On Behalf Of David
William Bitner
Sent: Wednesday, September 29, 2010 11:03 AM
To: Jay Kapalczynski
Cc: Stephen Woodbridge; mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] Expressions
Jay,
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=.
David
On Wed, Sep 29, 2010 at 10:49 AM, Jay Kapalczynski
jkapalczyn...@ci.maple-grove.mn.usmailto:jkapalczyn...@ci.maple-grove.mn.us
wrote:
I thank you for your responsegreatly appreciated as I cannot figure this
out
I know that I have 4 features in the dataset that have a value of 20100916
that's 13 days agoso with the expression below those 4 or 5 features should
show upbut nothing shows up
IncidentDa is the field (long integer)
Param type is specifying MMDD my data has values of 20100916 (13 days)
I have no idea what could be wrong...Thank you all for your help
.XML file
map-source name=Burglaries type=mapserver
file./maple_grove_datasets/police/Burglaries.map/file
param type=today offset=-90 name=LASTNINTY format=%4Y%2M%2D /
param type=today offset=-30 name=LASTTHIRTY format=%4Y%2M%2D /
param type=today offset=-14 name=LASTTWOWEEKS format=%4Y%2M%2D /
param type=today offset=-7 name=LASTWEEK format=%4Y%2M%2D /
param type=today offset=0 name=TODAY format=%4Y%2M%2D /
layer name=Burglaries/
/map-source
.MAP file
CLASS
NAME 'Last Weeks'
EXPRESSION ('[IncidentDa]' '%LASTTWOWEEKS%' '[IncidentDa]'
'%LASTWEEK%')
STYLE
COLOR 0 100 50
SYMBOL bike
SIZE 12
END
END
===
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.
CLASS
NAME 'Last Weeks'
EXPRESSION ('[IncidentDa]' '%LASTWEEK%')
STYLE
COLOR 0 0 0
SYMBOL tent
SIZE 12
END
#END
-Original Message-
From:
mapserver-users-boun...@lists.osgeo.orgmailto:mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.orgmailto:mapserver-users-boun...@lists.osgeo.org]
On Behalf Of Stephen Woodbridge
Sent: Wednesday, September 29, 2010 8:19 AM
To: mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] Expressions
In EXPRESSIONS you can evaluate any of the following:
1. Regular expressions treating the value as a string
2. numeric expressions using booleans like ==,,,=,=
3. string expressions like ==, !=, and I think strlen()
So if you converted you dates into a format like MMDD then it would
be easy to use a numeric expression like:
EXPRESSION ('[dateValues]' '%STARTDATE%' '[dateValues]' '%ENDDATE%')
or
EXPRESSION ('[dateValues]' '%STARTDATE%')
where STARTDATE is the MMDD value of two weeks ago and ENDDATE would
be in the same format and allow you to extract record betwee any two
start and end dates.
Or you might be able to figure out a complex regular expression the
represents the last two weeks like:
EXPRESSION ('[dateValues]' =~ '/%LASTTWOWEEKS%/')
I'm not sure what you would need for the regular expression.
-Steve W
On 9/28/2010 4:23 PM, Jay Kapalczynski wrote:
Anyone have anymore ideas about this
I have a string field with values
And the code below. The expression does not seem to be running...if I only
use LASTTWOWEEKS it still draws all the pointsand I know there are
values in there from 2008
Thanks
*From:*
mapserver-users-boun...@lists.osgeo.orgmailto:mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.orgmailto:mapserver-users-boun...@lists.osgeo.org]
*On Behalf Of *Jay
Kapalczynski
*Sent:* Tuesday, September 21, 2010 9:51 AM
*To:* 'Bob Basques';
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
*Subject:* RE: [mapserver-users] Expressions
My major question is can I do this with a String/text field? Its the
only way I can see keeping things in a %2Y%2M%2D format ex. 092110 (Sept
21^st 2010), otherwise the 0 will get removed in a numeric field
[mapserver-users] ODBC connections 32 vs 64 bit
Question: I am trying to connect to a MDB on a local driveeverything testing on my local computer. I have a 64 bit windows 7 machine There are two locations to create ODBC connections: This article says a bit http://support.microsoft.com/kb/942976 32 bit \Windows\SysWoW64\odbcad32.exe 64 bit \Windows\System32\odbcad32.exe Does it matter if the ODBC connection is done on 32 or 64 bit? Is there a difference? When I try and create an ODBC connection on 64 bit there are no drivers displayed? Very confusing Thoughts? Thanks ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] Symbology
Thank you all for your help here….and I am quite embarrassed as to my solution…and more importantly sorry to take up your time, although I did learn a few things. I moved everything into the map section and created a Symbol folder to hold the images and .sym files. I placed the png in the map folder (as requested by David) And it still didn’t work…looking closer I realized that the symbol name was “bike” although the image name was “bikes” one stupid ‘s’ and this results. Although your help allowed me to move the files into the correct location, understand the connection between map file and sym file and images etc. I thank you for all your help..much appreciated From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Fawcett, David (MPCA) Sent: Tuesday, September 21, 2010 9:20 AM To: mapserver-users@lists.osgeo.org Subject: FW: [mapserver-users] Symbology Apologies for the dup, my original response got embargoed due to the large image included… From: Fawcett, David (MPCA) Sent: Tuesday, September 21, 2010 9:13 AM To: 'Jay Kapalczynski'; 'Bob Basques'; mapserver-users@lists.osgeo.org; 'adams' Subject: RE: [mapserver-users] Symbology I think that someone else pointed out that the path to your symbol image is relative to the location of your map file. A quick test would be to drop bike.png in the same folder as your map file. Looking at your dir tree, I would move your symbol stuff out of the htdocs branch and into the area where your map files are. David. From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Jay Kapalczynski Sent: Tuesday, September 21, 2010 8:53 AM To: 'Bob Basques'; mapserver-users@lists.osgeo.org; 'adams' Subject: RE: [mapserver-users] Symbology I added a few things to my sym file and got a few to work I can now call circle and get a circle….BUT for some reason the image will not work, maybe an issue with the image? You have any test images that are known to work? I have the image like this IMAGE 'bike.png' because the images are in the same folder as the .sym file Any other thoughts….greatly appreciated….thanks THIS WORKS CLASS NAME 'Last Week' STYLE SYMBOL circle COLOR 0 0 0 OUTLINECOLOR 0 0 0 #SIZE 12 END # STYLE END # CLASS THIS DOES NOT WORK CLASS NAME 'Last Week' STYLE SYMBOL bike COLOR 0 0 0 OUTLINECOLOR 0 0 0 #SIZE 12 END # STYLE END # CLASS .SYM FILE Symbol Name 'circle' Type ELLIPSE FILLED TRUE Points 1 1 END END SYMBOL NAME 'circle-dashed' TYPE ELLIPSE FILLED TRUE POINTS 1 1 END STYLE 5 5 END END SYMBOL NAME 'bike' TYPE pixmap IMAGE 'bike.png' END ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] Expressions
My major question is can I do this with a String/text field? Its the only way
I can see keeping things in a %2Y%2M%2D format ex. 092110 (Sept 21st 2010),
otherwise the 0 will get removed in a numeric field
Can I use the format Year, Month, Day? Or do I have to use Month, Day, Year?
In this example I eliminated two expressions and focused on one Expression to
see if it is working.
I kept this
map-source name=Burglaries type=mapserver
file./maple_grove_datasets/police/Burglaries.map/file
param type=today offset=-7 name=LASTWEEK format=%2Y%2M%2D /
param type=today offset=-14 name=LASTTWOWEEKS format=%2Y%2M%2D /
param type=today offset=-30 name=LASTTHIRTY format=%2Y%2M%2D /
param type=today offset=-90 name=LASTNINTY format=%2Y%2M%2D /
layer name=Burglaries/
/map-source
In my map file I used ONLY this
CLASS
NAME 'Last Weeks'
EXPRESSION ('[dateValues]' '%LASTTWOWEEKS%')
STYLE
COLOR 0 100 50
SYMBOL bike
SIZE 12
END
END
Now in my data I have these values (below), although every symbol was displayed
in the map
NOTE THIS IS A TEXT FIELD
081204, 081225,090118
These values (above) for the Year, Month, Day format specified in the map
source are clearly less than the last two weeks, Where as they are older than
the last 14 daysso none of them should show up, but they do
Any thoughts
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Bob Basques
Sent: Friday, September 17, 2010 9:25 PM
To: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] Expressions
A first stab at seeing more than one class, might be to try and switch them
around order wise, one filter may be overwriting the other for example.
bobb
On 9/17/2010 8:20 AM, Jay Kapalczynski wrote:
I am using GeoMoose but feel this is more a question for Map Server.
I am trying to sort my points by dates using the code belowI think that I
can do this but not sure
Is this a viable format 2Y%2M%2D ?
As for the field in the shapefile...If I use an integer it removes the 0 from
the 092110, (sept 21st 2010)
If I use a date then there are / ... 9/21/10
The only way I can see this happening is using a text field with retains the 0
in 092110
When I use the textfield dateValues as seen below I can get the stars to draw
but only the LASTWEEK...for some reason the LASTTWOWEEKS does not show and I
know that I have a few records with dates in the last 14 days...
Thoughts?
THANKSall your help is very appreciated
Main .xml file
map-source name=Burglaries type=mapserver
file./maple_grove_datasets/police/Burglaries.map/file
param type=today offset=-7 name=LASTWEEK format=%2Y%2M%2D /
param type=today offset=-14 name=LASTTWOWEEKS format=%2Y%2M%2D /
param type=today offset=-30 name=LASTTHIRTY format=%2Y%2M%2D /
param type=today offset=-90 name=LASTNINTY format=%2Y%2M%2D /
layer name=Burglaries/
/map-source
.map file
CLASS
NAME 'Last Weeks'
EXPRESSION ('[dateValues]' '%LASTWEEK%')
STYLE
COLOR 0 0 0
SYMBOL star
SIZE 12
END
END
CLASS
NAME 'Last Two Weeks'
EXPRESSION ('[dateValues]' '%LASTTWOWEEKS%')
STYLE
COLOR 0 100 50
SYMBOL star
SIZE 12
END
END
___
mapserver-users mailing list
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] Symbology
This is what I am trying...when I turn on the layer it all goes pink...so something is not correct I have to move back 3 folders and go into the one housing the sym file The images are in the sym file folder in their own file [cid:image001.jpg@01CB558F.F564F670] MAP FILE PROJECTION 'init=epsg:26915' END LEGEND STATUS ON LABEL TYPE TRUETYPE FONT vera_sans SIZE 8 COLOR 0 0 0 END END SYMBOLSET ../../../htdocs/symbolsets/symbolset.sym LAYER NAME Burglaries DATA './Burglaries.shp' STATUS ON TYPE POINT CLASS NAME 'Last Weeks' STYLE SYMBOL bike COLOR 0 0 0 OUTLINECOLOR 0 0 0 END END SYMBOL FILE SYMBOLSET SYMBOL NAME 'bike' TYPE pixmap IMAGE '/symbol_images/bike.png' TRANSPARENT 2 END SYMBOL NAME 'church' TYPE pixmap IMAGE '/symbol_images/church.png' TRANSPARENT 5 END Folder structure: Ms4w Apps maplegrove Htdocs Symbolset folder .sym file maps maple_grove police .map files ... ... ... From: Smith, Michael D ERDC-CRREL-NH [mailto:michael.sm...@usace.army.mil] Sent: Thursday, September 16, 2010 10:26 AM To: Jay Kapalczynski; 'Fawcett, David (MPCA)'; 'Michael Schulz' Cc: mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] Symbology Jay, A couple of additional steps. 1). Add SYMBOLSET as the first line in your symbol file 2). In the mapfile, in the MAP section add a line SYMBOLSET /path/to/symbolset_file Mike -- Michael Smith Remote Sensing/GIS Center US Army Corps of Engineers Hanover, NH On 9/16/10 11:20 AM, Jay Kapalczynski jkapalczyn...@ci.maple-grove.mn.us wrote: Thanks guys for your thoughts...still green to this and trying to learn I would make real sense to me to create the .sym file where I would not have to redefine the particular symbol sets DO I HAVE THIS RIGHT? 1. BUT how do I define the symbol set or point to the .sym file from the map file ? SYMBOL FILE: So in the Symbol file I would have this (example of two of them) SYMBOL NAME 'bike' TYPE pixmap IMAGE '/home/mapserv/proj/pmap/bike.png' TRANSPARENT 2 END SYMBOL NAME 'church' TYPE pixmap IMAGE '/home/mapserv/proj/pmap/church.png' TRANSPARENT 5 END MAP FILE: I would simply call them? CLASS STYLE SYMBOL bike COLOR 0 0 0 OUTLINECOLOR 0 0 0 END END -Original Message- From: Fawcett, David (MPCA) [mailto:david.fawc...@state.mn.us] Sent: Thursday, September 16, 2010 9:50 AM To: Jay Kapalczynski; 'Michael Schulz' Cc: mapserver-users@lists.osgeo.org Subject: RE: [mapserver-users] Symbology You can put the symbol definition in your map file, or in a symbols file (e.g. symbols.sym) and then set SYMBOLSET at the MAP level to point to your symbols.sym file. David. -Original Message- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Jay Kapalczynski Sent: Thursday, September 16, 2010 9:45 AM To: 'Michael Schulz' Cc: mapserver-users@lists.osgeo.org Subject: RE: [mapserver-users] Symbology Ok that seems to make sense...but where do I place the image SYMBOL (your example below)? DO I place that in the map file as well? Little confused there Thanks Michael and Adam for your return replys. -Original Message- From: mandsch...@googlemail.com [mailto:mandsch...@googlemail.com] On Behalf Of Michael Schulz Sent: Thursday, September 16, 2010 9:27 AM To: Jay Kapalczynski Cc: mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] Symbology Hi, yes, you have to define an image symbol in your symbolset and use that: SYMBOL NAME 'church' TYPE pixmap IMAGE 'church.gif' TRANSPARENT 5 END then use SYMBOL 'church' in your style. Cheers, Michael 2010/9/16 Jay Kapalczynski jkapalczyn...@ci.maple-grove.mn.us: In a map file...Is there a way to use an image (jpg, bmp, png) instead of a marker symbol (star, circle etc) when symbolizing points LAYER DUMP TRUE NAME 'Firestations' DATA 'firestations' TYPE POINT STATUS ON CLASS NAME 'Fire Stations' COLOR 254 0 0 INSTEAD OF STAR PLACE AN IMAGE SYMBOL star SIZE 8 END ___ mapserver-users
[mapserver-users] Expressions
I am using GeoMoose but feel this is more a question for Map Server.
I am trying to sort my points by dates using the code belowI think that I
can do this but not sure
Is this a viable format 2Y%2M%2D ?
* As for the field in the shapefile...If I use an integer it removes
the 0 from the 092110, (sept 21st 2010)
* If I use a date then there are / ... 9/21/10
* The only way I can see this happening is using a text field with
retains the 0 in 092110
When I use the textfield dateValues as seen below I can get the stars to draw
but only the LASTWEEK...for some reason the LASTTWOWEEKS does not show and I
know that I have a few records with dates in the last 14 days...
Thoughts?
THANKSall your help is very appreciated
Main .xml file
map-source name=Burglaries type=mapserver
file./maple_grove_datasets/police/Burglaries.map/file
param type=today offset=-7 name=LASTWEEK format=%2Y%2M%2D /
param type=today offset=-14 name=LASTTWOWEEKS format=%2Y%2M%2D /
param type=today offset=-30 name=LASTTHIRTY format=%2Y%2M%2D /
param type=today offset=-90 name=LASTNINTY format=%2Y%2M%2D /
layer name=Burglaries/
/map-source
.map file
CLASS
NAME 'Last Weeks'
EXPRESSION ('[dateValues]' '%LASTWEEK%')
STYLE
COLOR 0 0 0
SYMBOL star
SIZE 12
END
END
CLASS
NAME 'Last Two Weeks'
EXPRESSION ('[dateValues]' '%LASTTWOWEEKS%')
STYLE
COLOR 0 100 50
SYMBOL star
SIZE 12
END
END
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Symbology
In a map file.Is there a way to use an image (jpg, bmp, png) instead of a marker symbol (star, circle etc) when symbolizing points LAYER DUMP TRUE NAME 'Firestations' DATA 'firestations' TYPE POINT STATUS ON CLASS NAME 'Fire Stations' COLOR 254 0 0 INSTEAD OF STAR PLACE AN IMAGE SYMBOL star SIZE 8 END ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] Symbology
Ok that seems to make sense...but where do I place the image SYMBOL (your example below)? DO I place that in the map file as well? Little confused there Thanks Michael and Adam for your return replys. -Original Message- From: mandsch...@googlemail.com [mailto:mandsch...@googlemail.com] On Behalf Of Michael Schulz Sent: Thursday, September 16, 2010 9:27 AM To: Jay Kapalczynski Cc: mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] Symbology Hi, yes, you have to define an image symbol in your symbolset and use that: SYMBOL NAME 'church' TYPE pixmap IMAGE 'church.gif' TRANSPARENT 5 END then use SYMBOL 'church' in your style. Cheers, Michael 2010/9/16 Jay Kapalczynski jkapalczyn...@ci.maple-grove.mn.us: In a map file...Is there a way to use an image (jpg, bmp, png) instead of a marker symbol (star, circle etc) when symbolizing points LAYER DUMP TRUE NAME 'Firestations' DATA 'firestations' TYPE POINT STATUS ON CLASS NAME 'Fire Stations' COLOR 254 0 0 INSTEAD OF STAR PLACE AN IMAGE SYMBOL star SIZE 8 END ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- ~ Aufwind durch Wissen! Qualifizierte Open Source Schulungen bei der http://www.foss-academy.eu/ ~ --- Michael Schulz msch...@webgis.de in medias res Gesellschaft für Informationstechnologie mbH Schwimmbadstraße 2 D-79100 Freiburg i. Br. Tel: +49 (0)761 705798-102 Tel: +49 (0)761 705798-0 Fax: +49 (0)761 705798-09 http://www.webgis.de / http://www.zopecms.de -- Geschäftsführer: Stefan Giese, Dr. Christof Lindenbeck Eingetragen im Handelsregister HRB 5930 beim Amtsgericht Freiburg ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] Symbology
Thanks guys for your thoughts...still green to this and trying to learn I would make real sense to me to create the .sym file where I would not have to redefine the particular symbol sets DO I HAVE THIS RIGHT? 1. BUT how do I define the symbol set or point to the .sym file from the map file ? SYMBOL FILE: So in the Symbol file I would have this (example of two of them) SYMBOL NAME 'bike' TYPE pixmap IMAGE '/home/mapserv/proj/pmap/bike.png' TRANSPARENT 2 END SYMBOL NAME 'church' TYPE pixmap IMAGE '/home/mapserv/proj/pmap/church.png' TRANSPARENT 5 END MAP FILE: I would simply call them? CLASS STYLE SYMBOL bike COLOR 0 0 0 OUTLINECOLOR 0 0 0 END END -Original Message- From: Fawcett, David (MPCA) [mailto:david.fawc...@state.mn.us] Sent: Thursday, September 16, 2010 9:50 AM To: Jay Kapalczynski; 'Michael Schulz' Cc: mapserver-users@lists.osgeo.org Subject: RE: [mapserver-users] Symbology You can put the symbol definition in your map file, or in a symbols file (e.g. symbols.sym) and then set SYMBOLSET at the MAP level to point to your symbols.sym file. David. -Original Message- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Jay Kapalczynski Sent: Thursday, September 16, 2010 9:45 AM To: 'Michael Schulz' Cc: mapserver-users@lists.osgeo.org Subject: RE: [mapserver-users] Symbology Ok that seems to make sense...but where do I place the image SYMBOL (your example below)? DO I place that in the map file as well? Little confused there Thanks Michael and Adam for your return replys. -Original Message- From: mandsch...@googlemail.com [mailto:mandsch...@googlemail.com] On Behalf Of Michael Schulz Sent: Thursday, September 16, 2010 9:27 AM To: Jay Kapalczynski Cc: mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] Symbology Hi, yes, you have to define an image symbol in your symbolset and use that: SYMBOL NAME 'church' TYPE pixmap IMAGE 'church.gif' TRANSPARENT 5 END then use SYMBOL 'church' in your style. Cheers, Michael 2010/9/16 Jay Kapalczynski jkapalczyn...@ci.maple-grove.mn.us: In a map file...Is there a way to use an image (jpg, bmp, png) instead of a marker symbol (star, circle etc) when symbolizing points LAYER DUMP TRUE NAME 'Firestations' DATA 'firestations' TYPE POINT STATUS ON CLASS NAME 'Fire Stations' COLOR 254 0 0 INSTEAD OF STAR PLACE AN IMAGE SYMBOL star SIZE 8 END ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- ~ Aufwind durch Wissen! Qualifizierte Open Source Schulungen bei der http://www.foss-academy.eu/ ~ --- Michael Schulz msch...@webgis.de in medias res Gesellschaft für Informationstechnologie mbH Schwimmbadstraße 2 D-79100 Freiburg i. Br. Tel: +49 (0)761 705798-102 Tel: +49 (0)761 705798-0 Fax: +49 (0)761 705798-09 http://www.webgis.de / http://www.zopecms.de -- Geschäftsführer: Stefan Giese, Dr. Christof Lindenbeck Eingetragen im Handelsregister HRB 5930 beim Amtsgericht Freiburg ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] Symbology
Once again guysthanks...VERY Appreciated I am having one last problem...the path...if the map file is in the police folder (as seen below) how do I write the path to get to the .sym file. I am having a hard tiem trying to figure out were is the root to start my URL path Hope this does not seem to stupid a question...when I am trying to create a path...do I think of it from the location of the .map file to the .sym file and then create the path between them. OR do I always start from one location? SYMBOLSET /path/to/symbolset_file Folder structure: Ms4w Apps maplegrove Htdocs Symbolset folder .sym file maps maple_grove police .map files ... ... ... From: Smith, Michael D ERDC-CRREL-NH [mailto:michael.sm...@usace.army.mil] Sent: Thursday, September 16, 2010 10:26 AM To: Jay Kapalczynski; 'Fawcett, David (MPCA)'; 'Michael Schulz' Cc: mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] Symbology Jay, A couple of additional steps. 1). Add SYMBOLSET as the first line in your symbol file 2). In the mapfile, in the MAP section add a line SYMBOLSET /path/to/symbolset_file Mike -- Michael Smith Remote Sensing/GIS Center US Army Corps of Engineers Hanover, NH On 9/16/10 11:20 AM, Jay Kapalczynski jkapalczyn...@ci.maple-grove.mn.us wrote: Thanks guys for your thoughts...still green to this and trying to learn I would make real sense to me to create the .sym file where I would not have to redefine the particular symbol sets DO I HAVE THIS RIGHT? 1. BUT how do I define the symbol set or point to the .sym file from the map file ? SYMBOL FILE: So in the Symbol file I would have this (example of two of them) SYMBOL NAME 'bike' TYPE pixmap IMAGE '/home/mapserv/proj/pmap/bike.png' TRANSPARENT 2 END SYMBOL NAME 'church' TYPE pixmap IMAGE '/home/mapserv/proj/pmap/church.png' TRANSPARENT 5 END MAP FILE: I would simply call them? CLASS STYLE SYMBOL bike COLOR 0 0 0 OUTLINECOLOR 0 0 0 END END -Original Message- From: Fawcett, David (MPCA) [mailto:david.fawc...@state.mn.us] Sent: Thursday, September 16, 2010 9:50 AM To: Jay Kapalczynski; 'Michael Schulz' Cc: mapserver-users@lists.osgeo.org Subject: RE: [mapserver-users] Symbology You can put the symbol definition in your map file, or in a symbols file (e.g. symbols.sym) and then set SYMBOLSET at the MAP level to point to your symbols.sym file. David. -Original Message- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Jay Kapalczynski Sent: Thursday, September 16, 2010 9:45 AM To: 'Michael Schulz' Cc: mapserver-users@lists.osgeo.org Subject: RE: [mapserver-users] Symbology Ok that seems to make sense...but where do I place the image SYMBOL (your example below)? DO I place that in the map file as well? Little confused there Thanks Michael and Adam for your return replys. -Original Message- From: mandsch...@googlemail.com [mailto:mandsch...@googlemail.com] On Behalf Of Michael Schulz Sent: Thursday, September 16, 2010 9:27 AM To: Jay Kapalczynski Cc: mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] Symbology Hi, yes, you have to define an image symbol in your symbolset and use that: SYMBOL NAME 'church' TYPE pixmap IMAGE 'church.gif' TRANSPARENT 5 END then use SYMBOL 'church' in your style. Cheers, Michael 2010/9/16 Jay Kapalczynski jkapalczyn...@ci.maple-grove.mn.us: In a map file...Is there a way to use an image (jpg, bmp, png) instead of a marker symbol (star, circle etc) when symbolizing points LAYER DUMP TRUE NAME 'Firestations' DATA 'firestations' TYPE POINT STATUS ON CLASS NAME 'Fire Stations' COLOR 254 0 0 INSTEAD OF STAR PLACE AN IMAGE SYMBOL star SIZE 8 END ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] Symbology
Last entry on thisI can get this to work ALTHOUGH ONLY in the map file In the map file I am pointing to the folder that contains the .sym file but cant get the sym file to work I cannot get the SYMBOLSET to load the sym file. As Seen below it only works when I have the symbol set declared in the map file... What can I be doing wrong? MAP # THIS DOES NOT WORK # DECLARE LOCATION OF THE SYMBOL SET #SYMBOLSET '../../../htdocs/symbolsets/symbolset.sym' # THIS WORKS SYMBOL NAME 'bike' TYPE pixmap IMAGE '../../../htdocs/symbolsets/symbol_images/bike.png' TRANSPARENT 50 END LAYER NAME Burglaries DATA './Burglaries.shp' STATUS ON TYPE POINT CLASS NAME 'Last Weeks' STYLE SYMBOL bike COLOR 0 0 0 OUTLINECOLOR 0 0 0 END END #.snip SYM FILE SYMBOLSET SYMBOL NAME 'bike' TYPE pixmap IMAGE 'symbol_images/bike.png' TRANSPARENT 2 END END From: Smith, Michael D ERDC-CRREL-NH [mailto:michael.sm...@usace.army.mil] Sent: Thursday, September 16, 2010 10:26 AM To: Jay Kapalczynski; 'Fawcett, David (MPCA)'; 'Michael Schulz' Cc: mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] Symbology Jay, A couple of additional steps. 1). Add SYMBOLSET as the first line in your symbol file 2). In the mapfile, in the MAP section add a line SYMBOLSET /path/to/symbolset_file Mike -- Michael Smith Remote Sensing/GIS Center US Army Corps of Engineers Hanover, NH On 9/16/10 11:20 AM, Jay Kapalczynski jkapalczyn...@ci.maple-grove.mn.us wrote: Thanks guys for your thoughts...still green to this and trying to learn I would make real sense to me to create the .sym file where I would not have to redefine the particular symbol sets DO I HAVE THIS RIGHT? 1. BUT how do I define the symbol set or point to the .sym file from the map file ? SYMBOL FILE: So in the Symbol file I would have this (example of two of them) SYMBOL NAME 'bike' TYPE pixmap IMAGE '/home/mapserv/proj/pmap/bike.png' TRANSPARENT 2 END SYMBOL NAME 'church' TYPE pixmap IMAGE '/home/mapserv/proj/pmap/church.png' TRANSPARENT 5 END MAP FILE: I would simply call them? CLASS STYLE SYMBOL bike COLOR 0 0 0 OUTLINECOLOR 0 0 0 END END -Original Message- From: Fawcett, David (MPCA) [mailto:david.fawc...@state.mn.us] Sent: Thursday, September 16, 2010 9:50 AM To: Jay Kapalczynski; 'Michael Schulz' Cc: mapserver-users@lists.osgeo.org Subject: RE: [mapserver-users] Symbology You can put the symbol definition in your map file, or in a symbols file (e.g. symbols.sym) and then set SYMBOLSET at the MAP level to point to your symbols.sym file. David. -Original Message- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Jay Kapalczynski Sent: Thursday, September 16, 2010 9:45 AM To: 'Michael Schulz' Cc: mapserver-users@lists.osgeo.org Subject: RE: [mapserver-users] Symbology Ok that seems to make sense...but where do I place the image SYMBOL (your example below)? DO I place that in the map file as well? Little confused there Thanks Michael and Adam for your return replys. -Original Message- From: mandsch...@googlemail.com [mailto:mandsch...@googlemail.com] On Behalf Of Michael Schulz Sent: Thursday, September 16, 2010 9:27 AM To: Jay Kapalczynski Cc: mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] Symbology Hi, yes, you have to define an image symbol in your symbolset and use that: SYMBOL NAME 'church' TYPE pixmap IMAGE 'church.gif' TRANSPARENT 5 END then use SYMBOL 'church' in your style. Cheers, Michael 2010/9/16 Jay Kapalczynski jkapalczyn...@ci.maple-grove.mn.us: In a map file...Is there a way to use an image (jpg, bmp, png) instead of a marker symbol (star, circle etc) when symbolizing points LAYER DUMP TRUE NAME 'Firestations' DATA 'firestations' TYPE POINT STATUS ON CLASS NAME 'Fire Stations' COLOR 254 0 0 INSTEAD OF STAR PLACE AN IMAGE SYMBOL star SIZE 8 END ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users
RE: [mapserver-users] Expression Syntax
Thanks for all your help yesterdayvery appreciated...seems I always get
botched up with the syntax
U...I have tried 20 different ways and I just seem to be missing something..
I guess the question is, Can I use a wild card search in a logical expression?
This works (WILD CARD )
FILTER /.*%idOwnerQueryDESC%.*/i
This works (NO WILD CARD)
FILTER ('[USE1_DESC]'='%idOwnerQueryDESC%' AND '[BLOCK]'='%idOwnerQueryBLOCK%')
This DOSENT work (Cant get the wild card into this)
FILTER ('[USE1_DESC]'=' /.*%idOwnerQueryDESC%.*/i' AND
'[BLOCK]'='%idOwnerQueryBLOCK%')
Any thoughts?
Thanks
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Jay Kapalczynski
Sent: Thursday, December 10, 2009 3:57 PM
To: 'Fawcett, David (MPCA)'; 'Emiliano Castañeda'
Cc: mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] Expression Syntax
Thanks all for your thoughts
Got it...I had to add ' ' around the textbox id as well when referencing the
textbox id names
Notice( '%idOwnerQueryDESC%' and '%idOwnerQueryBLOCK%' )
FILTER ('[USE1_DESC]'='%idOwnerQueryDESC%' AND '[BLOCK]'='%idOwnerQueryBLOCK%')
Dan thanks for your thoughts...I am going to be moving to 2.x soonbut have
to have the time to lean this all over again...moving to open layers that is
One step at a time...I have a ton programmed into 1.6 that's going to take me
some time to convert...
Thanks again allvery appreciated
From: Fawcett, David (MPCA) [mailto:david.fawc...@state.mn.us]
Sent: Thursday, December 10, 2009 3:26 PM
To: Jay Kapalczynski; 'Emiliano Castañeda'
Cc: mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] Expression Syntax
At a minimum, I think that you will need to add quotes around the query
columns. (just use single quotes, not the fancy Microsofty ones below...)
FILTER ('[USE1_DESC]'=%idOwnerQueryDESC% AND '[BLOCK]'=%idOwnerQueryBLOCK%)
Try setting a filter with static values from your data to get the filter format
working before you add the complexity of passing the values in with variables.
FILTER ('[USE1_DESC]'='myUse' AND '[BLOCK]'='myBlock')
David.
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Jay Kapalczynski
Sent: Thursday, December 10, 2009 3:21 PM
To: 'Emiliano Castañeda'
Cc: mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] Expression Syntax
Emiliano thanks for the responseyea I looked at the documentation and it
was a bit fuzzy to me...
If I do them individually it works:
#FILTERITEM 'USE1_DESC'
#FILTER /.*%idOwnerQueryDESC%.*/i
#FILTERITEM 'BLOCK'
#FILTER /.*%idOwnerQueryBLOCK%.*/i
FILTER ([USE1_DESC]=%idOwnerQueryDESC% AND [BLOCK]=%idOwnerQueryBLOCK%)
ERROR: msEvalExpression: Expression parser error. Failed to parse expression:
=Residential AND =006
FILTER (USE1_DESC=%idOwnerQueryDESC% AND BLOCK=%idOwnerQueryBLOCK%)
I seemed to get a bunch of returns that were incorrect...seems like it grabbed
all of them.
Thoughts?
From: Emiliano Castañeda [mailto:emilianocastan...@suremptec.com.ar]
Sent: Thursday, December 10, 2009 2:13 PM
To: Jay Kapalczynski
Cc: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] Expression Syntax
Jay,
you must use FILTERITEM only for simple FILTER expressions (string comparison
only)
for example:
FILTER 2005 -fieldvalue
FILTERITEM year -fieldname
For Logical FILTER expressions you do not define FILTERITEM. In this case you
must place the FILTER between parentheses, and fieldnames between brackets
for example:
FILTER ([field1]4000 AND [field2]==Museum) --observe quotes on both sides
on text fields
See http://mapserver.org/mapfile/expressions.html#expressions for detail on how
to build logical expressions
Regards,
Emiliano
2009/12/10 Jay Kapalczynski
jkapalczyn...@ci.maple-grove.mn.usmailto:jkapalczyn...@ci.maple-grove.mn.us
I looked on map server website in the documentation and cant get the synstax
correct
I have two textboxes idOwner and idOwner2
I am a bit confused on the FILTERITEM because I am trying to write the
expression to include two fields.
USE1_DESC and BLOCK are the two fields that form the query
LAYER # Parcels Owner Layer
NAME 'Parcels'
DATA 'parcels/parcels.shp'
STATUS DEFAULT
TYPE POLYGON
METADATA
qstring_validation_pattern '.'
END
TEMPLATE 'parcels/itemquery_parcels_Owner.html'
FILTERITEM 'USE1_DESC'
FILTER (* WHERE USE1_DESC = '%idOwner%' and BLOCK =
'%idOwner2%')
END
___
mapserver-users mailing list
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
--
Ing
RE: [mapserver-users] Expression Syntax
Thanks Steve for you response
I have been scouring the documentation on expressions and was getting confused..
This is from Mapserver
( ( ... ) AND ( ... ) ) ( ( ... ) ( ... ) ) ... will become true when both
of the two logical expressions in the innermost brackets are true.
Although my solution followed (...AND...) NOT ((...) AND (...))
I didn't see the ~ in the documentation...what is that doing is signifying?
I had to remove the i so I am not longer case insensitive.thats a
drag...guess I have to modify my attributes to LCase to get around that...
Any other thoughts about the case sensitive issue...any way around that with
the Logical Expression...
Thanks again everyone for you help and suggestions.
-Original Message-
From: Lime, Steve D (DNR) [mailto:steve.l...@state.mn.us]
Sent: Friday, December 11, 2009 8:55 AM
To: Jay Kapalczynski
Cc: mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] Expression Syntax
Try:
FILTER ('[USE1_DESC]' =~ /.*%idOwnerQueryDESC%.*/i AND
'[BLOCK]'='%idOwnerQueryBLOCK%')
I've not tried case insensitive regex in a logical expression though. You might
have to remove the i...
Steve
From: mapserver-users-boun...@lists.osgeo.org
[mapserver-users-boun...@lists.osgeo.org] On Behalf Of Jay Kapalczynski
[jkapalczyn...@ci.maple-grove.mn.us]
Sent: Friday, December 11, 2009 8:37 AM
To: Fawcett, David (MPCA); 'Emiliano Castañeda'
Cc: mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] Expression Syntax
Thanks for all your help yesterdayvery appreciated...seems I always get
botched up with the syntax
U...I have tried 20 different ways and I just seem to be missing something..
I guess the question is, Can I use a wild card search in a logical expression?
This works (WILD CARD )
FILTER /.*%idOwnerQueryDESC%.*/i
This works (NO WILD CARD)
FILTER ('[USE1_DESC]'='%idOwnerQueryDESC%' AND '[BLOCK]'='%idOwnerQueryBLOCK%')
This DOSENT work (Cant get the wild card into this)
FILTER ('[USE1_DESC]'=' /.*%idOwnerQueryDESC%.*/i' AND
'[BLOCK]'='%idOwnerQueryBLOCK%')
Any thoughts?
Thanks
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Jay Kapalczynski
Sent: Thursday, December 10, 2009 3:57 PM
To: 'Fawcett, David (MPCA)'; 'Emiliano Castañeda'
Cc: mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] Expression Syntax
Thanks all for your thoughts
Got it...I had to add ' ' around the textbox id as well when referencing the
textbox id names
Notice( '%idOwnerQueryDESC%' and '%idOwnerQueryBLOCK%' )
FILTER ('[USE1_DESC]'='%idOwnerQueryDESC%' AND '[BLOCK]'='%idOwnerQueryBLOCK%')
Dan thanks for your thoughts...I am going to be moving to 2.x soonbut have
to have the time to lean this all over again...moving to open layers that is
One step at a time...I have a ton programmed into 1.6 that's going to take me
some time to convert...
Thanks again allvery appreciated
From: Fawcett, David (MPCA) [mailto:david.fawc...@state.mn.us]
Sent: Thursday, December 10, 2009 3:26 PM
To: Jay Kapalczynski; 'Emiliano Castañeda'
Cc: mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] Expression Syntax
At a minimum, I think that you will need to add quotes around the query
columns. (just use single quotes, not the fancy Microsofty ones below...)
FILTER ('[USE1_DESC]'=%idOwnerQueryDESC% AND '[BLOCK]'=%idOwnerQueryBLOCK%)
Try setting a filter with static values from your data to get the filter format
working before you add the complexity of passing the values in with variables.
FILTER ('[USE1_DESC]'='myUse' AND '[BLOCK]'='myBlock')
David.
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Jay Kapalczynski
Sent: Thursday, December 10, 2009 3:21 PM
To: 'Emiliano Castañeda'
Cc: mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] Expression Syntax
Emiliano thanks for the responseyea I looked at the documentation and it
was a bit fuzzy to me...
If I do them individually it works:
#FILTERITEM 'USE1_DESC'
#FILTER /.*%idOwnerQueryDESC%.*/i
#FILTERITEM 'BLOCK'
#FILTER /.*%idOwnerQueryBLOCK%.*/i
FILTER ([USE1_DESC]=%idOwnerQueryDESC% AND [BLOCK]=%idOwnerQueryBLOCK%)
ERROR: msEvalExpression: Expression parser error. Failed to parse expression:
=Residential AND =006
FILTER (USE1_DESC=%idOwnerQueryDESC% AND BLOCK=%idOwnerQueryBLOCK%)
I seemed to get a bunch of returns that were incorrect...seems like it grabbed
all of them.
Thoughts?
From: Emiliano Castañeda [mailto:emilianocastan...@suremptec.com.ar]
Sent: Thursday, December 10, 2009 2:13 PM
To: Jay Kapalczynski
Cc: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] Expression Syntax
RE: [mapserver-users] Expression Syntax
My example I am having the user fill the query...so I don't know what they are
entering
Are you hinting at doing that with the whole alphabet?
/idOwnerQueryDESC/ = [Aa][Bb][Cc][Dd] etc etc
If I split them apart like you suggested how does the AND statement of the
logical expression get referenced?
Thanks Steve for your thoughts and comments...apprecaited...
Thanks
-Original Message-
From: Lime, Steve D (DNR) [mailto:steve.l...@state.mn.us]
Sent: Friday, December 11, 2009 9:29 AM
To: Jay Kapalczynski
Cc: mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] Expression Syntax
The =~ is the regex operator. It's referenced in a Note just below all the
other logical expressions... Probably
should just be inlined with the other examples.
You can write case insensitive regex's the brute force way, e.g.:
/hello/ = /[Hh][Ee][Ll][Ll][Oo]/
Bit of a pain though. Also, if you could isolate the regex somehow and remove
your block test then you could do a
straight regex expression and use case insensitivity. For example,
FILTERITEM 'block'
FILTER '%idOwnerQueryBLOCK%'
CLASSITEM 'USE1_DESC'
CLASS
EXPRESSION /.*%idOwnerQueryDESC%.*/i
END
Might even see better performance...
Steve
From: Jay Kapalczynski [jkapalczyn...@ci.maple-grove.mn.us]
Sent: Friday, December 11, 2009 9:17 AM
To: Lime, Steve D (DNR)
Cc: mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] Expression Syntax
Thanks Steve for you response
I have been scouring the documentation on expressions and was getting confused..
This is from Mapserver
( ( ... ) AND ( ... ) ) ( ( ... ) ( ... ) ) ... will become true when both
of the two logical expressions in the innermost brackets are true.
Although my solution followed (...AND...) NOT ((...) AND (...))
I didn't see the ~ in the documentation...what is that doing is signifying?
I had to remove the i so I am not longer case insensitive.thats a
drag...guess I have to modify my attributes to LCase to get around that...
Any other thoughts about the case sensitive issue...any way around that with
the Logical Expression...
Thanks again everyone for you help and suggestions.
-Original Message-
From: Lime, Steve D (DNR) [mailto:steve.l...@state.mn.us]
Sent: Friday, December 11, 2009 8:55 AM
To: Jay Kapalczynski
Cc: mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] Expression Syntax
Try:
FILTER ('[USE1_DESC]' =~ /.*%idOwnerQueryDESC%.*/i AND
'[BLOCK]'='%idOwnerQueryBLOCK%')
I've not tried case insensitive regex in a logical expression though. You might
have to remove the i...
Steve
From: mapserver-users-boun...@lists.osgeo.org
[mapserver-users-boun...@lists.osgeo.org] On Behalf Of Jay Kapalczynski
[jkapalczyn...@ci.maple-grove.mn.us]
Sent: Friday, December 11, 2009 8:37 AM
To: Fawcett, David (MPCA); 'Emiliano Castañeda'
Cc: mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] Expression Syntax
Thanks for all your help yesterday..very appreciated.seems I always get botched
up with the syntax..
U.I have tried 20 different ways and I just seem to be missing something..
I guess the question is, Can I use a wild card search in a logical expression?
This works (WILD CARD )
FILTER /.*%idOwnerQueryDESC%.*/i
This works (NO WILD CARD)
FILTER ('[USE1_DESC]'='%idOwnerQueryDESC%' AND '[BLOCK]'='%idOwnerQueryBLOCK%')
This DOSENT work (Cant get the wild card into this)
FILTER ('[USE1_DESC]'=' /.*%idOwnerQueryDESC%.*/i' AND
'[BLOCK]'='%idOwnerQueryBLOCK%')
Any thoughts?
Thanks
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Jay Kapalczynski
Sent: Thursday, December 10, 2009 3:57 PM
To: 'Fawcett, David (MPCA)'; 'Emiliano Castañeda'
Cc: mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] Expression Syntax
Thanks all for your thoughts..
Got it.I had to add ' ' around the textbox id as well when referencing the
textbox id names
Notice( '%idOwnerQueryDESC%' and '%idOwnerQueryBLOCK%' )
FILTER ('[USE1_DESC]'='%idOwnerQueryDESC%' AND '[BLOCK]'='%idOwnerQueryBLOCK%')
Dan thanks for your thoughts.I am going to be moving to 2.x soon..but have to
have the time to lean this all over again.moving to open layers that is..
One step at a time.I have a ton programmed into 1.6 that's going to take me
some time to convert.
Thanks again all..very appreciated
From: Fawcett, David (MPCA) [mailto:david.fawc...@state.mn.us]
Sent: Thursday, December 10, 2009 3:26 PM
To: Jay Kapalczynski; 'Emiliano Castañeda'
Cc: mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] Expression Syntax
At a minimum, I think that you will need to add quotes around the query
columns. (just use single quotes, not the fancy Microsofty ones below.)
FILTER ('[USE1_DESC]'=%idOwnerQueryDESC% AND '[BLOCK
[mapserver-users] Expression Syntax
I looked on map server website in the documentation and cant get the synstax correct I have two textboxes idOwner and idOwner2 I am a bit confused on the FILTERITEM because I am trying to write the expression to include two fields. USE1_DESC and BLOCK are the two fields that form the query LAYER # Parcels Owner Layer NAME 'Parcels' DATA 'parcels/parcels.shp' STATUS DEFAULT TYPE POLYGON METADATA qstring_validation_pattern '.' END TEMPLATE 'parcels/itemquery_parcels_Owner.html' FILTERITEM 'USE1_DESC' FILTER (* WHERE USE1_DESC = '%idOwner%' and BLOCK = '%idOwner2%') END ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] Expression Syntax
Emiliano thanks for the responseyea I looked at the documentation and it was a bit fuzzy to me... If I do them individually it works: #FILTERITEM 'USE1_DESC' #FILTER /.*%idOwnerQueryDESC%.*/i #FILTERITEM 'BLOCK' #FILTER /.*%idOwnerQueryBLOCK%.*/i FILTER ([USE1_DESC]=%idOwnerQueryDESC% AND [BLOCK]=%idOwnerQueryBLOCK%) ERROR: msEvalExpression: Expression parser error. Failed to parse expression: =Residential AND =006 FILTER (USE1_DESC=%idOwnerQueryDESC% AND BLOCK=%idOwnerQueryBLOCK%) I seemed to get a bunch of returns that were incorrect...seems like it grabbed all of them. Thoughts? From: Emiliano Castañeda [mailto:emilianocastan...@suremptec.com.ar] Sent: Thursday, December 10, 2009 2:13 PM To: Jay Kapalczynski Cc: mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] Expression Syntax Jay, you must use FILTERITEM only for simple FILTER expressions (string comparison only) for example: FILTER 2005 -fieldvalue FILTERITEM year -fieldname For Logical FILTER expressions you do not define FILTERITEM. In this case you must place the FILTER between parentheses, and fieldnames between brackets for example: FILTER ([field1]4000 AND [field2]==Museum) --observe quotes on both sides on text fields See http://mapserver.org/mapfile/expressions.html#expressions for detail on how to build logical expressions Regards, Emiliano 2009/12/10 Jay Kapalczynski jkapalczyn...@ci.maple-grove.mn.usmailto:jkapalczyn...@ci.maple-grove.mn.us I looked on map server website in the documentation and cant get the synstax correct I have two textboxes idOwner and idOwner2 I am a bit confused on the FILTERITEM because I am trying to write the expression to include two fields. USE1_DESC and BLOCK are the two fields that form the query LAYER # Parcels Owner Layer NAME 'Parcels' DATA 'parcels/parcels.shp' STATUS DEFAULT TYPE POLYGON METADATA qstring_validation_pattern '.' END TEMPLATE 'parcels/itemquery_parcels_Owner.html' FILTERITEM 'USE1_DESC' FILTER (* WHERE USE1_DESC = '%idOwner%' and BLOCK = '%idOwner2%') END ___ mapserver-users mailing list mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- Ing. Emiliano Castañeda SUR Emprendimientos Tecnológicos Ing. Huergo 1189 (C1007AOL) Ciudad de Buenos Aires, Argentina Tel. +54 (11) 5811-4552 ext. 107 emilianocastan...@suremptec.com.armailto:emilianocastan...@suremptec.com.ar www.suremptec.comhttp://www.suremptec.com ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] Expression Syntax
Thanks all for your thoughts
Got it...I had to add ' ' around the textbox id as well when referencing the
textbox id names
Notice( '%idOwnerQueryDESC%' and '%idOwnerQueryBLOCK%' )
FILTER ('[USE1_DESC]'='%idOwnerQueryDESC%' AND '[BLOCK]'='%idOwnerQueryBLOCK%')
Dan thanks for your thoughts...I am going to be moving to 2.x soonbut have
to have the time to lean this all over again...moving to open layers that is
One step at a time...I have a ton programmed into 1.6 that's going to take me
some time to convert...
Thanks again allvery appreciated
From: Fawcett, David (MPCA) [mailto:david.fawc...@state.mn.us]
Sent: Thursday, December 10, 2009 3:26 PM
To: Jay Kapalczynski; 'Emiliano Castañeda'
Cc: mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] Expression Syntax
At a minimum, I think that you will need to add quotes around the query
columns. (just use single quotes, not the fancy Microsofty ones below...)
FILTER ('[USE1_DESC]'=%idOwnerQueryDESC% AND '[BLOCK]'=%idOwnerQueryBLOCK%)
Try setting a filter with static values from your data to get the filter format
working before you add the complexity of passing the values in with variables.
FILTER ('[USE1_DESC]'='myUse' AND '[BLOCK]'='myBlock')
David.
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Jay Kapalczynski
Sent: Thursday, December 10, 2009 3:21 PM
To: 'Emiliano Castañeda'
Cc: mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] Expression Syntax
Emiliano thanks for the responseyea I looked at the documentation and it
was a bit fuzzy to me...
If I do them individually it works:
#FILTERITEM 'USE1_DESC'
#FILTER /.*%idOwnerQueryDESC%.*/i
#FILTERITEM 'BLOCK'
#FILTER /.*%idOwnerQueryBLOCK%.*/i
FILTER ([USE1_DESC]=%idOwnerQueryDESC% AND [BLOCK]=%idOwnerQueryBLOCK%)
ERROR: msEvalExpression: Expression parser error. Failed to parse expression:
=Residential AND =006
FILTER (USE1_DESC=%idOwnerQueryDESC% AND BLOCK=%idOwnerQueryBLOCK%)
I seemed to get a bunch of returns that were incorrect...seems like it grabbed
all of them.
Thoughts?
From: Emiliano Castañeda [mailto:emilianocastan...@suremptec.com.ar]
Sent: Thursday, December 10, 2009 2:13 PM
To: Jay Kapalczynski
Cc: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] Expression Syntax
Jay,
you must use FILTERITEM only for simple FILTER expressions (string comparison
only)
for example:
FILTER 2005 -fieldvalue
FILTERITEM year -fieldname
For Logical FILTER expressions you do not define FILTERITEM. In this case you
must place the FILTER between parentheses, and fieldnames between brackets
for example:
FILTER ([field1]4000 AND [field2]==Museum) --observe quotes on both sides
on text fields
See http://mapserver.org/mapfile/expressions.html#expressions for detail on how
to build logical expressions
Regards,
Emiliano
2009/12/10 Jay Kapalczynski
jkapalczyn...@ci.maple-grove.mn.usmailto:jkapalczyn...@ci.maple-grove.mn.us
I looked on map server website in the documentation and cant get the synstax
correct
I have two textboxes idOwner and idOwner2
I am a bit confused on the FILTERITEM because I am trying to write the
expression to include two fields.
USE1_DESC and BLOCK are the two fields that form the query
LAYER # Parcels Owner Layer
NAME 'Parcels'
DATA 'parcels/parcels.shp'
STATUS DEFAULT
TYPE POLYGON
METADATA
qstring_validation_pattern '.'
END
TEMPLATE 'parcels/itemquery_parcels_Owner.html'
FILTERITEM 'USE1_DESC'
FILTER (* WHERE USE1_DESC = '%idOwner%' and BLOCK =
'%idOwner2%')
END
___
mapserver-users mailing list
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
--
Ing. Emiliano Castañeda
SUR Emprendimientos Tecnológicos
Ing. Huergo 1189 (C1007AOL)
Ciudad de Buenos Aires, Argentina
Tel. +54 (11) 5811-4552 ext. 107
emilianocastan...@suremptec.com.armailto:emilianocastan...@suremptec.com.ar
www.suremptec.comhttp://www.suremptec.com
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] Expression Syntax
Last thought
Now that this is working:
FILTER ('[USE1_DESC]'='%idOwnerQueryDESC%' AND '[BLOCK]'='%idOwnerQueryBLOCK%')
I am trying to get them to be wild cards...this worked individually: BUT does
not work in the full string.
FILTER /.*%idOwnerQueryDESC%.*/i
Not Working:
FILTER ('[USE1_DESC]'=' /.*%idOwnerQueryDESC%.*/i' AND
'[BLOCK]'='%idOwnerQueryBLOCK%')
FILTER ('[USE1_DESC]'= /.*%idOwnerQueryDESC%.*/i AND
'[BLOCK]'='%idOwnerQueryBLOCK%')
FILTER ('[USE1_DESC]'=' .*%idOwnerQueryDESC%*.' AND
'[BLOCK]'='%idOwnerQueryBLOCK%')
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Jay Kapalczynski
Sent: Thursday, December 10, 2009 3:57 PM
To: 'Fawcett, David (MPCA)'; 'Emiliano Castañeda'
Cc: mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] Expression Syntax
Thanks all for your thoughts
Got it...I had to add ' ' around the textbox id as well when referencing the
textbox id names
Notice( '%idOwnerQueryDESC%' and '%idOwnerQueryBLOCK%' )
FILTER ('[USE1_DESC]'='%idOwnerQueryDESC%' AND '[BLOCK]'='%idOwnerQueryBLOCK%')
Dan thanks for your thoughts...I am going to be moving to 2.x soonbut have
to have the time to lean this all over again...moving to open layers that is
One step at a time...I have a ton programmed into 1.6 that's going to take me
some time to convert...
Thanks again allvery appreciated
From: Fawcett, David (MPCA) [mailto:david.fawc...@state.mn.us]
Sent: Thursday, December 10, 2009 3:26 PM
To: Jay Kapalczynski; 'Emiliano Castañeda'
Cc: mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] Expression Syntax
At a minimum, I think that you will need to add quotes around the query
columns. (just use single quotes, not the fancy Microsofty ones below...)
FILTER ('[USE1_DESC]'=%idOwnerQueryDESC% AND '[BLOCK]'=%idOwnerQueryBLOCK%)
Try setting a filter with static values from your data to get the filter format
working before you add the complexity of passing the values in with variables.
FILTER ('[USE1_DESC]'='myUse' AND '[BLOCK]'='myBlock')
David.
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Jay Kapalczynski
Sent: Thursday, December 10, 2009 3:21 PM
To: 'Emiliano Castañeda'
Cc: mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] Expression Syntax
Emiliano thanks for the responseyea I looked at the documentation and it
was a bit fuzzy to me...
If I do them individually it works:
#FILTERITEM 'USE1_DESC'
#FILTER /.*%idOwnerQueryDESC%.*/i
#FILTERITEM 'BLOCK'
#FILTER /.*%idOwnerQueryBLOCK%.*/i
FILTER ([USE1_DESC]=%idOwnerQueryDESC% AND [BLOCK]=%idOwnerQueryBLOCK%)
ERROR: msEvalExpression: Expression parser error. Failed to parse expression:
=Residential AND =006
FILTER (USE1_DESC=%idOwnerQueryDESC% AND BLOCK=%idOwnerQueryBLOCK%)
I seemed to get a bunch of returns that were incorrect...seems like it grabbed
all of them.
Thoughts?
From: Emiliano Castañeda [mailto:emilianocastan...@suremptec.com.ar]
Sent: Thursday, December 10, 2009 2:13 PM
To: Jay Kapalczynski
Cc: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] Expression Syntax
Jay,
you must use FILTERITEM only for simple FILTER expressions (string comparison
only)
for example:
FILTER 2005 -fieldvalue
FILTERITEM year -fieldname
For Logical FILTER expressions you do not define FILTERITEM. In this case you
must place the FILTER between parentheses, and fieldnames between brackets
for example:
FILTER ([field1]4000 AND [field2]==Museum) --observe quotes on both sides
on text fields
See http://mapserver.org/mapfile/expressions.html#expressions for detail on how
to build logical expressions
Regards,
Emiliano
2009/12/10 Jay Kapalczynski
jkapalczyn...@ci.maple-grove.mn.usmailto:jkapalczyn...@ci.maple-grove.mn.us
I looked on map server website in the documentation and cant get the synstax
correct
I have two textboxes idOwner and idOwner2
I am a bit confused on the FILTERITEM because I am trying to write the
expression to include two fields.
USE1_DESC and BLOCK are the two fields that form the query
LAYER # Parcels Owner Layer
NAME 'Parcels'
DATA 'parcels/parcels.shp'
STATUS DEFAULT
TYPE POLYGON
METADATA
qstring_validation_pattern '.'
END
TEMPLATE 'parcels/itemquery_parcels_Owner.html'
FILTERITEM 'USE1_DESC'
FILTER (* WHERE USE1_DESC = '%idOwner%' and BLOCK =
'%idOwner2%')
END
___
mapserver-users mailing list
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
--
Ing. Emiliano Castañeda
SUR Emprendimientos Tecnológicos
Ing
[mapserver-users] Item Query
Wondering if this is possible? I have a Service set up to allow the user to input a few choices. I then am attempting to send those to a .map file to query a layer Can this be done...I am grabbing at straws here because I don't even know if this can be done? Service from an xml file: service title=SearchByPID selectable=false default=false locked=true div=PIDsearch url/cgi-bin/mapserv.exe/url input type=hidden name=map value=/ms4w/apps/GeoMOOSE/Maple_Grove_GeoMoose/itemquery_PID.map/ input type=hidden name=mode value=nquery/ input type=hidden name=layer value=parcels/ input type=select name=PropertyType title=Property Type: option value=CommercialCommercial/option option value=ResidentialResidential/option option value=Single FamilySingle Family/option option value=TownhomeTownhome/option option value=Twinhome/Zero LotTwinhome/Zero Lot/option /input input type=select name=PriceFactor title=Price Factor: option value=Greater ThanGreater Than/option option value=Less ThanLess Than/option option value=BetweenBetween/option option value=Equal ToEqual To/option option value=Greater Than Equal ToGreater Than Equal To/option option value=Less Than Equal ToLess Than Equal To/option /input /service .map file being called from above IS there a way to Use the filter to query the shapefile with the values from the two comboboxes above? Can I make a where clause in the Filter Filter * WHERE Propertytype (above combobox) and PriceFactor (above combobox) LAYER # Parcels Polygon Layer NAME 'Parcels' DATA 'parcels/parcels.shp' STATUS DEFAULT TYPE POLYGON METADATA qstring_validation_pattern '.' END TEMPLATE 'parcels/identpar.html' FILTERITEM 'PID' FILTER /^%idPID%/ END ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] aJAX
I am trying to write some ajax here to run a query. I simplified this down so
that no query is happening, rather just getting all the pages to work together
and return some text.
I don't know whats going on here
1. I created a button that calls a javascript function
input type=button value=Send to Ajax and Tab
onClick=ReturnQueryResults();
2. This function is calling and passing an ajax page some info.
function ReturnQueryResults() {
getRunquery('parcellinktest.php','121190012','S')
/* getResulthype('parcellinktest.php','121190012','S') */
}
3. Once there it (depending on what is commented out in the ajax page) it
runs one of two functions (both of which are IDENTICAL)
But for some reason when I run the getRunquery I get errorsbut when I run
the getResulthype it works.
I am passing the same values to the same php page.
I just added the getRunquery to the ajax page.
function getResulthype(page,id,type){
var _target = 'content_details_form';
if (id.length == 0) {
document.getElementById(_target).innerHTML=bNo Information
Available/b;
return;
}
xmlHttp = GetAJAXObject();
if (xmlHttp==null) {
alert (Unable to process your request, your browser does not support
AJAX!);
return;
}
var url = http://127.0.0.1:80/geomoose/php/+page+?id=+id+type=+type;
xmlHttp.onreadystatechange = showResult;
xmlHttp.open(GET,url,true);
xmlHttp.send(null);
}
function getRunquery(page,id,type){
var _target = 'content_details_form';
if (url.length == )) {
document.getElementById(_target_.innerHTML=bNo Information
Available/b;
return;
}
xmlhttp = GetAJAXObject();
if {xmlHttp==null) {
alert (Unable to process you request, your browser does not
support AJAX);
return;
}
var url = http://127.0.0.1:80/geomoose/php/+page+?id=+id+type=+type;
xmlHttp.onreadystatechange = showResult;
xmlHttp.open(GET,url,true);
xmlHttp.send(null);
}
I thought something might be hanging so I cleared all temp files, shut down,
restarted Apache.
If the values are the same, and they are being sent to the same page how can I
be getting errors
Error:
getRunquery is not defined
[cid:image001.png@01CA7739.FEAD4550]getRunquery('parcellinktest.php','121190012','S')
inline: image001.png___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] RE: aJAX
I now went back and changed the ajax function (getRunquery, getResulthype) to
getResulthype and not this function is getting the error not defined but it
was working 20 seconds ago.
What can be hanging up here?
From: Jay Kapalczynski
Sent: Monday, December 07, 2009 12:38 PM
To: 'geomoose-develop...@lists.sourceforge.net';
'mapserver-users@lists.osgeo.org'
Subject: aJAX
I am trying to write some ajax here to run a query. I simplified this down so
that no query is happening, rather just getting all the pages to work together
and return some text.
I don't know whats going on here
1. I created a button that calls a javascript function
input type=button value=Send to Ajax and Tab
onClick=ReturnQueryResults();
2. This function is calling and passing an ajax page some info.
function ReturnQueryResults() {
getRunquery('parcellinktest.php','121190012','S')
/* getResulthype('parcellinktest.php','121190012','S') */
}
3. Once there it (depending on what is commented out in the ajax page) it
runs one of two functions (both of which are IDENTICAL)
But for some reason when I run the getRunquery I get errorsbut when I run
the getResulthype it works.
I am passing the same values to the same php page.
I just added the getRunquery to the ajax page.
function getResulthype(page,id,type){
var _target = 'content_details_form';
if (id.length == 0) {
document.getElementById(_target).innerHTML=bNo Information
Available/b;
return;
}
xmlHttp = GetAJAXObject();
if (xmlHttp==null) {
alert (Unable to process your request, your browser does not support
AJAX!);
return;
}
var url = http://127.0.0.1:80/geomoose/php/+page+?id=+id+type=+type;
xmlHttp.onreadystatechange = showResult;
xmlHttp.open(GET,url,true);
xmlHttp.send(null);
}
function getRunquery(page,id,type){
var _target = 'content_details_form';
if (url.length == )) {
document.getElementById(_target_.innerHTML=bNo Information
Available/b;
return;
}
xmlhttp = GetAJAXObject();
if {xmlHttp==null) {
alert (Unable to process you request, your browser does not
support AJAX);
return;
}
var url = http://127.0.0.1:80/geomoose/php/+page+?id=+id+type=+type;
xmlHttp.onreadystatechange = showResult;
xmlHttp.open(GET,url,true);
xmlHttp.send(null);
}
I thought something might be hanging so I cleared all temp files, shut down,
restarted Apache.
If the values are the same, and they are being sent to the same page how can I
be getting errors
Error:
getRunquery is not defined
[cid:image001.png@01CA773B.6EF61FC0]getRunquery('parcellinktest.php','121190012','S')
inline: image001.png___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] RE: [Geomoose-developers] aJAX
Brent and Stephen.
thank for the extra set of eyes...that was it...there were actually a couple
things wrong I thank you for pointing me in the right direction.
I did a copy and paste, like I should have done before, and changed the
functions name and it works
Thank you both for your help
Thanks
-Original Message-
From: Brent Fraser [mailto:bfra...@geoanalytic.com]
Sent: Monday, December 07, 2009 12:54 PM
To: Jay Kapalczynski
Cc: 'geomoose-develop...@lists.sourceforge.net';
'mapserver-users@lists.osgeo.org'
Subject: Re: [Geomoose-developers] aJAX
Actually they are not identical (there's an extra ) in getRunquery. And
there
could be other syntax problems...
Jay Kapalczynski wrote:
I am trying to write some ajax here to run a query. I simplified this
down so that no query is happening, rather just getting all the pages to
work together and return some text.
I don't know whats going on here
1. I created a button that calls a javascript function
input type=button value=Send to Ajax and Tab
onClick=ReturnQueryResults();
2. This function is calling and passing an ajax page some info.
function ReturnQueryResults() {
getRunquery('parcellinktest.php','121190012','S')
/*
getResulthype('parcellinktest.php','121190012','S') */
}
3. Once there it (depending on what is commented out in the ajax
page) it runs one of two functions (both of which are IDENTICAL)
But for some reason when I run the getRunquery I get errorsbut when I
run the getResulthype it works.
I am passing the same values to the same php page.
I just added the getRunquery to the ajax page.
*function getResulthype(page,id,type){*
var _target = 'content_details_form';
if (id.length == 0) {
document.getElementById(_target).innerHTML=bNo Information
Available/b;
return;
}
xmlHttp = GetAJAXObject();
if (xmlHttp==null) {
alert (Unable to process your request, your browser does not
support AJAX!);
return;
}
var url =
http://127.0.0.1:80/geomoose/php/+page+?id=+id+type=+type;
xmlHttp.onreadystatechange = showResult;
xmlHttp.open(GET,url,true);
xmlHttp.send(null);
}
*function getRunquery(page,id,type){*
var _target = 'content_details_form';
if (url.length == )) {
document.getElementById(_target_.innerHTML=bNo Information
Available/b;
return;
}
xmlhttp = GetAJAXObject();
if {xmlHttp==null) {
alert (Unable to process you request, your browser does
not support AJAX);
return;
}
var url =
http://127.0.0.1:80/geomoose/php/+page+?id=+id+type=+type;
xmlHttp.onreadystatechange = showResult;
xmlHttp.open(GET,url,true);
xmlHttp.send(null);
}
I thought something might be hanging so I cleared all temp files, shut
down, restarted Apache.
If the values are the same, and they are being sent to the same page how
can I be getting errors
Error:
getRunquery is not defined
getRunquery('parcellinktest.php','121190012','S')
--
Join us December 9, 2009 for the Red Hat Virtual Experience,
a free event focused on virtualization and cloud computing.
Attend in-depth sessions from your desk. Your couch. Anywhere.
http://p.sf.net/sfu/redhat-sfdev2dev
___
Geomoose-developers mailing list
geomoose-develop...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geomoose-developers
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] RE: [Geomoose-developers] aJAX
One last syntax question
When I call the ajax page to send the values to:
getRunquery('parcellinktest.php','121190012','S')
Whats the syntax to replace the '121190012' with a variable?
I tried this:
getRunquery('parcellinktest.php', .'varaible'. ,'S')
thanks again
-Original Message-
From: Brent Fraser [mailto:bfra...@geoanalytic.com]
Sent: Monday, December 07, 2009 12:54 PM
To: Jay Kapalczynski
Cc: 'geomoose-develop...@lists.sourceforge.net';
'mapserver-users@lists.osgeo.org'
Subject: Re: [Geomoose-developers] aJAX
Actually they are not identical (there's an extra ) in getRunquery. And there
could be other syntax problems...
Jay Kapalczynski wrote:
I am trying to write some ajax here to run a query. I simplified this
down so that no query is happening, rather just getting all the pages to
work together and return some text.
I don't know whats going on here
1. I created a button that calls a javascript function
input type=button value=Send to Ajax and Tab
onClick=ReturnQueryResults();
2. This function is calling and passing an ajax page some info.
function ReturnQueryResults() {
getRunquery('parcellinktest.php','121190012','S')
/*
getResulthype('parcellinktest.php','121190012','S') */
}
3. Once there it (depending on what is commented out in the ajax
page) it runs one of two functions (both of which are IDENTICAL)
But for some reason when I run the getRunquery I get errorsbut when I
run the getResulthype it works.
I am passing the same values to the same php page.
I just added the getRunquery to the ajax page.
*function getResulthype(page,id,type){*
var _target = 'content_details_form';
if (id.length == 0) {
document.getElementById(_target).innerHTML=bNo Information
Available/b;
return;
}
xmlHttp = GetAJAXObject();
if (xmlHttp==null) {
alert (Unable to process your request, your browser does not
support AJAX!);
return;
}
var url =
http://127.0.0.1:80/geomoose/php/+page+?id=+id+type=+type;
xmlHttp.onreadystatechange = showResult;
xmlHttp.open(GET,url,true);
xmlHttp.send(null);
}
*function getRunquery(page,id,type){*
var _target = 'content_details_form';
if (url.length == )) {
document.getElementById(_target_.innerHTML=bNo Information
Available/b;
return;
}
xmlhttp = GetAJAXObject();
if {xmlHttp==null) {
alert (Unable to process you request, your browser does
not support AJAX);
return;
}
var url =
http://127.0.0.1:80/geomoose/php/+page+?id=+id+type=+type;
xmlHttp.onreadystatechange = showResult;
xmlHttp.open(GET,url,true);
xmlHttp.send(null);
}
I thought something might be hanging so I cleared all temp files, shut
down, restarted Apache.
If the values are the same, and they are being sent to the same page how
can I be getting errors
Error:
getRunquery is not defined
getRunquery('parcellinktest.php','121190012','S')
--
Join us December 9, 2009 for the Red Hat Virtual Experience,
a free event focused on virtualization and cloud computing.
Attend in-depth sessions from your desk. Your couch. Anywhere.
http://p.sf.net/sfu/redhat-sfdev2dev
___
Geomoose-developers mailing list
geomoose-develop...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geomoose-developers
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] RE: [Geomoose-developers] aJAX
NEVER MIND GOT IT.just took the ' ' off.
getRunquery('parcellinktest.php',varaible,'S')
From: Jay Kapalczynski
Sent: Monday, December 07, 2009 2:31 PM
To: 'Brent Fraser'
Cc: 'geomoose-develop...@lists.sourceforge.net';
'mapserver-users@lists.osgeo.org'
Subject: RE: [Geomoose-developers] aJAX
One last syntax question
When I call the ajax page to send the values to:
getRunquery('parcellinktest.php','121190012','S')
Whats the syntax to replace the '121190012' with a variable?
I tried this:
getRunquery('parcellinktest.php', .'varaible'. ,'S')
thanks again
-Original Message-
From: Brent Fraser [mailto:bfra...@geoanalytic.com]
Sent: Monday, December 07, 2009 12:54 PM
To: Jay Kapalczynski
Cc: 'geomoose-develop...@lists.sourceforge.net';
'mapserver-users@lists.osgeo.org'
Subject: Re: [Geomoose-developers] aJAX
Actually they are not identical (there's an extra ) in getRunquery. And there
could be other syntax problems...
Jay Kapalczynski wrote:
I am trying to write some ajax here to run a query. I simplified this
down so that no query is happening, rather just getting all the pages to
work together and return some text.
I don't know whats going on here
1. I created a button that calls a javascript function
input type=button value=Send to Ajax and Tab
onClick=ReturnQueryResults();
2. This function is calling and passing an ajax page some info.
function ReturnQueryResults() {
getRunquery('parcellinktest.php','121190012','S')
/*
getResulthype('parcellinktest.php','121190012','S') */
}
3. Once there it (depending on what is commented out in the ajax
page) it runs one of two functions (both of which are IDENTICAL)
But for some reason when I run the getRunquery I get errorsbut when I
run the getResulthype it works.
I am passing the same values to the same php page.
I just added the getRunquery to the ajax page.
*function getResulthype(page,id,type){*
var _target = 'content_details_form';
if (id.length == 0) {
document.getElementById(_target).innerHTML=bNo Information
Available/b;
return;
}
xmlHttp = GetAJAXObject();
if (xmlHttp==null) {
alert (Unable to process your request, your browser does not
support AJAX!);
return;
}
var url =
http://127.0.0.1:80/geomoose/php/+page+?id=+id+type=+type;
xmlHttp.onreadystatechange = showResult;
xmlHttp.open(GET,url,true);
xmlHttp.send(null);
}
*function getRunquery(page,id,type){*
var _target = 'content_details_form';
if (url.length == )) {
document.getElementById(_target_.innerHTML=bNo Information
Available/b;
return;
}
xmlhttp = GetAJAXObject();
if {xmlHttp==null) {
alert (Unable to process you request, your browser does
not support AJAX);
return;
}
var url =
http://127.0.0.1:80/geomoose/php/+page+?id=+id+type=+type;
xmlHttp.onreadystatechange = showResult;
xmlHttp.open(GET,url,true);
xmlHttp.send(null);
}
I thought something might be hanging so I cleared all temp files, shut
down, restarted Apache.
If the values are the same, and they are being sent to the same page how
can I be getting errors
Error:
getRunquery is not defined
getRunquery('parcellinktest.php','121190012','S')
--
Join us December 9, 2009 for the Red Hat Virtual Experience,
a free event focused on virtualization and cloud computing.
Attend in-depth sessions from your desk. Your couch. Anywhere.
http://p.sf.net/sfu/redhat-sfdev2dev
___
Geomoose-developers mailing list
geomoose-develop...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geomoose-developers
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] html and ajax query
I am trying to get the user to choose from 2 comboboxes...cant seem to get this
to work...maybe someone out there can see something I am doin wrong?
I think this how it works? Using the code below
The user selects two values in combo boxes (PriceFactor and PriceArea)
Click the button to call function ReturnQueryResults
The Array is built from the values of the two dropdown boxes (id =
PriceFactor and id = PriceArea) using their ID values
The javascript call is made that calls Ajax page which sends the php page the
array of values. I then have to parse the ID (the array) with Get in the php
page, formatting the output, which is then shown on the target specified in the
Ajax page.
The results go back to the back to the ajax page
I don't have a great understanding of this...trying with a couple dropdowns to
start.
Any help would be greatly appreciated...I think I am pretty close but can use
another set of eyes...
THanks
HTML PAGE:
pbPlease Choose Price Factor:/bbr
select name=PriceFactor id=PriceFactor
option value=/option
option
value=greaterthanGreater Than/option
option value=lessthanLess
Than/option
option
value=betweenBetween/option
option value=equaltoEqual
To/option
option
value=greaterthanequaltoGreater Than Equal To/option
option
value=lessthanequaltoLess Than Equal To/option
/select
pbPlease Choose Area:/bbr
select name=PriceArea id=PriceArea
option value=/option
option value=100100/option
option value=500500/option
option value=700700/option
/select
input type=button value=Send to Ajax and Tab
onClick=ReturnQueryResults();
br
br
script type=text/javascript
function ReturnQueryResults() {
var url = PropertyQuery3?;
var input_values_to_append =
new Array('PriceFactor','PriceArea');
for(var i = 0; i
input_values_to_append.length; i++) {
url +=
''+input_values_to_append[i].name+'='+input_values_to_append[i].value;
}
javascript:getResulthype('url')
}
/script
AJAX Page:
function getResulthype(url){
var _target = 'content_details_form';
if (id.length == 0) {
document.getElementById(_target).innerHTML=bNo Information
Available/b;
return;
}
xmlHttp = GetAJAXObject();
if (xmlHttp==null) {
alert (Unable to process your request, your browser does not support
AJAX!);
return;
}
var url = http://127.0.0.1:80/webapp/php/+url+;;
xmlHttp.onreadystatechange = showResult;
xmlHttp.open(GET,url,true);
xmlHttp.send(null);
}
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] RE: Extents
I am plotting an XY coordinate in my map using an OVF file to hit the MySQL
database.
I then have a button that calls a .js page and refreshes the layer...
As the XY changes in the database it appears to be tracking in the map
I want to take this one step further and test the recently plotted XY to see if
it s in the current extent. If not then recenter.
PART 1
BUITTON: Calls the .js page sets an interval and refreshes the layer Database
service name=refreshLayers3 title=Refresh Layer every 2 Seconds
type=internal default=true locked=true command=setIntervalNow()
icon=shared/images/toolbar/MapleGrove_Buttons/Reload.jpg
highlight=shared/images/toolbar/MapleGrove_Buttons/Pictometry.jpg/
.js PAGE:
//setIntervalNow();
var varTest = -1;
function setIntervalNow()
{
varTest = setInterval(setIntervalNow2(), 3000);
}
function setIntervalNow2()
{
Events.triggerEvent('refreshlayer', 'Database');
}
PART 2
What I want to do is grab the current XY and test to see if its in the current
extent
If not then create another extent and zoom to it.
Right now I am having a hard time trying to join the two parts.
For this part I am launching the code from the Identify button which calls an
Ajax page and passes the Extent to a PHP page
tr
td align=center width='100'Tracking Testing:/td
td style= cursor:pointer align=center
onclick=javascript:getnewresults('XY_MapRecenter.php','[imgext]','[miny]','[maxx]','[maxy]')font
size='2' color='#007FFF' Open Images/font/td
/tr
I can get test and make the new Extent but can only return the values to a tab
and then fire it off from a buttonwhat I want to do is have this done
automatically...
I don't know how I can do this...
Thanks
-Original Message-
From: Steve Lime [mailto:steve.l...@dnr.state.mn.us]
Sent: Friday, October 09, 2009 2:23 PM
To: Jay Kapalczynski; 'mapserver-users@lists.osgeo.org'
Subject: RE: [mapserver-users] RE: Extents
Still confused on what you're trying to do. It sounds like your PHP code is
hitting the database to
get the xy's. You could poll that PHP page as necessary via AJAX and have it
return the xy data
as JSON. Then you use the JSON data accordingly to control GeoMoose by zooming
to a point or
whatever. I don't know if GeoMoose provides AJAX wrappers or not, that's a
question for that
another mailing list...
Steve
On 10/6/2009 at 1:33 PM, in message
d7a5eac385604446ab1dd24bf4f5a918a00826a...@mg-mail.ci.maple-grove.mn.us, Jay
Kapalczynski jkapalczyn...@ci.maple-grove.mn.us wrote:
I am using GeoMOOSE if that sheds new light on this...
What I am trying to do is click a button.
This calls a js page that runs some code every few seconds. Right now its
simply refreshing a specific layer.
I want the code to grab the extent of the current map
I then use an XY to recreate a new extent.
Then zoom to that extent.
I am getting the XY from a database. Testing to see if within current
extent.
If not I want it to recenter (zoom to new extent I calculated)
Currently I am doing this in php...the only thing is that I cant figure out
how to get the app to recenter from PHP.
I can do it from a button (see below) but I need it to work automatically
h5 style=margin:0px; padding:0px;bZoom to View String:/b a
href=javascript:Map.zoomToViewString(453633.29 + ',' + 4984898.68 + ',' +
464278.99 + ',' + 4995544.38)img src=shared/images/view.png border=0
title=Click to Zoom Map to PID/a
I have everything I need ( I think ) but need to figure out how to get the
js page to retireve the extent, then I can fire to above off in javascript.
That make sense
Thanks for your thoughts Steve...
-Original Message-
From: Steve Lime [mailto:steve.l...@dnr.state.mn.us]
Sent: Tuesday, October 06, 2009 1:25 PM
To: Jay Kapalczynski; 'mapserver-users@lists.osgeo.org'
Subject: [mapserver-users] RE: Extents
Why wouldn't you get the extent at the same time you get the map? You had to
have one to retrieve
it in the first place. -Steve
On 10/6/2009 at 1:17 PM, in message
d7a5eac385604446ab1dd24bf4f5a918a00826a...@mg-mail.ci.maple-grove.mn.us, Jay
Kapalczynski jkapalczyn...@ci.maple-grove.mn.us wrote:
Can I call or make a request from a .js page to get the extent of my map?
From: Jay Kapalczynski
Sent: Tuesday, October 06, 2009 8:35 AM
To: mapserver-users@lists.osgeo.org
Subject: Extents
I have a applications using MapServer. I have a button that runs some code
on a .js page every few seconds.
What I need to do is somehow get the map extent to the .js page.
Is it possible to write some javascript code to retrieve the maps extent
every few seconds?
Thanks
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Button / Automaticly run
I have this button which I am running from a button in a php page, which is simply zooming to a new extent. Is there any way to automatically run this code...instead of assigning it to a button? echo h5 style=\margin:0px; padding:0px;\bZoom to View String:/ba href=\javascript:Map.zoomToViewString(.$varextentminx. + ',' + .$varextentminy. + ',' + .$varextentmaxx. + ',' + .$varextentmaxy.)\img src=\shared/images/view.png\ border=\0\ title=\Click to Zoom Map to PID\/a; Thanks ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Extents
I have a applications using MapServer. I have a button that runs some code on a .js page every few seconds. What I need to do is somehow get the map extent to the .js page. Is it possible to write some javascript code to retrieve the maps extent every few seconds? Thanks ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] RE: Extents
Can I call or make a request from a .js page to get the extent of my map? From: Jay Kapalczynski Sent: Tuesday, October 06, 2009 8:35 AM To: mapserver-users@lists.osgeo.org Subject: Extents I have a applications using MapServer. I have a button that runs some code on a .js page every few seconds. What I need to do is somehow get the map extent to the .js page. Is it possible to write some javascript code to retrieve the maps extent every few seconds? Thanks ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] RE: Extents
I am using GeoMOOSE if that sheds new light on this... What I am trying to do is click a button. This calls a js page that runs some code every few seconds. Right now its simply refreshing a specific layer. I want the code to grab the extent of the current map I then use an XY to recreate a new extent. Then zoom to that extent. I am getting the XY from a database. Testing to see if within current extent. If not I want it to recenter (zoom to new extent I calculated) Currently I am doing this in php...the only thing is that I cant figure out how to get the app to recenter from PHP. I can do it from a button (see below) but I need it to work automatically h5 style=margin:0px; padding:0px;bZoom to View String:/b a href=javascript:Map.zoomToViewString(453633.29 + ',' + 4984898.68 + ',' + 464278.99 + ',' + 4995544.38)img src=shared/images/view.png border=0 title=Click to Zoom Map to PID/a I have everything I need ( I think ) but need to figure out how to get the js page to retireve the extent, then I can fire to above off in javascript. That make sense Thanks for your thoughts Steve... -Original Message- From: Steve Lime [mailto:steve.l...@dnr.state.mn.us] Sent: Tuesday, October 06, 2009 1:25 PM To: Jay Kapalczynski; 'mapserver-users@lists.osgeo.org' Subject: [mapserver-users] RE: Extents Why wouldn't you get the extent at the same time you get the map? You had to have one to retrieve it in the first place. -Steve On 10/6/2009 at 1:17 PM, in message d7a5eac385604446ab1dd24bf4f5a918a00826a...@mg-mail.ci.maple-grove.mn.us, Jay Kapalczynski jkapalczyn...@ci.maple-grove.mn.us wrote: Can I call or make a request from a .js page to get the extent of my map? From: Jay Kapalczynski Sent: Tuesday, October 06, 2009 8:35 AM To: mapserver-users@lists.osgeo.org Subject: Extents I have a applications using MapServer. I have a button that runs some code on a .js page every few seconds. What I need to do is somehow get the map extent to the .js page. Is it possible to write some javascript code to retrieve the maps extent every few seconds? Thanks ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] Mapserver consuming Google Maps
How do I write code (map File) to consume aerial images (not obliques) from Google maps or Bing etc. This is an example of a few services that I am consuming right now... BUT need the aerialsI assume that I can consume the aerials just as you see in Bing or Google Maps.. Any help would be greatly appreciated. map title=Weather Radar default=false zindex=-1 filehttp://mesonet.agron.iastate.edu/cgi-bin/wms/nexrad/n0r.cgi?LAYERS=nexrad-n0ramp;SERVICE=WMSamp;VERSION=1.1.1amp;REQUEST=GetMapamp;STYLES=amp;FORMAT=image/pngamp;SRS=EPSG:26915amp;BBOX=%MINX%,%MINY%,%MAXX%,%MAXY%amp;WIDTH=%WIDTH%amp;HEIGHT=%HEIGHT%amp;TRANSPARENT=TRUE/file /map map title=Infrared Satellite default=false zindex=-1 filehttp://mesonet.agron.iastate.edu/cgi-bin/wms/nexrad/conus_ir.cgi?LAYERS=nexrad-iramp;SERVICE=WMSamp;VERSION=1.1.1amp;REQUEST=GetMapamp;STYLES=amp;FORMAT=image/pngamp;SRS=EPSG:26915amp;BBOX=%MINX%,%MINY%,%MAXX%,%MAXY%amp;WIDTH=%WIDTH%amp;HEIGHT=%HEIGHT%amp;TRANSPARENT=TRUE/file /map -Original Message- From: Christopher Schmidt [mailto:crschm...@metacarta.com] Sent: Monday, September 21, 2009 4:14 PM To: Jay Kapalczynski Subject: Re: [mapserver-users] Mapserver consuming Google Maps On Mon, Sep 21, 2009 at 03:49:54PM -0500, Jay Kapalczynski wrote: I am trying to see if there is a way to consume the Aerial images from Google Maps inside a map server / open layers application. Not the obliques... Is this at all possible? Even fee based OpenLayers does this by design. (It is not a 'Desktop client'.) So yes. If you want more information, send mail to a mailing list, rather than to me personally. -- Chris -Original Message- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Christopher Schmidt Sent: Wednesday, August 26, 2009 12:16 PM To: Marco Foi (marco.foi) Cc: Rahkonen Jukka; mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] Mapserver consuming Google Maps On Wed, Aug 26, 2009 at 05:13:53PM +0200, Marco Foi (marco.foi) wrote: Some time ago a similar issue was raised among UDig users and the conclusion was that: IT IS NOT POSSIBLE to consume Google Maps in Desktop clients. This isn't strictly true. Desktop clients which are capable of embedding a browser can use the browser, render a scene, take the resulting image, and display that to the client. There are a number of clients which do exactly that in OpenStreetMap editors, for example. However, this is obviousl significantly more complex than just fetching the tiles, which is the way most people discuss doing it. Anything is possible, but that doesn't mean it will be easy. Regards, -- Christopher Schmidt MetaCarta ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- Christopher Schmidt MetaCarta ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] plotting points dynamically
Suman I am doing this another way Although I am using GeoMoose/MapServer... I am using an OGR connection in my map file to connect to a MySQL database via a OVF filethis is plotting Points based on XY Coordinates, which is querying the database. I am would have to look up again what I am doing if you are interested in this. Is this something like you are doing Bobb. I am not familiar with the Query/Render engine in map server. Jay From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Bob Basques Sent: Tuesday, June 30, 2009 10:03 AM To: Suman Chatterjee; mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] plotting points dynamically The best approach I can think of, would be to figure out how to add the points to the database in a dynamic method, and use MapServer as the Query/Render engine. This is how we do GPS location points for example. The points are loaded into the Database (POSTGIS) and simply (re)read as a display request by MapServer. Just set up both sides, the Database and the MapServer connectivity to the database as two separate processes, and that should get you what you are after. bobb Suman Chatterjee schatter...@addisontx.gov wrote: Hi all, I am working on a project which requires adding points to a basic map dynamically. That means the basic map will be read from the map file. Then the points will be queried from a database preferably PostGreSQL and then plotted on the map. I cannot add the query to the map file because the points will be generated dynamically at regular intervals. Is there any way I can do this in mapserver? *** This e-mail and any files or attachments transmitted with it contains Information that is confidential and privileged. This document may contain Protected Health Information (PHI) or other information that is intended only for the use of the individual(s) and entity(ies) to whom it is addressed. If you are the intended recipient, further disclosures are prohibited without proper authorization. If you are not the intended recipient, any disclosure, copying, printing, or use of this information is strictly prohibited and possibly a violation of federal or state law and regulations. If you have received this information in error, please delete it and notify Hamid Khaleghipour at 972-450-2868 immediately. Thank you. *** ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] RE: Highlight
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. 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. Then Classify in the Map file the color and outline that I am after. Could I use a filter on the Map file then to just show records in the database? Is this even possible or make sense? OVF File (but select the PID values from the table) OGRVRTDataSource OGRVRTLayer name=Coordinatedata SrcDataSourceMYSQL:coordinates_database,user=Jay,password=Passw0rd,host=127.0.0.1,port=3306,tables=coordinates/SrcDataSource SrcSQLSELECT X,Y FROM coordinates/SrcSQL GeometryTypewkbPoint/GeometryType GeometryField encoding=PointFromColumns x=X y=Y/ /OGRVRTLayer /OGRVRTDataSource MAP FILE LAYER # Points from the MySQL Database NAME Database STATUS DEFAULT TYPE POLYGON CONNECTIONTYPE OGR CONNECTION './Coordinatedata1.ovf' DATA 'Coordinatedata' CLASS #NAME ID STYLE OUTLINECOLOR 204 204 204 WIDTH 1 END END END -Original Message- From: Steve Lime [mailto:steve.l...@dnr.state.mn.us] Sent: Tuesday, April 14, 2009 4:18 PM To: Jay Kapalczynski; mapserver-users@lists.osgeo.org; Paul T.' 'Moen; David' 'Fawcett Subject: RE: [mapserver-users] RE: Highlight This is an example of how to highlight a feature (click on a dot in the application I sent) without doing query maps or anything like that. You're manipulating a layer filter on-the-fly based on your search result. This can work with multiple results but is best suited to just a few results. With more than that you really need to look at some other way to cache features- a queryfile or some sort of a temp table. Sorry if I've confused things. Steve On 4/14/2009 at 3:23 PM, in message d7a5eac385604446ab1dd24bf4f5a9184fb90ee...@mg-mail.ci.maple-grove.mn.us, Jay Kapalczynski jkapalczyn...@ci.maple-grove.mn.us wrote: I am having a hard time trying to understand how that applies to what I am doingI do appreciate the help here. Just trying to find a solution here... From my main page I run a query in PHP that returns specific records I then move to a different web page that has a couple frames. I display the map in one frame and build a table in the 2nd frame that shows the results. In the table I have a field that will zoom to and identify that feature in the main map The only thing I am missing is after I run the query none of the parcels are highlighted in the map... I want to create the table and highlight the returned parcels in the map... Getting pretty confused right now...dont know the best way to accomplish this...going in 4 different directions right now.. The Query is being done in PHP, so I somehow need to take that result (comma delimited string) and get a the PID values from that to show up highlighted in my map.. Before I go on does anyone have a suggestion as to what would be the best course of action... Like Steve said, Like I am doing... Thanks Guys...you help is appreciated... -Original Message- From: Fawcett, David [mailto:david.fawc...@state.mn.us] Sent: Tuesday, April 14, 2009 2:39 PM To: Jay Kapalczynski; Steve Lime; mapserver-users@lists.osgeo.org; Paul T.' 'Moen Subject: RE: [mapserver-users] RE: Highlight Steve is using CGI MapServer instead of php. When you click on a station, you will notice that the outline of the station turns yellow. Here is the URL to a tile with a highlighted symbol on it: http://maps.dnr.state.mn.us/cgi-bin/mapserv52?map=/usr/local/mapserver/a pps/waters/csg/csg.maplayers=active_sitemap_transparent=trueid=0mode =mapmap_imagetype=pngstation=63023001mapext=-27687.5+4793250+941687.5 +5480750imgext=-27687.5+4793250+941687.5+5480750map_size=705+500imgx= 352.5imgy=250imgxy=705+500 Notice that he has a layer called 'active_site' and he is passing in the station ID use in a class in that layer to turn only that feature yellow. When no station is selected, no stations are drawn in the 'active_site' layer. David. -Original Message- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Jay Kapalczynski Sent: Tuesday, April 14, 2009 2:30 PM To: 'Steve Lime'; mapserver-users@lists.osgeo.org; Paul T.' 'Moen Subject: RE: [mapserver-users] RE: Highlight Thanksbut little confused as to what I am look at... How is this working? -Original Message- From: Steve Lime [mailto:steve.l...@dnr.state.mn.us] Sent: Tuesday, April
[mapserver-users] Labeling via OGR, MySQL table
I am plotting a few points via an OVF file and MySQL table The points show up fine... As soon as I try to label from the MySQL table the Star points disappear... I imagine I have some syntax issues or missing something in the map file (See below) Any thoughts? THANKS HERE ARE THE POINTS LAYER # Points from the MySQL Database NAME Database STATUS DEFAULT TYPE POINT CONNECTIONTYPE OGR CONNECTION './Coordinatedata1.ovf' DATA 'Coordinatedata' CLASS #NAME ID STYLE SYMBOL star SIZE 15 COLOR 238 0 0 END END END CANT GET THE LABELS TO SHOW UP LAYER # Points from the MySQL Database NAME Database STATUS DEFAULT TYPE POINT CONNECTIONTYPE OGR CONNECTION './Coordinatedata1.ovf' DATA 'Coordinatedata' LABELITEM 'Name' LABELCACHE ON CLASS LABEL COLOR 0 0 0 SIZE 7 END END END ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] RE: Labeling via OGR, MySQL table
This is my ovf file: Name is the field I want to label on... Anyone have any thoughts? OGRVRTDataSource OGRVRTLayer name=Coordinatedata SrcDataSourceMYSQL:coordinates_database,user=Jay,password=Passw0rd,host=127.0.0.1,port=3306,tables=coordinates/SrcDataSource SrcSQLSELECT X,Y,Name FROM coordinates/SrcSQL GeometryTypewkbPoint/GeometryType GeometryField encoding=PointFromColumns x=X y=Y/ /OGRVRTLayer /OGRVRTDataSource From: Jay Kapalczynski Sent: Thursday, April 16, 2009 12:02 PM To: mapserver-users@lists.osgeo.org Subject: Labeling via OGR, MySQL table I am plotting a few points via an OVF file and MySQL table The points show up fine... As soon as I try to label from the MySQL table the Star points disappear... I imagine I have some syntax issues or missing something in the map file (See below) Any thoughts? THANKS HERE ARE THE POINTS LAYER # Points from the MySQL Database NAME Database STATUS DEFAULT TYPE POINT CONNECTIONTYPE OGR CONNECTION './Coordinatedata1.ovf' DATA 'Coordinatedata' CLASS #NAME ID STYLE SYMBOL star SIZE 15 COLOR 238 0 0 END END END CANT GET THE LABELS TO SHOW UP LAYER # Points from the MySQL Database NAME Database STATUS DEFAULT TYPE POINT CONNECTIONTYPE OGR CONNECTION './Coordinatedata1.ovf' DATA 'Coordinatedata' LABELITEM 'Name' LABELCACHE ON CLASS LABEL COLOR 0 0 0 SIZE 7 END END END ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] RE: Labeling via OGR, MySQL table
I was able to get some text to display with this: ALTHOUGH I could only get the fields that were Numeric to label...cant get text fields to display. Is this a syntax thing or is it not possible? OGRVRTDataSource OGRVRTLayer name=Coordinatedata SrcDataSourceMYSQL:coordinates_database,user=Jay,password=Letmein,host=127.0.0.1,port=3306,tables=coordinates/SrcDataSource SrcSQLSELECT X,Y,ID FROM coordinates/SrcSQL GeometryTypewkbPoint/GeometryType GeometryField encoding=PointFromColumns x=X y=Y/ /OGRVRTLayer /OGRVRTDataSource LAYER # Points from the MySQL Database NAME Database STATUS DEFAULT TYPE ANNOTATION CONNECTIONTYPE OGR CONNECTION './Coordinatedata1.ovf' DATA 'Coordinatedata' LABELITEM 'ID' LABELCACHE ON CLASS LABEL POSITION CC FONT vera_sans TYPE TRUETYPE COLOR 0 0 0 OUTLINECOLOR 255 255 128 SIZE 7 END END END From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Jay Kapalczynski Sent: Thursday, April 16, 2009 1:29 PM To: 'mapserver-users@lists.osgeo.org' Subject: [mapserver-users] RE: Labeling via OGR, MySQL table This is my ovf file: Name is the field I want to label on... Anyone have any thoughts? OGRVRTDataSource OGRVRTLayer name=Coordinatedata SrcDataSourceMYSQL:coordinates_database,user=Jay,password=Passw0rd,host=127.0.0.1,port=3306,tables=coordinates/SrcDataSource SrcSQLSELECT X,Y,Name FROM coordinates/SrcSQL GeometryTypewkbPoint/GeometryType GeometryField encoding=PointFromColumns x=X y=Y/ /OGRVRTLayer /OGRVRTDataSource From: Jay Kapalczynski Sent: Thursday, April 16, 2009 12:02 PM To: mapserver-users@lists.osgeo.org Subject: Labeling via OGR, MySQL table I am plotting a few points via an OVF file and MySQL table The points show up fine... As soon as I try to label from the MySQL table the Star points disappear... I imagine I have some syntax issues or missing something in the map file (See below) Any thoughts? THANKS HERE ARE THE POINTS LAYER # Points from the MySQL Database NAME Database STATUS DEFAULT TYPE POINT CONNECTIONTYPE OGR CONNECTION './Coordinatedata1.ovf' DATA 'Coordinatedata' CLASS #NAME ID STYLE SYMBOL star SIZE 15 COLOR 238 0 0 END END END CANT GET THE LABELS TO SHOW UP LAYER # Points from the MySQL Database NAME Database STATUS DEFAULT TYPE POINT CONNECTIONTYPE OGR CONNECTION './Coordinatedata1.ovf' DATA 'Coordinatedata' LABELITEM 'Name' LABELCACHE ON CLASS LABEL COLOR 0 0 0 SIZE 7 END END END ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] RE: Highlight
Steve no worrieswasnt trying to shoot your idea down...I am using something similar in another layer and it works great.. All thoughts are welcome...I was thinking about this last night... There has to be a way to take a selection set from a query and have that highlight features of an existing shapefile from PHP Just have to find it...Thanks again Steve for your thoughts and help..they are greatly appreciated... -Original Message- From: Steve Lime [mailto:steve.l...@dnr.state.mn.us] Sent: Tuesday, April 14, 2009 4:18 PM To: Jay Kapalczynski; mapserver-users@lists.osgeo.org; Paul T.' 'Moen; David' 'Fawcett Subject: RE: [mapserver-users] RE: Highlight This is an example of how to highlight a feature (click on a dot in the application I sent) without doing query maps or anything like that. You're manipulating a layer filter on-the-fly based on your search result. This can work with multiple results but is best suited to just a few results. With more than that you really need to look at some other way to cache features- a queryfile or some sort of a temp table. Sorry if I've confused things. Steve On 4/14/2009 at 3:23 PM, in message d7a5eac385604446ab1dd24bf4f5a9184fb90ee...@mg-mail.ci.maple-grove.mn.us, Jay Kapalczynski jkapalczyn...@ci.maple-grove.mn.us wrote: I am having a hard time trying to understand how that applies to what I am doingI do appreciate the help here. Just trying to find a solution here... From my main page I run a query in PHP that returns specific records I then move to a different web page that has a couple frames. I display the map in one frame and build a table in the 2nd frame that shows the results. In the table I have a field that will zoom to and identify that feature in the main map The only thing I am missing is after I run the query none of the parcels are highlighted in the map... I want to create the table and highlight the returned parcels in the map... Getting pretty confused right now...dont know the best way to accomplish this...going in 4 different directions right now.. The Query is being done in PHP, so I somehow need to take that result (comma delimited string) and get a the PID values from that to show up highlighted in my map.. Before I go on does anyone have a suggestion as to what would be the best course of action... Like Steve said, Like I am doing... Thanks Guys...you help is appreciated... -Original Message- From: Fawcett, David [mailto:david.fawc...@state.mn.us] Sent: Tuesday, April 14, 2009 2:39 PM To: Jay Kapalczynski; Steve Lime; mapserver-users@lists.osgeo.org; Paul T.' 'Moen Subject: RE: [mapserver-users] RE: Highlight Steve is using CGI MapServer instead of php. When you click on a station, you will notice that the outline of the station turns yellow. Here is the URL to a tile with a highlighted symbol on it: http://maps.dnr.state.mn.us/cgi-bin/mapserv52?map=/usr/local/mapserver/a pps/waters/csg/csg.maplayers=active_sitemap_transparent=trueid=0mode =mapmap_imagetype=pngstation=63023001mapext=-27687.5+4793250+941687.5 +5480750imgext=-27687.5+4793250+941687.5+5480750map_size=705+500imgx= 352.5imgy=250imgxy=705+500 Notice that he has a layer called 'active_site' and he is passing in the station ID use in a class in that layer to turn only that feature yellow. When no station is selected, no stations are drawn in the 'active_site' layer. David. -Original Message- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Jay Kapalczynski Sent: Tuesday, April 14, 2009 2:30 PM To: 'Steve Lime'; mapserver-users@lists.osgeo.org; Paul T.' 'Moen Subject: RE: [mapserver-users] RE: Highlight Thanksbut little confused as to what I am look at... How is this working? -Original Message- From: Steve Lime [mailto:steve.l...@dnr.state.mn.us] Sent: Tuesday, April 14, 2009 1:02 PM To: Jay Kapalczynski; mapserver-users@lists.osgeo.org; Paul T.' 'Moen Subject: RE: [mapserver-users] RE: Highlight This is probably too late to be of use but I've been using a highlight layer to achieve this. The layer takes input from a URL so that layer filter allows just the desired feature through. Works quite nicely and is relatively simple to implement. Here's an OpenLayers site that uses this: http://www.dnr.state.mn.us/waters/csg/index_copy.html In this case the highlight is a separate layer but you could just as easily return a single map. Steve On 4/13/2009 at 11:17 AM, in message d7a5eac385604446ab1dd24bf4f5a91841f1a74...@mg-mail.ci.maple-grove.mn.us , Jay Kapalczynski jkapalczyn...@ci.maple-grove.mn.us wrote: So say I have a Database that I am querying... I get the results back with a PID number (unique) This number exists in the Parcels Shapefile so I can go after that field. I have a map file that is set up for the Parcels
RE: [mapserver-users] RE: Highlight
Thanks for the help and responseI think I am getting closer...
I set up another php page...this page is getting the PID values sent to it via
a session, I am using frames in this page
It was the only way I could get the queries to work, the table to build...etc
You can see the session code below...I echo it and all the correct PIDs are
displayed so I know that I have passed to correctly.
I added your code example...
Note: the PID string is a comma delimited string of PID values
I am pointing the frame to the PHP page and I get this, but no image. So part
of my code is working
String:0711922340036,0711922340038,0711922340039
But that's itthere is no jpeg...
Again I am very green to thisthis is my first attempt to actually return an
image... here...
I tried to add this : for my reference library for the ms_newMapObj but I get
errors...
So I went back to the GeoMOOSE libraries...(As see below)
No errors but no image
dl('php_mapscript.so');
I am going to try and post this on their site but help is hard to find...
Anyone else out here on the MapServer page mess around with GeoMOOSE...
THANK YOU MOEN for your help it is very appreciated..
?php
session_start();
$varPIDValue = $_SESSION[PIDString];
// Echo the session values THIS GIVES ME A COMMA DELIMITED STRING OF PID VALUES
// MAYBE I HAVE TO EXPLODE THEM FIRST?
echo String:.$varPIDValue;
error_reporting(E_ERROR | E_PARSE);
# Include the GeoMOOSE PHP Library Utilities
include('Configuration.php');
include('geomoose_php_util.php');
$map = ms_newMapObj('/ms4w/apps/GeoMOOSE/Maple_Grove_GeoMoose/select.map');
$qlayer = $map-$map-getLayerByName('parcels');
$qlayer-queryByAttributes('PID','PID IN ($PIDString)',MS_MULTIPLE);
$img = $map-drawQuery();
$map-selectOutputFormat('jpeg');
header('Content-Type: image/jpeg');
$img-saveImage();
$image_url=$img-saveWebImage();
?
HTML
HEAD
TITLEDisplaying a map/TITLE
/HEAD
BODY
IMG SRC=?php echo $img; ?
/BODY
/HTML
From: Moen, Paul T. [mailto:pm...@nd.gov]
Sent: Monday, April 13, 2009 3:22 PM
To: Jay Kapalczynski
Cc: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] RE: Highlight
On 4/13/09 2:25 PM, Jay Kapalczynski jkapalczyn...@ci.maple-grove.mn.us
wrote:
I am messing around with thisdoes any of this map sense?
Yes, you have many errors. Check the error logs for php to help debugging with
syntax.
// THE QUERY HAPPENS BEFORE THISJUST SHOWING THAT THE VARAIBLE HOLDING ALL
THE PIS VALUES IS BELOW
//===
//===
// BUILD A COMMAN DELIMITED LIST
// if something already in $PIDString, append a comma
if (isset($PIDString))
$PIDString .= ',';
// Append the new value
$PIDString .= $PID;
//===
//===
} // end while
//===
//===
$map = ms_newMapObj(/ms4w/apps/GeoMOOSE/Maple_Grove_GeoMoose/select.map);
Won't work because it requires a string, so you would need $map =
ms_newMapObj('/ms4w/apps/GeoMOOSE/Maple_Grove_GeoMoose/select.map');
$qlayer = $map-$map-getLayerByName(parcels);
Won't work because it requires a string and the layer in your mapfile is
Parcels, so you would need $qlayer = $map-getLayerByName('Parcels');
$qlayer-queryByAttributes('PID','($PIDString)',MS_MULTIPLE);
Won't work because it needs to know how to query for the PID as in
$qlayer-queryByAttributes('PID','PID IN ($PIDString)',MS_MULTIPLE);
$img = $map-drawQuery();
Should set the output format to jpeg
$map-selectOutputFormat('jpeg');
header('Content-Type: image/jpeg');
$img-saveImage();
Can I then test the jpeg in another window or something...
You could set up your php file to accept $_GET variables and pass in the PIDs
like below.
http://yourserver.com/phpfilename.php?PID=1%2C2%2C3%2C4%2C5, which should give
you a png image after making changes above.
Is this all that I need code wise?
That should give you the basics. You will also need to load the php_mapscript
library before any of the above functions will be recognized. Check out
http://mapserver.org/mapscript/php/by_example.html. There is an abundance of
good documentation on http://mapserver.org.
HERE is the select.map file
MAP
NAME 'all layers'
SIZE 800 650
STATUS ON
EXTENT 427632.50 4893613.33 560300.922104
5015936.68
UNITS METERS
SYMBOLSET 'symbols/symbol.sym'
TRANSPARENT TRUE
IMAGETYPE PNG
QUERYMAP
STATUS ON
STYLE SELECTED
#STYLE HILITE
END
WEB
RE: [mapserver-users] RE: Highlight
Thanksbut little confused as to what I am look at...
How is this working?
-Original Message-
From: Steve Lime [mailto:steve.l...@dnr.state.mn.us]
Sent: Tuesday, April 14, 2009 1:02 PM
To: Jay Kapalczynski; mapserver-users@lists.osgeo.org; Paul T.' 'Moen
Subject: RE: [mapserver-users] RE: Highlight
This is probably too late to be of use but I've been using a highlight layer to
achieve this. The
layer takes input from a URL so that layer filter allows just the desired
feature through. Works
quite nicely and is relatively simple to implement. Here's an OpenLayers site
that uses this:
http://www.dnr.state.mn.us/waters/csg/index_copy.html
In this case the highlight is a separate layer but you could just as easily
return a single map.
Steve
On 4/13/2009 at 11:17 AM, in message
d7a5eac385604446ab1dd24bf4f5a91841f1a74...@mg-mail.ci.maple-grove.mn.us, Jay
Kapalczynski jkapalczyn...@ci.maple-grove.mn.us wrote:
So say I have a Database that I am querying...
I get the results back with a PID number (unique)
This number exists in the Parcels Shapefile so I can go after that field.
I have a map file that is set up for the Parcels, but this is just there to
draw the Parcels...
I assume that I would have to modify this one for this to work?
I am just a bit confused on how to get this to work...
When I run the code that creates the Table below I want the parcels to also
highlight in the map
Attached is my code that I am using to get the resulting PID Values, build
the table, and populate the last frame showing the Comma Delimited String.
I just don't know how to apply that to my map?
I attached my code from my PHP page which I hope that someone can at least
put their eyes on...
Towards to bottom you will see highlighted in RED the code that I am
building a comma delimited string to populate a variable with all the PID
numbers...
I assume that I would not need the comma delimited string as I could place
the highlighting code inside the while loop to get the parcels highlighted...
I don't really know...
Any thoughts?
Thanks
This inside the while loop
$map = ms_newMapObj(PATH TO YOU MAPFILE);
$qlayer = $map-$map-getLayerByName(NAME OF PARCEL LAYER);
$qlayer-queryByAttributes('PID','PID IN (MY COMMA DELIMITED STRING
VARIABLE')',MS_MULTIPLE);
$img = $map-drawQuery();
header('Content-Type: image/jpeg');
$img-saveImage();
[cid:image001.jpg@01C9BC29.7A1ECE10]
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Moen, Paul T.
Sent: Thursday, April 09, 2009 3:15 PM
To: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] RE: Highlight
If the database that you are querying has the same attributes as the shape
file, you can query the Layer that points to the shape file and display the
highlighted results on your map. I know nothing about GeoMOOSE but I know it
can be done with php-mapscript.
Regardless of what you are using, you need a map file layer for the shape
file with the parcels.
You will then need to use php-mapscript to query that layer with something
like
$map = ms_newMapObj(PATH TO YOU MAPFILE);
$qlayer = $map-$map-getLayerByName(NAME OF PARCEL LAYER);
$qlayer-queryByAttributes('PID','PID IN (1, 2,7,9,23,87)',MS_MULTIPLE);
You will then need to create the output image from query using something
like
$img = $map-drawQuery();
header('Content-Type: image/jpeg');
$img-saveImage();
I can't give you specifics without knowing how GeoMOOSE works, so the best
thing is to look at the documentation for GeoMOOSE if that is what you are
using.
On 4/9/09 2:17 PM, Jay Kapalczynski jkapalczyn...@ci.maple-grove.mn.us
wrote:
Dang I misspoke...I am sorry...
I am querying a Database for records, these records have a PID (unique
Number).
These are the records that show up in the Table.
As this happens I have to take the results and run the query against the
parcels to get the features in the Shapefile, then highlight..
If that makes any sense...
If I am in a PHP file and have the records returned from the query
(database)...what would I have to do next to take those records and run a
query to highlight the parcels (PID to PID)?
Can all of this be accomplished in the PHP file?
Thanks...and sorry for my ignorance...
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Moen, Paul T.
Sent: Thursday, April 09, 2009 1:57 PM
To: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] RE: Highlight
Set the mapfile QUERYMAP style to highlight
http://mapserver.org/mapfile/querymap.html. Draw the map using drawQuery()
instead of draw().
$img = $map-drawQuery();
header('Content-Type: image/jpeg');
$img-saveImage();
On 4/9/09 1:31 PM, Jay Kapalczynski jkapalczyn...@ci.maple-grove.mn.us
wrote:
Basically what I have is a query
RE: [mapserver-users] RE: Highlight
I am having a hard time trying to understand how that applies to what I am
doingI do appreciate the help here.
Just trying to find a solution here...
From my main page I run a query in PHP that returns specific records
I then move to a different web page that has a couple frames.
I display the map in one frame and build a table in the 2nd frame that shows
the results.
In the table I have a field that will zoom to and identify that feature in the
main map
The only thing I am missing is after I run the query none of the parcels are
highlighted in the map...
I want to create the table and highlight the returned parcels in the map...
Getting pretty confused right now...dont know the best way to accomplish
this...going in 4 different directions right now..
The Query is being done in PHP, so I somehow need to take that result (comma
delimited string) and get a the PID values from that to show up highlighted in
my map..
Before I go on does anyone have a suggestion as to what would be the best
course of action...
Like Steve said, Like I am doing...
Thanks Guys...you help is appreciated...
-Original Message-
From: Fawcett, David [mailto:david.fawc...@state.mn.us]
Sent: Tuesday, April 14, 2009 2:39 PM
To: Jay Kapalczynski; Steve Lime; mapserver-users@lists.osgeo.org; Paul T.'
'Moen
Subject: RE: [mapserver-users] RE: Highlight
Steve is using CGI MapServer instead of php.
When you click on a station, you will notice that the outline of the
station turns yellow.
Here is the URL to a tile with a highlighted symbol on it:
http://maps.dnr.state.mn.us/cgi-bin/mapserv52?map=/usr/local/mapserver/a
pps/waters/csg/csg.maplayers=active_sitemap_transparent=trueid=0mode
=mapmap_imagetype=pngstation=63023001mapext=-27687.5+4793250+941687.5
+5480750imgext=-27687.5+4793250+941687.5+5480750map_size=705+500imgx=
352.5imgy=250imgxy=705+500
Notice that he has a layer called 'active_site' and he is passing in the
station ID use in a class in that layer to turn only that feature
yellow.
When no station is selected, no stations are drawn in the 'active_site'
layer.
David.
-Original Message-
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Jay
Kapalczynski
Sent: Tuesday, April 14, 2009 2:30 PM
To: 'Steve Lime'; mapserver-users@lists.osgeo.org; Paul T.' 'Moen
Subject: RE: [mapserver-users] RE: Highlight
Thanksbut little confused as to what I am look at...
How is this working?
-Original Message-
From: Steve Lime [mailto:steve.l...@dnr.state.mn.us]
Sent: Tuesday, April 14, 2009 1:02 PM
To: Jay Kapalczynski; mapserver-users@lists.osgeo.org; Paul T.' 'Moen
Subject: RE: [mapserver-users] RE: Highlight
This is probably too late to be of use but I've been using a highlight
layer to achieve this. The layer takes input from a URL so that layer
filter allows just the desired feature through. Works quite nicely and
is relatively simple to implement. Here's an OpenLayers site that uses
this:
http://www.dnr.state.mn.us/waters/csg/index_copy.html
In this case the highlight is a separate layer but you could just as
easily return a single map.
Steve
On 4/13/2009 at 11:17 AM, in message
d7a5eac385604446ab1dd24bf4f5a91841f1a74...@mg-mail.ci.maple-grove.mn.us
, Jay Kapalczynski jkapalczyn...@ci.maple-grove.mn.us wrote:
So say I have a Database that I am querying...
I get the results back with a PID number (unique)
This number exists in the Parcels Shapefile so I can go after that
field. I have a map file that is set up for the Parcels, but this is
just there to draw the Parcels... I assume that I would have to modify
this one for this to work?
I am just a bit confused on how to get this to work...
When I run the code that creates the Table below I want the parcels to
also
highlight in the map
Attached is my code that I am using to get the resulting PID Values,
build
the table, and populate the last frame showing the Comma Delimited
String.
I just don't know how to apply that to my map?
I attached my code from my PHP page which I hope that someone can at
least
put their eyes on...
Towards to bottom you will see highlighted in RED the code that I am
building a comma delimited string to populate a variable with all the
PID
numbers...
I assume that I would not need the comma delimited string as I could
place
the highlighting code inside the while loop to get the parcels
highlighted...
I don't really know...
Any thoughts?
Thanks
This inside the while loop
$map = ms_newMapObj(PATH TO YOU MAPFILE);
$qlayer = $map-$map-getLayerByName(NAME OF PARCEL LAYER);
$qlayer-queryByAttributes('PID','PID IN (MY COMMA DELIMITED STRING
VARIABLE')',MS_MULTIPLE); $img = $map-drawQuery();
header('Content-Type: image/jpeg');
$img-saveImage();
[cid:image001.jpg@01C9BC29.7A1ECE10]
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org
[mapserver-users] Highlight
Any way to highlight a feature in my map in PHP? I can grab a unique identifier but can figure out how to highlight it... THanks ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] RE: Highlight
Basically what I have is a query that runs on a shapefile... It returns the records into a table, which I then have the option to zoom to. I am looking for a bit moreafter I run the query (php) I want the returned records to highlight in the map... I can get the Unique identifier but don't know if I can write some code in PHP to highlight those features I don't even know where to start here... The query and returning records into the table, as well as, the zoom to work great...just need the highlight part Thanks From: Jay Kapalczynski Sent: Thursday, April 09, 2009 1:03 PM To: 'mapserver-users@lists.osgeo.org' Subject: Highlight Any way to highlight a feature in my map in PHP? I can grab a unique identifier but can figure out how to highlight it... THanks ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] RE: Highlight
Dang I misspoke...I am sorry...
I am querying a Database for records, these records have a PID (unique Number).
These are the records that show up in the Table.
As this happens I have to take the results and run the query against the
parcels to get the features in the Shapefile, then highlight..
If that makes any sense...
If I am in a PHP file and have the records returned from the query
(database)...what would I have to do next to take those records and run a query
to highlight the parcels (PID to PID)?
Can all of this be accomplished in the PHP file?
Thanks...and sorry for my ignorance...
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Moen, Paul T.
Sent: Thursday, April 09, 2009 1:57 PM
To: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] RE: Highlight
Set the mapfile QUERYMAP style to highlight
http://mapserver.org/mapfile/querymap.html. Draw the map using drawQuery()
instead of draw().
$img = $map-drawQuery();
header('Content-Type: image/jpeg');
$img-saveImage();
On 4/9/09 1:31 PM, Jay Kapalczynski jkapalczyn...@ci.maple-grove.mn.us
wrote:
Basically what I have is a query that runs on a shapefile...
It returns the records into a table, which I then have the option to zoom to.
I am looking for a bit moreafter I run the query (php) I want the returned
records to highlight in the map...
I can get the Unique identifier but don't know if I can write some code in PHP
to highlight those features
I don't even know where to start here...
The query and returning records into the table, as well as, the zoom to work
great...just need the highlight part
Thanks
From: Jay Kapalczynski
Sent: Thursday, April 09, 2009 1:03 PM
To: 'mapserver-users@lists.osgeo.orgmapserver-users@lists.osgeo.org'
Subject: Highlight
Any way to highlight a feature in my map in PHP?
I can grab a unique identifier but can figure out how to highlight it...
THanks
Paul
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] RE: Highlight
That's what I was figuringright now I have some code that is in a while
loop building the table from the query...
I think maybe here I can build a list of PID values that can be sent to a PHP
page
Once at the PHP page I can then write code that will highlight the features in
the map based off of the Parcels Shapefile...
Does that make sense?
Is that feasible???
Something like this?
THANKS
?php
$conn=odbc_connect('PDS_Access_db','','');
switch ($varPropertyFactor)
{
case 'lessthan':
$sql_str=SELECT * FROM dbo_DISPLAY_RESIDENTIAL_CHARS WHERE
Dwelling_Type = '$varPropertyType' AND FF_GBA $varPriceArea ORDER BY PID;
//echo $sql_str;
break;
}
$rs=odbc_exec($conn,$sql_str);
if (!$conn)
{exit(Connection Failed: . $conn);}
if (!$rs)
{exit(Error in SQL);}
while (odbc_fetch_row($rs))
{
$PID=odbc_result($rs,1);
$AssessmentYr=odbc_result($rs,2);
$YrBuilt=odbc_result($rs,109);
$Bedrooms=odbc_result($rs,116);
$DwellingType=odbc_result($rs,8);
$Style=odbc_result($rs,7);
$Construction=odbc_result($rs,10);
$Exterior=odbc_result($rs,11);
$RoofType=odbc_result($rs,14);
$Air=odbc_result($rs,19);
$GarageCars=odbc_result($rs,29);
$SqFootage=odbc_result($rs,142);
$Electric=odbc_result($rs,48);
$Heating=odbc_result($rs,49);
$Path=odbc_result($rs,147);
$Image=odbc_result($rs,149);
$Print=odbc_result($rs,150);
echo
tbody class='scrollContent bodyFormat' style='height:160px;'
tr class='alternateRow'
td align=Center$PID/td
td align=Center$AssessmentYr/td
td align=Center$YrBuilt/td
td align=Center$Bedrooms/td
td align=Centernbsp $DwellingType nbsp/td
td align=Centernbsp $Style nbsp/td
td align=Centerstronga href='$Path'
target='main'Map/a/strong/td
td align=Centerstronga href='$Print'
target='_blank'Print/a/strong/td
td align=Centera
href='javascript:Map.itemQueryLayer('Highlight', 'Parcels', 'PID', '$PID',
'/ms4w/apps/GeoMOOSE/Maple_Grove_GeoMoose/select.map');
Map.zoomToViewString(([shpminx]-100)+','+([shpminy]-100)+','+([shpmaxx]+100)+','+([shpmaxy]+100))'img
src='../shared/images/view.png' border='0' title='Click to Zoom Map to
PID'/a/td
/tr
/tbody
;
BUILD THE COMMA DELIMITED LIST RIGHT HERE
} // end while
AFTER ALL HAVE BEEN SELECTED and THE LIST BUILT
SEND THE LIST TO ANOTHER PHP PAGE TO HANDLE THE HIGHLIGHTING OF THE FEATURES
?
From: Fawcett, David [mailto:david.fawc...@state.mn.us]
Sent: Thursday, April 09, 2009 3:34 PM
To: Jay Kapalczynski; Moen, Paul T.; mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] RE: Highlight
Or a string variable containing a comma-delimited list of the ID numbers that
you really want?
David.
-Original Message-
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Jay Kapalczynski
Sent: Thursday, April 09, 2009 3:31 PM
To: 'Moen, Paul T.'; mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] RE: Highlight
Thanks for your response...
$qlayer-queryByAttributes('PID','PID IN (1, 2,7,9,23,87)',MS_MULTIPLE);
Is the 1, 2,7,9,23,87 examples of PID values, if so I assume that these can be
replaced with variables?
Thanks again
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Moen, Paul T.
Sent: Thursday, April 09, 2009 3:15 PM
To: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] RE: Highlight
If the database that you are querying has the same attributes as the shape
file, you can query the Layer that points to the shape file and display the
highlighted results on your map. I know nothing about GeoMOOSE but I know it
can be done with php-mapscript.
Regardless of what you are using, you need a map file layer for the shape file
with the parcels.
You will then need to use php-mapscript to query that layer with something like
$map = ms_newMapObj(PATH TO YOU MAPFILE);
$qlayer = $map-$map-getLayerByName(NAME OF PARCEL LAYER);
$qlayer-queryByAttributes('PID','PID IN (1, 2,7,9,23,87)',MS_MULTIPLE);
You will then need to create the output image from query using something like
$img = $map-drawQuery();
header('Content-Type: image/jpeg');
$img-saveImage();
I can't give you specifics without knowing how GeoMOOSE works, so the best
thing is to look at the documentation for GeoMOOSE if that is what you are
using.
On 4/9/09 2:17 PM, Jay Kapalczynski jkapalczyn...@ci.maple-grove.mn.us
wrote:
Dang I misspoke...I am sorry...
I am querying a Database for records, these records have a PID (unique Number).
These are the records that show up in the Table.
As this happens I have to take the results and run the query against the
parcels to get the features in the Shapefile, then highlight..
If that makes any sense...
If I am in a PHP file and have the records returned from the query
(database)...what would I have to do next to take those records
RE: [mapserver-users] RE: Highlight
Thanks for your response...
$qlayer-queryByAttributes('PID','PID IN (1, 2,7,9,23,87)',MS_MULTIPLE);
Is the 1, 2,7,9,23,87 examples of PID values, if so I assume that these can be
replaced with variables?
Thanks again
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Moen, Paul T.
Sent: Thursday, April 09, 2009 3:15 PM
To: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] RE: Highlight
If the database that you are querying has the same attributes as the shape
file, you can query the Layer that points to the shape file and display the
highlighted results on your map. I know nothing about GeoMOOSE but I know it
can be done with php-mapscript.
Regardless of what you are using, you need a map file layer for the shape file
with the parcels.
You will then need to use php-mapscript to query that layer with something like
$map = ms_newMapObj(PATH TO YOU MAPFILE);
$qlayer = $map-$map-getLayerByName(NAME OF PARCEL LAYER);
$qlayer-queryByAttributes('PID','PID IN (1, 2,7,9,23,87)',MS_MULTIPLE);
You will then need to create the output image from query using something like
$img = $map-drawQuery();
header('Content-Type: image/jpeg');
$img-saveImage();
I can't give you specifics without knowing how GeoMOOSE works, so the best
thing is to look at the documentation for GeoMOOSE if that is what you are
using.
On 4/9/09 2:17 PM, Jay Kapalczynski jkapalczyn...@ci.maple-grove.mn.us
wrote:
Dang I misspoke...I am sorry...
I am querying a Database for records, these records have a PID (unique Number).
These are the records that show up in the Table.
As this happens I have to take the results and run the query against the
parcels to get the features in the Shapefile, then highlight..
If that makes any sense...
If I am in a PHP file and have the records returned from the query
(database)...what would I have to do next to take those records and run a query
to highlight the parcels (PID to PID)?
Can all of this be accomplished in the PHP file?
Thanks...and sorry for my ignorance...
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Moen, Paul T.
Sent: Thursday, April 09, 2009 1:57 PM
To: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] RE: Highlight
Set the mapfile QUERYMAP style to highlight
http://mapserver.org/mapfile/querymap.html. Draw the map using drawQuery()
instead of draw().
$img = $map-drawQuery();
header('Content-Type: image/jpeg');
$img-saveImage();
On 4/9/09 1:31 PM, Jay Kapalczynski jkapalczyn...@ci.maple-grove.mn.us
wrote:
Basically what I have is a query that runs on a shapefile...
It returns the records into a table, which I then have the option to zoom to.
I am looking for a bit moreafter I run the query (php) I want the returned
records to highlight in the map...
I can get the Unique identifier but don't know if I can write some code in PHP
to highlight those features
I don't even know where to start here...
The query and returning records into the table, as well as, the zoom to work
great...just need the highlight part
Thanks
From: Jay Kapalczynski
Sent: Thursday, April 09, 2009 1:03 PM
To: 'mapserver-users@lists.osgeo.orgmapserver-users@lists.osgeo.org
mapserver-users@lists.osgeo.org '
Subject: Highlight
Any way to highlight a feature in my map in PHP?
I can grab a unique identifier but can figure out how to highlight it...
THanks
Paul
Paul
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Labeling
Is there any way to eliminate the decimal places here...I looked online but was unable to find anything. Thanks The fields I am labeling are numeric...so I get this 3434. 123. I am looking to drop all the extra decimal places... Or maybe set it to keep two 3434.00 THANKS LAYER # Maple Grove Parcels NAME Parcel_Labels DATA './parcels.shp' STATUS DEFAULT TYPE annotation MAXSCALE 2000 MINSCALE 100 LABELITEM 'EMV_LAND' LABELCACHE ON CLASS COLOR -1 -1 -1 LABEL POSITION UC TYPE TRUETYPE FONT vera_sans MAXSIZE 7 SIZE 7 OFFSET 0 10 MINSIZE 4 #ANTIALIAS TRUE COLOR 0 0 0 OUTLINECOLOR 255 255 128 BUFFER 2 END END END # Maple Grove Parcels ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] Labeling
Yea I can do that but then I have to build processes to do all the converting... I want to read this data live. Anyone else have any ideas? Thanks One Last thought, don't know if I should enter a new topic... I have three labels I want to label. Right now I am using an Offset to push one above, and one below (UC, CC, LC) with offsets. And as such these are three separate layers in my app I tried to combine all three into one map file but it only labels the first one (I copied the original code in the original email and simply changed the label field)(no matter what I do it just labels the first one it reads) Can I combine these into one and still have them label on three different rows Value 1 Value 2 Value 3 Can I concatenate like this? LABELITEM 'Value 1' 'VALUE 2' 'VALUE 3' But how would I specify they are supposed to create 3 lines??? THANKS From: Fawcett, David [mailto:david.fawc...@state.mn.us] Sent: Thursday, March 26, 2009 9:38 AM To: Jay Kapalczynski; mapserver-users@lists.osgeo.org Subject: RE: [mapserver-users] Labeling It is always an option to create a string column and then populate it with your numbers formatted the way that you want them to appear. I am sure that you realize this, but it is something that I have done in the past. David. -Original Message- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Jay Kapalczynski Sent: Thursday, March 26, 2009 9:14 AM To: 'mapserver-users@lists.osgeo.org' Subject: [mapserver-users] Labeling Is there any way to eliminate the decimal places here...I looked online but was unable to find anything. Thanks The fields I am labeling are numeric...so I get this 3434. 123. I am looking to drop all the extra decimal places... Or maybe set it to keep two 3434.00 THANKS LAYER # Maple Grove Parcels NAME Parcel_Labels DATA './parcels.shp' STATUS DEFAULT TYPE annotation MAXSCALE 2000 MINSCALE 100 LABELITEM 'EMV_LAND' LABELCACHE ON CLASS COLOR -1 -1 -1 LABEL POSITION UC TYPE TRUETYPE FONT vera_sans MAXSIZE 7 SIZE 7 OFFSET 0 10 MINSIZE 4 #ANTIALIAS TRUE COLOR 0 0 0 OUTLINECOLOR 255 255 128 BUFFER 2 END END END # Maple Grove Parcels ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] RE: Labeling issue mutli lines and precision
This works . BUT??? For some reason the 2nd and 3rd line seem indented a bit Result: 1982 19961001 $ 250854 Do you know what could be causing this indent? This is my Code: LAYER # Maple Grove Parcels NAME Parcel_Labels DATA './parcels.shp' STATUS DEFAULT TYPE annotation MAXSCALE 2000 MINSCALE 100 LABELCACHE ON CLASS TEXT ([YEAR_BUI_1] * [SALE_DATE] * [SALE_VAL_1]) #label LABEL COLOR 0 0 0 OUTLINECOLOR 255 255 128 WRAP * #select character to wrap on END #label END #class END # Maple Grove Parcels PRECISION: As for the Precision I have also done that on the query resultsdont really know if or how I can use that in the Labelingfor now I just converted the test data. But in a real world setting I am not going to be able to do that. I will be reading live... If I have to I can created another database that has links and convert it therebut would rather bypass all that additional work... THANKS EVERYONE FOR YOUR HELP IT IS GREATLY APPRECIATED THANKS MARK -Original Message- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Mark Volz Sent: Thursday, March 26, 2009 1:30 PM To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] RE: Labeling issue mutli lines and precision In response to Jay's Labeling question: I have multi line / field labels working: In this example I am stringing together both the name and the parcel id as a label, then splitting the label into two lines CLASS NAME 'Parcels' TEXT ([TXLname] * [PARCEL_ID]) #label LABEL WRAP * #select character to wrap on END #label END #class I tried using precision in the query results, I have not tried it as part of a label [item name=NORTHING precision=2] Mark Volz GIS Specialist Lyon County, MN (507) 532-8218 -Original Message- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of mapserver-users-requ...@lists.osgeo.org Sent: Thursday, March 26, 2009 11:02 AM To: mapserver-users@lists.osgeo.org Subject: mapserver-users Digest, Vol 14, Issue 80 Send mapserver-users mailing list submissions to mapserver-users@lists.osgeo.org To subscribe or unsubscribe via the World Wide Web, visit http://lists.osgeo.org/mailman/listinfo/mapserver-users or, via email, send a message with subject or body 'help' to mapserver-users-requ...@lists.osgeo.org You can reach the person managing the list at mapserver-users-ow...@lists.osgeo.org When replying, please edit your Subject line so it is more specific than Re: Contents of mapserver-users digest... Today's Topics: 1. RE: Labeling (Jay Kapalczynski) -- Message: 1 Date: Thu, 26 Mar 2009 10:57:39 -0500 From: Jay Kapalczynski jkapalczyn...@ci.maple-grove.mn.us Subject: RE: [mapserver-users] Labeling To: 'Fawcett, David' david.fawc...@state.mn.us, mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org Message-ID: d7a5eac385604446ab1dd24bf4f5a9181e06947...@mg-mail.ci.maple-grove.mn.us Content-Type: text/plain; charset=us-ascii Yea I can do that but then I have to build processes to do all the converting... I want to read this data live. Anyone else have any ideas? Thanks One Last thought, don't know if I should enter a new topic... I have three labels I want to label. Right now I am using an Offset to push one above, and one below (UC, CC, LC) with offsets. And as such these are three separate layers in my app I tried to combine all three into one map file but it only labels the first one (I copied the original code in the original email and simply changed the label field)(no matter what I do it just labels the first one it reads) Can I combine these into one and still have them label on three different rows Value 1 Value 2 Value 3 Can I concatenate like this? LABELITEM 'Value 1' 'VALUE 2' 'VALUE 3' But how would I specify they are supposed to create 3 lines??? THANKS From: Fawcett, David [mailto:david.fawc...@state.mn.us] Sent: Thursday, March 26, 2009 9:38 AM To: Jay Kapalczynski; mapserver-users@lists.osgeo.org Subject: RE: [mapserver-users] Labeling It is always an option to create a string column and then populate it with your numbers formatted the way that you want them to appear. I am sure that you realize this, but it is something that I have done in the past. David. -Original Message
RE: [mapserver-users] Labeling
Thank you all for your help... No worries on the decimal truncationwill patiently wait for the 6.0 releasein the mean time I have just updated the test data to a string (text) As for the multi-lineThank you Steve and Mark Volz for your thoughts... They are working although it seems to indent the 2nd and 3rd line...I posted this on the other email sent by Mark Volz Any thoughts -Original Message- From: Steve Lime [mailto:steve.l...@dnr.state.mn.us] Sent: Thursday, March 26, 2009 11:46 AM To: Jay Kapalczynski; mapserver-users@lists.osgeo.org; David' 'Fawcett Subject: RE: [mapserver-users] Labeling The decimal truncation simply can't be done with a shapefile at the moment. There's a ticket in place to add this functionality but it will be a 6.0 improvement. Wish I have better news. One the other question you can use the class TEXT property along with a wrap character to achieve the multiline labels. E.g.: CLASS ... TEXT [col1]|[col2]|[col3] LABEL ... WRAP | END END and that should get you a multi-line label based on 3 attributes. Steve On 3/26/2009 at 10:57 AM, in message d7a5eac385604446ab1dd24bf4f5a9181e06947...@mg-mail.ci.maple-grove.mn.us, Jay Kapalczynski jkapalczyn...@ci.maple-grove.mn.us wrote: Yea I can do that but then I have to build processes to do all the converting... I want to read this data live. Anyone else have any ideas? Thanks One Last thought, don't know if I should enter a new topic... I have three labels I want to label. Right now I am using an Offset to push one above, and one below (UC, CC, LC) with offsets. And as such these are three separate layers in my app I tried to combine all three into one map file but it only labels the first one (I copied the original code in the original email and simply changed the label field)(no matter what I do it just labels the first one it reads) Can I combine these into one and still have them label on three different rows Value 1 Value 2 Value 3 Can I concatenate like this? LABELITEM 'Value 1' 'VALUE 2' 'VALUE 3' But how would I specify they are supposed to create 3 lines??? THANKS From: Fawcett, David [mailto:david.fawc...@state.mn.us] Sent: Thursday, March 26, 2009 9:38 AM To: Jay Kapalczynski; mapserver-users@lists.osgeo.org Subject: RE: [mapserver-users] Labeling It is always an option to create a string column and then populate it with your numbers formatted the way that you want them to appear. I am sure that you realize this, but it is something that I have done in the past. David. -Original Message- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Jay Kapalczynski Sent: Thursday, March 26, 2009 9:14 AM To: 'mapserver-users@lists.osgeo.org' Subject: [mapserver-users] Labeling Is there any way to eliminate the decimal places here...I looked online but was unable to find anything. Thanks The fields I am labeling are numeric...so I get this 3434. 123. I am looking to drop all the extra decimal places... Or maybe set it to keep two 3434.00 THANKS LAYER # Maple Grove Parcels NAME Parcel_Labels DATA './parcels.shp' STATUS DEFAULT TYPE annotation MAXSCALE 2000 MINSCALE 100 LABELITEM 'EMV_LAND' LABELCACHE ON CLASS COLOR -1 -1 -1 LABEL POSITION UC TYPE TRUETYPE FONT vera_sans MAXSIZE 7 SIZE 7 OFFSET 0 10 MINSIZE 4 #ANTIALIAS TRUE COLOR 0 0 0 OUTLINECOLOR 255 255 128 BUFFER 2 END END END # Maple Grove Parcels ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] RE: Labeling issue mutli lines and precision
Fantasticworks... one last quick question.. Can I add actual text... THANKS A MILLIONVERY APPRECIATED... CODE: TEXT (['Land Value:' EMV_LAND_]*[ 'Building Value:' EMV_BLDG_]*['Total Value:'EMV_TOTAL_]) #label RESULT: Land Value: $45000 Building Value: $25 Total Value: $295000 -Original Message- From: Steve Lime [mailto:steve.l...@dnr.state.mn.us] Sent: Thursday, March 26, 2009 2:26 PM To: Jay Kapalczynski; 'Mark Volz'; mapserver-users@lists.osgeo.org Subject: [mapserver-users] RE: Labeling issue mutli lines and precision Jay, the spaces in your TEXT expression are preserved, try removing them. Steve On 3/26/2009 at 2:00 PM, in message d7a5eac385604446ab1dd24bf4f5a9181e06947...@mg-mail.ci.maple-grove.mn.us, Jay Kapalczynski jkapalczyn...@ci.maple-grove.mn.us wrote: This works . BUT??? For some reason the 2nd and 3rd line seem indented a bit Result: 1982 19961001 $ 250854 Do you know what could be causing this indent? This is my Code: LAYER # Maple Grove Parcels NAME Parcel_Labels DATA './parcels.shp' STATUS DEFAULT TYPE annotation MAXSCALE 2000 MINSCALE 100 LABELCACHE ON CLASS TEXT ([YEAR_BUI_1] * [SALE_DATE] * [SALE_VAL_1]) #label LABEL COLOR 0 0 0 OUTLINECOLOR 255 255 128 WRAP * #select character to wrap on END #label END #class END # Maple Grove Parcels PRECISION: As for the Precision I have also done that on the query resultsdont really know if or how I can use that in the Labelingfor now I just converted the test data. But in a real world setting I am not going to be able to do that. I will be reading live... If I have to I can created another database that has links and convert it therebut would rather bypass all that additional work... THANKS EVERYONE FOR YOUR HELP IT IS GREATLY APPRECIATED THANKS MARK -Original Message- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Mark Volz Sent: Thursday, March 26, 2009 1:30 PM To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] RE: Labeling issue mutli lines and precision In response to Jay's Labeling question: I have multi line / field labels working: In this example I am stringing together both the name and the parcel id as a label, then splitting the label into two lines CLASS NAME 'Parcels' TEXT ([TXLname] * [PARCEL_ID]) #label LABEL WRAP * #select character to wrap on END #label END #class I tried using precision in the query results, I have not tried it as part of a label [item name=NORTHING precision=2] Mark Volz GIS Specialist Lyon County, MN (507) 532-8218 -Original Message- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of mapserver-users-requ...@lists.osgeo.org Sent: Thursday, March 26, 2009 11:02 AM To: mapserver-users@lists.osgeo.org Subject: mapserver-users Digest, Vol 14, Issue 80 Send mapserver-users mailing list submissions to mapserver-users@lists.osgeo.org To subscribe or unsubscribe via the World Wide Web, visit http://lists.osgeo.org/mailman/listinfo/mapserver-users or, via email, send a message with subject or body 'help' to mapserver-users-requ...@lists.osgeo.org You can reach the person managing the list at mapserver-users-ow...@lists.osgeo.org When replying, please edit your Subject line so it is more specific than Re: Contents of mapserver-users digest... Today's Topics: 1. RE: Labeling (Jay Kapalczynski) -- Message: 1 Date: Thu, 26 Mar 2009 10:57:39 -0500 From: Jay Kapalczynski jkapalczyn...@ci.maple-grove.mn.us Subject: RE: [mapserver-users] Labeling To: 'Fawcett, David' david.fawc...@state.mn.us, mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org Message-ID: d7a5eac385604446ab1dd24bf4f5a9181e06947...@mg-mail.ci.maple-grove.mn.us Content-Type: text/plain; charset=us-ascii Yea I can do that but then I have to build processes to do all the converting... I want to read this data live. Anyone else have any ideas? Thanks One Last thought
RE: [mapserver-users] RE: Labeling issue mutli lines and precision
GOT IT TEXT (HI [EMV_LAND_]*[EMV_BLDG_]*[EMV_TOTAL_]) #label THANKS FOR ALL YOU HELP From: Jay Kapalczynski Sent: Thursday, March 26, 2009 2:33 PM To: 'Steve Lime'; 'Mark Volz'; mapserver-users@lists.osgeo.org Subject: RE: [mapserver-users] RE: Labeling issue mutli lines and precision Fantasticworks... one last quick question.. Can I add actual text... THANKS A MILLIONVERY APPRECIATED... CODE: TEXT (['Land Value:' EMV_LAND_]*[ 'Building Value:' EMV_BLDG_]*['Total Value:'EMV_TOTAL_]) #label RESULT: Land Value: $45000 Building Value: $25 Total Value: $295000 -Original Message- From: Steve Lime [mailto:steve.l...@dnr.state.mn.us] Sent: Thursday, March 26, 2009 2:26 PM To: Jay Kapalczynski; 'Mark Volz'; mapserver-users@lists.osgeo.org Subject: [mapserver-users] RE: Labeling issue mutli lines and precision Jay, the spaces in your TEXT expression are preserved, try removing them. Steve On 3/26/2009 at 2:00 PM, in message d7a5eac385604446ab1dd24bf4f5a9181e06947...@mg-mail.ci.maple-grove.mn.us, Jay Kapalczynski jkapalczyn...@ci.maple-grove.mn.us wrote: This works . BUT??? For some reason the 2nd and 3rd line seem indented a bit Result: 1982 19961001 $ 250854 Do you know what could be causing this indent? This is my Code: LAYER # Maple Grove Parcels NAME Parcel_Labels DATA './parcels.shp' STATUS DEFAULT TYPE annotation MAXSCALE 2000 MINSCALE 100 LABELCACHE ON CLASS TEXT ([YEAR_BUI_1] * [SALE_DATE] * [SALE_VAL_1]) #label LABEL COLOR 0 0 0 OUTLINECOLOR 255 255 128 WRAP * #select character to wrap on END #label END #class END # Maple Grove Parcels PRECISION: As for the Precision I have also done that on the query resultsdont really know if or how I can use that in the Labelingfor now I just converted the test data. But in a real world setting I am not going to be able to do that. I will be reading live... If I have to I can created another database that has links and convert it therebut would rather bypass all that additional work... THANKS EVERYONE FOR YOUR HELP IT IS GREATLY APPRECIATED THANKS MARK -Original Message- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Mark Volz Sent: Thursday, March 26, 2009 1:30 PM To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] RE: Labeling issue mutli lines and precision In response to Jay's Labeling question: I have multi line / field labels working: In this example I am stringing together both the name and the parcel id as a label, then splitting the label into two lines CLASS NAME 'Parcels' TEXT ([TXLname] * [PARCEL_ID]) #label LABEL WRAP * #select character to wrap on END #label END #class I tried using precision in the query results, I have not tried it as part of a label [item name=NORTHING precision=2] Mark Volz GIS Specialist Lyon County, MN (507) 532-8218 -Original Message- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of mapserver-users-requ...@lists.osgeo.org Sent: Thursday, March 26, 2009 11:02 AM To: mapserver-users@lists.osgeo.org Subject: mapserver-users Digest, Vol 14, Issue 80 Send mapserver-users mailing list submissions to mapserver-users@lists.osgeo.org To subscribe or unsubscribe via the World Wide Web, visit http://lists.osgeo.org/mailman/listinfo/mapserver-users or, via email, send a message with subject or body 'help' to mapserver-users-requ...@lists.osgeo.org You can reach the person managing the list at mapserver-users-ow...@lists.osgeo.org When replying, please edit your Subject line so it is more specific than Re: Contents of mapserver-users digest... Today's Topics: 1. RE: Labeling (Jay Kapalczynski) -- Message: 1 Date: Thu, 26 Mar 2009 10:57:39 -0500 From: Jay Kapalczynski jkapalczyn...@ci.maple-grove.mn.us Subject: RE: [mapserver-users] Labeling To: 'Fawcett, David' david.fawc...@state.mn.us, mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org
[mapserver-users] Expressions
I am trying to do expressions based on a shapefile...I had this working in a
prior version but now it wont work...
The fields GEO_SIMPLE and dateValues exist in the shapefile.
I have the date values in dateValues as TEXT, 8 characters.
The Star symbols come up but the application freezes up and wont draw the rest
of the layers...so I have something wrong...
Does the date format have to be changed?
Does the field have to be a date field?
Will the below format work? (%2M%2D%2Y)
But in the field it looks like this 11509
If I remove the param types and the expression stuff it draws the layer
fine...so it has to be with the dates.
THANKS IN ADVANCE FOR ANY HELP
I get this error:
Strfdate is not defined
mapParams[i].SetAttribute('value',strfdate(new
Date(d.getTime()+offset),formats
DEMO.XML
map title=Burglaries default=true reference=false
popups=true data=true
param type=today offset=-7 name=LASTWEEK
format=%2M%2D%2Y/
param type=today offset=-14 name=LASTTWOWEEKS
format=%2M%2D%2Y/
param type=today offset=-30 name=LASTTHIRTY
format=%2M%2D%2Y/
param type=today offset=-90 name=LASTNINTY
format=%2M%2D%2Y/
file/ms4w/apps/GeoMOOSE/Maple_Grove_GeoMoose/Burglaries/Burglaries_8bit.map/file
/map
BURGLARIES.map
CLASS
NAME 'Last Week'
EXPRESSION ('[GEO_SIMPLE]' = 'BURGLARY'
AND '[dateValues]' '%LASTWEEK%')
COLOR 197 0 255
SYMBOL star
SIZE 12
END
CLASS
NAME 'Last Two Weeks'
EXPRESSION ('[GEO_SIMPLE]' = 'BURGLARY' AND
'[dateValues]' '%LASTTWOWEEKS%')
COLOR 255 0 0
SYMBOL star
SIZE 12
END
CLASS
NAME 'Last Thirty Days'
EXPRESSION ('[GEO_SIMPLE]' = 'BURGLARY' AND
'[dateValues]' '%LASTTHIRTY%')
COLOR 0 255 0
SYMBOL star
SIZE 12
END
CLASS
NAME 'Last Ninety Days'
EXPRESSION ('[GEO_SIMPLE]' = 'BURGLARY' AND
'[dateValues]' '%LASTNINTY%')
COLOR 0 0 255
SYMBOL star
SIZE 12
END
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Search
I am trying to use this filter to act as a wild card and am not having any successincorrect syntax??? Any thoughts? Thanks THIS WORKS: but not a wild card search FILTER /^%idOwner%/ THIS NOT WORKING: FILTER /.%idOwner%./ LAYER # Parcels Owner Layer NAME 'Parcels' DATA 'parcels/parcels.shp' STATUS DEFAULT TYPE POLYGON METADATA qstring_validation_pattern '.' END TEMPLATE 'parcels/itemquery_parcels_Owner.html' FILTERITEM 'OWNER_NAME' #FILTER /^%idOwner%/ FILTER /.%idOwner%./ END ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] ShpTree
I am trying to figure out what I need to do/install/run to create a .qix file (tile index) for a few of my shapefiles. I have looked this up on a few pages and still am confused. Can anyone help me? Thanks J ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] RE: Labeling
That was itmoved the lines inside the LABEL CLASS Credit due to the GeoMoose Forum...(Dan) But I do thank you all for your help...it is very appreciated. Especially for Green coders like myself... Thanks again Steve for your response CLASS LABEL PUT LINES HERE END END -Original Message- From: Steve Lime [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 06, 2008 9:42 AM To: Jay Kapalczynski; mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] RE: Labeling From your example I can see that your ANGLE parameter is in the wrong object it should be in the label object to rotate the text. As is you should be throwing parsing errors. the item storing the angle need not be numeric although the values must represent numbers upon conversion. Steve Jay Kapalczynski [EMAIL PROTECTED] 08/06/08 2:15 AM What I am trying to do is use annotation from a Geodatabase. From what I hear GeoMoose / Map Server will not read it. I converted the Annotation Feature Class to a Point. Then created a Polygon from the Annotation Feature Classes, pointing to the Point Feature class for the Attributes (label field, degree field) I then read the Polygons into GeoMoose and label on the field and Angle the text by Angle' Field. The ANGLE call to Map Server dosent seem to work in this case Any thoughts? From: Jay Kapalczynski Sent: Tuesday, August 05, 2008 2:48 PM To: 'mapserver-users@lists.osgeo.org' Subject: Labeling Don't know if I have to correct location. I have been successful labeling street centerlines using the ANGLE FOLLOW in the .map File This is being performed on a Shapefile Line feature I also have a Polygon Feature that has a field that I am trying to labelonce again I need the text to follow the polygon As you can see from the image the road names a following properly, but the labels for the polygons are not following... I tried the ANGLE FOLLOW on the Polygon and It will not draw.. I tried ANGLE [Angle] with Angle being a field name that holds Degree values (ex 270) does the field have to be numeric? Is there some other syntax that I have to put in the map file that will force the text to follow the Polygon? THANKS STREET MAP FILE LAYER # Maple Grove Streets Name NAME Streets_Labels DATA './GEOCODED_CENTERLINES2.shp' STATUS DEFAULT TYPE annotation MAXSCALE 6000 MINSCALE 100 LABELITEM 'STREET_NAM' LABELCACHE ON CLASS COLOR -1 -1 -1 LABEL TYPE TRUETYPE FONT vera_sans ANGLE FOLLOW POSITION AUTO MAXSIZE 10 SIZE 8 MINSIZE 8 ANTIALIAS TRUE COLOR 0 0 0 OUTLINECOLOR 255 255 192 BUFFER 2 END END END # Maple Grove Streets Name PARCELS MAP FILE THAT DOES NOT WORK LAYER # Maple Grove Parcels NAME Parcel_Labels DATA './parcels.shp' STATUS DEFAULT TYPE annotation MAXSCALE 2500 MINSCALE 100 LABELITEM 'TextString' ANGLE [Angle] POSITION AUTO PARTIALS FALSE LABELCACHE ON CLASS COLOR -1 -1 -1 LABEL TYPE TRUETYPE FONT vera_sans MAXSIZE 8 SIZE 8 MINSIZE 2 #ANTIALIAS TRUE COLOR 0 0 0 OUTLINECOLOR 255 255 128 BUFFER 2 END END END # Maple Grove Parcels ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
