CCH1 Recent Updates

Updates for 2023

  March 1  —  Bug fixes, Major Feature Update

1.  The search and list page has been redesigned due to recent hacker and web crawler attacks overloading the CCH1 server

 — The search page will block attackers by not allowing users to search CCH1 more than 5 times in a few seconds
 — These same limitations are present on the other Berkeley Natural History Museum websites
 — The output and format of the query results page has been greatly exapanded and new features added
 — Most of the features from the original CCH1 results page are now active

2.  County distribution maps from the ICPN now read live from the current version of CCH1

 — see this example page for Sedum kiersteadiae
 — clicking on the blue dots searches the current CCH1 (not the archived pre-2018 CCH)
3.  The first "F" column (Flag Color/Checkbox) on the Results page can be sorted according to flag color

 — sort order --> yellow (if applicable), blue, green, black, purple, no color
 — This column used to sort by accession number due to the checkbox value
 — This field now has multiple-functionalities
4.  Downloading Search Results in Excel-compatible CSV text format has been re-developed
5.  An anonymous download user survey (i.e. how are you using this data) has been created
6.  Bug Fixes:

 — numerous bug fixes resulting from the changeover to a new database have been fixed

Updates for 2022

  August 1  —  Bug fixes, Major Feature Update

1.  The CCH1 database has been moved to Maria DB

 — this software is more IT-secure than SQLite
 — CCH1 resources are being redeveloped for this new database
2.  Bug Fixes:

  July 11  —  Bug fixes, Major Update

1.  The following are welcomed as data providers, newly added from CCH2 since March 2022:
    — INF — Inyo National Forest Herbarium, Bishop
    — SPIF — Sierra Pacific Industries-Forestry Herbarium
   
2.  Update statistics:
 — 2,427,527 records in CCH1
 —   18,045 records newly added to CCH1 since last update
 —    7,224 records marked as cultivated (purple flags)
 —    XXXX records with new determinations last update
    • Summary list of counts for each herbarium can be found here.

3.  Georeference statistics:
 — 
 —      691,161 coordinates corrected using CCH1 resources
 —    68,033 records with county mapped to by the georeference is different than label county
 —    22,248 ambiguous or unmappable localities with georeferences nulled (black flags)
 —   181,399 yellow-flagged records
 —     XXXXX CCH1 2018 blue flags now yellow flagged
 —     XXXXX new specimens yellow flagged
 —      XXXX CCH1 2018 yellow flags now blue flagged
 —   XXXXX new specimens blue flagged
 Record count: 2,427,527 (XXXXXXXXX of which are georeferenced)

4.  Corrections:
 —XXXXX Taxon name errors corrected
 —  1789 elevations higher or lower than the state maximum/minimum (orange flags)
 —  XXXX elevations corrected (minor typos and errors corrected)
 —    57 collection dates flagged as before 1800 or after current year
 —  24,717 County names corrected from a total of 2,389,648 records from CCH2 with county values
    • Summary list of Verbatim Counties and Counts can be found here.

  April 22  —  Bug fixes, Major Feature Update

1.  The ability to use BerkeleyMapper to map the search results has been re-developed
2.  Bug Fixes:

 — Results are now sortable by collection number; this has been bugged in previous versions.

  March 1  —  Bug fixes, Major Update

1.  The following are welcomed as data providers, newly added from CCH2 since December 2021:
    — ELH — Eagle Lake Field Office Herbarium
    — GDRC — Green Diamond Resource Co. Herbarium
    — KNFY — Klamath National Forest Herbarium
    — LVNP — Lassen Volcanic National Park Herbarium
    — NCC — Sonoma State University Herbarium Herbarium
    — PPWD — Stephen J. Barnhart Herbarium at Pepperwood Preserve
    — PUA — Pacific Union College Herbarium
    — SSRD — Salmon-Scott Ranger District Herbarium
    — STNF — Shasta-Trinity National Forest Herbarium
    — THRI — Sequoia and Kings Canyon National Parks Herbarium
   
2.  Update statistics:
 — 2,409,482 records in CCH1
 —   98,698 records newly added to CCH1 since last update
 —    8,968 records with new determinations last update
 — XXXXX elevations higher or lower than the label county maximum (orange flags)

