SELECT * FROM sessions,people WHERE ip=20315109220 AND enterer=person_noSELECT p.first_name AS contributor_first,p.last_name AS contributor_last,p2.first_name AS enterer_first,p2.last_name AS enterer_last,t.* FROM people p,people p2,samples t WHERE t.contributor_no=p.person_no AND t.enterer_no=p2.person_no AND t.sample_no=2493 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2493SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2333SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2493 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moropus' AND (junior_species='elatus' OR junior_species='elatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Moropus' AND (species='elatus' OR species='elatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Moropus' AND (species='elatus' OR species='elatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moropus' AND (junior_species='elatus' OR junior_species='elatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Moropus' AND (species='elatus' OR species='elatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kalobatippus' AND (junior_species='agatensis' OR junior_species='agatensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kalobatippus' AND (species='agatensis' OR species='agatensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kalobatippus' AND (species='agatensis' OR species='agatensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kalobatippus' AND (junior_species='agatensis' OR junior_species='agatensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Kalobatippus' AND (species='agatensis' OR species='agatensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parahippus' AND (junior_species='atavus' OR junior_species='atavus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parahippus' AND (species='atavus' OR species='atavus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parahippus' AND (species='atavus' OR species='atavus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parahippus' AND (junior_species='atavus' OR junior_species='atavus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Parahippus' AND (species='atavus' OR species='atavus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diceratherium' AND (junior_species='niobrarense' OR junior_species='niobrarense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diceratherium' AND (species='niobrarense' OR species='niobrarense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diceratherium' AND (species='niobrarense' OR species='niobrarense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diceratherium' AND (junior_species='niobrarense' OR junior_species='niobrarense')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diceratherium' AND (species='niobrarense' OR species='niobrarense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Menoceras' AND (junior_species='arikarense' OR junior_species='arikarense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Menoceras' AND (species='arikarense' OR species='arikarense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Menoceras' AND (species='arikarense' OR species='arikarense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Menoceras' AND (junior_species='arikarense' OR junior_species='arikarense')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Menoceras' AND (species='arikarense' OR species='arikarense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dinohyus' AND (junior_species='hollandi' OR junior_species='hollandii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dinohyus' AND (species='hollandi' OR species='hollandii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dinohyus' AND (species='hollandi' OR species='hollandii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dinohyus' AND (junior_species='hollandi' OR junior_species='hollandii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dinohyus' AND (species='hollandi' OR species='hollandii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phenacocoelus' AND (junior_species='stouti' OR junior_species='stoutii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phenacocoelus' AND (species='stouti' OR species='stoutii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phenacocoelus' AND (species='stouti' OR species='stoutii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phenacocoelus' AND (junior_species='stouti' OR junior_species='stoutii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phenacocoelus' AND (species='stouti' OR species='stoutii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenomylus' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stenomylus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stenomylus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenomylus' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Stenomylus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Michenia' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Michenia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Michenia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Michenia' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Michenia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blastomeryx' AND (junior_species='olcotti' OR junior_species='olcottii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Blastomeryx' AND (species='olcotti' OR species='olcottii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Blastomeryx' AND (species='olcotti' OR species='olcottii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blastomeryx' AND (junior_species='olcotti' OR junior_species='olcottii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Blastomeryx' AND (species='olcotti' OR species='olcottii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nanotragulus' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nanotragulus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nanotragulus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nanotragulus' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nanotragulus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Canidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Daphoenodon' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Daphoenodon' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Daphoenodon' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Daphoenodon' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Daphoenodon' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ysengrinia' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ysengrinia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ysengrinia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ysengrinia' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ysengrinia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaeocastor' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palaeocastor' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palaeocastor' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaeocastor' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Palaeocastor' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2493 The Ecological Register: Morava Ranch Quarry (1975)
Morava Ranch Quarry (1975)
Basic information
Sample name: Morava Ranch Quarry (1975)

Reference: M. C. Coombs and W. P. Coombs Jr. 1997. Analysis of the geology, fauna, and taphonomy of Morava Ranch Quarry, early Miocene of northwest Nebraska. Palaios 12(2):165-187 [ER 2333]
Geography
Country: United States

State: Nebraska


Coordinate: 42° 26' N, 103° 26' W
Coordinate basis: stated in text

Time interval: Early Miocene

Ma: 22

Geography comments: "NE 1/4 Sect. 6, T28N, R52W... Harrison Formation or Upper Harrison beds"

Environment
Substrate: ground surface

Lithology: sandstone

Habitat comments: "channel deposits"

Methods
Life forms: carnivores,rodents,ungulates

Sampling methods: quarry

Sample size: 365 specimens

Years: 1975

Metadata
Sample number: 2493

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-02-12 12:34:36

Modified: 2017-02-12 01:42:24

Abundance distribution
15 species
3 singletons
total count 365
extrapolated richness: 23.5
Fisher's α: 3.151
geometric series k: 0.6837
Hurlbert's PIE: 0.6535
Shannon's H: 1.5861
Good's u: 0.9918
Each square represents a species. Square sizes are proportional to counts.
Register