[Therion] How to extract the length of each centerline ?
Hi Xavier, I understood you works on windows I think you can use a tools to do the first step for example : http://sqlitebrowser.sourceforge.net/ and create query on sql language to select the data you need with where conditions. Regards, Laurent 2012/5/29, Marco Corvi : > hi xavier, > > just export as database, say with output "cave.sql", > make a db with it: "sqlite3 cave.db< cave.sql". > open the db and select from the table centreline: "sqlite3 cave.db" and at > the prompt > > "select title, length from centreline;" > > or "select title, length from centreline where title not null;" > use ".schema centreline" to see the fields of the table, > ".help"for help. > > > marco > > > > > From: Xavier Robert > To: Therion > Cc: stephane lips > Sent: Tuesday, May 29, 2012 11:43 AM > Subject: [Therion] How to extract the length of each centerline ? > > Hi all, > > I am still working on the survey of the Jean-Bernard system in the French > Alps. I have a bunch of different centerlines series, and I need to extract > the length of each centerline to link them to the history of the > exploration/surveying. > > I understood how to export the SQL database of the cave system, however, as > I do not know at all how to deal with SQL databases, I wondering if there is > there an easy way to extract this information with a command similar to > "export survey-list" ? The best will be an output like "centerline_ID - > Station_first - Station_last - Centerline_length - Topo_date" ! > > Cheers, > > Xavier > > > > ___ > Therion mailing list > Therion at speleo.sk > http://mailman.speleo.sk/mailman/listinfo/therion
[Therion] lat-long coordinate system not supported for output in export cave-list
Thanks Stacho, This explains why it was not working! I look forward to its future implementation. Best regards Xavier Le 29/05/2012 16:27, Stacho Mudrak a écrit : > I am sorry Xavier for the late answer, I am finishing my TODO list and > I have found this e-mail. > > In your case "cs lat-long" can not be used, because only cartesian > coordinate systems can be used for calculations. > > Of course, for export it is possible to convert them back to lat-long, > but -cs option for cave-list is not yet implemented. > > I will put it in the TODO list. > > Sorry again for late answer, S. > > On 15 May 2012 19:40, Xavier Pennec wrote: >> In the version 5.3.9 of therion, I get the following error: >> \Program Files (x86)\Therion\therion.exe: error -- HierleGeneral_thconfig.th >> [127] -- lat-long coordinate system not supported for output >> >> when I try to export entrance coordinates in lat-long format: >> >> cs lat-long >> export cave-list -o Topos/Coordonnees.html -location on >> >> Is there any reason why this should not work? That would be really usefull >> to point the coordinates of the entrances in google earth as they are not >> exported in kml files. It seems to me that it was working in previous >> version. >> >> Xavier >> >> -- >>> - >>> Xavier Pennec >>> Senior Research Scientist / Directeur de recherche >>> Asclepios project-team, INRIA Sophia-Antipolis >>> 2004 Route des Lucioles, BP93 >>> F-06902 Sophia-Antipolis Cedex, France >>> +33 4 92 38 76 64 >>> +33 6 78 35 16 90 >>> http://www-sop.inria.fr/asclepios/ >>> --- >> >> ___ >> Therion mailing list >> Therion at speleo.sk >> http://mailman.speleo.sk/mailman/listinfo/therion > ___ > Therion mailing list > Therion at speleo.sk > http://mailman.speleo.sk/mailman/listinfo/therion -- > - > Xavier Pennec > Senior Research Scientist / Directeur de recherche > Asclepios project-team, INRIA Sophia-Antipolis > 2004 Route des Lucioles, BP93 > F-06902 Sophia-Antipolis Cedex, France > +33 4 92 38 76 64 > +33 6 78 35 16 90 > http://www-sop.inria.fr/asclepios/ > ---
[Therion] lat-long coordinate system not supported for output in export cave-list
I am sorry Xavier for the late answer, I am finishing my TODO list and I have found this e-mail. In your case "cs lat-long" can not be used, because only cartesian coordinate systems can be used for calculations. Of course, for export it is possible to convert them back to lat-long, but -cs option for cave-list is not yet implemented. I will put it in the TODO list. Sorry again for late answer, S. On 15 May 2012 19:40, Xavier Pennec wrote: > > In the version 5.3.9 of therion, I get the following error: > \Program Files (x86)\Therion\therion.exe: error -- HierleGeneral_thconfig.th > [127] -- lat-long coordinate system not supported for output > > when I try to export entrance coordinates in lat-long format: > > cs lat-long > export cave-list -o Topos/Coordonnees.html  -location on > > Is there any reason why this should not work? That would be really usefull > to point the coordinates of the entrances in google earth as they are not > exported in kml files.  It seems to me that it was working in previous > version. > > Xavier > > -- >> >>  - >>  Xavier Pennec >>  Senior Research Scientist / Directeur de recherche >>  Asclepios project-team, INRIA Sophia-Antipolis >>  2004 Route des Lucioles, BP93 >>  F-06902 Sophia-Antipolis Cedex, France >>  +33 4 92 38 76 64 >>  +33 6 78 35 16 90 >> http://www-sop.inria.fr/asclepios/ >>  --- > > > ___ > Therion mailing list > Therion at speleo.sk > http://mailman.speleo.sk/mailman/listinfo/therion
[Therion] How to extract the length of each centerline ?
Hi all, I am still working on the survey of the Jean-Bernard system in the French Alps. I have a bunch of different centerlines series, and I need to extract the length of each centerline to link them to the history of the exploration/surveying. I understood how to export the SQL database of the cave system, however, as I do not know at all how to deal with SQL databases, I wondering if there is there an easy way to extract this information with a command similar to "export survey-list" ? The best will be an output like "centerline_ID - Station_first - Station_last - Centerline_length - Topo_date" ! Cheers, Xavier
[Therion] How to extract the length of each centerline ?
hi xavier, just export as database, say with output "cave.sql", make a db with it: "sqlite3 cave.db< cave.sql". open the db and select from the table centreline: "sqlite3 cave.db" and at the prompt "select title, length from centreline;" or "select title, length from centreline where title not null;" use ".schema centreline" to see the fields of the table, ".help"for help. marco From: Xavier Robert To: Therion Cc: stephane lips Sent: Tuesday, May 29, 2012 11:43 AM Subject: [Therion] How to extract the length of each centerline ? Hi all, I am still working on the survey of the Jean-Bernard system in the French Alps. I have a bunch of different centerlines series, and I need to extract the length of each centerline to link them to the history of the exploration/surveying. I understood how to export the SQL database of the cave system, however, as I do not know at all how to deal with SQL databases, I wondering if there is there an easy way to extract this information with a command similar to "export survey-list" ? The best will be an output like "centerline_ID - Station_first - Station_last - Centerline_length - Topo_date" ! Cheers, Xavier ___ Therion mailing list Therion at speleo.sk http://mailman.speleo.sk/mailman/listinfo/therion -- next part -- An HTML attachment was scrubbed... URL: <http://mailman.speleo.sk/pipermail/therion/attachments/20120529/205b0e1f/attachment.html>