I have a requirement to store spatial data on an Umbraco website and was wondering what was available for this, although I'm sure it's trivial to support the storing of the data my main concern was queries against spatial data (i.e. items within a certain distance of each other).
At the moment I'm considering using a custom table and utilising Sql Servers support for spatial types and then I can query against that and link to necessary content in Umbraco where necessary.
Thanks for that, I will give that a try, I don't suppose you know what sort of query-support this might offer? For example if I wanted to get nearest located items from one point to another?
its quite a new package so i haven't played about with it much, i think it does distance between points, and in the past i've just lifted the SQL for nearest from the internet.
Spatial type properties
Hi all
I have a requirement to store spatial data on an Umbraco website and was wondering what was available for this, although I'm sure it's trivial to support the storing of the data my main concern was queries against spatial data (i.e. items within a certain distance of each other).
At the moment I'm considering using a custom table and utilising Sql Servers support for spatial types and then I can query against that and link to necessary content in Umbraco where necessary.
Or could I achieve this solely using Umbraco?
Thanks
you might want to look at uLocate http://our.umbraco.org/projects/collaboration/ulocate
Hi Kevin
Thanks for that, I will give that a try, I don't suppose you know what sort of query-support this might offer? For example if I wanted to get nearest located items from one point to another?
Thanks
its quite a new package so i haven't played about with it much, i think it does distance between points, and in the past i've just lifted the SQL for nearest from the internet.
The best place to ask the package creators on their site https://bitbucket.org/rustyswayne/ulocate
is working on a reply...