I have vector data fed into a database which returns a report at province level upon querying. This is implemented in a web tool.
I want to add an extra functionality at point level, where I can input lat/lon and run a spatial query to calculate some attribute, say distance to coast, based on that point. Let us assume I have data which contains the distance from centroid of the province.
Please suggest me an open source approach to implement this. How feasible would it be to divide the province into grids and dynamically take up the values?