Event Index
Here we list seismic events in the Event Bibliography sorted by event origin time. For older events click on the time windows below. For many relevant events the code, chosen from the scientific literature, is also listed to help users to identify a particular known event. For example, TOHOKU2011 is the code for the great Tohoku earthquake of 11 March, 2011.
To search, click on the appropriate ISC event.
| ISC event | Agency | Origin Time | Lat | Lon | Depth | Magn | N | Event code |
execute();
while ($evid = $query1->fetch()) {
array_push($evidall, $evid[0]);
}
foreach ($evidall as $evid) {
# print ("$result1[0] $result1[5] ");
$sq = $db_conn->prepare("SELECT h.isc_evid,h.day,h.lat,h.lon,h.grn,e.etype,h.author,h.depth
FROM isc.hypocenter h, isc.event e
WHERE e.evid = h.isc_evid
AND h.hypid = h.pref_hypid
AND h.hypid = e.prime_hyp
AND e.evid = $evid");
$sq->execute();
$result1 = $sq->fetch();
$sqbibid = $db_conn->prepare("SELECT count(bibid)
FROM isc.biblio_event
WHERE evid = $evid");
$sqbibid->execute();
$countbib = $sqbibid->fetch();
$sqcode = $db_conn->prepare("SELECT COALESCE(code,'')
FROM isc.biblio_event_code
WHERE evid = $evid");
$sqcode->execute();
$code = $sqcode->fetch();
$query2 = $db_conn->prepare("SELECT COALESCE(n.author,'UK'),COALESCE(n.magnitude,-9.9),COALESCE(n.magtype,'UK')
FROM isc.netmag n, isc.hypocenter h
WHERE h.hypid = h.pref_hypid
AND n.hypid = h.hypid
AND h.isc_evid = $evid
AND ( h.deprecated is NULL OR h.deprecated = 'P' )
AND ( n.deprecated is NULL OR n.deprecated = 'M' )
AND (n.magtype not like '%tmp' and n.magtype not like '%mx' and n.magtype not like '%1' and upper(n.magtype) not like 'ME%' OR n.magtype is null)
AND n.author not in ('ISCJB','EIDC','ISC1','DJA','ERE','BKK','ISCJB')
ORDER BY (case n.author when 'GCMT' then 0
when 'HRVD' then 1
when 'HRV' then 2
when 'ISC' then 3
when 'NEIC' then 4
when 'NEIS' then 5
when 'USGS' then 6
when 'IDC' then 7
when 'MOS' then 8
when 'CSEM' then 9
else 10
end) limit 1");
$query2->execute();
$result2 = $query2->fetch();
#if (strlen($result2[1]) == 0) {
# $result2[1] = "";
#}
#if ($result2[2] == "MW") {
# $result2[2] = "Mw";
#}
#if ($result2[2] == "MS") {
# $result2[2] = "Ms";
#}
#if (strlen($result2[0]) == 0) {
# $result2[0] = "";
#} else {
# $result2[0] = ("($result2[0]) =");
#}
$result2[1] = number_format($result2[1], 1);
$result1[2] = number_format($result1[2], 2);
$result1[3] = number_format($result1[3], 2);
$result1[7] = number_format($result1[7], 1);
$query3 = $db_conn->prepare("SELECT b.bibid,b.title,COALESCE(journal,series),coalesce(year,9999),coalesce(volume,''),coalesce(issue,''),coalesce(page1,''),coalesce(page2,''),coalesce(doi,'')
FROM isc.bibliography b, isc.biblio_event e FULL JOIN isc.biblio_event_code c ON e.evid = c.evid
WHERE e.bibid = b.bibid
AND c.evid = '$evid'
ORDER BY b.year desc");
$query3->execute();
#
# 1 2 3 4 5 6 7 8
#SELECT h.isc_evid,h.day,h.lat,h.lon,h.grn,e.etype,h.author,h.depth
printf("| $result1[0] | $result1[6] | $result1[1] | $result1[2] | $result1[3] | $result1[7] | $result2[1] | $countbib[0] | $code[0] |
");
}
?>