Latest records added

These are the latest records added, for all species. Click on any row in the table to highlight the record on the map. Use the question mark icon to click on the map and highlight the associated row in the table. Use the + icon on the map to switch between a satellite image and street map. For security reasons, black rhino, white rhino and pangolin are not shown. If you have a legitimate need for records of these species, contact us.

general_errors.There was an SQL error: ERROR: column "date" does not exist LINE 41: ORDER BY date, DESC LIMIT 21 ^ - SELECT as occurrence_id, w.title || ' | ' || o.survey_title as source, o.sample_id as sample_id, CASE WHEN o.preferred_taxon=o.default_common_name then o.preferred_taxon ELSE o.preferred_taxon || COALESCE(' | ' || o.default_common_name, '') END as taxon, o.taxon_group as taxon_group, o.taxa_taxon_list_id as taxa_taxon_list_id, o.location_name as location_name, regexp_replace(o.public_entered_sref, ',[^ ]', ', ', 'g') as entered_sref, o.date_start as date_start, o.date_end as date_end, o.date_type as date_type, CASE WHEN IN (2) THEN '' ELSE w.title || '-> ' END || CASE WHEN LENGTH(o.recorders)>30 THEN 'Recorder' ELSE o.recorders END as recorder, o.zero_abundance as zero_abundance, o.record_status as record_status, CASE WHEN CAST(o.created_by_id AS character varying) = '0' AND o.website_id IN (2) THEN true ELSE false END as belongs_to_user, o.certainty as certainty, round(length(o.public_entered_sref) / 24.0, 2) as fo, case o.record_status when 'C' then case o.certainty when 'C' then 'green' when 'L' then 'orange' when 'U' then 'red' else 'blue' end when 'V' then 'green' when 'D' then 'orange' when 'R' then 'red' else 'black' end as sc, case o.record_status when 'V' then 'green' when 'D' then 'orange' when 'R' then 'red' else 'blue' end as fc, length(o.public_entered_sref) as zi, st_astext(o.public_geom) as geom, o.images as images, case when o.input_form is null then '' else o.input_form end as input_form FROM cache_occurrences o JOIN websites w on JOIN users privacyusers ON WHERE ( OR IS NULL) AND (o.website_id in (2) OR OR privacyusers.allow_share_for_reporting=true OR privacyusers.allow_share_for_reporting IS NULL) AND o.website_id in (2) AND o.taxa_taxon_list_id !='3780' AND o.taxa_taxon_list_id !='3781' AND o.taxa_taxon_list_id !='4118' AND o.taxa_taxon_list_id !='4119' AND o.taxa_taxon_list_id !='4120' AND o.taxa_taxon_list_id !='4121' AND o.record_status not in ('I','T') AND (0=1 OR o.record_status not in ('D','R')) AND o.release_status='R' AND (''='' OR st_intersects(o.public_geom, st_geomfromtext('',900913))) ORDER BY date, DESC LIMIT 21

Latest records map

Click anywhere on the sliding scale to zoom in or out quickly, or on the plus or minus signs at its top or bottom to zoom one step at a time. Or double-click to zoom in.