Esta página fornece um resumo dos registos das contagens de borboletas introduzidos no istema na forma de mapa e tabela de observações.
{occurrence_id}<\/div>","datatype":"integer","internal_sql":"o.id"},"source":{"visible":"provisional_true","img":"false","autodef":false,"display":"Source","datatype":"text","sql":"snf.website_title || ' | ' || case when substring(snf.survey_title from 1 for length(snf.website_title)) = snf.website_title then trim(substring(snf.survey_title from length(snf.website_title)+1)) else snf.survey_title end","internal_sql":"snf.website_title || ' | ' || case when substring(snf.survey_title from 1 for length(snf.website_title)) = snf.website_title then trim(substring(snf.survey_title from length(snf.website_title)+1)) else snf.survey_title end"},"source_id":{"visible":"false","img":"false","autodef":false,"display":"Source ID","datatype":"text","sql":"o.website_id::varchar || '|' || o.survey_id::varchar","template":"{source_id}<\/span>","internal_sql":"o.website_id::varchar || '|' || o.survey_id::varchar"},"sample_id":{"visible":"false","img":"false","autodef":false,"sql":"o.sample_id","datatype":"integer","internal_sql":"o.sample_id"},"taxon":{"visible":"provisional_true","img":"false","autodef":false,"display":"Species","datatype":"species","sql":"cttl.preferred_taxon","internal_sql":"cttl.preferred_taxon"},"common":{"visible":"provisional_true","img":"false","autodef":false,"display":"Common name","datatype":"text","sql":"cttl.default_common_name","internal_sql":"cttl.default_common_name"},"taxon_group":{"visible":"provisional_true","img":"false","autodef":false,"display":"Taxon group","sql":"cttl.taxon_group","datatype":"text","internal_sql":"cttl.taxon_group"},"taxon_group_id":{"visible":"false","img":"false","autodef":false,"display":"Taxon group ID","sql":"o.taxon_group_id","datatype":"integer","internal_sql":"o.taxon_group_id"},"taxa_taxon_list_id":{"visible":"false","img":"false","autodef":false,"sql":"o.taxa_taxon_list_id","datatype":"integer","internal_sql":"o.taxa_taxon_list_id"},"location_name":{"visible":"provisional_true","img":"false","autodef":false,"display":"Site name","sql":"o.location_name","datatype":"text","internal_sql":"o.location_name"},"entered_sref":{"visible":"false","img":"false","autodef":false,"display":"Original grid ref","datatype":"text","sql":"coalesce(regexp_replace(#sample_sref_field#, ',[^ ]', ', ', 'g'), snf.public_entered_sref, onf.output_sref)","internal_sql":"coalesce(regexp_replace(#sample_sref_field#, ',[^ ]', ', ', 'g'), snf.public_entered_sref, onf.output_sref)"},"output_sref":{"visible":"provisional_true","img":"false","autodef":false,"sql":"onf.output_sref","display":"Grid ref","datatype":"text","internal_sql":"onf.output_sref"},"date_start":{"visible":"false","img":"false","autodef":false,"sql":"o.date_start","internal_sql":"o.date_start"},"date_end":{"visible":"false","img":"false","autodef":false,"sql":"o.date_end","internal_sql":"o.date_end"},"date_type":{"visible":"false","img":"false","autodef":false,"sql":"o.date_type","internal_sql":"o.date_type"},"date":{"visible":"provisional_true","img":"false","autodef":false,"display":"Date","datatype":"date"},"cache_created_on":{"visible":"false","img":"false","autodef":false,"sql":"to_char(o.created_on,'DD\/MM\/YYYY')","display":"Submitted date","datatype":"date","orderby":"cache_created_on_raw","internal_sql":"to_char(o.created_on,'DD\/MM\/YYYY')"},"cache_created_on_raw":{"visible":"false","img":"false","autodef":false,"sql":"o.created_on","display":"Submitted date unformatted","internal_sql":"o.created_on"},"cache_updated_on":{"visible":"false","img":"false","autodef":false,"sql":"to_char(o.updated_on,'DD\/MM\/YYYY HH24:MI')","display":"Last updated","orderby":"cache_updated_on_raw","internal_sql":"to_char(o.updated_on,'DD\/MM\/YYYY HH24:MI')"},"cache_updated_on_raw":{"visible":"false","img":"false","autodef":false,"sql":"o.updated_on","display":"Last updated unformatted","internal_sql":"o.updated_on"},"recorder":{"visible":"provisional_true","img":"false","autodef":false,"display":"Recorder","sql":"CASE WHEN (TRIM(snf.recorders) !~ ' ' AND LENGTH(snf.recorders)>30) THEN 'Recorder' ELSE snf.recorders END","datatype":"text","internal_sql":"CASE WHEN (TRIM(snf.recorders) !~ ' ' AND LENGTH(snf.recorders)>30) THEN 'Recorder' ELSE snf.recorders END"},"zero_abundance":{"visible":"false","img":"false","autodef":false,"display":"Zero abundance","sql":"o.zero_abundance","internal_sql":"o.zero_abundance"},"created_by_id":{"visible":"false","img":"false","autodef":false,"sql":"o.created_by_id","datatype":"integer","internal_sql":"o.created_by_id"},"record_status":{"visible":"false","img":"false","autodef":false,"display":"State","sql":"o.record_status","internal_sql":"o.record_status"},"record_substatus":{"visible":"false","img":"false","autodef":false,"display":"State","sql":"o.record_substatus","internal_sql":"o.record_substatus"},"release_status":{"visible":"false","img":"false","autodef":false,"display":"State","sql":"o.release_status","internal_sql":"o.release_status"},"certainty":{"visible":"false","img":"false","autodef":false,"display":"Certainty","sql":"o.certainty","internal_sql":"o.certainty"},"belongs_to_user":{"visible":"false","img":"false","autodef":false,"display":"Belongs to user","sql":"CASE WHEN CAST(o.created_by_id AS character varying) = '#user_id#' AND o.website_id IN (#website_ids#) THEN true ELSE false END","internal_sql":"CASE WHEN CAST(o.created_by_id AS character varying) = '#user_id#' AND o.website_id IN (#website_ids#) THEN true ELSE false END"},"belongs_to_site":{"visible":"false","img":"false","autodef":false,"display":"Belongs to site","sql":"CASE WHEN o.website_id IN (#website_ids#) THEN true ELSE false END","internal_sql":"CASE WHEN o.website_id IN (#website_ids#) THEN true ELSE false END"},"images":{"visible":"provisional_true","img":"true","autodef":false,"display":"Images","sql":"onf.media","internal_sql":"onf.media"},"input_form":{"visible":"false","img":"false","autodef":false,"sql":"case when canEdit.id is null then null when o.input_form is null or o.website_id not in (#website_ids#) or #force_default_input_form#=1 then '#default_input_form#' else o.input_form end","datatype":"text","internal_sql":"case when canEdit.id is null then null when o.input_form is null or o.website_id not in (#website_ids#) or #force_default_input_form#=1 then '#default_input_form#' else o.input_form end"},"pass":{"visible":"false","img":"false","autodef":false,"sql":"CASE WHEN o.data_cleaner_result='t' THEN '