Discrepanza delle 'fasi' tra 'seisev' e 'quakedb'
@andrea.bono e @lucia.margheriti mi hanno chiesto di indagare sulla seguente incongruenza di dati tra seisev e quakedb.
Nello specifico, per l'evento con:
quakedb.event.id_localspace=seisev.event.id_locator=355262
proveniente da:
-
hew10
,
si sono riscontrate solo 5 fasi su quakedb rispetto alle 30 di seisev.
Questa una bozza di query per seisev:
MySQL [seisev]> SELECT
-> *
-> FROM
-> event e
-> JOIN writer w ON e.fk_writer = w.id
-> JOIN hypocenter h ON h.fk_event = e.id
-> JOIN hyp_lnk_pha hlp ON hlp.fk_hypocenter = h.id
-> JOIN phase p ON hlp.fk_phase = p.id
-> WHERE
-> id_locator = 355262
-> AND w.short LIKE 'hew10%'
-> AND h.fk_version = 1;
+----------+-------------+------------+----------------+---------+-------------+-----------------+---------------+-----------+---------------------+------+---------------------------+---------------------------------+---------------------+----------+---------------------+--------+-----------+--------+-------+--------+---------+---------+-----------+-------+-------+----------------+-------+--------+-------------------+-------+--------+------+------+-----------+--------------+--------------+----------+--------------+------+-------+----------------+----------------+-------------+------+-------+---------+--------+---------+-------------------------------------------------+----------+---------------------+---------+-----------+------------+----------+----------+----------------+------------+---------------+-----------+--------+-------------+--------------+--------+----------+------------------+------------------+----------+-----------------+--------+-----------+---------------------+-----------+----------+------------+----------+--------+---------------------+--------+------------------+-------------+---------+------+---------+---------+---------+---------+---------+---------+--------+--------+--------+--------+--------+--------+-----------+---------------------+---------+
| id | ingv_writer | id_locator | web_id_locator | pro_civ | fk_pref_hyp | fk_events_group | fk_type_event | fk_writer | modified | id | short | name | modified | id | ot | usec | lat | lon | depth | err_ot | err_lat | err_lon | err_depth | err_h | err_z | confidence_lev | e0_az | e0_dip | e0 | e1_az | e1_dip | e1 | e2 | fix_depth | min_distance | max_distance | azim_gap | sec_azim_gap | rms | w_rms | w_max_distance | w_max_residual | is_centroid | nph | nph_s | nph_tot | nph_fm | quality | region | dpc_time | modified | fk_note | fk_writer | fk_version | fk_event | fk_model | fk_loc_program | id | fk_hypocenter | fk_phase | ph_isc | ep_distance | hyp_distance | azimut | take_off | polarity_is_used | arr_time_is_used | residual | teo_travel_time | weight | std_error | modified | id | cha_code | phase_code | isc_code | weight | arrival_time | usec | err_arrival_time | firstmotion | emersio | pamp | ccntr_0 | ccntr_1 | ccntr_2 | ccntr_3 | ccntr_4 | ccntr_5 | caav_0 | caav_1 | caav_2 | caav_3 | caav_4 | caav_5 | fk_writer | modified | fk_scnl |
+----------+-------------+------------+----------------+---------+-------------+-----------------+---------------+-----------+---------------------+------+---------------------------+---------------------------------+---------------------+----------+---------------------+--------+-----------+--------+-------+--------+---------+---------+-----------+-------+-------+----------------+-------+--------+-------------------+-------+--------+------+------+-----------+--------------+--------------+----------+--------------+------+-------+----------------+----------------+-------------+------+-------+---------+--------+---------+-------------------------------------------------+----------+---------------------+---------+-----------+------------+----------+----------+----------------+------------+---------------+-----------+--------+-------------+--------------+--------+----------+------------------+------------------+----------+-----------------+--------+-----------+---------------------+-----------+----------+------------+----------+--------+---------------------+--------+------------------+-------------+---------+------+---------+---------+---------+---------+---------+---------+--------+--------+--------+--------+--------+--------+-----------+---------------------+---------+
| 28137841 | NULL | 355262 | 4028137841 | u | NULL | NULL | 1 | 1401 | 2021-08-31 04:14:35 | 1401 | hew10_mole#MOD_EQASSEMBLE | Sistema Automatico Earthworm-10 | 2019-06-13 12:47:12 | 94847061 | 2021-08-31 04:14:02 | 780000 | 38.175999 | 13.901 | 65.5 | NULL | NULL | NULL | NULL | 2.2 | 6.16 | 68.3 | 320 | 81 | 6.230000019073486 | 162 | 7 | 2.22 | 1.19 | 0 | 23 | NULL | 135 | NULL | 0.91 | NULL | NULL | NULL | 0 | 30 | 25 | 30 | 5 | CB | Costa Siciliana centro-settentrionale (Palermo) | NULL | 2021-08-31 04:14:45 | NULL | 1401 | 1 | 28137841 | 9 | 3 | 1841647911 | 94847061 | 546923911 | NULL | 23.4 | NULL | 151 | 157 | NULL | NULL | 0.56 | NULL | 1.31 | NULL | 2021-08-31 04:14:46 | 546923911 | Z | P | P | 0 | 2021-08-31 04:14:13 | 630000 | NULL | D | NULL | 223 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1401 | 2021-08-31 04:14:36 | 547 |
| 28137841 | NULL | 355262 | 4028137841 | u | NULL | NULL | 1 | 1401 | 2021-08-31 04:14:35 | 1401 | hew10_mole#MOD_EQASSEMBLE | Sistema Automatico Earthworm-10 | 2019-06-13 12:47:12 | 94847061 | 2021-08-31 04:14:02 | 780000 | 38.175999 | 13.901 | 65.5 | NULL | NULL | NULL | NULL | 2.2 | 6.16 | 68.3 | 320 | 81 | 6.230000019073486 | 162 | 7 | 2.22 | 1.19 | 0 | 23 | NULL | 135 | NULL | 0.91 | NULL | NULL | NULL | 0 | 30 | 25 | 30 | 5 | CB | Costa Siciliana centro-settentrionale (Palermo) | NULL | 2021-08-31 04:14:45 | NULL | 1401 | 1 | 28137841 | 9 | 3 | 1841647921 | 94847061 | 546923921 | NULL | 29.299999 | NULL | 208 | 152 | NULL | NULL | 1.19 | NULL | 0.33 | NULL | 2021-08-31 04:14:46 | 546923921 | Z | P | P | 3 | 2021-08-31 04:14:14 | 570000 | NULL | U | NULL | 23 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1401 | 2021-08-31 04:14:36 | 1421641 |
| 28137841 | NULL | 355262 | 4028137841 | u | NULL | NULL | 1 | 1401 | 2021-08-31 04:14:35 | 1401 | hew10_mole#MOD_EQASSEMBLE | Sistema Automatico Earthworm-10 | 2019-06-13 12:47:12 | 94847061 | 2021-08-31 04:14:02 | 780000 | 38.175999 | 13.901 | 65.5 | NULL | NULL | NULL | NULL | 2.2 | 6.16 | 68.3 | 320 | 81 | 6.230000019073486 | 162 | 7 | 2.22 | 1.19 | 0 | 23 | NULL | 135 | NULL | 0.91 | NULL | NULL | NULL | 0 | 30 | 25 | 30 | 5 | CB | Costa Siciliana centro-settentrionale (Palermo) | NULL | 2021-08-31 04:14:45 | NULL | 1401 | 1 | 28137841 | 9 | 3 | 1841647931 | 94847061 | 546923931 | NULL | 29.299999 | NULL | 208 | 152 | NULL | NULL | -1.67 | NULL | 1.31 | NULL | 2021-08-31 04:14:46 | 546923931 | Z | S | S | 0 | 2021-08-31 04:14:19 | 980000 | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1401 | 2021-08-31 04:14:36 | 1426911 |
| 28137841 | NULL | 355262 | 4028137841 | u | NULL | NULL | 1 | 1401 | 2021-08-31 04:14:35 | 1401 | hew10_mole#MOD_EQASSEMBLE | Sistema Automatico Earthworm-10 | 2019-06-13 12:47:12 | 94847061 | 2021-08-31 04:14:02 | 780000 | 38.175999 | 13.901 | 65.5 | NULL | NULL | NULL | NULL | 2.2 | 6.16 | 68.3 | 320 | 81 | 6.230000019073486 | 162 | 7 | 2.22 | 1.19 | 0 | 23 | NULL | 135 | NULL | 0.91 | NULL | NULL | NULL | 0 | 30 | 25 | 30 | 5 | CB | Costa Siciliana centro-settentrionale (Palermo) | NULL | 2021-08-31 04:14:45 | NULL | 1401 | 1 | 28137841 | 9 | 3 | 1841647951 | 94847061 | 546923941 | NULL | 29.799999 | NULL | 152 | 151 | NULL | NULL | 0.95 | NULL | 0.98 | NULL | 2021-08-31 04:14:46 | 546923941 | Z | P | P | 1 | 2021-08-31 04:14:14 | 360000 | NULL | D | NULL | 60 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1401 | 2021-08-31 04:14:36 | 49791 |
| 28137841 | NULL | 355262 | 4028137841 | u | NULL | NULL | 1 | 1401 | 2021-08-31 04:14:35 | 1401 | hew10_mole#MOD_EQASSEMBLE | Sistema Automatico Earthworm-10 | 2019-06-13 12:47:12 | 94847061 | 2021-08-31 04:14:02 | 780000 | 38.175999 | 13.901 | 65.5 | NULL | NULL | NULL | NULL | 2.2 | 6.16 | 68.3 | 320 | 81 | 6.230000019073486 | 162 | 7 | 2.22 | 1.19 | 0 | 23 | NULL | 135 | NULL | 0.91 | NULL | NULL | NULL | 0 | 30 | 25 | 30 | 5 | CB | Costa Siciliana centro-settentrionale (Palermo) | NULL | 2021-08-31 04:14:45 | NULL | 1401 | 1 | 28137841 | 9 | 3 | 1841647941 | 94847061 | 546923951 | NULL | 29.4 | NULL | 133 | 151 | NULL | NULL | 1.51 | NULL | 0.66 | NULL | 2021-08-31 04:14:46 | 546923951 | Z | P | P | 2 | 2021-08-31 04:14:14 | 900000 | NULL | D | NULL | 126 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1401 | 2021-08-31 04:14:36 | 51151 |
| 28137841 | NULL | 355262 | 4028137841 | u | NULL | NULL | 1 | 1401 | 2021-08-31 04:14:35 | 1401 | hew10_mole#MOD_EQASSEMBLE | Sistema Automatico Earthworm-10 | 2019-06-13 12:47:12 | 94847061 | 2021-08-31 04:14:02 | 780000 | 38.175999 | 13.901 | 65.5 | NULL | NULL | NULL | NULL | 2.2 | 6.16 | 68.3 | 320 | 81 | 6.230000019073486 | 162 | 7 | 2.22 | 1.19 | 0 | 23 | NULL | 135 | NULL | 0.91 | NULL | NULL | NULL | 0 | 30 | 25 | 30 | 5 | CB | Costa Siciliana centro-settentrionale (Palermo) | NULL | 2021-08-31 04:14:45 | NULL | 1401 | 1 | 28137841 | 9 | 3 | 1841647961 | 94847061 | 546923961 | NULL | 33.599998 | NULL | 255 | 148 | NULL | NULL | 2.49 | NULL | 0.16 | NULL | 2021-08-31 04:14:46 | 546923961 | Z | P | P | 3 | 2021-08-31 04:14:16 | 140000 | NULL | D | NULL | 57 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1401 | 2021-08-31 04:14:36 | 537 |
| 28137841 | NULL | 355262 | 4028137841 | u | NULL | NULL | 1 | 1401 | 2021-08-31 04:14:35 | 1401 | hew10_mole#MOD_EQASSEMBLE | Sistema Automatico Earthworm-10 | 2019-06-13 12:47:12 | 94847061 | 2021-08-31 04:14:02 | 780000 | 38.175999 | 13.901 | 65.5 | NULL | NULL | NULL | NULL | 2.2 | 6.16 | 68.3 | 320 | 81 | 6.230000019073486 | 162 | 7 | 2.22 | 1.19 | 0 | 23 | NULL | 135 | NULL | 0.91 | NULL | NULL | NULL | 0 | 30 | 25 | 30 | 5 | CB | Costa Siciliana centro-settentrionale (Palermo) | NULL | 2021-08-31 04:14:45 | NULL | 1401 | 1 | 28137841 | 9 | 3 | 1841647971 | 94847061 | 546923971 | NULL | 47.400002 | NULL | 269 | 138 | NULL | NULL | -0.16 | NULL | 1.31 | NULL | 2021-08-31 04:14:46 | 546923971 | Z | S | S | 0 | 2021-08-31 04:14:23 | 780000 | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1401 | 2021-08-31 04:14:36 | 4171 |
| 28137841 | NULL | 355262 | 4028137841 | u | NULL | NULL | 1 | 1401 | 2021-08-31 04:14:35 | 1401 | hew10_mole#MOD_EQASSEMBLE | Sistema Automatico Earthworm-10 | 2019-06-13 12:47:12 | 94847061 | 2021-08-31 04:14:02 | 780000 | 38.175999 | 13.901 | 65.5 | NULL | NULL | NULL | NULL | 2.2 | 6.16 | 68.3 | 320 | 81 | 6.230000019073486 | 162 | 7 | 2.22 | 1.19 | 0 | 23 | NULL | 135 | NULL | 0.91 | NULL | NULL | NULL | 0 | 30 | 25 | 30 | 5 | CB | Costa Siciliana centro-settentrionale (Palermo) | NULL | 2021-08-31 04:14:45 | NULL | 1401 | 1 | 28137841 | 9 | 3 | 1841647991 | 94847061 | 546923981 | NULL | 60.299999 | NULL | 166 | 130 | NULL | NULL | -0.09 | NULL | 1.31 | NULL | 2021-08-31 04:14:46 | 546923981 | Z | S | S | 0 | 2021-08-31 04:14:25 | 880000 | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1401 | 2021-08-31 04:14:36 | 237 |
| 28137841 | NULL | 355262 | 4028137841 | u | NULL | NULL | 1 | 1401 | 2021-08-31 04:14:35 | 1401 | hew10_mole#MOD_EQASSEMBLE | Sistema Automatico Earthworm-10 | 2019-06-13 12:47:12 | 94847061 | 2021-08-31 04:14:02 | 780000 | 38.175999 | 13.901 | 65.5 | NULL | NULL | NULL | NULL | 2.2 | 6.16 | 68.3 | 320 | 81 | 6.230000019073486 | 162 | 7 | 2.22 | 1.19 | 0 | 23 | NULL | 135 | NULL | 0.91 | NULL | NULL | NULL | 0 | 30 | 25 | 30 | 5 | CB | Costa Siciliana centro-settentrionale (Palermo) | NULL | 2021-08-31 04:14:45 | NULL | 1401 | 1 | 28137841 | 9 | 3 | 1841647981 | 94847061 | 546924271 | NULL | 56.099998 | NULL | 44 | 132 | NULL | NULL | 1.55 | NULL | 0.98 | NULL | 2021-08-31 04:14:46 | 546924271 | Z | S | Sg | 1 | 2021-08-31 04:14:26 | 830000 | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1401 | 2021-08-31 04:14:46 | 241 |
| 28137841 | NULL | 355262 | 4028137841 | u | NULL | NULL | 1 | 1401 | 2021-08-31 04:14:35 | 1401 | hew10_mole#MOD_EQASSEMBLE | Sistema Automatico Earthworm-10 | 2019-06-13 12:47:12 | 94847061 | 2021-08-31 04:14:02 | 780000 | 38.175999 | 13.901 | 65.5 | NULL | NULL | NULL | NULL | 2.2 | 6.16 | 68.3 | 320 | 81 | 6.230000019073486 | 162 | 7 | 2.22 | 1.19 | 0 | 23 | NULL | 135 | NULL | 0.91 | NULL | NULL | NULL | 0 | 30 | 25 | 30 | 5 | CB | Costa Siciliana centro-settentrionale (Palermo) | NULL | 2021-08-31 04:14:45 | NULL | 1401 | 1 | 28137841 | 9 | 3 | 1841648001 | 94847061 | 546924281 | NULL | 62.599998 | NULL | 104 | 129 | NULL | NULL | 0.05 | NULL | 1.31 | NULL | 2021-08-31 04:14:46 | 546924281 | Z | S | S | 0 | 2021-08-31 04:14:26 | 400000 | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1401 | 2021-08-31 04:14:46 | 2285 |
| 28137841 | NULL | 355262 | 4028137841 | u | NULL | NULL | 1 | 1401 | 2021-08-31 04:14:35 | 1401 | hew10_mole#MOD_EQASSEMBLE | Sistema Automatico Earthworm-10 | 2019-06-13 12:47:12 | 94847061 | 2021-08-31 04:14:02 | 780000 | 38.175999 | 13.901 | 65.5 | NULL | NULL | NULL | NULL | 2.2 | 6.16 | 68.3 | 320 | 81 | 6.230000019073486 | 162 | 7 | 2.22 | 1.19 | 0 | 23 | NULL | 135 | NULL | 0.91 | NULL | NULL | NULL | 0 | 30 | 25 | 30 | 5 | CB | Costa Siciliana centro-settentrionale (Palermo) | NULL | 2021-08-31 04:14:45 | NULL | 1401 | 1 | 28137841 | 9 | 3 | 1841648011 | 94847061 | 546924291 | NULL | 67 | NULL | 203 | 127 | NULL | NULL | 1.58 | NULL | 1.31 | NULL | 2021-08-31 04:14:46 | 546924291 | Z | S | Sg | 0 | 2021-08-31 04:14:28 | 690000 | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1401 | 2021-08-31 04:14:46 | 2409971 |
| 28137841 | NULL | 355262 | 4028137841 | u | NULL | NULL | 1 | 1401 | 2021-08-31 04:14:35 | 1401 | hew10_mole#MOD_EQASSEMBLE | Sistema Automatico Earthworm-10 | 2019-06-13 12:47:12 | 94847061 | 2021-08-31 04:14:02 | 780000 | 38.175999 | 13.901 | 65.5 | NULL | NULL | NULL | NULL | 2.2 | 6.16 | 68.3 | 320 | 81 | 6.230000019073486 | 162 | 7 | 2.22 | 1.19 | 0 | 23 | NULL | 135 | NULL | 0.91 | NULL | NULL | NULL | 0 | 30 | 25 | 30 | 5 | CB | Costa Siciliana centro-settentrionale (Palermo) | NULL | 2021-08-31 04:14:45 | NULL | 1401 | 1 | 28137841 | 9 | 3 | 1841648021 | 94847061 | 546924301 | NULL | 73 | NULL | 53 | 124 | NULL | NULL | 0.9 | NULL | 0.98 | NULL | 2021-08-31 04:14:46 | 546924301 | Z | S | Sn | 1 | 2021-08-31 04:14:29 | 80000 | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1401 | 2021-08-31 04:14:46 | 2149 |
| 28137841 | NULL | 355262 | 4028137841 | u | NULL | NULL | 1 | 1401 | 2021-08-31 04:14:35 | 1401 | hew10_mole#MOD_EQASSEMBLE | Sistema Automatico Earthworm-10 | 2019-06-13 12:47:12 | 94847061 | 2021-08-31 04:14:02 | 780000 | 38.175999 | 13.901 | 65.5 | NULL | NULL | NULL | NULL | 2.2 | 6.16 | 68.3 | 320 | 81 | 6.230000019073486 | 162 | 7 | 2.22 | 1.19 | 0 | 23 | NULL | 135 | NULL | 0.91 | NULL | NULL | NULL | 0 | 30 | 25 | 30 | 5 | CB | Costa Siciliana centro-settentrionale (Palermo) | NULL | 2021-08-31 04:14:45 | NULL | 1401 | 1 | 28137841 | 9 | 3 | 1841648031 | 94847061 | 546924311 | NULL | 73 | NULL | 94 | 124 | NULL | NULL | 0.03 | NULL | 1.31 | NULL | 2021-08-31 04:14:46 | 546924311 | Z | S | Sn | 0 | 2021-08-31 04:14:28 | 210000 | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1401 | 2021-08-31 04:14:46 | 6921 |
| 28137841 | NULL | 355262 | 4028137841 | u | NULL | NULL | 1 | 1401 | 2021-08-31 04:14:35 | 1401 | hew10_mole#MOD_EQASSEMBLE | Sistema Automatico Earthworm-10 | 2019-06-13 12:47:12 | 94847061 | 2021-08-31 04:14:02 | 780000 | 38.175999 | 13.901 | 65.5 | NULL | NULL | NULL | NULL | 2.2 | 6.16 | 68.3 | 320 | 81 | 6.230000019073486 | 162 | 7 | 2.22 | 1.19 | 0 | 23 | NULL | 135 | NULL | 0.91 | NULL | NULL | NULL | 0 | 30 | 25 | 30 | 5 | CB | Costa Siciliana centro-settentrionale (Palermo) | NULL | 2021-08-31 04:14:45 | NULL | 1401 | 1 | 28137841 | 9 | 3 | 1841648041 | 94847061 | 546924321 | NULL | 78 | NULL | 131 | 122 | NULL | NULL | -0.31 | NULL | 1.31 | NULL | 2021-08-31 04:14:46 | 546924321 | Z | S | Sn | 0 | 2021-08-31 04:14:28 | 800000 | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1401 | 2021-08-31 04:14:46 | 179 |
| 28137841 | NULL | 355262 | 4028137841 | u | NULL | NULL | 1 | 1401 | 2021-08-31 04:14:35 | 1401 | hew10_mole#MOD_EQASSEMBLE | Sistema Automatico Earthworm-10 | 2019-06-13 12:47:12 | 94847061 | 2021-08-31 04:14:02 | 780000 | 38.175999 | 13.901 | 65.5 | NULL | NULL | NULL | NULL | 2.2 | 6.16 | 68.3 | 320 | 81 | 6.230000019073486 | 162 | 7 | 2.22 | 1.19 | 0 | 23 | NULL | 135 | NULL | 0.91 | NULL | NULL | NULL | 0 | 30 | 25 | 30 | 5 | CB | Costa Siciliana centro-settentrionale (Palermo) | NULL | 2021-08-31 04:14:45 | NULL | 1401 | 1 | 28137841 | 9 | 3 | 1841648051 | 94847061 | 546924331 | NULL | 79.300003 | NULL | 185 | 121 | NULL | NULL | 1.56 | NULL | 0.98 | NULL | 2021-08-31 04:14:46 | 546924331 | Z | S | Sg | 1 | 2021-08-31 04:14:30 | 900000 | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1401 | 2021-08-31 04:14:46 | 50531 |
| 28137841 | NULL | 355262 | 4028137841 | u | NULL | NULL | 1 | 1401 | 2021-08-31 04:14:35 | 1401 | hew10_mole#MOD_EQASSEMBLE | Sistema Automatico Earthworm-10 | 2019-06-13 12:47:12 | 94847061 | 2021-08-31 04:14:02 | 780000 | 38.175999 | 13.901 | 65.5 | NULL | NULL | NULL | NULL | 2.2 | 6.16 | 68.3 | 320 | 81 | 6.230000019073486 | 162 | 7 | 2.22 | 1.19 | 0 | 23 | NULL | 135 | NULL | 0.91 | NULL | NULL | NULL | 0 | 30 | 25 | 30 | 5 | CB | Costa Siciliana centro-settentrionale (Palermo) | NULL | 2021-08-31 04:14:45 | NULL | 1401 | 1 | 28137841 | 9 | 3 | 1841648061 | 94847061 | 546924341 | NULL | 81 | NULL | 139 | 121 | NULL | NULL | 0.3 | NULL | 0.66 | NULL | 2021-08-31 04:14:46 | 546924341 | Z | S | Sn | 2 | 2021-08-31 04:14:29 | 940000 | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1401 | 2021-08-31 04:14:46 | 593 |
| 28137841 | NULL | 355262 | 4028137841 | u | NULL | NULL | 1 | 1401 | 2021-08-31 04:14:35 | 1401 | hew10_mole#MOD_EQASSEMBLE | Sistema Automatico Earthworm-10 | 2019-06-13 12:47:12 | 94847061 | 2021-08-31 04:14:02 | 780000 | 38.175999 | 13.901 | 65.5 | NULL | NULL | NULL | NULL | 2.2 | 6.16 | 68.3 | 320 | 81 | 6.230000019073486 | 162 | 7 | 2.22 | 1.19 | 0 | 23 | NULL | 135 | NULL | 0.91 | NULL | NULL | NULL | 0 | 30 | 25 | 30 | 5 | CB | Costa Siciliana centro-settentrionale (Palermo) | NULL | 2021-08-31 04:14:45 | NULL | 1401 | 1 | 28137841 | 9 | 3 | 1841648071 | 94847061 | 546924351 | NULL | 86.599998 | NULL | 99 | 119 | NULL | NULL | -0.61 | NULL | 1.31 | NULL | 2021-08-31 04:14:46 | 546924351 | Z | S | Sn | 0 | 2021-08-31 04:14:30 | 100000 | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1401 | 2021-08-31 04:14:46 | 2273 |
| 28137841 | NULL | 355262 | 4028137841 | u | NULL | NULL | 1 | 1401 | 2021-08-31 04:14:35 | 1401 | hew10_mole#MOD_EQASSEMBLE | Sistema Automatico Earthworm-10 | 2019-06-13 12:47:12 | 94847061 | 2021-08-31 04:14:02 | 780000 | 38.175999 | 13.901 | 65.5 | NULL | NULL | NULL | NULL | 2.2 | 6.16 | 68.3 | 320 | 81 | 6.230000019073486 | 162 | 7 | 2.22 | 1.19 | 0 | 23 | NULL | 135 | NULL | 0.91 | NULL | NULL | NULL | 0 | 30 | 25 | 30 | 5 | CB | Costa Siciliana centro-settentrionale (Palermo) | NULL | 2021-08-31 04:14:45 | NULL | 1401 | 1 | 28137841 | 9 | 3 | 1841648081 | 94847061 | 546924361 | NULL | 87 | NULL | 254 | 119 | NULL | NULL | -1.14 | NULL | 0.33 | NULL | 2021-08-31 04:14:46 | 546924361 | Z | S | Sn | 3 | 2021-08-31 04:14:29 | 640000 | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1401 | 2021-08-31 04:14:46 | 179381 |
| 28137841 | NULL | 355262 | 4028137841 | u | NULL | NULL | 1 | 1401 | 2021-08-31 04:14:35 | 1401 | hew10_mole#MOD_EQASSEMBLE | Sistema Automatico Earthworm-10 | 2019-06-13 12:47:12 | 94847061 | 2021-08-31 04:14:02 | 780000 | 38.175999 | 13.901 | 65.5 | NULL | NULL | NULL | NULL | 2.2 | 6.16 | 68.3 | 320 | 81 | 6.230000019073486 | 162 | 7 | 2.22 | 1.19 | 0 | 23 | NULL | 135 | NULL | 0.91 | NULL | NULL | NULL | 0 | 30 | 25 | 30 | 5 | CB | Costa Siciliana centro-settentrionale (Palermo) | NULL | 2021-08-31 04:14:45 | NULL | 1401 | 1 | 28137841 | 9 | 3 | 1841648091 | 94847061 | 546924371 | NULL | 89.099998 | NULL | 243 | 118 | NULL | NULL | -0.83 | NULL | 0.98 | NULL | 2021-08-31 04:14:46 | 546924371 | Z | S | Sn | 1 | 2021-08-31 04:14:30 | 360000 | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1401 | 2021-08-31 04:14:46 | 172041 |
| 28137841 | NULL | 355262 | 4028137841 | u | NULL | NULL | 1 | 1401 | 2021-08-31 04:14:35 | 1401 | hew10_mole#MOD_EQASSEMBLE | Sistema Automatico Earthworm-10 | 2019-06-13 12:47:12 | 94847061 | 2021-08-31 04:14:02 | 780000 | 38.175999 | 13.901 | 65.5 | NULL | NULL | NULL | NULL | 2.2 | 6.16 | 68.3 | 320 | 81 | 6.230000019073486 | 162 | 7 | 2.22 | 1.19 | 0 | 23 | NULL | 135 | NULL | 0.91 | NULL | NULL | NULL | 0 | 30 | 25 | 30 | 5 | CB | Costa Siciliana centro-settentrionale (Palermo) | NULL | 2021-08-31 04:14:45 | NULL | 1401 | 1 | 28137841 | 9 | 3 | 1841648101 | 94847061 | 546924381 | NULL | 89.699997 | NULL | 223 | 118 | NULL | NULL | 0.48 | NULL | 1.31 | NULL | 2021-08-31 04:14:46 | 546924381 | Z | S | Sn | 0 | 2021-08-31 04:14:31 | 780000 | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1401 | 2021-08-31 04:14:46 | 461 |
| 28137841 | NULL | 355262 | 4028137841 | u | NULL | NULL | 1 | 1401 | 2021-08-31 04:14:35 | 1401 | hew10_mole#MOD_EQASSEMBLE | Sistema Automatico Earthworm-10 | 2019-06-13 12:47:12 | 94847061 | 2021-08-31 04:14:02 | 780000 | 38.175999 | 13.901 | 65.5 | NULL | NULL | NULL | NULL | 2.2 | 6.16 | 68.3 | 320 | 81 | 6.230000019073486 | 162 | 7 | 2.22 | 1.19 | 0 | 23 | NULL | 135 | NULL | 0.91 | NULL | NULL | NULL | 0 | 30 | 25 | 30 | 5 | CB | Costa Siciliana centro-settentrionale (Palermo) | NULL | 2021-08-31 04:14:45 | NULL | 1401 | 1 | 28137841 | 9 | 3 | 1841648111 | 94847061 | 546924391 | NULL | 92.599998 | NULL | 114 | 117 | NULL | NULL | 0.56 | NULL | 1.31 | NULL | 2021-08-31 04:14:46 | 546924391 | Z | S | Sn | 0 | 2021-08-31 04:14:32 | 440000 | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1401 | 2021-08-31 04:14:46 | 9031 |
| 28137841 | NULL | 355262 | 4028137841 | u | NULL | NULL | 1 | 1401 | 2021-08-31 04:14:35 | 1401 | hew10_mole#MOD_EQASSEMBLE | Sistema Automatico Earthworm-10 | 2019-06-13 12:47:12 | 94847061 | 2021-08-31 04:14:02 | 780000 | 38.175999 | 13.901 | 65.5 | NULL | NULL | NULL | NULL | 2.2 | 6.16 | 68.3 | 320 | 81 | 6.230000019073486 | 162 | 7 | 2.22 | 1.19 | 0 | 23 | NULL | 135 | NULL | 0.91 | NULL | NULL | NULL | 0 | 30 | 25 | 30 | 5 | CB | Costa Siciliana centro-settentrionale (Palermo) | NULL | 2021-08-31 04:14:45 | NULL | 1401 | 1 | 28137841 | 9 | 3 | 1841648121 | 94847061 | 546924401 | NULL | 96.400002 | NULL | 71 | 116 | NULL | NULL | -0.39 | NULL | 1.31 | NULL | 2021-08-31 04:14:46 | 546924401 | Z | S | Sn | 0 | 2021-08-31 04:14:32 | 220000 | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1401 | 2021-08-31 04:14:46 | 3952521 |
| 28137841 | NULL | 355262 | 4028137841 | u | NULL | NULL | 1 | 1401 | 2021-08-31 04:14:35 | 1401 | hew10_mole#MOD_EQASSEMBLE | Sistema Automatico Earthworm-10 | 2019-06-13 12:47:12 | 94847061 | 2021-08-31 04:14:02 | 780000 | 38.175999 | 13.901 | 65.5 | NULL | NULL | NULL | NULL | 2.2 | 6.16 | 68.3 | 320 | 81 | 6.230000019073486 | 162 | 7 | 2.22 | 1.19 | 0 | 23 | NULL | 135 | NULL | 0.91 | NULL | NULL | NULL | 0 | 30 | 25 | 30 | 5 | CB | Costa Siciliana centro-settentrionale (Palermo) | NULL | 2021-08-31 04:14:45 | NULL | 1401 | 1 | 28137841 | 9 | 3 | 1841648131 | 94847061 | 546924411 | NULL | 99.300003 | NULL | 236 | 115 | NULL | NULL | -1.6 | NULL | 0.66 | NULL | 2021-08-31 04:14:46 | 546924411 | Z | S | Sn | 2 | 2021-08-31 04:14:31 | 600000 | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1401 | 2021-08-31 04:14:46 | 175791 |
| 28137841 | NULL | 355262 | 4028137841 | u | NULL | NULL | 1 | 1401 | 2021-08-31 04:14:35 | 1401 | hew10_mole#MOD_EQASSEMBLE | Sistema Automatico Earthworm-10 | 2019-06-13 12:47:12 | 94847061 | 2021-08-31 04:14:02 | 780000 | 38.175999 | 13.901 | 65.5 | NULL | NULL | NULL | NULL | 2.2 | 6.16 | 68.3 | 320 | 81 | 6.230000019073486 | 162 | 7 | 2.22 | 1.19 | 0 | 23 | NULL | 135 | NULL | 0.91 | NULL | NULL | NULL | 0 | 30 | 25 | 30 | 5 | CB | Costa Siciliana centro-settentrionale (Palermo) | NULL | 2021-08-31 04:14:45 | NULL | 1401 | 1 | 28137841 | 9 | 3 | 1841648141 | 94847061 | 546924421 | NULL | 100.199997 | NULL | 112 | 115 | NULL | NULL | 0.17 | NULL | 1.31 | NULL | 2021-08-31 04:14:46 | 546924421 | Z | S | Sn | 0 | 2021-08-31 04:14:33 | 550000 | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1401 | 2021-08-31 04:14:46 | 9001 |
| 28137841 | NULL | 355262 | 4028137841 | u | NULL | NULL | 1 | 1401 | 2021-08-31 04:14:35 | 1401 | hew10_mole#MOD_EQASSEMBLE | Sistema Automatico Earthworm-10 | 2019-06-13 12:47:12 | 94847061 | 2021-08-31 04:14:02 | 780000 | 38.175999 | 13.901 | 65.5 | NULL | NULL | NULL | NULL | 2.2 | 6.16 | 68.3 | 320 | 81 | 6.230000019073486 | 162 | 7 | 2.22 | 1.19 | 0 | 23 | NULL | 135 | NULL | 0.91 | NULL | NULL | NULL | 0 | 30 | 25 | 30 | 5 | CB | Costa Siciliana centro-settentrionale (Palermo) | NULL | 2021-08-31 04:14:45 | NULL | 1401 | 1 | 28137841 | 9 | 3 | 1841648151 | 94847061 | 546924431 | NULL | 101.5 | NULL | 225 | 114 | NULL | NULL | -0.83 | NULL | 0.66 | NULL | 2021-08-31 04:14:46 | 546924431 | Z | S | Sn | 2 | 2021-08-31 04:14:32 | 800000 | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1401 | 2021-08-31 04:14:46 | 2461991 |
| 28137841 | NULL | 355262 | 4028137841 | u | NULL | NULL | 1 | 1401 | 2021-08-31 04:14:35 | 1401 | hew10_mole#MOD_EQASSEMBLE | Sistema Automatico Earthworm-10 | 2019-06-13 12:47:12 | 94847061 | 2021-08-31 04:14:02 | 780000 | 38.175999 | 13.901 | 65.5 | NULL | NULL | NULL | NULL | 2.2 | 6.16 | 68.3 | 320 | 81 | 6.230000019073486 | 162 | 7 | 2.22 | 1.19 | 0 | 23 | NULL | 135 | NULL | 0.91 | NULL | NULL | NULL | 0 | 30 | 25 | 30 | 5 | CB | Costa Siciliana centro-settentrionale (Palermo) | NULL | 2021-08-31 04:14:45 | NULL | 1401 | 1 | 28137841 | 9 | 3 | 1841648161 | 94847061 | 546924441 | NULL | 105 | NULL | 253 | 113 | NULL | NULL | -1.66 | NULL | 0.66 | NULL | 2021-08-31 04:14:46 | 546924441 | Z | S | Sn | 2 | 2021-08-31 04:14:32 | 680000 | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1401 | 2021-08-31 04:14:46 | 180581 |
| 28137841 | NULL | 355262 | 4028137841 | u | NULL | NULL | 1 | 1401 | 2021-08-31 04:14:35 | 1401 | hew10_mole#MOD_EQASSEMBLE | Sistema Automatico Earthworm-10 | 2019-06-13 12:47:12 | 94847061 | 2021-08-31 04:14:02 | 780000 | 38.175999 | 13.901 | 65.5 | NULL | NULL | NULL | NULL | 2.2 | 6.16 | 68.3 | 320 | 81 | 6.230000019073486 | 162 | 7 | 2.22 | 1.19 | 0 | 23 | NULL | 135 | NULL | 0.91 | NULL | NULL | NULL | 0 | 30 | 25 | 30 | 5 | CB | Costa Siciliana centro-settentrionale (Palermo) | NULL | 2021-08-31 04:14:45 | NULL | 1401 | 1 | 28137841 | 9 | 3 | 1841648171 | 94847061 | 546924451 | NULL | 109 | NULL | 120 | 113 | NULL | NULL | 0.32 | NULL | 0.98 | NULL | 2021-08-31 04:14:46 | 546924451 | Z | S | Sn | 1 | 2021-08-31 04:14:35 | 460000 | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1401 | 2021-08-31 04:14:46 | 5609271 |
| 28137841 | NULL | 355262 | 4028137841 | u | NULL | NULL | 1 | 1401 | 2021-08-31 04:14:35 | 1401 | hew10_mole#MOD_EQASSEMBLE | Sistema Automatico Earthworm-10 | 2019-06-13 12:47:12 | 94847061 | 2021-08-31 04:14:02 | 780000 | 38.175999 | 13.901 | 65.5 | NULL | NULL | NULL | NULL | 2.2 | 6.16 | 68.3 | 320 | 81 | 6.230000019073486 | 162 | 7 | 2.22 | 1.19 | 0 | 23 | NULL | 135 | NULL | 0.91 | NULL | NULL | NULL | 0 | 30 | 25 | 30 | 5 | CB | Costa Siciliana centro-settentrionale (Palermo) | NULL | 2021-08-31 04:14:45 | NULL | 1401 | 1 | 28137841 | 9 | 3 | 1841648181 | 94847061 | 546924461 | NULL | 109.300003 | NULL | 111 | 112 | NULL | NULL | -0.42 | NULL | 0.33 | NULL | 2021-08-31 04:14:46 | 546924461 | Z | S | Sn | 3 | 2021-08-31 04:14:34 | 770000 | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1401 | 2021-08-31 04:14:46 | 1588671 |
| 28137841 | NULL | 355262 | 4028137841 | u | NULL | NULL | 1 | 1401 | 2021-08-31 04:14:35 | 1401 | hew10_mole#MOD_EQASSEMBLE | Sistema Automatico Earthworm-10 | 2019-06-13 12:47:12 | 94847061 | 2021-08-31 04:14:02 | 780000 | 38.175999 | 13.901 | 65.5 | NULL | NULL | NULL | NULL | 2.2 | 6.16 | 68.3 | 320 | 81 | 6.230000019073486 | 162 | 7 | 2.22 | 1.19 | 0 | 23 | NULL | 135 | NULL | 0.91 | NULL | NULL | NULL | 0 | 30 | 25 | 30 | 5 | CB | Costa Siciliana centro-settentrionale (Palermo) | NULL | 2021-08-31 04:14:45 | NULL | 1401 | 1 | 28137841 | 9 | 3 | 1841648191 | 94847061 | 546924471 | NULL | 109.599998 | NULL | 98 | 112 | NULL | NULL | -1.68 | NULL | 1.31 | NULL | 2021-08-31 04:14:46 | 546924471 | Z | S | Sn | 0 | 2021-08-31 04:14:33 | 590000 | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1401 | 2021-08-31 04:14:46 | 611 |
| 28137841 | NULL | 355262 | 4028137841 | u | NULL | NULL | 1 | 1401 | 2021-08-31 04:14:35 | 1401 | hew10_mole#MOD_EQASSEMBLE | Sistema Automatico Earthworm-10 | 2019-06-13 12:47:12 | 94847061 | 2021-08-31 04:14:02 | 780000 | 38.175999 | 13.901 | 65.5 | NULL | NULL | NULL | NULL | 2.2 | 6.16 | 68.3 | 320 | 81 | 6.230000019073486 | 162 | 7 | 2.22 | 1.19 | 0 | 23 | NULL | 135 | NULL | 0.91 | NULL | NULL | NULL | 0 | 30 | 25 | 30 | 5 | CB | Costa Siciliana centro-settentrionale (Palermo) | NULL | 2021-08-31 04:14:45 | NULL | 1401 | 1 | 28137841 | 9 | 3 | 1841648201 | 94847061 | 546924481 | NULL | 113.099998 | NULL | 177 | 112 | NULL | NULL | -0.51 | NULL | 1.31 | NULL | 2021-08-31 04:14:46 | 546924481 | Z | S | Sn | 0 | 2021-08-31 04:14:35 | 470000 | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1401 | 2021-08-31 04:14:46 | 6991 |
+----------+-------------+------------+----------------+---------+-------------+-----------------+---------------+-----------+---------------------+------+---------------------------+---------------------------------+---------------------+----------+---------------------+--------+-----------+--------+-------+--------+---------+---------+-----------+-------+-------+----------------+-------+--------+-------------------+-------+--------+------+------+-----------+--------------+--------------+----------+--------------+------+-------+----------------+----------------+-------------+------+-------+---------+--------+---------+-------------------------------------------------+----------+---------------------+---------+-----------+------------+----------+----------+----------------+------------+---------------+-----------+--------+-------------+--------------+--------+----------+------------------+------------------+----------+-----------------+--------+-----------+---------------------+-----------+----------+------------+----------+--------+---------------------+--------+------------------+-------------+---------+------+---------+---------+---------+---------+---------+---------+--------+--------+--------+--------+--------+--------+-----------+---------------------+---------+
30 rows in set (0.005 sec)
MySQL [seisev]>
questa una bozza di query per quakedb:
SELECT
*
FROM
event e
JOIN origin o ON o.fk_event = e.id
JOIN arrival a ON a.fk_origin = o.id
JOIN pick p ON a.fk_pick = p.id
JOIN localspace l ON e.fk_localspace = l.id
JOIN type_origin tyo ON o.fk_type_origin = tyo.id
WHERE
e.id_localspace = 355262
AND l.name LIKE 'hew10%'
AND tyo.value = 1
id fk_event_group type_group fk_type_event fk_localspace id_localspace fk_origin_preferred fk_magnitude_preferred fk_focalmechanism_preferred fk_provenance modified inserted id ot depth geom err_ot err_lat err_lon err_depth err_h err_z confidence_level e0_az e0_dip e0 e1_az e1_dip e1 e2_az e2_dip e2 fix_depth min_distance med_distance max_distance azim_gap sec_azim_gap rms w_rms is_centroid nph nph_s nph_tot nph_fm quality quality_numeric modified inserted fk_provenance fk_localspace id_localspace fk_type_origin fk_event id isc_code fk_origin fk_pick ep_distance_km ep_distance_delta orig_distance azimut take_off polarity_is_used arr_time_is_used residual weight modified inserted id quality_class arrival_time lower_uncertainty upper_uncertainty confidence_level firstmotion emersio fk_provenance fk_localspace id_localspacemodified inserted fk_scnl id name description modified inserted id value name description priority modified inserted
27672408 27672425 0 1 321 355262 91345067 97485178 3401 2021-08-31 04:17:41.820867 2021-08-31 04:14:28.416 91345025 2021-08-31 04:14:02.78 65.5 SRID=4326;POINT(13.901 38.175999) 2.2 6.16 68.30 320 81 6.23 162 7 2.22 1.19 f 23 135 0.91 030 25 30 5 CB 2021-08-31 04:14:46.552 2021-08-31 04:14:46.552 3451 321 1002 27672408 1770656705 P 91345025 747209292 23.4 151 157 0.56 1.31 2021-08-31 04:14:46 2021-08-31 04:14:46 747209292 0 2021-08-31 04:14:13.63 D 3451 321 2021-08-31 04:14:36.601 2021-08-31 04:14:36.601 547 321 hew10_mole Sistema Automatico Earthworm-10 2021-04-08 15:31:38 2021-04-08 15:31:38 1002 1 ew rapid Earthworm RapidRule 1 2021-04-08 15:31:40 2021-04-08 15:31:40
27672408 27672425 0 1 321 355262 91345067 97485178 3401 2021-08-31 04:17:41.820867 2021-08-31 04:14:28.416 91345025 2021-08-31 04:14:02.78 65.5 SRID=4326;POINT(13.901 38.175999) 2.2 6.16 68.30 320 81 6.23 162 7 2.22 1.19 f 23 135 0.91 030 25 30 5 CB 2021-08-31 04:14:46.552 2021-08-31 04:14:46.552 3451 321 1002 27672408 1770656706 P 91345025 747209293 29.3 208 152 1.19 0.33 2021-08-31 04:14:46 2021-08-31 04:14:46 747209293 3 2021-08-31 04:14:14.57 U 3451 321 2021-08-31 04:14:36.615 2021-08-31 04:14:36.615 1421641 321 hew10_mole Sistema Automatico Earthworm-10 2021-04-08 15:31:38 2021-04-08 15:31:38 1002 1 ew rapid Earthworm RapidRule 1 2021-04-08 15:31:40 2021-04-08 15:31:40
27672408 27672425 0 1 321 355262 91345067 97485178 3401 2021-08-31 04:17:41.820867 2021-08-31 04:14:28.416 91345025 2021-08-31 04:14:02.78 65.5 SRID=4326;POINT(13.901 38.175999) 2.2 6.16 68.30 320 81 6.23 162 7 2.22 1.19 f 23 135 0.91 030 25 30 5 CB 2021-08-31 04:14:46.552 2021-08-31 04:14:46.552 3451 321 1002 27672408 1770656708 P 91345025 747209294 29.8 152 151 0.95 0.98 2021-08-31 04:14:46 2021-08-31 04:14:46 747209294 1 2021-08-31 04:14:14.36 D 3451 321 2021-08-31 04:14:36.628 2021-08-31 04:14:36.628 49791 321 hew10_mole Sistema Automatico Earthworm-10 2021-04-08 15:31:38 2021-04-08 15:31:38 1002 1 ew rapid Earthworm RapidRule 1 2021-04-08 15:31:40 2021-04-08 15:31:40
27672408 27672425 0 1 321 355262 91345067 97485178 3401 2021-08-31 04:17:41.820867 2021-08-31 04:14:28.416 91345025 2021-08-31 04:14:02.78 65.5 SRID=4326;POINT(13.901 38.175999) 2.2 6.16 68.30 320 81 6.23 162 7 2.22 1.19 f 23 135 0.91 030 25 30 5 CB 2021-08-31 04:14:46.552 2021-08-31 04:14:46.552 3451 321 1002 27672408 1770656707 P 91345025 747209295 29.4 133 151 1.51 0.66 2021-08-31 04:14:46 2021-08-31 04:14:46 747209295 2 2021-08-31 04:14:14.9 D 3451 321 2021-08-31 04:14:36.64 2021-08-31 04:14:36.64 51151 321 hew10_mole Sistema Automatico Earthworm-10 2021-04-08 15:31:38 2021-04-08 15:31:38 1002 1 ew rapid Earthworm RapidRule 1 2021-04-08 15:31:40 2021-04-08 15:31:40
27672408 27672425 0 1 321 355262 91345067 97485178 3401 2021-08-31 04:17:41.820867 2021-08-31 04:14:28.416 91345025 2021-08-31 04:14:02.78 65.5 SRID=4326;POINT(13.901 38.175999) 2.2 6.16 68.30 320 81 6.23 162 7 2.22 1.19 f 23 135 0.91 030 25 30 5 CB 2021-08-31 04:14:46.552 2021-08-31 04:14:46.552 3451 321 1002 27672408 1770656709 P 91345025 747209296 33.6 255 148 2.49 0.16 2021-08-31 04:14:46 2021-08-31 04:14:46 747209296 3 2021-08-31 04:14:16.14 D 3451 321 2021-08-31 04:14:36.652 2021-08-31 04:14:36.652 537 321 hew10_mole Sistema Automatico Earthworm-10 2021-04-08 15:31:38 2021-04-08 15:31:38 1002 1 ew rapid Earthworm RapidRule 1 2021-04-08 15:31:40 2021-04-08 15:31:40%
@matteo.quintiliani potrebbe essere un problema di ew2openapi?