Usage Instructions

The search form al­lows you to search im­ages by XMP meta­da­ta. On­ly a se­lec­tion of im­ages are cur­rent­ly ap­pro­pri­ate­ly tagged, but I’m suc­ces­sive­ly up­dat­ing the rest as I see fit.

The un­der­ly­ing data­base man­age­ment sys­tem is MySQL.

To the right of the text fields are two let­ters, rep­re­sent­ing the col­umn type (N = nu­mer­ic, S = string), and the col­umn in­dex (B = B‐​tree, F = full‐​text, K = key phrase). “Key phrase” isn’t re­al­ly an in­dex; see be­low for an ex­pla­na­tion.

The B‐​tree in­dexed text fields are short­cuts for <col­umn> LIKE '<string>' or <col­umn> = <string> ex­pres­sions, de­pend­ing on the type (string/​nu­mer­ic) of the col­umn, where <string> is the con­tents of the text field.

The full‐​text in­dexed text fields are short­cuts for boolean full‐​text MATCH (<col­umn>) AGAINST ('<string>' IN BOOLEAN MODE) ex­pres­sions, where <string> is the con­tents of the text field.

The “key phrase” text fields are dif­fer­ent from the rest in that the columns are stored in their own ta­bles which are JOINed with the main im­age ta­ble. You can en­ter mul­ti­ple key phras­es in a text field by us­ing a U+003B SEMI­COLON (;) as the de­lim­iter. Each key phrase is com­pared us­ing a LIKE op­er­a­tor.

For all text fields ex­cept the key phrase ones, you can negate an ex­pres­sion (NOT LIKE or NOT MATCH) by us­ing a U+0021 EX­CLA­MA­TION MARK (!) at the be­gin­ning of the string.

The Ad­di­tion­al Ex­pres­sions text field can be used to en­ter ad­di­tion­al ex­pres­sions. Please note that the key phrase columns can­not be used in these ex­pres­sions, for rea­sons ex­plained above.

The ex­pres­sions of all text fields (ex­cept the key phrase ones) will be com­bined with an AND op­er­a­tor.

The data­base ta­bles con­tain the fol­low­ing rel­e­vant columns:

image
Column NameColumn TypeIndex Type
pathVARCHARB‐Tree
sizeINT UNSIGNEDB‐Tree
dc_descriptionVARCHARFull‐Text
dc_formatVARCHARB‐Tree
dc_publisherVARCHAR 
dc_rightsVARCHAR 
dc_sourceVARCHAR 
dc_titleVARCHARB‐Tree
iptcCore_CreatorAddressVARCHAR 
iptcCore_CreatorCityVARCHARB‐Tree
iptcCore_CreatorCountryVARCHARB‐Tree
iptcCore_CreatorPostalCodeVARCHAR 
iptcCore_CreatorRegionVARCHARB‐Tree
iptcCore_CreatorWorkEmailVARCHAR 
iptcCore_CreatorWorkTelephoneVARCHAR 
iptcCore_CreatorWorkURLVARCHAR 
iptcExt_ArtworkCopyrightNoticeVARCHAR 
iptcExt_ArtworkDateCreatedVARCHARB‐Tree
iptcExt_ArtworkSourceVARCHAR 
iptcExt_ArtworkTitleVARCHARB‐Tree
iptcExt_LocationShownCityVARCHARB‐Tree
iptcExt_LocationShownCountryNameVARCHARB‐Tree
iptcExt_LocationShownProvinceStateVARCHARB‐Tree
iptcExt_LocationShownSublocationVARCHARB‐Tree
iptcExt_LocationShownWorldRegionVARCHAR 
pdf_KeywordsVARCHAR 
pdf_ProducerVARCHAR 
photoshop_DateCreatedVARCHARB‐Tree
photoshop_ICCProfileNameVARCHAR 
tiff_ImageWidthSMALLINT UNSIGNEDB‐Tree
tiff_ImageHeightSMALLINT UNSIGNEDB‐Tree
tiff_MakeVARCHARB‐Tree
tiff_ModelVARCHARB‐Tree
tiff_ResolutionUnitTINYINT UNSIGNEDB‐Tree
tiff_XResolutionDOUBLEB‐Tree
tiff_YResolutionDOUBLEB‐Tree
xmp_CreateDateVARCHARB‐Tree
xmp_CreatorToolVARCHARFull‐Text
xmp_MetadataDateVARCHAR 
xmp_ModifyDateVARCHAR 
xmpMM_DocumentIDVARCHARB‐Tree
xmpMM_InstanceIDVARCHARB‐Tree
dc_contributor
Column NameColumn TypeIndex Type
dc_contributorVARCHARB‐Tree
dc_creator
Column NameColumn TypeIndex Type
dc_creatorVARCHARB‐Tree
dc_subject
Column NameColumn TypeIndex Type
dc_subjectVARCHARB‐Tree
iptcExt_ArtworkCreator
Column NameColumn TypeIndex Type
iptcExt_ArtworkCreatorVARCHARB‐Tree
iptcExt_PersonInImage
Column NameColumn TypeIndex Type
iptcExt_PersonInImageVARCHARB‐Tree

You can dis­play a list of unique val­ues of any col­umn by en­ter­ing the col­umn name pre­ced­ed by a U+002D HY­PHEN‐​MI­NUS (-), e.g. ‘-dc_sub­ject’, in the Ad­di­tion­al Ex­pres­sions text field.