Geoserver render interpolated polygons

[المشرف العام]

First post here on the GIS forum, ill try to do my best explaining my situation.Im looking for solutions or pointers in the right direction.

So, right now I'm experimenting with Geoserver. The data i have access to right now is the following:

• A Shape file with all of Swedens farming fields as polygons. (Geoserver serves that to Leaflet as WMS or GeoJSON right now as I'm experimenting.)
• A MySQL table with around 400k soil samples, coordinates and a lot of information about stuff like pH and so forth. The coordinates are not stored as spatial points right now, just a column with X value and one with Y value. The samples are taken with 100 meter interval.

The result id like to see is something like this:

What you see is 3 polygons with interpolated values, each square is about 20-30 meter. It doesn't matter if the result looks like that or if its a nice gradient all over.

So on the fly i would like to get some kind of layer from Geoserver with interpolated colors based on the soil samples I've got in the MySQL table. Im not at all certain how to combine the two data sources (polygons and samples). I guess thats my main problem. How to get Geoserver to find the samples, and from that color the polygons.

I could use what ever application you see fit for the task, preferably open source.

I would greatly appreciate all you're advice in the matter.



أكثر...