Specimen descriptions¶

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

• 1.6 million taxonRemarks entries¹ (5.3%)
• 2.4 million fieldNotes entries² (9.6%)

¹ 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

² 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