Hello. I am volunteering my time as a computer programmer to assist a local historical society in upgrading their online digital image collection. I've reviewed enough of your documentation to have hopes that Omeka is what I'm looking for. Since I am not the web server admin, I can't simply install Omeka and try it, so could you please confirm that Omeka will fulfill my requirements below?
The institution has an online collection of around 6,000 images that are currently in a non-user-friendly set of albums. I would like to work with the archivist to create the metadata, and then give them a SQL-driven web interface for image display.
I envision three types of fields: Y/N, free text, and lookup. For instance, I might have a Y/N field named "library" that the archivist would check if that picture contained a library, a free text field named "Description" which would hold a narrative about the scene, and a lookup field named "Street" which the archivist could fill using a combo box linked to a table containing all streets in the town.
I would want to give web users a similar interface so that, for instances, they could see all images of libraries on Main Street by checking the "Libraries" box and selecting "Main Street" from the dropdown. I would also like to have dependent fields, e.g. have a second combo box named "Street Number" that repopulates itself whenever the selection in "Street" changes.
I see from the demo videos that I can define data types and fields however I like, but will Omeka allow me to do the sort of querying I specify above?