[mapserver-users] symbolize a wms map based upon a sql count() query

[Scott Pezanowski]

Hi,

I am hoping to be able to symbolize a WMS or image map, based upon the results of a SQL COUNT() query. To be more specific, this query needs to be dynamic based upon user input from my application for specific attributes in the data, count up the number of records that meet that query, and then produce a choropleth map of the resulting counts. So the query would produce, a count of 10 records for one county, 5 records for another county, etc. and my counties will be colored based upon a scheme for these counts. My data is in a PostGIS database.

Is there a way to do this with Mapserver? I am currently simply returning all of the records that meet my criteria and counting things up on the client application. But I am hoping there is a way to do this on the server or database-side of things.

Thank you very much in advance for any help or tips you may be able to offer. Also, please let me know if you need more info on what I am trying to do.

Thanks,
Scott




********************************************* Scott Pezanowski 


email: scottpez at hotmail.com  
*********************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20081029/12004c9d/attachment.html