none
Batch Geocodes return same long and lat coordinates RRS feed

  • Question

  • I have created a visual basic program that uploads a text file of addresses.    In the results many of the addresses have the same longitude and latitude values even though the addresses themselves are different.  I do not understand why.

    Any ideas?  I spent some time looking in the forums and didn't find anything so hopefully this is a new challenge.

    DragonflyBog



    Friday, February 12, 2016 9:49 PM

Answers

  • Look at the geocode data, there should be information around how the result was matched. I suspect that the results likely went up the hierarchy where if it can't find an exact match it moves to a lower level match. For example an address may go through the following match steps looking for something it can find: street address, road block, postal code, neighborhood, city, state/province, country.

    http://rbrundritt.wordpress.com

    Saturday, February 13, 2016 12:17 AM
  • Looks like a lot of your addresses have extra information like apartment numbers and internal building numbers. These are not supported. Removing these values I'm finding that Bing Maps is returning very accurate results.

    http://rbrundritt.wordpress.com

    Tuesday, February 16, 2016 4:17 PM

All replies

  • Look at the geocode data, there should be information around how the result was matched. I suspect that the results likely went up the hierarchy where if it can't find an exact match it moves to a lower level match. For example an address may go through the following match steps looking for something it can find: street address, road block, postal code, neighborhood, city, state/province, country.

    http://rbrundritt.wordpress.com

    Saturday, February 13, 2016 12:17 AM
  • I see what you mean.  These addresses are legit though.  I wonder what I am missing to cause the addresses to be hard to find.

    Monday, February 15, 2016 2:57 PM
  • Looks like my submit file was missing a few commas before the address.  The program is better but still not accurate for actual addresses.  I guess I need to see what other info other than address the API needs.

    sample:

    ,,1405 Somerset Place NW,Washington,DC,20011
    ,,14583 Earlham Ct,Woodbridge,VA,22193
    ,,8515 Greenwood Avenue #4,Takoma Park,MD,20912
    ,,8623 Anderson Ave,Marshall,VA,20115

    • Marked as answer by DragonflyBog Monday, February 15, 2016 3:25 PM
    • Unmarked as answer by DragonflyBog Monday, February 15, 2016 9:38 PM
    • Edited by DragonflyBog Monday, February 15, 2016 9:40 PM
    Monday, February 15, 2016 3:25 PM
  • Looks like a lot of your addresses have extra information like apartment numbers and internal building numbers. These are not supported. Removing these values I'm finding that Bing Maps is returning very accurate results.

    http://rbrundritt.wordpress.com

    Tuesday, February 16, 2016 4:17 PM
  • I realize this is a long time ago, but I'm working on something similar right now and seem to be having issues with the format of my dataLocation parameter. Currently it is just the url of the file I'm wanting to upload, but it gives me an error saying it can't access it. Could you possibly show what the format was for the request you're sending? Just the single line of "http://spatial.virtualearth.net/REST/v1/Dataflows/Geocode?" etc. would be of great help to me. Thank you!

    -NL

    Monday, May 8, 2017 9:25 PM
  • Be sure to encode your data location URL. For example:

    http://spatial.virtualearth.net/REST/v1/Dataflows/Geocode?input=xml&dataLocation=http%3a%2f%2fmyAzureAccount.blob.core.windows.net%2fmyEntityData&key=YOUR_BING_MAPS_KEY


    [Blog] [twitter] [LinkedIn]

    Tuesday, May 9, 2017 12:17 AM
  • Thanks for the response! I made this change, though I just tried re-running this and am still getting the same error - that one or more parameters is not valid and that there is a problem accessing my dataLocation. So there's still some other problem that I haven't yet tracked down.
    Tuesday, May 9, 2017 7:31 PM
  • Make sure that your file is on a publically accessible endpoint. If you have a basic account, ensure your data set has less than 50 rows of data. Enterprise accounts can have up to 200,000 rows of data.

    [Blog] [twitter] [LinkedIn]

    Tuesday, May 9, 2017 8:26 PM
  • I think therein lies my problem. After digging through some more documentation, it appears I need to upload my data to the Azure cloud? or something along those lines. So I think I now need to explore that a bit. I do appreciate your responses, they've been quite helpful.
    Tuesday, May 9, 2017 9:53 PM
  • You can also just upload the data in the bing maps portal using the upload tool or if you want to use code, post the data as a stream.

    [Blog] [twitter] [LinkedIn]

    Wednesday, May 10, 2017 3:45 AM