SPEEDS GoTo Meeting Notes

From NGDCWiki

Jump to: navigation, search

Contents

May 19, 2009

Agenda

A couple of things to discuss:

  1. NOAA-19
  2. Connecting instruments, formats, etc. to a product

April 21, 2009

Agenda

A couple of things to discuss:

  1. Online Resources Transferred from Metadata records.
  2. The spreadsheet

April 14, 2009

Agenda

A couple of things to discuss:

  1. Choosing one POP for datafiles currently associated with more than one.
  2. How are primary output datafiles(products) associated with input datafiles?

April 7, 2009

Agenda

A couple of items to discuss:

  1. Logging in first... The SPEEDS Database Editor requires that you login to the Interface Database System using the user name and password that we gave you. You only need to login once per session. Once you log in, you will go to an Interface Database Utilities page. Press the back button once and you will be back where you started!
  2. SPEEDS URLs and FGDC Metadata (see POP Searches)
  3. POP emails - Should they exist?

March 31, 2009

Agenda

Short-term tasks (Current Interface)

  1. Delete or decommission products (add status = deleted, status history) - Delete Action Added, Tables created
  2. Make / break connections, delete all connections for a particular satellite / instrument - Working on it
  3. Add ID's to CSV, HTML output - Done
  4. Add Glossary Tab - Done
  5. Comma delimited format list for each product in the CPL. (Migrate format table to ISO) - Done
  6. Create a brand new product, satellite, instrument, channel…
  7. cookbook for new product…
  8. Talk to security guys about transfer to OSD
  9. Integration of Tom/Brian spreadsheet
  10. RSS Feeds

POP Searches

This section moved to POP Searches

March 10, 2009

Agenda

  • Launch dates and "Deactivated" added to Satellites
  • "All" satellite records updated
  • Our proposal for a unified SATPROD Interface
  • Satellite identifiers in SPEEDS, Level1B, and GCMD
  • Instrument identifiers in SPEEDS, Level1B, and GCMD

Question

  • How would we handle something like GOES-10 which provides data to South America countries and we stopped using data from this satellite w/i NOAA? There might need to be a 3rd category. Something like partially operational (see discuss in next para).
  • You can have the same discussion about sensors to. During the life span of a satellite a sensor can be operational, partially operational and in-operative. The partially operational gets a little tricky because we can decommission a product and still send some out. For example, recent examples would be NOAA-16 AVHRR products about a year or two ago. Most applications shut down w/a N16 anomaly but some persisted (e.g., earth radiation products were unaffected).

Links to Development Views

Level 1B Notices - Satellite Cleanup

Histogram View
We continued work on the Satellite cleanup in the Level 1B Notices with input from Tom on Satellites and times. The following steps were taken:

  1. added NOAA-11, NOAA-12, NOAA-14, and MetOp with Launch Dates, Decommissioned Dates and Status = Deactivated where appropriate.
  2. commands below were used to update the SATS_INVOLVED field for 28 rows (6 rows remain with "All" in the Satellites).

Commands: The form of these commands is
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'New Value' where ID = ID;

