* Table C_ChannelData (current version): ---------------------------------------- ================================================================ net VARCHAR2(8) -- Network code sta VARCHAR2(6) -- Station code seedchan VARCHAR2(3) -- SEED Channel code location VARCHAR2(2) -- SEED Location code ondate DATE -- Start date offdate DATE -- End date -- COSMOS mapping fields netId NUMBER(5) -- FK C_Net (Cosmos Table 4) lgrName VARCHAR2(48) -- FK from C_LoggerData where C_LgrTyp lgrId PK is mapped to the lgrName (Cosmos Table 9) snsName VARCHAR2(48) -- FK from C_SensorData where C_SnsTyp snsId PK is mapped to the snsName (Cosmos Table 10) siteId NUMBER(5) -- FK C_Site (Cosmos Table 6) orntId NUMBER(5) -- FK C_Ornt (Cosmos Table 11) timeId NUMBER(5) -- FK C_TimeClk (Cosmos Table 8) Currently assigning value of 5 (GPS Signal) datumId NUMBER(5) -- FK C_Datum (Cosmos Table 5) Currently assigning value of 1 (WGS84) staVs30 NUMBER(5,2) -- Vs30 (km/s) Not currently used staGeoId NUMBER(15) -- Site geology code at station if any Not currently used chan_number NUMBER(3) -- Channel number Not currently used description VARCHAR2(60) -- Channel description relative to station -- lddate DATE -- Load date ================================================================ * We propose to add the following fields to the C_ChannelData table: 1.- Geologic Site Class Definitions (CBC 2010): ----------------------------------------------- A Hard rock (Vs30 > 5000 ft/s, or Vs30 > 1525 m/s) B Rock (2500 ft/s < Vs30 <= 5000 ft/s, or 760 m/s < Vs30 <= 1525 m/s) C Very dense soil and soft rock (1200 ft/s < Vs30 <= 2500 ft/s, or 365 m/s < Vs30 <= 1525m/s) D Stiff soil profile (600 ft/s < Vs30 <= 1200 ft/s, or 182 m/s < Vs30 <= 365 m/s) E Soft soil profile (Vs30 <= 600 ft/s, or Vs30 <= 182 m/s ) F Liquefiable soils, peats and/or highly organic clays, etc. U Unknown Note: If Vs30 is known for a site it can optionally be appended to the Site Class letter field, as a number in brackets [ ]. ==> The current field 'staGeoId' can be used to store this value. ==> VARCHAR(1). 2.- Physical Surroundings Conditions at Site: --------------------------------------------- a No nearby structures or topographic changes, sensors firmly anchored. b Small structure (<1000 ft2 or 93 m2, single-story) exists within 1 structure dimension of the site. c Larger structure (>1000 ft2 or 93 m2, and/or >= 2-story) exists within 1 structure dimension (largest) from the site. d Significant topographic change (>10 ft or 3m) within 2x of the amplitude of the topographic change from the site (e.g. ridge top, narrow canyon bottom, cliff or bluff). e Other noteworthy condition. u Physical surroundings at site unknown. ==> A new corresponding field needs to be added (VARCHAR2(1)). ==> NUMBER(1). Reuse the same association? Talk to Ellen. 3.- Recommendation by Network Seismologist for Use of Data in ShakeMap: ----------------------------------------------------------------------- -1 Data from site not recommended for use in ShakeMap. 0 No recommendation regarding use in ShakeMap. 1 Data recommended for use in ShakeMap. The site has good characteristics or there is no station with better characteristics nearby. ==> A new corresponding field needs to be added (NUMBER(1)). ==> Allow NULL values (different from 0). 4.- Structure/Array Reference Orientation (azimuth of Structure/Array): ----------------------------------------------------------------------- ==> A new corresponding field needs to be added (NUMBER(3)). ==> Allow NULL. 5.- Station Channel Number/Recorder Channel Number (Cosmos I50/I51): -------------------------------------------------------------------- ==> The current field 'chan_number' can be used to store the Station Channel Number. ==> The Recorder Channel Number can be found in the Hardware Tracking Schema. ==> Add both fields to c_channeldata. Channel description is relative to station (San Pablo Dam - Left Toe).