Dataset: wdt

Dean W. Taylor Herbarium Specimens Last Modified:
Modified By: Tony Morosco
Original Data provided in the following format:

Field Name field type
Family text
Name text
State text
County text
Date date
Collector text
Location text

'fulname' was parsed into component parts. (genus, specific epithet, species author, etc..)
No geographic coordinates were provided with data (latitude/longitude, UTM, or Meridian/Township/Range/Section), but nearly all records had a county name associated with them.

Number of records Received: 6121
Number of Records posted: 6091
Records where county did not match a known California County filtered out (30).

   conventions: * = Denotes fields that are required for CalFlora Database
Blank values in 'Data' column = data not available
Data tables: [TableName]![FieldName]
Source data --> converted to result data by matching value in source to result in named table.
required? CalFlora field name type Data
* seq_num SERIAL UNIQUE, serial number (unique across datasets)
  dataset varchar(16), dataset: "wdt"
  source varchar(255), source: "Dean W. Taylor Herbarium Specimens"
  source_id varchar(32), IIf(IsNumeric([WDT-"SPECIMEN"]![CNUM]),[WDT-"SPECIMEN"]![CNUM],Null)
  dset_seq_num integer, dset_seq_num: [WDT-"SPECIMEN"]![dset_seq_num]
(serial number unique to dataset)
  orig_nomen varchar(64), "Jepson"
  index_date date, "1999-05-14"
  observ_type varchar(32), "undirectedsearch"
  doc_type varchar(16), "specimen"
  rslvd_taxon varchar(128), Trim([Deans_names_split]![genus] & " " & Trim([Deans_names_split]![Hybrid_species] & " ") & [Deans_names_split]![Specific Epithet] & " " & [Deans_names_split]![infraspecific rank] & " " & [Deans_names_split]![infraspecific epithet])
  rslvd_genus varchar(64), [Deans_names_split]![genus]
  rslvd_specif_epith varchar(64), [Deans_names_split]![Specific Epithet]
  rslvd_species_auth varchar(128), [Deans_names_split]![Species Author]
  rslvd_infra_rank varchar(4), [Deans_names_split]![infraspecific rank]
  rslvd_infra_epith varchar(64), [Deans_names_split]![infraspecific epithet]
  rslvd_infra_author varchar(128), [Deans_names_split]![infraspecific author]
  namesoup varchar(255), [Deans_names_split]![orig_name] & " " & Trim([Deans_names_split]![genus] & " " & Trim([Deans_names_split]![Hybrid_species] & " ") & [Deans_names_split]![Specific Epithet] & " " & [Deans_names_split]![infraspecific rank] & " " & [Deans_names_split]![infraspecific epithet])
  county char(3), [WDT-"SPECIMEN"]![COUNTY] --> [Countycodes]![FIPCode]
  lat real, --
  long real, --
  utm_zone integer, --
  utm10_x real, --
  utm10_y real, --
  elevation integer, --
  elev_source varchar(16), --
  site_info_avail varchar(255) --
  plot_id varchar(32), --
  plot_size real, --
  observ_date date, IIf(IsDate([WDT-"SPECIMEN"]![DATE]),Year([WDT-"SPECIMEN"]![DATE]) & "-" & IIf(Month([WDT-"SPECIMEN"]![DATE])<10,"0" & Month([WDT-"SPECIMEN"]![DATE]),Month([WDT-"SPECIMEN"]![DATE])) & "-" & IIf(Day([WDT-"SPECIMEN"]![DATE])<10,"0" & Day([WDT-"SPECIMEN"]![DATE]),Day([WDT-"SPECIMEN"]![DATE])),Null)
  date_prec varchar(16), IIf(IsDate([WDT-"SPECIMEN"]![DATE]),"exactday","nodate")
  auth_collector varchar(255), Trim([WDT-"SPECIMEN"]![Collector] & " " & [WDT-"SPECIMEN"]![CNUM])
  collctn varchar(255), "Some specimens deposited at University and Jepson Herbaria"
  orig_name varchar(255), [WDT-"SPECIMEN"]![Name]
  orig_plants char(8), --
  orig_adp char(8), --
  orig_location varchar(255), [Countycodes]![FIPCode]
  orig_loc_form varchar(16), IIf(IsEmpty([Countycodes]![FIPCode]),Null,"county")
  orig_loc_prec real, --
  orig_loc_desc varchar(255), "State of " & [WDT-"SPECIMEN"]![STATE] & ", " & [WDT-"SPECIMEN"]![LOCATION]
  orig_county varchar(32), [WDT-"SPECIMEN"]![COUNTY]
  orig_habitat varchar(255), --
  orig_elev integer, --
  orig_elev_form char(8), --
  orig_date varchar(32), [WDT-"SPECIMEN"]![DATE]
  u_rslvd_taxon varchar(255), uc[rslvd_taxon]
  u_orig_loc_desc varchar(255) uc[orig_loc_desc]