[Therion] How to extract the length of each centerline ?

[Sluka Martin]

On 29.5.2012, at 18:21, cawa sorix wrote:

> and create query on sql language to select the data you need with
> where conditions.

Nice database and query features has OpenOffice. After you import database from 
MySQL.

m.

[Therion] How to extract the length of each centerline ?

[Xavier Robert]

Hi,

Thanks a lot for your answers, that helps me a lot to understand how to use 
this database !
Regards,

Xav



Le 29 mai 2012 à 18:21, cawa sorix a écrit :

> 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 mailing list
> Therion at speleo.sk
> http://mailman.speleo.sk/mailman/listinfo/therion

[Therion] How to extract the length of each centerline ?

[cawa sorix]

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] How to extract the length of each centerline ?

[Xavier Robert]

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 ?

[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
-- next part --
An HTML attachment was scrubbed...
URL: