1

Topic: Generating a species list with first/last date recorded for a polygon

Hello

Just wondering if there is a report we could use to generate a species list for a site which included first/late date? We have found the system report V06-12 Detailed species list for single <location> which looks to get the info we would like, but using a location name. We tried to run the report as a test but had an error code specifying that there was an error in the sql code  and that string or binary data would be truncated.

Any help gratefully received,

Thanks

2

Re: Generating a species list with first/last date recorded for a polygon

Hi Simon - this sounded familiar! See
https://forums.nbn.org.uk/viewtopic.php?id=4750

I likewise would like to do something similiar based on a collection of polygons (our nature reserves), rather than using Location which is variable.

Cheers,
Andy.

3

Re: Generating a species list with first/last date recorded for a polygon

Hi Andy,

Ha look at that! Thanks very much for your help.

So just to confirm, at the moment there isn't a report we could use to get this info using polygons, or a work around you could think of?

Thanks again,

Simon

4

Re: Generating a species list with first/last date recorded for a polygon

As far as I'm aware there isn't anything out of the box. What I've done previously is use the report wizard using "Restrict to one or more polygons" to get a full list of taxa, and then do the summarizing outside of R6.  Though it should be possible to modify the Detailed species list report to filter by polygons. It's just not made it to the top of my to do list yet!

Andy.

5

Re: Generating a species list with first/last date recorded for a polygon

That's what we've have done too, glad to hear we haven't missed anything - thank you very much for your help!