How can I start using Pisces ?

[Sepideh Rastin IESE]

Hi there,
I am a little confused how I can save my waveforms and metadata in a Pisces based database?
Can you please kindly advise me on this?
thanks

[jkmacc]

Hi Joni,

I'm so sorry I missed this post!  Right now (v 0.2.1), Pisces supports building at database from a directory of SAC files.  My intention is to also support building from other waveform and metadata formats, like miniseed or QuakeML.  After installing Pisces, you can "pisces sac2db -h" at your bash prompt to see how to do it.  I've pasted the help below.  Afterwards, you can use the documented tools query metadata, and load waveforms.  Please feel free to ask further questions!

Best,
Jon

$ pisces sac2db -h
Usage: pisces sac2db [OPTIONS] DB [FILES]...

  Scrape SAC files into database tables.

  SAC files may be used to produce the following tables: Wfdisc, Site,
  Sitechan, Origin, Event, Arrival, Assoc, Lastid, and Instrument.  Id
  numbering will follow the Lastid table, if one is found, otherwise it will
  start from 1.

  Examples -------- # use standard table names to local test.sqlite file
  pisces sac2db sqlite:///test.sqlite datadir/*.sac

  # prefix all tables in an oracle account with prefix my_, prompt for
  password pisces sac2db --prefix my_
  oracle://us...@server.domain.com:port/dbname datadir/*.sac

  # if there are too many SAC files for the shell to handle, use a list:
  find datadir -name "*.sac" -print > saclist.txt sac2db.py
  sqlite:///test.sqlite saclist.txt

Options:
  -t, --tables owner.tablename[,...]
                                  Comma-separated (no spaces), list of tables
                                  to create.  Default is all core tables with
                                  standard names.
  -p, --prefix TEXT               Target tables using 'account.prefix naming.
                                  e.g. myaccount.test_ will target tables like
                                  myaccount.test_origin,
                                  myaccount.test_sitechan.
  -A, --absolute_paths            If set, write database 'dir' directory
                                  entries as absolute paths, not relative.
  -l, --file_list FILENAME        A list file, one file name per line.
  -h, --help                      Show this message and exit.