NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

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

asked 08 May '20, 13:39

Cascafico's gravatar image

Cascafico
283202329
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 '20, 14:10

SomeoneElse's gravatar image

SomeoneElse ♦
36.9k71370866
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 '20, 14:22

Frederik%20Ramm's gravatar image

Frederik Ramm ♦
82.5k927201273
accept rate: 23%

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, 20:52

Cascafico's gravatar image

Cascafico
283202329
accept rate: 0%

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:

×38
×22
×2

question asked: 08 May '20, 13:39

question was seen: 2,283 times

last updated: 10 May '20, 20:52

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum