This table shows recorders ordered by the number of records they have contributed to the NatureSpot database and the number of species these records cover. Click on the column headers to order each list, click again to reverse the order.

    Click on the Images in library tab above to see who's photos are currently displayed in the Species Library.

    cUrl POST request failed. Please check cUrl is installed on the server and the $base_url setting is correct.
    URL:https://warehouse1.indicia.org.uk/index.php/services/report/requestReport?report=library/recorder_name/species_and_occurrence_counts.xml
    Server response
    {"error":"There was an SQL error: ERROR: canceling statement due to statement timeout - \n select snf.recorders as recorder_name, count(DISTINCT o.taxon_meaning_id) as species_count, count(DISTINCT o.id) as occurrences_count, 8 as website_id\n from cache_occurrences_functional o\n JOIN cache_samples_nonfunctional snf on snf.id=o.sample_id\n WHERE o.website_id=8\n AND (CAST(o.survey_id as character varying)='' OR ''='')\n AND (trim('')='' OR ''='Click here' OR o.date_end >= CAST(COALESCE('','1500-01-01') as date))\n AND (trim('')='' OR ''='Click here' OR o.date_start <= CAST(COALESCE('','1500-01-01') as date))\n AND snf.recorders is not null AND snf.recorders <> ''\n GROUP BY recorder_name\n UNION\n select 'Total' as recorder_name, count(DISTINCT o.taxon_meaning_id) as species_count, count(DISTINCT o.id) as occurrences_count, 8 as website_id\n from cache_occurrences_functional o\n WHERE o.website_id=8\n AND (CAST(o.survey_id as character varying)='' OR ''='')\n AND (trim('')='' OR ''='Click here' OR o.date_end >= CAST(COALESCE('','1500-01-01') as date))\n AND (trim('')='' OR ''='Click here' OR o.date_start <= CAST(COALESCE('','1500-01-01') as date))\n AND 'yes'!='no'\n ORDER BY \"occurrences_count\" desc, species_count DESC, occurrences_count DESC LIMIT 1000 OFFSET 20","code":44,"file":"D:\\websites\\warehouse\\system\\libraries\\drivers\\Database\\Pgsql.php","line":342,"trace":[]}
    There was an SQL error: ERROR: canceling statement due to statement timeout - select snf.recorders as recorder_name, count(DISTINCT o.taxon_meaning_id) as species_count, count(DISTINCT o.id) as occurrences_count, 8 as website_id from cache_occurrences_functional o JOIN cache_samples_nonfunctional snf on snf.id=o.sample_id WHERE o.website_id=8 AND (CAST(o.survey_id as character varying)='' OR ''='') AND (trim('')='' OR ''='Click here' OR o.date_end >= CAST(COALESCE('','1500-01-01') as date)) AND (trim('')='' OR ''='Click here' OR o.date_start <= CAST(COALESCE('','1500-01-01') as date)) AND snf.recorders is not null AND snf.recorders <> '' GROUP BY recorder_name UNION select 'Total' as recorder_name, count(DISTINCT o.taxon_meaning_id) as species_count, count(DISTINCT o.id) as occurrences_count, 8 as website_id from cache_occurrences_functional o WHERE o.website_id=8 AND (CAST(o.survey_id as character varying)='' OR ''='') AND (trim('')='' OR ''='Click here' OR o.date_end >= CAST(COALESCE('','1500-01-01') as date)) AND (trim('')='' OR ''='Click here' OR o.date_start <= CAST(COALESCE('','1500-01-01') as date)) AND 'yes'!='no' ORDER BY "occurrences_count" desc, species_count DESC, occurrences_count DESC LIMIT 1000 OFFSET 20
    RecorderImages
    Maggie Frankum 30
    Ruth Dring 29
    Richard Jeffery 27
    Peter Thompson 27
    MTR 23
    Bob Sheridan 23
    Tim Caldicott 21
    Beckyboo 21
    Uta Hamzaoui 20
    David Gray 19
    glfmaf14 19
    Dave Neville 19
    Paul Roberts 19
    David Robinson 19
    Barry Ingram 18
    John Hayes 18
    John Tinning 17
    Lindsi Donovan 16
    Jon Barker 14
    David Perrins 14
    David Scott 14
    Fran Marsland 14
    Carl Baggott 13
    irturner 13
    Ray Pearce 13
    Paul Riddle 12
    philjohn 12
    Orientalis 11
    Hip-Humblebee 11
    BurbageNP 11
    Jane Hollingworth 11
    Paul Palmer 10
    klex 10
    Kate Moore 9
    Liamandrews 9
    Keith Tailby 8
    grahamstocks 8
    Nigel Judson 8
    Jason Canning 8
    Example species 8
    Keith Hextall 7
    Steve Ford 7
    Jean 7
    Roberto52 7
    Dave Whiting 7
    Roger Collier 7
    Cherryl Benyon 7
    Ben Devine 7
    Richard Pegler 7
    JamieG 7