Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Generate place.sql file directly from planet file data #46

Open
hholzgra opened this issue Oct 15, 2022 · 2 comments
Open

Generate place.sql file directly from planet file data #46

hholzgra opened this issue Oct 15, 2022 · 2 comments

Comments

@hholzgra
Copy link
Owner

So far the place.sql file was generated form OSM Names data https://github.com/OSMNames/OSMNames, but unfortunately there has been now new release of that data since 2019.

As we only need a subset of the OSM Names data anyway (both in rows and columns), and with the new possibilities we now have with the osm2pgsql flex backend, the places table could probably generated more directly that way.

@hholzgra
Copy link
Owner Author

TODO:

  • generate alternative_names: can be done with Lua
  • generate display_name: geo hierarchy information not available to Lua during import, requires SQL post processing

@hholzgra
Copy link
Owner Author

hholzgra commented Mar 7, 2023

On hold for now as the upstream project has been revived

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant