Have Geek Brain

SQL Server 2008 Spatial Clustering

I am trying to group geospatial data points based on density and relative distance. Is there a way that this can be done in SQL Server 2008 using spatial functions or would it be better to translate the data into graph data and use the graph clustering algorithm?

+2


a source to share


1 answer


As far as I know, there are no built-in spatial methods for clusters in SQL Server 2008. I've never come across examples of this in T-SQL / at the database level. It would be much easier to go with your second approach and do these calculations at the application level - using R, GRASS, MapServer depending on your development needs / preferences.

If it's just a display of clusters of points (not a linked analysis), check the following links:

OpenLayers

http://openlayers.org/dev/examples/strategy-cluster.html

Google



http://googlemapsapi.martinpearman.co.uk/articles.php?cat_id=1

http://econym.org.uk/gmap/example_clusterer.htm

Python / PostGIS

http://wiki.osgeo.org/wiki/Point_Clustering

+1


a source






More articles:


All Articles