Natural Resource Management System (NRMS): Database Descriptions

Database Descriptions

Area Databases:
These databases contain data specific to recreation areas.

AR_MAIN (1984-1999) - This database contains information about the recreation area including acreage, managing agency, cost share agreements, open/close status, number and type of sanitary facilities, etc.
FACILTS (1984-1986) - This database contains the number and types of recreation facilities found in the area. Facilities in concession areas, which are reported in the CONCESN database, are double-counted in this database.
OPEN_FC (1987-1999) - This database (which replaced the FACILTS database found in the years 1984-1986) contains the number and types of recreation facilities found in the areas that are open for public use. The same data fields are found in the CLOSED area database. All recreation facilities for the recreation area are counted except for facilities in concession areas, which are reported in the CONCESN database, and facilities listed in the CLOSED database. There should be no double-counting between these databases.
CLOSED (1987-1999) - This database contains the number and types of facilities found in the recreation areas that are closed for public use. Seasonal closures are not included in the CLOSED database. The same data fields are found in the OPEN area database.
CONCESN (1984-1999) - This database contains the number and types of facilities found in the recreation area that are managed by a concessionaire(s) and open for public use. The CONCESN database is exclusive of the OPEN_FC database. This is a multiple-record database.
PRO_FEE (1984-1999) - This database contains fee information for those recreation areas proposed to be included in the FEE Program for the next FY. The proposed number and type of fee campsites, method and dates of collection, camping fee and special facility fee rates are included. This is a multiple-record database.
CUR_FEE (1984-1999) - This database contains fee information for the recreation areas that were in the Fee Program during the report FY. The number and type of fee camp sites, method and dates of collection, camping and special facility fee rates, special event permits fees, various total fees collected, and visitor hours are included in this database. This is a multiple-record database.
COOP_AS (1992-1999) - This database contains information about formal cooperating association agreements; wherein non-profit, tax-exempt corporations enter into agreements with the Corps for their mutual benefit. Refer to ER 1130-2-441 for further information about cooperating associations.
CC_SHARE (1995-1999) - This database contains information about Challenge Cost-Share Agreements with non-Federal public and private groups and individuals to contribute to and participate in the O&M of Corps water resource development projects. Refer to ER 1130-2-426 for further information.

Project Databases
These databases contain data specific to the project as a whole.

PR_MAIN (1984-1999) - This database contains project purposes as specifically authorized by congress and establishes the Project Name for use in all databases.
PR_STAT (1984-1999) - This database contains various project pertinent data such as acquisition policy, pool elevation, boundary, budget, encroachments, land and water acres, shoreline miles, signs, etc.
MSA (1984-1999) - This database contains information related to the metropolitan area or areas nearest the project. This is a multiple-record database.
PR_USE (1984-1999) - This database contains visitation data and activity use for the project.
TREEPLT (1984-1999) - This database contains tree-planting information concerning cumulative acres of reforestation and wind barriers.
PR_DATE (1984-1999) - This database contains the dates that impoundment began and recreation facilities were complete. It also contains approval dates and scheduled updates of various documents such as master plans, operational master plans, sign plans, and visitor-use surveys.
PERSNEL (1984-1999) - This database contains numbers of various project personnel, their educational background, FTE's, and volunteer information.
GOLDAGE (1984-1999) - This database contains the number of Golden Age and Golden Access passports issued and estimates the number needed for next season.
LNDMGNT (1990-1999) - This database contains the land use allocations for the project as defined in ER 1130-2-435, "preparation of Project Master Plans" and lists the respective managing agencies. This database would be used for those Projects whose Master Plans have been developed using this new ER. This generally would only include new Projects or older Projects whose Master Plans have been recently updated.
MNGAGCY (1984-1999) - This database contains the land use allocations for the project as defined in ER 1120-2-400, and lists the respective managing agencies. Most projects will use this database until such time that their Master Plans have been updated under ER 1130-2-435.
PROJMGR (1984-1999) - This database contains the name of the primary point of contact for the project, addresses, phone numbers, etc.
LAW_ENF (1984-1999) - This database contains the number and types of Title 36 citations and written warnings. It also contains the number and costs of law enforcement agreements.
VIS_CTR (1984-1999) - This database contains information about the project visitor center, such as the year it was completed, the name, staffing, type, number of visitors, etc.
DOCKS (1984-1999) - This database contains information on the number and types of use permits for the project in accordance with ER 1130-2-406.
DIS_DIV (1991-1999) - The information in this database pertains only to the District and Division Natural Resources Management office and covers employees, both full-time and part-time permanent, that are engaged in recreation and natural resources management activities.

Home