[Therion] sql output station flags incorrect

[Martin Budaj]

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).