Difference between revisions of "CSEP 2 CATALOG FORMAT"
| (21 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
== Summary == | == Summary == | ||
| − | The general philosophy is | + | The general philosophy is the file format should be human readable and easy to use for both researchers and developers. (The actual storage of these catalogs in CSEP testing centers might be different than this proposed format). |
| − | The catalog will | + | The catalog will be defined as a (ASCII/utf-8) text-file in csv format. Each row corresponds to a single event. This file will have the following headers:<br><br> |
<code> | <code> | ||
| − | longitude, latitude, '''M''', time_string format="%Y-%m-% | + | longitude, latitude, '''M''', time_string format="%Y-%m-%dT%H:%M:%S.%f", depth, catalog_id, [event_id] |
</code> | </code> | ||
<code>'''longitude'''</code>: longitude in decimal degrees</br> | <code>'''longitude'''</code>: longitude in decimal degrees</br> | ||
<code>'''latitude'''</code>: latitude in decimal degrees</br> | <code>'''latitude'''</code>: latitude in decimal degrees</br> | ||
| − | <code>'''M'''</code>: magnitude | + | <code>'''M'''</code>: magnitude</br> |
| − | <code>'''time string (UTC)'''</code>: year-month-day hour-minute-second.fraction_second. strptime format="%Y-%m-% | + | <code>'''time string (UTC)'''</code>: year-month-day hour-minute-second.fraction_second. strptime format="%Y-%m-%dT%H:%M:%S.%f": example: 1985-01-01T00:00:00.0</br> |
<code>'''depth'''</code>: hypocenter depth in (km)</br> | <code>'''depth'''</code>: hypocenter depth in (km)</br> | ||
<code>'''catalog_id'''</code>: indicates type of catalog</br> | <code>'''catalog_id'''</code>: indicates type of catalog</br> | ||
| + | <code>'''event_id'''</code> [optional] column to indicate specific flags for a given event | ||
* observed: -1 | * observed: -1 | ||
* simulated: [0, n_cat-1] | * simulated: [0, n_cat-1] | ||
| − | This format can be easily extended to additional file types, including more advanced storage | + | This format can be easily extended to additional file types, including more advanced storage including binary, HDF5, or database representations. Modelers can chose an arbitrary number of catalogs to store within a file. Events will be mapped to catalogs through the ''catalog_id'' field, which would prevent the build-up of many, but potentially empty, catalog files. |
== Example Catalog == | == Example Catalog == | ||
| − | [Csep2_sample_catalog-comcat.csv] | + | [[Media:Csep2_sample_catalog-comcat.csv|Downloadable Example]] |
| + | The catalog at the above link contains 829 events. This catalog requires 52kb of storage. The table below shows expected sizes of these catalogs for individual catalogs (middle) and forecast (right) assuming 100000 catalogs per forecast. Important: If event_id is not provided by the modeler there needs to be a ',' in the final column. See example below. | ||
| + | |||
| + | {| class = 'wikitable' | ||
| + | |- | ||
| + | ! event count | ||
| + | ! catalog size (Mb) | ||
| + | ! forecast size (Gb) | ||
| + | |- | ||
| + | | 1 | ||
| + | | 0.00006 | ||
| + | | 0.00568 | ||
| + | |- | ||
| + | | 10 | ||
| + | | 0.00058 | ||
| + | | 0.05681 | ||
| + | |- | ||
| + | | 100 | ||
| + | | 0.00582 | ||
| + | | 0.56811 | ||
| + | |- | ||
| + | | 500 | ||
| + | | 0.02909 | ||
| + | | 2.84053 | ||
| + | |- | ||
| + | | 1000 | ||
| + | | 0.05817 | ||
| + | | 5.68107 | ||
| + | |- | ||
| + | | 5000 | ||
| + | | 0.29087 | ||
| + | | 28.40534 | ||
| + | |} | ||
<code> | <code> | ||
| − | lon,lat,M, | + | lon,lat,M,time_string,depth,catalog_id,event_id |
</code><br> | </code><br> | ||
| − | + | -117.43017,35.616665,4.73,2019-07-06T03:22:35.630000,9.35,-1,<br> | |
| − | -117.43017,35.616665,4.73,2019-07- | + | -117.7365,35.891,4.64,2019-07-06T03:22:48.300000,9.1,-1,<br> |
| − | -117.7365,35.891,4.64,2019-07- | + | -117.617836,35.803165,4.84,2019-07-06T03:23:50.720000,11.44,-1,<br> |
| − | -117.617836,35.803165,4.84,2019-07- | + | -117.67083,35.86067,4.61,2019-07-06T03:25:27.970000,10.32,-1,<br> |
| − | -117.67083,35.86067,4.61,2019-07- | + | -117.72583,35.913834,4.5,2019-07-06T03:27:07.010000,8.0,-1,<br> |
| − | -117.72583,35.913834,4.5,2019-07- | + | -117.431335,35.530334,4.57,2019-07-06T03:27:11.370000,3.83,-1,<br> |
| − | -117.431335,35.530334,4.57,2019-07- | + | -117.7115,35.902832,4.51,2019-07-06T03:29:32.080000,3.18,-1,<br> |
| − | -117.7115,35.902832,4.51,2019-07- | + | -117.35817,35.556667,4.49,2019-07-06T03:30:25.050000,8.71,-1,<br> |
| − | -117.35817,35.556667,4.49,2019-07- | + | -117.73033,35.890335,4.17,2019-07-06T03:32:46.660000,6.15,-1,<br> |
| − | -117.73033,35.890335,4.17,2019-07- | + | -117.505165,35.714832,4.13,2019-07-06T03:33:09.850000,1.74,-1,<br> |
| − | -117.505165,35.714832,4.13,2019-07- | + | -117.466835,35.65217,4.09,2019-07-06T03:35:05.420000,1.97,-1,<br> |
| − | -117.466835,35.65217,4.09,2019-07- | + | -117.73383,35.902832,4.35,2019-07-06T03:36:16.460000,7.27,-1,<br> |
| − | -117.73383,35.902832,4.35,2019-07- | ||
Latest revision as of 23:35, 11 June 2020
Contents
Summary
The general philosophy is the file format should be human readable and easy to use for both researchers and developers. (The actual storage of these catalogs in CSEP testing centers might be different than this proposed format).
The catalog will be defined as a (ASCII/utf-8) text-file in csv format. Each row corresponds to a single event. This file will have the following headers:
longitude, latitude, M, time_string format="%Y-%m-%dT%H:%M:%S.%f", depth, catalog_id, [event_id]
longitude: longitude in decimal degrees
latitude: latitude in decimal degrees
M: magnitude
time string (UTC): year-month-day hour-minute-second.fraction_second. strptime format="%Y-%m-%dT%H:%M:%S.%f": example: 1985-01-01T00:00:00.0
depth: hypocenter depth in (km)
catalog_id: indicates type of catalog
event_id [optional] column to indicate specific flags for a given event
- observed: -1
- simulated: [0, n_cat-1]
This format can be easily extended to additional file types, including more advanced storage including binary, HDF5, or database representations. Modelers can chose an arbitrary number of catalogs to store within a file. Events will be mapped to catalogs through the catalog_id field, which would prevent the build-up of many, but potentially empty, catalog files.
Example Catalog
The catalog at the above link contains 829 events. This catalog requires 52kb of storage. The table below shows expected sizes of these catalogs for individual catalogs (middle) and forecast (right) assuming 100000 catalogs per forecast. Important: If event_id is not provided by the modeler there needs to be a ',' in the final column. See example below.
| event count | catalog size (Mb) | forecast size (Gb) |
|---|---|---|
| 1 | 0.00006 | 0.00568 |
| 10 | 0.00058 | 0.05681 |
| 100 | 0.00582 | 0.56811 |
| 500 | 0.02909 | 2.84053 |
| 1000 | 0.05817 | 5.68107 |
| 5000 | 0.29087 | 28.40534 |
lon,lat,M,time_string,depth,catalog_id,event_id
-117.43017,35.616665,4.73,2019-07-06T03:22:35.630000,9.35,-1,
-117.7365,35.891,4.64,2019-07-06T03:22:48.300000,9.1,-1,
-117.617836,35.803165,4.84,2019-07-06T03:23:50.720000,11.44,-1,
-117.67083,35.86067,4.61,2019-07-06T03:25:27.970000,10.32,-1,
-117.72583,35.913834,4.5,2019-07-06T03:27:07.010000,8.0,-1,
-117.431335,35.530334,4.57,2019-07-06T03:27:11.370000,3.83,-1,
-117.7115,35.902832,4.51,2019-07-06T03:29:32.080000,3.18,-1,
-117.35817,35.556667,4.49,2019-07-06T03:30:25.050000,8.71,-1,
-117.73033,35.890335,4.17,2019-07-06T03:32:46.660000,6.15,-1,
-117.505165,35.714832,4.13,2019-07-06T03:33:09.850000,1.74,-1,
-117.466835,35.65217,4.09,2019-07-06T03:35:05.420000,1.97,-1,
-117.73383,35.902832,4.35,2019-07-06T03:36:16.460000,7.27,-1,
