Pawlet History
Home|Browse Records|Browse Album |Advanced Search

Browsing and Searching the Database [top]

The Pawlet Community Study Database contains over 700 images of life in Pawlet, Vermont from 1890 through 1990. The images in the database have been indexed to include a range of information about them and the people they represent.

Although the terms used for indexing these elements are not yet tied to a standard library cataloging vocabulary, the terms themselves are an internally consistent controlled vocabulary—meaning that each concept, item or feature indexed is consistently represented by only one term. Although one can enter any keyword into a search, in order to most effectively search the database it is useful to consult lists of these terms for reference purposes.

Controlled Vocabulary terms for each field are available in static lists that can be downloaded or printed and referred to in searching. When executing an Advanced Search, for several database fields one has the option of selecting field-specific terms and automatically adding them to searches. Explanations of these searches and others are provided below.

Table of Contents

Browsing the Database
Searching the Database
Special Search Functions

Browsing the Database [top]

Browsing using the database Record List View

Clicking on the Browse Records link available at the top of each page will return a listing of all the records in the database sorted according to Photo Number order. One can then explore the database by selecting individual records and viewing them.

Browsing using the database Album View

Using the Album View one can browse the database in Photo Number order via thumbnails of every image — except those that are only present as a part of a Photographic "Series". Clicking on a thumbnail will give access to a larger image and open an Image Viewer that allows for sequential viewing of image files and provides access to the database record for each image.

The Album View is accessible by clicking on the Browse Images link available at the top of each page. One can also access the database via the Database Album View page.

Browsing from Advanced Search

From Advanced Search one can call up hot-linked lists of keywords found in several database fields. Clicking on a keyword will query the database for that term, returning all records where the term appears in that field.

Browsing from Within Records

One can also browse the database from within records. In the record screen, keywords listed within database fields are hot-linked. Clicking on a hot-linked keyword will query the database for that term, returning all records where the term appears in that field.

For Example:

Clicking on the hot-linked term "tree" in the database field "Contents Keyword(s)" will return every database record where "tree" appears in that field.

Browsing using the Pawlet 1869 School District Map

Clicking on the link entitled Map in the Search Bar at the top of each page will open up the 1869 Pawlet School District Map. One can click on an individual school district on the map and browse all database records associated with that school district.

For Example:

Opening up the Pawlet 1869 School District Map and clicking on "Dist. No. 12" (Spanktown) will call up a list of all database records where the field "School District" includes the term "Spanktown."

Searching the Database [top]

Basic Search

Basic Search is accessed via the Search Bar at the top of each page. With Basic Search one can execute two kinds of the searches of the database by typing a term into the box, selecting a database field and clicking the Search button:

Search for a single term in an individual database field.

For Example:

Searching for the term "cow" and selecting "Background Features" will search for every occurrence of the word "cow" in the field "Background Features."

Or search for a single term across all the database fields.

For example:

Searching for the term "deer" and selecting "All" will search the database for every occurrence of the word "deer" in every field of the database.

Advanced Search

With Advanced Search one can execute a variety of complex searches of the database using the Boolean Operators AND and OR.

Search for a single term across multiple database fields using Boolean Operators:

For example:

Searching for the term "cow" in "Background Features" AND "Image Contents" will return only those database records where "cow" appears in both fields.

Searching for the term "cow" in "Background Features" OR "Image Contents" will return every record where "cow" appears in either field.

Search for multiple terms in a single database field using Boolean Operators:

For Example:

Searching for the terms "rug" AND "lamp" in "Image Contents" will return only those database records where both terms appear in the "Image Contents" database field.

Searching for the terms "rug" OR "lamp" in "Image Contents" will return every database record where either of the terms appear in the "Image Contents" database field.

Search for multiple terms across multiple database fields using Boolean Operators:

For Example:

Searching for the terms "rug" AND "lamp" in "Image Contents" AND "Background Features" will return only those database records where both terms appear in both database fields.

Searching for the terms "rug" OR "lamp" in "Image Contents" OR "Background Features" will return database records where either of the terms appear in the "Image Contents" database field.

It is also possible to create complex searches by combining search terms, database fields and multiple Boolean Operators into a single search.

For Example:

Searching for the terms "rug" AND "lamp" in "Image Contents" OR "Background Features" will return database records where both terms appear together in either database field.

Searching for the terms "rug" OR "lamp" in "Image Contents" AND "Background Features" will return database records where either term appears in both database fields.

Special Search Functions [top]

Keyword Lists

In Advanced Search users have the option of viewing the complete list of Controlled Vocabulary terms associated with several selected fields, and incorporating these terms directly into an Advanced Search.

The option to view a keyword list becomes available when one selects any of the following fields: "Last Name," "Image Contents," "School District," and "Occupations". To utilize field-specific terms in a search one clicks on "View Keyword List" and selects the desired term. It will then automatically populate the appropriate search box.

Yes/No Fields

Three database fields can only be searched using either "Yes" or "No": "Family (Yes/No)," "Interview (Yes/No)," and "Series (Yes/No)"

Entering "Yes" into any of these fields will limit results to records that include images of families ["Family (Yes/No)"], records that that include an interview transcript and/or an audio file ["Interview (Yes/No)"], or records that include a Photographic Series ["Series (Yes/No)"]. Entering "No" into any of these fields will exclude any of the above records from search results.

All Images Copyright © Susanne Rappaport. Unauthorized reproduction prohibited.
Please contact us if you would like permission.