1.- Review of pending requests: =============================== 1.1.- Request #10 (D. Given): ----------------------------- --> Add new column "nread" to NETMAG table. ------------------------------------------------------------------------ ==> Request has been approved but the implementation is on hold until: 1.- NC is done migrating to the new CISN software. 2.- SC is done migrating to the leap seconds compliant code. ------------------------------------------------------------------------ 1.2.- Request #19 (D. Given): ----------------------------- --> Add "timequality" to WAVEFORM. ------------------------------------------------------------------------ ==> D. Neuhauser sent an email to Egill about his concerns. ------------------------------------------------------------------------ 1.3.- Request #119 (E. Yu): --------------------------- --> Remove amp02 constraint (amplitude > 0) from amp table. ------------------------------------------------------------------------ ==> SCWG wants to have Standards group opinion. D. Neuhauser will schedule a Standards call. ------------------------------------------------------------------------ 2.- New requests: ================= 2.1.- Request #122 (P. Lombard - NEW): -------------------------------------- ----------------------------------------------------------------- --> AppChannels primary key constraint is missing ondate. Primary key constraint of (progid, net, sta, seedchan, location) is too restrictive: this table could have many rows for a given (progid, net, sta, seedchan, location) spanning different times periods. By design, these time periods should not overlap, but that cannot be expressed as an SQL constraint. Following the examples of channel_data and simple_response, ondate should be added to this primary key constraint. ----------------------------------------------------------------- ------------------------------------------------------------------------ ==> Approved. New Primary key will be: (progid, net, sta, seedchan, location, ondate). ------------------------------------------------------------------------ 2.2.- Request #95 (P. Lombard - NEW): ------------------------------------- ----------------------------------------------------------------- --> Add field to IR to give the clipping level of the channel. The clipping level of channels is currently needed for coda duration measurements in earthworm and jiggle. In NCSS we are currently deriving this from the datalogger type from HT schema, and a flat-file table giving digitizer bit range. Caltech (AWW, Friberg) are "guessing" based on channel names. ----------------------------------------------------------------- ------------------------------------------------------------------------ ==> Closed. There is now a field in the ChannelMap_AmpParms table to accommodate this value. ------------------------------------------------------------------------ 2.3.- Request #53 (D. Given - NEW): ----------------------------------- ----------------------------------------------------------------- --> Add integer attribute for each channel to hold COSMOS "Table 6" value. This is required to distinguish freefield from structural sensors. This is needed by ShakeMap and the Gro. Mo. packet. ----------------------------------------------------------------- ------------------------------------------------------------------------ ==> Discussed. A. Walter is currently involved in NSMP project. We should wait until he has more information concerning this matter. ------------------------------------------------------------------------