FWGNA database fields
*Required fields are marked with an asterisk
Explanatory notes follow

1. HUC
2. Ref_Site_No
3. Date*
4. County*
5. Project
6. Waterway
7. Commonloc
8. Road_No
9. River_Basin
10. State*
11. Latitude*
12. Longitude*
13. Collectors
14. Site_Comments
15. Sci_Name

An example excel spreadsheet in the format above can be downloaded from the FWGNA website.


(1) The US Geological Survey has divided all regional water resources into hydrological units, and given each a code number, or "HUC."  Enter 8-digit HUC in field #1 if available.

(2) Collector's original site number or code, if applicable.  Also useful for museum catalogue numbers.

(3) mm/dd/yyyy

(4) Do not include the descriptor "County" or "Co."  If (for example) a collection was taken from Godforsaken County, Nevada, simply enter "Godforsaken" in this field.  If the collection was made on the border of two counties, separate by a slash.  Equivalent terms, such as "parish" in Louisiana, may be substituted.

(5) Local project name or funding source (if any).

(6) The name of the lake or stream, if available.  Standard abbreviations such as "L. Huron," or "St. Lawrence R." or "Stinking Ck." are acceptable.  If the water body is unnamed, leave this field blank.

(7) Express the locality data as precisely as possible in conventional terms.  No need to be redundant with other fields.  For example, suppose a fresh sample came from "Stinking Creek at State Route 34 bridge, 2 km W of Dumpton, Godforsaken County, Nevada."  Then for field (7), simply enter "2 km W of Dumpton."

(8) The route number of the road at the bridge or access where the collection was made.  Prefix with US, state, or county abbreviation, if appropriate.  For the example above, the entry would simply be, "NV 34."

(9) For tributaries, give the name of a larger stream here.

(10) Use standard two-letter abbreviations.  If on the border of two states, separate by a slash.  Equivalent terms, such as "province" in Canada, may be substituted.

(11) & (12) - Use decimal degrees.  All FWGNA records must be plottable.  Very few lots as curated in the museums today are associated with map coordinates, but if the locality data (as expressed in conventional terms) are sufficiently precise, such data should be obtainable from USGS maps, or online resources such as Topozone or Google Earth.  There's a very helpful shareware program called "GEOLocate" available from Tulane University.  Coordinates for collections freshly made for the FWGNA project may be obtained by GPS.

(13) Record collector(s) name in ordinary (first, last) order.  Initials are OK for given names, but please specify full family name of the collector(s).

(14) Free field.  Enter anything you'd like to observe about the habitat here, or about the population of snails being recorded, the collection methods used, and so forth.

(15) Genus-space-species.  Do not include subgenus or authority.  Subspecies may be specfied as Genus-space-species-space-subspecies.