1 Reply by davva

  • davva
  • Veteran
  • Offline
  • From: Scotland
  • Registered: 03-11-2008
  • Posts: 55

Re: Grid Square Error: Spatial reference system cannot be recognised

Hi again
I have encountered another strange error message. This time, it was while trying to add grid squares to a location. When I try to save my changes Recorder 6 says:

date/time         : 2009-06-25, 15:30:39, 78ms
computer name     : PC1
user name         : David Angel
operating system  : Windows XP Service Pack 3 build 2600
system language   : English
system up time    : 4 minutes 12 seconds
program up time   : 2 minutes 10 seconds
processor         : Intel(R) Pentium(R) 4 CPU 2.60GHz
physical memory   : 2048/2048 MB (free/total)
free disk space   : (C:) 18.58 GB
display mode      : 1280x1024, 32 bit
process id        : $84c
allocated memory  : 20.99 MB
command line      : RecorderApp.exe /66028
executable        : RecorderApp.exe
exec. date/time   : 2008-11-04 09:45
version           : 6.13.3.182
madExcept version : 2.7h
exception class   : ESpatialRefSystemConversionError
exception message : The spatial reference system cannot be recognised..

main thread ($850):
005742de RecorderApp.exe SpatialRefFuncs  2918 ConvertSystems
0057472b RecorderApp.exe SpatialRefFuncs  3076 CheckSRefInSRef
007336f9 RecorderApp.exe LocationDetails  3287 TfrmLocationDetails.CheckRefInSquares
0072c3c6 RecorderApp.exe LocationDetails  1230 TfrmLocationDetails.bbSaveClick
004b4048 RecorderApp.exe Controls              TControl.Click
004a9160 RecorderApp.exe StdCtrls              TButton.Click
004a9254 RecorderApp.exe StdCtrls              TButton.CNCommand
004b3eb0 RecorderApp.exe Controls              TControl.WndProc
004b6f0f RecorderApp.exe Controls              TWinControl.WndProc
004a9024 RecorderApp.exe StdCtrls              TButtonControl.WndProc
004b3c80 RecorderApp.exe Controls              TControl.Perform
004b7047 RecorderApp.exe Controls              DoControlMsg
004b769f RecorderApp.exe Controls              TWinControl.WMCommand
004b3eb0 RecorderApp.exe Controls              TControl.WndProc
004560d9 RecorderApp.exe Graphics              TCanvas.TextOut
00502917 RecorderApp.exe GeneralFunctions  268 DrawChoppedText
004b6b8c RecorderApp.exe Controls              TWinControl.MainWndProc
004528d8 RecorderApp.exe Classes               StdWndProc
7e4292de user32.dll                            SendMessageW
7e42a993 user32.dll                            CallWindowProcA
004b6ff3 RecorderApp.exe Controls              TWinControl.DefaultHandler
004b4450 RecorderApp.exe Controls              TControl.WMLButtonUp
004b3eb0 RecorderApp.exe Controls              TControl.WndProc
004b6f0f RecorderApp.exe Controls              TWinControl.WndProc
004a9024 RecorderApp.exe StdCtrls              TButtonControl.WndProc
004b6b8c RecorderApp.exe Controls              TWinControl.MainWndProc
004528d8 RecorderApp.exe Classes               StdWndProc
7e4196c2 user32.dll                            DispatchMessageA
004d4de3 RecorderApp.exe Forms                 TApplication.ProcessMessage
004d4e1a RecorderApp.exe Forms                 TApplication.HandleMessage
004d503a RecorderApp.exe Forms                 TApplication.Run
0099f832 RecorderApp.exe RecorderApp       317 initialization

Can anyone shed some light on this?
Cheers
David

[color=blue]David Angel[/color]
[color=blue]Data Officer[/color]
[color=blue]The Wildlife Information Centre[/color]

2 Reply by sallyrankin

  • sallyrankin
  • Administrator
  • Offline
  • Registered: 07-04-2006
  • Posts: 371

Re: Grid Square Error: Spatial reference system cannot be recognised

Are you including spaces in the grid references you are typing in? I have recently noticed that you get the error message 'The spatial reference system cannot be recognised.' if you type 'SU 760 820' instead of 'SU760820' when entering observations. I am sure previous versions of Recorder just automatically removed the spaces.

There are known problems with grid squares - see http://forums.nbn.org.uk/viewtopic.php?pid=2544#p2544. 'Creating a subsite of a location with many grid squares where the spatial reference is not within the top10 of the parent list produces an error' is supposed to be fixed in version 6.14.

Sally Rankin, JNCC Recorder Approved Expert
E-mail: s.rankin@btinternet.com
Telephone: 01491 578633
Mobile: 07941 207687

3 Reply by davva

  • davva
  • Veteran
  • Offline
  • From: Scotland
  • Registered: 03-11-2008
  • Posts: 55

Re: Grid Square Error: Spatial reference system cannot be recognised

Hi Sally
thanks for the reply.
There were no spaces in the spatial reference. Grid squares do seem to be the problem. I had one site with many, many  1km grid squares. The spatial reference I wanted to add was not within the area of the top ten entries.
I have backed up the database, removed all the 1 km grid square entries and replaced them with three 10 km squares. Will this cause any problems elsewhere in Recorder? What is the purpose of the grid square entries?
Cheers
David

[color=blue]David Angel[/color]
[color=blue]Data Officer[/color]
[color=blue]The Wildlife Information Centre[/color]

4 Reply by Matt_tullie

  • Matt_tullie
  • Veteran
  • Offline
  • From: Carlisle, Cumbria
  • Registered: 18-05-2007
  • Posts: 166

Re: Grid Square Error: Spatial reference system cannot be recognised

David,

If you can check the GRID_SQUARE table, you will probably find empty values in the SPATIAL_REF_SYSTEM column.

This certainly generates that error.
These empty cells can be populated with 'OSGB' (assuming that is the reference system) to counteract the problem.

[As noted in My later postings in topic: http://forums.nbn.org.uk/viewtopic.php?pid=2544#p2544..]

MAtt

Cumbria Biodiversity Data Centre
Tullie House Museum

Matt_tullie's Website

5 Reply by davva

  • davva
  • Veteran
  • Offline
  • From: Scotland
  • Registered: 03-11-2008
  • Posts: 55

Re: Grid Square Error: Spatial reference system cannot be recognised

Thanks Matt. I'll have a look at that.
Am I right in thinking that the grid square entries are not essential? Are They just there to prevent you adding records for a location that our outside its boundaries?

[color=blue]David Angel[/color]
[color=blue]Data Officer[/color]
[color=blue]The Wildlife Information Centre[/color]

6 Reply by Matt_tullie

  • Matt_tullie
  • Veteran
  • Offline
  • From: Carlisle, Cumbria
  • Registered: 18-05-2007
  • Posts: 166

Re: Grid Square Error: Spatial reference system cannot be recognised

That is my understanding.

M

Cumbria Biodiversity Data Centre
Tullie House Museum

Matt_tullie's Website