update level1bnotice2 set SATS_INVOLVED = 'NOAA-11, NOAA-12, NOAA-14, NOAA-15, NOAA-16, NOAA-17' where ID=375;
update level1bnotice2 set SATS_INVOLVED = 'NOAA-11, NOAA-12, NOAA-14, NOAA-15, NOAA-16, NOAA-17' where ID=147;
update level1bnotice2 set SATS_INVOLVED = 'NOAA-11, NOAA-12, NOAA-14, NOAA-15, NOAA-16, NOAA-17' where ID=196;
update level1bnotice2 set SATS_INVOLVED = 'NOAA-11, NOAA-12, NOAA-14, NOAA-15, NOAA-16, NOAA-17' where ID=199;
update level1bnotice2 set SATS_INVOLVED = 'NOAA-11, NOAA-12, NOAA-14, NOAA-15, NOAA-16, NOAA-17' where ID=508;
update level1bnotice2 set SATS_INVOLVED = 'NOAA-11, NOAA-12, NOAA-14, NOAA-15, NOAA-16, NOAA-17, NOAA-18' where ID=158;
update level1bnotice2 set SATS_INVOLVED = 'NOAA-12, NOAA-14, NOAA-15, NOAA-16, NOAA-17' where ID=8;
update level1bnotice2 set SATS_INVOLVED = 'NOAA-12, NOAA-14, NOAA-15, NOAA-16, NOAA-17 and NOAA-18' where ID=150;
update level1bnotice2 set SATS_INVOLVED = 'NOAA-12, NOAA-14, NOAA-15, NOAA-16, NOAA-17, NOAA-18' where ID=97;
update level1bnotice2 set SATS_INVOLVED = 'NOAA-12, NOAA-14, NOAA-15, NOAA-16, NOAA-17, NOAA-18' where ID=104;
update level1bnotice2 set SATS_INVOLVED = 'NOAA-12, NOAA-14, NOAA-15, NOAA-16, NOAA-17, NOAA-18' where ID=106;
update level1bnotice2 set SATS_INVOLVED = 'NOAA-12, NOAA-14, NOAA-15, NOAA-16, NOAA-17, NOAA-18' where ID=153;
update level1bnotice2 set SATS_INVOLVED = 'NOAA-12, NOAA-14, NOAA-15, NOAA-16, NOAA-17, NOAA-18' where ID=243;
update level1bnotice2 set SATS_INVOLVED = 'NOAA-12, NOAA-14, NOAA-15, NOAA-16, NOAA-17, NOAA-18' where ID=245;
update level1bnotice2 set SATS_INVOLVED = 'NOAA-12, NOAA-14, NOAA-15, NOAA-16, NOAA-17, NOAA-18' where ID=255;
update level1bnotice2 set SATS_INVOLVED = 'NOAA-12, NOAA-14, NOAA-15, NOAA-16, NOAA-17, NOAA-18' where ID=289;
update level1bnotice2 set SATS_INVOLVED = 'NOAA-12, NOAA-14, NOAA-15, NOAA-16, NOAA-17, NOAA-18' where ID=290;
update level1bnotice2 set SATS_INVOLVED = 'NOAA-12, NOAA-14, NOAA-15, NOAA-16, NOAA-17, NOAA-18' where ID=292;
update level1bnotice2 set SATS_INVOLVED = 'NOAA-12, NOAA-14, NOAA-15, NOAA-16, NOAA-17, NOAA-18' where ID=354;
update level1bnotice2 set SATS_INVOLVED = 'NOAA-12, NOAA-14, NOAA-15, NOAA-16, NOAA-17, NOAA-18' where ID=415;
update level1bnotice2 set SATS_INVOLVED = 'NOAA-12, NOAA-14, NOAA-15, NOAA-16, NOAA-17, NOAA-18' where ID=425;
update level1bnotice2 set SATS_INVOLVED = 'NOAA-12, NOAA-14, NOAA-15, NOAA-16, NOAA-17, NOAA-18' where ID=442;
update level1bnotice2 set SATS_INVOLVED = 'NOAA-12, NOAA-14, NOAA-15, NOAA-16, NOAA-17, NOAA-18, MetOp-A' where ID=222;
update level1bnotice2 set SATS_INVOLVED = 'NOAA-15, NOAA-16, NOAA-17' where ID=134;
update level1bnotice2 set SATS_INVOLVED = 'NOAA-15, NOAA-16, NOAA-17' where ID=135;
update level1bnotice2 set SATS_INVOLVED = 'NOAA-15, NOAA-16, NOAA-17' where ID=146;

Questions
Is FY-2C = FENGYUN 2C?

Level 1B Notices - Instrument Cleanup

The Instruments field in the Level 1B Notices also need to be cleaned up in the same way as the Satellites (see Histogram). The first step is to clean up the lists of satellite names. These are the commands we used for the initial pass:

