Jump to content

User:Kbh3rd/Tagging queries

From Wikipedia, the free encyclopedia

Testing some queries against a copy of the database to find images w/o tags that might easily be recognized as deserving of a certain type of tag. This is against the January 7 dump, so it's out of date for meaningful work – most of these will already be tagged. E.g.:

"Public" but not tagged

[edit]

If the image description has the word "public", it might very well be described as public domain. So let's look for all untagged images with "public" in the description field:

select img_name, img_description from image where img_description like '%public%' and img_description not like '%{{%' ;

Name Description
Image:022srUSGSCyprusVia.jpg USGS public domain image. 22. Side view of support-column failure and collapsed upper deck, Cypress viaduct. [H.G. Wilshire, U.S. Geological Survey]
Image:0817tmp3.jpg 2004 Ford Territory. Ford New Zealand publicity photograph.
Image:122-38.gif USGS public domain faultline image
Image:1837flagsm.jpg Republic of Canada flag (1837)
Image:18th_century_bidet.jpg An etching from the 18th Century of ladies using bidets (now in the public domain).
Image:1905WhiteAuto.JPG Advertisement now in the public domain
Image:1946LincolnZepher.jpg 1946 Lincoln Zephyr, cropped from photo put in public domain on loc.gov
Image:1967-VW-Beatle.jpg Picture taken by User:Minesweeper on December 14, 2003 and released into the public domain.
Image:1973_C150L_19370.jpg Picture of (my) cessna 150L - public domain
Image:1_Norwegian_krone_adverse.jpg Taken from the official website of the Central Bank of Norway, which is owned by the Norwegian state, so public domain is assumed.
Image:1_Norwegian_krone_reverse.jpg Taken from the official website of the Central Bank of Norway, which is owned by the Norwegian state, so public domain is assumed.
Image:2002_Winter_Olympics_flame.jpg public domain
Image:2004GOPconventionlogo.png 2004 Republican National Convention logo
Image:2004_canadian_election_approval_ratings_June_2.png Approval ratings (percentages) for the 2004 Canadian federal election, created by Nicholas Moreau, public domain
Image:2MASS_logo.jpg 2MASS logo: images are public domain [1], c/o 2MASS/UMass/IPAC-Caltech/NASA/NSF
Image:4-42_FA_Coat_of_Arms.PNG This file is from a US Government website (http://www.hood.army.mil/4ID_4-42fa/coat_of_arms.htm) and so, to the best of my knowledge is in the public domain
Image:47b4d728b3127cceb66e1e3b27280000005610.jpg Picture found on Ebay, should be public domain
Image:50Cent.jpg publicity photo from official site, upped as fair use
Image:5p_pwy_pansies.jpg purple, white & yellow pansies. I release this picture into the public domain; you do not need my permission to reuse it, but do not claim that you took it.  :-) --KQ
Image:6-Genghis-Khan.gif This image is in public domain.

This could also be used to find images claimed to be PD, but probably are not. That EBay image, for example – I doubt that there's anything in the US law that says you lose your copyright by putting an image on an EBay page.