I'm new to Umbraco, so I've spent the past few working days watching pretty much every video tutorial on the website to get myself up to speed.
Umbraco looks to be a very close fit for my needs, however I need to store spatial data.
This data will then be plotted on a map control (Google or Bing) but also need to be accessable in order to perform search queries (e.g. Find all data within 1 mile of a point)
Everything I've read on Umbraco so far deals with higher level development - but where do I look in order to store a new database datatype over the four available out the box: date, integer, ntext, nvarchar
Storing Spatial data (In MS SQL Server 2008)
I'm new to Umbraco, so I've spent the past few working days watching pretty much every video tutorial on the website to get myself up to speed.
Umbraco looks to be a very close fit for my needs, however I need to store spatial data.
This data will then be plotted on a map control (Google or Bing) but also need to be accessable in order to perform search queries (e.g. Find all data within 1 mile of a point)
Everything I've read on Umbraco so far deals with higher level development - but where do I look in order to store a new database datatype over the four available out the box: date, integer, ntext, nvarchar
Thanks
Pete
Although an old package, this may help shed some light into an implementation similar to what you want:
http://our.umbraco.org/projects/backoffice-extensions/locator-package
Also check out the google maps location package:
http://our.umbraco.org/projects/backoffice-extensions/google-maps-datatype
Thanks for your response Drew.
The more I learn about Umbraco, the more I can see that the best way to extend it is not at the database level.
I've investigate these already built solutions and hopefully they'll allow me to achieve my aims.
Pete
is working on a reply...