1

Topic: Entering 2km data

How do you import data that has been recorded with Grid References at 2km resolution into Recorder. The provided Site Names would have to be imported into Location Name as no standard naming convention has been used.
The only way I can think this could be done, is to create a dummy Location as the grid reference, and then manually add the Grid Square as a Tetrad into Geo Info for each location. Is there any way this could be automated, or is there some better method?

Harry Clarke
Surrey County Butterfly Recorder

2

Re: Entering 2km data

Perhaps I haven't fully understood the problem, but  Recorder will accept the standard tetrad grid reference eg SY67A etc. Recorder doesn't have to have locations (either ones in the hierrarchy or the location name field)  associated with records.

Mike Weideli

3

Re: Entering 2km data

Sorry for not making clear, This is because the data is not entered as a standard Tetrad grid reference, but as
TQ1256k
SU9662t

Harry Clarke
Surrey County Butterfly Recorder

4

Re: Entering 2km data

Do you think these are perhaps 200m references ( ie 25 parts of a 1km square), rather than the more normal 2km square ( 25 part of a 10km square ?),  If they are then Recorder can't hold them as such. You could either convert them to 1km squares just by dropiing the letters or  spurious 100m refrences by dropping the letter  and  adding in zeros   to make the refrencea 100m references. Either way you could add a note (say in sample reference) giving the true reference. 

If the above is true or if they are genuine 2km tetrads in a unusual format then youi can convert them before they go in in say Excel. If you are on R6 version 6.17 or above then a batch update after import is another option (I wrongly assumed you were on 6.12, from the other post -  but see now that this is the name of the report not your R6 version).

Mike Weideli

5

Re: Entering 2km data

After doing some more digging, I have found the "t" refers to Tetrad squares, and the "k" refers to 1km squares. Now that I know Recorder can handle proper 2km Grid References, I will use Excel to covert these strange grid references into proper recognisable grid references

Harry Clarke
Surrey County Butterfly Recorder