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=4263 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4263SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3884SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4263 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nyctereutes' AND (junior_species='megamastoides' OR junior_species='megamastoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nyctereutes' AND (species='megamastoides' OR species='megamastoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nyctereutes' AND (species='megamastoides' OR species='megamastoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nyctereutes' AND (junior_species='megamastoides' OR junior_species='megamastoides')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='Nyctereutes' AND (species='megamastoides' OR species='megamastoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucyon' 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='Eucyon' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eucyon' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucyon' 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='Eucyon' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' AND (junior_species='minimus' OR junior_species='minimus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ursus' AND (species='minimus' OR species='minimus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ursus' AND (species='minimus' OR species='minimus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' AND (junior_species='minimus' OR junior_species='minimus')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='Ursus' AND (species='minimus' OR species='minimus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lynx' AND (junior_species='issiodorensis' OR junior_species='issiodorensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lynx' AND (species='issiodorensis' OR species='issiodorensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lynx' AND (species='issiodorensis' OR species='issiodorensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lynx' AND (junior_species='issiodorensis' OR junior_species='issiodorensis')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='Lynx' AND (species='issiodorensis' OR species='issiodorensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homotherium' AND (junior_species='latidens' OR junior_species='latidens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Homotherium' AND (species='latidens' OR species='latidens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Homotherium' AND (species='latidens' OR species='latidens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homotherium' AND (junior_species='latidens' OR junior_species='latidens')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='Homotherium' AND (species='latidens' OR species='latidens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Puma' AND (junior_species='paradoides' OR junior_species='paradoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Puma' AND (species='paradoides' OR species='paradoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Puma' AND (species='paradoides' OR species='paradoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Puma' AND (junior_species='paradoides' OR junior_species='paradoides')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='Puma' AND (species='paradoides' OR species='paradoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dinofelis' AND (junior_species='cristata' OR junior_species='cristata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dinofelis' AND (species='cristata' OR species='cristata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dinofelis' AND (species='cristata' OR species='cristata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dinofelis' AND (junior_species='cristata' OR junior_species='cristata')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='Dinofelis' AND (species='cristata' OR species='cristata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chasmaporthetes' AND (junior_species='lunensis' OR junior_species='lunensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chasmaporthetes' AND (species='lunensis' OR species='lunensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chasmaporthetes' AND (species='lunensis' OR species='lunensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chasmaporthetes' AND (junior_species='lunensis' OR junior_species='lunensis')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='Chasmaporthetes' AND (species='lunensis' OR species='lunensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hystrix' AND (junior_species='primigenia' OR junior_species='primigenia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hystrix' AND (species='primigenia' OR species='primigenia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hystrix' AND (species='primigenia' OR species='primigenia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hystrix' AND (junior_species='primigenia' OR junior_species='primigenia')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='Hystrix' AND (species='primigenia' OR species='primigenia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Propotamochoerus' AND (junior_species='provincialis' OR junior_species='provincialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Propotamochoerus' AND (species='provincialis' OR species='provincialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Propotamochoerus' AND (species='provincialis' OR species='provincialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Propotamochoerus' AND (junior_species='provincialis' OR junior_species='provincialis')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='Propotamochoerus' AND (species='provincialis' OR species='provincialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucladoceros' 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='Eucladoceros' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eucladoceros' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucladoceros' 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='Eucladoceros' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudalces' 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='Pseudalces' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudalces' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudalces' 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='Pseudalces' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procapreolus' 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='Procapreolus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Procapreolus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procapreolus' 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='Procapreolus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ioribos' AND (junior_species='aceros' OR junior_species='aceros')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ioribos' AND (species='aceros' OR species='aceros') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ioribos' AND (species='aceros' OR species='aceros')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ioribos' AND (junior_species='aceros' OR junior_species='aceros')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='Ioribos' AND (species='aceros' OR species='aceros') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protoryx' AND (junior_species='heinrichi' OR junior_species='heinrichii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protoryx' AND (species='heinrichi' OR species='heinrichii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protoryx' AND (species='heinrichi' OR species='heinrichii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protoryx' AND (junior_species='heinrichi' OR junior_species='heinrichii')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='Protoryx' AND (species='heinrichi' OR species='heinrichii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oryx' 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='Oryx' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oryx' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oryx' 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='Oryx' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gazellospira' AND (junior_species='torticornis' OR junior_species='torticornis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gazellospira' AND (species='torticornis' OR species='torticornis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gazellospira' AND (species='torticornis' OR species='torticornis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gazellospira' AND (junior_species='torticornis' OR junior_species='torticornis')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='Gazellospira' AND (species='torticornis' OR species='torticornis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eosyncerus' AND (junior_species='ivericus' OR junior_species='ivericus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eosyncerus' AND (species='ivericus' OR species='ivericus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eosyncerus' AND (species='ivericus' OR species='ivericus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eosyncerus' AND (junior_species='ivericus' OR junior_species='ivericus')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='Eosyncerus' AND (species='ivericus' OR species='ivericus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gazella' AND (junior_species='postmitilinii' OR junior_species='postmitilini')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gazella' AND (species='postmitilinii' OR species='postmitilini') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gazella' AND (species='postmitilinii' OR species='postmitilini')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gazella' AND (junior_species='postmitilinii' OR junior_species='postmitilini')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='Gazella' AND (species='postmitilinii' OR species='postmitilini') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipparion' AND (junior_species='rocinantis' OR junior_species='rocinantis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hipparion' AND (species='rocinantis' OR species='rocinantis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hipparion' AND (species='rocinantis' OR species='rocinantis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipparion' AND (junior_species='rocinantis' OR junior_species='rocinantis')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='Hipparion' AND (species='rocinantis' OR species='rocinantis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dihoplus' AND (junior_species='megarhinus' OR junior_species='megarhinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dihoplus' AND (species='megarhinus' OR species='megarhinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dihoplus' AND (species='megarhinus' OR species='megarhinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dihoplus' AND (junior_species='megarhinus' OR junior_species='megarhinus')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='Dihoplus' AND (species='megarhinus' OR species='megarhinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kvabebihyrax' AND (junior_species='kachethicus' OR junior_species='kachethicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kvabebihyrax' AND (species='kachethicus' OR species='kachethicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kvabebihyrax' AND (species='kachethicus' OR species='kachethicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kvabebihyrax' AND (junior_species='kachethicus' OR junior_species='kachethicus')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='Kvabebihyrax' AND (species='kachethicus' OR species='kachethicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anancus' AND (junior_species='arvernensis' OR junior_species='arvernensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anancus' AND (species='arvernensis' OR species='arvernensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anancus' AND (species='arvernensis' OR species='arvernensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anancus' AND (junior_species='arvernensis' OR junior_species='arvernensis')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='Anancus' AND (species='arvernensis' OR species='arvernensis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=4263 The Ecological Register: Kvabebi
Kvabebi
Basic information
Sample name: Kvabebi

Reference: J. Agusti, A. Vekua, O. Oms, D. Lordkipanidze, M. Bukhsianidze, G. Kiladze, and L. Rook. 2009. The Pliocene-Pleistocene succession of Kvabebi (Georgia) and the background to the early human occupation of Southern Caucasus. Quaternary Science Reviews 28:3275-3280 [ER 3884]
Geography
Country: Georgia

State: Kakheti


Coordinate: 41.473862° N, 45.741837° E
Coordinate basis: estimated from map

Formation: Akchagylian Basin

Time interval: Late Pliocene

Ma: 3.07

Age basis: paleomag

Geography comments: The Kvabebi site is located in the "area surrounding Kvabebi Mountain to the south of the village of Magaro"

Coordinates estimated from Kevabebi Mountain

Age established through paleomag ("Site should have an age bracketed by the polarity reversals of chron 2An.1r, i.e., 3.04 and 3.11 Ma") and correlation with the European biochronological scale

Environment
Lithology: siliciclastic (mixed)

Taphonomic context: fluvial deposit

Habitat comments: "Kvabebi site is the result of accumulation due to tractive processes in a fluvial influenced environment"

"Bone and bone fragments are reworked and more or less scattered within sandstones and shales"

Fossil bones are typically found anatomically disconnected, most bones are isolated with no evidence of carnivore damage and "may be very well preserved"

Methods
Life forms: carnivores,rodents,ungulates,other large mammals

Sampling methods: quarry

Sample size: 808 specimens

Sampled by: G. Avakov, A. Vekua, J. Agusti

Sampling comments: "In recent years" a joint Georgian-Spanish team began re-prospecting and re-excavating the Kvabebi section

A paleomagnetic analysis was conducted on the series, consisting of field sampling with a drilling machine from >20 levels

Obtained a minimum of three cores from each sampled level

Metadata
Sample number: 4263

Contributor: Jack Nesbitt

Enterer: Jack Nesbitt

Created: 2023-05-11 16:27:24

Modified: 2023-05-12 00:58:15

Abundance distribution
23 species
4 singletons
total count 808
extrapolated richness: 32.6
Fisher's α: 4.409
geometric series k: 0.7804
Hurlbert's PIE: 0.8604
Shannon's H: 2.3069
Good's u: 0.9951
Each square represents a species. Square sizes are proportional to counts.
Register