OvertureMaps / OvertureMaps/data

Missing `division_area`s for major cities

Open
#235 2 comments 0 reactions 2 assignees View on GitHub

Nobody has claimed this yet.

divisions
Dominant language
Python
Stars
1.2k
Forks
47
Avg merge
3h 42m
Merged PRs (30d)
1

Description

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!!

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.