OvertureMaps / OvertureMaps/data
Missing `division_area`s for major cities
Open
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
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.