USDA Forest Service
 

Blue Mountains Natural Resources Institute

 
This research program is no longer active.
 
   
Education Links
Information Providers
   
   
Managing Disturbance Regimes
   
Pacific Northwest Research Station
   
USFS Research & Development
   
Evaluate Our Service
Your comments and suggestions are very important to our service improvement.

Pacific Northwest Research Station
Blue Mountains National Resources Institute

Forestry and Range Sciences Laboratory
1401 Gekeler Lane
La Grande, OR 97850

United States Forest Service.

BMNRI Home > Research > Databases > HUSSI


Research

Databases and Software: The Hopkins U.S. System Index (HUSSI)

The Hopkins U.S. System Index (HUSSI) is an information resource for forest entomologists, systematic entomologists, pest management specialists, foresters, and students.


The Hopkins U.S. System is:

  • A collection of notes on thousands of insect and damage specimens from forests or wood products taken mainly in the United States, some from Canada, Mexico, Central America, South America and other regions.
  • Information includes location, date, taxon, insect and plant host association, and other searches, measurements, quantitative data and other information in tabular or narrative form.
  • Specimens related to the records are in collections at several USDA Forest Service installations; at the U.S. National Museum, Smithsonian Institution, Washington, DC; and at several universities.
  • The system, begun by Dr. A.D. Hopkins about 1900, now contains over 160,000 written records.
What can you do with HUSSI?

You can import the database into dBase, Access, FoxBase, RBase, Paradox, and other XBase-type programs.

You can scan the data dictionary which describes information entered in the 16 fields abstracted from the Hopkins U.S. System records.

You can structure specific queries and reports that show:

  • Plant hosts
  • Insect hosts
  • Parasites & predators
  • Geographical distribution
  • Collection dates and collectors
  • Location of original written notes
  • Location of insect or damage specimens
The HUSSI Files

The ALLWEST Archive

Listing of files and instructions for retrieval of the ALLWEST2 database.

Files with .TXT extensions are saved as ASCII files and may be read using any text or word processor.


Files in the self-extracting zip archive

README.TXT : This text.

TITLPAGE.TXT : Title page.

HUSINTRO.TXT : Background information on the Hopkins U.S. System and the Hopkins U.S. System Index (HUSSI).

HUSSTAT.TXT : Description of HUSSI files at each repository.

HUSREPOS.TXT : List of repositories (as of 1986) for Hopkins U.S. System records described in HUSSI.

HUSDTDIC.TXT : Data dictionary for HUSSI records.

DBDESAW2.TXT : Description of ALLWEST2 database.

ALLWEST2.DBF : HUSSI records from all western USDA Forest Service repositories (as of 1986), except PSWNB records from notebooks at the Pacific Southwest Experiment Station, Berkeley, CA. PSWNB records are in a seperate archive. Files have been compressed using PKZIP software, but PKZIP is not needed to retrieve and decompress the file.

 

Creating the ALLWEST directory and installing the HUSSI files in it

Download the self-extracting zip archive to your computer. Make sure you remember the location of the directory where the archive is placed when it is downloaded.

From the DOS prompt, or from the RUN dialog box in Windows (under the FILE menu in Windows 3.x, and the START button in Windows 95) type the following:

[path]ALLWEST2 -d C:\ALLWEST

Here [path] is the full path of the drive and directory into which the ALLWEST2.EXE file was downloaded. Example:

D:\XFER\ALLWEST2 -d C:\ALLWEST

D:\XFER\ is the path where the ALLWEST2.EXE file was created when you downloaded it. The self-extractor will create a directory C:\ALLWEST and place the contents of the ALLWEST2.EXE into that directory. The extracted database in ALLWEST2.EXE will occupy about 12 MB. The ALLWEST2 file is dBase-compatible and can be imported or read directly into programs such as PC-File, ACCESS, FoxBase, RBase, PARADOX1, and other "X"Base-type programs within which specific queries and reports may be generated.


Download the ALLWEST archive now...


1Mention of tradename or software program does not constitute endorsement of that product by the U.S. Department of Agriculture.

What data are in HUSSI?

DATA DICTIONARY FOR HOPKINS U.S. SYSTEM INDEX RECORDS

