Database Websites: Menu and Features
Find here the explanation for some features of the data base websites which might be useful for you to get information about your data.
Pull-Down Menus, Check-Boxes
In the different menu items you find normal check-boxes and check-boxes with pull-down menus:
- By clicking a check-box the according value is displayed, when you query the table.
- In the pull-down menu you can either choose a certain setting or status or you can do group by.
- By clicking on the link of the name of the pull-down you get the according table of the database showing you e.g. which different settings are available.
To get statistics of your data, e.g. how many hours are available of one source or how many sequences could not be calibrated, you can use the group by functionality. There are two different kinds:
- The one is available in the menu items RunInfo, SequInfo and DataSetInfo for several settings like SourceName, LightConditions, RunType, HvSettings, ... providing the number of hours, the number of events and the zenith angle range for the different values of the chosen setting. It is also possible to combine several group by.
- In StatusInfo another kind of group by option is available. By choosing it, you get a list for how many runs/sequences/datasets a step is already done, for how many it failed, etc. More details on this can be found also in the section Status of Data.
Interactions between Websites
Like runs, sequences and datasets are connected with each other, also the according websites are connected.
- On SequInfo you get for the sequence number a link to RunInfo getting a list of runs there.
- On Sequence Build Status you can find in each line (there's one line per night) links called 'Runs' and 'Sequ', with which you can get a list of all runs and sequences for the according night.
- On SequInfo and DataSetInfo you find links to plots and other websites, which are marked the following:
|Name||On SequInfo link to||On DataSetInfo link to|
|f||sequence file||dataset file|
|cal||calib plots*, i.e. calculation of calibration constants||-|
|sig||signal plots*, i.e. calibration of the data||-|
|star||star plots*, i.e. image cleaning||-|
|rbk||rbk entries from the according night||-|
|g||-||ganymed plots, i.e. background suppression|
|pdb||-||plots from plotdb for dataset file (sequences marked in colour)|
- *also the logging output is available here
- The links at the pull-down menus and the titles of the columns in the tables provide pages explaining the according table in the database.
Special Check-Boxes and Buttons
- Get .txt Button
- On several websites you get a 'Get.txt' button after sending the query. Pressing this button you can download the table you queried as txt-file.
- Print Button
- On several websites you get a 'Print' button after sending the query. Pressing this button the website is displayed without the menu, so that it is more convenient for printing.
- MySql Query
- On several websites you get a MySqlQuery '+/-' button after sending the query. By enhancing it, you get the mysql query for the displayed talbe at the bottom of the page. This might be useful for more experienced user and software developers.
- Only Offsources
- This checkbox in the menu item SequInfo on SequInfo allows you to display only dedicated offsource data, i.e. data where the source name starts with 'Off*'
- Only Sumtrigger
- This checkbox in the menu item SequInfo on SequInfo allows you to display only data which is taken with sumtrigger, i.e. data where sumtrigger events are found
- Incl. Offsources
- By unchecking this box in the menu item SequInfo on SequInfo you get all but dedicated offsource data, i.e. data where the source name starts with 'Off*'
- Incl. Test Sources
- By checking this box in the menu item SequInfo on SequInfo or on RunInfo you get all also data from sources which is marked as test in the database (different flag from the test-flag set by arehucas), e.g. data of so-called point runs or data of fadc-tests, camera-tests, grb-tests etc. is marked like this.
- Be aware, that this box is checked on RunInfo, but not on SequInfo.
- Hide and restore Rows
- Navigating in the database, you will recognize a small "-" on the left for each row. By clicking on the "-", the row will disappear (hide). Choose carefully which rows to hide, since you cannot restore single rows. However, it is possible to restore all hidden rows by clicking on the "+" in the very first row.
- Providing on SequInfo a column with links to the callisto log file, the callisto plots, the star log file, the star plots, the sequence file and a link to the sequence on sequence.php. On DataSetInfo it provides links to the dataset file, the ganymed plots and ganymed.php.
At the top of several pages (below the links to other pages) you can find a menu with several items which can be expanded (collapsed) by clicking on the button with + (-). In the following each of these menu items is explained:
Information of each run provided by arehucas in the *.run file. From this menu it is not only possible to chose which values are displayed, but also to choose runs with the same settings, conditions, source name, etc.
The settings like SourceName, RunType, LightConditions, ObservationMode, ... have a group by functionality, which allows you to look how many hours of data, how many events, how many runs are available with the same settings and which zenith angle range they cover.
By entering the sequence number in the field Sequ#____ (menu item Ranges) you can query all runs of one sequence.
Like RunInfo this contains the information coming from arehucas, but here it's of course only that information which all runs of one sequence have in common.
The settings like SourceName, LightConditions, ObservationMode, ... have a group by functionality, which allows you to look how many hours of data, how many events, how many sequences are available with the same settings and which zenith angle range they cover.
In this menu point you can choose which output values and data quality parameters you want to have displayed in the table. For your data selection, you might find the mean pedestal rms useful, as it is a measure of the night sky background. To check the quality of your data you might want to check the bad pixel values (first block of the menu).
In this menu point you can choose which output values and data quality parameters you want to have displayed in the table. This includes the values from the muon analysis, i.e. PSF, Ratio, ... Also the starguider values are available from this menu and you might find the rate after image cleaning, the spark rate and the parameter for the camera inhomogeneity useful.
This menu point, which is available for sequences, is very useful for the selection of data and offdata, as you can set here limits for the display of the numbers. According to your limits, the values are set in different colours in the following way:
|Color||Mean and Rms||Limit 1 and Limit 2|
|dark green||mean-rms < value < mean+rms||inside Limit 1|
|light green||value < mean-rms or value > mean+rms||-|
|yellow||value < mean-2⋅rms or value > mean+2⋅rms||-|
|orange||value < mean-3⋅rms or value > mean+3⋅rms||between Limit 1 and Limit 2|
|red||value < mean-5⋅rms or value > mean+5⋅rms||outside Limit 2|
The predefined values in the fields are empirical values from previous data checks.
This table contains the information which all sequences of one dataset have in common.
The settings like SourceName, ObservationMode, ... have a group by functionality, which allows you to look how many datasets are available with the same settings.
Information on the status of the processing of the runs / sequences / datasets, this includes information about the availablility of files. There is the possibility to group by the status, to see e.g. of how many of your sequences the star files are already available. More information about this in the section Status of Data.
In this menu item you can choose ranges for which you want to get the information of your data and the number of results you want to have displayed on one page.
Possible ranges are in runnumber, sequence number, dataset number, zenith distance and night. But also things like all selecting runs of one sequence / all sequences of one dataset or choosing the sourcename via regular expression are possible (e.g. '.*1553' returns all data with 1553 in the SourceName). With this it is e.g. also possible to check which runs have not been grouped to sequences by querying runs with the sequence number 00 in the RunInfo table. Furthermore it is possible to group your sequences by year, month or day. For more details see the single ranges explained below:
Appearing only on single pages:
- Runs from____to____
- Choose the range of runs which you want to have displayed. Only available on RunInfo.
- Sequences from____to____
- Choose the range of sequences which you want to have displayed. Only available on SequInfo
- Datasets from____to____
- Choose the range of datasets which you want to have displayed. Only available on DatasetInfo
- The runs belonging to the sequence number you enter here are displayed. Only available on RunInfo.
Available on several pages:
- Night (yyyy-mm-dd) from____to____
- In this fields you insert the night (i.e. date of sunrise) in the format yyyy-mm-dd and you get the runs/sequences from 13:00:00 of the day, on which the night starts to 13:00:00 of the day on which the night ends.
- Like this it is possible to query the data of one day, of several days or of one period.
- Regular expression are not possible in this fields.
- ZenithDistance from__to__
- Choose the zenith distance range of your data. For sequences the from__ field corresponds to ZdMin while to__ to ZdMax.
- Here you can enter the source name using regular expressions. This may be helpful, if either your source is in the database with two different names, or when you want to look for offdata at the same time. E.g. with .*1553 you get all data of PG 1553+113 and the dedicated off positions of this source.
- Group by Date
- Here you can group your sequences by year, month or day. Time, events and number of sequences for each entry are added automatically. Also minimum and maximum Zenithdistance is shown.
- With this pull-down menu you can choose the number of results you want to have displayed on one page.
From this website, you can query the entries from the electronic runbook. The field Date (yyyy-mm-dd):______ offers you the possibility to query a range of dates. You can enter e.g. 2007-07 to get all comments of which the time-stamp starts with 2007-07. This field has to be filled. To query all comments of one night, you can enter the date of the sunrise the field Night (yyyy-mmd-dd):______. Be sure, that the dates in the fields 'Night' and 'Date' do not exclude each other. In the field Search:________ you can search for words in the run book entries using regular expressions.
Like SequInfo (more information on the menu and features above), but provides in addition the possibility to select sequences and build a data set. This data set can either be inserted to the database or a data set file can be downloaded. For the inserting in the database, a personal user account is needed.