The page displayed above is used for querying information from the Watershed Assistance Grants table. Some general notes on querying the grants table follow:

 

      The wild card character % will allow you to query for all data occurrences.

 

      All the columns are drop down list columns allowing you to select a specific Fiscal Years, Funding Sources, Organizations and Major Watersheds.

 

      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 funding types in fiscal year 2001 then you should expect the query to be slower than a query requesting the funding type SECTION 319 Base with a fiscal year 2001. It is RECOMMENDED that a fiscal year and/or funding type always be used when locating information.

 

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

 

1.

A user wishes to locate all grants funded in a fiscal year 2001.

 

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

 

2. Mouse-click the drop down list for fiscal year and select 2001.

 

3. Mouse-click

 

2.

A user wishes to locate all SECTION 319 Base grants funded in any fiscal year.

 

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

 

2. Mouse-click the drop down list for funding and select Section 319 Base.

 

3. Mouse-click

 

3.

A user wishes to locate all SECTION 319 Base grants funded in fiscal year 2001.

 

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

 

2. Mouse-click the drop down list for fiscal year and select 2001.

 

3. Mouse-click the drop down list for funding and select Section 319 Base.

 

4. Mouse-click

 

4.

A user wishes to locate all grants funded in all fiscal years.

 

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

 

2. Mouse-click