Thread: eport stations and azimuth data to excel

Started: 2020-08-16 02:28:50
Last activity: 2020-08-18 11:08:13
Topics: Wilber Help
Madlazim Madlazim
2020-08-16 02:28:50
I need export stations and azimuth data for each event from
https://ds.iris.edu/wilber3/find_stations/3337497
to excel file. How should I do it? Thanks a lot.
  • Adam Clark (Legacy)
    2020-08-18 11:08:13
    Hi Madlazim,

    There's not really a way to do this right now. The azimuth in particular is calculated on the fly, so there's no real "source" data to point to.

    One way to (fairly) easily get the raw station data is to make a data request with the "Request Body" format -- this is a text file that can be posted to various services (see http://service.iris.edu/fdsnws/station/docs/1/help/#postexamples) including the fdsnws-station service. So if you save it to 'wilber.request' and run

    curl -L --data-binary @wilber.request -o station.txt https://service.iris.edu/fdsnws/station/1/query

    you will get a StationXML file of the station data.

    You could also post it to:
    https://service.iris.edu/fdsnws/dataselect/1/query - to get the actual data
    https://service.iris.edu/fdsnws/availability/1/[extents|query] - to get availability data
    https://service.iris.edu/irisws/fedcatalog/1/query - to access services across data centers

    WARNING: In general these services don't impose any limits, they will try to serve as big a request as you provide. A large Wilber request all at once would overwhelm most of them, for practical use these should be chunked. (But the format is intended to make chunking easy.)

    All of these use (and may require) options specified at the top of the file, ie.

    level=station
    format=text
    TA A25A -- BH? 2010-03-25T00:00:00 2010-04-01T00:00:00
    IU ANMO * BH? 2010-03-25T00:00:00 2010-04-01T00:00:00
    IU ANMO 10 HHZ 2010-03-25T00:00:00 2010-04-01T00:00:00
    ..

    The options above (level=station, format=text) for the fdsnws-station call would get you something readable by Excel, but azimuth is a calculation based on some source location so it's not in the raw data. Excel could calculate it easily enough, I think; you might be able to find the code for it online somewhere.

    Cheers,
    Adam

    ----------------------
    Adam Clark
    Web Developer / Admin
    IRIS Data Management Center
    adam<at>iris.washington.edu



    On Aug 17, 2020, at 2:41 PM, Madlazim Madlazim (via IRIS) <wilber-help-9113.83307-bounce<at>lists.ds.iris.edu> wrote:

    I need export stations and azimuth data for each event from
    https://ds.iris.edu/wilber3/find_stations/3337497
    to excel file. How should I do it? Thanks a lot.

    ----------------------
    Wilber Help
    Topic home: http://ds.iris.edu/message-center/topic/wilber-help/ | Unsubscribe: wilber-help-unsubscribe<at>lists.ds.iris.edu

    Sent from the IRIS Message Center (http://ds.iris.edu/message-center/)
    Update subscription preferences at http://ds.iris.edu/account/profile/


23:37:55 v.01697673