I would like to add something new to this whole story.
We developed some years ago a gallery called K-OS
catserver.ingenieriasinfronteras.org/k-os .
We did that because we wanted to have several pictures classified per different parameters; for exampleL: water supply, b/w, nicaragua.
Besides this we wanted to be able to get all pictures in Water(including those which have water supply, water tratment, pumps, etc).
What we did is the following:
- Table 1: Pictures. All information of pictures: date, size, contributor, etc
- Table 2: Words. To make a tree of words so you could have Water/Supply/Pump/Manual, for example; or Location/Central America/Nicaragua/Chontales.
- Table 3L: Words_Pictures. With all relations between words and pictures.
In this way we could easyly list all pictures we were looking for.
Furthermore, if you are an administrator, you can add/delete words and assign a word to several pictures at the same time.
The idea is that if you search for pictures of Manual Pumps, you search the pictures, and once you find them, you can add the word Manual in the Tree and assign that word to those pictures.
I think something similar to this would be really really really helpful for many people.
Our problem is that we are not very good programmers and the final K-OS is quite a mess. We programed it because we didn't find this functionality in any gallery available in the web.
Finally I would just like to add that we did this under GNU license so, if you are interested, I can send you the code.
Ignasi