search

gramener / geocode-excel

Convert addresses to lat-longs (and vice versa) in Excel
49 stars 23 forks source link

OSM - excel toolkit #5

Open krijnsent opened 4 years ago

krijnsent commented 4 years ago

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?

sanand0 commented 4 years ago

@krijnsent That sounds great!

Please feel free to use any code.

I'd love to help build geo capabilities into Excel. What did you have in mind?

krijnsent commented 4 years ago

I am using my code to find e.g. data inconsistencies I can then correct in OSM. E.g. looking for everything "ice_cream" through nominatim & overpassturbo give me a table of all nodes in my city with: shop=ice_cream, cuisine=ice_cream or amenity=ice_cream. That table is very helpful to find missing info and add that.

Next, I wanted to plot those ice_cream shops on a map, but Excel only has a Chloropleth map with predefined regions. My thinking was: why don't I create a map-chart-type: get map bounds from my coordinates, import map tiles, merge them into 1 image and use them as a background for a scatterplot. So that's what I'm building towards, starting with the building blocks I learned from Leatfletjs as a kind of cross-inspiration.

I think that in a next version I'll add my current OSM code so you can get a better idea of what I've built so far. I do have to polish it though :).

krijnsent commented 4 years ago

Just updated my code, have nominatim search & reverse search working with some expanded options versus your code. I did learn some stuff from your code though, thanks! Next up for me: overpass-turbo