function get_GBIF_map_availability() { $sql = "SELECT he.taxon_concept_id FROM hierarchy_entries he\n WHERE he.hierarchy_id = " . Hierarchy::find_by_label('GBIF Nub Taxonomy')->id . " AND he.identifier!=''"; if ($this->test_taxon_concept_ids) { $sql .= " AND he.taxon_concept_id IN (" . $this->test_taxon_concept_ids . ")"; } $raw_stats = array(); foreach ($this->mysqli_slave->iterate_file($sql) as $row_number => $row) { $taxon_concept_id = trim($row[0]); $raw_stats[$taxon_concept_id] = "1"; } $this->save_category_stats($raw_stats, "get_GBIF_map_availability"); }