Description: The following describes the data entered in each field of Hopkins U.S. System Index (HUSSI) records.

  1. HOPK_US_NO. The Hopkins number as assigned in the original record. Generally: letters in uppercase; no hyphen between the 5-digit number and the letter, except before the letter "O" to distinguish it from zero. Examples: 35682; 53821L; 43280-O; 23546A-3; 23546A-3a; 43280-O-1b.
  2. NAME. The scientific name, at least genus, of the insect as provided by the person making the identification. Abbreviations only if the name is too long for the space available; genus name not abbreviated. No entry for "near" or "possible" species. Examples: Choristoneura fumiferana; Leperisinus sp. (not Leperisinus nr. criddlei); Ips sp. (not Ips); Dendroctonus pseudotsugae (for Dendroctonus prob. pseudotsugae (considering host, locality, etc.)).
  3. ORDER. The order name as given by the person making the identification or from a reliable reference.
  4. FAMILY. The family name as given by the person making the identification or from a reliable reference.
  5. IDENT_BY. The name of the person making the identification if given in the identification report and as given. No space between first and second initials. More than one name can be entered, if space available, using "/" to separate. Examples: P.M. Marsh; Miller; R.W. Hodges/G.Lewis.
  6. PLANT_HOST. The name of the plant host of the identified phytophagous species or, in the case of parasites and predators, of the phytophagous host or prey of the identified parasite or predator. The first letter capitalized. Scientific names used if known. Examples: Pinus ponderosa; Bitterbrush; Maple; Oak.
  7. ENTO_HOST. The name of the insect host or prey of the identified parasite or predator. Scientific names used if known. If the host or prey relationship not a definitive one, see the "Insect associate" field. For example, when parasites emerge from general collections containing more than one phytophagous species, the host of the parasites is not known with certainty. If the identified insect is known to be a parasite or predator but the insect host or prey is not known, the entry in this field should be "Unknown" rather than a blank. Examples: Archips cerasivorana; Unknown Lepidoptera.
  8. ENTO_ASSOC. The name of the "primary" insect if a host or prey relationship is not clear, or if an association clearly exists. For example, species known to be parasitic on a given defoliator can often be taken by sweeping the understory in the infested area; the name of the defoliator present would be entered in this field. Also, species of Ips are often associated with Dendroctonus; the species of Dendroctonus would go in this field.
  9. LOCALITY. The name of the jurisdiction in which the identified species was taken; by entomological convention, usually the nearest post office. National Forests (N.F.) and National Parks (N.P.) can be used as jurisdictions. Do not use "Turtle Mountains", "Green Mountains," etc. as localities. Examples: Custer N.F.; Yellowstone N.P.; Stoneville.
  10. STATE. The two-letter abbreviations (see GPO Style Manual) for States and Provinces.
  11. COLLECTOR. The name(s) of the collector(s). No space between first and second initials. More than one name can be entered, if space available, using "/" to separate. Examples: F.W. Honing; Donn B. Cahill; M.E.McKnight/A.D.Tagestad.
  12. DATE. The date of collection as year-month-day (YYMMDD). Zeros entered for missing information. Examples: May 8, 1985 as 850508; 11-VIII-47 as 470811; June 1956 as 560600; Summer 1923 as 230000.
  13. NOTES. Codes or abbreviations to indicate if there is additional significant information on the collection. The most frequest entry is "L" for locality; many records show Section, Township, and Range, or geographic descriptors such as Red Creek drainage or Green Mountains, or additional jurisdiction information as Animas District, or more specific collection location such as "4 miles west of Halsey." Other entries might be "B" for biology or life history information including hatch, pupation, or eclosion dates; "R" if detailed rearing notes were taken; "Des" if there is a description of the specimens; "T" or "Trap" if a light, Malaise, pitfall, or pheromone trap was used. This is the field in which to enter "In flight," "Soil," "Duff," or other collection notes if significant.
  14. REPOSIT. The Repository Code (see HUSREPOS.TXT) indicates the location where the Hopkins U.S. System records resided when they were microfilmed in 1986. The records and the specimens with which they were associated may have been moved to another location.
  15. COUNTY. The name of the county from which the collection was made. This will be especially helpful if there is not more specific locality information. Examples: Thomas Co.; Bottineau Co.; Calhoun Co.
  16. COUNTRY. The name of the country, other than the United States, from which the collection was made. Examples: Canada; Canal Zone; Mexico.

For More Information, Contact:

Torolf R. Torgersen

USDA Forest Service, Pacific Northwest Research Station

Forestry and Range Sciences Laboratory

1401 Gekeler Lane

La Grande, OR 97850

Tel: (541) 962-6533


Melvin E. McKnight

USDA Forest Service (Retired)

Rural Route 1, Box 3045

Plainfield, VT 05667

US Forest Service - Pacific Northwest Research Station, Blue Mountains National Resources Institute
Last Modified: Monday, 16 December 2013 at 14:18:42 CST


USDA logo which links to the department's national site. Forest Service logo which links to the agency's national site.