3.  Georeference statistics:
 — 
 —      4447 coordinates corrected using CCH1 resources
 —    15342 inaccurate georeferences nulled (black flags)
 —      2503 records marked as cultivated (purple flags)
 —   143449 yellow-flagged records (11% increase compared to CCH1 2018)
 —     20996 CCH1 2018 blue flags now yellow flagged
 —     23328 new specimens yellow flagged
 —      6302 CCH1 2018 yellow flags now blue flagged
 —   227330 new specimens blue flagged
 Record count: 2,313,930 (1,882,441 of which are georeferenced)

4.  Corrections:
 —21842 Taxon name errors corrected
 —  1822 elevations corrected
 —    70 collection dates flagged as before 1800 or after current year
 —  9209 County names corrected from a total of 2313902 records from CCH2 with county values
    • Summary list of Verbatim Counties and Counts can be found here.

  January 31  —  feature restored

1.  The processing script used to create Hartman Maps (georeference progress dot maps) has been entirely re-written. New maps can now be access on this page, which has also been updated (https://ucjeps.berkeley.edu/consortium/georef_map.html)
The red-dot map on the About page has also been updated. All of these maps show CCH2 data now.

  January 5  —  Bug fixes

1.  A bug in the SQL search for names at the genus-level was fixed, all specimens having a determination that starts with the matching genus name will now display in search results. Genus-only searches were coming up with no records previously due to updates in December.

Updates for 2021

  December 6  —  new and restored features

1.  New Records log for each update is active again (https://ucjeps.berkeley.edu/consortium/new_log_name.html)
2.  New Determinations log for each update is active again (https://ucjeps.berkeley.edu/consortium/new_det_log_name.html)
3.  Name Change log for each update added as a new feature (https://ucjeps.berkeley.edu/consortium/name_change_log.html)

 — All three links to the most current update logs can be found under the webpage header "Update History/Recent Update Logs". A comprehensive log of all CCH1 updates from 2008 onward can be found in the header link "Update History/CCH1 Record Log Archive" which leads to this webpage: https://ucjeps.berkeley.edu/consortium/record_log_archive.html.
 — Name changes used to happen in the background in the original CCH. Scripts altered problem names during the loading process. Many changed names were reported to herbaria in the error logs. None of these changes were apparent online to users. Most of these problem names are unpublished names on the herbarium label and are still the currrent ID even in CCH2. In the past, unpublished names were altered to just the genus or skipped entirely. Since the original CCH did not have a comprehensive determination history field, one could not determine if a specimen name was changed from that in the home database This is no longer done in CCH1. Hcanged names can be found on the Name Change log (see link above). The ICPN keeps track of unpublished or illegitimate names researched by the editor. That tracking is now applied in CCH1. If a unpublished name is not in the ICPN, it is placed into a Not In EFlora (NIEF) nomen_rej.txt holding table and marked as an unpublished name in the details page. For example see the many unpublished Trifolium species names by Randall Morgan, including Trifolium fax - (UCSC100002137.)

  November 30  —  new features

1.  First loading date and determination added to the detailed specimen record.
    — CCH1 has a long-recorded history of the names and the dates for each specimen was loaded into the database. Eventually, there will be a database determination log avalable for all specimens, showing the date for each time a name was changed for a CCH1 record. The first step of this process has been to add the date for the first time a specimen was loaded into the original CCH and determination for that first load.
   

  November 1  —  Bug fixes, Major Update

1.  The following are welcomed as data providers, newly added from CCH2 since October 1st:
    — MCCC — Mendocino College Coast Center Herbarium
    — SFSU — Harry D. Thiers Herbarium, San Francisco State University
    — SHTC — California State University, Stanislaus Herbarium
    — SPIF — Sierra Pacific Industries-Forestry Herbarium
   
2.  Update statistics:
 — 2313930 records added to CCH1
 —   9211 records newly added to CCH1 since last update
 —    521 records with new determinations last update
 — XXXXX elevations higher or lower than the label county maximum (orange flags)

3.  Georeference statistics:
 — 
 —      4447 coordinates corrected using CCH1 resources
 —    17564 inaccurate georeferences nulled (black flags)
 —      2503 records marked as cultivated (purple flags)
 —   143449 yellow-flagged records (11% increase compared to CCH1 2018)
 —     20996 CCH1 2018 blue flags now yellow flagged
 —     23328 new specimens yellow flagged
 —      6302 CCH1 2018 yellow flags now blue flagged
 —   227330 new specimens blue flagged
 Record count: 2,313,930 (1,882,441 of which are georeferenced)

4.  Corrections:
 —19397 Taxon name errors corrected
 —  1747 elevations corrected
 —    60 collection dates flagged as before 1800 or after current year
 —  9525 County names corrected from a total of 2313902 records from CCH2 with county-level data
    • Summary list of Verbatim Counties and Counts can be found here.

  October 28  —  Bug fixes

1.  Specimens with unpublished taxon names used to be tossed out completely or modified to just the genus in CCH1 prior to 2018. One goal of the new CCH1 is to be more transparent with changes made to data. For the past two months, unpublished taxon names were replaced with a phrase from the ICPN used for names studies by editors: unpublished, invalidly published, illegitimate, or rejected name. However, not having a name in the display name field created bugs in searches, sorting, and other website functions. This phrase is better placed in status, even though many of these names have no offical ICPN status and have never been vetted by Jepson Flora editors. Now, the unpublished name is used as a display name and a NIEF (Not In EFlora) status phrase is provided for the eflora status. None of these can be given an actual accepted name because Jepson Flora editors have not investigated them, unlike similar unpublished names treated in ranks 1b, 2b, etc in the ICPN.

  October 10  —  Bug fixes

1.  Queries of specimens determined as an eflora accepted name that have no synonyms (such as Eriodictyon capitatum) were resulting in a query of all specimen records. This bug has been fixed. Searches using eflora names without synonyms now appear to display correctly in search results.

  October 5  —  Bug fixes

1.  A bug in the SQL search for synonyms was fixed, synonyms will now display in search results.

  October 1  —  Launch of the new CCH1

1.  The new CCH1 website is now live.
2.  The CCH1 database now contains a CCH2 data upload from September 28th.
3.  All 2018 data from the old CCH1 has been replaced and updated.
4.  The following are welcomed as new data providers, added since the last old-format refresh in 2018:
    — BSCA — Colorado Desert District, California Department of Parks and Recreation Herbarium
    — BLMRD — BLM Redding Field Office
    — CSLA — California State University, Los Angeles Herbarium
    — FSC — Fresno State Herbarium
    — LOB — Long Beach Herbarium, California State University
   
5.  Update statistics:
 — 2304590 records added to CCH1
 —   204238 records newly added to CCH1 since September 2018
 —    93796 records with new determinations since September 2018
 — XXXXX elevations higher or lower than the label county maximum (orange flags)

6.  Georeference statistics:
 — 1616194 records with decimal Lat/Long, processed from coordinates on the label
 —      4447 coordinates corrected using CCH1 resources
 —    17564 inaccurate georeferences nulled (black flags)
 —      2503 records marked as cultivated (purple flags)
 —      XXXXX yellow-flagged records
 — XXXXX georeferences outside the label county(red flags)

7.  Corrections:
 — 1729 elevations corrected
 — 94937 County names corrected from a total of 2304588 records from CCH2 with county-level data
    • Summary list of Verbatim Counties and Counts can be found here.

Updates for 2020

  May 1  —  CCH1 redevelopment

1.  The redevelopment of CCH1 started with the creation of a new about and search page layout. Redevelopment will continue during the shelter-at-home order caused by the COVID19 pandemic stage.

Updates for 2019

  July 1  —  CCH1 redevelopment

1.  CCH2 development is mostly complete with the final loading of all CCH member databases. The redevelopment of CCH1 is now in the early planning stages.

Updates for 2018

  September 20  —  Bug and georef. fixes

1.  Last update before uploading of data to CCH2.

• Record count: 2,320,817 (1,778,243 of which are georeferenced)

  July 12  —  SEINET

1.  SEINET updated; additional error and bug fixes.

•    1093633 Records with decimal Lat/Long, processed from coordinates on the label.
  
•   598508 georeference records from the Primary Buffer.
•    81399 georeference records from the Baldwin et al 2017.
•      3386 georeference records from other user submitted files.
•        3451 georeference records from the Mexico buffer.
•   127703 yellow-flagged georeference records.
• Record count: 2,323,435 (1,780,418 of which are georeferenced)