About this Dataset

Continuing Inventory Of The Aquatic Oligochaeta (Annelida, Clitellata) Of The Great Smoky Mountains National Park

Through 2008, 30 species of aquatic oligochaetes representing at least 4 families and 15 genera have been documented from aquatic habitats in the park, all representing new park records. In addition, five of these species represent new state records for Tennessee, and two represent new state records for North Carolina. See web site
Organization: Department of the Interior
Last updated: 2025-09-14T21:26:39.094146
Tags: annelida, annelids, aphn, appalachian-highlands-network, aquatic-oligochaeta, clitellata, ecological-framework-water-water-quality-aquatic-macroinvertebrates-and-algae, great-smoky-mountains-national-park, ser, southeast-region, studyid-grsm-00057

Tables

Oligochaetes1

@usgov.doi_gov_continuing_inventory_of_the_aquatic_oligochaet_b7f4b730.oligochaetes1

72.66 kB
20 rows
23 columns

CREATE TABLE oligochaetes1 (
  "n_2002_01_gsmnp2002_01_usa_tennessee_blount_4709_white_5546e774" VARCHAR  -- 2002-01,"GSMNP2002-01","USA","Tennessee","Blount ","4709","Whiteoak Flats Branch, ","3.5 Mi (5.6 Km) SE Townsend, Just Upstream (south Side Of) TN Rt 73 / Little River Gorge Road (mile 36.3),
  "n__in_great_smoky_mountains_national_park_little_river_eac4038d" VARCHAR  -- In Great Smoky Mountains National Park. ","Little River, Tennessee River, Ohio River, Mississippi River.","N/A","35.6595° North, ","083.7017° West. ","","","","","17","0255422","3949349","1,150’.","Wear Cove, TENN. (7.5’ Series, 1953 Edition, Photorevised 1974,
  "n__nad_1927_24_c_17_62_c_clear" VARCHAR  -- NAD 1927) ","","24°C","17.62°C","clear,
  "n__3_15_ftu_8_16_85_5_5_96_0_01_272_0_0_00_0_15_ms_78__f8895452" VARCHAR  -- 3.15 FTU","8.16","85.5","5.96","0.01","272.0","0.00","--","","0.15 MS","78,500.","","","","1m (2-7m In Pools)","1-10cm,
  "n_10_32cm_pool_mostly_boulder_cascade" VARCHAR  -- 10-32cm Pool","","","mostly Boulder Cascade,
  "n__most_boulders_covered_with_moss_cobble_and_course_s_71e6bd18" VARCHAR  -- Most Boulders Covered With Moss. Cobble And Course Sand In Plunge Pools. ","moss.,
  "n__roots_gsmnp2002_01_aquatic_annelida_other_macroinvertebrates" VARCHAR  -- Roots!","GSMNP2002-01","aquatic Annelida, Other Macroinvertebrates,
  "n__sticks_twigs_for_fungal_analysis_d_ring_dip_net" VARCHAR  -- Sticks / Twigs For Fungal Analysis. ","D-ring Dip Net,
  "n__leaf_and_detritus_material_elutriated_by_hand_in_bu_c82d6395" VARCHAR  -- Leaf And Detritus Material Elutriated By Hand In Bucket Of Water, Then Strained Through Small, Fine Meshed Aquarium Net,
  "n__hand_picking_of_substrates_lat_long_coordinates_wer_064c57e6" VARCHAR  -- Hand Picking Of Substrates. Lat./Long. Coordinates Were Taken In Field Using Garman ETrex Vista GPS Unit,
  "n__coordinates_lat_long" VARCHAR  -- Coordinates [Lat., Long.,
  "n__utm_noted_on_this_sheet_then_corrected_using_topozone_com" VARCHAR  -- UTM] Noted On This Sheet Then Corrected Using TopoZone.com,
  "n__errors_noted_below_denuded_sticks_twigs_collected_f_d7ca21a1" VARCHAR  -- Errors Noted Below. Denuded Sticks / Twigs Collected For Fungal Analysis By Dr. Carol Shearer (aquatic Mycologist, UIUC Dept. Botany),
  "n__twigs_drip_dried_then_stored_in_ziplock_bags_on_ice_3635beb1" VARCHAR  -- Twigs ‘drip-dried’, Then Stored In Ziplock Bags On Ice For Return To Lab. ","Field Relaxation In 15% Ethanol (15+ Minutes), Then Fixation In Buffered Formalin,
  "n__some_insects_crayfishes_if_present_preserved_in_70__ae3b7419" VARCHAR  -- Some Insects, Crayfishes (if Present) Preserved In 70-85% Ethanol. After Return To Lab, Samples Rinsed With Tap Water, Drained Of Excess Water, Then Preserved In >70% Ethanol Prior To, After Sorting. ","","none Taken This Trip,
  "n__all_photos_taken_by_atbi_photographer_r_p_shiflett__2a9bcb69" VARCHAR  -- All Photos Taken By ATBI Photographer R.P. Shiflett","19 April 2002","19","April","2002","15:30","M.J. Wetzel (#2002-01), INHS,
  "n__rebecca_p_shiflett_atbi_photographer_creek_crosses__361b3c40" VARCHAR  -- Rebecca P. Shiflett (ATBI Photographer). ","Creek Crosses Under Road Through Single Port Cement Box Culvert, With Stone Face,
  "n__stream_exits_n_side_of_culvert_directly_into_little_58615c1e" VARCHAR  -- Stream Exits N Side Of Culvert Directly Into Little River. Some Collecting Methodologies Demonstrated In Little River, Just Downstream Of Confluence With This Creek.....for ATBI Photographer,
  "n__all_inverts_from_that_collecting_were_released_aliv_e0e661bf" VARCHAR  -- All Inverts From That Collecting...were Released Alive. TopoZone.com Map Location URL: Http://www.topozone.com/map.asp?z=17&n=3949349&e=255422&s=25","","","4/29/2002","29Apr2002","1530","000000","1530","O","x","x","","","","","","","","","","","USA: Tennessee: Blount Co.: Whiteoak Flats Branch, 3.5 Mi (5.6 Km) SE Townsend, Just Upstream (south Side Of) TN Rt 73 / Little River Gorge Road (mile 36.3),
  "n__in_great_smoky_mountains_national_park_35_6595_nort_76a1a97f" VARCHAR  -- In Great Smoky Mountains National Park. 35.6595° North, 083.7017° West. N/A Principal Meridian: Universal Transverse Mercator System: Zone 17, 0255422m East, 3949349m North. (NAD:1927), Wear Cove, TENN. (7.5’ Series, 1953 Edition, Photorevised 1974,
  "n__nad_1927_19_april_2002_gsmnp2002_01_mjw_2002_01_m_j_b6742547" VARCHAR  -- NAD 1927) . 19 April 2002. GSMNP2002-01. MJW#2002-01. M.J. Wetzel (#2002-01), INHS,
  "n__rebecca_p_shiflett_atbi_photographer_1927_9_11_2003_85244dcb" VARCHAR  -- Rebecca P. Shiflett (ATBI Photographer). ","1927","9/11/2003","9/11/2003","","","VIAL LABELS: USA: TN: Blount Co.: Whiteoak Flats Branch, 5.6 Km SE Townsend, Upstrm (S Side Of) TN Rt 73 / Little River Gorge Rd (mile 36.3),
  "n__in_great_smoky_mtns_nat_l_park_elev_1_150_utm_z_17__1454156d" VARCHAR  -- In Great Smoky Mtns Nat’l Park. Elev:1,150’. UTM: Z. 17 (NAD 1927), 0255422m E, 3949349m N. Lat: 35.6595°N, Lng: 083.7017°W. M.J. Wetzel (#2002-01), INHS, R.P. Shiflett (ATBI Photographer). 19 APR 2002. GSMNP2002-01. ","","",""
);