update SATPROD.LEVEL1BNOTICE2 set INST_INVOLVED = 'All Instruments' where INST_INVOLVED in ('ALL', 'ALL instruments', 'ALL.', 'Al Instruments', 'All', 'All Instruments.', 'All active Instruments', 'All instruments', 'All instruments.') ;
update SATPROD.LEVEL1BNOTICE2 set INST_INVOLVED = 'AVHRR' where INST_INVOLVED in ('AVHRR Instrument', 'AVHRR Instrument.', 'AVHRR instrument', 'AVHRR.', 'AVHRR...', 'AVHRR....') ;
update SATPROD.LEVEL1BNOTICE2 set INST_INVOLVED = 'HIRS' where INST_INVOLVED = 'HIRS instrument';
update SATPROD.LEVEL1BNOTICE2 set INST_INVOLVED = 'MHS' where INST_INVOLVED in (', MHS', 'MHS Instrument', 'MHS instrument') ;
update SATPROD.LEVEL1BNOTICE2 set INST_INVOLVED = 'AMSU-A1, AMSU-A2' where INST_INVOLVED in ('AMSU-A1 & A2', 'AMSU-A1 and A2') ;
update SATPROD.LEVEL1BNOTICE2 set INST_INVOLVED = 'AMSU-A1' where INST_INVOLVED = 'AMSU-A-1.';
update SATPROD.LEVEL1BNOTICE2 set INST_INVOLVED = 'AMSU-B' where INST_INVOLVED in ('AMSU-B Instrument', 'AMSU-B.') ;
update SATPROD.LEVEL1BNOTICE2 set INST_INVOLVED = 'HIRS, AVHRR, AMSU-A, AMSU-B, MHS' where INST_INVOLVED in ('HIRS, AVHRR, AMSU-A, AMSU-B, and MHS', 'HIRS, AMSU-B, AMSU-A, MHS, AVHRR') ;
update SATPROD.LEVEL1BNOTICE2 set INST_INVOLVED = 'AVHRR, SEM' where INST_INVOLVED in ('AVHRR, and SEM', 'AVHRR,SEM') ;
update SATPROD.LEVEL1BNOTICE2 set INST_INVOLVED = 'HIRS, AVHRR, AMSU-A, AMSU-B' where INST_INVOLVED = 'HIRS,AMSU-A,AMSU-B, AVHRR';
update SATPROD.LEVEL1BNOTICE2 set INST_INVOLVED = 'HIRS, AVHRR, AMSU-A, AMSU-B, MHS' where INST_INVOLVED = 'AMSU-A, AMSU-B, AVHRR, HIRS, and MHS';
update SATPROD.LEVEL1BNOTICE2 set INST_INVOLVED = 'AVHRR, HIRS' where INST_INVOLVED = 'AVHRR and HIRS';
update SATPROD.LEVEL1BNOTICE2 set INST_INVOLVED = 'HIRS, AVHRR, AMSU-A, AMSU-B, MHS' where INST_INVOLVED = 'HIRS, MHS, AVHRR, AMSU-A, AMSU-B,....';

Questions: What is APT?
Some of these entries include Satellites. Those need to be checked against the satellite field.

March 3, 2009

Agenda

  • Our proposal for a unified SATPROD Interface
  • Need to harmonize satellite identifiers in SPEEDS, Level1B, and GCMD

Links to Development Views

Level 1B Notices - Satellite Cleanup

Histogram View
What are All NOAA POES Satellites?
Is that the same as All NOAA Polar?
Is that the same as All POES Satellites?
What do we want to do about pre-launch names?

Commands: The form of these commands is
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'New Value' where SATS_INVOLVED = 'Old Values'; or
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'New Value' where SATS_INVOLVED in ('Old Value', 'Old Value');

