Is there a formula for calculating uSv/h from the pulse count and sample time values?

____________

There appears to be a new field after the experimental flag.

____________

Thanks, TJM.

____________

I have a problem, there are no more data is written to the last entry is 03/17/2012 23:52 why
look here http://radioactiveathome.org/boinc/gettrickledata.php?start=X&hostid=1722

lg,
Wolfgang

Sorry, my mistake Thanks for the answer TJM

lg,
Wolfgang
____________

hi guys,
many thanks for all this info.

However, is there any simple trick (script etc.) to download the whole database or all data for single station without manual downloading or generating plenty of download links?

We would like to perform some analyses of long term data (1 month, first only for 1-2 stations) and later maybe more.

thanks much

Thanks for reply TJM.
We are not going to download full dump regularly, but we would need it as start point.

I would appreciate any advice in this case.
For example if I use this link:
http://radioactiveathome.org/boinc/gettrickledata.php?start=X&hostid=Y
without any parameter set,
I get output for 48763789 to 48770832, while there is written that the database contains data 48763789:60449876

If I modify the link to:
http://radioactiveathome.org/boinc/gettrickledata.php?start=60449876&hostid=Y

I get the last portion of the data.
However, if I am right, the Sample ID (starts now at 48763789) changes, so I cannot use it as fixed value in a script.

I know, that I can jump to next data page by using the last sample id as the X parameter in the link.

Second, it would be necessary - if we consider daily database update - to somehow set the script to only load pages for the particular day.

Is there any additional parameter which could be used for this task or do I have to somehow calculate/guess the approximate number of data pages, which should be checked?

thanks

thank you very much TJM. We are currently running some analyses of the data and will see about the results. The method to download the data will also be discussed. :-)

thanks TJM,
I forwarded this info to my colleague. :-)

Second, what do you think about adding a new parameter marking whether the sensor is indoor or outdoors?

I am not sure whether the sensor is able to be placed outdoors without significant modifications so maybe such parameter would be useless.

Hello,

I need to recover the last 15 days from host ID 1787, because I've try to measure some bags of pellet ashes and I would like to do some calculations on the raw data.

And I've see that these file:

https://dl.dropbox.com/u/1912652/radioactive_data/2013_03.7z or
https://dl.dropbox.com/u/1912652/radioactive_data/2013_04.7z

do not exists.
Have you another site to download the raw data ?

Regards,

Ale

For everyone interested in getting the raw data returned from sensors, there is a simple script that allows synchronization with the database.

http://radioactiveathome.org/boinc/gettrickledata.php
http://radioactiveathome.org/boinc/gettrickledata.php?start=X&hostid=Y

The live database is limited up to 31 days back (it is cleared from time to time).

Could you please describe the data row format ones again? The image describing row format is unavailable.

Hi,

As I see there are only some of the dumps available (the last dump is 2012_09.7z).

Could you please share the data from October 2012 till June 2013 inclusively. I'll try to build some time series models for the data.



What about creating torrent files for the old dumps so the people could download old data to build their local copies of the database? And then sync up with your database using 'live' data access.

It will free your dropbox space.

We can use public free torrent trackers like openbittorrent.com or publicbt.com

We can find some volunteers to seed the data all the time.
E.g. I can seed 1 or 2 years of data archive on my always online PC.

I've seen some records with S sample type like

169943792,10000001,105,2013-07-18 04:46:17,0.000000,0.000000,5.000,S,1,0

TJM, Could you tell us what it is?

I can't get my raw data per script any longer

