OvertureMaps / OvertureMaps/schema

division_area > subtype > borough > examples

Open
#402 0 comments 0 reactions 1 assignee View on GitHub

@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

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.