Geocoding with excel

[David Oesch]

Dear list

We have an excel spreadsheet available  to easily geocode your addresses and display on a map 

http://cms.geo.admin.ch/www.geo.admin.ch/kml/geocoder.xlsx 

useful for geocoding reverse geocoding and putting addresses on a map 

[Radoslaw Panczak]

This is super helpful. 

Are there any limits we are allowed to geocode using such method?

Thanks,

Radek

[David...@swisstopo.ch]

«Fair use» is the limit. If you fire up to many requests (speaking of more than 20req/s - may vary)  – you might get blocked

 

Otherwise: feel free ….

--
You received this message because you are subscribed to the Google Groups "GeoAdmin API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to geoadmin-api...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/geoadmin-api/a920e860-a6a1-4714-8af1-76dee16fcf19n%40googlegroups.com.

[Radoslaw Panczak]

Thank you for prompt feedback David. 

Is the same 'fair use' a limit when it comes to using API via different methods?

We will work with 40k addresses in our project. Is that feasible when done at rates not exceeding what you recommended? Wouldn't like to get blacklisted right at the beginning ;)

You received this message because you are subscribed to a topic in the Google Groups "GeoAdmin API" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/geoadmin-api/T9uHlYD28Hc/unsubscribe.
To unsubscribe from this group and all its topics, send an email to geoadmin-api...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/geoadmin-api/ad63f6434e4840f5b1aea3d5a84cb244%40swisstopo.ch.

[David...@swisstopo.ch]

Does also apply to API requests ---if you place 2000 req/hour you are surely on the save side. And done in 24h

To view this discussion on the web visit https://groups.google.com/d/msgid/geoadmin-api/CAApPNyO%3Dik3Nw74GRsiHSv5sTApy3ef0w7tCDsgmyZFK9-TzAA%40mail.gmail.com.

[Radoslaw Panczak]

Perfect. Thank you!

To view this discussion on the web visit https://groups.google.com/d/msgid/geoadmin-api/a8bd4a76ff1247a2800c2df743b6dec6%40swisstopo.ch.

[mic...@gmail.com]

Hi all,

I've been using the reverse geocoding in excel for a while now with my own pipeline this year.

I noticed today that the response on a identify query on the gemeinde-fläche verzeichnis has changed. Now it give me a list of all historical "gde_nr" that this point used to belong to, whereas before we only got the most recent layer as a response.

Case in point, taken from the Documentation:

https://api3.geo.admin.ch/rest/services/api/MapServer/identify?geometryType=esriGeometryPoint&geometry=548945.5,147956&imageDisplay=0,0,0&mapExtent=0,0,0,0&tolerance=0&layers=all:ch.swisstopo.swissboundaries3d-gemeinde-flaeche.fill,ch.swisstopo-vd.ortschaftenverzeichnis_plz&returnGeometry=false

The problem is as follows: Excel cells and the Webservice function used to obtain this response cannot deal with content more than 32767 characters, while responses are usually in the 150k range. (see https://support.microsoft.com/en-us/office/webservice-function-0546a35a-ecc6-4739-aed7-c0b7ce1562c4).

How can the query above be adapted to only return the most recent gemeinde-layer or at least a sensible subset of data? Basically, I need to know how to filter the list of responses to the single one with the attribute is_current_jahr = true or filter for a certain year. 

Thanks

[Jürgen Hansmann]

Hi Micgas,

Could you please try to append `&timeInstant=2024` at the end of your request as an additional parameter?

(I knew it was something like this, but I had to ask a colleague, thanks @Tobias ;-) I tried something like `time=2024`, but it is `timeInstant`).

Does that help?

Have a nice weekend

Juergen

[mic...@gmail.com]

Hi Jürgen,

Your suggestion works, thank you. Is there a way to always get the most current one? 

The documentation is unfortunately not helpful. I've tried out a few ideas (current, now, today) but this was not a very fruitful exercise. 

Thanks, Mike 

[Jürgen Hansmann]

Hi Mike,

as far as I understood, in this case there is no such way currently, sorry.

Probably, depending on how you invoke the call, you can first get the current local date and pass the year as a parameter to the GET request, so you always have the current year in your request parameter?

Might that be a work around?

Have a nice weekend,

Juergen