OvertureMaps / OvertureMaps/schema
division_area > subtype > borough > examples
Open
@danabauer is already working on this.
Since Jan 30, 2026.
change type - documentation - docs team 📝
- Dominant language
- Python
- Stars
- 213
- Forks
- 22
- Avg merge
- 3d 3h
- Merged PRs (30d)
- 31
Description
In the division_area documentation (https://docs.overturemaps.org/guides/divisions/) it lists "Brooklyn, Queens, etc." as examples of subtype=borough but in the data these are subtype=locality
SET s3_region='us-west-2';
SELECT
names.primary,
subtype,
country,
region,
FROM
read_parquet('s3://overturemaps-us-west-2/release/2025-09-24.0/theme=divisions/type=division_area/*', hive_partitioning=1)
WHERE
country = 'US'
AND region = 'US-NY'
AND names.primary IN ('Manhattan', 'Brooklyn', 'Queens', 'The Bronx', 'Staten Island');
Returns:
│ primary │ subtype │ country │ region │
│ Staten Island │ locality │ US │ US-NY │
│ Brooklyn │ locality │ US │ US-NY │
│ Queens │ locality │ US │ US-NY │
│ Manhattan │ locality │ US │ US-NY │
│ The Bronx │ locality │ US │ US-NY │
SET s3_region='us-west-2';
SELECT
names.primary,
subtype,
country,
region,
FROM
read_parquet('s3://overturemaps-us-west-2/release/2025-09-24.0/theme=divisions/type=division_area/*', hive_partitioning=1)
WHERE
subtype = 'borough'
AND country = 'US'
AND region = 'US-NY';
Returns nothing
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.