CHRONO Marine Database
Connected to marine database as query
| details | taxa | class |
| MapNo |
| Lon |
| Lat |
| DeltaR |
| DeltaRErr |
| Reference |
| Locality |
| Subregion |
| Notes |
| CollectionYear |
| ReservoirAge |
| ReservoirErr |
| C14age |
| C14err |
| LabID |
| Delta13C |
| TaxaNo |
| RefNo |
|
| TaxaNo |
| Genus |
| Species |
| Feeding |
| ClassNo |
|
|
Type in a query here, following the example syntax
Help with Syntax
Examples:
Select * from class
Select * from details where mapno=600
select deltar,genus,species from details join taxa using (taxano) join class using (classno) where name='algae'
select locality,subregion,feeding,name from details join taxa using (taxano) join class using (classno) where reference like 'mcneely%'
select deltar,lon,lat from details where deltar>500 order by deltar
select mapno,labid,count(labid) from details group by labid having count(labid)>1 order by mapno
select avg(deltar),stddev_pop(deltar) from details where lat<-40 and lon between 0 and 180