|
The technical forum of the NBN Trust for use by the Network. It includes discussions and announcements on the NBN Atlas, Recorder 6 and Indicia |
You are not logged in. Please login or register.
Forum → How Do I... & Other Questions → Lat long
How can I pull out the Sample.Lat and Sample.Long in an XML report?
SELECT Sample.Spatial_ref,
YEAR(Sample.vague_date_start),
Sample.lat,
Sample.long
FROM Sample
INNER JOIN Taxon_Occurrence ON Taxon_Occurrence.Sample_key = Sample.Sample_key
WHERE ...Should this work? I get nothing, not even a column.
Just a hunch, have you tried aliasing the column names. E.g.
SELECT Sample.Spatial_ref AS Spatial_Reference,
YEAR(Sample.vague_date_start),
Sample.lat AS Latitude,
Sample.long AS Longitude
FROM Sample
INNER JOIN Taxon_Occurrence ON Taxon_Occurrence.Sample_key = Sample.Sample_key
WHERE...Recorder has special processing of grid columns in order to translate to your output system (e.g. OSGB) so it may be that kicking in.
Bingo! Could have sworn I tried that...
Forum → How Do I... & Other Questions → Lat long
Powered by PunBB 1.4.6, supported by Informer Technologies, Inc.