Difference between revisions of "Database Management - David Court"
| Line 3: | Line 3: | ||
== Current Tasks == | == Current Tasks == | ||
| − | Sept 2011: Re-organization of the BBOP database with the purpose of increasing performance of (in-situ) matchups | + | Sept 2011: Re-organization of the BBOP database with the purpose of increasing performance of (in-situ) matchups<br/> |
| − | - imported all possible pigment measurements from SeaBASS | + | - imported all possible pigment measurements from SeaBASS<br/> |
| − | - organized all radiometric data (MER, SPMR, & MicrPro) | + | - organized all radiometric data (MER, SPMR, & MicrPro)<br/> |
| − | - organized all absorption data (ag, ad, ap & aph) | + | - organized all absorption data (ag, ad, ap & aph)<br/> |
| − | Reasons for performing this task: | + | Reasons for performing this task:<br/> |
| − | - The chlorophyll values in the original database were incorrect. The chlorophyll values were taken from the IOP bottle-files that had been submitted to SeaBASS. These were labeled as "chl_a", which is defined by SeaBASS as an HPLC product. However, these are Flourometric measurements. At some point, a script needs to be written to re-format these files and a they must then be re-submitted to SeaBASS. | + | - The chlorophyll values in the original database were incorrect. The chlorophyll values were taken from the IOP bottle-files that had been submitted to SeaBASS. These were labeled as "chl_a", which is defined by SeaBASS as an HPLC product. However, these are Flourometric measurements. At some point, a script needs to be written to re-format these files and a they must then be re-submitted to SeaBASS.<br/> |
| − | - Many of the sample times are incorrect. This creates inaccuracies when trying to match-up the different measurements. Most of the problems are a result of submitting the data in local (Bermuda) time rather than GMT - as required by SeaBASS. Other issues exist as a result of the technician's computer clock being incorrectly set - sometimes by an order of years. Again, these data will ultimately have to edited and re-submitted to SeaBASS. | + | - Many of the sample times are incorrect. This creates inaccuracies when trying to match-up the different measurements. Most of the problems are a result of submitting the data in local (Bermuda) time rather than GMT - as required by SeaBASS. Other issues exist as a result of the technician's computer clock being incorrectly set - sometimes by an order of years. Again, these data will ultimately have to edited and re-submitted to SeaBASS.<br/> |
Revision as of 16:18, 21 September 2011
Summary of My Position
Current Tasks
Sept 2011: Re-organization of the BBOP database with the purpose of increasing performance of (in-situ) matchups
- imported all possible pigment measurements from SeaBASS
- organized all radiometric data (MER, SPMR, & MicrPro)
- organized all absorption data (ag, ad, ap & aph)
Reasons for performing this task:
- The chlorophyll values in the original database were incorrect. The chlorophyll values were taken from the IOP bottle-files that had been submitted to SeaBASS. These were labeled as "chl_a", which is defined by SeaBASS as an HPLC product. However, these are Flourometric measurements. At some point, a script needs to be written to re-format these files and a they must then be re-submitted to SeaBASS.
- Many of the sample times are incorrect. This creates inaccuracies when trying to match-up the different measurements. Most of the problems are a result of submitting the data in local (Bermuda) time rather than GMT - as required by SeaBASS. Other issues exist as a result of the technician's computer clock being incorrectly set - sometimes by an order of years. Again, these data will ultimately have to edited and re-submitted to SeaBASS.
