Code here written by Erica Krimmel.
Here, we explore a situation where data from the provider were modified by iDigBio during ingestion as part of its data quality processing. Understanding how data were modified can help collections staff identify updates that need to be made on their specimen records as well as issues that the aggregator may need to remedy in their data quality processing.
General Overview
In this demo we will cover how to:
- Write a query to search for specimens using
idig_search_records - Compare the difference between the data providers and aggregators
data
- Identify specimen records that need to be reviewed
Write a query to search for specimen records
First, let’s find all the specimen records from a given recordset,
e.g. all of the records published by a single collection. Do this using
the idig_search_records function from the
ridigbio package. You can learn more about this function
from the iDigBio API
documentation and ridigbio
documentation. In this example, we want to start by searching for
specimens from the Invertebrate
Paleontology collection at the Natural History Museum of Los
Angeles.
# Edit the value after `recordset` to search for data from a different collection
# and the fields (e.g. `uuid`) in `fields` to adjust the columns returned in
# your results
df_names <- idig_search_records(rq = list(recordset = "5082e6c8-8f5b-4bf6-a930-e3e6de7bf6fb"),
fields = c("uuid",
"data.dwc:occurrenceID",
"data.dwc:catalogNumber",
"family",
"data.dwc:family",
"genus",
"data.dwc:genus",
"specificepithet",
"data.dwc:specificEpithet",
"infraspecificepithet",
"data.dwc:infraspecificEpithet",
"data.dwc:scientificName",
"flags"),
# Set the limit for how many records are returned by the
# search to a low number for the purposes of this demo
limit = 1000) %>%
# Rename fields to more easily reflect their provenance (either from the
# data provider directly or modified by the data aggregator)
rename(occurrenceID = `data.dwc:occurrenceID`,
catalogNumber = `data.dwc:catalogNumber`,
provider_family = `data.dwc:family`,
provider_genus = `data.dwc:genus`,
provider_species = `data.dwc:specificEpithet`,
provider_subspecies = `data.dwc:infraspecificEpithet`,
provider_scientificName = `data.dwc:scientificName`,
aggregator_family = `family`,
aggregator_genus = `genus`,
aggregator_species = `specificepithet`,
aggregator_subspecies = `infraspecificepithet`) %>%
# Reorder columns for easier viewing
select(uuid, occurrenceID, catalogNumber, aggregator_family, provider_family,
aggregator_genus, aggregator_species, aggregator_subspecies,
provider_genus, provider_species, provider_subspecies,
provider_scientificName, flags)Here is what our query result data looks like, with the data from the aggregator’s processing highlighted in red text:
| uuid | occurrenceID | catalogNumber | aggregator_family | provider_family | aggregator_genus | aggregator_species | aggregator_subspecies | provider_genus | provider_species | provider_subspecies | provider_scientificName |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 000153f6-4861-4219-ac9e-f0d0f62fe60b | 0b6e2924-4b1a-4a18-a532-6c2d95962e95 | LACMIP 42500.14 | NA | NA | NA | NA | NA | NA | NA | NA | Clypeasteroida indet. |
| 000249c8-5c27-4292-94a7-1802f4d1ca4b | 37ae5d77-073e-4713-aa54-92d7e0616fcf | LACMIP 16817.200 | borsoniidae | Borsoniidae | ophiodermella | NA | NA | Ophiodermella | NA | NA | Ophiodermella sp. |
| 00028446-c91d-47f2-b036-2134f011e282 | 2933a74c-faeb-4519-9117-6000c9f43926 | LACMIP 2657.24 | mactridae | Mactridae | tresus | nuttallii | NA | Tresus | nuttallii | NA | Tresus nuttallii (Conrad, 1837) |
| 00034f81-997b-499f-a176-ac2949facbb9 | aecc92f1-1994-41bf-988c-e095ce1ce030 | LACMIP 1195.4 | fissurellidae | Fissurellidae | puncturella | cooperi | NA | Puncturella | cooperi | NA | Puncturella cooperi Carpenter, 1864 |
| 00038886-e0ca-4893-b454-e90d75f1eaa7 | 07cfa54b-1f25-4ea2-a0f2-a812f4e0523c | LACMIP 16408.1 | cirolanidae | Cirolanidae | palaega | goedertorum | NA | Palaega | goedertorum | NA | Palaega goedertorum Wieder & Feldmann, 2016 |
| 0003949f-4780-4283-bab1-8e8fb7a71841 | be239c5f-fbdc-4062-b0d5-1a7f6074665e | LACMIP 351.105 | ceratopogonidae | Ceratopogonidae | NA | NA | NA | NA | NA | NA | Ceratopogonidae indet. |
| 0004af95-d2bf-4247-9522-440662c2788f | d29d432a-d390-4479-8bf7-552399a5eb0c | LACMIP 20651.58 | epitoniidae | Epitoniidae | hirtoscala | tinctum | NA | Hirtoscala | tinctum | NA | Hirtoscala tinctum (Carpenter, 1864) |
| 000587e5-d012-4f50-bc04-52f44e0182d3 | b5dc4eb7-6f1a-44b5-a4aa-2d8dd7608293 | LACMIP 10099.9 | turritellidae | Turritellidae | turritella | hearni | NA | Turritella | hearni | NA | Turritella hearni Merriam, 1941 |
| 00058f4c-855d-423b-a9b5-aaec1b1bd25f | 727c3b93-52e8-403c-9e73-2232ac01a37e | LACMIP 22382.118 | calyptraeidae | Calyptraeidae | crepidula | onyx | NA | Crepidula | NA | NA | Crepidula sp. |
| 0006606e-53aa-4264-8af3-d55ff9951759 | 240d0a7f-b29e-45ea-8394-c115ee56e8fd | LACMIP 5060.45 | pectinidae | Pectinidae | leptopecten | latiauratus | NA | Leptopecten | latiauratus | NA | Leptopecten latiauratus (Conrad, 1837) |
| 00067a2d-5d0f-47d7-9072-4b9b7b89bd88 | e5e3733b-c1d8-4e8c-a435-9a8ac0bbcde4 | LACMIP 7290.22 | potamididae | Potamididae | cerithidea | californica | NA | Cerithideopsis | californica | NA | Cerithideopsis californica (Haldeman, 1840) |
| 00077744-a544-453a-b1bf-ad634d94eacf | 6ab4f80d-0d1a-4ae2-aabf-acc155320a1d | LACMIP 31257.62 | nassariidae | Nassariidae | hima | mendica | NA | Hima | mendica | NA | Hima mendica (Gould, 1849) |
| 0007cf26-5306-4f2f-a585-94a319069820 | 2fe4c7be-6ca2-4b06-846a-d6869a032b82 | LACMIP 42484.30 | olividae | Olividae | callianax | alectona | NA | Callianax | alectona | NA | Callianax alectona (Duclos, 1835) |
| 0007d63a-b15e-4cd5-9154-53a6204c0e41 | e87ad9af-e536-4303-a622-048892bf4dae | LACMIP 2533.3708 | NA | NA | NA | NA | NA | NA | NA | NA | Coleoptera indet. |
| 0007f380-2797-40fe-8071-a836be493f5b | 22d202d2-ce38-467c-aa2e-778070a37c3f | LACMIP 22848.1 | gaudryceratidae | Gaudryceratidae | eogaudryceras | hertleini | NA | Eogaudryceras | hertleini | NA | Eogaudryceras hertleini (Wiedmann, 1962) |
| 0009b3cf-ba45-4631-ad9f-b8e84b690bdf | 341ca08b-892f-40bf-8ad0-00a9a1aa8208 | LACMIP 260.336 | NA | NA | NA | NA | NA | NA | NA | NA | Diptera indet. |
| 000ae0be-f613-43cf-a2bf-0eaefe5eedb8 | c3f51eee-ecc6-4d35-b05e-7b1dac915e7e | LACMIP 42035.31 | conidae | Conidae | conus | californicus | NA | Californiconus | californicus | NA | Californiconus californicus (Reeve, 1844) |
| 000ba35c-8bea-4528-b1cf-bbbb15d9a68d | 17750fa4-8422-4fd7-8167-9a31c00e0096 | LACMIP 5090.6 | tellinidae | Tellinidae | macoma | astori | NA | Macoma | astori | NA | Macoma (Rexithaerus) astori Dall, 1909 |
| 000bb3a9-7161-4c90-ad21-f28b0aac7f15 | 911b1326-38b2-4946-9eb4-61aaa3ca812a | LACMIP 23225.88 | littorinidae | Littorinidae | lacuna | unifasciata | NA | Lacuna | unifasciata | NA | Lacuna (Epheria) unifasciata Carpenter, 1857 |
| 000d25fe-9b7c-4a8a-b200-23b8643adee1 | 5d3319d4-a595-4f10-a897-e82d29eb5032 | LACMIP 2533.1396 | incertae sedis | Incertae sedis | NA | NA | NA | NA | NA | NA | Anisoptera indet. |
| 000d50ee-faa7-4cf7-a276-cded9bc2b92d | 2d4ec77f-c893-4595-bb3c-299f23ef09be | LACMIP 22404.62 | lucinidae | Lucinidae | lucinoma | annulata | NA | Lucinoma | annulatum | NA | Lucinoma annulatum (Reeve, 1850) |
| 000ea1d1-128a-4963-b1e2-2a142d91a32b | 9824ec2c-4122-4196-a1df-4763e78450f8 | LACMIP 2533.1797 | notonectidae | Notonectidae | notonecta | glauca | NA | Notonecta | NA | NA | Notonecta sp. |
| 000eb38d-2ae0-4475-814e-c9ca812be6b1 | d158b0eb-bb73-4afe-95fc-5d220dd2be0c | LACMIP 17898.333 | NA | NA | NA | NA | NA | NA | NA | NA | Insecta indet. |
| 000fa3fc-5311-475a-80d5-30b638db3db3 | a65ffe73-68d1-457a-a4c7-4bce55bd81f5 | LACMIP 10101.2 | nuculidae | Nuculidae | acila | demessa | NA | Acila | demessa | NA | Acila (Truncacila) demessa Finlay, 1927 |
| 000fec10-9144-4b0d-b88c-a06a27b9f380 | e26c1d53-ecb6-41b0-aedb-944306bafd29 | LACMIP 29180.20 | NA | NA | NA | NA | NA | NA | NA | NA | Bivalvia indet. |
| 000ffcfb-9ea0-44ad-a1d3-a000b180d400 | e0d808f9-77fb-4321-80eb-b86b4733e2b1 | LACMIP 17095.4 | inoceramidae | Inoceramidae | cataceramus | subundatus | NA | Cataceramus | subundatus | NA | Cataceramus subundatus (Meek, 1861) |
| 00105f0e-4f02-4cf6-924d-24334aa36168 | 27f4bacb-b697-49a0-896d-883356825c69 | LACMIP 21589.7 | turritellidae | Turritellidae | turritella | peninsularis | quaylei | Turritella | peninsularis | quaylei | Turritella peninsularis quaylei Saul, 1983 |
| 0010a364-e56e-41a0-80da-bc7ec0f580f0 | aa2aa1a1-c6cb-47d7-9254-10a87f05a014 | LACMIP 23153.5 | turritellidae | Turritellidae | mesalia | martinezensis | NA | Mesalia | martinezensis | NA | Mesalia martinezensis (Gabb, 1869) |
| 00112f80-1f0f-4cce-9f58-fb58142b4cea | 5b9c0097-95d3-457c-9a12-69d5a6b3c0ec | LACMIP 29233.34 | nuculidae | Nuculidae | acila | haidana | NA | Acila | haidana | NA | Acila (Truncacila) haidana Packard in Schenck, 1936 |
| 00113821-2386-425a-bfe7-b86b30c3571a | 4df5ade2-6242-402c-b44e-4f74a0f263af | LACMIP 8226.206 | naticidae | Naticidae | neverita | reclusiana | NA | Glossaulax | reclusiana | NA | Glossaulax reclusiana (Deshayes, 1839) |
| 0011e9dc-aea8-4909-b277-671f660572b0 | c8a22b89-070a-4101-b1fe-6bd3558ae098 | LACMIP 20187.59 | naticidae | Naticidae | neverita | reclusiana | NA | Glossaulax | reclusiana | NA | Glossaulax reclusiana (Deshayes, 1839) |
| 00121bbf-0162-47aa-9d66-70825c61853f | 3b4e0b4a-0529-42e9-8ca8-a31f1b18746c | LACMIP 129.10 | veneridae | Veneridae | leukoma | laciniata | NA | Leukoma | laciniata | NA | Leukoma laciniata (Carpenter, 1864) |
| 0012598c-c37c-4d8c-a03f-26f4910b04df | 8db53592-bad0-4142-a4ac-3e73109c9a9e | LACMIP 25446.101 | buccinidae | Buccinidae | neptunea | tabulata | NA | Neptunea | tabulata | NA | Neptunea (Sulcosipho) tabulata (Baird, 1863) |
| 0012ce1c-6297-4854-9a89-a4ea3627b960 | 8b13250e-5e43-48c2-a4ec-e77352a7c0dc | LACMIP 20341.1 | hiatellidae | Hiatellidae | panopea | whitfieldi | NA | Panopea | NA | NA | Panopea sp. |
| 00130464-1faf-4526-be44-a8595f829352 | b61872a5-b278-446f-8834-99e070792e72 | LACMIP 421.73 | pectinidae | Pectinidae | spathochlamys | vestalis | NA | Spathochlamys | vestalis | NA | Spathochlamys vestalis (Reeve, 1853) |
| 00139f82-3cb1-491f-a95a-c90207af164d | 989f4361-d944-4ff8-ac01-3c4ebb538265 | LACMIP 23637.185 | buccinidae | Buccinidae | “cominella” | lecontei | NA | “Cominella” | lecontei | NA | “Cominella” lecontei White, 1889 |
| 0013c23e-b64b-4737-9c7b-b8d8149934b8 | e7c33bee-f096-47d9-9ee0-b699eada698d | LACMIP 21054.29 | ostreidae | Ostreidae | ostrea | conchaphila | NA | Ostrea | conchaphila | NA | Ostrea conchaphila Carpenter, 1857 |
| 00141151-babc-484d-b904-02aced161e7a | 5f5e0c91-7158-4cac-9932-e1f5a5855d46 | LACMIP 7205.93 | calyptraeidae | Calyptraeidae | crepidula | dorsata | NA | Crepipatella | dorsata | NA | Crepipatella dorsata (Broderip, 1834) |
| 0014b73a-4ca3-4937-8e99-c5cbb35ca431 | 220b3f78-5957-43c8-97c4-8154b3619b74 | LACMIP 2533.2188 | incertae sedis | Incertae sedis | NA | NA | NA | NA | NA | NA | Nematocera indet. |
| 00150998-6357-44f4-9ffc-b8dd6b2fe00a | 825e53ba-6813-48ff-9fee-cc04e380f011 | LACMIP 6953.58 | ostreidae | Ostreidae | ostrea | conchaphila | NA | Ostrea | conchaphila | NA | Ostrea conchaphila Carpenter, 1857 |
| 0015396f-d1f6-48de-b015-6ebc1ea073cd | 7955b9a4-ad58-4547-92f7-73714bdf8781 | LACMIP 5848.2 | cancridae | Cancridae | romaleon | wahkiakumensis | NA | Romaleon | wahkiakumensis | NA | Romaleon wahkiakumensis (Berglund & Goedert, 1992) |
| 00156735-151c-40ec-af32-e95b70c7abe5 | d19de809-af30-4ff7-b5a6-db4c552a3d24 | LACMIP 23225.542 | pseudomelatomidae | Pseudomelatomidae | rectiplanes | voyi | NA | Rectiplanes | voyi | NA | Rectiplanes voyi (Gabb, 1866) |
| 0015acac-ae8e-4fef-89fd-3b142bbc33da | 9a6ca880-b352-4465-b01e-cda524b881ba | LACMIP 10843.10 | glycymerididae | Glycymerididae | glycymerita | huttoni | NA | Glycymerita | veatchii | NA | Glycymerita veatchii (Gabb, 1864) |
| 0015fe85-ea75-4ac5-9c85-c1d33f6e7fa3 | b796ab8d-3911-41f9-a64d-2b0290c3b6f9 | LACMIP 41662.37 | NA | NA | NA | NA | NA | NA | NA | NA | Bryozoa indet. |
| 00166dc8-789f-4fb1-95c7-e41f745fe098 | d24bfa37-2ab7-4bb9-b3cf-f2bfafe6a2ce | LACMIP 2056.4 | tegulidae | Tegulidae | tegula | funebralis | NA | Chlorostoma | funebralis | NA | Chlorostoma funebralis (A. Adams, 1855) |
| 001714ef-e925-4325-9e53-cd936c8f6568 | b6c81107-63a8-4733-bac0-c3434524b7df | LACMIP 5868.196 | lucinidae | Lucinidae | lucinoma | annulata | NA | Lucinoma | annulatum | NA | Lucinoma annulatum (Reeve, 1850) |
| 00173dc6-2ae1-4cfa-a04c-64f312920bfe | 472a09f7-dc72-496a-b55e-22bed92acd26 | LACMIP 31276.115 | mactridae | Mactridae | mactrotoma | californica | NA | Mactrotoma | californica | NA | Mactrotoma californica (Conrad, 1837) |
| 00176285-ecef-4407-9105-3b16b92c9145 | 591250af-2ac8-4511-b86e-7d74e2fbf19d | LACMIP 41688.16 | arcidae | Arcidae | arca | sisquocensis | NA | Arca | sisquocensis | NA | Arca sisquocensis Reinhart, 1937 |
| 0017c563-b6a4-4d5f-8552-814d6d5bf31e | 19cddaa9-752a-482c-a95a-1d8106c4bbfc | LACMIP 2533.757 | hydrophilidae | Hydrophilidae | berosus | morticinus | NA | Berosus | morticinus | NA | Berosus (Berosus) morticinus (Heyden & Heyden, 1866) |
| 00183af0-7b5a-4d2d-8ceb-90b50dbd375c | 77f1f34a-8f65-48fb-b9e5-c81416e640b1 | LACMIP 42035.85 | naticidae | Naticidae | neverita | reclusiana | NA | Glossaulax | reclusiana | NA | Glossaulax reclusiana (Deshayes, 1839) |
Explore differences in the data
We can already see that there are some formatting differences between the data from the provider and that modified by the aggregator. For example, iDigBio converts all data to lowercase, which was historically useful for standardizing and indexing data across all of the recordsets represented in the iDigBio database. Family and genus names are capitalized by convention, so we will reformat those fields here:
# Reformat aggregator fields to title case
df_names <- df_names %>%
mutate(aggregator_family = str_to_title(aggregator_family)) %>%
mutate(aggregator_genus = str_to_title(aggregator_genus))
# Subset `df_names` to show example
df_names[1:5,] %>%
select(-flags) %>%
kable() %>%
kable_styling(bootstrap_options = c("striped", "hover", "condensed"),
font_size = 12,
fixed_thead = T) %>%
column_spec(c(4,6,7,8), color = "red") %>%
scroll_box(width = "100%", height = "400px")| uuid | occurrenceID | catalogNumber | aggregator_family | provider_family | aggregator_genus | aggregator_species | aggregator_subspecies | provider_genus | provider_species | provider_subspecies | provider_scientificName |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 000153f6-4861-4219-ac9e-f0d0f62fe60b | 0b6e2924-4b1a-4a18-a532-6c2d95962e95 | LACMIP 42500.14 | NA | NA | NA | NA | NA | NA | NA | NA | Clypeasteroida indet. |
| 000249c8-5c27-4292-94a7-1802f4d1ca4b | 37ae5d77-073e-4713-aa54-92d7e0616fcf | LACMIP 16817.200 | Borsoniidae | Borsoniidae | Ophiodermella | NA | NA | Ophiodermella | NA | NA | Ophiodermella sp. |
| 00028446-c91d-47f2-b036-2134f011e282 | 2933a74c-faeb-4519-9117-6000c9f43926 | LACMIP 2657.24 | Mactridae | Mactridae | Tresus | nuttallii | NA | Tresus | nuttallii | NA | Tresus nuttallii (Conrad, 1837) |
| 00034f81-997b-499f-a176-ac2949facbb9 | aecc92f1-1994-41bf-988c-e095ce1ce030 | LACMIP 1195.4 | Fissurellidae | Fissurellidae | Puncturella | cooperi | NA | Puncturella | cooperi | NA | Puncturella cooperi Carpenter, 1864 |
| 00038886-e0ca-4893-b454-e90d75f1eaa7 | 07cfa54b-1f25-4ea2-a0f2-a812f4e0523c | LACMIP 16408.1 | Cirolanidae | Cirolanidae | Palaega | goedertorum | NA | Palaega | goedertorum | NA | Palaega goedertorum Wieder & Feldmann, 2016 |
Let’s use the power of R to filter out data that have not been modified so that we can focus on rows where the aggregator has made changes. As an example, we will look at rows where the genus name does not match between the provider and the aggregator:
# Filter for rows where genus does not match
df_names %>%
filter(provider_genus != aggregator_genus) %>%
kable() %>%
kable_styling(bootstrap_options = c("striped", "hover", "condensed"),
font_size = 12,
fixed_thead = T) %>%
column_spec(c(4,6,7,8), color = "red") %>%
scroll_box(width = "100%", height = "400px")| uuid | occurrenceID | catalogNumber | aggregator_family | provider_family | aggregator_genus | aggregator_species | aggregator_subspecies | provider_genus | provider_species | provider_subspecies | provider_scientificName | flags |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 00067a2d-5d0f-47d7-9072-4b9b7b89bd88 | e5e3733b-c1d8-4e8c-a435-9a8ac0bbcde4 | LACMIP 7290.22 | Potamididae | Potamididae | Cerithidea | californica | NA | Cerithideopsis | californica | NA | Cerithideopsis californica (Haldeman, 1840) | rev_geocode_eez , geopoint_low_precision , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 000ae0be-f613-43cf-a2bf-0eaefe5eedb8 | c3f51eee-ecc6-4d35-b05e-7b1dac915e7e | LACMIP 42035.31 | Conidae | Conidae | Conus | californicus | NA | Californiconus | californicus | NA | Californiconus californicus (Reeve, 1844) | geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, gbif_vernacularname_added , dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_multimedia_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 00113821-2386-425a-bfe7-b86b30c3571a | 4df5ade2-6242-402c-b44e-4f74a0f263af | LACMIP 8226.206 | Naticidae | Naticidae | Neverita | reclusiana | NA | Glossaulax | reclusiana | NA | Glossaulax reclusiana (Deshayes, 1839) | rev_geocode_eez , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 0011e9dc-aea8-4909-b277-671f660572b0 | c8a22b89-070a-4101-b1fe-6bd3558ae098 | LACMIP 20187.59 | Naticidae | Naticidae | Neverita | reclusiana | NA | Glossaulax | reclusiana | NA | Glossaulax reclusiana (Deshayes, 1839) | geopoint_datum_error , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 00141151-babc-484d-b904-02aced161e7a | 5f5e0c91-7158-4cac-9932-e1f5a5855d46 | LACMIP 7205.93 | Calyptraeidae | Calyptraeidae | Crepidula | dorsata | NA | Crepipatella | dorsata | NA | Crepipatella dorsata (Broderip, 1834) | rev_geocode_eez , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 00166dc8-789f-4fb1-95c7-e41f745fe098 | d24bfa37-2ab7-4bb9-b3cf-f2bfafe6a2ce | LACMIP 2056.4 | Tegulidae | Tegulidae | Tegula | funebralis | NA | Chlorostoma | funebralis | NA | Chlorostoma funebralis (A. Adams, 1855) | geopoint_low_precision , gbif_reference_added , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, gbif_vernacularname_added , dwc_taxonomicstatus_added , dwc_originalnameusageid_added , gbif_canonicalname_added , gbif_taxon_corrected , idigbio_isocountrycode_added , dwc_genus_replaced , dwc_taxonid_added , dwc_parentnameusageid_added |
| 00183af0-7b5a-4d2d-8ceb-90b50dbd375c | 77f1f34a-8f65-48fb-b9e5-c81416e640b1 | LACMIP 42035.85 | Naticidae | Naticidae | Neverita | reclusiana | NA | Glossaulax | reclusiana | NA | Glossaulax reclusiana (Deshayes, 1839) | geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 001eb465-05cb-4ff1-9c7d-3b0217d1a03c | 00cc7a85-a440-40dd-955b-0e13a2a8ef98 | LACMIP 41678.50 | Naticidae | Naticidae | Neverita | reclusiana | NA | Glossaulax | reclusiana | NA | Glossaulax reclusiana (Deshayes, 1839) | geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 002122b5-714f-4c17-8718-c8ff1d250c7b | 3e6695d5-5747-4c40-b562-05a2684d79da | LACMIP 21055.13 | Tegulidae | Tegulidae | Tegula | montereyi | NA | Chlorostoma | montereyi | NA | Chlorostoma montereyi (Kiener, 1850) | geopoint_datum_error , rev_geocode_eez , geopoint_low_precision , gbif_reference_added , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, gbif_vernacularname_added , dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_genus_replaced , dwc_taxonomicstatus_added , gbif_taxon_corrected , dwc_taxonid_added , dwc_originalnameusageid_added , gbif_canonicalname_added |
| 002440ab-2a15-46db-aa8f-c043b4e143dc | 37b0e696-1328-4c5d-9884-def9b9026df9 | LACMIP 16521.17 | Nassariidae | Nassariidae | Nassarius | perpinguis | NA | Caesia | perpinguis | NA | Caesia perpinguis (Hinds, 1844) | geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 0025fcb8-8f8d-48af-9662-a579cf631b99 | 6c739c75-5c26-4fd1-8520-55a1523614a9 | LACMIP 3936.94 | Epitoniidae | Epitoniidae | Epitonium | indianorum | NA | Hirtoscala | indianorum | NA | Hirtoscala indianorum (Carpenter, 1864) | rev_geocode_eez , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, idigbio_isocountrycode_added , dwc_originalnameusageid_added , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 00317c86-c463-4c45-8c23-f9fdcd363a25 | d9d6e433-73e9-4e96-937c-fd381e329855 | LACMIP 66.873 | Naticidae | Naticidae | Glossaulax | draconis | NA | Euspira | draconis | NA | Euspira draconis (Dall, 1903) | rev_geocode_eez , geopoint_low_precision , gbif_reference_added , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, gbif_vernacularname_added , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_multimedia_added , dwc_originalnameusageid_added , gbif_canonicalname_added , gbif_taxon_corrected , idigbio_isocountrycode_added , dwc_genus_replaced , dwc_parentnameusageid_added |
| 0040542c-ed12-4dba-9246-325ab81cf27e | 99fad840-f82e-4e63-bb97-72acd55a2d8a | LACMIP 23393.9 | Chamidae | Chamidae | Pseudochama | exogyra | NA | Chama | exogyra | NA | Chama exogyra Conrad, 1837 | rev_geocode_eez , geopoint_low_precision , gbif_reference_added , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, gbif_vernacularname_added , dwc_order_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_multimedia_added , dwc_originalnameusageid_added , gbif_canonicalname_added , gbif_taxon_corrected , idigbio_isocountrycode_added , dwc_genus_replaced , dwc_parentnameusageid_added |
| 00420e9a-1b9d-4638-93e4-a14f20b23103 | bd22b32b-ab88-40ad-afe6-6b7310209185 | LACMIP 77.139 | Cardiidae | Cardiidae | Americardia | media | NA | Mexicardia | procerum | NA | Mexicardia procerum (Sowerby I, 1833) | geopoint_datum_error , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added , dwc_order_replaced , dwc_genus_replaced , dwc_specificepithet_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 0049f8e1-ed87-4c0e-81df-f03cd5012fb6 | 2db62d06-4c59-47d4-8a59-2ac19a5be256 | LACMIP 41838.8 | Ostreidae | Ostreidae | Ostrea | vespertina | NA | Dendostrea | vespertina | NA | Dendostrea vespertina (Conrad, 1854) | dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , gbif_taxon_corrected , idigbio_isocountrycode_added , gbif_canonicalname_added , dwc_scientificnameauthorship_replaced, dwc_order_replaced , dwc_taxonid_added , dwc_parentnameusageid_added , dwc_genus_replaced |
| 004b9842-0e3c-463b-b7c6-da0259f63c88 | c68ca582-6b7c-4493-bb7b-dde68e5de18e | LACMIP 16815.14 | Columbellidae | Columbellidae | Alia | gausapata | NA | Mitrella | gausapata | NA | Mitrella gausapata (Gould, 1850) | geopoint_low_precision , rev_geocode_mismatch , gbif_reference_added , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , dwc_taxonid_added , gbif_taxon_corrected , idigbio_isocountrycode_added, gbif_canonicalname_added , dwc_parentnameusageid_added , taxon_match_failed , dwc_genus_replaced |
| 00503f61-af2f-4882-ad6a-e59a9d9857a2 | b70b1004-32d6-4aff-a533-b17532db1c77 | LACMIP 25446.87 | Naticidae | Naticidae | Neverita | reclusiana | NA | Glossaulax | reclusiana | NA | Glossaulax reclusiana (Deshayes, 1839) | geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 00584135-2041-44b5-896d-6e2eeac20295 | 28bd8af1-17c0-4b0a-8756-e3ae91ee48e8 | LACMIP 17848.45 | Cardiidae | Cardiidae | Cardium | brewerii | NA | Acanthocardia | brewerii | NA | Acanthocardia (Schedocardia) brewerii (Gabb, 1864) | geopoint_low_precision , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , gbif_taxon_corrected , idigbio_isocountrycode_added , gbif_canonicalname_added , dwc_scientificnameauthorship_replaced, dwc_order_replaced , dwc_taxonid_added , dwc_parentnameusageid_added , dwc_genus_replaced |
| 0058566e-f0f5-4917-81b9-e717953b6d11 | e779e326-8582-4b57-98a2-210c9aafc60b | LACMIP 23386.27 | Nassariidae | Nassariidae | Nassarius | perpinguis | NA | Caesia | perpinguis | NA | Caesia perpinguis (Hinds, 1844) | rev_geocode_eez , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 00591879-55a9-48df-afa5-32a637f47d5a | abdac336-68aa-4e5e-b4e1-73e44bb29c40 | LACMIP 229.44 | Nassariidae | Nassariidae | Nassarius | perpinguis | NA | Caesia | perpinguis | NA | Caesia perpinguis (Hinds, 1844) | geopoint_datum_error , geopoint_low_precision , gbif_reference_added , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , dwc_parentnameusageid_added , dwc_taxonid_added , gbif_taxon_corrected , idigbio_isocountrycode_added , gbif_vernacularname_added , gbif_canonicalname_added , dwc_originalnameusageid_added, dwc_genus_replaced |
| 005bfaf1-a68a-4734-9d40-7826ce51f35d | 298e665b-66a1-423b-be7a-ec6b3dab277b | LACMIP 22413.169 | Naticidae | Naticidae | Neverita | reclusiana | NA | Glossaulax | reclusiana | NA | Glossaulax reclusiana (Deshayes, 1839) | geopoint_datum_error , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 006495be-7f3d-4180-8940-2200c4f812e1 | e3532b29-4b90-41a5-9371-5aabd1acba10 | LACMIP 305.1256 | Pectinidae | Pectinidae | Pecten | healeyi | NA | Patinopecten | healeyi | NA | Patinopecten healeyi (Arnold, 1906) | geopoint_low_precision , rev_geocode_mismatch , gbif_reference_added , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_order_replaced , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 006cad27-7f96-4a91-ac9d-e2e2f7be09f3 | 138071e2-b4a8-4624-8281-e2e2405f91ca | LACMIP 18090.4 | Ostreidae | Ostreidae | Ostrea | vespertina | NA | Dendostrea | vespertina | NA | Dendostrea vespertina (Conrad, 1854) | geopoint_low_precision , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , dwc_order_replaced , gbif_taxon_corrected , idigbio_isocountrycode_added , gbif_canonicalname_added , dwc_scientificnameauthorship_replaced, dwc_taxonid_added , dwc_parentnameusageid_added , dwc_genus_replaced |
| 006fe4fa-483c-4d4f-a114-2b82e175b2e3 | c266471b-54e6-475d-973b-2e23b4253c49 | LACMIP 5574.68 | Muricidae | Muricidae | Pteropurpura | festiva | NA | Shaskyus | festivus | NA | Shaskyus festivus (Hinds, 1844) | geopoint_datum_error , rev_geocode_eez , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_specificepithet_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_multimedia_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 0072ebfc-76a0-4ac0-ac09-750e611ce0e0 | e1a5e47c-bd29-41dd-9126-cf40d604f847 | LACMIP 40054.17 | Pectinidae | Pectinidae | Pecten | healeyi | NA | Patinopecten | healeyi | NA | Patinopecten healeyi (Arnold, 1906) | geopoint_datum_error , rev_geocode_eez , geopoint_low_precision , gbif_reference_added , dwc_taxonrank_replaced , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , dwc_taxonid_added , gbif_taxon_corrected , gbif_canonicalname_added , dwc_scientificnameauthorship_replaced, dwc_order_replaced , idigbio_isocountrycode_added , dwc_parentnameusageid_added , dwc_genus_replaced |
| 007da931-eba7-459b-81d0-88018a478a38 | d99553e3-67e9-4fd1-82df-09ddd9ac4317 | LACMIP 1215.25 | Pachydiscidae | Pachydiscidae | Eupachydiscus | catarinae | NA | Pachydiscus | catarinae | NA | Pachydiscus (Neodesmoceras) catarinae (Anderson & Hanna, 1928) | geopoint_low_precision , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_genus_replaced , taxon_match_failed , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_multimedia_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 007f0bfc-7829-4507-b94a-61b48c2aaf57 | 193ad913-1629-4afa-a1de-c3ca4d379054 | LACMIP 7002.10 | Columbellidae | Columbellidae | Alia | gausapata | NA | Mitrella | gausapata | NA | Mitrella gausapata (Gould, 1850) | geopoint_datum_error , rev_geocode_eez , geopoint_low_precision , gbif_reference_added , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , gbif_taxon_corrected , idigbio_isocountrycode_added, gbif_canonicalname_added , dwc_taxonid_added , dwc_parentnameusageid_added , taxon_match_failed , dwc_genus_replaced |
| 007f4e47-f6da-4749-8b92-8001b85d1581 | 65bc1734-d437-4ca8-a22c-38d3e44b3853 | LACMIP 10328.80 | Serpulidae | Serpulidae | Pyrgopolon | onyx | NA | Hamulus | onyx | NA | Hamulus onyx Morton, 1834 | geopoint_low_precision , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , gbif_taxon_corrected , idigbio_isocountrycode_added, gbif_canonicalname_added , dwc_taxonid_added , dwc_parentnameusageid_added , dwc_genus_replaced |
| 0087bd4a-f55f-497b-9e22-33483a88bfec | 7153ae1c-75bd-4f8a-bf68-c90e452c0835 | LACMIP 76.18 | Lasaeidae | Lasaeidae | Aligena | trigonalis | NA | Isorobitella | trigonalis | NA | Isorobitella trigonalis (Carpenter, 1857) | geopoint_datum_error , rev_geocode_eez , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_order_replaced , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 00886c2e-99cf-4793-bf03-7560789fbc7e | f21cb736-d86a-4752-846a-70a705b19d05 | LACMIP 10105.210 | Mactridae | Mactridae | Mactra | stantoni | NA | Cymbophora | stantoni | NA | Cymbophora stantoni (Arnold, 1908) | geopoint_low_precision , gbif_genericname_added , dwc_parentnameusageid_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, idigbio_isocountrycode_added , dwc_order_replaced , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 008924fa-cb1e-4353-81e4-743fc73b6fb8 | 7e313c7f-c58d-4bdb-9589-4cdae5a3cb45 | LACMIP 5041.29 | Vermetidae | Vermetidae | Thylacodes | squamigerus | NA | Serpulorbis | squamigerus | NA | Serpulorbis squamigerus (Carpenter, 1857) | geopoint_low_precision , gbif_reference_added , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , gbif_taxon_corrected , dwc_scientificnameauthorship_replaced, dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_originalnameusageid_added , gbif_canonicalname_added |
| 008d249e-a9b8-4654-b15f-bb7354e537aa | 280c5795-9370-4bbe-8d71-9af1441bd93a | LACMIP 25992.45 | Columbellidae | Columbellidae | Alia | gausapata | NA | Mitrella | gausapata | NA | Mitrella gausapata (Gould, 1850) | geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , dwc_parentnameusageid_added , idigbio_isocountrycode_added, dwc_genus_replaced , taxon_match_failed , dwc_taxonomicstatus_added , dwc_taxonid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 0093696a-2330-4a86-8913-7ed35a2281d5 | 60b6851e-5919-49c2-88e3-081085400880 | LACMIP 5868.5 | Conidae | Conidae | Conus | californicus | NA | Californiconus | californicus | NA | Californiconus californicus (Reeve, 1844) | geopoint_datum_error , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, gbif_vernacularname_added , dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_multimedia_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 009e4a6e-9283-44f8-bd89-8ffe76475fac | 1b024d38-1f0c-47a1-832c-46a5fda6c00e | LACMIP 4804.14 | Epitoniidae | Epitoniidae | Epitonium | hindsii | NA | Hirtoscala | hindsii | NA | Hirtoscala hindsii (Carpenter, 1856) | geopoint_datum_error , geopoint_low_precision , gbif_reference_added , dwc_parentnameusageid_added , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , gbif_taxon_corrected , idigbio_isocountrycode_added , gbif_canonicalname_added , dwc_taxonid_added , dwc_originalnameusageid_added, dwc_genus_replaced |
| 00a58d86-9cf9-4b88-9bf2-4f428ec4f6ba | 18215210-6352-4476-856f-40470062f081 | LACMIP 22387.54 | Glycymerididae | Glycymerididae | Glycymeris | major | NA | Glycymerita | major | NA | Glycymerita major (Stanton, 1896) | geopoint_low_precision , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , dwc_order_replaced , gbif_taxon_corrected , idigbio_isocountrycode_added , gbif_canonicalname_added , dwc_scientificnameauthorship_replaced, dwc_taxonid_added , dwc_parentnameusageid_added , dwc_genus_replaced |
| 00a9677e-0262-4f78-b470-6541bb12dde0 | 51751506-dc91-4bc9-b113-e6460b9577b2 | LACMIP 22413.218 | Nassariidae | Nassariidae | Nassarius | perpinguis | NA | Caesia | perpinguis | NA | Caesia perpinguis (Hinds, 1844) | geopoint_datum_error , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 00b912fc-a225-4fbd-9b11-2ba629abcbfd | 9563b851-14e6-4f38-ab3c-972612d81b37 | LACMIP 64.264 | Vermetidae | Vermetidae | Thylacodes | squamigerus | NA | Serpulorbis | squamigerus | NA | Serpulorbis squamigerus (Carpenter, 1857) | geopoint_datum_error , geopoint_low_precision , gbif_reference_added , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , gbif_taxon_corrected , dwc_scientificnameauthorship_replaced, dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_originalnameusageid_added , gbif_canonicalname_added |
| 00bcb521-f6b3-4ec7-9b2e-b75770a795d5 | dad42ef7-f184-4d46-97f7-3ee288ff25fb | LACMIP 30123.64 | Cardiidae | Cardiidae | Cardium | coronaensis | NA | Pachycardium | coronaense | NA | Pachycardium coronaense (Packard, 1922) | geopoint_low_precision , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_order_replaced , dwc_genus_replaced , dwc_specificepithet_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 00bdf59a-c045-4302-80d6-525196c13c48 | 6618fa60-ce0a-4a5a-b6e1-30db73c0f0f7 | LACMIP 59.51 | Epitoniidae | Epitoniidae | Epitonium | indianorum | NA | Hirtoscala | indianorum | NA | Hirtoscala indianorum (Carpenter, 1864) | geopoint_datum_error , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, idigbio_isocountrycode_added , dwc_originalnameusageid_added , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 00cde2a9-08f6-467d-9358-996bc7ce69c5 | c281817d-2aa6-4fb9-8b69-59e32a0e1506 | LACMIP 2685.9 | Naticidae | Naticidae | Neverita | reclusiana | NA | Glossaulax | reclusiana | NA | Glossaulax reclusiana (Deshayes, 1839) | geopoint_low_precision , gbif_reference_added , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , dwc_parentnameusageid_added , dwc_taxonid_added , gbif_taxon_corrected , idigbio_isocountrycode_added , gbif_vernacularname_added , gbif_canonicalname_added , dwc_originalnameusageid_added, dwc_genus_replaced |
| 00dbae3f-9973-4ec4-9c8b-7d04d6f36783 | d264258b-f47f-481d-a26a-7964ae1923d1 | LACMIP 4396.20 | Naticidae | Naticidae | Neverita | reclusiana | NA | Glossaulax | reclusiana | NA | Glossaulax reclusiana (Deshayes, 1839) | geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 00e15c79-866d-458b-b1a3-00c8288e6adb | b188a191-fb4e-406a-972e-7b2a4e51226e | LACMIP 7290.1 | Conidae | Conidae | Conus | californicus | NA | Californiconus | californicus | NA | Californiconus californicus (Reeve, 1844) | rev_geocode_eez , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, gbif_vernacularname_added , dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_multimedia_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 01119912-24c7-4405-9c1a-d0bf723dbbc0 | 0769dc81-1085-49b7-b008-1f0ff48f9f34 | LACMIP 466.63 | Naticidae | Naticidae | Neverita | reclusiana | NA | Glossaulax | reclusiana | NA | Glossaulax reclusiana (Deshayes, 1839) | geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 0118a4fb-46f3-4356-ad3b-26af888a937d | 6de8d7cc-242d-423e-ac04-f44f97ecefd0 | LACMIP 10908.1 | Trigoniidae | Trigoniidae | Protrigonia | NA | NA | Pterotrigonia | NA | NA | Pterotrigonia sp. | geopoint_low_precision , idigbio_isocountrycode_added , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , dwc_order_replaced , gbif_taxon_corrected , gbif_canonicalname_added , dwc_scientificnameauthorship_added, dwc_taxonid_added , dwc_parentnameusageid_added , dwc_genus_replaced |
| 0135d386-8226-4907-92e5-04ed3ea51ef4 | 81af9fb2-45e1-4a0c-b8d9-a747756b3e85 | LACMIP 409.3 | Potamididae | Potamididae | Cerithidea | californica | NA | Cerithideopsis | californica | NA | Cerithideopsis californica (Haldeman, 1840) | geopoint_low_precision , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 013f124a-2b35-465d-affa-bcfbb27b879e | 1b3968bb-d69f-41e1-b4eb-1169b266c0a0 | LACMIP 23225.599 | Muricidae | Muricidae | Pteropurpura | festiva | NA | Shaskyus | festivus | NA | Shaskyus festivus (Hinds, 1844) | rev_geocode_eez , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , dwc_specificepithet_replaced , dwc_taxonomicstatus_added , dwc_multimedia_added , gbif_taxon_corrected , gbif_canonicalname_added , dwc_originalnameusageid_added, idigbio_isocountrycode_added , dwc_genus_replaced , dwc_taxonid_added , dwc_parentnameusageid_added |
| 013fd299-9bc2-4076-a3d1-444cd4cc1706 | 5cb1861c-621f-452c-9cba-c6bf0c8d8202 | LACMIP 10611.17 | Tegulidae | Tegulidae | Tegula | funebralis | NA | Chlorostoma | funebralis | NA | Chlorostoma funebralis (A. Adams, 1855) | geopoint_low_precision , gbif_reference_added , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, gbif_vernacularname_added , dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_genus_replaced , dwc_taxonomicstatus_added , gbif_taxon_corrected , dwc_taxonid_added , dwc_originalnameusageid_added , gbif_canonicalname_added |
| 0147e4c3-d7e4-4f23-924d-ce441d6589b9 | 39a94132-37b4-4e6d-b1f6-04499a9eaefb | LACMIP 21801.26 | Nassariidae | Nassariidae | Nassarius | perpinguis | NA | Caesia | perpinguis | NA | Caesia perpinguis (Hinds, 1844) | geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 0157b790-e96e-423b-a055-ff53537f1bc1 | f7602217-605f-4571-be3c-46dfa05269dc | LACMIP 97.40 | Muricidae | Muricidae | Pteropurpura | festiva | NA | Shaskyus | festivus | NA | Shaskyus festivus (Hinds, 1844) | rev_geocode_eez , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_specificepithet_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_multimedia_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 0167d93a-186b-4c11-91b6-c245ebf384ea | 9d138c51-a4dc-4adc-96a5-70c828acba4a | LACMIP 18605.1 | Pectinidae | Pectinidae | Pecten | healeyi | NA | Patinopecten | healeyi | NA | Patinopecten healeyi (Arnold, 1906) | geopoint_low_precision , gbif_reference_added , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_order_replaced , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 01696b3f-28e9-4312-b042-ae44fc1d149b | 36e386c3-105e-4151-9ccc-3c9d87594746 | LACMIP 2533.475 | Chironomidae | Chironomidae | Paracladius | NA | NA | Procladius | NA | NA | Procladius sp. | geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_parentnameusageid_added , dwc_datasetid_added , idigbio_isocountrycode_added , dwc_scientificnameauthorship_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 01774058-6b93-4f15-ae70-9e5c634af68d | 6e2d319f-f3a8-4a1a-b155-2242ef940c85 | LACMIP 1499.5 | Pterotrigoniidae | Trigoniidae | Notoscabrotrigonia | klamathonia | NA | Pterotrigonia | klamathonia | NA | Pterotrigonia klamathonia (Anderson, 1958) | geopoint_low_precision , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , gbif_taxon_corrected , dwc_scientificnameauthorship_replaced, dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_family_replaced , dwc_order_replaced , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_originalnameusageid_added , gbif_canonicalname_added |
| 017cac70-9c5e-4189-9770-ecf7a82caf17 | a9e7efe1-92a2-4d19-9616-af3b260c681e | LACMIP 16204.2 | Ostreidae | Ostreidae | Ostrea | vespertina | NA | Dendostrea | vespertina | NA | Dendostrea vespertina (Conrad, 1854) | geopoint_low_precision , gbif_genericname_added , dwc_parentnameusageid_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, idigbio_isocountrycode_added , dwc_order_replaced , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 017d2baa-43b7-4cab-9fd2-4e2169edced6 | ca9e6925-b74d-49b6-9e4e-65fd138233af | LACMIP 10781.7 | Acteonellidae | Acteonellidae | Actaeonella | oviformis | NA | Acteonella | oviformis | NA | Acteonella oviformis Gabb, 1869 | geopoint_low_precision , dwc_taxonrank_replaced , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , gbif_taxon_corrected , gbif_canonicalname_added , dwc_scientificnameauthorship_replaced, dwc_taxonid_added , dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_genus_replaced |
| 018dfa07-1327-49aa-8116-bdd6baac81aa | c5de5a63-9876-418a-a13a-3af22382938a | LACMIP 40054.16 | Epitoniidae | Epitoniidae | Epitonium | indianorum | NA | Hirtoscala | indianorum | NA | Hirtoscala indianorum (Carpenter, 1864) | geopoint_datum_error , rev_geocode_eez , geopoint_low_precision , gbif_reference_added , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , dwc_parentnameusageid_added , dwc_taxonid_added , gbif_taxon_corrected , idigbio_isocountrycode_added , gbif_canonicalname_added , dwc_scientificnameauthorship_replaced, dwc_originalnameusageid_added , dwc_genus_replaced |
| 018eec44-bdca-432a-9144-9cb389f316d6 | 191b7400-5bef-4b56-8fc6-6c7c2d38b07f | LACMIP 7290.29 | Fasciolariidae | Fasciolariidae | Fusinus | luteopictus | NA | Hesperaptyxis | luteopictus | NA | Hesperaptyxis luteopictus (Dall, 1877) | rev_geocode_eez , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 0195789f-94e0-4d52-84ae-5d0390035d84 | 2c3a785c-13d6-4430-8268-0a325eb965b3 | LACMIP 20259.1 | Pectinidae | Pectinidae | Pecten | opuntia | NA | Chlamys | opuntia | NA | Chlamys opuntia (Dall, 1898) | geopoint_low_precision , gbif_reference_added , dwc_taxonrank_replaced , gbif_genericname_added , dwc_parentnameusageid_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, idigbio_isocountrycode_added , dwc_order_replaced , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_multimedia_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 019b6cfc-1525-4c0c-bfc3-40e5ba219ef0 | 1be3302f-e0b1-4703-a305-b045a4bcd079 | LACMIP 5062.114 | Vermetidae | Vermetidae | Thylacodes | squamigerus | NA | Serpulorbis | squamigerus | NA | Serpulorbis squamigerus (Carpenter, 1857) | geopoint_low_precision , gbif_reference_added , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_genus_replaced , dwc_taxonomicstatus_added , gbif_taxon_corrected , dwc_taxonid_added , dwc_originalnameusageid_added , gbif_canonicalname_added |
| 01b6d44b-1bb0-4a41-afcf-e266d991ccf1 | fad75362-a905-4985-b590-a42a7fc98d16 | LACMIP 226.65 | Nassariidae | Nassariidae | Nassarius | perpinguis | NA | Caesia | perpinguis | NA | Caesia perpinguis (Hinds, 1844) | geopoint_datum_error , rev_geocode_eez , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 01b7ba89-5c9b-4c5e-8567-c6ec269ede31 | 26784e25-70f4-4d75-8a7b-2967dee7178a | LACMIP 21940.9 | Epitoniidae | Epitoniidae | Epitonium | indianorum | NA | Hirtoscala | indianorum | NA | Hirtoscala indianorum (Carpenter, 1864) | geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, idigbio_isocountrycode_added , dwc_originalnameusageid_added , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 01bb2dd9-2e1d-49a9-ae2d-4cc369d726ed | c99f4a65-b6f3-434d-9196-603969edef04 | LACMIP 10326.26 | Serpulidae | Serpulidae | Pyrgopolon | onyx | NA | Hamulus | onyx | NA | Hamulus onyx Morton, 1834 | geopoint_low_precision , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , gbif_taxon_corrected , idigbio_isocountrycode_added, gbif_canonicalname_added , dwc_taxonid_added , dwc_parentnameusageid_added , dwc_genus_replaced |
| 01c171e8-dbb6-4d11-95f7-c267c1080553 | 7fc4e114-e3be-4874-9ff4-b33b3e5cbff6 | LACMIP 23647.17 | Pachydiscidae | Pachydiscidae | Eupachydiscus | grossouvrei | NA | Pachydiscus | buckhami | NA | Pachydiscus buckhami Usher, 1952 | geopoint_low_precision , dwc_taxonrank_replaced , gbif_genericname_added , dwc_parentnameusageid_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, idigbio_isocountrycode_added , dwc_genus_replaced , dwc_specificepithet_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_multimedia_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 01c194f0-6b5b-4161-8746-00965a6423ca | 90632594-92b8-4116-8b9f-19387ba4d014 | LACMIP 23165.10 | Glycymerididae | Glycymerididae | Glycymeris | major | NA | Glycymerita | major | NA | Glycymerita major (Stanton, 1896) | geopoint_low_precision , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , dwc_order_replaced , gbif_taxon_corrected , idigbio_isocountrycode_added , gbif_canonicalname_added , dwc_scientificnameauthorship_replaced, dwc_taxonid_added , dwc_parentnameusageid_added , dwc_genus_replaced |
| 01d096ec-c783-4605-b49e-0609205532e1 | 41f39393-6a7f-4be7-94e2-03ce30ea195c | LACMIP 31263.78 | Naticidae | Naticidae | Neverita | reclusiana | NA | Glossaulax | reclusiana | NA | Glossaulax reclusiana (Deshayes, 1839) | geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 01d3ad81-682f-4d15-8265-7bc5b1693259 | 30fc1ed1-b44a-4f8d-b1cc-14c09fceb8f6 | LACMIP 26980.18 | Bakevelliidae | Bakevelliidae | Gervillaria | alifera | NA | Gervillia | NA | NA | Gervillia sp. | geopoint_low_precision , dwc_taxonrank_replaced , dwc_specificepithet_added , gbif_genericname_added , dwc_datasetid_added , dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_scientificnameauthorship_added, dwc_order_replaced , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 0205cc71-a358-49e3-9b94-c15e92d16db4 | f1d27794-ef56-4c7d-8294-29743e2caf03 | LACMIP 23633.23 | Trigoniidae | Trigoniidae | Pleurotrigonia | jacobseni | NA | Pterotrigonia | evansana | NA | Pterotrigonia evansana (Meek, 1858) | geopoint_low_precision , gbif_reference_added , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_order_replaced , dwc_genus_replaced , dwc_specificepithet_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 020ed019-afc2-45a9-bf36-6a38c306cd51 | e2e2f1a5-31a3-4b77-ab32-e6d897ccf046 | LACMIP 18601.4 | Pectinidae | Pectinidae | Pecten | healeyi | NA | Patinopecten | healeyi | NA | Patinopecten healeyi (Arnold, 1906) | geopoint_low_precision , gbif_reference_added , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_order_replaced , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 0210ef77-9139-4602-8984-9d0ca01bd9ed | d172a61e-c537-4029-8563-59ffb4f62611 | LACMIP 8194.6 | Pterotrigoniidae | Trigoniidae | Notoscabrotrigonia | klamathonia | NA | Pterotrigonia | klamathonia | NA | Pterotrigonia klamathonia (Anderson, 1958) | geopoint_low_precision , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_family_replaced , dwc_order_replaced , dwc_genus_replaced , dwc_taxonomicstatus_added , gbif_taxon_corrected , dwc_taxonid_added , dwc_originalnameusageid_added , gbif_canonicalname_added |
| 02183e26-5f4b-4b2c-93a3-ce4af35a6c2a | 9e8c52db-31fd-4d71-8d81-877864cc46f3 | LACMIP 11921.12 | Cerithiidae | Cerithiidae | Stylidium | eschrichtii | NA | Neostylidium | eschrichtii | NA | Neostylidium eschrichtii (Middendorff, 1849) | rev_geocode_eez , geopoint_low_precision , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 02190def-2a96-4aea-8efb-7e8ed39c2ccb | 1b669af4-3c97-4165-924d-a8f2e7eba839 | LACMIP 16862.121 | Pectinidae | Pectinidae | Pecten | healeyi | NA | Patinopecten | healeyi | NA | Patinopecten healeyi (Arnold, 1906) | geopoint_low_precision , rev_geocode_mismatch , gbif_reference_added , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_order_replaced , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 021b33b4-7fd7-4109-814a-735b5c14781e | 750fb2ec-7706-408b-be72-f57bef291e0c | LACMIP 6953.184 | Nassariidae | Nassariidae | Nassarius | perpinguis | NA | Caesia | perpinguis | NA | Caesia perpinguis (Hinds, 1844) | geopoint_datum_error , rev_geocode_eez , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 0226d059-bb79-4f8d-8ae9-ef2b3280c19b | 0b01930b-c3ff-4052-8034-bfcc8ee3c00f | LACMIP 16520.155 | Naticidae | Naticidae | Neverita | reclusiana | NA | Glossaulax | reclusiana | NA | Glossaulax reclusiana (Deshayes, 1839) | geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 023336f3-59a6-44c4-bfae-6bf009c5444c | 2e6952d9-ae1b-4ac8-b76b-293ee19ada30 | LACMIP 421.18 | Nassariidae | Nassariidae | Nassarius | perpinguis | NA | Caesia | perpinguis | NA | Caesia perpinguis (Hinds, 1844) | geopoint_datum_error , rev_geocode_eez , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 023d255e-3614-4765-8b5f-75580f0b72b1 | 60318c6a-b4e8-420a-a320-ab34190a87aa | LACMIP 137.1 | Myidae | Myidae | Platydon | cancellatus | NA | Platyodon | cancellatus | NA | Platyodon cancellatus (Conrad, 1837) | geopoint_low_precision , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , dwc_order_replaced , gbif_taxon_corrected , idigbio_isocountrycode_added , gbif_canonicalname_added , dwc_scientificnameauthorship_replaced, dwc_taxonid_added , dwc_parentnameusageid_added , dwc_genus_replaced |
| 023de46a-ebc1-4ed8-b870-893174e283f7 | 4a90361d-e784-459a-868e-bc15ba99eee2 | LACMIP 17650.56 | Naticidae | Naticidae | Neverita | reclusiana | NA | Glossaulax | reclusiana | NA | Glossaulax reclusiana (Deshayes, 1839) | geopoint_datum_error , rev_geocode_eez , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , gbif_vernacularname_added , idigbio_isocountrycode_added , dwc_originalnameusageid_added, dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_parentnameusageid_added , gbif_taxon_corrected , gbif_canonicalname_added |
| 02458ba3-ae85-4fd3-ad6b-f4e7fddd0910 | 52105c17-8d1e-49ca-8a10-fc40d5ffa040 | LACMIP 29181.44 | Pterotrigoniidae | Trigoniidae | Notoscabrotrigonia | klamathonia | NA | Pterotrigonia | klamathonia | NA | Pterotrigonia klamathonia (Anderson, 1958) | geopoint_low_precision , dwc_taxonrank_replaced , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_family_replaced , dwc_order_replaced , dwc_genus_replaced , dwc_taxonomicstatus_added , gbif_taxon_corrected , dwc_taxonid_added , dwc_originalnameusageid_added , gbif_canonicalname_added |
| 0258072d-5307-4d14-becd-9da6c164dc3d | 0e7fee00-1ffc-41ee-aa58-04f4e07070dd | LACMIP 129.13 | Calyptraeidae | Calyptraeidae | Crepidula | dorsata | NA | Crepipatella | dorsata | NA | Crepipatella dorsata (Broderip, 1834) | geopoint_datum_error , geopoint_low_precision , gbif_reference_added , dwc_parentnameusageid_added , dwc_taxonomicstatus_added , gbif_genericname_added , dwc_datasetid_added , gbif_taxon_corrected , idigbio_isocountrycode_added , gbif_canonicalname_added , dwc_taxonid_added , dwc_originalnameusageid_added, dwc_genus_replaced |
| 026635d9-39c2-47d8-8a8e-3be6767f6c2a | b07122cd-dc9d-4a24-bdd2-c4f12358433c | LACMIP 228.37 | Conidae | Conidae | Conus | californicus | NA | Californiconus | californicus | NA | Californiconus californicus (Reeve, 1844) | geopoint_datum_error , geopoint_low_precision , gbif_reference_added , gbif_genericname_added , dwc_datasetid_added , dwc_scientificnameauthorship_replaced, gbif_vernacularname_added , dwc_parentnameusageid_added , idigbio_isocountrycode_added , dwc_genus_replaced , dwc_taxonomicstatus_added , dwc_taxonid_added , dwc_multimedia_added , gbif_taxon_corrected , gbif_canonicalname_added |
When iDigBio makes modifications to data, these actions are recorded with data quality flags, for instance you will notice that all of the rows in the filtered data above have the flag “dwc_genus_replaced.” We could have used values in the flags field, like “dwc_genus_replaced,” to search for records back at the beginning of this demo. You can learn more about the flags that iDigBio uses here.
Summarize differences in the data
If you want to make changes based on the modifications we have
discovered here, it may be helpful to summarize the distinct
modifications, as opposed to seeing them repeated across many individual
specimen records. We can summarize the distinct modifications for genus
names using the group_by and tally functions
from the dplyr package.
# Summarize modifications made to genus names
df_names %>%
filter(provider_genus != aggregator_genus) %>%
# Because of the nature of scientific names, it makes sense to group data by
# all of the primary fields that comprise a scientific name
group_by(provider_genus, provider_species, provider_subspecies,
aggregator_genus, aggregator_species, aggregator_subspecies,
provider_scientificName) %>%
# Count how many rows are affected by this modification made to genus name
tally() %>%
# Order by frequency of rows affected
arrange(desc(n)) %>%
kable() %>%
kable_styling(bootstrap_options = c("striped", "hover", "condensed"),
font_size = 12,
fixed_thead = T) %>%
column_spec(c(4,5,6), color = "red") %>%
scroll_box(width = "100%", height = "400px")| provider_genus | provider_species | provider_subspecies | aggregator_genus | aggregator_species | aggregator_subspecies | provider_scientificName | n |
|---|---|---|---|---|---|---|---|
| Glossaulax | reclusiana | NA | Neverita | reclusiana | NA | Glossaulax reclusiana (Deshayes, 1839) | 12 |
| Caesia | perpinguis | NA | Nassarius | perpinguis | NA | Caesia perpinguis (Hinds, 1844) | 8 |
| Patinopecten | healeyi | NA | Pecten | healeyi | NA | Patinopecten healeyi (Arnold, 1906) | 5 |
| Californiconus | californicus | NA | Conus | californicus | NA | Californiconus californicus (Reeve, 1844) | 4 |
| Hirtoscala | indianorum | NA | Epitonium | indianorum | NA | Hirtoscala indianorum (Carpenter, 1864) | 4 |
| Dendostrea | vespertina | NA | Ostrea | vespertina | NA | Dendostrea vespertina (Conrad, 1854) | 3 |
| Mitrella | gausapata | NA | Alia | gausapata | NA | Mitrella gausapata (Gould, 1850) | 3 |
| Pterotrigonia | klamathonia | NA | Notoscabrotrigonia | klamathonia | NA | Pterotrigonia klamathonia (Anderson, 1958) | 3 |
| Serpulorbis | squamigerus | NA | Thylacodes | squamigerus | NA | Serpulorbis squamigerus (Carpenter, 1857) | 3 |
| Shaskyus | festivus | NA | Pteropurpura | festiva | NA | Shaskyus festivus (Hinds, 1844) | 3 |
| Cerithideopsis | californica | NA | Cerithidea | californica | NA | Cerithideopsis californica (Haldeman, 1840) | 2 |
| Chlorostoma | funebralis | NA | Tegula | funebralis | NA | Chlorostoma funebralis (A. Adams, 1855) | 2 |
| Crepipatella | dorsata | NA | Crepidula | dorsata | NA | Crepipatella dorsata (Broderip, 1834) | 2 |
| Glycymerita | major | NA | Glycymeris | major | NA | Glycymerita major (Stanton, 1896) | 2 |
| Hamulus | onyx | NA | Pyrgopolon | onyx | NA | Hamulus onyx Morton, 1834 | 2 |
| Acanthocardia | brewerii | NA | Cardium | brewerii | NA | Acanthocardia (Schedocardia) brewerii (Gabb, 1864) | 1 |
| Acteonella | oviformis | NA | Actaeonella | oviformis | NA | Acteonella oviformis Gabb, 1869 | 1 |
| Chama | exogyra | NA | Pseudochama | exogyra | NA | Chama exogyra Conrad, 1837 | 1 |
| Chlamys | opuntia | NA | Pecten | opuntia | NA | Chlamys opuntia (Dall, 1898) | 1 |
| Chlorostoma | montereyi | NA | Tegula | montereyi | NA | Chlorostoma montereyi (Kiener, 1850) | 1 |
| Cymbophora | stantoni | NA | Mactra | stantoni | NA | Cymbophora stantoni (Arnold, 1908) | 1 |
| Euspira | draconis | NA | Glossaulax | draconis | NA | Euspira draconis (Dall, 1903) | 1 |
| Gervillia | NA | NA | Gervillaria | alifera | NA | Gervillia sp. | 1 |
| Hesperaptyxis | luteopictus | NA | Fusinus | luteopictus | NA | Hesperaptyxis luteopictus (Dall, 1877) | 1 |
| Hirtoscala | hindsii | NA | Epitonium | hindsii | NA | Hirtoscala hindsii (Carpenter, 1856) | 1 |
| Isorobitella | trigonalis | NA | Aligena | trigonalis | NA | Isorobitella trigonalis (Carpenter, 1857) | 1 |
| Mexicardia | procerum | NA | Americardia | media | NA | Mexicardia procerum (Sowerby I, 1833) | 1 |
| Neostylidium | eschrichtii | NA | Stylidium | eschrichtii | NA | Neostylidium eschrichtii (Middendorff, 1849) | 1 |
| Pachycardium | coronaense | NA | Cardium | coronaensis | NA | Pachycardium coronaense (Packard, 1922) | 1 |
| Pachydiscus | buckhami | NA | Eupachydiscus | grossouvrei | NA | Pachydiscus buckhami Usher, 1952 | 1 |
| Pachydiscus | catarinae | NA | Eupachydiscus | catarinae | NA | Pachydiscus (Neodesmoceras) catarinae (Anderson & Hanna, 1928) | 1 |
| Platyodon | cancellatus | NA | Platydon | cancellatus | NA | Platyodon cancellatus (Conrad, 1837) | 1 |
| Procladius | NA | NA | Paracladius | NA | NA | Procladius sp. | 1 |
| Pterotrigonia | evansana | NA | Pleurotrigonia | jacobseni | NA | Pterotrigonia evansana (Meek, 1858) | 1 |
| Pterotrigonia | NA | NA | Protrigonia | NA | NA | Pterotrigonia sp. | 1 |
After reviewing the summarized data, you may wish to review individual specimens and possibly update their data. We can use the information from the summary above to search for the catalog numbers of which specimens to review.
# Search for specimen records of an example modified genus name
df_names %>%
filter(provider_genus == "Glossaulax" & provider_species == "reclusiana") %>%
select(catalogNumber)## catalogNumber
## 1 LACMIP 8226.206
## 2 LACMIP 20187.59
## 3 LACMIP 42035.85
## 4 LACMIP 41678.50
## 5 LACMIP 25446.87
## 6 LACMIP 22413.169
## 7 LACMIP 2685.9
## 8 LACMIP 4396.20
## 9 LACMIP 466.63
## 10 LACMIP 31263.78
## 11 LACMIP 16520.155
## 12 LACMIP 17650.56