Bug #2615
closedFailure to map WEWO and other non-NCU series in Specify
0%
Description
The herbarium has a small but growing collection of NCSU collections. These appear on the map, but not in the list of collections. We think the reason for not appearing in the collections is that these have a “series†value not equal to NCU. Originally this test was put in place to skip over deaccessioned collections. A couple changes are in order here.
The “series†variable now contains 3 possible values = ~ NCU, NCSU, NCU-deaccessessioned. As these are all valid specimens they should all be mapped and all should be listed under specimens.
At present the NCSU specimens in specify are mapped as NCU specimens. For mapping purposes lump these NCSU specimens in the NCU Specify database with the legacy NCSU collections now in the access database.
For mapping of NCU-deaccessioned collections, shown them in Red as specimens, but as a third category of specimens called “Otherâ€.
In specimen details show BOTH Herbarium code and ID. NCSU and NCU are valid herbarium codes. For deaccessioned collections, the herbarium code is shown in the deaccession table as text1. For deaccessioned specimens the ID number should be nul (not the NCU number).
Updated by Michael Lee over 17 years ago
This bug is originally from "other ideas and observations from Peet and Weakley"
Updated by Xianhua Liu over 17 years ago
The reason NCSU collections do not show up in "Collections" is that they are not stored in Specify database as NCU specimens. There is not detailed information currently available in our database. Basically, the data for NCSC records are not different from that for USDA plants and RAB and others. There is no quick way to get them show up as collections.
Updated by Robert Peet over 17 years ago
This bug refers to those NCSU specimens stored in the Specify database (a small number) and not to the larger number referenced otherwise. These can be idnetified followign the description originally indicated for this bug.
Updated by Robert Peet over 17 years ago
Example = Brassica nigra, which is an NCSC specimen in the NCU SPecify database. The colelctiosn show up as speciments at NCU on the map, but are not listed as specimens in the specimen list, which makes for a two-way error.
Updated by Xianhua Liu over 17 years ago
changed in "http://152.2.14.231/website/NCFloraTest/". Now collections show up for any herbarium collections. We need to show the herbarium where the specimens are from. Lisa, could you please tell me which filed in which table containing the herbarium information. Thanks.
Updated by Lisa Giencke over 17 years ago
The Series field tells us which herbarium is in possession of a certain specimen. The table CatalogSeries shows what series we are currently using, and this information is linked to the CollectionObjectCatalog table by CatalogSeriesID.
(In reply to comment #5)
changed in "http://152.2.14.231/website/NCFloraTest/". Now collections show up
for any herbarium collections. We need to show the herbarium where the
specimens are from. Lisa, could you please tell me which filed in which table
containing the herbarium information. Thanks.
Updated by Xianhua Liu over 17 years ago
1. changed the querying class at the server side
2. Changed the html pages (both colletions and images) to show series information: added series prefix before catalog id and added a new field for series names, such as NCU.
3. email sent to Hinar to update the classes
4. Before classes updated, you can check the result from http://152.2.14.231/website/NCFloraTest
Updated by Robert Peet over 17 years ago
Much progress has been made.
One problem remains. Although NCSU collections in SPECIFY show up correctly tagged in the specimens list, they appear as NCU specimens on the map. We need to flag them as NSCU on the map, combining htem into the same pile as the static NCSU records
Updated by xianhua liu over 17 years ago
fixed:
1. querying function changed at the server side
2. sent email to Hinar to update the new classes
3. please check the result on the testing website: 152.2.14.231/website/NCFloraTest before the herbarium seflora is updated.
Xianhua
Updated by Robert Peet over 17 years ago
Looks good. Brassica nirgra now shows as NCSU.
I cannot fully test this feature until we have a species with different NCSU records in both the static file and SPECIFY. I think I have to turn this over to Lisa to find a species to database for NCSU that has at least one NCSU record in SPECIFY, but not all the NCSU records in SPECIFY.
Updated by Lisa Giencke over 17 years ago
I think that there will not be a case that we have a species in both the static file and in Specify. The Specify records pick up where they left off databasing the records in the static file.
(In reply to comment #10)Looks good. Brassica nirgra now shows as NCSU.
I cannot fully test this feature until we have a species with different NCSU
records in both the static file and SPECIFY. I think I have to turn this over
to Lisa to find a species to database for NCSU that has at least one NCSU
record in SPECIFY, but not all the NCSU records in SPECIFY.
Updated by Lisa Giencke over 17 years ago
We have just added another Series - WEWO. I created a dummy record of it, Viola pedata in Orange Co., for testing purposes. The atlas is ignoring it for mapping purposes, but is including it on the specimen tab. Will it be set up to map all series so that the programming doesn't have to be fiddled with each time we add a series? Elon is a definite possibility to be added as a series in the future, so this certainly isn't the end of series additions.
Updated by Robert Peet about 17 years ago
County records from the WEWO series are not being mapped, but do show up in the specimens, and when one clicks on a county for the records.
Need to fix programming so that when add series in the future, the mapping will occur.