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=3458 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3458SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3159SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3458 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gavia' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gavia' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gavia' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gavia' AND (junior_species='spp.' OR junior_species='spp.')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='Gavia' AND (species='spp.' OR species='spp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podiceps' AND (junior_species='grisegena' OR junior_species='grisegena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Podiceps' AND (species='grisegena' OR species='grisegena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Podiceps' AND (species='grisegena' OR species='grisegena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podiceps' AND (junior_species='grisegena' OR junior_species='grisegena')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='Podiceps' AND (species='grisegena' OR species='grisegena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Branta' AND (junior_species='canadensis' OR junior_species='canadensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Branta' AND (species='canadensis' OR species='canadensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Branta' AND (species='canadensis' OR species='canadensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Branta' AND (junior_species='canadensis' OR junior_species='canadensis')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='Branta' AND (species='canadensis' OR species='canadensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitta' AND (junior_species='fusca' OR junior_species='fusca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanitta' AND (species='fusca' OR species='fusca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanitta' AND (species='fusca' OR species='fusca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitta' AND (junior_species='fusca' OR junior_species='fusca')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='Melanitta' AND (species='fusca' OR species='fusca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Haliaeetus' AND (junior_species='leucocephalus' OR junior_species='leucocephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Haliaeetus' AND (species='leucocephalus' OR species='leucocephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Haliaeetus' AND (species='leucocephalus' OR species='leucocephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Haliaeetus' AND (junior_species='leucocephalus' OR junior_species='leucocephalus')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='Haliaeetus' AND (species='leucocephalus' OR species='leucocephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Accipiter' AND (junior_species='gentilis' OR junior_species='gentilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Accipiter' AND (species='gentilis' OR species='gentilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Accipiter' AND (species='gentilis' OR species='gentilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Accipiter' AND (junior_species='gentilis' OR junior_species='gentilis')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='Accipiter' AND (species='gentilis' OR species='gentilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cerorhinca' AND (junior_species='monocerata' OR junior_species='monocerata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cerorhinca' AND (species='monocerata' OR species='monocerata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cerorhinca' AND (species='monocerata' OR species='monocerata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cerorhinca' AND (junior_species='monocerata' OR junior_species='monocerata')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='Cerorhinca' AND (species='monocerata' OR species='monocerata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marmota' AND (junior_species='caligata' OR junior_species='caligata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marmota' AND (species='caligata' OR species='caligata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Marmota' AND (species='caligata' OR species='caligata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marmota' AND (junior_species='caligata' OR junior_species='caligata')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='Marmota' AND (species='caligata' OR species='caligata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castor' AND (junior_species='canadensis' OR junior_species='canadensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Castor' AND (species='canadensis' OR species='canadensis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castor' AND (junior_species='canadensis' OR junior_species='canadensis')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='Castor' AND (species='canadensis' OR species='canadensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erethizon' AND (junior_species='dorsatum' OR junior_species='dorsatum')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erethizon' AND (species='dorsatum' OR species='dorsatum') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erethizon' AND (junior_species='dorsatum' OR junior_species='dorsatum')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''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='Erethizon' AND (species='dorsatum' OR species='dorsatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canis' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canis' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='spp.' OR junior_species='spp.')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='Canis' AND (species='spp.' OR species='spp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' AND (junior_species='americanus' OR junior_species='americanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ursus' AND (species='americanus' OR species='americanus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' AND (junior_species='americanus' OR junior_species='americanus')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='americanus' OR species='americanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' AND (junior_species='arctos' OR junior_species='arctos')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ursus' AND (species='arctos' OR species='arctos') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' AND (junior_species='arctos' OR junior_species='arctos')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='arctos' OR species='arctos') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procyon' AND (junior_species='lotor' OR junior_species='lotor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Procyon' AND (species='lotor' OR species='lotor') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procyon' AND (junior_species='lotor' OR junior_species='lotor')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='Procyon' AND (species='lotor' OR species='lotor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neogale' AND (junior_species='vison' OR junior_species='vison')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neogale' AND (species='vison' OR species='vison') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neogale' AND (junior_species='vison' OR junior_species='vison')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='Neogale' AND (species='vison' OR species='vison') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lontra' AND (junior_species='canadensis' OR junior_species='canadensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lontra' AND (species='canadensis' OR species='canadensis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lontra' AND (junior_species='canadensis' OR junior_species='canadensis')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='Lontra' AND (species='canadensis' OR species='canadensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enhydra' AND (junior_species='lutris' OR junior_species='lutris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Enhydra' AND (species='lutris' OR species='lutris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Enhydra' AND (species='lutris' OR species='lutris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enhydra' AND (junior_species='lutris' OR junior_species='lutris')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='Enhydra' AND (species='lutris' OR species='lutris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumetopias' AND (junior_species='jubata' OR junior_species='jubata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eumetopias' AND (species='jubata' OR species='jubata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eumetopias' AND (species='jubata' OR species='jubata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumetopias' AND (junior_species='jubata' OR junior_species='jubata')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='Eumetopias' AND (species='jubata' OR species='jubata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callorhinus' AND (junior_species='ursinus' OR junior_species='ursinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Callorhinus' AND (species='ursinus' OR species='ursinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Callorhinus' AND (species='ursinus' OR species='ursinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callorhinus' AND (junior_species='ursinus' OR junior_species='ursinus')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='Callorhinus' AND (species='ursinus' OR species='ursinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoca' AND (junior_species='vitulina' OR junior_species='vitulina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phoca' AND (species='vitulina' OR species='vitulina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phoca' AND (species='vitulina' OR species='vitulina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoca' AND (junior_species='vitulina' OR junior_species='vitulina')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='Phoca' AND (species='vitulina' OR species='vitulina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odocoileus' AND (junior_species='hemionus' OR junior_species='hemionus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odocoileus' AND (species='hemionus' OR species='hemionus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odocoileus' AND (junior_species='hemionus' OR junior_species='hemionus')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='Odocoileus' AND (species='hemionus' OR species='hemionus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alces' AND (junior_species='alces' OR junior_species='alces')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alces' AND (species='alces' OR species='alces') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alces' AND (junior_species='alces' OR junior_species='alces')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='Alces' AND (species='alces' OR species='alces') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oreamnos' AND (junior_species='americanus' OR junior_species='americanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oreamnos' AND (species='americanus' OR species='americanus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oreamnos' AND (junior_species='americanus' OR junior_species='americanus')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='Oreamnos' AND (species='americanus' OR species='americanus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3458 The Ecological Register: Grassy Bay
Grassy Bay
Basic information
Sample name: Grassy Bay

Reference: F. L. Stewart and K. M. Stewart. 1996. The Boardwalk and Grassy Bay sites: patterns of seasonality and subsistence on the northern Northwest Coast, B.C.. Canadian Journal of Archaeology 20:39-60 [ER 3159]
Geography
Country: Canada

State: British Columbia


Coordinate: 54° 17' N, 130° 18' W
Coordinate basis: based on nearby landmark

Time interval: Holocene

Max Ma: 0.001615

Min Ma: 0.00062

Age basis: radiocarbon (uncalibrated)

Geography comments: "on the northeast shore of Kaien Island, on Grassy Bay, facing Fern Passage" (coordinate based on Kaien Island)
four radiocarbon dates range from 1615 +/- 60 to 620 +/- 55 BP (presumed to be uncalibrated because errors are symmetrically distributed)

•
Environment
Lithology: not described

Taphonomic context: human accumulation

Habitat comments: lithology is described as "heavy wet soil"
a "seasonal camp"
the site is not described as a midden per se
lithics, ceramics, and other artifacts are not discussed, and structures appear not to be present

Methods
Life forms: carnivores,rodents,ungulates,marine mammals,birds

Sampling methods: quarry

Sample size: 874 specimens

Sampled by: G. F. MacDonald

Sampling comments: it was no possible to screenwash, so small material was "trowelled through"
fish material was not identified

Metadata
Sample number: 3458

Contributor: John Alroy

Enterer: John Alroy

Created: 2019-09-02 15:48:21

Modified: 2023-04-03 08:50:17

Abundance distribution
23 species
6 singletons
total count 874
extrapolated richness: 36.9
Fisher's α: 4.329
geometric series k: 0.7812
Hurlbert's PIE: 0.8124
Shannon's H: 1.9564
Good's u: 0.9931
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Gavia spp.10
Podiceps grisegena11.0 kg
Branta canadensis34.1 g folivore
Melanitta fusca343.8 g
Haliaeetus leucocephalus34.1 kg piscivore
Accipiter gentilis17.9 g carnivore
Cerorhinca monocerata229510 g
Marmota caligata3
Castor canadensis811 kg
Erethizon dorsatum229.9 kg herbivore
Canis spp.51
Ursus americanus18115 kg browser-insectivore
Ursus arctos1156 kg frugivore-carnivore
Procyon lotor15.5 kg carnivore-granivore
Neogale vison1950 g
"Mustela vison"
Lontra canadensis37.1 kg piscivore
Enhydra lutris111
Eumetopias jubata3
Callorhinus ursinus5
Phoca vitulina186
Odocoileus hemionus20065 kg browser
Alces alces1421 kg herbivore
Oreamnos americanus1078 kg