topic convert address to lat long in Developer

convert address to lat long

ThomasDay — Mon, 12 Sep 2016 19:26:16 GMT

I have a one time need to convert 1mm addresses to a lat/long after which the update process will only require maybe 10k updates per quarter. All the plans seem to be geared to monthly volumes so hence my question...Anyone have any experience with this in their powerbi data transformations whether done in powerbi or pre-bi?

Thanks,

Tom

PS: It's probably worth saying I'm doing this to pre-compute the distance between data point pairs...and then find the "other" data points within a radius (set by a slicer) of any selected point.

Re: convert address to lat long

Greg_Deckler — Mon, 12 Sep 2016 22:02:45 GMT

Generally, you use Bing Spatial Data Services:

or Google Maps Geocoding API

https://developers.google.com/maps/documentation/geocoding/usage-limits

Re: convert address to lat long

ThomasDay — Tue, 13 Sep 2016 17:40:48 GMT

Thanks @Greg_Deckler. It's a little byzantine to figure out the pricing. We're non-standard in that we won't be attached to a map (powerbi can do that with an address) rather we're creating distances between points for slicers to go into a commercial application. 1MM geo codes can be expensive and hence the question.

I was imagining I could use an opensourced service for the big push, then a bing like service for the quarterly changes...(which are modest). Have you ever deciphered pricing for one time big jobs using bing? I'd like to keep things in the "family" if possible.

Tom

Re: convert address to lat long

Greg_Deckler — Tue, 13 Sep 2016 17:57:01 GMT

You should email maplic@microsoft.com for assistance in determining the Bing Maps service and licensing program that’s best for your business.

https://azure.microsoft.com/en-us/marketplace/partners/bingmaps/mapapis/

Re: convert address to lat long

ThomasDay — Tue, 20 Sep 2016 13:07:38 GMT

@Greg_Deckler Thanks! Should have marked this as the answer quicker. As always, I'm in your debt---Tom