Re: Ideas wanted for identifying records within LRC area
I would like a quick way to filter records - using all manner of reporting - based on whether or not they are within the core geographical area covered by this LRC.
Currently if I want to do this using the report wizard (or XML reporting) I can retrict the search to a polygon that describes our LRC area. But this has a massive impact on performance - slowing queries down to the point that I avoid using them wherever possible.
I thought about adding a measurement to each taxon occurence to indicate whether or not it is within the LRC boundary. I could then filter on that. But to do this I would need a batch method for adding taxon occurrence measurements to lots of records at once (e.g. all those I've selected with a geographic filter).
Does anyone know if it is possible to construct a batch update to do this. Are there other ideas about how I might achieve my goal in a different way?
Rich
Biodiversity Project Officer
Field Studies Council