I have a fairly simple question. What is the best strategy to do the following scenario? I think this is a very common scenario:
I have a several thousands of dataset with polygon/points. Each dataset/record can have multiple polygons.
Allow users to draw a polygon and search which datasets fall into that space
- I have several predefined polygon/areas, that the users can also use/pick to search for datasets.
When the search is done, just show the list of the datasets, display as markers on a map. I'm not worried about this bit because it has been done just with OpenLayers.
My current options (I am new and some of my current options may not even be possible. Please let me know if that is the case) are:
- Put datasets in PostGIS, set it up in Geoserver. Put predefined polygons straight in geoserver. Use WMS filtering.
- Put datasets in PostGIS, but not in Geoserver. Put predefined polygons in PostGIS and Geoserver for displaying. Use PostGIS intersection.
- I've heard from another person that for performance ,it is best to calculate the intersection using a custom app, e.g. Java / other
I'm not sure what is the best in terms of performance and efficiency. Suggestions are very welcomed!