I, being a lazy person, took ChangesetMD and modified it to import OSM notes into a pgsql database. I called it, well, NoteMD ;-) [1] Other than that, I hacked ChangesetMD [2] to add some small "epsilon" to changeset bboxes if they're zero height/width so that PostGIS doesn't complain about invalid geometries. One can easily import each of these into a single DB and make mashups of these two datasets.
[1] https://github.com/RicoElectrico/NoteMD [2] https://github.com/RicoElectrico/ChangesetMD Michał On Sun, Jan 28, 2018 at 9:06 PM, Mateusz Konieczny <[email protected]> wrote: > Is there some existing tool to query note activity (especially > closing) by user with low edit count? > > I noticed a vandal creating multiple accounts*, all with 0 edits > and closing random valid notes (or at least closing without > explanation notes that seemed to not be clearly invalid). > > I undid it in cases of two accounts that closed also my notes but I > expect problem to be more widespread. > > *maybe accounts that I encountered were unrelated but given very close > timing, similar area and that this is highly unusual activity I suspect > a single person. > > _______________________________________________ > talk mailing list > [email protected] > https://lists.openstreetmap.org/listinfo/talk >
_______________________________________________ talk mailing list [email protected] https://lists.openstreetmap.org/listinfo/talk

