[Antelope] calib tables and trexcerpt -de

[Gabe Plank]

Thanks Jennifer. That worked, as long as I put `dbjoin calibration` 
alongside every instrument join.

I shall continue to unravel the secrets of trexcerpt.pf.

Gabe

Jennifer Eakins wrote:
> 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
> 
> 
> 

-- 
// Gabe Plank
// Seismic Network Analyst
// Nevada Seismological Laboratory
// University of Nevada, Reno
// 775.784.7039