1 Topic by Gordon Barker

  • Gordon Barker
  • Veteran
  • Offline
  • Registered: 15-05-2006
  • Posts: 344

Topic: Zero values in Sample Northing

Hi just trying to work out what has happened here.

I have some records which on exporting to ESRI shapefile appeared in the wrong location - the gridref is TF740008, but they appeared on the exported file as if the ref was TF74000000. As the data below shows the Sample Northing values are 0. I can sort of follow how this would create the exported shape that it does, via concatenation and trimming.

FID    475
Shape    Polygon
ID    475
SAMPLE_LOC    Oxburgh Hall: Home Covert, NW
SAMPLE_L_1    
SAMPLE_SPA    TF740008
SAMPLE_L_2    
SAMPLE_VAG    41474
TAXON_COMM    Small Green Nettle Weevil
TAXON_LATI    Phyllobius roboretanus
TAXON_GROU    insect - beetle (Coleoptera)
SAMPLE_REC    Martin Collier
OBS_COMMEN    small window trap in wet woodland, near pile of poplar logs, 27/6 to 19/7/13
ALL_DESIGN    
SAMPLE_NOR    0     (=Sample Northing Centre)
SAMPLE_EAS    574005    (=Sample Easting Centre)
SAMPLE_N_1    0                   (=Sample Northing SW Corner)
SAMPLE_E_1    574000        (=Sample Easting SW Corner)
SAMPLE_LON    0.5678
SAMPLE_LAT    52.5696

I can't actually find where the values for Sample Northing are held, they don't seem to be in the SAMPLE table. Can anyone suggest what I need to change. There appear to be only 96 records that have this problem, all of which are at the same location. The location will have been created by the import wizard on importing these records.

Thanks

Gordon Barker
Biological Survey Data Manager
National Trust

2 Reply by charliebarnes

  • charliebarnes
  • Veteran
  • Offline
  • From: Greater Lincolnshire
  • Registered: 07-09-2008
  • Posts: 1,396

Re: Zero values in Sample Northing

If I remember rightly the eastings/northing are automatically generated and not stored anywhere.

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

charliebarnes's Website

3 Reply by Gordon Barker

  • Gordon Barker
  • Veteran
  • Offline
  • Registered: 15-05-2006
  • Posts: 344

Re: Zero values in Sample Northing

I was hoping that wasn't going to be the case, as that might suggest there is something wrong with the function that generates these values. A lot easier to fix a few dodgy data points.

Gordon Barker
Biological Survey Data Manager
National Trust

4 Reply by RobLarge

  • RobLarge
  • RobLarge
  • Veteran
  • Offline
  • From: Wiltshire
  • Registered: 15-07-2008
  • Posts: 812

Re: Zero values in Sample Northing

Yes, there is a user defined function in the database which creates the easting and northing values (I think its the same function for both). If you have SQLMS you should be able to locate the function (I can't at the moment as I haven't installed the tools on my new machine yet) by Navigating to Databases/NBNData/Programmability/Functions/Scalar Valued Functions & looking through for one with a suitable looking name. Or look in the tables REPORT_ATTRIBUTE and REPORT_FIELD to find the name of the function.

That at least would give you access to the code which generates the eastings and northings. Beyond that I can't be much help right now I'm afraid.

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

RobLarge's Website

5 Reply by Gordon Barker

  • Gordon Barker
  • Veteran
  • Offline
  • Registered: 15-05-2006
  • Posts: 344

Re: Zero values in Sample Northing

Thanks Rob,

managed to find it there, it's dbo.LCReturnNorthingsV2. As it says that only invalid gridrefs would return a 0 I changed the location gridref back and forward which cascaded through to the samples and has solved the problem. There must have been an invisible character that got through the import wizard or something like that, as the gridref looked valid.

Gordon Barker
Biological Survey Data Manager
National Trust

6 Reply by RobLarge

  • RobLarge
  • RobLarge
  • Veteran
  • Offline
  • From: Wiltshire
  • Registered: 15-07-2008
  • Posts: 812

Re: Zero values in Sample Northing

Glad it worked for you Gordon

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

RobLarge's Website