Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL v MongoDB
Message
From
24/09/2014 13:30:36
 
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Environment versions
SQL Server:
SQL Server 2014
Application:
Web
Miscellaneous
Thread ID:
01608144
Message ID:
01608193
Views:
38
>>Wish I had time to play with it. But, end of day, I think you are right. This particular example wasn't a fair comparison.
>>BTW I noticed that the SQL Geography data type is implemented as a CLR data type :-}
>
>True, it's a CLR data type. There are functions associated with the data type to convert latitude and longitude points into a geospatial value.
>
>The feature has been around for six years now, though it's still a bit of a niche feature in the product. There are probably many who don't realize (and haven't had a need to realize) that you can use the core Microsoft platform to write something to consume a restful service (like rpc.geocoder.us/service), pass it address information, get back latitude and longitude points, convert them to a spatial value, store the values in a SQL table, and then generate a map in SSRS (or PowerMaps) to show the dozen Kroger grocery stores in Northern Atlanta and their sales. :)

If I ever feel the need to ascertain Kroger sales figures I'll remember that :-}

I've been working on a web app that combines Mongo Geospatial with the google.maps GeoCode and HTML GeoLocation APIs.
Good fun !
Previous
Reply
Map
View

Click here to load this message in the networking platform