The page displayed above is used for querying information from the Air Stationary Source Facility table.  Some general notes on querying the facility table follow:

 

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

 

Ø      The Town column is a drop down list column allowing you to select a specific Town.

 

Ø      The Id and Master Id columns 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 facilities in CONCORD then you should expect the query to be slower than a query requesting all facilities in CONCORD with a name containing the word GARAGE.  It is RECOMMENDED that a town always be used when locating one or more facilities in a specific community.

 

Ø      The Maximum Rows/Page column allows you to select how many facilities 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 facilities 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 facilities 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 facilities 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 facilities 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