The page displayed above is used for querying information from the Site Remediation Site table.  Some general notes on querying the site table follow:

 

Ø      The wild card character % will allow you to query for word(s) anywhere within a column except the Site Number and Master Id columns.

 

Ø      The Site Town, Program and Project Type columns are drop down list columns allowing you to select a specific Site Town or Project Type.

 

Ø      The Site Number column must only be searched using numeric characters.  Using letters or special characters will cause an error.  

 

Ø      Any combination of columns may be used to formulate your query.  The more precise your query the faster the results will be returned conversely the more general the query the slower the results will be returned.  For example, if your query was built requesting all sites in CONCORD then you should expect the query to be slower than a query requesting all sites in CONCORD with a name containing the word GARAGE.  It is RECOMMENDED that a town always be used when locating one or more sites in a specific community.

 

Ø      The Maximum Rows/Page column allows you to select how many sites will be returned to you on each page as a result of your query.

 

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 a name containing the word GARAGE appearing anywhere in the name, i.e. Joes Garage and Auto Sales.

 

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

 

2.         Locate the Name box and key %GARAGE%

 

3.         Mouse-click

 

3.

A user wishes to locate all sites in any town with a name containing the word GARAGE located at the end of the name,  i.e.  Joes Garage.

 

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

 

2.         Locate the Name box and key %GARAGE

 

3.         Mouse-click

 

4.

A user wishes to locate all sites in CONCORD with a name containing the word GARAGE appearing anywhere in the name, i.e. Joes Garage and Auto Sales.

 

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