Hi Iain

I can't think of a way you could do this within Recorder 6 itself, but in SQL Server Management Studio you could just do a simple select query to find any records without spatial references

Ensure NBNData is selected.

Click <new query> and type:

SELECT *
FROM Survey_Event
WHERE Survey_Event.Spatial_Ref is null or Survey_Event.Spatial_Ref = 'unknown'

If you didn't have that many you could copy the Survey_Event_Key from the results set and use the Go_To addin to go directly to that event in the observation hierarchy.

I'd probably then do a separate select query to identify any probs with spatial_ref_system, e.g.

SELECT *
FROM Survey_Event
WHERE Survey_Event.Spatial_Ref_System is null

Hope this helps,

Sarah

Sarah Shaw
Biodiversity Information Assistant
JNCC