-
Notifications
You must be signed in to change notification settings - Fork 41
Open
Description
In the schema description, borough subtype is described as 'unit, below the locality placetype, e.g. Brooklyn, Queens, etc.'
But: The current release 2025-10 has absolutely no division with subtype=borough. Neither in division_areas, nor in divisions type.
My rough expectation: I would expect this subtype to appear maybe even more often than localities (1 city with n boroughs is quite common).
SELECT count(*) as count, subtype
FROM
read_parquet('s3://overturemaps-us-west-2/release/2025-10-22.0/theme=divisions/type=division/*')
GROUP BY subtype
ORDER BY count DESC ;
count subtype
3377993 locality
679757 neighborhood
220989 microhood
151567 macrohood
38799 county
21133 localadmin
3906 region
219 country
53 dependency
If my understanding or expectation is wrong, then please give me some advise.
Metadata
Metadata
Assignees
Labels
No labels