I'm not sure if this is possible within Geoserver so wanted to ping to the community. I have a table in a database (~3m rows), this table has a column of counts in it and I want to thematically shade the data by Equal Count or Equal Range or % buckets (such as 0-25%, 25-50%, 50%-75%, 75%-100%) using ONLY the data being returned in the Bounding Box.
I do not want to hardcode the count ranges (Low: 0-100, Med: 100-200, High: 200-300) into the SLD because if I move the map to an area where the counts are quite low I'll end up with all similar colours (for example if the area only has counts < 100 then it'll all be one colour) where in reality I want to see color range within the set of data being returned. E.g: If the colour range from the bounding box is 1-50 I want to be able to show Low/Med/High using Equal Count/Ranges applied to that 1-50 range.
I wasn't sure if this was possible within Geoserver and before I try to embark on this I wanted to check.
Hope that makes sense?
Many thanks, Ben
Tried reading the documentation and searching but couldn't find the answer I was looking for.