Have just started playing with Therions sql outputs, and bumbling along. May have found a bug? Running the query select ID, SURVEY_ID, NAME, X, Y, Z, FLAG from STATION, STATION_FLAG group by SURVEY_ID, NAME; results in D SURVEY_ID NAME X Y Z FLAG 2 34 F100 2500604.74 6023114.36 620.49 fix 3 34 F101 2500601.9 6023115.01 618.94 fix 4 34 F102 2500599.78 6023118.02 620.73 fix 5 34 F103 2500604.18 6023127.05 622.96 fix 6 34 F104 2500613.11 6023143.64 625.37 fix 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. A bug, or am I misunderstanding something? Using 5.2.7 Bruce
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).
Thanks for the sql lesson Martin. Your example works. Seems like I've more to learn... I'll look up spatialite sometime. Bruce
participants (2)
-
Bruce Mutton -
Martin Budaj