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.

Sign up for GitHub

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

Jump to bottom

Implement location hierarchy proposal #38

Open

tholzheim opened this issue Jun 2, 2021 · 2 comments

Assignees

Labels

Collaborator

tholzheim commented Jun 2, 2021

see #35
refactor from here as start https://github.com/SmartDataAnalytics/OpenResearch/blob/master/migration/openresearch/location.py

WolfgangFahl assigned tholzheim, WolfgangFahl and somnathrakshit

WolfgangFahl added the enhancement label

Collaborator

WolfgangFahl commented Aug 14, 2021

see https://www.wikidata.org/wiki/Q56061#/media/File:World_administrative_levels.png

Collaborator

WolfgangFahl commented Aug 19, 2021

select count(*),hierarchy 
from location_labels
group by hierarchy

count(*)	hierarchy
1302117	City
1486	Country
7480	Region

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment