search

ArctosDB / arctos

Arctos is a museum collections management system
https://arctos.database.museum
60 stars 13 forks source link

can we magic drainage out of locality remarks? #2136

Closed dustymc closed 3 years ago

dustymc commented 5 years ago

ref:https://github.com/ArctosDB/arctos/issues/2133#issuecomment-506813320


UAM@ARCTOS>  select locality_remarks, count(*) from locality,geog_auth_rec where locality.geog_auth_rec_id=geog_auth_rec.geog_auth_rec_id and drainage is null and lower(locality_remarks) like '%drainage%' group by locality_remarks order by locality_remarks;

LOCALITY_REMARKS
------------------------------------------------------------------------------------------------------------------------
  COUNT(*)
----------
"Double Tanks Corral" is an unofficial place name used internally at IMRS; this structure lies halfway between Pirtle an
d Road Tanks on the east side of IMRS, Green River/Rio Grande Drainage, IMRS/Double Tanks Corral
     1

(see Gen. Loc.), Rio Grande drainage
     1

; LATDEGREES: 58; LATMINUTES: 35; NORS: N; LONDEGREES: 161; LONMINUTES: 45; WORE: W; SITEDESCRIPTION: Along small draina
ge stream on Zostera flats.
     1

Alexander-Kellogg camp was "a short distance east of the divide [between the Warm Springs drainage, which flows to the e
ast into Death Valley, and the Butte Valley drainage that flows west into Anvile Springs Canyon] (Kellogg, 24 Feb 1936,
p.231; or Alexander, 24 Feb 1936, p. 563 "made camp about 2 1.2 mil north of the Butte") - here they set gopher traps "o
n the slope north of our camp about 1/4 mile away" (Kellogg, 25 Feb 1936, p. 231) - approximate coordinates would be 35.
979982, -117.034235, elevation 4240 ft [datum WGS84] - site is marked on map bound in Alexander's Feb 8 to March 5 1936
field notebook. Reviewed by Jim Patton 1/26/16.
     1

Apache Creek drainage
     9

Arkansas River Drainage
     1

Arriaga, Rio Grijalva Drainage, Ocozocoautla
     1

Assume by air and in Crystal Creek drainage.
     1

Big Creek drainage
    17

Borell's field notes are not in the MVZ, but specimen most likely collected along the road that follows the Amargosa Riv
er drainage into Death Valley, rather than directly north of Saratoga Springs where the current coordinates place the lo
cality.
     1

Bruton's/Big Cypress Creek/Red River Drainage, Daingerfield State Park
     1

Chama/El Rito drainage
     1

Cienega, along intermittent drainage
     1

Colorado River Drainage, Midland/Sewage Disposal Ponds
     1

Cuevas Creek approaches El Indio at the northeastern edge of town, and then passes on the east side of the town (see Geo
reference Comments by Lieb).  Collection may have been made at the large drainage canal on the west edge of town(?).
     1

Current coordinates place collecting spot in an east-slope drainage leading down to Phinney Canyon, but Johnson (p. 36 o
f his 1940 notes) that he went over "the main divide of the Grapevine Range and down about 1/4 mile on the west side." H
ere he collected a skink (#4121), a Bewick's wren (#4122), and two mountain quail  (#4123-4124). Better coordinates at t
he 7000 ft contour in the west-slope drainage just over the ridge from their campsite would be 36.95328, -117.12703. Rev
iewed by Jim Patton 1/26/16.
     1

Devil's River/Pecos/Rio grandeDrainage, Eldorado
     1

El Carrizo Drainage, Guaymas, The offset is actually at a general SE heading rather than E from Guaymas,
     1

El Rito Creek drainage, Estimated specimen age range: Maximum date 1540, Minimum date 1300
     1

Fish Hatchery Drainage
     1

Fish Hatchery Drainage, Hatchery
    26

Fish Hatchery Drainage, US Fish and Wildlife Service
     2

Fivemile/Salt Draw/Toyah Creek/Pecos DrgDrainage, Hwy 10/Jeff Davis County Line
     1

Flows to Dome Creek, Fortymile River drainage
     1

Franklin Mts. drainage
     9

From GoogleEarth - "Paradise Riege" at "Beach Rance Airport" on Buford Creek drainage; VERBATIMELEVATION: 3640; GEOREFER
ENCEVERIFICATIONSTATUS: requires verification
     1

Galvan Creek/Atascosa Drainage, Leming
     1

Guadalupe River Drainage
     1

Internal drainage
     4

Internal drainage, SEC 36 E EDGE SE 1/4 R8W T25S
     1

Internal drainage, ca. 3,880 ft.
     1

Internal or Rio Grande? drainage
     1

Internal: Carson sink drainage
     1

Kanawha River Drainage
     1

Lago De Patzcuaro Drainage, Quiroga
     1

LatLong recorded for the geographic center of the section of the Green River within Daggett Co. Extent measured from cen
ter point to edge of drainage within Daggett Co..; VERBATIMCOORDINATESYSTEM: decimal degrees; GEOREFERENCEDBY: A. Baugh
(UMNH); GEOREFERENCEDDATE: 9 Jul 2002; GEOREFERENCESOURCES: USGS 1:24,000; GEOREFERENCEVERIFICATIONSTATUS: requires veri
fication
     1

Little Hatchet mountain range, internal drainage, 32 center R16W T27S
     1

Little Kanawha River Drainage
     9

Little Snake River drainage
     1

Loose talus rubble exposed above east fork of major drainage on Squaw Mtn. Elevation approx 3,700. Talus composed of lig
ht-grey limeston derived from Ogilvie Formation.
     1

Lower Atchafalaya River DDrainage, Jeanerette/Bayou Teche
     1

Mad Island Slough Drainage, Ap Ranch/Palacios
     1

Mimbres Mountains drainage
     1

Monongahela River Drainage
     2

New Area, Dry Cave, Pecos River drainage, SEC 22  R24E T22 Strat: Surface.
     1

No road named. Should Be Luna County. Luna County Split From Dona Ana County In 1901, may have been collected prior, Clo
sed Basin Drainage, Columbus
     1

Notes Say "Canelas (Prob.)", Quebrada De Topia/Rio Tam Drainage, Canelas
     1

Notes also say Jalisco, Rio Cihuatlan Drainage, Cihuatl�n
     1

Nueces River Drainage
     1

Ohio River Drainage
     8

Original collection data placed the locality In stafford county (The offset distance at any heading falls short of this
county by a minumum of 4.5 miles), Arkansas River Drainage, Sterling
     1

Palacio Drainage, Bermejillo
     1

Pascagoula river drainage
     2

Patuxent River Drainage, Largo
     1

Pearl River Drainage, Philadelphia
     1

Pecos River Drainage
     6

Pecos River Drainage. Badly vandalized limestone cave.  Material from surface and probably not Pleistocene. BLM in lette
r dated 4 Dec 1970 gives location as SE 1/4, SW 1/4 Sec. 23, T22S, R24E. NM: EDDY CO.: MCKITTRICK CAVE.  ELEV. CA 1270 [
CK] 32°22'25"N, 104°28'55"W; SEfl SEC 22, T22S, R24E [CK].  PLEISTOCENE/HOLOCENE.
     1

Pecos River Drainage. DRY CAVE.  CORRIDORS AND SMALL ROOMS OFF THE SOUTH END OF THE EXPRESSWAY AND FARTHER WITHIN THE CA
VE THAN BOULDER ROOM AND BISON CHAMBER.  LITTLE FILL; FOSSIL MATERIAL ON SURFACE AND IMMEDIATELY BENEATH.  POSSIBLY HOLO
CENE AS WELL AS PLEISTOCENE ON SURFACE. Carnaro Peak Topographic Quad,  Lat. 32 degrees 22.34 Minutes North, Long. 104 d
egrees, 28.89 minutes West.  UTM 548.770 East, 3581.640 North, NAD 27. T.22S., R.24E., Section 22.  Elevation 4200. Wisc
onsinan Pleistocene.
     1

Pecos River Drainage. DRY CAVE.  THIS IS AN INTERMEDIATE LEVEL, OPENING FROM THE SIDE OF LOST VALLEY SINK AND CONNECTING
 DOWNSLOPE TO UTEP 5. Carnaro Peak Topographic Quad,  Lat. 32 degrees 22.34 Minutes North, Long. 104 degrees, 28.89 minu
tes West.  UTM 548.770 East, 3581.640 North, NAD 27. T.22S., R.24E., Section 22.  Elevation 4200. Wisconsinan Pleistocen
e.
     1

Pecos River Drainage. Deposits on floor of balcony room.  Sources are bison sink (via utep 54), the modern entrance, and
 possibly animal fair (utep 22). Also SW1/4 SW1/4 Sec 23, according to BLM.
     1

Pecos River Drainage. Dry Cave.  Deposits at base of Bison Sink, below Boulder Room.  Test trench II (TT II, UTEP 54), o
n south side of Balcony above Balcony Room originally was included, but later split off. Carnaro Peak Topographic Quad,
 Lat. 32 degrees 22.34 Minutes North, Long. 104 degrees, 28.89 minutes West.  UTM 548.770 East, 3581.640 North, NAD 27.
T.22S., R.24E., Section 22.  Elevation 4200. Wisconsinan Pleistocene. Minimum date = 11,000.  Maximum date = 14,000.
     1

Pecos River Drainage. Dry cave.  Enlargement in small limestone corridor; lead in one direction carries to balcony of Ba
lcony Room; in other direction, too small to follow, but apparently the source of the fossil material and probably leads
 to foot of deposits from Bison Sink in vicinity of UTEP 4. Carnaro Peak Topographic Quad,  Lat. 32 degrees 22.34 Minute
s North, Long. 104 degrees, 28.89 minutes West.  UTM 548.770 East, 3581.640 North, NAD 27. T.22S., R.24E., Section 22.
Elevation 4200. Wisconsinan Pleistocene. Minimum date = 14470.
     1

Pecos River Drainage. Dry cave.  Fossils from fill surrounding the sink known as Lost Valley and, with merging of utep 1
7, Lost Valley itself.  Originally limited to the upper level, including the funnel portion of the sink.  A large fissur
e in the ceiling clogged with boulders is the obvious source.  Fossils in the upper level occur from the surface to at l
east 20 cm and probably much deeper.
     1

Pecos River Drainage. Dry cave.  Lowest known level east and south of the north-south fissure (back of cave).  Tracing u
pslope, reach Balcony on Lost Valley (UTEP 2). Carnaro Peak Topographic Quad,  Lat. 32 degrees 22.34 Minutes North, Long
. 104 degrees, 28.89 minutes West.  UTM 548.770 East, 3581.640 North, NAD 27. T.22S., R.24E., Section 22.  Elevation 420
0. Wisconsinan Pleistocene. Minimum Date = 25160.
     1

Pecos River Drainage. Dry cave.  South Chimney at survey marker F11.  Crevice leading both up and down from locality.  T
op now blocked by breakdown, bottom leads to extreme edge of UTEP 5. Carnaro Peak Topographic Quad,  Lat. 32 degrees 22.
34 Minutes North, Long. 104 degrees, 28.89 minutes West.  UTM 548.770 East, 3581.640 North, NAD 27. T.22S., R.24E., Sect
ion 22.  Elevation 4200. Wisconsinan Pleistocene.
     1

Pecos River drainage
     5

Pecos River drainage (presumably), R36E T8N
     1

Pecos River drainage (presumably), cave deposit
     1

Pecos River drainage, 22 NW1/4 SW1/4 SE1/4 R24E T24S
     1

Pecos River drainage, 24 NW1/4 SW1/4 R25E T23S, Specimen Age Estimate - minimum date: 10730
     1

Pecos River drainage, SEC 22  R24E T22S
     8

Pecos River drainage, SEC 22 R24E T22S
     5

Pecos River drainage, SEC 22 R24E T22S, Estimated Age: Minimum date 29,290
     1

Pecos River drainage, SEC 22 W1/2 SE1/4, NE1/4 SE1/4 R24E T22S
     1

Pecos River drainage?
     1

Pecos drainage
    10

Pecos/Rio Grande Drainage, McMillan Lake
     1

Prob. Closed Basin Drainage, Gonzales Ortega
     1

Prob. Rio AcaponetaDrainage, Acaponeta
     1

Prob. Rio Atoyac/Mexcala Drainage, Iz�car De Matmoros
     1

Prob. Rio Pichuca Ico/TeaDrainage, Pichucalco
     1

Prob. Rio Tuxpan/Coahuaya Drainage, Cd. Colima
     1

Puskus Creek/Tallahatchie River Drainage, Minnows, Inc., T7S, R2W, Secs.34 & 35, T8S, R2W, Sec.3, Acquired by UM In 1995
, The area is now The Univ. Mississippi Biol. Research Center For Water And Wetland Resources
     1

Quihi/Hondo Creek/Frio/NuDrainage, Hwy 2676/Elm Creek Crossing
     1

Rio AcaponetaageDrainage, San Miguel
     1

Rio Aguanaval Drainage, Fresnillo/Ba�os Santa Cruz
     1

Rio Ameca Drainage, Ameca
     1

Rio Arenal/Rio Grijalva Drainage, Ocozocoautla
     2

Rio Bavispe/Yaqui Drainage, Mesa Tres Rios/Ranch Tres Rios
     1

Rio Bavispe/Yaqui Drainage, Mesa Tres Rios/Rancho Tres Rios
     1

Rio Bejuco/Santa CatarinaDrainage, Putla
     1

Rio Blanco/Rio Grijalva Drainage, Ixtapa
     1

Rio Casas Grandes Drainage, Nuevo Casas Grandes/Rio Casas Grandes
     1

Rio Chacala Drainage, Cihuatlan
     1

Rio Cihuatlan Drainage, Barra De Navidad
     1

Rio Colotlan/Bolanos/Gran Drainage, Momax
     1

Rio Colotlan/Bolanos/GranDrainage, Tlaltenango
     1

Rio Del Presidio Drainage, Concordia
     1

Rio Del Presidio Drainage, Villa Union/Rio Del Presidio
     1

Rio Gramde drainage
     1

Rio Grande (presumably) drainage
     1

Rio Grande Drainage
     7

Rio Grande Drainage, Esperanza Cutoff
     1

Rio Grande Drainage, Fabens/Two Brothers Farm/Border Spur Drain No. 1
     1

Rio Grande Drainage, From a spring that formerly entered into a stock pond (ALM field notes)
     1

Rio Grande Drainage, Moon Rd/Jct North Loop
     1

Rio Grande Drainage, Socorro/Rio Grande
     1

Rio Grande Drainage, Tornillo
     1

Rio Grande drainage
       163

Rio Grande drainage T28S, R2E
     1

Rio Grande drainage,  SEC 3 NE 1/4 NW 1/4
     1

Rio Grande drainage, R3E T29S
     1

Rio Grande drainage, R3E+ T27S
     1

Rio Grande drainage, SE1/4 NW1/4 SEC 18, T28S, R3E
     1

Rio Grande drainage, SEC 10 SE 1/4 NE 1/4 SE 1/4 R1E T22S
     1

Rio Grande drainage, SEC 19 NW 1/4 R8W T13S
     1

Rio Grande drainage, SEC 19 SW 1/4 NW 1/4 R3/4W T19S
     1

Rio Grande drainage, SEC 31 N 1/2 R1E T8N, Specimen Age Estimate - maximum date: 17240
     1

Rio Grande drainage, SEC 33 NW 1/4 NW 1/4 R4W T13S
     1

Rio Grande drainage, SEC 35 SW 1/4 SE 1/4 R4E T26S
     1

Rio Grande drainage, SEC 8 SE 1/4 SE 1/4 R6E T16N
     1

Rio Grande drainage, SEC 9 NE 1/4 NW 1/4 R2W T26S
     1

Rio Grande drainage, SW 1/4 NE 1/4 Sec 26  R3E T24S
     1

Rio Grande drainage, Sec 31 N 1/2 R1E T8N
     1

Rio Grande drainage, T28S, R2E, SW 1/4 SEC 19
     1

Rio Grande drainage, above high water level
     1

Rio Grande drainage, residence
     1

Rio Grande drainage.
     1

Rio Grande drainage; Cerro De Muleros (Cristo Rey) mountain range
     1

Rio Grande drainage; Franklin mountain range
     1

Rio Grande drainage; Indio mountain range
     2

Rio Grande drainage; Organ mountain range
     1

Rio Huicicila Drainage, Compostela
     2

Rio Juchilipa/Grande De S Drainage, Jalpa
     1

Rio Juchilipa/Grande De S Drainage, Zapoqui
     1

Rio Mezquital Drainage, Mezquital
     1

Rio Mezquital/Rio San Ped Drainage, Durango
     1

Rio Mezquital/Rio San Ped Drainage, Rio Chico
     1

Rio Nazas Drainage, Cuencame
     1

Rio Nazas Drainage, Cuencam�/Pueblo De Santiago
     1

Rio Nazas Drainage, Palmito
     1

Rio Purificacion Drainage, La Huerta
     1

Rio San Juan/Rio Moctezum Drainage, Cadereyta
     1

Rio San Lorenzo Drainage, San Lorenzo/Rio San Lorenzo
     1

Rio Sinaloa Drainage, Guasave/Rio Sinaloa
     1

Rio Tuxpan/Coahuayana Drainage, Atenquique
     1

Rio Valparaiso/Bolanos/Gr Drainage, Valparaiso
     1

Rio Verde Grande De Belem Drainage, Tepatitl�n
     1

Rio Yaqui Drainage, Yepomera
     1

Robledo Mountains/Rio Grande drainage
     1

Route used by Webb in 1963 to access site off of Doniphan Drive is now fenced off as part of Foxworth Galbraith Lumber/A
nthony Truss Mfc. Company grounds (and bridge over east drain used by him is now demolished); access used by Lieb in 201
2 was via Rainbow Lakes Rd , then south along roads bordering east drain to the west bound canal ("penitentiary drain")
indicated by Webb (in field notes) as the trapping site, locality is inferred from Webb's field notes to be W of La Tuna
 Federal Prison, in penitentiary canal between the Anthony Drain And East Drain, Rio Grande Drainage, anthony
     1

Salt Fork/Arkansas River Drainage, Great Salt Plains State Park/Nw Refuge
     1

San Francisco Creek/Rio Grande Drainage, Marathon
     1

San Gabriel Mountains, very little of the Lytle Creek Drainage is in los angeles county
     1

San Juan River Drainage. Badlands. Same locality cited by Wilson 1951.
     1

San Juan River drainage
     1

San Juan River drainage, R4W T34N
     1

San Pedro River Drainage
     4

Selkirk Mountains, Columbia River Drainage
     1

Seventysix Draw Drainage, Columbus
     1

Station T34 or 395 for K.M. Sommerman specimens.  These station numbers are interchangeable and refer to the same locali
ty.  Artificial drainage ditch on right of road.  Pool fed by trickle under road.  SAH 02/01/2011
     1

Suspected to have been collected at drainage canal at Two Brothers Farm (see UTEP 16218)
     1

T16S, R17W, Sec.4, Colorado/Gila Drainage, Cliff/Hwy 180/Gila River Bridge
     1

T21S, R26E, Nw 1/4 Sw 1/4 Sec.26, Pecos/Rio Grande Drainage, Eddy Co.
     1

T21S, R26E, Sw 1/4 Sec.26, Pecos/Rio Grande Drainage, Eddy Co., Pecos Rv. Pool Of Pecos
     1

T21S, R26E, Sw 1/4 Sec.26, Pecos/Rio Grande Drainage, Eddy Co., Pecos Rv., Pool Of Pecos
     1

T22S, R253, Nw 1/4 Se 1/4 Se 1/4 Sec.29, Shoud Be Range 25E., Pecos/Rio Grande Drainage, T22S R25E S29 Nw1/4 Se1/4 Se1/4
     1

T22S, R25E, Nw 1/4 Sw 1/4 Sec.28, Pecos/Rio Grande Drainage, Eddy Co.
     1

T28S, R17W, Playas Valley (Closed Bas) Drainage, Playas Lake
     1

T2N, R25E, Centr. Sec.9, Alligator Creek/Nassau River Drainage, Musselwhite Rd/Jct Hwy 1-301
     1

That day Carr walked up "to summit at Lead Canyon directly East of Camp...collecting along route" (p. 161, 1912).  The 9
500 ft contour in the drainage was his likely route (there is no marked trail on topo maps). J.L.Patton 12 March 2010.
     2

Tularosa Creek drainage, SEC 32 NE 1/4 R10E T13S
     1

Used City of Newton's Areas Requiring Drainage 1892 Historic Map to verify Cabot Park area contained a swamp portion. Ge
oreferenced at the center of Cabot Park with uncertainty radius extending to city boundaries, by Teresa Dorado on 2018 D
ecember 19 [tdorado 2018 December 19].
     1

Used City of Newton's Areas Requiring Drainage 1892 Historic Map to verify Cabot Park area contained a swamp portion. Ge
oreferenced at the center of Cabot Park with uncertainty radius extending to city boundaries, by Teresa Dorado on 2018 D
ecember 21 [tdorado 2018 December 21].
     2

Webb field notes indicate this specimen was taken while setting turtle traps west of the Country Club in the drainage ca
nal that lies next to Montoya Drive (this is not Montoya Drain per se, but apparently a tributary of the NewMexas Drain-
- CSL)
     1

West Fork Monongahela River Drainage
     5

coordinates for center of ca. 9 mi. long drainage; VERBATIMCOORDINATESYSTEM: decimal degrees; GEOREFERENCEDBY: Eric Rick
art (UMNH); GEOREFERENCEDDATE: 27 Jun 2003; GEOREFERENCESOURCES: USGS 1:24,000; GEOREFERENCEVERIFICATIONSTATUS: requires
 verification
     2

locality is recorded as "on the Carribean drainage of the trans-Isthmus railway"
     1

or Columbia County, Ichetucknee River drainage
     1

179 rows selected.

Elapsed: 00:00:00.67
UAM@ARCTOS>
campmlc commented 5 years ago

Can you do the easy ones automagically and give a short list for manual interpretation? Or do these all require some human interpretation?

On Fri, Jun 28, 2019 at 11:45 AM dustymc notifications@github.com wrote:

ref:#2133 (comment) https://github.com/ArctosDB/arctos/issues/2133#issuecomment-506813320

UAM@ARCTOS> select locality_remarks, count(*) from locality,geog_auth_rec where locality.geog_auth_rec_id=geog_auth_rec.geog_auth_rec_id and drainage is null and lower(locality_remarks) like '%drainage%' group by locality_remarks order by locality_remarks;

LOCALITY_REMARKS

COUNT(*)

"Double Tanks Corral" is an unofficial place name used internally at IMRS; this structure lies halfway between Pirtle an

d Road Tanks on the east side of IMRS, Green River/Rio Grande Drainage, IMRS/Double Tanks Corral

1

(see Gen. Loc.), Rio Grande drainage

1

; LATDEGREES: 58; LATMINUTES: 35; NORS: N; LONDEGREES: 161; LONMINUTES: 45; WORE: W; SITEDESCRIPTION: Along small draina

ge stream on Zostera flats.

1

Alexander-Kellogg camp was "a short distance east of the divide [between the Warm Springs drainage, which flows to the e

ast into Death Valley, and the Butte Valley drainage that flows west into Anvile Springs Canyon] (Kellogg, 24 Feb 1936,

p.231; or Alexander, 24 Feb 1936, p. 563 "made camp about 2 1.2 mil north of the Butte") - here they set gopher traps "o

n the slope north of our camp about 1/4 mile away" (Kellogg, 25 Feb 1936, p. 231) - approximate coordinates would be 35.

979982, -117.034235, elevation 4240 ft [datum WGS84] - site is marked on map bound in Alexander's Feb 8 to March 5 1936

field notebook. Reviewed by Jim Patton 1/26/16.

1

Apache Creek drainage

9

Arkansas River Drainage

1

Arriaga, Rio Grijalva Drainage, Ocozocoautla

1

Assume by air and in Crystal Creek drainage.

1

Big Creek drainage

17

Borell's field notes are not in the MVZ, but specimen most likely collected along the road that follows the Amargosa Riv

er drainage into Death Valley, rather than directly north of Saratoga Springs where the current coordinates place the lo

cality.

1

Bruton's/Big Cypress Creek/Red River Drainage, Daingerfield State Park

1

Chama/El Rito drainage

1

Cienega, along intermittent drainage

1

Colorado River Drainage, Midland/Sewage Disposal Ponds

1

Cuevas Creek approaches El Indio at the northeastern edge of town, and then passes on the east side of the town (see Geo

reference Comments by Lieb). Collection may have been made at the large drainage canal on the west edge of town(?).

1

Current coordinates place collecting spot in an east-slope drainage leading down to Phinney Canyon, but Johnson (p. 36 o

f his 1940 notes) that he went over "the main divide of the Grapevine Range and down about 1/4 mile on the west side." H

ere he collected a skink (#4121), a Bewick's wren (#4122), and two mountain quail (#4123-4124). Better coordinates at t

he 7000 ft contour in the west-slope drainage just over the ridge from their campsite would be 36.95328, -117.12703. Rev

iewed by Jim Patton 1/26/16.

1

Devil's River/Pecos/Rio grandeDrainage, Eldorado

1

El Carrizo Drainage, Guaymas, The offset is actually at a general SE heading rather than E from Guaymas,

1

El Rito Creek drainage, Estimated specimen age range: Maximum date 1540, Minimum date 1300

1

Fish Hatchery Drainage

1

Fish Hatchery Drainage, Hatchery

26

Fish Hatchery Drainage, US Fish and Wildlife Service

2

Fivemile/Salt Draw/Toyah Creek/Pecos DrgDrainage, Hwy 10/Jeff Davis County Line

1

Flows to Dome Creek, Fortymile River drainage

1

Franklin Mts. drainage

9

From GoogleEarth - "Paradise Riege" at "Beach Rance Airport" on Buford Creek drainage; VERBATIMELEVATION: 3640; GEOREFER

ENCEVERIFICATIONSTATUS: requires verification

1

Galvan Creek/Atascosa Drainage, Leming

1

Guadalupe River Drainage

1

Internal drainage

4

Internal drainage, SEC 36 E EDGE SE 1/4 R8W T25S

1

Internal drainage, ca. 3,880 ft.

1

Internal or Rio Grande? drainage

1

Internal: Carson sink drainage

1

Kanawha River Drainage

1

Lago De Patzcuaro Drainage, Quiroga

1

LatLong recorded for the geographic center of the section of the Green River within Daggett Co. Extent measured from cen

ter point to edge of drainage within Daggett Co..; VERBATIMCOORDINATESYSTEM: decimal degrees; GEOREFERENCEDBY: A. Baugh

(UMNH); GEOREFERENCEDDATE: 9 Jul 2002; GEOREFERENCESOURCES: USGS 1:24,000; GEOREFERENCEVERIFICATIONSTATUS: requires veri

fication

1

Little Hatchet mountain range, internal drainage, 32 center R16W T27S

1

Little Kanawha River Drainage

9

Little Snake River drainage

1

Loose talus rubble exposed above east fork of major drainage on Squaw Mtn. Elevation approx 3,700. Talus composed of lig

ht-grey limeston derived from Ogilvie Formation.

1

Lower Atchafalaya River DDrainage, Jeanerette/Bayou Teche

1

Mad Island Slough Drainage, Ap Ranch/Palacios

1

Mimbres Mountains drainage

1

Monongahela River Drainage

2

New Area, Dry Cave, Pecos River drainage, SEC 22 R24E T22 Strat: Surface.

1

No road named. Should Be Luna County. Luna County Split From Dona Ana County In 1901, may have been collected prior, Clo

sed Basin Drainage, Columbus

1

Notes Say "Canelas (Prob.)", Quebrada De Topia/Rio Tam Drainage, Canelas

1

Notes also say Jalisco, Rio Cihuatlan Drainage, Cihuatl�n

1

Nueces River Drainage

1

Ohio River Drainage

8

Original collection data placed the locality In stafford county (The offset distance at any heading falls short of this

county by a minumum of 4.5 miles), Arkansas River Drainage, Sterling

1

Palacio Drainage, Bermejillo

1

Pascagoula river drainage

2

Patuxent River Drainage, Largo

1

Pearl River Drainage, Philadelphia

1

Pecos River Drainage

6

Pecos River Drainage. Badly vandalized limestone cave. Material from surface and probably not Pleistocene. BLM in lette

r dated 4 Dec 1970 gives location as SE 1/4, SW 1/4 Sec. 23, T22S, R24E. NM: EDDY CO.: MCKITTRICK CAVE. ELEV. CA 1270 [

CK] 32°22'25"N, 104°28'55"W; SEfl SEC 22, T22S, R24E [CK]. PLEISTOCENE/HOLOCENE.

1

Pecos River Drainage. DRY CAVE. CORRIDORS AND SMALL ROOMS OFF THE SOUTH END OF THE EXPRESSWAY AND FARTHER WITHIN THE CA

VE THAN BOULDER ROOM AND BISON CHAMBER. LITTLE FILL; FOSSIL MATERIAL ON SURFACE AND IMMEDIATELY BENEATH. POSSIBLY HOLO

CENE AS WELL AS PLEISTOCENE ON SURFACE. Carnaro Peak Topographic Quad, Lat. 32 degrees 22.34 Minutes North, Long. 104 d

egrees, 28.89 minutes West. UTM 548.770 East, 3581.640 North, NAD 27. T.22S., R.24E., Section 22. Elevation 4200. Wisc

onsinan Pleistocene.

1

Pecos River Drainage. DRY CAVE. THIS IS AN INTERMEDIATE LEVEL, OPENING FROM THE SIDE OF LOST VALLEY SINK AND CONNECTING

DOWNSLOPE TO UTEP 5. Carnaro Peak Topographic Quad, Lat. 32 degrees 22.34 Minutes North, Long. 104 degrees, 28.89 minu

tes West. UTM 548.770 East, 3581.640 North, NAD 27. T.22S., R.24E., Section 22. Elevation 4200. Wisconsinan Pleistocen

e.

1

Pecos River Drainage. Deposits on floor of balcony room. Sources are bison sink (via utep 54), the modern entrance, and

possibly animal fair (utep 22). Also SW1/4 SW1/4 Sec 23, according to BLM.

1

Pecos River Drainage. Dry Cave. Deposits at base of Bison Sink, below Boulder Room. Test trench II (TT II, UTEP 54), o

n south side of Balcony above Balcony Room originally was included, but later split off. Carnaro Peak Topographic Quad,

Lat. 32 degrees 22.34 Minutes North, Long. 104 degrees, 28.89 minutes West. UTM 548.770 East, 3581.640 North, NAD 27.

T.22S., R.24E., Section 22. Elevation 4200. Wisconsinan Pleistocene. Minimum date = 11,000. Maximum date = 14,000.

1

Pecos River Drainage. Dry cave. Enlargement in small limestone corridor; lead in one direction carries to balcony of Ba

lcony Room; in other direction, too small to follow, but apparently the source of the fossil material and probably leads

to foot of deposits from Bison Sink in vicinity of UTEP 4. Carnaro Peak Topographic Quad, Lat. 32 degrees 22.34 Minute

s North, Long. 104 degrees, 28.89 minutes West. UTM 548.770 East, 3581.640 North, NAD 27. T.22S., R.24E., Section 22.

Elevation 4200. Wisconsinan Pleistocene. Minimum date = 14470.

1

Pecos River Drainage. Dry cave. Fossils from fill surrounding the sink known as Lost Valley and, with merging of utep 1

7, Lost Valley itself. Originally limited to the upper level, including the funnel portion of the sink. A large fissur

e in the ceiling clogged with boulders is the obvious source. Fossils in the upper level occur from the surface to at l

east 20 cm and probably much deeper.

1

Pecos River Drainage. Dry cave. Lowest known level east and south of the north-south fissure (back of cave). Tracing u

pslope, reach Balcony on Lost Valley (UTEP 2). Carnaro Peak Topographic Quad, Lat. 32 degrees 22.34 Minutes North, Long

. 104 degrees, 28.89 minutes West. UTM 548.770 East, 3581.640 North, NAD 27. T.22S., R.24E., Section 22. Elevation 420

  1. Wisconsinan Pleistocene. Minimum Date = 25160.

    1

Pecos River Drainage. Dry cave. South Chimney at survey marker F11. Crevice leading both up and down from locality. T

op now blocked by breakdown, bottom leads to extreme edge of UTEP 5. Carnaro Peak Topographic Quad, Lat. 32 degrees 22.

34 Minutes North, Long. 104 degrees, 28.89 minutes West. UTM 548.770 East, 3581.640 North, NAD 27. T.22S., R.24E., Sect

ion 22. Elevation 4200. Wisconsinan Pleistocene.

1

Pecos River drainage

5

Pecos River drainage (presumably), R36E T8N

1

Pecos River drainage (presumably), cave deposit

1

Pecos River drainage, 22 NW1/4 SW1/4 SE1/4 R24E T24S

1

Pecos River drainage, 24 NW1/4 SW1/4 R25E T23S, Specimen Age Estimate - minimum date: 10730

1

Pecos River drainage, SEC 22 R24E T22S

8

Pecos River drainage, SEC 22 R24E T22S

5

Pecos River drainage, SEC 22 R24E T22S, Estimated Age: Minimum date 29,290

1

Pecos River drainage, SEC 22 W1/2 SE1/4, NE1/4 SE1/4 R24E T22S

1

Pecos River drainage?

1

Pecos drainage

10

Pecos/Rio Grande Drainage, McMillan Lake

1

Prob. Closed Basin Drainage, Gonzales Ortega

1

Prob. Rio AcaponetaDrainage, Acaponeta

1

Prob. Rio Atoyac/Mexcala Drainage, Iz�car De Matmoros

1

Prob. Rio Pichuca Ico/TeaDrainage, Pichucalco

1

Prob. Rio Tuxpan/Coahuaya Drainage, Cd. Colima

1

Puskus Creek/Tallahatchie River Drainage, Minnows, Inc., T7S, R2W, Secs.34 & 35, T8S, R2W, Sec.3, Acquired by UM In 1995

, The area is now The Univ. Mississippi Biol. Research Center For Water And Wetland Resources

1

Quihi/Hondo Creek/Frio/NuDrainage, Hwy 2676/Elm Creek Crossing

1

Rio AcaponetaageDrainage, San Miguel

1

Rio Aguanaval Drainage, Fresnillo/Ba�os Santa Cruz

1

Rio Ameca Drainage, Ameca

1

Rio Arenal/Rio Grijalva Drainage, Ocozocoautla

2

Rio Bavispe/Yaqui Drainage, Mesa Tres Rios/Ranch Tres Rios

1

Rio Bavispe/Yaqui Drainage, Mesa Tres Rios/Rancho Tres Rios

1

Rio Bejuco/Santa CatarinaDrainage, Putla

1

Rio Blanco/Rio Grijalva Drainage, Ixtapa

1

Rio Casas Grandes Drainage, Nuevo Casas Grandes/Rio Casas Grandes

1

Rio Chacala Drainage, Cihuatlan

1

Rio Cihuatlan Drainage, Barra De Navidad

1

Rio Colotlan/Bolanos/Gran Drainage, Momax

1

Rio Colotlan/Bolanos/GranDrainage, Tlaltenango

1

Rio Del Presidio Drainage, Concordia

1

Rio Del Presidio Drainage, Villa Union/Rio Del Presidio

1

Rio Gramde drainage

1

Rio Grande (presumably) drainage

1

Rio Grande Drainage

7

Rio Grande Drainage, Esperanza Cutoff

1

Rio Grande Drainage, Fabens/Two Brothers Farm/Border Spur Drain No. 1

1

Rio Grande Drainage, From a spring that formerly entered into a stock pond (ALM field notes)

1

Rio Grande Drainage, Moon Rd/Jct North Loop

1

Rio Grande Drainage, Socorro/Rio Grande

1

Rio Grande Drainage, Tornillo

1

Rio Grande drainage

   163

Rio Grande drainage T28S, R2E

1

Rio Grande drainage, SEC 3 NE 1/4 NW 1/4

1

Rio Grande drainage, R3E T29S

1

Rio Grande drainage, R3E+ T27S

1

Rio Grande drainage, SE1/4 NW1/4 SEC 18, T28S, R3E

1

Rio Grande drainage, SEC 10 SE 1/4 NE 1/4 SE 1/4 R1E T22S

1

Rio Grande drainage, SEC 19 NW 1/4 R8W T13S

1

Rio Grande drainage, SEC 19 SW 1/4 NW 1/4 R3/4W T19S

1

Rio Grande drainage, SEC 31 N 1/2 R1E T8N, Specimen Age Estimate - maximum date: 17240

1

Rio Grande drainage, SEC 33 NW 1/4 NW 1/4 R4W T13S

1

Rio Grande drainage, SEC 35 SW 1/4 SE 1/4 R4E T26S

1

Rio Grande drainage, SEC 8 SE 1/4 SE 1/4 R6E T16N

1

Rio Grande drainage, SEC 9 NE 1/4 NW 1/4 R2W T26S

1

Rio Grande drainage, SW 1/4 NE 1/4 Sec 26 R3E T24S

1

Rio Grande drainage, Sec 31 N 1/2 R1E T8N

1

Rio Grande drainage, T28S, R2E, SW 1/4 SEC 19

1

Rio Grande drainage, above high water level

1

Rio Grande drainage, residence

1

Rio Grande drainage.

1

Rio Grande drainage; Cerro De Muleros (Cristo Rey) mountain range

1

Rio Grande drainage; Franklin mountain range

1

Rio Grande drainage; Indio mountain range

2

Rio Grande drainage; Organ mountain range

1

Rio Huicicila Drainage, Compostela

2

Rio Juchilipa/Grande De S Drainage, Jalpa

1

Rio Juchilipa/Grande De S Drainage, Zapoqui

1

Rio Mezquital Drainage, Mezquital

1

Rio Mezquital/Rio San Ped Drainage, Durango

1

Rio Mezquital/Rio San Ped Drainage, Rio Chico

1

Rio Nazas Drainage, Cuencame

1

Rio Nazas Drainage, Cuencam�/Pueblo De Santiago

1

Rio Nazas Drainage, Palmito

1

Rio Purificacion Drainage, La Huerta

1

Rio San Juan/Rio Moctezum Drainage, Cadereyta

1

Rio San Lorenzo Drainage, San Lorenzo/Rio San Lorenzo

1

Rio Sinaloa Drainage, Guasave/Rio Sinaloa

1

Rio Tuxpan/Coahuayana Drainage, Atenquique

1

Rio Valparaiso/Bolanos/Gr Drainage, Valparaiso

1

Rio Verde Grande De Belem Drainage, Tepatitl�n

1

Rio Yaqui Drainage, Yepomera

1

Robledo Mountains/Rio Grande drainage

1

Route used by Webb in 1963 to access site off of Doniphan Drive is now fenced off as part of Foxworth Galbraith Lumber/A

nthony Truss Mfc. Company grounds (and bridge over east drain used by him is now demolished); access used by Lieb in 201

2 was via Rainbow Lakes Rd , then south along roads bordering east drain to the west bound canal ("penitentiary drain")

indicated by Webb (in field notes) as the trapping site, locality is inferred from Webb's field notes to be W of La Tuna

Federal Prison, in penitentiary canal between the Anthony Drain And East Drain, Rio Grande Drainage, anthony

1

Salt Fork/Arkansas River Drainage, Great Salt Plains State Park/Nw Refuge

1

San Francisco Creek/Rio Grande Drainage, Marathon

1

San Gabriel Mountains, very little of the Lytle Creek Drainage is in los angeles county

1

San Juan River Drainage. Badlands. Same locality cited by Wilson 1951.

1

San Juan River drainage

1

San Juan River drainage, R4W T34N

1

San Pedro River Drainage

4

Selkirk Mountains, Columbia River Drainage

1

Seventysix Draw Drainage, Columbus

1

Station T34 or 395 for K.M. Sommerman specimens. These station numbers are interchangeable and refer to the same locali

ty. Artificial drainage ditch on right of road. Pool fed by trickle under road. SAH 02/01/2011

1

Suspected to have been collected at drainage canal at Two Brothers Farm (see UTEP 16218)

1

T16S, R17W, Sec.4, Colorado/Gila Drainage, Cliff/Hwy 180/Gila River Bridge

1

T21S, R26E, Nw 1/4 Sw 1/4 Sec.26, Pecos/Rio Grande Drainage, Eddy Co.

1

T21S, R26E, Sw 1/4 Sec.26, Pecos/Rio Grande Drainage, Eddy Co., Pecos Rv. Pool Of Pecos

1

T21S, R26E, Sw 1/4 Sec.26, Pecos/Rio Grande Drainage, Eddy Co., Pecos Rv., Pool Of Pecos

1

T22S, R253, Nw 1/4 Se 1/4 Se 1/4 Sec.29, Shoud Be Range 25E., Pecos/Rio Grande Drainage, T22S R25E S29 Nw1/4 Se1/4 Se1/4

1

T22S, R25E, Nw 1/4 Sw 1/4 Sec.28, Pecos/Rio Grande Drainage, Eddy Co.

1

T28S, R17W, Playas Valley (Closed Bas) Drainage, Playas Lake

1

T2N, R25E, Centr. Sec.9, Alligator Creek/Nassau River Drainage, Musselwhite Rd/Jct Hwy 1-301

1

That day Carr walked up "to summit at Lead Canyon directly East of Camp...collecting along route" (p. 161, 1912). The 9

500 ft contour in the drainage was his likely route (there is no marked trail on topo maps). J.L.Patton 12 March 2010.

2

Tularosa Creek drainage, SEC 32 NE 1/4 R10E T13S

1

Used City of Newton's Areas Requiring Drainage 1892 Historic Map to verify Cabot Park area contained a swamp portion. Ge

oreferenced at the center of Cabot Park with uncertainty radius extending to city boundaries, by Teresa Dorado on 2018 D

ecember 19 [tdorado 2018 December 19].

1

Used City of Newton's Areas Requiring Drainage 1892 Historic Map to verify Cabot Park area contained a swamp portion. Ge

oreferenced at the center of Cabot Park with uncertainty radius extending to city boundaries, by Teresa Dorado on 2018 D

ecember 21 [tdorado 2018 December 21].

2

Webb field notes indicate this specimen was taken while setting turtle traps west of the Country Club in the drainage ca

nal that lies next to Montoya Drive (this is not Montoya Drain per se, but apparently a tributary of the NewMexas Drain-

  • CSL)

    1

West Fork Monongahela River Drainage

5

coordinates for center of ca. 9 mi. long drainage; VERBATIMCOORDINATESYSTEM: decimal degrees; GEOREFERENCEDBY: Eric Rick

art (UMNH); GEOREFERENCEDDATE: 27 Jun 2003; GEOREFERENCESOURCES: USGS 1:24,000; GEOREFERENCEVERIFICATIONSTATUS: requires

verification

2

locality is recorded as "on the Carribean drainage of the trans-Isthmus railway"

1

or Columbia County, Ichetucknee River drainage

1

179 rows selected.

Elapsed: 00:00:00.67

UAM@ARCTOS>

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/ArctosDB/arctos/issues/2136?email_source=notifications&email_token=ADQ7JBGFRYQONNMXDK2D7Q3P4ZE4TA5CNFSM4H4HKIX2YY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4G4LXMRA, or mute the thread https://github.com/notifications/unsubscribe-auth/ADQ7JBEWCWQYNFU23DA6QR3P4ZE4TANCNFSM4H4HKIXQ .

dustymc commented 5 years ago 

create table temp_l_d as 
  select 
    locality.locality_id,
    locality.spec_locality, 
    locality.locality_remarks, 
    geog_auth_rec.geog_auth_rec_id,
    geog_auth_rec.higher_geog
  from 
    locality,
    geog_auth_rec 
  where 
    locality.geog_auth_rec_id=geog_auth_rec.geog_auth_rec_id and 
    drainage is null and 
    lower(locality_remarks) like '%drainage%'
  ;

alter table temp_l_d add usedby varchar2(255);

declare
  g varchar2(255);
  s varchar2(2);
begin
  for r in (select distinct locality_id from temp_l_d) loop
    s:='';
    g:='';
    for c in (
      select distinct 
        guid_prefix 
      from 
        collection, 
        cataloged_item,
        specimen_event,
        collecting_event
      where
        collection.collection_id=cataloged_item.collection_id and
        cataloged_item.collection_object_id=specimen_event.collection_object_id and
        specimen_event.collecting_event_id=collecting_event.collecting_event_id and
        collecting_event.locality_id=r.locality_id
     ) loop
        g:=g||s||c.guid_prefix;
        s:='; ';
      end loop;
    update temp_l_d set usedby=g where locality_id=r.locality_id;
  end loop;
end;
/

UAM@ARCTOS> select usedby,count(*) from temp_l_d group by usedby order by usedby;

USEDBY                                 COUNT(*)
------------------------------------------------------------ ----------
CHAS:Inv                                  3
MSB:Fish                                 29
MVZ:Bird; MVZ:Herp                            1
MVZ:Herp                                  2
MVZ:Mamm                                  3
UAM:Alg                                   1
UAM:ES                                    2
UAM:Ento                                  1
UCM:Herp                                  1
UTEP:Arc                                  2
UTEP:Bird                                11
UTEP:ES                                 141
UTEP:ES; MSB:Mamm                             1
UTEP:Herb                                 6
UTEP:Herp                                74
UTEP:HerpOS                              14
UTEP:Inv                                  2
UTEP:Inv; UTEP:ES                            12
UTEP:Mamm                               128
UTEP:Mamm; UTEP:Bird                              1
UTEP:Mamm; UTEP:ES                            1
UTEP:Mamm; UTEP:Teach                             1
UTEP:Zoo                                  1
UWBM:Mamm                                 4
                                     25

25 rows selected.

alter table temp_l_d add might_be_drainage varchar2(255);
alter table temp_l_d add might_be_GID varchar2(255);

declare 
  pd varchar2(4000);
  lr varchar2(4000);
  c number;
  hg varchar2(255);
  g number;
begin
  for r in (select locality_id,higher_geog,locality_remarks from temp_l_d) loop
    lr:=trim(lower(replace(r.locality_remarks,'drainage')));
    pd:=lower(r.higher_geog || ', ' || lr);
    select count(*) into c from geog_auth_rec where lower(higher_geog)=pd;
    if c=1 then
      select higher_geog,geog_auth_rec_id into hg,g from geog_auth_rec where lower(higher_geog)=pd;
      update temp_l_d set might_be_drainage=hg,might_be_GID=g where locality_id=r.locality_id;
    end if;
  end loop;
end;
/

temp_l_d.csv.zip

Let me know if anyone wants to try to catch some of these and I'll name the localities and re-run this.

Do not do anything with the attached - the localityIDs are not necessarily stable.

FWIW were these mine I'd probably not move them unless I also had the resources to secure WKT for the drainage-in-county type data; I'd almost certainly see the loss of the spatial capabilities as much more important than the drainage data. Probably why I'm not a fishologist....

Jegelewicz commented 5 years ago

The MSB:Fish are all "Fish Hatchery Drainage", which seems meaningless to me, so I would leave those out of drainage. However, this comment might actually be better placed in the specimen event/habitat? @campmlc ?

A review of the UTEP stuff also makes me think that drainage should stay where it is for now for all UTEP localities given your remarks above.

I'll let others speak for themselves.

dustymc commented 5 years ago

Fish Hatchery Drainage

Not 100% certain, but I think that's a swing-and-miss in the general vicinity of captive. I suppose it's habitat as well....

Jegelewicz commented 5 years ago 
Fish Hatchery Drainage

Not 100% certain, but I think that's a swing-and-miss in the general vicinity of captive. I suppose it's habitat as well....

Possible, but I don't know for sure. Probably best to just leave it as is for now.

campmlc commented 5 years ago

Agree that Fish Hatchery Drainage could go into Collecting Event remarks, where all drainage info started out.

On Tue, Jul 9, 2019 at 2:37 PM Teresa Mayfield-Meyer < notifications@github.com> wrote:

Fish Hatchery Drainage

Not 100% certain, but I think that's a swing-and-miss in the general vicinity of captive. I suppose it's habitat as well....

Possible, but I don't know for sure. Probably best to just leave it as is for now.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/ArctosDB/arctos/issues/2136?email_source=notifications&email_token=ADQ7JBFK26X3NXYDXSYGG23P6TZIBA5CNFSM4H4HKIX2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODZROMXY#issuecomment-509797983, or mute the thread https://github.com/notifications/unsubscribe-auth/ADQ7JBDPTEUCWL5YBRWFZW3P6TZIBANCNFSM4H4HKIXQ .