|
The field names below are not necessarily shown in the order that they appear in downloaded data files.
Note that the data contained in Calflora is dynamic,
and the database may also change structure periodically
to adapt to new needs or processes.
.
CALFLORA RECORD NUMBER
Example: 7245
Max size: 4
Unique ID number (integer) for Calflora record. These numbers are
revised from time to time as circumscriptions or database maintenance
dictate, please be advised not to use them as unique identifiers for
taxa unless you are willing to perform maintenance on your data
references. (links based on taxon names or ID codes (PLANTS, ADP or
ITIS TSN) are probably more stable long-term.
CALFLORA TAXON NAME
Example: Abronia villosa S. Watson var. aurita (Abrams) Jepson
Max size: 255
(logistically longest: 138 for Pentagramma triangularis ssp. semipallida)
Full name of taxon, concatenated from the separate name component fields.
= "genus species author1 rank ssp_var author2"
Usage and spelling generally follows the Jepson Manual (Hickman 1993). Taxa
given partial recognition in the Jepson Manual ( eg. 'plants with
fr. < 3mm have been called var. minima') are also included, as are
taxa recognized as distinct by the California Native Plant Society in
the Inventory of Rare and Endangered Plants of California. We
plan to include additional plants discovered or recognized since these
publications, with criteria for inclusion currently under development.
The list of names originally used in Calflora was provided by Fred
Hrusa, California Department of Food and Agriculture. Differs from field taxon in that it includes author citation.
TAXON
Example: Abronia maritima
Max size: 128
Name of taxon, without authors. Useful for matching data
between data sets.
concatenated from the separate name component fields:
= "genus species rank ssp_var"
Note: A taxon record does not always correspond to unique
plant species or end-points of diversity.
i.e. Calflora contains
separate records for Pentagramma triangularis, Pentagramma
triangularis ssp.triangularis, and Pentagramma triangularis
ssp. semipallida. If one were tracking biodiversity for an area, it
would be wrong to double count both a parent taxon record "Pentagramma
triangularis" and a child taxon record (i.e. Pentagramma triangularis
ssp. semipallida" as two separate units of biodiversity. See
additional discussion under the field description for parent_child.
GENUS
Example: Abronia
Max size: 17
Genus name of taxon.
SPECIES
Example: villosa
Max size: 21
Specific epithet of taxon. Note the uses of the word 'species' to refer to specific epithet is incorrect. Species refers to unique combinations of genus plus specific epithet.
AUTHOR 1
Example: S. Watson
Max size: 46
Species author of taxon, including parenthetical authorship.
RANK
Example: var.
Max size: 4
Infraspecific rank of taxon - "var." or "ssp."
SSP_VAR
Example: aurita
Max size: 19
Infraspecific epithet for taxon.
AUTHOR 2
Example: (Abrams) Jepson
Max size: 49
Infraspecific author of taxon, including parenthetical authorship.
FAMILY
Example: ASTERACEAE
Max size: 16
Family assignments follow the Jepson Manual (Hickman 1993).
CATEGORY
Example: 3Dicot
Max size: 13
Values include:
dicot
gymnosperm
monocot
pteridophyte
Designed to facilitate sorting of records in a phylogenetic order.
PARENT/CHILD TAG
Example: child
Max size: 10
This field tags the record as
child, stepchild, or parent.
A child is a fully recognized taxon
that is included in another taxon within
this database.
A parent is the taxon within which the child is included.
For example,
|
Poa secunda ssp. juncifolia | is a child, and |
Poa secunda| is the parent of that child. |
In a case like this, the information available in this database
for the child
will be more articulated than information available for the parent.
On the other hand, information for the parent will in some ways be
an aggregate of information for all of the children
(subspecies and varieties).
For instance, observation data reported for Poa secunda
will include all observation data for
Poa secunda ssp. juncifolia
and Poa secunda ssp. secunda.
(A stepchild is a taxon not fully recognized as distinct in the
Jepson Manual (Hickman 1993), but included here because it is recognized as
distinct by the CNPS or considered possibly distinct by the Jepson Manual
treatment author. A taxon from which the stepchild is doubtfully distinct is
not identified as a parent.)
This tag is intended to facilitate species
counts--including both a child and its parent results in an over-count of
taxa.
PARENT RECORDNUM
Example: 345
Max size: 4
For children this is the calrecnum of the parent. For stepchildren, this is the calrecnum of the taxon from which the stepchild is possibly distinct.
PARENT NAME
Example: Trifolium andersonii
Max size: 42
For children this is the name (genus + species + rank + ssp_var) of the parent. For stepchildren, this is the name of the taxon from which the stepchild is possibly distinct.
TREATMENT NOTE
Example: optional in Jeps.
Max size: 17
Taxa not included or not fully recognized in the Jepson Manual (Hickman1993) have a note here explaining inclusion in Calflora.
'Optional in JM' refers to taxa mentioned as possibly distinct in the Jepson Manual.
'CNPS' refers to taxa recognized in the CNPS's Inventory of Rare and Endangered Vascular Plants of California.
'Post-JM' refers to taxa recognized as occurring in California since publication of the Jepson Manual, both new taxa and range extensions.
Values include:
NATIVE
Example: t
Max Size: 1 Each taxon is classed as t (true) for Native or f (false)
for Non-Native (Introduced).
This data is based mainly on
comparison of Fred Hrusa's XWALK designation and the Calflora 'introduced'
designation, with individual review of conflicts and gaps.
LIFEFORM
Example: Perennial
Max size: 22
Each taxon is classed as one or more of the following:
- Fern
- Annual herb
- Perennial herb
- Biennial herb
- Tree
- Shrub
- Vine
followed by adjectives in parentheses--e.g. Shrub (stem succulent)
- aquatic
- biennial
- bulb
- carnivorous
- hemiparasitic
- mosslike
- rhizomatous
- parasitic
- mycoparasitic (previously "saprophitic")
- stem succulent
Transcribed from Lum/Walker codes except that occurrences of 'not
specified' were replaced with my interpretation of description in Munz
or the Jepson Manual. For taxa included in the CNPS Inventory (1994),
this field contains the lifeform descriptor used in that database
(some infrequently-used adjectives have been dropped). For taxa not
included in either Lum/Walker or the CNPS Inventory, this field
contains transcriptions of data from the USDA PLANTS database. All
Pteridophytes were reclassified as lifeform 'Fern' on 30 January 2001.
All Ericaceae (Monotropoideae) previously marked 'saprophytic'
reclassified as 'mycoparasitic' per communication with Garry Wallace
(Wallace 1975) on 13 March 2001.
US DISTRIBUTION
Example: CA Endemic
Max size: 20
Describes distribution beyond California.
For non-endemic taxa included in CNPS Inventory (1994), this field contains the non-California portion of the distribution entry from that database: standard 2-letter codes for U.S. states, also
COUNTY LIST (County Distributions)
Example: ALP ELD HUM
List of County regions where this species is, was, or may be present, based
on data included in the Calflora Occurrence Database.
| ALA | Alameda
|
| ALP | Alpine
|
| AMA | Amador
|
| BUT | Butte
|
| CAL | Calaveras
|
| CCA | Contra Costa
|
| COL | Colusa
|
| DNT | Del Norte
|
| ELD | El Dorado
|
| FRE | Fresno
|
| GLE | Glenn
|
| HUM | Humboldt
|
| IMP | Imperial
|
| INY | Inyo
|
| KNG | Kings
|
| KRN | Kern
|
| LAK | Lake
|
| LAS | Lassen
|
| LAX | Los Angeles
|
| MAD | Madera
|
| MEN | Mendocino
|
| MER | Merced
|
| MNO | Mono
|
| MNT | Monterey
|
| MOD | Modoc
|
| MPA | Mariposa
|
| MRN | Marin
|
| NAP | Napa
|
| NEV | Nevada
|
| ORA | Orange
|
| PLA | Placer
|
| PLU | Plumas
|
| RIV | Riverside
|
| SAC | Sacramento
|
| SBA | Santa Barbara
|
| SBD | San Bernardino
|
| SBT | San Benito
|
| SCL | Santa Clara
|
| SCR | Santa Cruz
|
| SDG | San Diego
|
| SFO | San Francisco
|
| SMT | San Mateo
|
| SHA | Shasta
|
| SIE | Sierra
|
| SIS | Siskiyou
|
| SJQ | San Joaquin
|
| SLO | San Luis Obispo
|
| SOL | Solano
|
| SON | Sonoma
|
| STA | Stanislaus
|
| SUT | Sutter
|
| TEH | Tehama
|
| TRI | Trinity
|
| TUL | Tulare
|
| TUO | Tuolumne
|
| VEN | Ventura
|
| YOL | Yolo |
| YUB | Yuba |
Example: m16m17m15 Medws
Max size: 42
List of two-digit codes each preceded by a 'm', no spaces (e.g. 'm13m27m29') Codes m01-m29 correspond to numbers used in Munz68 plant communities list (see Munz68 pp12-18 for descriptions)
|
| | m01 | Coastal Strand
| | m02 | Coastal Salt Marsh
| | m03 | Freshwater Marsh (note: this has been expanded to include all freshwater wetlands)
| | m04 | Northern Coastal Scrub
| | m05 | Coastal Sage Scrub
| | m06 | Sagebrush Scrub
| | m07 | Shadscale Scrub
| | m08 | Creosote Bush Scrub
| | m09 | Alkali Sink
| | m10 | North Coastal Coniferous Forest
| | m11 | Closed-cone Pine Forest
| | m12 | Redwood Forest
| | m13 | Douglas-Fir Forest
| | m14 | Yellow Pine Forest
| | m15 | Red Fir Forest
| | m16 | Lodgepole Forest
| | m17 | Subalpine Forest
| | m18 | Bristle-cone Pine Forest
| | m19 | Mixed Evergreen Forest
| | m20 | Northern Oak Woodland
| | m21 | Southern Oak Woodland
| | m22 | Foothill Woodland
| | m23 | Chaparral
| | m24 | Coastal Prairie
| | m25 | Valley Grassland
| | m26 | Alpine Fell-fields
| | m27 | Northern Juniper Woodland
| | m28 | Pinyon-Juniper Woodland
| | m29 | Joshua Tree Woodland
|
Other codes from Lum-Walker:
| m30 | weed, species characteristic of disturbed places,
| | m31 | agricultural weed,
| | m40 | escaped cultivar,
| | m41 | introduced plant which is becoming naturalized,
| | m42 | agricultural plant,
| | m50 | many plant communities,
| | m80 | community not given, species associated with a peculiar habitat.
|
Code added April, 2008
Plant community codes from CNPS INVENTORY (1994) were transcribed as follows, replacing Lum/Walker data for taxa included in both databases except as noted below:
LOWER ELEVATION LIMIT IN FEET
Example: 3500 Max size: 5 Richard Walker's compilation
of elevation limits for Sierran taxa, based on Munz (1968) distribution
descriptions, is the primary source of elevation data presented here. For
taxa not included in Walker's compilation, we present elevation values
from the Jepson Manual (1993), converted to feet. Converted values are
rounded only to the nearest foot to minimize compounding of rounding
errors if users convert all values to meters.
UPPER ELEVATION LIMIT IN FEET
Example: 5000
Max size: 5
same as above
ELEVATION SOURCE & ORIGINAL UNITS
Example: Munz (ft.)
Max size: 10
Source(s) of elevation data and unit of measure used in the original
data.
CNPS RARITY CODE
Example: 2B
Max size: 3
Values of 'Rarity' code from CNPS Inventory database (CNPS 2008).
Taxa not included in CNPS Inventory are designated 0 (not rare).
CALIFORNIA STATE LISTING STATUS
Max size: 64 char.
State listing codes from
California
Department of Fish and Game.
Date of listing included in parenthesis. Note field may include more
than one listing status, values are separated by a semicolon.
Data refreshed: January 2001.
FEDERAL LISTING STATUS
Max size: 64 char.
Federal listing codes from
California
Department of Fish and Game.
Date of listing included in parenthesis.
Date refreshed: January 2001.
HABITATS
Example: riparian
Max size: 57
Captures habitat descriptors from Lum/Walker and CNPS Inventory (1994) databases, includes the following keywords:
Data is not available for all taxa.
CDFA WEED STATUS
Example: A
Max size: 16
Weed status rating
codes from the California
Department of Food and Agriculture, Plant Health and Pest
Prevention Services.
Last updated in Calflora: October 2000 with classifications as of September 2000 (CDFA Weeds 2000).
|
Possible values:
| |
A
|
"An organism of know economic importance subject to state
(or commissioner when acting as a state agent) enforced action
involving: eradication, quarantine, containment, rejection, or other
holding action."
| |
B
|
"An organism of known economic importance subject to: eradication,
containment, control or other holding action at the discretion of the
individual county agricultural commissioner." OR "An organism of know
economic importance subject to state endorsed holding action and
eradication only when found in a nursery."
| |
C
|
"An organism subject to no state enforced action outside of nurseries
except to retard spread. At the discretion of the commissioner." OR
"An organism subject to no state enforced action except to provide for
pest cleanliness in nurseries."
| |
D
|
"No action. (Parasites, predators, and organisms of little or no economic importance)."
| |
Q
|
"An organism or disorder requiring temporary "A" action pending
determination of a permanent rating. The organism is suspected to be
of economic importance but its status is uncertain because of
incomplete identification or inadequate information. In the case of
an established infestation, at the discretion of the Assistant
Director for Plant Industry, the Department will conduct surveys and
will convene the Division Pest Study Team to determine a permanent
rating."
|
FEDERAL NOXIOUS WEED STATUS
Example:
Max size: 34
Weed status rating codes from the United States Department of Agriculture Animal and Plant Health Inspection Service.
Last updated in Calflora: October 26, 2000 with ratings as of September 8, 2000 (USDA 2000)
Values:
not listed
y
y (author typo in their file)
y (author diff disregarded)
PLANTS CODE
Example: ABCO
Max size: 7
Code from USDA PLANTS for this name. May bridge different spellings between Calflora and PLANTS.
FWS WETLAND INDICATOR
Example: OBL
Max size: 8
The likelihood of a species occurring in wetlands versus non wetlands in
California as determined by the U.S. Fish and
Wildlife Service. Note that indicator categories do not refer to
degrees of wetness. Some obligate wetland species
occur in wetlands which are only temporarily or seasonally flooded.
Data provided by Andrew Cruz and Buck Reed, U.S. Fish and Wildlife
Service, National Wetlands Inventory, October 1997
(
further information).
Indicator categories:
An asterisk (*) following a regional Indicator identifies tentative assignments based on limited information from which to determine the indicator status.
A positive (+) or negative (-) sign is used with the Facultative
Indicator categories to more specifically define the regional frequency of
occurrence in wetlands. The positive sign indicates a frequency toward the
higher end of the category (more frequently found in wetlands), and a
negative sign indicates a frequency toward the lower end of the category
(less frequently found in wetlands).
CALIFORNIA INVASIVE PLANT COUNCIL PLANT STATUS and URL
Example: 4:Ulmus%20pumila.pdf
Weed status code and URL from the California Invasive Plant Council.
In the example above, 4 is the status code.
OCCURRENCE DATABASE TOTAL COUNT
Example: 1236
The total count of records in the Calflora Occurrence Database that are unambiguously assignable to this taxon (including synonyms and included sub-taxa).
ITIS TAXONOMIC SERIAL NUMBER (TSN)
Example: 34123
The
ITIS Taxonomic Serial Number for this taxon.
ONE COMMON NAME
Example: moutain dandelion
A single common name for the plant.
ACTIVE
Example: f
Is this record active? When there is a name change,
and several nomenclature authorities agree on the new name,
then Calflora will create a new record for the new name,
and set active = 'f' on the old record.
SERPENTINE AFFINITY
Example: 2.6 (strong indicator)
The mean ultramafic affinity
for this taxon, as per
Safford et al 2005.
The numbers, on a scale from 1.0 to 6.25, are interpreted as follows:
| >= 5.5 |
strict endemic |
164 taxa with 95% of their occurrances on ultramafics |
< 5.5, >= 4.5 |
broad endemic |
82 taxa with 85-94% of their occurrances on ultramafics |
< 4.5, >= 3.5 |
transition from broad endemic to strong indicator |
71 taxa with 75-84% of their occurrances on ultramafics |
< 3.5, >= 2.5 |
strong indicator |
123 taxa with 65-74% of their occurrances on ultramafics |
< 2.5, >= 1.5 |
weak indicator |
150 taxa with 55-64% of their occurrances on ultramafics |
< 1.5, >= 1.0 |
weak indicator / indifferent |
79 taxa with 50-54% of their occurrances on ultramafics |
Field List:
calrecnum
calname
taxon
genus
species
author1
rank
ssp_var
author2
family
parent_child
parent_rec
parent_name
treatment
category
lifeform
native
us_dist
plant_community
habitat_descriptors
countylist
lower_elev_ft
upper_elev_ft
elev_src_units
rarity
ca_status
fed_status
cdfa_weed_status
fed_nox_weed
wetland
plants_code
calipc
itis_tsn
occ_count
common
active
um_affinity
|
|