Baselight

Alien Plant Threat Assessment

Department of the Interior

@usgov.doi_gov_alien_plant_threat_assessment

JFLORA
@usgov.doi_gov_alien_plant_threat_assessment.jflora

Lookup table for codes used to represent vascular plant species recorded during alien plant species assessment surveys (nomenclature: Hickman. 1993. The Jepson Manual, 1st Edition)

  • 125.63 KB
  • 1436 rows
  • 16 columns
camo20

CAMO20

calyptridium

Calyptridium

monospermum

Monospermum

greene

Greene

unnamed_4

Unnamed: 4

unnamed_5

Unnamed: 5

unnamed_6

Unnamed: 6

portulacaceae

Portulacaceae

added_the_species

Added The Species

n_1

1

n_0

0

calyptridium_monospermum_greene

Calyptridium Monospermum Greene

unnamed_12

Unnamed: 12

calyptridium_monospermum

Calyptridium Monospermum

unnamed_14

Unnamed: 14

calyptridium_monospermum_1

Calyptridium Monospermum.1

ACNE11Achnatherumnelsonii(Scribner) Barkworthssp.dorei(Barkworth & J. Maze) BarkworthPoaceaeAdded the species1Achnatherum nelsonii (Scribn.) Barkworth ssp. dorei (Barkworth & J.R. Maze) BarkworthAchnatherum nelsonii ssp. doreiAchnatherum nelsonii
PLTO11Plagiobothrystorreyi(A. Gray) A. Grayvar.diffususI. M. Johnst.BoraginaceaeAdded the variety1Plagiobothrys torreyi (A. Gray) A. Gray var. diffusus I. M. Johnst.Plagiobothrys torreyi var. diffususPlagiobothrys torreyi
ROBR10RosabridgesiiCrép. ex Rydb.RosaceaeAdded the species1Rosa bridgesii Crép. ex Rydb.Rosa bridgesiiRosa bridgesii
URUR10UrticaurensL.UrticaceaeUrtica urens L.Urtica urensUrtica urens
CAPY20CarduuspycnocephalusL.AsteraceaeCarduus pycnocephalusCarduus pycnocephalusCarduus pycnocephalus
ANCA31AnthriscuscaucalisM. Bieb.ApiaceaeAnthriscus caucalis M. Bieb.Anthriscus caucalisAnthriscus caucalis
TRDU10TragopogondubiusScop.AsteraceaeTragopogon dubius Scop.Tragopogon dubiusTragopogon dubius
HIIN10Hirschfeldiaincana(L.) Lagr.-FossatBrassicaceaeHirschfeldia incana (L.) Lagr.-FossatHirschfeldia incanaHirschfeldia incana
TRDU20TrifoliumdubiumSibth.FabaceaeTrifolium dubium Sibth.Trifolium dubiumTrifolium dubium
VIBE10ViciabenghalensisL.FabaceaeVicia benghalensis L.Vicia benghalensisVicia benghalensis

CREATE TABLE jflora (
  "camo20" VARCHAR,
  "calyptridium" VARCHAR,
  "monospermum" VARCHAR,
  "greene" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "portulacaceae" VARCHAR,
  "added_the_species" VARCHAR,
  "n_1" BIGINT,
  "n_0" BIGINT,
  "calyptridium_monospermum_greene" VARCHAR,
  "unnamed_12" VARCHAR,
  "calyptridium_monospermum" VARCHAR,
  "unnamed_14" VARCHAR,
  "calyptridium_monospermum_1" VARCHAR
);

Share link

Anyone who has the link will be able to view this.