Generate Database

Program gen_stdb

Description

Create Station Database dictionary from input text or stationXML file.

Usage

$ gen_stdb -h
Usage: gen_stdb [options] <station list>

Script to generate a pickled station database file. Available input formats are .csv and .xml. Check the documentation for more information.


Options:
  -h, --help       show this help message and exit
  -L, --long-keys  Specify Key format. Default is Net.Stn. Long keys are
                   Net.Stn.Chn
  -a, --ascii      Specify to write ascii Pickle files instead of binary.
                   Ascii are larger file size, but more likely to be system
                   independent.

Example

Let’s use the example in Database structure and create a database from information contained in a <space>-separated file. The basic format of the <space>-separated file for some TA stations would look like:

network

station

channel

latitude

longitude

elevation

startdate

enddate

TA	M31M	BH*	62.2024	-134.3906	0.64	2015-10-17	2599-12-31
TA	N32M	BH*	61.1512	-133.0818	0.82	2016-05-11	2599-12-31
TA	P33M	BH*	60.2114	-132.8174	1.07	2015-10-15	2599-12-31

We can generate a database using the program:

$ gen_stdb ta_table.csv

Parse Station List ta_table.csv
Adding key: TA.M31M
Adding key: TA.N32M
Adding key: TA.P33M
  Pickling ta_table.pkl

Also, starting with version 0.2.7, StDb can now handle the conversion from stationXML (inventory) object to an StDb database. The function load_db() from the module io can now ingest an inventory object and convert it to an StDb database. Also, the script gen_stdb can generate an StDb database from a stationXML file:

$ gen_stdb ta_stations.xml

Parse Station XML: ta_stations.xml
Search Complete:
  3 stations in 1 networks
  ...
  Pickling to ta_stations.pkl
  Saving csv to: ta_stations.csv

Now we can check that the databases contain the same list using the program ls_stdb:

$ ls_stdb ta_table.pkl

Listing Station Pickle: ta_table.pkl
TA.M31M
--------------------------------------------------------------------------
1) TA.M31M
     Station: TA M31M
      Alternate Networks: None
      Channel: BH ;  Location: "--"
      Lon, Lat, Elev:  62.20240, -134.39060,   0.640
      StartTime: 2015-10-17 00:00:00
      EndTime:   2599-12-31 00:00:00
      Status:
      Polarity: 1
      Azimuth Correction: 0.000000


TA.N32M
--------------------------------------------------------------------------
2) TA.N32M
     Station: TA N32M
      Alternate Networks: None
      Channel: BH ;  Location: "--"
      Lon, Lat, Elev:  61.15120, -133.08180,   0.820
      StartTime: 2016-05-11 00:00:00
      EndTime:   2599-12-31 00:00:00
      Status:
      Polarity: 1
      Azimuth Correction: 0.000000


TA.P33M
--------------------------------------------------------------------------
3) TA.P33M
     Station: TA P33M
      Alternate Networks: None
      Channel: BH ;  Location: "--"
      Lon, Lat, Elev:  60.21140, -132.81740,   1.070
      StartTime: 2015-10-15 00:00:00
      EndTime:   2599-12-31 00:00:00
      Status:
      Polarity: 1
      Azimuth Correction: 0.000000