[Antelope] calib tables and trexcerpt -de

[Jennifer Eakins]

Hi Gabe,

Have you tried modifying your trexcerpt.pf file?  Look for sections  
like I have below and add in the line for the join with the  
calibration table.

     # Following are the options for a view from which the
     # output station side of a database is constructed.
     station_database &Tbl{
         &Tbl{  # should never happen
             dbopen sensor
             dbjoin sitechan
             dbjoin site
             dbjoin -o instrument
	    dbjoin -o calibration
         }
     }

# Following are the various views trexcerpt will
# attempt to make the view from which waveforms will
# be loaded into the trace table.  Joining with site,
# sitechan, sensor and instrument facilitates propagating
# fields from these tables into the output.
waveform_view   &Tbl{
     &Tbl{
         dbopen sensor
         dbjoin sitechan
         dbjoin site
         dbjoin -o instrument
         dbjoin -o calibration
         dbleftjoin wfdisc sta chan time::endtime
     }
     &Tbl{
         dbopen wfdisc
         dbjoin -o site
     }
}

I tested this on a local database using the same command as you  
report below (subbing appropriate evid and db paths) and it seemed to  
produce a valid calibration table.

--Jennifer

On Jun 5, 2009, at 10:27 AM, Gabe Plank wrote:

> Hi folks-
>
> Using trexcerpt with the -de option writes most of the input tables  
> to the output database. However, the calibration table appears to  
> be ignored. Does anyone have experience with this? Do I need to add  
> a `dbjoin calibration` to one of the views in trexcerpt.pf ?
>
> Here's my $command =
>        "trexcerpt -v -m event ". # event mode
>        "-s 'evid ==\"$evid\"' ".   # subset on evid
>        "-c 'chan =~ /(BH.)|(BN.)|(HN.)|(HG.)/' ".          # subset  
> on channel
>        "-j 'distance(lat,lon,site.lat,site.lon) < $spdmax' ". #  
> subset on stadist
>        "-o sd ".      # write mseed datatype
>        "-e ".           # write event,origin,assoc,arrival tables
>        "-d ".           # write site, sitechan, calibration tables
>        "$input_db $output_db ".
>        "'parrival() - 5' 'sarrival() + 15'";
>
> Gabe
>
> // Gabe Plank
> // Seismic Network Analyst
> // Nevada Seismological Laboratory
> // University of Nevada, Reno
>
>
> _______________________________________________
> Antelope mailing list
> Antelope at brtt.net
> http://brtt.net/mailman/listinfo/antelope_brtt.net