update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'All Satellites' where SATS_INVOLVED = 'All satellites';
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'All Satellites' where SATS_INVOLVED = 'ALL';
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'All POES Satellites' where SATS_INVOLVED in ('All POES', 'All POES satellites') ;
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'All NOAA Satellites' where SATS_INVOLVED in ('All NOAA', 'All NOAA satellites', NULL) ;
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-14, NOAA-12' where SATS_INVOLVED in ('NOAA-12 and 14', 'NOAA-14 and 12') ;
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-12, NOAA-14' where SATS_INVOLVED = 'NOAA-14, NOAA-12';
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-11, NOAA-12, NOAA-14' where SATS_INVOLVED = 'NOAA-11, 12, and 14';
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-12, NOAA-15' where SATS_INVOLVED = 'NOAA-12 and 15';
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-14, NOAA-16' where SATS_INVOLVED = 'NOAA-14 and 16';
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-15, NOAA-16, NOAA-17, NOAA-N' where SATS_INVOLVED in ('. NOAA-15, NOAA-16, NOAA-17, and NOAA-N', NULL) ;
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'GOES-10, GOES-11' where SATS_INVOLVED = 'GOES-10 and 11';
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-12, NOAA-14' where SATS_INVOLVED = 'NOAA-12, and 14';
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-12, NOAA-14, NOAA-15, NOAA-16, NOAA-17, NOAA-18' where SATS_INVOLVED = 'NOAA-12,14,15,16,17,and 18';
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-14, NOAA-15, NOAA-16, NOAA-17' where SATS_INVOLVED in ('NOAA-14, 15, 16, 17', 'NOAA-14, 15, 16, and 17');
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-16, NOAA-17, NOAA-18' where SATS_INVOLVED in ('NOAA -16,17 and 18', 'NOAA-16, 17, &18', 'NOAA-16, 17, and 18', 'NOAA-16,17 and 18', 'NOAA-16,17, and 18', 'NOAA-16,17,1nd 18', 'NOAA-16,17,and 18', 'NOAA-16,17,and18', 'NOAA-16. 17, and 18', 'NOAA-16.17.and 18') ;
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-14, NOAA-16, NOAA-17' where SATS_INVOLVED in ('NOAA-14, 16, 17', 'NOAA-14, NOAA-16, and NOAA-17') ;
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-15, NOAA-16, NOAA-17' where SATS_INVOLVED in ('NOAA-15, -16, & -17', 'NOAA-15, 16, 17', 'NOAA-15,16, and 17', 'NOAA-15,16,and 17') ;
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-15, NOAA-16, NOAA-17' where SATS_INVOLVED = 'NOAA-15, NOAA-16, and NOAA-17';
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-15, NOAA-16' where SATS_INVOLVED in ('NOAA-15 and 16') ;
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-15, NOAA-16, NOAA-17, NOAA-18' where SATS_INVOLVED in ('NOAA-15, 16, 17, 18', 'NOAA-15, 16, 17, and 18', 'NOAA-15, 16- 17, 18', 'NOAA-15,16,17, and 18', 'NOAA-15,16,17,and 18') ;
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-16, NOAA-17' where SATS_INVOLVED in ('NOAA-16 and 17', 'NOAA-16 and NOAA-17', 'NOAA-16, -17', 'NOAA-16, NOAA-17', 'NOAA-16, and 17', 'NOAA-16, and NOAA-17', NULL) ;
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-16' where SATS_INVOLVED = 'NOAA-16,';
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-15, NOAA-16, NOAA-17' where SATS_INVOLVED = 'NOAA-15, 16, and 17';
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-15, NOAA-16' where SATS_INVOLVED = 'NOAA-15, and NOAA-16';
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-16, NOAA-18' where SATS_INVOLVED in ('NOAA-16 and 18') ;
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-16, NOAA-17, NOAA-18' where SATS_INVOLVED = 'NOAA-18, 17, 16';
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-14, NOAA-17' where SATS_INVOLVED in ('NOAA-17 and 14', NULL) ;
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-17, NOAA-18' where SATS_INVOLVED in ('NOAA-17 and 18', 'NOAA-17, and 18') ;
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-15, NOAA-16, NOAA-17, NOAA-N' where SATS_INVOLVED = 'NOAA-15, 16, 17, and NOAA-N';
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-16, NOAA-17, NOAA-18, MetOp-2/A' where SATS_INVOLVED in ('NOAA-16, 17, 18, & MetOp-2/A', 'NOAA-16, 17, 18, & MetOp-2/A') ;
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-K, NOAA-L, NOAA-M' where SATS_INVOLVED = 'NOAA-K, L, and M';
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-K, NOAA-L, NOAA-M' where SATS_INVOLVED = 'NOAA-K, NOAA-L, and NOAA-M';
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-K, NOAA-L, NOAA-M' where SATS_INVOLVED = 'NOAA-K,L,M';
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-15, NOAA-16, NOAA-17, NOAA-18' where SATS_INVOLVED = '*NOAA-15 through 18';
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-15, NOAA-16, NOAA-17, NOAA-18' where SATS_INVOLVED = '*NOAA-15 through 18';
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'MetOp-2/A' where SATS_INVOLVED = 'Metop-2/A';
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-15, NOAA-16, NOAA-17, NOAA-18, MetOp-2/A' where SATS_INVOLVED = 'NOAA-15, 16, 17, 18 MetOp-2/A';
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-15, NOAA-16, NOAA-17, NOAA-18' where SATS_INVOLVED in ('NOAA-15 - 18', NULL) ;


select id, SATS_INVOLVED
from SATPROD.LEVEL1BNOTICE2
where SATS_INVOLVED like 'NOAA-16, 17, 18, % MetOp-2/A'
;
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-16, NOAA-17, NOAA-18, MetOp-2/A' where id = 151;

select id, SATS_INVOLVED
from SATPROD.LEVEL1BNOTICE2
where SATS_INVOLVED like 'NOAA-15, 16,%'
;
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'NOAA-15, NOAA-16, NOAA-17, NOAA-18, MetOp-2/A' where id = 154;

select id, SATS_INVOLVED
from SATPROD.LEVEL1BNOTICE2
where SATS_INVOLVED like 'F14%'
;
update SATPROD.LEVEL1BNOTICE2 set SATS_INVOLVED = 'F14, F15' where id = 318;

February 17, 2009

Consolidated Product List

  • Add Measurement Category to the list
  • Add option for export via HTML table

Hierarchy Trees

  • Product Detail pop-up window displays 'no data found' for some products
  • Add instrument to channel hierarchy

Internet Explorer

  • Pages don't display well - columns are all pushed up together

Product Details

  • Platforms are out of date
  • Don't necessarily need comments or graphics
Personal tools