Within the Berlin category on Wikimedia Commons, I want to see all images with width > 2100 pixels.

Is there a way to get this?

Bonus if thumbnails are shown, so that I can efficiently choose a picture I like.

1 Answer 1


You can sort by size in catscan (by Magnus Manske, the creator of MediaWiki): http://tools.wmflabs.org/catscan2/catscan2.php

Berlin images sorted by size; or, more useful category, Quality images of Berlin sorted by size. You can't filter by width, but file size is a good approximation, there's a width column and you can pick the appropriate category. Walking subcategories is unreliable due to how MediaWiki categories are made but you can try (look at the bottom after all the errors). You can also produce a gallery which you'd then need to preview on a Commons page; and there are other tools/versions which produce thumbs but have less filtering/sorting options.

  • My attempts fail with Unknown MySQL server host 'commons.labsdb'... would you be kind enough to provide the request itself? There is a convenient Link to a pre-filled form for the query you just ran (preferably without autorun). Thanks!
    – nic
    Commented Jan 19, 2014 at 1:14
  • 2
    Added above, the tool had some problems.
    – Nemo
    Commented Jan 19, 2014 at 20:39
  • Looks like PetScan (the new CatScan) no longer supports this functionality.
    – Ynhockey
    Commented Aug 20, 2018 at 8:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.