any help with geocoding and reverse geocoding without api or from open source

[Deepak Sharda]

i googled and get this site address which is open source of geocoding and reverse geocoding but i am not expert in node.js  could you help . 

is it helpful for data relating to india. 

there was a file aattached as sample data for india 

https://github.com/pelias/pelias

[Bhanu K]

Hi Deepak,

Few options depending on the tool:

- if Google Sheets is an option, Geocode by Awesome Table is a good add-on.

- if Microsoft Excel is an option, geocode-excel is an offline version.

- Nominatim API can be used in a language of your choice.

thanks,

Bhanu

--
Datameet is a community of Data Science enthusiasts in India. Know more about us by visiting http://datameet.org
---
You received this message because you are subscribed to the Google Groups "datameet" group.
To unsubscribe from this group and stop receiving emails from it, send an email to datameet+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/a672e807-c8dd-4dba-8d79-f407aa076cb1%40googlegroups.com.

--

Bhanu

[Nikhil VJ]

Hi Deepak,

I was digging up regarding this recently and tried one option that didn't work out; sharing my notes:

Starting rule : Cannot rely on 3rd party service; needs to be self-hosted; use OSM country extract from https://download.geofabrik.de/ as base data.

Starting point:

OSM wiki page listing several different software for searching places:

https://wiki.openstreetmap.org/wiki/Search_engines

Osmnames + Sphinxsearch :

This seemed easier to start off so tried it. Once I got it depoyed, didn't get any proper results even for city names. I'm guessing the parameters may require fine-tuning. And I couldn't understand why they are involving wikipedia. It seemed like the search was relying more on data from wikipedia than from OSM.

Didn't explore on it further. (Spare time burned up!)

Nominatim related leads, where I want to dig into in next sprint:

https://www.cascadia-analytics.com/2017/10/01/nominatim-docker.html

https://github.com/mediagis/nominatim-docker

Pelias seems promising too, but we need a proper elasticsearch deployment to run it and that takes up quite some memory.

-----

My personal observations, may be inaccurate:

We should treat geocoding and reverse geocoding as two different applications.

Reverse geocoding would be much simpler to do, since you just need to put in the lat-longs and cough up the closest place names.

Geocoding involves complicated textual search, especially given the variations in ways place names are stored. There has to be high flexibility like making up for spelling differences. So elasticsearch seems like a good fit for it. Then, geo-constraining searches is very important here. We need ways to progressively narrow down the search areas and cut out false positives. Letting the user draw a box on the map to search in, for example, can greatly increase effectiveness of results rather than searching the whole country / planet data.

--
Cheers,
Nikhil VJ
https://nikhilvj.co.in

To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/CADbFdW4_1DrFTrQvpTdBuBmW2KMmm3Kxr8D84nmKK9Viwt6fmg%40mail.gmail.com.

[Deepak Sharda]

i am trying to pelicia with qgis and try to dig data will update you once i get some results

To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/CAH7jeuOFsm2NgkWWQt_582OW7UGithgqFAp02-hFC4%3D%3DWO_0eQ%40mail.gmail.com.

[Jobin Jose]

Geocoding can be done with the help of Google sheets. Please check these links

https://discourse.looker.com/t/get-latitude-longitude-for-any-location-through-google-sheets-and-plot-these-in-looker/5402

http://youtube.com/watch?v=vE5gTSw4M7Q

http://youtube.com/watch?v=ozjSCoJGgVc

--

[Sajjad Anwar]

Highly recommend https://opencagedata.com/. Based on OSM and several open datasets. Really good API and documentation. Also free for a pretty good number of requests.

Sajjad

To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/CAKmBd7tjac15zuV7raY5m3AwPGCCxee64FT1qMc_PTOKsjXUmg%40mail.gmail.com.

[Deepak Sharda]

thanks a lot.

i have so many data sets u can ask any time in shapefiles

To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/CALQA-LXH4yNvAgTZnLYA2cgbQQfkTmk3UUDnND5DhYuC3e6L%2BQ%40mail.gmail.com.

[Rajesvari Parasa]

Thank you, this thread was very helpful!

--

Regards,

Rajesvari

To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/CA%2B4SsQAXibDzWSp%3DV1gk%2Btd5bwTSkrycziyLzvvOkcQuMEXd2Q%40mail.gmail.com.

[Akshay S Dinesh]

Ah. I didn't notice this thread.

Pelias is completely free software and has importers for OSM data, geonames data and some other data sources. It allows import of a custom CSV with latitude and longitude also.

https://geocode.earth/ is a cloud instance run by the same people and can be used to preview how the results will be.

I've set it up once. I agree it takes some RAM to have elastic running fast.

As for India data, I think the alternate spellings aren't getting imported from OSM, geonames, etc. And therefore, the results are slightly less useful. Perhaps the importers can be patched to fix this.

But if you want to run a geocoding service on your own (or have loads of queries to make), it is a great starting point.

Akshay

To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/CAEKTdxrh0S8gYH2cze5Ldo5rXvubT%3D0RCOfAh8h%2BKTkpd5kG5g%40mail.gmail.com.