1

Topic: Problem with Easy Download

Hi,

I'm using the BRC live warehouse.

On my website I have set up a download page using the Easy Download utility. I've just experimented with downloading a set of records from 1st January 2012 to now. When I download the spreadsheet (csv) I get all the records I'd expect but when I download in NBN Format I only get the 5 records where people entered their record with a lat/long rather than a grid reference. I suspect this may have something to do with the Irish grid but I'm not sure.

Any thoughts?

Thanks,
Fiona

Fiona McCrory
CEDaR Website Officer
www.nmni.com/cedar

2

Re: Problem with Easy Download

Hi Fiona

The two different downloads can use 2 different reports.
I'm looking at iRecord which I see uses the Occurrences Download 2 and NBN Exchange Format reports.
Both these reports take a number of parameters and these may differ between the two as well.
For example, I see the quality parameter is !R (not rejected I would hazard) for the csv download but V (verified) for the NBN download.
Is your configuration anything like this?

Jim Bacon.

3

Re: Problem with Easy Download

Hi Jim,
yes, my set-up is pretty much the same except that both quality parameters are set to V.

I think the problem may lie in the NBN Exchange format XML file where there is a line in the query that says

"and (s.entered_sref_system ilike 'osgb' or s.entered_sref_system ilike 'osni' or s.entered_sref_system = '4326' or s.entered_sref_system = '27700')"

I would hazard a guess that the "osni" should read "osie" but again I'm only guessing.

Roll on the Advanced training!!

Thanks,
Fiona

Fiona McCrory
CEDaR Website Officer
www.nmni.com/cedar

4

Re: Problem with Easy Download

Just an update to say John has fixed this on the warehouse and it's all working as expected.
Fiona

Fiona McCrory
CEDaR Website Officer
www.nmni.com/cedar

5

Re: Problem with Easy Download

Hi Fiona,

I'd say that is a pretty well informed guess! Your update was posted while I was trying to reply but I will continue as I don't think John has quite bottomed this one out.

The NBN exchange format only admits the projections OSGB, OSNI, OSI, plus lat/long with datum WGS84 or OSGB1936 so the NBN Export report has to filter records accordingly since Indicia can support any number of projections which can be added as optional modules.

Indicia uses slightly different names for the projections so the report also has to rewrite the projection names which results in the following (from inspection)

Indicia   Report 
4326      WGS84
27700     OSGB1936
osgb      OSGB
osie      OSIE

Is that right? Do you have OSIE in your report output? That would not be a valid output. It should be OSNI or OSI but which?

I always find it very confusing trying to disentangle different projections and this is not helped by the fact that OSI is an ambiguous name as far as I can see. An EPSG number is more helpful. Maybe the NBN define what they mean more precisely elsewhere.

I wrote the sref_osie module and my understanding was that OSNI, the Northern Ireland grid (EPSG:29901), had been replaced by an all Ireland  grid and, in particular, a 1975 adjustment was in use (EPSG:29903, I concluded). Consequently I didn't create an osni module.

However, I see that John made a change to the module some time back that may actually mean that the module is working in OSNI.

I have 2 adjacent maps in my hand.
Ordnance Survey of Northern Ireland Discoverer Series 1:50000 Sheet 27 copyright 2004. Reference System: Irish Grid, Geodetic Datum: Irleand 1965.
Ordnance Survey Ireland Discovery Series 1:50000 Sheet 26 copyright 2004. Transverse Mercator Projection. Airy modified spheroid 1975.
They join up fine. Are those two different ways of defining the same grid?

The Irish Grid is fabulously documented but my current grid reference is somewhere out at sea. Does any of this matter? At 1:50000, I detect no difference between grid refs from your form and the map in my hand.

Jim

6

Re: Problem with Easy Download

Hi Jim,
Thanks for the reply. It took me a while to get my head round what you were saying but I have asked my GIS colleague at NIEA who says:

In terms of co-ordinate system, N.I. government bodies currently use the Irish Grid system (TM65) and the N.I. EPSG grid code N.I. is ‘EPSG:29903’.

At least this does clarify that we should be using *29903* as we (in CEDaR) would definitely be following their guidelines. And, yes, my report output has OSIE in it, not OSNI.

In terms of the NBN format and what they mean by OSNI, I'm wondering who would be best to ask...

Ultimately I think there is no real difference and the short answer to your question "does any of this matter?" is no. But, I don't think I know enough to say that with confidence.

I'm happy to pursue this but it would be good to have some advice on who I should speak to. Should I approach Lynn Heeley in the first instance?

Thanks,
Fiona

Fiona McCrory
CEDaR Website Officer
www.nmni.com/cedar