How can I list all usernames that a vandal used in the past, using unique UID?

asked 08 May, 13:39

Cascafico's gravatar image

Cascafico
56358
accept rate: 0%


If you want to find usernames that a particular account used to edit with then "Who's That" will help - like this: http://whosthat.osmz.ru/?q=SomeoneElse2. However, that won't necessarily match all names that that account has been called (often users who have been blocked change the account name afterwards). The userid will be constant though, so you can use it e.g. at http://resultmaps.neis-one.org/osm-discussion-comments?uid=490556.

However, often "vandal" users (of which there are thankfully not many) will create multiple accounts, so you sometimes need to look for "edits to the same sort of objects in a similar style".

If you're aware of a vandal account please of course email the Data Working Group at data@osmfoundation.org !

permanent link

answered 08 May, 14:10

SomeoneElse's gravatar image

SomeoneElse ♦
33.2k65344785
accept rate: 16%

Another option that leads to the same results, but does not depend on a third-party web site, is this:

  • get a full history planet file (.osh.pbf)
  • install the osmium command line utility
  • convert the full planet file into easily parsable "opl" format and check for all lines that contain " i<userid>"
  • those lines will also have " u<username>" which you can use to list the user name.

Here's a Linux one-liner (fsvo) that will do it:

curl https://planet.openstreetmap.org/pbf/full-history/history-latest.osm.pbf |
   osmium cat -Fosh.pbf -fopl |
   grep " i490556 " |
   sed -e "s/.* u//" |
   cut -d\  -f1 |
   sort -u

If you are only looking for actions in a particular country or region, you can also download a regional history file instead which speeds up the process.

Note that neither whosthat.osmz.ru nor this process will return user names that the user may have had, and may have used to write messages, but has not used for editing OSM.

permanent link

answered 08 May, 14:22

Frederik%20Ramm's gravatar image

Frederik Ramm ♦
73.9k866671145
accept rate: 24%

Thanks for your answers. I will go for the "whosthat", a good start for investigation. And in the future I'll experiment on planet full-history filters.

Of course, I sent a block request for user to DWG.

permanent link

answered 10 May, 20:52

Cascafico's gravatar image

Cascafico
56358
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×35
×20
×2

question asked: 08 May, 13:39

question was seen: 212 times

last updated: 10 May, 20:52

powered by OSQA