Skip to content

Wikidata in NZ divisions missing #454

@davelowndes

Description

@davelowndes

I have been using the 2025-05-21.0 release. Around 85% (2989) of the 3498 divisions in 'NZ' had wikidata ID. Now there's only 18 in the 2026-01-21.0 release, for just the country and regions. The Wikidata ID is important for creating relationships to other sources. Do we know why the Wikidata IDs are missing?

Running in WSL/Linux:

docker run --rm duckdb/duckdb duckdb -c "
INSTALL httpfs; LOAD httpfs;
SET s3_region='us-west-2';
SELECT id, subtype, country, wikidata, names.primary AS name
FROM read_parquet('s3://overturemaps-us-west-2/release/2026-01-21.0/theme=divisions/type=division/*')
WHERE country='NZ' AND wikidata IS NOT NULL
ORDER BY subtype, name
;"

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions