gramener / geocode-excel Goto Github PK

Hello,

I use Excel 2019 Professionnal 64 bits, when i try to use Nominatim functions : nominatimgeocode and NominatimReverseGeocode , the returned result is an error message : " Echec du téléchargement de la ressource spécifiée"

Would you please tell me how to fix that issue ?

Thanks,

Hello, when I try to reverse geocode using the Nominatim function (=NominatimReverseGeocode(lat, lng)) I get the red text "The download of the specified resource has failed."

This appears to be the case with multiple legitimate latitude-longitude pairs. Normal geocoding (=NominatimGeocode(address)) works with no problem. Am I missing something obvious, or do you see anything obvious that has changed with the API or elsewhere?

Thank you very much for your time developing this and for reading this :)

My excel sheet is saying request denied on Geocoding, can u suggest any solution!

Hi there,
I'm building an Excel-vba-geo/osm toolkit, https://github.com/krijnsent/geo_vba
I already built my own nominatim & overpass-turbo connection into my excel (not published yet), hope it's okay if I borrow some of your code? Or want to coop on building some more OSM & geography into Excel&VBA?

Hi,

just tried the Spreadsheet and it works as long as if there are no umlauts in the adress. I tried geocoding some german adresse and most of them failed because street is spelled Straße over here. Addresses located in Fürth also didn't work.

Is there a way to fix this?

Kind regards

Christian

Hi,

First of all, thank you for your work!

I am currently testing the reverse geocoding feature with Nominatim.

I have a cell with latitude, another with longitude and using the formula =NominatimReverseGeocode(lat, lng), I get an error when I have complex GPS coordinates like for example: 38.8950368,-77.0365427.

It only works with values without decimals.

Am I missing something?

Killian

Hi,

I would like to use your tool for Nominatim, OpenStreetMap Api.

I was trying to use your code, copying it from the source file, which looks like this:

Function NominatimGeocode(address As String) As String Application.Caller.Font.ColorIndex = xlNone Dim xDoc As New MSXML2.DOMDocument xDoc.async = False xDoc.Load ("https://nominatim.openstreetmap.org/search?format=xml&q=" + address) If xDoc.parseError.ErrorCode <> 0 Then Application.Caller.Font.ColorIndex = vbErr NominatimGeocode = xDoc.parseError.reason Else xDoc.SetProperty "SelectionLanguage", "XPath" Dim loc As MSXML2.IXMLDOMElement Set loc = xDoc.SelectSingleNode("/searchresults/place") If loc Is Nothing Then Application.Caller.Font.ColorIndex = vbErr NominatimGeocode = xDoc.XML Else Application.Caller.Font.ColorIndex = vbOK NominatimGeocode = loc.getAttribute("lat") & "," & loc.getAttribute("lon") End If End If End Function

but after typing the formula into my Excel document: =nominatimGeocode(AA2) I am getting an error:
**Compile error

User-defined type not defined**

I came to consultation, that you used your own API key, so it might cause the problem. I set up my own API key on the Mapquest.com, and receive it.

Now I don't know, where to place it.
I superseded the line:
Dim loc As MSXML2.IXMLDOMElement, which was indicated by the VBA excel debugger.
I put my API key like this: Dim loc As (myAPI).
Unfortunately now, the debugger points the same line, and error says Syntax error.

Could you help me to sort it out?

Thank you in advance,

Hi,

I just want to ask about the upper limit of geocoding in Excel.
For example, the Bing API can geocode up to 10k addresses from one account.
How about the Nominatim. Is it limited at some point?
Thanks