I ran a php-script to get the raw data for my machine, and since 5th November I can't get them any longer. Here's the error I receive:
(( Warning:
file(http://radioactiveathome.org/boinc/gettrickledata.php?start=180072691&hostid=1722)
[function.file]: failed to open stream: HTTP request failed!
HTTP/1.1 403 Forbidden ))

If I go there by browser, I still get them, but this doesn't work any more.
Has there been some changes to the database recently, or is there something else wrong or broken?

Thank you

Hi,

i've found a bug or feature i don't understand.

http://radioactiveathome.org/boinc/gettrickledata.php?start=201493843

12th line:

Hello
There is a problem with the file gettrickledata.php
the problem is Unable to connect to MySQL

Here's my script that I use to pull the new data, it's not commented at all but should be easy to understand anyway.
For performance reasons it's set to stop after 20 iterations (so each run it pulls up to 100k records) or when there's no more data available.

header('content-type: text/plain');
$rows_inserted = 1; //zeby wystartowac petle
$num_updates = 0;
while ($rows_inserted > 0 and $num_updates < 20) {
$result = mysql_query("SELECT MAX(id) FROM trickles_lite") OR die(mysql_error());
if (mysql_num_rows($result) == 0) {
$max_id = 0;
}
else {
$wynik = mysql_fetch_row($result);
$max_id = $wynik[0];
}
echo "Last local trickle id: $max_id\n";

$content = file_get_contents("http://radioactiveathome.org/boinc/gettrickledata.php?start=$max_id");
$content_array = explode("\n",$content);
if ($content_array[0] == "NO DATA") die("Remote server returned empty document");
$first_line = explode(":",$content_array[0]);
$remote_min_trickle_id = $first_line[0];
$remote_max_trickle_id = $first_line[1];
$content_size = sizeof($content_array);
echo "$content_size lines of data\n";
echo "Remote data min id: $remote_min_trickle_id, max id: $remote_max_trickle_id\n";
$rows_inserted = 0;
for ($i=1;$i<$content_size;$i++) {
if ($content_array[$i] == "NO DATA") continue;
$line_content = explode(",",$content_array[$i]);
$tdata_id = $line_content[0];
$tdata_hostid = $line_content[1];
$tdata_pomiar_raw = $line_content[2];
$tdata_data = $line_content[3];
$tdata_loc1 = $line_content[4];
$tdata_loc2 = $line_content[5];
$tdata_czas_pomiaru = $line_content[6];
$tdata_typ_pomiaru = $line_content[7];
$tdata_eksperyment = $line_content[8];
$tdata_revision_int = $line_content[9];
$tdata_vid_pid_int = 0; //to be changed later
if ($tdata_id) {
mysql_query("INSERT INTO trickles_lite vALUES($tdata_id,$tdata_hostid, $tdata_pomiar_raw, '$tdata_data', $tdata_loc1, $tdata_loc2, $tdata_czas_pomiaru, '$tdata_typ_pomiaru', $tdata_eksperyment, $tdata_revision_int, $tdata_vid_pid_int)") OR die(mysql_error());
$rows_inserted++;
}
}
echo "$rows_inserted records written to the local db\n";
$num_updates++;
} //while

Hello,

i get an error when i use the Query on my MySQL DB.
I using the SQL Software-Version: 5.1.61 - Source distribution Protokoll-Version: 10

After start the query i get following error.

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'header('content-type: text/plain')' at line 1


Using following Script with my stationsID.

header('content-type: text/plain');
$rows_inserted = 1; //zeby wystartowac petle
$num_updates = 0;
while ($rows_inserted > 0 and $num_updates < 20) {
$result = mysql_query("SELECT MAX(id) FROM trickles_lite") OR die(mysql_error());
if (mysql_num_rows($result) == 0) {
$max_id = 0;
}
else {
$wynik = mysql_fetch_row($result);
$max_id = $wynik[0];
}
echo "Last local trickle id: $max_id\n";

$content = file_get_contents("http://radioactiveathome.org/boinc/gettrickledata.php?start=0&hostid=12104");
$content_array = explode("\n",$content);
if ($content_array[0] == "NO DATA") die("Remote server returned empty document");
$first_line = explode(":",$content_array[0]);
$remote_min_trickle_id = $first_line[0];
$remote_max_trickle_id = $first_line[1];
$content_size = sizeof($content_array);
echo "$content_size lines of data\n";
echo "Remote data min id: $remote_min_trickle_id, max id: $remote_max_trickle_id\n";
$rows_inserted = 0;
for ($i=1;$i<$content_size;$i++) {
if ($content_array[$i] == "NO DATA") continue;
$line_content = explode(",",$content_array[$i]);
$tdata_id = $line_content[0];
$tdata_hostid = $line_content[1];
$tdata_pomiar_raw = $line_content[2];
$tdata_data = $line_content[3];
$tdata_loc1 = $line_content[4];
$tdata_loc2 = $line_content[5];
$tdata_czas_pomiaru = $line_content[6];
$tdata_typ_pomiaru = $line_content[7];
$tdata_eksperyment = $line_content[8];
$tdata_revision_int = $line_content[9];
$tdata_vid_pid_int = 0; //to be changed later
if ($tdata_id) {
mysql_query("INSERT INTO trickles_lite vALUES($tdata_id,$tdata_hostid, $tdata_pomiar_raw, '$tdata_data', $tdata_loc1, $tdata_loc2, $tdata_czas_pomiaru, '$tdata_typ_pomiaru', $tdata_eksperyment, $tdata_revision_int, $tdata_vid_pid_int)") OR die(mysql_error());
$rows_inserted++;
}
}
echo "$rows_inserted records written to the local db\n";
$num_updates++;
} //while

Hi,

It seems that raw data export has trouble now.

I see some PHP code instead of the data when I access http://radioactiveathome.org/boinc/gettrickledata.php

Could someone check please?