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

Missing division_areas for major cities #235

Open
phgn0 opened this issue Sep 27, 2024 · 0 comments
Open

Missing division_areas for major cities #235

phgn0 opened this issue Sep 27, 2024 · 0 comments

Comments

@phgn0
Copy link

phgn0 commented Sep 27, 2024

Hey!

I noticed that many large cities (subtype=locality) are present in the division dataset but have no related entry in division_area:

SELECT
  divisions.id,
  divisions.names.primary,
  divisions.country as country_code,
  divisions.population
FROM
  `bigquery-public-data.overture_maps.division` as divisions
WHERE
  divisions.subtype = 'locality' AND
  divisions.population >= 100000 AND
  NOT EXISTS (
    SELECT 1
    FROM `bigquery-public-data.overture_maps.division_area` as areas
    WHERE divisions.id = areas.division_id
  )
ORDER BY
  divisions.population DESC

This returns 3872 rows, including Beijing, Tokyo, Istanbul, or Berlin.

Many of those city boundaries exist on https://whosonfirst.org. Could we add their data sources to Overture?

Thank you!!

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

No branches or pull requests

2 participants