codes:productsdescription
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
codes:productsdescription [2015/10/15 09:42] bhcruz |
codes:productsdescription [2016/03/29 13:31] (current) bhcruz |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Products Description ====== | ====== Products Description ====== | ||
| + | Referenced tables in Eubrewnet: | ||
| + | * db.brewer_t: Brewer main table | ||
| + | * db.b_t: B files table | ||
| + | * db.b_ds_t: Individual Direct Sun measures in B files | ||
| + | * db.b_ds_summary_t: Direct Sun Summaries in B files | ||
| + | * db.icf_t: ICF files table | ||
| + | * [[devel:eubrewnetconfiguration#constants|db.configs_t]]: Uploaded by operators configurations table | ||
| + | * ozone_product_1_0: Level 1 Ozone Product Table | ||
| + | * ozone_product_1_5: Level 1.5 Ozone Product Table | ||
| + | * ozone_product_2_0: Level 2.0 Ozone Product Table | ||
| - | ===== Ozone Level 1 ===== | + | |
| - | Table: ozone_product_1_0 | + | ===== Level 1 ===== |
| + | ==== Ozone Level 1 ==== | ||
| + | ^ ozone_product_1_0 Table ^^^^ | ||
| + | ^ Field ^ Description ^ Unit ^ Reference ^ | ||
| + | | brewerid | Brewer identification number | | db.brewer_t | | ||
| + | | gmt | UT time of the measure in ISO 8601 format | GMT |[[http://www.iso.org/iso/es/home/standards/iso8601.htm|ISO 8601]]| | ||
| + | | configid | Configuration identification Numer | | db.configs_t | | ||
| + | | n_sum | Index of the daily summary | | | | ||
| + | | date_index | Continuous date index (0.0 = 0000-00-00T00:00:00Z) based in Matlab datenum | days | db.b_ds_t.date.toordinal + 366 + db.b_ds_t.mmmm_gmt / SECONDS_IN_A_DAY | | ||
| + | | sza | Solar zenith angle using time function | Degrees | [[devel:brewerpythonmodule#solar_zenith_angle| Brewer Python Module (Solar Zenith Angle)]] | | ||
| + | | airmass | Calculated airmass using time function | | [[devel:brewerpythonmodule#brewer_airmass| Brewer Python Module (Brewer Airmass)]] | | ||
| + | | temperature | Instrument temperature | Degrees | db.b_ds_summary_t.temp | | ||
| + | | filt | Applied neutral density filter | | db.b_ds_t.nd_filter_position / 64 | | ||
| + | | o3 | Calculated Ozone value with Standard algorithm + attenuation filter correction [[codes:ozoneproduct#level_1|Ozone Level 1]] | Dobson Units | [[devel:brewerpythonmodule#o3_so2|Brewer Python Module (o3_so2)]] | | ||
| + | | std_o3 | Standard deviation of the group of measures | Dobson Units | Brewer Operator Manual (Section 9.2.6) | | ||
| + | | so2 | Calculated so2 value with Standard algorithm + attenuation filter correction | Dobson Units | [[codes:ozoneproduct#level_1|Ozone Level 1]]| | ||
| + | | std_so2 | Standard deviation of the group of measures | Dobson Units | Brewer Operator Manual (Section 9.2.6) | | ||
| + | | latitude | Latitude of the Brewer Location | Degrees | db.b_t, db.configs_t | | ||
| + | | longitude | Longitude of the Brewer Location | Degrees | db.b_t, db.configs_t | | ||
| + | | press | Medium Pressure of the Brewer Location | Milibars | db.b_t, db.configs_t | | ||
| + | | configdate | UT Date of the used configuration in ISO 8601 format | GMT | db.b_t, db.configs_t | | ||
| + | | configtype | Type of the used configuration: B header(1), ICF (2), Config (3) | | db.b_t, db.icf_t db.configs_t | | ||
| + | | process_date | Date and time when the product was processed |GMT | | ||
| + | | ms8 | First double ratio | | [[devel:brewerpythonmodule#o3_so2|Brewer Python Module (o3_so2)]] | | ||
| + | | ms9 | Second double ratio | | [[devel:brewerpythonmodule#o3_so2|Brewer Python Module (o3_so2)]] | | ||
| + | | f1 | Corrected Operational-Wavelength counts per second for slit 1 (includes only instrumental corrections, does not include the Rayleigh correction) | | Brewer Operator Manual (Appendix G) | | ||
| + | | f2 | Corrected Operational-Wavelength counts per second for slit 2 (includes only instrumental corrections, does not include the Rayleigh correction) | | Brewer Operator Manual (Appendix G) | | ||
| + | | f3 | Corrected Operational-Wavelength counts per second for slit 3 (includes only instrumental corrections, does not include the Rayleigh correction) | | Brewer Operator Manual (Appendix G) | | ||
| + | | f4 | Corrected Operational-Wavelength counts per second for slit 4 (includes only instrumental corrections, does not include the Rayleigh correction) | | Brewer Operator Manual (Appendix G) | | ||
| + | | f5 | Corrected Operational-Wavelength counts per second for slit 5 (includes only instrumental corrections, does not include the Rayleigh correction) | | Brewer Operator Manual (Appendix G) | | ||
| + | [[http://www.iso.org/iso/es/home/standards/iso8601.htm|ISO 8601]]| | ||
| + | |||
| + | ===== Level 1.5 ===== | ||
| + | ==== Ozone Level 1.5 ==== | ||
| + | ^ ozone_product_1_5 Table ^^^^ | ||
| + | ^ Field ^ Description ^ Unit ^ Reference ^ | ||
| + | | brewerid | Brewer identification number | | db.brewer_t | | ||
| + | | gmt | UT time of the measure in ISO 8601 format | GMT |[[http://www.iso.org/iso/es/home/standards/iso8601.htm|ISO 8601]]| | ||
| + | | configid | Configuration identification Numer | | db.configs_t | | ||
| + | | n_sum | Index of the daily summary | | | | ||
| + | | date_index | Continuous date index (1.0 = 0001-01-01T00:00:00Z) based in python date.toordinal | days | db.b_ds_t.date.toordinal + db.b_ds_t.mmmm_gmt / SECONDS_IN_A_DAY | | ||
| + | | sza | Solar zenith angle using time function | Degrees | [[devel:brewerpythonmodule#solar_zenith_angle| Brewer Python Module (Solar Zenith Angle)]] | | ||
| + | | airmass | Calculated airmass using time function | | [[devel:brewerpythonmodule#brewer_airmass| Brewer Python Module (Brewer Airmass)]] | | ||
| + | | temperature | Instrument temperature | Degrees | db.b_ds_summary_t.temp | | ||
| + | | filt | Applied neutral density filter | | db.b_ds_t.nd_filter_position / 64 | | ||
| + | | o3 | Calculated Ozone value with Standard algorithm + attenuation filter correction + config corrections [[codes:ozoneproduct#level_15_realtime_observation|Ozone Level 1.5]] | Dobson Units | [[devel:brewerpythonmodule#o3_so2_sl|Brewer Python Module (o3_so2_sl)]] | | ||
| + | | std_o3 | Standard deviation of the group of measures | Dobson Units | Brewer Operator Manual (Section 9.2.6) | | ||
| + | | so2 | Calculated so2 value with Standard algorithm + attenuation filter correction [[codes:ozoneproduct#level_15_realtime_observation|Ozone Level 1.5]] | Dobson Units | [[devel:brewerpythonmodule#o3_so2_sl|Brewer Python Module (o3_so2_sl)]] | | ||
| + | | std_so2 | Standard deviation of the group of measures | Dobson Units | Brewer Operator Manual (Section 9.2.6) | | ||
| + | | latitude | Latitude of the Brewer Location | Degrees | db.b_t, db.configs_t | | ||
| + | | longitude | Longitude of the Brewer Location | Degrees | db.b_t, db.configs_t | | ||
| + | | press | Medium Pressure of the Brewer Location | Milibars | db.b_t, db.configs_t | | ||
| + | | o3_0 | Calculated Ozone value with Standard algorithm + attenuation filter correction [[codes:ozoneproduct#level_1|Ozone Level 1]]| Dobson Units | [[devel:brewerpythonmodule#o3_so2|Brewer Python Module (o3_so2)]] | | ||
| + | | so2_0 | Calculated so2 value with Standard algorithm + attenuation filter correction [[codes:ozoneproduct#level_1|Ozone Level 1]]| Dobson Units | [[devel:brewerpythonmodule#o3_so2|Brewer Python Module (o3_so2)]] | | ||
| + | | r6 | Standard Lamp Double Ratio 2 | | [[devel:brewerpythonmodule#sl_tma|Brewer Python Module (Triangular Moving Average)]] | | ||
| + | | r6_ref | Ozone value for Standard Lamp of Reference (Double Ratio 2) | | db.configs_t.r6_ref | | ||
| + | | r5 | Standard Lamp Double Ratio 1 | | [[devel:brewerpythonmodule#sl_tma|Brewer Python Module (Triangular Moving Average)]] | | ||
| + | | r5_ref | Ozone value for Standard Lamp of Reference (Double Ratio 1) | | db.configs_t.r5_ref | | ||
| + | | filter_flag | APPLIED FLAGS: HG Filter, Max Airmass, O3 std (1 means True) | | [[codes:ozoneproduct#level_15_realtime_observation|Level 1.5 Realtime Observation]] | | ||
| + | | correction_flag | APPLIED CORRECTIONS: Straylight, ETC Correction, Standard Lamp correction(1 means True) | | [[codes:ozoneproduct#level_15_realtime_observation|Level 1.5 Realtime Observation]] | | ||
| + | | configdate | UT Date of the used configuration in ISO 8601 format | GMT | db.b_t, db.configs_t | | ||
| + | | configtype | Type of the used configuration: B header(1), ICF (2), Config (3) | | db.b_t, db.icf_t db.configs_t | | ||
| + | | process_date | Date and time when the product was processed |GMT |[[http://www.iso.org/iso/es/home/standards/iso8601.htm|ISO 8601]]| | ||
| + | |||
| + | ===== Level 2.0 ===== | ||
| + | ==== Ozone Level 2.0 ==== | ||
| + | ^ ozone_product_2_0 Table ^^^^ | ||
| ^ Field ^ Description ^ Unit ^ Reference ^ | ^ Field ^ Description ^ Unit ^ Reference ^ | ||
| | brewerid | Brewer identification number | | db.brewer_t | | | brewerid | Brewer identification number | | db.brewer_t | | ||
| + | | configid | Configuration identification Numer | | db.configs_t | | ||
| + | | n_sum | Index of the daily summary | | | | ||
| | gmt | UT time of the measure in ISO 8601 format | GMT |[[http://www.iso.org/iso/es/home/standards/iso8601.htm|ISO 8601]]| | | gmt | UT time of the measure in ISO 8601 format | GMT |[[http://www.iso.org/iso/es/home/standards/iso8601.htm|ISO 8601]]| | ||
| | date_index | Continuous date index (1.0 = 0001-01-01T00:00:00Z) based in python date.toordinal | days | db.b_ds_t.date.toordinal + db.b_ds_t.mmmm_gmt / SECONDS_IN_A_DAY | | | date_index | Continuous date index (1.0 = 0001-01-01T00:00:00Z) based in python date.toordinal | days | db.b_ds_t.date.toordinal + db.b_ds_t.mmmm_gmt / SECONDS_IN_A_DAY | | ||
| Line 11: | Line 89: | ||
| | temperature | Instrument temperature | Degrees | db.b_ds_summary_t.temp | | | temperature | Instrument temperature | Degrees | db.b_ds_summary_t.temp | | ||
| | filt | Applied neutral density filter | | db.b_ds_t.nd_filter_position / 64 | | | filt | Applied neutral density filter | | db.b_ds_t.nd_filter_position / 64 | | ||
| - | | o3 | Calculated Ozone value with Standard algorithm + attenuation filter correction | Dobson Units | Brewer Operator Manual (Appendix G) | | + | | o3_0 | Calculated Ozone value with Standard algorithm + attenuation filter correction [[codes:ozoneproduct#level_1|Ozone Level 1]]| Dobson Units | [[devel:brewerpythonmodule#o3_so2|Brewer Python Module (o3_so2)]] | |
| + | | so2_0 | Calculated so2 value with Standard algorithm + attenuation filter correction [[codes:ozoneproduct#level_1|Ozone Level 1]]| Dobson Units | [[devel:brewerpythonmodule#o3_so2|Brewer Python Module (o3_so2)]] | | ||
| + | | o3 | Calculated Ozone value with Standard algorithm + attenuation filter correction + config corrections [[codes:ozoneproduct#level_20|Ozone Level 2.0]] | Dobson Units | [[devel:brewerpythonmodule#o3_so2_sl|Brewer Python Module (o3_so2_sl)]] | | ||
| | std_o3 | Standard deviation of the group of measures | Dobson Units | Brewer Operator Manual (Section 9.2.6) | | | std_o3 | Standard deviation of the group of measures | Dobson Units | Brewer Operator Manual (Section 9.2.6) | | ||
| - | | ms9 | Second double ratio | | Brewer Operator Manual (Appendix G) | | + | | so2 | Calculated so2 value with Standard algorithm + attenuation filter correction [[codes:ozoneproduct#level_15_realtime_observation|Ozone Level 1.5]] | Dobson Units | [[devel:brewerpythonmodule#o3_so2_sl|Brewer Python Module (o3_so2_sl)]] | |
| - | | so2 | Calculated so2 value with Standard algorithm + attenuation filter correction | Dobson Units | Brewer Operator Manual (Appendix G) | | + | |
| | std_so2 | Standard deviation of the group of measures | Dobson Units | Brewer Operator Manual (Section 9.2.6) | | | std_so2 | Standard deviation of the group of measures | Dobson Units | Brewer Operator Manual (Section 9.2.6) | | ||
| - | | ms8 | First double ratio | | Brewer Operator Manual (Appendix G) | | + | | r6 | Standard Lamp Double Ratio 2 | | [[devel:brewerpythonmodule#sl_tma|Brewer Python Module (Triangular Moving Average)]] | |
| - | | f1 | Corrected Operational-Wavelength counts per second for slit 1 | | Brewer Operator Manual (Appendix G) | | + | | r6_ref | Ozone value for Standard Lamp of Reference (Double Ratio 2) | | db.configs_t.r6_ref | |
| - | | f2 | Corrected Operational-Wavelength counts per second for slit 2 | | Brewer Operator Manual (Appendix G) | | + | | r5 | Standard Lamp Double Ratio 1 | | [[devel:brewerpythonmodule#sl_tma|Brewer Python Module (Triangular Moving Average)]] | |
| - | | f3 | Corrected Operational-Wavelength counts per second for slit 3 | | Brewer Operator Manual (Appendix G) | | + | | r5_ref | Ozone value for Standard Lamp of Reference (Double Ratio 1) | | db.configs_t.r5_ref | |
| - | | f4 | Corrected Operational-Wavelength counts per second for slit 4 | | Brewer Operator Manual (Appendix G) | | + | |
| - | | f5 | Corrected Operational-Wavelength counts per second for slit 5 | | Brewer Operator Manual (Appendix G) | | + | |
| | latitude | Latitude of the Brewer Location | Degrees | db.b_t, db.configs_t | | | latitude | Latitude of the Brewer Location | Degrees | db.b_t, db.configs_t | | ||
| | longitude | Longitude of the Brewer Location | Degrees | db.b_t, db.configs_t | | | longitude | Longitude of the Brewer Location | Degrees | db.b_t, db.configs_t | | ||
| Line 27: | Line 104: | ||
| | configdate | UT Date of the used configuration in ISO 8601 format | GMT | db.b_t, db.configs_t | | | configdate | UT Date of the used configuration in ISO 8601 format | GMT | db.b_t, db.configs_t | | ||
| | configtype | Type of the used configuration: B header(1), ICF (2), Config (3) | | db.b_t, db.icf_t db.configs_t | | | configtype | Type of the used configuration: B header(1), ICF (2), Config (3) | | db.b_t, db.icf_t db.configs_t | | ||
| + | | filter_flag | APPLIED FLAGS: HG Filter, Max Airmass, O3 std (1 means True) | | [[codes:ozoneproduct#level_15_realtime_observation|Level 1.5 Realtime Observation]] | | ||
| + | | correction_flag | APPLIED CORRECTIONS: Straylight, ETC Correction, Standard Lamp correction(1 means True) | | [[codes:ozoneproduct#level_15_realtime_observation|Level 1.5 Realtime Observation]] | | ||
| + | | process_date | Date and time when the product was processed |GMT |[[http://www.iso.org/iso/es/home/standards/iso8601.htm|ISO 8601]]| | ||
codes/productsdescription.1444902137.txt.gz · Last modified: 2015/10/15 09:42 by bhcruz
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 3.0 Unported
