[Therion] Therion database web interface (Bruce)
Iâve looked at the sql output in the past and havenât been able to use much of the data, parts of it such as maps seem to be undocumented. Your request has caused me to look again. Iâm not sure youâll be able to do the things you want. I have a cave system (Whiterock in Mulu) which has 123 surveys listed in the database. Each survey has a unique id and a name apart from the first record which has an id of 1 and no name. All the surveys have a parent id of 1 apart from the first record which has a parent id of 0. If I look at the maps table there are 120 records and all are referenced to survey id 1 which is obviously the top level survey so I canât identify which survey each map belongs to. Iâve tried creating a container survey to contain all the sub surveys but, when I do, all maps are referenced to that container survey Similarly, if I look at the scraps table, all the scraps are referenced to the master survey. My index file has a map for plans and a map for elevations. Each of the maps contains all the scraps for that elevation. In addition all surveys have their own plan and elevation maps so that I can print out each survey map separately. I then created a master map which contained each of the individual survey maps but all the individual maps are still referenced to the master survey. What Iâve not tried to do is create a sql output for each survey. Iâm sure that wouldnât work anyway as the sql creates new tables and doesnât append records. This means you would have to create a separate database for each survey and there would be no easy way of linking them. I have done some work on Andrews code and when Iâm satisfied with the results Iâll post on the Wiki. Dave Clucas daveclucas.com sarawak-caves.com dave.clucas at icloud.com Exploring the World - One cave at a time -- next part -- An HTML attachment was scrubbed... URL: <http://mailman.speleo.sk/pipermail/therion/attachments/20140709/59f5ce16/attachment.html>
[Therion] Symbol different in legend to survey
Nice drawing Jenny. You appear to be using similar tricks to me to try to join scraps along curved pitch lines so that in colour by altitude the colour boundaries are hidden along drawn boundaries in the cave. I've been meaning to write a wiki page about how I do this. Nice to see I am not the only one. Footleg On 9 July 2014 06:47, Jenny Black wrote: > Hi, > > Sorry, I should have replied sooner. You are both right of course, the > symbols are the same size. It was an optical illusion due to the shape of > some of the area fills in the original survey > (http://expo.survex.com/expoimages/surveys/107-plan-2013-draft3.pdf), and > once I could see it there I convinced myself it was true in the cut down > example as well. Sorry to have wasted your time! > > Thanks, > Jenny > > > > On 26 June 2014 20:28, Stacho Mudrak wrote: >> >> Hi Jenny, >> >> this is magnification from your PDF file. Legend and map. To me, symbols >> look to be in the same scale. I am probably getting something wrong. >> >> S. >> >> > > > ___ > Therion mailing list > Therion at speleo.sk > http://mailman.speleo.sk/mailman/listinfo/therion >
