A dataset containing 516329 records in GBIF matching the query: SELECT specieskey, COUNT(specieskey), waterbody FROM occurrence WHERE specieskey IS NOT NULL AND waterbody IS NOT NULL AND occurrencestatus = 'PRESENT' AND ( basisofrecord = 'HUMAN_OBSERVATION' OR basisofrecord = 'MACHINE_OBSERVATION' OR basisofrecord = 'OCCURRENCE' OR basisofrecord = 'LIVING_SPECIMEN' OR basisofrecord = 'MATERIAL_SAMPLE' ) AND NOT ARRAY_CONTAINS(issue, 'ZERO_COORDINATE') AND NOT ARRAY_CONTAINS(issue, 'COORDINATE_OUT_OF_RANGE') AND datasetKey != 'c8fb4ced-0374-46f7-8c03-5eb5a6b70640' GROUP BY specieskey, waterbody The dataset's 516329 records were derived from 2348 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0004139-250117142028555/datasets/export for details. Data from some individual datasets included in this download may be licensed under less restrictive terms.