search

gbif / portal-feedback

User feedback for the GBIF API, website and published data. You can ask questions here. 🗨❓
30 stars 16 forks source link

Need to include accepted species scientific name in CSV downloads #242

Open gbif-portal opened 7 years ago

gbif-portal commented 7 years ago

Need to include accepted species scientific name in CSV downloads

CSV downloads contain 1) scientificname, 2) taxonkey and (where applicable) 3) specieskey. The first and second match and may relate to a synonym for 3), which is always the key for an accepted species (not a synonym).

A common data processing task is to bin data in various ways and generate a species list for each bin (e.g. each country or grid cell or time period). It is really simple to do this using scientificname, but this is often a synonym for the accepted species. The specieskey can be used to group records by accepted species, but the associated name can only be found by further look-up.

CSV downloads should include an extra field (not sure what name would be best but equivalent to acceptedspeciesname.

fbitem-8b16037cf12b5f958bf6d374db1c1429764c1b51 Reported by: dhobern@gbif.org System: Chrome 59.0.3071 / Windows 10 0.0.0 Referer: https://demo.gbif.org/occurrence/download?dataset_key=95aef98e-f762-11e1-a439-00145eb45e9a Window size: width 1536 - height 735 API log&_a=(columns:!(request,response,clientip),filters:!(),index:'prod-varnish-',interval:auto,query:(query_string:(analyze_wildcard:!t,query:'response:%3E499%20AND%20(request:%22%2F%2Fapi.gbif.org%22)')),sort:!('@timestamp',desc))&indexPattern=uat-varnish-&type=histogram) Site log&_a=(columns:!(request,response,clientip),filters:!(),index:'prod-varnish-',interval:auto,query:(query_string:(analyze_wildcard:!t,query:'response:%3E399%20AND%20(request:%22%2F%2Fdemo.gbif.org%22)')),sort:!('@timestamp',desc))&indexPattern=uat-varnish-&type=histogram)

mdoering commented 7 years ago

dwc:acceptedNameUsage and dwc:acceptedNameUsageID would be the relevant Darwin Core terms