I don't works with geocoding before. But I have geocoding task now. We have postgreslq database with addresses data. And we have two ways for geocoding: nominatim and pelias (are placed on different server than address DB).

There is issue:

  • how unload addresses data from data base for geocoder well?
  • We have to choose .csv or something more?
  • maybe exists way of linking DB with geocoder without unloading?

In general, you'll find that geocoders have to work with their own database, and cannot be linked to an existing one. There are too many combinations of configuration parameters, table schemas, etc to handle.

However, exporting data into a format that can be imported into a geocoder's database is usually possible.

For Pelias, the csv-importer was designed precisely for this task. The CSV format used by Pelias is quite simple and so you should be able to write a small SQL query to do it. For Postgres, the COPY command is helpful.

| improve this answer | |
  • Thanks! so pelias the csv-importer can do forward geocoding too? (reverse geocoding is shown in csv-importer docs) – Tyomik_mnemonic Aug 9 '19 at 5:52
  • 1
    Yes, the csv-importer is used to bring data into Pelias for any use, so it can then be used for forward geocoding, reverse geocoding, autocomplete, structured geocoding, or any of the other functionality of Pelias. – orangejulius Aug 9 '19 at 11:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.