The page displayed above is used for querying information from the Subsurface Sites table. Some general notes on querying the sites table follow:

 

      The wild card character % will allow you to query for word(s) anywhere within a column

 

      The Town, County and Permit Type columns are drop down list columns allowing you to select a specific Town, County and/or Permit Type

 

      If the owner name or street contains NO wild card characters (%), then one will automatically be placed at the beginning and the end of the name or street.

 

      The Approved Date From and Approved Date To MUST be used together.

 

1.      If the Approved Date From is missing or invalid, it will be replaced with 01/01/1900.

2.      If the Approved To Date is missing or invalid it will be replaced with 12/31/2090.

 

      Any combination of columns may be used to formulate your query.

 

      It is RECOMMENDED that a town always be used when locating one or more sites.

 

A query can be built in many ways and some examples follow:

 

1.

A user wishes to locate all sites in a specific town such as CONCORD.

 

1. Mouse-click to clear any previous query parameters.

 

2. EITHER locate the Town box and press the letter C key for the first town beginning with

the letter C then press the letter C key repeatedly until CONCORD appears in the town box

OR mouse-click the down arrow to the right of the town box for a list of towns, use the scroll bar

and scroll until you locate CONCORD and then mouse-click CONCORD to select it for querying.

 

3. Mouse-click

 

2.

A user wishes to locate all sites in any town with an owner name containing the word JONES appearing anywhere in the name.

1. Mouse-click to clear any previous query parameters.

 

2. Locate the Name box and key %JONES%

 

3. Mouse-click

 

3.

A user wishes to locate all sites in CONCORD with a owner name containing the word JONES appearing anywhere in the name.

1. Mouse-click to clear any previous query parameters.

 

2. Follow step 2 in Example 1 and step 2 in Example 2.

 

3. Mouse-click