TAP Tables and Views - CSA Guide
TAP TABLES AND VIEWS
The TAP system allows read access to the CSA database concerning CSA products. The available data is arranged into custom tables called 'views' which collect together useful attributes for searching for the data/metadata that you need. The tables below list the views with their column names, descriptions/examples and equivalents in the header metadata and in the old CAIO system.
Here are instructions for using TOPCAT to find this information.
Remember (from metadata page) that to find all the possible values for a column, the ADQL syntax is:
SELECT DISTINCT <column> FROM <view>
For example, to find a list of possible values, for e.g., 'category' column name:
SELECT DISTINCT entity FROM v_parameter
and the results are:
Photon, Instrument, Transformation, Particles, Ion_CNO, Compound, Magnetic_Field, Proton, Electric_Field, Other1, Helium+, Alpha, Electron, Observatory, Oxygen+, Ion
In alphabetical order, the views are:
VIEW NAME |
DESCRIPTION |
|
Dataset information, including dataset IDs, dates, formats, type (e.g. data or graphical) |
||
Inventory data, providing information about data within intervals of time and versions |
||
Dataset reference documents (usually caveat files) associated with dataset IDs |
||
Experiment information such as descriptions, datasets available and contact details |
||
File information such as version numbers and dates ingested |
||
Instrument information including instrument types and measurement types |
||
Descriptions and dates for Cluster and Double Star |
||
Descriptions and dates for each spacecraft, but also describes contextual datasets |
||
Detailed information about the parameters available, such as units and dependencies |
||
Pre-generated plot information, such as generation date and size of file |
||
Lists of quick look products and image size |
CSA.V_DATASET
COLUMN NAME |
DESCRIPTION/EXAMPLE |
HEADER METADATA |
CAIO ATTRIBUTE |
acknowledgement |
Acknowledgement text for use in publication |
ACKNOWLEDGEMENT |
DATASET.ACK |
allow_overlap |
Dataset allows overlap between files. |
|
DATASET.ALLOW_OVERLAP |
category |
E.g., 'CLUSTER', 'Diagnostics', 'MIRACLE', 'Moments', ... |
|
DATASET.CATEGORY |
compress |
Compressed: 0, 1 |
|
DATASET.CATEGORY |
crosscal |
Cross-calibration product: 0, 1 |
|
DATASET.CATEGORY |
data_type |
E.g., CAA_Parameter, CAA_Graphic, ... |
DATA_TYPE[3:] |
|
data_type_id |
Abbreviated data_type, e.g., CP, CG, ... |
DATA_TYPE[0:1] |
|
dataset_caveats |
Caveat dataset_id or 'See User Guide for caveats', ... |
|
DATASET.CATEGORY |
dataset_id |
Dataset ID, e.g., C1_CP_FGM_SPIN |
DATASET_ID |
DATASET.DATASET_ID |
dataset_reference |
Reference dataset IDs delivered if applicable |
|
|
date_last_file_ingested |
ISO time |
|
DATASET.DATE_LAST_FILE_INGESTED |
date_last_update |
ISO time |
|
DATASET.DATE_LAST_UPDATE |
description |
Description of dataset |
DATASET_DESCRIPTION |
DATASET.DESCRIPTION |
display_order |
Display order in GUI |
|
DATASET.DISPLAY_ORDER |
end_date |
End date of currently ingested data |
|
DATASET.END_DATE |
experiments |
Experiment (multiple for cross-calibration products) |
|
|
file_extension |
E.g., .cef, .cdf, .png, ... |
|
DATASET.FILE_EXTENSION |
gui_name |
Name as it appears in the web GUI |
|
DATASET.GUI_NAME |
ingestion_date |
ISO time, earliest date for this version |
|
DATASET.INGESTION_DATE |
instruments |
e.g., PEACE2, STAFF-SA4 |
|
|
"interval" |
E.g., "24 Hour", mainly for graphical products |
|
DATASET.INTERVAL |
inventory |
Is represented in the inventory plots: 0, 1 |
|
DATASET.INVENTORY |
is_cef |
CEF product: 0, 1 |
|
DATASET.IS_CEF |
is_istp |
ISTP compliant product: 0, 1 |
|
DATASET.IS_ISTP |
key_product |
Datasets shown when GUI Results' "Short List" box is ticked |
|
DATASET.KEY_PRODUCT |
"level" |
E.g., Calibrated, Raw, Derived, ... |
PROCESSING_LEVEL |
|
main_group |
Grouping for GUI, e.g., Graphical, Science, ... |
|
DATASET.MAIN_GROUP |
max_start_file_date |
ISO time |
|
DATASET.MAX_START_FILE_DATE |
max_time_resolution |
In seconds |
|
DATASET.MAX_TIME_RESOLUTION |
measurement_types |
E.g., Magnetic_Field, Energetic_Particles |
|
|
min_time_resolution |
In seconds |
|
DATASET.MIN_TIME_RESOLUTION |
multi_inst |
Multi-instrument: 0, 1 |
|
DATASET.MULTI_INST |
multi_sc |
Multi-spacecraft: 0, 1 |
|
DATASET.MULTI_SC |
observatory_name |
Name of spacecraft, e.g., Cluster-4, DoubleStar-1, ... |
|
OBSERVATORY.NAME |
on_demand |
0, 1 |
|
DATASET.ON_DEMAND |
person_reference |
PI Team personnel/contact information |
CONTACT_COORDINATES |
|
pregen_product |
0, 1 |
|
DATASET.PREGEN_PRODUCT |
quicklook_product |
0, 1 |
|
DATASET.QUICK_LOOK_PRODUCT |
released |
0, 1 |
|
DATASET.RELEASED |
start_date |
Start date of dataset, ISO time |
|
DATASET.START_DATE |
time_resolution |
In seconds |
|
DATASET.TIME_RESOLUTION |
title |
Technical title of dataset, may or may not be same as gui_name |
DATASET_TITLE |
DATASET.TITLE |
unit_name |
E.g., Bitmap, Particle Energy Flux, Raw, ... |
|
DATASET.UNIT_NAME |
CSA.V_DATASET_INVENTORY
No equivalents in header metadata
COLUMN NAME |
EXAMPLE |
CAIO ATTRIBUTE |
dataset_id |
E.g., 'C1_CP_FGM_SPIN' |
DATASET_INVENTORY.DATASET_ID |
end_time |
End of interval, ISO time |
DATASET_INVENTORY.END_TIME |
inventory_version |
Interval data version number |
DATASET_INVENTORY.VERSION |
num_instances |
Number of data points in the interval, integer |
DATASET_INVENTORY.NUM_INSTANCES |
start_time |
Start of interval, ISO time |
DATASET_INVENTORY.START_TIME |
CSA.V_DATASET_REFERENCED
No equivalents in header metadata
COLUMN NAME |
DESCRIPTION/EXAMPLE |
CAIO ATTRIBUTE |
dataset_id |
Dataset ID |
|
dataset_referenced_id |
Reference document dataset ID |
|
mandatory |
Mandatory delivery if applicable: 0, 1 |
REFERENCED_DATASET.MANDATORY |
CSA.V_EXPERIMENT
COLUMN NAME |
DESCRIPTION/EXAMPLE |
HEADER METADATA |
CAIO ATTRIBUTE |
caveats |
Caveat dataset ID or descriptive caveats |
EXPERIMENT_CAVEATS |
|
datasets |
List of datasets from this experiment |
|
|
description |
Description of experiment |
EXPERIMENT_DESCRIPTION |
EXPERIMENT.DESCRIPTION |
display_order |
Integer |
|
EXPERIMENT.DISPLAY_ORDER |
end_date |
ISO time |
|
EXPERIMENT.END_DATE |
investigators |
Experiment investigator contact details |
INVESTIGATOR_COORDINATES |
|
key_persons |
Key personnel contact details |
EXPERIMENT_KEY_PERSONNEL |
|
long_name |
Full experiment name, e.g., PEACE electron spectrometer |
|
EXPERIMENT.LONG_NAME |
mission |
Cluster or Double Star |
|
|
name |
Experiment acronym, e.g., PEACE |
EXPERIMENT |
EXPERIMENT.NAME |
"references" |
Reference publications |
EXPERIMENT_REFERENCES |
|
start_date |
ISO time |
|
EXPERIMENT.START_DATE |
CSA.V_FILE
COLUMN NAME |
DESCRIPTION/EXAMPLE |
HEADER METADATA |
CAIO ATTRIBUTE |
backup |
0, 1 |
|
|
caa_ingestion_date |
ISO time |
|
FILE.CAA_INGESTION_DATE |
compressed |
0, 1 |
|
FILE.COMPRESSED |
csa_ingestion_date |
ISO time |
|
FILE.CSA_INGESTION_DATE |
dataset_id |
Dataset ID |
|
FILE.DATASET_ID |
dataset_version |
File dataset version |
|
FILE.DATASET_VERSION |
date_last_update |
ISO time |
|
FILE.DATE_LAST_UPDATE |
distribution_path |
Folder within package |
|
FILE.DISTRIBUTION_PATH |
extension |
e.g., cef.gz |
|
FILE.EXTENSION |
file_end_date |
ISO time |
FILE_TIME_SPAN |
FILE.END_DATE |
file_name |
Full file name |
|
FILE.FILE_NAME |
file_size |
KB |
|
FILE.FILE_SIZE |
file_start_date |
ISO time |
FILE_TIME_SPAN |
FILE.START_DATE |
file_type |
E.g., cef |
FILE_TYPE |
FILE.FILE_TYPE |
logical_file_id |
Filename without extension |
LOGICAL_FILE_ID |
FILE.LOGICAL_FILE_ID |
time_coverage_in_sc |
File coverage time in seconds |
|
|
version_number |
File version number, integer |
VERSION_NUMBER |
FILE.VERSION_NUMBER |
CSA.V_INSTRUMENT
COLUMN NAME |
DESCRIPTION/EXAMPLE |
HEADER METADATA |
CAIO ATTRIBUTE |
datasets |
Instrument's dataset IDs |
|
|
description |
Instrument's description |
INSTRUMENT_DESCRIPTION |
INSTRUMENT.DESCRIPTION |
experiment_name |
Experiment name (acronym) |
|
|
instrument_types |
E.g., Antenna, Waveform_Receiver |
INSTRUMENT_TYPE |
INSTRUMENT_TYPE.TYPE |
measurement_types |
E.g., Radio_and_Plasma_Waves, Magnetic_Field |
MEASUREMENT_TYPE |
MEASUREMENT_TYPE.TYPE |
name |
Experiment name (acronym) + spacecraft number, e.g., PEACE2, HID-D2 |
INSTRUMENT_NAME |
INSTRUMENT.NAME |
observatories |
Spacecraft + number, e.g., DoubleStar-2, Cluster-4 (csa.v_observatory.name) |
OBSERVATORY |
OBSERVATORY.NAME |
CSA.V_MISSION
COLUMN NAME |
DESCRIPTION/EXAMPLE |
HEADER METADATA |
CAIO ATTRIBUTE |
agency |
ESA or CNSA_and_ESA |
MISSION_AGENCY |
MISSION.AGENCY |
description |
Mission description |
MISSION_DESCRIPTION |
MISSION.DESCRIPTION |
end_date |
ISO time |
MISSION_TIME_SPAN{21:] |
MISSION.END_DATE |
name |
Cluster or DoubleStar |
MISSION |
MISSION.NAME |
start_date |
ISO time |
MISSION_TIME_SPAN[:20] |
MISSION.START_DATE |
CSA.V_OBSERVATORY
COLUMN NAME |
DESCRIPTION/EXAMPLE |
HEADER METADATA |
CAIO ATTRIBUTE |
abbreviation |
C1-4, D1-2, CC for contextual and CM for all Cluster spacecraft |
|
OBSERVATORY.ABBREVIATION |
description |
Description of s/c including COSPAR ID, dates, orbits, etc. |
|
OBSERVATORY.DESCRIPTION |
instruments |
Instrument names, acronym + s/c number (csa.v_instrument.name) |
|
|
mission_name |
Cluster or DoubleStar |
MISSION |
|
name |
E.g., Cluster-1 or DoubleStar-2 |
OBSERVATORY |
OBSERVATORY.NAME |
time_span |
ISO time interval |
OBSERVATORY_TIME_SPAN |
OBSERVATORY.TIME_SPAN |
CSA.V_PARAMETER
COLUMN NAME |
DESCRIPTION/EXAMPLE |
HEADER METADATA |
CAIO ATTRIBUTE |
array_dimension |
Numbered dimensions of the array, e.g. for 1D = 0:20, 2D = 0:21, 1:3 |
SIZES |
|
cat_description |
Description of parameter |
CATDESC |
PARAMETER.CAT_DESC |
caveat |
e.g., "This assumes that the source is dipolar…" |
PARAMETER_CAVEATS |
PARAMETER.CAVEAT |
coordinate_system |
E.g., GSE>Geocentric Solar Ecliptic |
COORDINATE_SYSTEM |
PARAMETER.COORDINATE_SYSTEM |
dataset_id |
Dataset ID, e.g. C1_CP_EDI_AEDC |
|
|
data_type |
Data or Support_Data |
PARAMETER_TYPE |
PARAMETER.TYPE |
delta_minus |
A floating point number or parameter_id |
DELTA_MINUS |
PARAMETER.DELTA_MINUS |
delta_plus |
A floating point number or parameter_id |
DELTA_PLUS |
PARAMETER.DELTA_PLUS |
display_type |
Time_Series or Spectrogram |
DISPLAYTYPE |
PARAMETER.DISPLAY_TYPE |
entity |
The subject, e.g., Electron, Magnetic_Field, etc. |
ENTITY |
PARAMETER.ENTITY |
error_minus |
Parameter ID of error |
ERROR_MINUS |
PARAMETER.ERROR_MINUS |
error_plus |
Parameter ID of error |
ERROR_PLUS |
PARAMETER.ERROR_PLUS |
field_name |
Parameter name, e.g, Electron Gyrofrequency, Ion Count Rates, etc |
FIELD_NAME |
PARAMETER.FIELD_NAME |
fillval |
Value used as a fill value for gaps in data |
FILLVAL |
PARAMETER.FILL_VAL |
fluctuations |
E.g., Waveform, Wavelet_Cross_Spectrum |
FLUCTUATIONS |
PARAMETER.FLUCTUATIONS |
frame |
scalar>na, FAC>xyz, … |
FRAME |
PARAMETER.FRAME |
frame_origin |
Observatory |
|
PARAMETER.FRAME_ORIGIN |
frame_velocity |
Inertial or Observatory |
FRAME_VELOCITY |
PARAMETER.FRAME_VELOCITY |
label_axis |
Axis label, e.g., UT, Mag Field, etc |
LABLAXIS |
PARAMETER.LABEL_AXIS |
parameter_data |
Lists of e.g., energy levels or frequencies |
DATA |
|
parameter_dependency |
Numbered list of dependencies on other parameters |
DEPEND_0 |
|
parameter_id |
Parameter name + dataset_id, e.g., time_tags__C1_CP_EDI_AEDC |
|
PARAMETER.PARAMETER_ID |
parameter_label |
Numbered list of labels for parameter, e.g., 1:Bz, 1:By, 1:Bx for magnetic field |
|
|
parameter_representation |
1:x, 1:y, 1:z or 2:xx, 2:yy, 2:zz |
REPRESENTATION_1 |
|
property |
Property being measured, e.g., Vector, Magnitude, Raw_Particle_Counts, etc |
PROPERTY |
PARAMETER.PROPERTY |
quality |
Integer from 0-3, or parameter ID, e.g., status__C1_CP_EDI_SPIN |
QUALITY |
PARAMETER.QUALITY |
scale_max |
A floating point number |
|
PARAMETER.SCALE_MAX |
scale_min |
A floating point number |
|
PARAMETER.SCALE_MIN |
scale_type |
Linear or Log |
|
PARAMETER.SCALE_TYPE |
si_conversion |
Conversion from data to SI units, e.g. for nT: 1.0E-9>T |
SI_CONVERSION |
PARAMETER.SI_CONVERSION |
significant_digits |
An integer |
SIGNIFICANT_DIGITS |
PARAMETER.SIGNIFICANT_DIGITS |
target_system |
FAC or GSE>Geocentric Solar Ecliptic |
|
PARAMETER.TARGET_SYSTEM |
tensor_order |
If the parameter is a tensor, the order of that tensor |
TENSOR_ORDER |
PARAMETER.TENSOR_ORDER |
units |
Units of the parameter |
UNITS |
PARAMETER.UNITS |
value_type |
Data type, i.e., FLOAT, INT or CHAR |
VALUE_TYPE |
PARAMETER.VALUE_TYPE |
CSA.V_PREGEN_INVENTORY
No equivalents in header or CAIO.
COLUMN NAME |
DESCRIPTION/EXAMPLE |
compressed |
0, 1 |
experiment_name |
Experiment acronym, e.g., PEACE, CIS-CODIF |
file_name |
PNG filename |
file_size |
File size in bytes |
ingestion_date |
Date of ingestion (generation) |
"interval" |
DAILY, MONTHLY or YEARLY |
observatory_name |
Spacecraft, e.g., Cluster-1, (csa.v_observatory.name) |
start_date |
Start date within plot |
to_regenerate |
0, 1 |
CSA.V_QUICK_LOOK_DATASET
No equivalents in header or CAIO.
COLUMN NAME |
DESCRIPTION/EXAMPLE |
dataset_id |
Dataset ID of quick look product |
height |
Height in pixels |
max_height |
Maximum height in pixels |
max_width |
Maximum width in pixels |
ql_display_order |
Order to display in GUI |
width |
Width in pixels |