none
BING Maps reverse geocoding RRS feed

  • Question

  • Hi,

    I'm not a developer so I'm looking for the fastest path forward.

    I'm wondering if there is a simple way to batch reverse geocode some address though the bing system? I work for a county GIS department and I would like to compare our internal structure point addresses against what Bing would return from an address search.  Ideally the result would be a table with the original address and x,y location.

    We have serious issue with our addressing and I'm looking for ways to demonstrate the variability that the public would see.

    Any thoughts or assistance would be greatly appreciated.

    Tuesday, August 1, 2017 7:04 PM

Answers

  • If you have an Enterprise license, you can use the Bing Spatial Data Services. This requires writing code and formatting your data a certain way. If this is a one off job then it might not be the best approach. Another option is to use the on-demand REST location API to reverse geocode. This does one address/coordinate at a time, but is fast and requires a lot less coding. Here is an example of how to do this in Excel: https://weblogs.asp.net/wkriebel/using-excel-to-geocode-with-bing-maps-web-services

    Simply modify the REST query to do reverse geocoding: 

    https://msdn.microsoft.com/en-US/library/ff701710.aspx

    Note that reverse geocoding only returns approximate addresses unless the coordinate is on a known parcel. Parcel data is not available everywhere and more often than not the data is interpolated. Usually addresses will be fairly close, but don't count on them being 100% accurate. The house numbers will more than likely be off by a few numbers here an there.


    [Blog] [twitter] [LinkedIn]

    Wednesday, August 2, 2017 3:34 PM

All replies

  • If you have an Enterprise license, you can use the Bing Spatial Data Services. This requires writing code and formatting your data a certain way. If this is a one off job then it might not be the best approach. Another option is to use the on-demand REST location API to reverse geocode. This does one address/coordinate at a time, but is fast and requires a lot less coding. Here is an example of how to do this in Excel: https://weblogs.asp.net/wkriebel/using-excel-to-geocode-with-bing-maps-web-services

    Simply modify the REST query to do reverse geocoding: 

    https://msdn.microsoft.com/en-US/library/ff701710.aspx

    Note that reverse geocoding only returns approximate addresses unless the coordinate is on a known parcel. Parcel data is not available everywhere and more often than not the data is interpolated. Usually addresses will be fairly close, but don't count on them being 100% accurate. The house numbers will more than likely be off by a few numbers here an there.


    [Blog] [twitter] [LinkedIn]

    Wednesday, August 2, 2017 3:34 PM
  • Dear Ricky,

    I am not sure if it is appropriate to touch on this matter again.

    I am not sure how to modify the code since I am not familiar with the REST api language.

    I have a set of Lattitudes and longitudes and would like to convert into columns of admin division 1, 2 etc.

    Could you show me what to change with the code?

    thanks

    Friday, October 13, 2017 12:20 PM
  • If you don't want to do any development, take a look at MapCite, they have an add-in for excel that can easily geocode your data for you. They have a free option that may be a good place to start. You can find it here: http://www.mapcite.com/excel-addin.aspx

    [Blog] [twitter] [LinkedIn]

    Friday, October 13, 2017 5:37 PM