<html><body><div style="color:#000; background-color:#fff; font-family:bookman old style, new york, times, serif;font-size:12pt"><div><span>hi xavier,</span></div><div><br><span></span></div><div><span>just export as database, say with output "cave.sql",</span></div><div><span>make a db with it: "sqlite3 cave.db</span><span></span><span> < cave.sql".</span></div><div><span>open the db </span><span>and select from the table centreline: "</span><span>sqlite3 cave.db" and at the prompt<br></span></div><div><span>"select title, length from centreline;" <br></span></div><div><span>or "</span><span>select title, length from centreline </span><span>where title not null;"</span></div><div><span>use ".schema centreline" to see the fields of the table,</span></div><div><span>".help"</span><span> for help.<br></span></div><div><br><span></span></div><div><span>marco<br></span></div><div><br></div> <div style="font-family: bookman old style, new york, times,
serif; font-size: 12pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <font face="Arial" size="2"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Xavier Robert <xavier.robert01@gmail.com><br> <b><span style="font-weight: bold;">To:</span></b> Therion <therion@speleo.sk> <br><b><span style="font-weight: bold;">Cc:</span></b> stephane lips <stephane.lips@free.fr> <br> <b><span style="font-weight: bold;">Sent:</span></b> Tuesday, May 29, 2012 11:43 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> [Therion] How to extract the length of each centerline ?<br> </font> </div> <br>
Hi all,<br><br>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.<br><br>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" !<br><br>Cheers,<br><br>Xavier<br><br><br><br>_______________________________________________<br>Therion mailing list<br><a ymailto="mailto:Therion@speleo.sk" href="mailto:Therion@speleo.sk">Therion@speleo.sk</a><br>http://mailman.speleo.sk/mailman/listinfo/therion<br><br><br> </div> </div> </div></body></html>