On Sun, Feb 15, 2009 at 10:03 AM, Bruce Mutton <bruce.mutton at 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).
