#600 Proof of Concept - Visualizing GIS data
This patch makes it able to visualize GIS data. This was done using the flot library. Please note that flot was chosen simply because this is just a proof of concept and I was playing around with it for some other task. I'm open to consider the pros and cons of other options and chose the most suitable library for the final implementation
Here I attach two patch files, and a suitable data set to see how this is working
Features:
1. 'Visualize GIS data' link is displayed in 'Query results options' pane ONLY for query results that has atleast one geometric column.
2. Visualization can be zoomed in, zoomed out and panned (thanx to flot)
3. If there are more than one geometric columns in the results, the user can chose which column to be used for th visualization
4. User can chose out of non-geometric columns a label column, which can be used for either tooltips or legend (to be implemeted)
5. User can resize the visualization.
Known limitations:
1. Here I have implemented this only for multipolygons.
2. I'm yet to handle the case where there is void area inside a polygon
3. function 'PMA_GIS_modify_query()' should be made more robust.
Enhancements
1. Can be extended to other geometric types. Extending to other types is a simple task. Would love to do so if you are happy with the patch.
2. As mentioned earlier tooltips or legend using label column would be nice.
A suitable dataset for visualization
Zipped it since it exceed the upload size
I guess this is part of the GSoC project.
Yes, I think it's alright to close this now