1 (edited by charliebarnes 03-02-2011 12:20:24)

Re: A location must be accompanied by a grid reference.

When importing from an e.g. excel spreadsheet:

A location must be accompanied by a grid reference.

Why?

I have hundreds of locations set up with site centroids in the location hierachy. Why do I now have to spend hours copying and pasting those grid references from the location hierachy to the excel spreadsheet before I import it?

How can I import site based records? Or can't I?

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

2

Re: A location must be accompanied by a grid reference.

I don't think you can  set up a site based record as a grid ref is always needed.  Just a thought, you could put in a grid ref totally oustside your area (say HU00) and import against that as long as you match all the Locations with this grid ref and don't let Recorder create them . Also the must not  have any geographical boundaries on the survey you use. You can then run a  batch update on anything with a sptail ref of HU00,  to change the Sample Spatial Ref, Sample Lat, Sample Long, Sample Spatial Ref qualifier to  those of the attached Location, plus a similar query in Survey Events.

Mike Weideli

3

Re: A location must be accompanied by a grid reference.

MikeWeideli wrote:

I don't think you can  set up a site based record as a grid ref is always needed.

Thought as much... I'd mark it as a bug - Recorder is quite happy to use grid references it obtains from the location when entering records via record cards etc.?

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

4 (edited by LBamforthSWT 23-04-2013 10:13:20)

Re: A location must be accompanied by a grid reference.

Hi,

Just wondering if the above is still the case or if there has been any development with the upgrade to 6.18?  It would be really useful to have the option of importing a list of records to a Location listed in the Location hierarchy and have the grid reference automatically linked to the centroid recorded for that Location, rather than having to add them in manually to the spreadsheet (or use a workaround such as the above). 

As stated above, when entering records directly into Recorder in a record card, using a Location listed in the Location hierarchy automatically fills in the grid reference with the associated site centroid.  Out of interest, if the grid reference for a listed Location is changed, would the grid reference for any records made using that Location be automatically updated to reflect the change?

Thanks,
Lindsay

Lindsay Bamforth
Biodiversity Data Analyst
Scottish Wildlife Trust

5

Re: A location must be accompanied by a grid reference.

While we are having this discussion, I would like to mention a little thing which always bothers me about the use of the word centroid in this context.

The word centroid has a specific meaning in GIS terms, that is a point, the coordinates of which are calculated from the geography of a GI object (or usually polygon). I imagine there are a number of ways this can be done and probably different GIS softwares use different methods, but basically it is an average of the node positions.

So far so good, but that implies a couple of things; firstly that there is only one centroid for a given polygon and software/methodology and secondly, that the centroid may not always lie within the polygon (where the polygon includes holes or the boundary is partially concave).

Obviously it is not desirable to have a spatial reference associated with a Location which is outside the location boundary, particularly when doing spatial queries. There is enough room for error in reducing a site-based record down to a six-figure grid reference without using a grid reference which isn't even in the right area/habitat or whatever. It is of course normal practice to assign a grid reference to a location by picking a suitable location (within the location boundary) from the map, but the temptation may be there to just let the GIS generate a centroid without checking.

All of this should be obvious to anyone who has spent any time handling GI biodiversity data, but it is also something which I often have to point out to less experienced users and the fact that Recorder uses Site Centroid as one of the spatial reference types (and doesn't offer a more appropriate term) doesn't help.

So my point is that when we talk about the grid reference associated with a Location in Recorder, it is better not to call it a centroid. It is in fact a nominal site grid reference.

Just a little personal niggle really, but I feel better now I have got it off my chest.

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre