Project

General

Profile

Specimen descriptions

There are 4 million different notes entries that may contain specimen description information:

1 The following query returns 1,619,011 of 30,712,071 rows:

SELECT COUNT(*)
FROM "public.2012-10-18-17-00-14.r5660".taxondetermination
WHERE notes IS NOT NULL

2 The following query returns 2,404,801 of 25,058,186 rows:

SELECT COUNT(*)
FROM "public.2012-10-18-17-00-14.r5660".aggregateoccurrence
WHERE notes IS NOT NULL