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鈥檒l occasionally send you account related emails.

Already on GitHub? Sign in to your account

馃椇 Include GeoNames to verify admin boundaries #73

Closed
wants to merge 1 commit into from

Conversation

mattigrthr
Copy link
Contributor

Closes #72

We are downloading city names from GeoNames as described in the issue to improve the admin boundaries' quality further.

I've added a downloader for the GeoNames file in the admin-boundaries pipeline, transforming the original txt file into the Parquet format.

The Parquet result is then imported into a new table in Postgres called admin_boundary_geonames_cities.

Now, I will use dbt to combine the OSM admin-boundary hierarchy with the city names.

@mattigrthr mattigrthr added enhancement New feature or request pipeline Issues related to pipelines core Issues related to the core new data source Issues about including a new data source pipeline/admin-boundaries Issues related to the admin-boundaries pipeline labels Jan 17, 2022
@mattigrthr mattigrthr self-assigned this Jan 17, 2022
@mattigrthr mattigrthr added this to In progress in Kuwala via automation Jan 17, 2022
@mattigrthr
Copy link
Contributor Author

The city names are matched based on OSM and GeoNames. I'm already using it in the poi dbt model. What's left to do is to add documentation to the admin-boundary pipeline and the database_transformer.

@mattigrthr mattigrthr force-pushed the features/admin_boundaries_geonames branch 3 times, most recently from 3d63723 to 99f3f21 Compare July 29, 2022 10:35
@ephe-meral ephe-meral force-pushed the features/admin_boundaries_geonames branch from 99f3f21 to 8a68bb5 Compare August 10, 2022 09:00
@ephe-meral
Copy link

Updated & pushed, should be ready for review @mattigrthr

@mattigrthr mattigrthr removed their assignment Dec 16, 2022
@mattigrthr mattigrthr closed this Dec 16, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
core Issues related to the core enhancement New feature or request new data source Issues about including a new data source pipeline/admin-boundaries Issues related to the admin-boundaries pipeline pipeline Issues related to pipelines
Projects
No open projects
Kuwala
In progress
Development

Successfully merging this pull request may close these issues.

Include GeoNames to verify admin boundaries
2 participants