Issue 14326
Create raw occurrence names export for fishes
14326
Reporter: mdoering
Assignee: mdoering
Type: Bug
Summary: Create raw occurrence names export for fishes
Priority: Major
Resolution: Fixed
Status: Closed
Created: 2013-11-01 15:55:43.994
Updated: 2013-11-02 11:11:52.245
Resolved: 2013-11-02 11:11:52.206
Description: Fishbase and WoRMS had requested on 16th September if we could do another raw fish name export again as we did for Fishbase last year. The export contained all distinct verbatim scientificNames as found in occurrences for those occurrences that have a higher nub taxon matching one of the following below. Please do this again.
Actinopterygii
Agnatha
Chondrichthyes
Chondrichtyes
Cyclostoma
Cyclostomata
Elasmobranchii
Holocephali
Selachii
Myxini
Osteichthyes
Osteichtyes
Pisces
Sarcopterygii
Teleostei
Jamoytiidae
Dipnorhynchidae
Dipteridae
Bothriolepididae
The actual fields exported had been these, but the same as for downloads would of course also work:
institutionID
datasetID
institutionCode
collectionCode
datasetName
scientificName
kingdom
phylum
class
order
family
genus
specificEpithet
infraspecificEpithet
verbatimTaxonRank
taxonRank
scientificNameAuthorship
scientificNameInterpreted
Please send the final files to:
Bailly, Nicolas (WorldFish)
Edward Vanden Berghe ]]>
Author: mdoering@gbif.org
Created: 2013-11-01 16:26:32.313
Updated: 2013-11-02 11:08:01.405
SELECT verbatim_scientific_name, dataset_id, count(*) AS occ_count, scientific_name_author, taxon_rank, verbatim_kingdom, verbatim_phylum, verbatim_class, verbatim_order, verbatim_family, verbatim_genus, verbatim_specific_epithet, verbatim_infraspecific_epithet
FROM occurrence_hdfs
WHERE
phylum_id in (204,2298862,119,120,121,5204761,238,4817458,4815623,4836892,3238258,4853178)
OR class_id in (204,2298862,119,120,121,5204761,238,4817458,4815623,4836892,3238258,4853178)
OR order_id in (204,2298862,119,120,121,5204761,238,4817458,4815623,4836892,3238258,4853178)
OR family_id in (204,2298862,119,120,121,5204761,238,4817458,4815623,4836892,3238258,4853178)
OR genus_id in (204,2298862,119,120,121,5204761,238,4817458,4815623,4836892,3238258,4853178)
GROUP BY verbatim_scientific_name, dataset_id, scientific_name_author, taxon_rank, verbatim_kingdom, verbatim_phylum, verbatim_class, verbatim_order, verbatim_family, verbatim_genus, verbatim_specific_epithet, verbatim_infraspecific_epithet
ORDER BY verbatim_scientific_name, dataset_id