Ich finde 44695 Buildings mit building=yes, version > 1, die er zuletzt geändert hat.
Da ich keine Full History online habe, kann ich nicht feststellen, was dabei geändert wurde.
Hier ein Snapshot:
select osm_id, wno_striptags(tags)
from planet_osm_polygon
where building='yes'
and tags->'osm_user'='PT-53'
and tags->'osm_version'!='1';
127582021 | "building"=>"yes", "addr:city"=>"Veringenstadt", "addr:street"=>"Schulstraße", "addr:suburb"=>"Hermentingen", "addr:housenumber"=>"3"
127582007 | "building"=>"yes", "addr:city"=>"Veringenstadt", "addr:street"=>"Ortsstraße", "addr:suburb"=>"Hermentingen", "addr:housenumber"=>"13"
127582027 | "building"=>"yes", "addr:city"=>"Veringenstadt", "addr:street"=>"Schulstraße", "addr:suburb"=>"Hermentingen", "addr:housenumber"=>"5"
127582020 | "building"=>"yes"
127581992 | "building"=>"yes"
127581975 | "building"=>"yes"
127582013 | "building"=>"yes", "addr:city"=>"Veringenstadt", "addr:street"=>"Schulstraße", "addr:suburb"=>"Hermentingen", "addr:housenumber"=>"9"
127581994 | "building"=>"yes", "addr:city"=>"Veringenstadt", "addr:street"=>"Ortsstraße", "addr:suburb"=>"Hermentingen", "addr:housenumber"=>"22"
127581976 | "building"=>"yes"
127581958 | "name"=>"Galluskirche", "amenity"=>"place_of_worship", "building"=>"yes", "religion"=>"christian", "addr:city"=>"Veringenstadt", "addr:street"=>"Ortsstraße", "addr:suburb"=>"Hermentingen", "addr:housenumber"=>"20"
127582026 | "building"=>"yes"
127582018 | "building"=>"yes"
127582003 | "building"=>"yes"
127581988 | "building"=>"yes", "addr:city"=>"Veringenstadt", "addr:street"=>"Im Öschle", "addr:suburb"=>"Hermentingen", "addr:housenumber"=>"1"
127581974 | "building"=>"yes", "addr:city"=>"Veringenstadt", "addr:street"=>"Ortsstraße", "addr:suburb"=>"Hermentingen", "addr:housenumber"=>"24"
127582024 | "building"=>"yes", "addr:city"=>"Veringenstadt", "addr:street"=>"Ortsstraße", "addr:suburb"=>"Hermentingen", "addr:housenumber"=>"19"
127582005 | "building"=>"yes", "addr:city"=>"Veringenstadt", "addr:street"=>"Ortsstraße", "addr:suburb"=>"Hermentingen", "addr:housenumber"=>"11"
127582033 | "building"=>"yes", "addr:city"=>"Veringenstadt", "addr:street"=>"Schulstraße", "addr:suburb"=>"Hermentingen", "addr:housenumber"=>"7"
...
...
...
127582025 | "building"=>"yes"
127582011 | "building"=>"yes", "addr:city"=>"Veringenstadt", "addr:street"=>"Ortsstraße", "addr:suburb"=>"Hermentingen", "addr:housenumber"=>"12"
127582000 | "building"=>"yes", "addr:city"=>"Veringenstadt", "addr:street"=>"Ortsstraße", "addr:suburb"=>"Hermentingen", "addr:housenumber"=>"8"
127581980 | "building"=>"yes"
(44695 Zeilen)
wno_striptags() blendet die Metadaten aus.
Gruss
walter