User:Kbh3rd/Tagging queries

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

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.