1 Topic by AndyFoy

  • AndyFoy
  • Consultant
  • Offline
  • Registered: 09-08-2006
  • Posts: 219

Topic: Spaces in Sample Spatial Ref

Hi

It seems to be possible to import occurrences into R6 when there are spaces in the sample spatial reference.  However, not only do the spaces not appear when then viewing the samples in the R6 field observation interface (so it's not easy to then spot the problem), but the spaces then cause errors in some of the SQL functions used by R6.

For example, when reporting on the 'Sample Easting SW Corner' or the 'Sample Northing SW Corner' in the report wizard the functions used (dbo.LCReturnEastingsV2 and dbo.LCReturnNorthingsV2) do not take into account of any spaces in the grid reference and return incorrect values.

Would it be possible to:

a) Stop the import wizard from allowing spatial references to contain spaces (or remove any spaces during the import)?

and

b) Change all the relevant SQL functions that use the sample spatial reference so that any spaces are removed before using them?

Many thanks
Andy

Andy Foy
Systems Manager
Greenspace Information for Greater London (GiGL) CIC
www.gigl.org.uk

2 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Spaces in Sample Spatial Ref

I thought that this has been fixed in that the Import wizard no longer allows spaces in Grid Refs. They show as  errors when validating the import. Not sure  in what version this was implemented. If you are using the latest version let me know and I will investigate further.

Mike Weideli

MikeWeideli's Website

3 Reply by AndyFoy

  • AndyFoy
  • Consultant
  • Offline
  • Registered: 09-08-2006
  • Posts: 219

Re: Spaces in Sample Spatial Ref

Hi Mike

Sorry, perhaps it has been fixed at the import wizard stage.  But presumably any data previously imported still contains spaces so there needs to be some kind of fix to avoid errors in the SQL functions.

Alternatively, perhaps you could write a batch update to remove any existing spaces.  However, has it also been fixed when performing imports using the NBN Zipped format?  If not then perhaps if should be fixed here too to avoid any existing spaces being shared with other R6 users?

Cheers
Andy

Andy Foy
Systems Manager
Greenspace Information for Greater London (GiGL) CIC
www.gigl.org.uk

4 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Spaces in Sample Spatial Ref

The Batch Updates in Problemv2.zip fixes any spaces in OSGB and OSNI references   
http://forums.nbn.org.uk/viewtopic.php?id=4003

It hasn't been fixed in NBN Imports which as you say would be a good idea.

Mike Weideli

MikeWeideli's Website