Data Set: inhs
Last Modified: 2 November 1999
Modified By: Tony Morosco
* = Denotes fields that are required for CalFlora Database
Blank values in Data Entered = data not available
Original Fields sent in FileMaker Pro File:
Family# text Fam. text Genus text Species text Auth. text S/V/F text Taxon text Author text Cultivar text Co. text T/R/S text Lat/Long text Locality text Habitat text Collector text Coll.# text Date text Det. text Acc. No. text Label? text State text calccountytext Serial No number Country text Status text
Notes:
Cultivar is blank for all Californian records.
35 of the original 1171 records are in face from Baja California. These were deleted from ingested data, leaving 1136 records.
8 duplicate accession numbers were found and left intact. Accession number can not be used for dataset unique ID number.
Infraspecific ranks in the form of "ssp." and "var." and one "forma".
4 records were deleted from original data since they were erroreous duplicates. (see bottom for email)
|
required? |
CalFlora field name |
Type |
Data |
|
* |
seq_num |
SERIAL UNIQUE, |
Unique ID number across datasets |
|
|
dataset |
varchar(16), |
"inhs" |
|
|
source |
varchar(255), |
"Illinois Natural History Survey Herbarium Specimens" |
|
|
source_id |
varchar(32), |
[inhs - specimens]![ACC__NO_] (Accession Number) |
|
|
dset_seq_num |
integer, |
[inhs - specimens]![dset_seq_num] (CalFlora generated: duplicates and nulls in INHS Accession Number) |
|
|
orig_nomen |
varchar(64), |
"unknown" |
|
|
index_date |
date, |
"1999-11-01" |
|
|
observ_type |
varchar(32), |
"undirectedsearch" |
|
|
doc_type |
varchar(16), |
"specimen" |
|
|
rslvd_taxon |
varchar(128), |
[taxon names]![taxon] (taken from split fields in [inhs - specimens] but "forma" folded into "f." |
|
|
rslvd_genus |
varchar(64), |
[inhs - specimens]![GENUS] |
|
|
rslvd_specif_epith |
varchar(64), |
iif([inhs - specimens]![S_V_F] = "forma", "f.", [inhs - specimens]![S_V_F] ) |
|
|
rslvd_species_auth |
varchar(128), |
[inhs - specimens]![TAXON] |
|
|
rslvd_infra_rank |
varchar(4), |
IIf([inhs - specimens]![S_V_F]="forma","f.",[inhs - specimens]![S_V_F]) |
|
|
rslvd_infra_epith |
varchar(64), |
[inhs - specimens]![TAXON] |
|
|
rslvd_infra_author |
varchar(128), |
[inhs - specimens]![AUTHOR] |
|
|
namesoup |
varchar(255), |
[inhs - specimens]![FAM_] & " " & [inhs - specimens]![GENUS] & " " & [inhs - specimens]![SPECIES] & " " & [inhs - specimens]![S_V_F] & " " & [inhs - specimens]![TAXON] & " " & [taxon names]![taxon] |
|
|
county |
char(3), |
[inhs - specimens]![CO_] --> [Countycodes]![FIPCode] |
|
|
lat |
real, |
IIF( [cleaned LL-DD]![LAT-DD] is not null, [cleaned LL-DD]![LAT-DD], IIF( [cleaned TRS]![lat] is not null, [cleaned TRS]![lat] , null)) |
|
|
long |
real, |
IIf([cleaned LL-DD]![LONG-DD] Is Not Null,[cleaned LL-DD]![LONG-DD],IIf([cleaned TRS]![long] Is Not Null,[cleaned TRS]![long],Null)) |
|
|
utm_zone |
integer, |
- |
|
|
utm10_x |
real, |
- |
|
|
utm10_y |
real, |
- |
|
|
elevation |
integer, |
[Elevation-extract]![ELEV] extracted from locality field with customized perl script. |
|
|
elev_source |
varchar(16), |
[Elevation-extract]![ELEV_SRC] calculated from locality field with customized perl script. |
|
|
site_info_avail |
varchar(255) |
[inhs - specimens]![HABITAT] |
|
|
plot_id |
varchar(32), |
- |
|
|
plot_size |
real, |
- |
|
|
observ_date |
date, |
[Cleaned_dates]![YYYY-MM-DD] extracted from [inhs - specimens]![DATE] with customized perl script |
|
|
date_prec |
varchar(16), |
[Cleaned_dates]![DATE_PREC] calculated from [inhs - specimens]![DATE] with customized perl script |
|
|
auth_collector |
varchar(255), |
Trim([inhs - specimens]![COLLECTOR] & " " & [inhs - specimens]![COLL__] ) |
|
|
collctn |
varchar(255), |
- |
|
|
orig_name |
varchar(255), |
Trim([inhs - specimens]![GENUS] & " " & [inhs - specimens]![SPECIES] & " " & [inhs - specimens]![AUTH_] & " " & [inhs - specimens]![S_V_F] & " " & [inhs - specimens]![TAXON] & " " & [inhs - specimens]![AUTHOR] & " " & [inhs - specimens]![CULTIVAR] ) |
|
|
orig_plants |
char(8), |
- |
|
|
orig_adp |
char(8), |
- |
|
|
orig_location |
varchar(255), |
IIf(Not IsEmpty([cleaned LL-DD]![ID]),"lat= [cleaned LL-DD]![LAT-DD] , long= [cleaned LL-DD]![LONG-DD]",IIf(Not IsEmpty([cleaned TRS]![dset_seq_num]),[cleaned TRS]![cleaned trs],IIf(Not IsEmpty([inhs - specimens]![CO_]),[inhs - specimens]![CO_],Null))) |
|
|
orig_loc_form |
varchar(16), |
IIF(not IsEmpty ([cleaned LL-DD]![ID]), "lldd" , IIF(not IsEmpty( [cleaned TRS]![dset_seq_num] ), "mtrs" , IIF(not IsEmpty([inhs - specimens]![CO_] ), "county" , null))) |
|
|
orig_loc_prec |
real, |
- |
|
|
orig_loc_desc |
varchar(255), |
[inhs - specimens]![LOCALITY] |
|
|
orig_county |
varchar(32), |
[inhs - specimens]![CO_] |
|
|
orig_habitat |
varchar(255), |
[inhs - specimens]![HABITAT] |
|
|
orig_elev |
integer, |
[Elevation-extract]![ORIG_ELEV] extracted from locality field with customized perl script. |
|
|
orig_elev_form |
char(8), |
[Elevation-extract]![ORIG UNITS] calculated from locality field with customized perl script. |
|
|
orig_date |
varchar(32), |
[inhs - specimens]![DATE] |
|
|
u_rslvd_taxon |
varchar(255), |
|
|
|
u_orig_loc_desc |
varchar(255) |
|
Date: Tue, 2 Nov 1999 11:22:34 -0800
From: "Kenneth R. Robertson" <krrobert@uiuc.edu>
To: Tony Morosco <waltony@cs.berkeley.edu>
Subject: Re: INHS herbarium records
Hi Tony,
Sorry for the problems with the info we sent you. There were some errors
in the database, which we have now corrected.
Acc# Taxon
11587 Potamogeton pectinatus
This is a duplicated record, there is only one specimen with this number in
the herbarium.
171535 Centaurea solstitialis
This is a duplicated record, there is only one specimen with this number in
the herbarium.
171537 Artemisia californica
171537 Artemisia biennis
There is no specimen of Artemisia biennis with this accession number,
somehow the specific epithet got changed when an incorrect duplicate record
was made for A. californica.
171572 Eremacarpus setigerus
This is a duplicated record, there is only one specimen with this number in
the herbarium.
Ken
-=-=-=-=-=-=-=-=-=-
Kenneth R. Robertson, Ph.D.
Plant Systematist
Center for Biodiversity
Illinois Natural History Survey
607 E. Peabody Drive
Champaign, IL 61820 USA
217 244-2171 (voice); 217 333-4949 (Fax)