Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL v MongoDB
Message
De
24/09/2014 13:30:36
 
 
À
24/09/2014 13:18:31
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Versions des environnements
SQL Server:
SQL Server 2014
Application:
Web
Divers
Thread ID:
01608144
Message ID:
01608193
Vues:
39
>>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 !
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform