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","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
    RecorderImages
    Graham Calow 14, 286
    David Nicholls 8, 758
    David Gould 1, 707
    HAPeacock 1, 433
    AJ Cann 1, 413
    Barbara Cooper 1, 296
    Rod Baker 1, 114
    Alan Semper 1, 081
    Mark Skevington 792
    Paul Ruddoch 724
    Steve Mathers 689
    Lostash 650
    Kate Nightingale 582
    Ron.stevens 580
    egaten 508
    Peter Smith 489
    Mike Higgott 486
    Craig Mabbett 360
    Annie Smith 351
    sue 326
    Saharima Roenisch 245
    steven lewis 236
    John Cranfield 224
    Jonesboy1 212
    Andy's Rutland 173
    martindgrimes 169
    Pete Leonard 161
    Adrian Russell 119
    Steve Woodward 114
    Chris Lythall 110
    c butterfield 95
    JamesCalow 85
    Lorraine Ellison 82
    andrew johnson 74
    Margaret McLoughlin 73
    Ken Charity 70
    PhilipCrowfoot 67
    MFBraker 50
    Sally Cunningham 43
    Adrian Baker 43
    Denise Stretton 41
    thebeesknees 41
    Melinda Bell 40
    David Taylor 36
    Simon Bennett 33
    Geoffrey Hall 32
    Maggie Frankum 31
    Ruth Dring 29
    Peter Thompson 27
    Richard Jeffery 25