division_area > subtype > borough > examples

[PeterTWNLUS]

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