Photos     Search Photo Albums    
imac.alexwilliams.com/photo_find.php  
3270 photos
1,725,104,545 pixels
2311 ft2 at 72 pixels per inch.

Main     Info     Files     Back to Photos     Links

This is an search page for my photo albums. You can search for photos with specific people in them, or search by title or keyword. Photos posted through September 2003 are accessible through this search page. If you want to know how to do an advanced search, scroll to the explanations at the very bottom of this page. This search is powered by a PostgreSQL database running on Mac OS X.

First Name:
Searches with last names will usually turn up nothing. To return results for XYZ or ABC, use the format "XYZ|ABC" ("|" character is shift-backslash).
Filename:
Useful for photos without keywords. As an example, "Soda" returns some photos of Berkeley's Soda Hall, and some photos of people holding soft drinks.
Keyword:
Some photos have keywords, others do not. Examples: "guinea pig" or "bowling". Keywords are very haphazardly defined. If you search for "bowling," for example, don't expect to get every single bowling picture, since many bowling photos lack that keyword.
Search:
Once you have input your desired search terms, search the photo album with the button above. Results will only be returned if they match ALL of the above fields. If you get no results, try entering results into only one field.






Advanced Search Information:
  • Single search terms work best: You can do more sophisticated searches, but it is more likely that you will get no results back.
  • First names only: Most people are listed in the database by first name only. If you can't find someone, try searching for *just* the person's first name. Notable names: "Mike Paik" is listed as "Mike" in this database. "Michael" will find you Michael Connolly, but not Mike Paik. Use first names only when searching, unless you are sure that the full name is in the database.
  • Multiple Search Terms (OR): When entering multiple search terms into a field (if you wanted all pictures with either "michael" or "tony" in them, for example), do not use spaces between the names—instead, use the vertical bar "|" (shift-backslash). Example: "alex|evan|squid" would find photos with "alex," "evan," or "squid" in them. I don't know of any easy way to do an "AND" search here, but here is an awkward way: search for "(name1.*name2)|(name2.*name1)". This becomes extremely ugly for more than two names.
  • Clever-er searches: The fields are interpreted as perl-style regular expressions. So if you wanted to find any name starting with "mi," you could do a search for "mi.*". This would find "michael" and "mike" (and "michelle," etc.). The notation for these expressions is somewhat complicated, and can be found in more detail by searching for "perl" and "regexp" on the web.

Each photo has the following data associated with it:
  • index: A unique ID associated with each photo, no special significance.
  • filename: The file's name.
  • size_bits: File size in bits. 8192 bits = 1 kilobyte.
  • width: Photo width in pixels.
  • height: Photo height, in pixels.
  • created: Approximately when the photo was first exported for the web.
  • modified: Approximately when the photo was last modified.
  • people: The people in each photograph. This was manually entered.
  • keywords: Just a bunch of keywords.
  • place: A special keyword indicating where the photo was taken (e.g. Berkeley, Memphis).
  • description: Most photos do not have a description.
  • state: The state or country
  • photographer: Usually the person who took the photo, or the owner of the camera.
  • path: The location of the photo file on the hard drive.

This site is running on Mac OS 10.3 on a 1.0 GHz eMac.

Alexander Graehl Williams
Undergrad: U.C. Berkeley
Grad School: Stanford