none
Bing Maps vs Google Maps API online map libraries/databases RRS feed

  • Question

  • I'm looking to develop a webpage with a map API. I'm not sure whether I should go with Google Maps or with Bing Maps. I looked into loading the map information from a KML file, but it seems as though there are many restrictions placed around this method. I'm going to use an online databse, like MySQL, to store the map information, which I understand would allow for better manipulation of the data compared to KML files. I'd like to load three map layers onto the map application, and enable the user to view any combination of the three, if that's possible.

    I'm open to using either Google or Bing Maps. How does Bing compare to Google in terms of how they manage data from an online database? or is there some other factor that I should consider?

    Thank you in advance :)

    Friday, June 8, 2012 10:56 PM

Answers

  • Well you should find that most, if not everyone on this forum will recommend Bing Maps. Using a database approach is definately a good way to increase the way you can work with your data. If you are looking at using MVC you may be interested in the AJAX Map DataConnector project which connects Bing Maps to a SQL database. Not only can it do spatial queries to pull in your data but it can also generate tiles out of your data for fast performnc eon large data sets. you can find this project here: http://ajaxmapdataconnector.codeplex.com/

    Another approach that works well is to us the Bing Spatial Data Services to store your data. This gives you an easy place to upload your location data that can then be accessed through a REST based service. Note that this is limited to point based data and is not recommeneded for polyline/polygon type data. You can find more information about this service here: http://msdn.microsoft.com/en-us/library/ff701734.aspx

    If you are interested in using Bing Maps in a desktop application the WPF map control works well. Here is an article on using the Entity Framework with the Bing Maps WPF control: http://rbrundritt.wordpress.com/2012/06/08/entity-framework-5-bing-maps-wpf/


    http://rbrundritt.wordpress.com

    Saturday, June 9, 2012 8:46 AM
  • CouchDB and MongoDB are very different to MS SQL Server, because they're not relational database management systems... if you want a free RBDMS with geospatial support, why not just use SQL Server Express? http://www.microsoft.com/sqlserver/en/us/editions/2012-editions/express.aspx

    twitter: @alastaira blog: http://alastaira.wordpress.com/

    Wednesday, June 13, 2012 8:09 PM
    Moderator

All replies

  • Well you should find that most, if not everyone on this forum will recommend Bing Maps. Using a database approach is definately a good way to increase the way you can work with your data. If you are looking at using MVC you may be interested in the AJAX Map DataConnector project which connects Bing Maps to a SQL database. Not only can it do spatial queries to pull in your data but it can also generate tiles out of your data for fast performnc eon large data sets. you can find this project here: http://ajaxmapdataconnector.codeplex.com/

    Another approach that works well is to us the Bing Spatial Data Services to store your data. This gives you an easy place to upload your location data that can then be accessed through a REST based service. Note that this is limited to point based data and is not recommeneded for polyline/polygon type data. You can find more information about this service here: http://msdn.microsoft.com/en-us/library/ff701734.aspx

    If you are interested in using Bing Maps in a desktop application the WPF map control works well. Here is an article on using the Entity Framework with the Bing Maps WPF control: http://rbrundritt.wordpress.com/2012/06/08/entity-framework-5-bing-maps-wpf/


    http://rbrundritt.wordpress.com

    Saturday, June 9, 2012 8:46 AM
  • Thank you Richard, your answer is helpful. I think I'm going to use Bing Maps instead of Google, specifically using the AJAX Map DataConnector project because I need to display polygons on one of the map layers. Do I have to use the 2012 MS SQL server if I want to use the AJAX Map DataConnector project? I would need a free server and database with geospatial support (to calculate the distance between a searched address and a point on the map). For example, how would couchdb ( http://couchdb.apache.org/ ) or mongodb (http://www.mongodb.org/ ) compare to MS SQL? 

    Thanks again, I really appreciate it.

    Wednesday, June 13, 2012 4:40 PM
  • CouchDB and MongoDB are very different to MS SQL Server, because they're not relational database management systems... if you want a free RBDMS with geospatial support, why not just use SQL Server Express? http://www.microsoft.com/sqlserver/en/us/editions/2012-editions/express.aspx

    twitter: @alastaira blog: http://alastaira.wordpress.com/

    Wednesday, June 13, 2012 8:09 PM
    Moderator
  • I will, thank you; I've downloaded the 2012 edition with tools, it seems to be better than MySQL. However, the documentation for installing the AJAX Map DataConnector is for the 2008 edition: http://ajaxmapdataconnector.codeplex.com/releases (build instructions), which is just a text document that has the following instructions: 

    "1. Download and install the database backup file in SQL Server 2008 R2.
    2. Download and unpack the source solution.
    3. Configure the connection string in Web.config to point to your copy of the database.
    4. Obtain a key from Bing Maps.See http://msdn.microsoft.com/en-us/library/ff428642.aspx
    5. Put the key into .\Scripts\MainPage.js replacing "My Bing Map Credentials". Keep the quotes.
    6. If wanting to run as azure webrole download and install azure sdk 1.4 then load DataConDemoAzure.sln otherwise just load
    DataConDemo.sln to run as a standard asp.net mvc 2 website
    6. Build and run the solution."

    How do you download and install the database backup file in SQL Server 2012? 

    Wednesday, June 13, 2012 9:03 PM