Growth forms¶

Barbara Dobrin's scripts¶

See attached ScriptsAnnot.zip

• KEY.docx provides an overview of the scripts
• There are a total of 7 scripts
• File1.sql is the example script described in the Skype call (stage2Ed.sql)

Provided by source data¶

There are 300,000 occurrence growth form entries, in only three datasources:

• 191,000 in SALVIAS¹ (45%)
• 209,531 in Madidi⁹ (99.4%)
  • 112,000 in the BIEN2 Madidi data² (100%)
• 11,571 in the BIEN2 CTFS data⁸ (100%), always set to Tree
  • the updated CTFS data does not provide growth forms, so they were almost certainly added after the fact to the BIEN2 extract
• 57+ in the NVS sample data⁵

There are also growth forms for non-occurrence entities in several datasources:

• 112,251 taxa in FIA³ (93%)
• 8614 taxa in CVS⁴ (85%)
• 337 plot observations in VegBank⁶ (0.46%)
  • the BIEN2 VegBank data does not provide growth forms (its VegCategory field is always empty⁷)

¹ The following query returns 191,405 of 427,730 rows:

SELECT COUNT(*)
FROM "SALVIAS"."plotObservations" 
WHERE "Habit" IS NOT NULL

² The following query returns 112,251 of 112,251 rows:

SELECT COUNT(*)
FROM "Madidi"."Organism" 
WHERE "Habit" IS NOT NULL

³ The following query returns 73,147 of 78,769 rows:

SELECT COUNT(*)
FROM "FIA"."REF_PLANT_DICTIONARY" 
WHERE /*"GROWTH_HABIT"*/"taxonGrowthForm" IS NOT NULL

⁴ The following query returns 8614 of 10,156 rows:

SELECT COUNT(*)
FROM "CVS"."plantConcept" 
WHERE "growthForm_short" IS NOT NULL OR "usda_growthForm" IS NOT NULL

⁵ The following query returns 57 of 57 rows:
(see also other columns named Taxon Growth Form)

SELECT COUNT(*)
FROM "NVS"."TaxonOccurrence" 
WHERE "Taxon Growth Form" IS NOT NULL

⁶ The following query returns 337 of 72,840 rows:

SELECT COUNT(*)
FROM "VegBank".observation
WHERE growthform1type IS NOT NULL

⁷ The following query (on starscream) returns 0 rows:

SELECT COUNT(*)
FROM `StagingAggregateComplete_vegbank`
WHERE VegCategory IS NOT NULL

⁸ The following query returns 11,571 of 11,571 rows:

SELECT COUNT(*)
FROM "CTFS"."AggregateObservation" 
WHERE "VegCategory" IS NOT NULL

⁹ The following query returns 209,531 of 210,854 rows:

SELECT COUNT(*)
FROM "Madidi"."IndividualObservation" 
WHERE "HabitName" IS NOT NULL