Thread: eport stations and azimuth data to excel

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/