On Sun, Feb 15, 2009 at 10:03 AM, Bruce Mutton <bruce.mutton@paradise.net.nz> wrote:
select ID, SURVEY_ID, NAME, X, Y, Z, FLAG
from STATION, STATION_FLAG
group by SURVEY_ID, NAME;
etc. Problem is that ALL the 1200 station flags are fixed. Most should be null I think, there should be three entrance flags, and some continuation flags. At least that is what has been entered and what the 'caves' and 'continuations' outputs indicate.
Try this one: select ID, SURVEY_ID, NAME, X, Y, Z, FLAG from STATION, STATION_FLAG where station.id = station_flag.station_id; Martin BTW, there is a simple database http://www.gaia-gis.it/spatialite/ (based on SQLite) which makes it easy to perform geospatial analyses on combination of therion data and data obtained from other sources (e.g. in shapefile or csv formats).