Data Report
Bulletin /
Contributed by DMN
hypid | isc_evid | author | lat | lon | prime
-----------+-----------+--------+----------+-----------+-------
600223617 | 600131621 | IDC | 27.61100 | 87.72990 | P
BEGIN WORK;
INSERT INTO report (repid,reporter,status,dirname,collector,product,filename) VALUES (600214973,'DMN',98,'DMN','james','Bulletin','201112_special.txt');
INSERT INTO hypocenter (day,msec, lat, lon, depth, author, reporter, lddate, hypid, pref_hypid, isc_evid )
VALUES ('2011-12-30 06:14:26', 820, 28.25, 87.76, 92.42, 'DMN', 600214973 , NOW(), 603981793,603981793, 600131621 );
INSERT INTO netmag (hypid,magid,magnitude,magtype,reporter,lddate,author)
VALUES (603981793,605093604,4.25,'M1',600214973,NOW(),'DMN');
INSERT INTO phase ( sta,phase,day,msec,phid,rdid,pref_rd, author,reporter, lddate ) VALUES ('TAPN', 'Pg', '2011-12-30 06:14:47', 300, 678221230, 643877922, 643877922, 'DMN', 600214973, NOW() );
INSERT INTO phase ( sta,phase,day,msec,phid,rdid,pref_rd, author,reporter, lddate ) VALUES ('TAPN', 'Sg', '2011-12-30 06:15:02', 200, 678221231, 643877922, 643877922, 'DMN', 600214973, NOW() );
INSERT INTO phase ( sta,phase,day,msec,phid,rdid,pref_rd, author,reporter, lddate ) VALUES ('ODAN', 'Pg', '2011-12-30 06:14:53', 700, 678221232, 643877923, 643877923, 'DMN', 600214973, NOW() );
INSERT INTO phase ( sta,phase,day,msec,phid,rdid,pref_rd, author,reporter, lddate ) VALUES ('ODAN', 'Sg', '2011-12-30 06:15:12', 500, 678221233, 643877923, 643877923, 'DMN', 600214973, NOW() );
INSERT INTO phase ( sta,phase,day,msec,phid,rdid,pref_rd, author,reporter, lddate ) VALUES ('JIRN', 'Pg', '2011-12-30 06:14:54', 800, 678221234, 643877924, 643877924, 'DMN', 600214973, NOW() );
INSERT INTO phase ( sta,phase,day,msec,phid,rdid,pref_rd, author,reporter, lddate ) VALUES ('RAMN', 'Pg', '2011-12-30 06:14:56', 100, 678221235, 643877925, 643877925, 'DMN', 600214973, NOW() );
INSERT INTO phase ( sta,phase,day,msec,phid,rdid,pref_rd, author,reporter, lddate ) VALUES ('RAMN', 'Sg', '2011-12-30 06:15:17', 100, 678221236, 643877925, 643877925, 'DMN', 600214973, NOW() );
INSERT INTO phase ( sta,phase,day,msec,phid,rdid,pref_rd, author,reporter, lddate ) VALUES ('GUN', 'Pg', '2011-12-30 06:14:57', 000, 678221237, 643877926, 643877926, 'DMN', 600214973, NOW() );
INSERT INTO phase ( sta,phase,day,msec,phid,rdid,pref_rd, author,reporter, lddate ) VALUES ('GUN', 'Sg', '2011-12-30 06:15:18', 600, 678221238, 643877926, 643877926, 'DMN', 600214973, NOW() );
INSERT INTO phase ( sta,phase,day,msec,phid,rdid,pref_rd, author,reporter, lddate ) VALUES ('PKI', 'Pg', '2011-12-30 06:15:03', 400, 678221239, 643877927, 643877927, 'DMN', 600214973, NOW() );
INSERT INTO phase ( sta,phase,day,msec,phid,rdid,pref_rd, author,reporter, lddate ) VALUES ('PKI', 'Sn', '2011-12-30 06:15:29', 700, 678221240, 643877927, 643877927, 'DMN', 600214973, NOW() );
INSERT INTO phase ( sta,phase,day,msec,phid,rdid,pref_rd, author,reporter, lddate ) VALUES ('KKN', 'Pn', '2011-12-30 06:15:03', 900, 678221241, 643877928, 643877928, 'DMN', 600214973, NOW() );
INSERT INTO phase ( sta,phase,day,msec,phid,rdid,pref_rd, author,reporter, lddate ) VALUES ('KKN', 'Sn', '2011-12-30 06:15:29', 900, 678221242, 643877928, 643877928, 'DMN', 600214973, NOW() );
INSERT INTO phase ( sta,phase,day,msec,phid,rdid,pref_rd, author,reporter, lddate ) VALUES ('DMN', 'Pg', '2011-12-30 06:15:06', 570, 678221243, 643877929, 643877929, 'DMN', 600214973, NOW() );
INSERT INTO phase ( sta,phase,day,msec,phid,rdid,pref_rd, author,reporter, lddate ) VALUES ('DMN', 'Sn', '2011-12-30 06:15:35', 100, 678221244, 643877929, 643877929, 'DMN', 600214973, NOW() );
INSERT INTO phase ( sta,phase,day,msec,phid,rdid,pref_rd, author,reporter, lddate ) VALUES ('GKN', 'Pn', '2011-12-30 06:15:09', 900, 678221245, 643877930, 643877930, 'DMN', 600214973, NOW() );
INSERT INTO phase ( sta,phase,day,msec,phid,rdid,pref_rd, author,reporter, lddate ) VALUES ('KOLN', 'Pn', '2011-12-30 06:15:22', 100, 678221246, 643877931, 643877931, 'DMN', 600214973, NOW() );
INSERT INTO phase ( sta,phase,day,msec,phid,rdid,pref_rd, author,reporter, lddate ) VALUES ('KOLN', 'Sn', '2011-12-30 06:16:03', 200, 678221247, 643877931, 643877931, 'DMN', 600214973, NOW() );
INSERT INTO phase ( sta,phase,day,msec,phid,rdid,pref_rd, author,reporter, lddate ) VALUES ('PYUN', 'Pn', '2011-12-30 06:15:28', 580, 678221248, 643877932, 643877932, 'DMN', 600214973, NOW() );
INSERT INTO phase ( sta,phase,day,msec,phid,rdid,pref_rd, author,reporter, lddate ) VALUES ('PYUN', 'Sn', '2011-12-30 06:16:15', 660, 678221249, 643877932, 643877932, 'DMN', 600214973, NOW() );
INSERT INTO phase ( sta,phase,day,msec,phid,rdid,pref_rd, author,reporter, lddate ) VALUES ('HARN', 'Pn', '2011-12-30 06:15:44', 400, 678221250, 643877933, 643877933, 'DMN', 600214973, NOW() );
INSERT INTO phase ( sta,phase,day,msec,phid,rdid,pref_rd, author,reporter, lddate ) VALUES ('HARN', 'Sn', '2011-12-30 06:16:42', 750, 678221251, 643877933, 643877933, 'DMN', 600214973, NOW() );
INSERT INTO phase ( sta,phase,day,msec,phid,rdid,pref_rd, author,reporter, lddate ) VALUES ('PUSN', 'Pn', '2011-12-30 06:15:49', 200, 678221252, 643877934, 643877934, 'DMN', 600214973, NOW() );
INSERT INTO phase ( sta,phase,day,msec,phid,rdid,pref_rd, author,reporter, lddate ) VALUES ('PUSN', 'Sn', '2011-12-30 06:16:51', 500, 678221253, 643877934, 643877934, 'DMN', 600214973, NOW() );
INSERT INTO phase ( sta,phase,day,msec,phid,rdid,pref_rd, author,reporter, lddate ) VALUES ('BADN', 'Pn', '2011-12-30 06:15:50', 300, 678221254, 643877935, 643877935, 'DMN', 600214973, NOW() );
INSERT INTO phase ( sta,phase,day,msec,phid,rdid,pref_rd, author,reporter, lddate ) VALUES ('BADN', 'Sn', '2011-12-30 06:16:53', 300, 678221255, 643877935, 643877935, 'DMN', 600214973, NOW() );
INSERT INTO phase ( sta,phase,day,msec,phid,rdid,pref_rd, author,reporter, lddate ) VALUES ('BAYN', 'Pn', '2011-12-30 06:15:51', 400, 678221256, 643877936, 643877936, 'DMN', 600214973, NOW() );
INSERT INTO phase ( sta,phase,day,msec,phid,rdid,pref_rd, author,reporter, lddate ) VALUES ('BAYN', 'Sn', '2011-12-30 06:16:55', 000, 678221257, 643877936, 643877936, 'DMN', 600214973, NOW() );
INSERT INTO phase ( sta,phase,day,msec,phid,rdid,pref_rd, author,reporter, lddate ) VALUES ('GJRN', 'Pn', '2011-12-30 06:15:57', 000, 678221258, 643877937, 643877937, 'DMN', 600214973, NOW() );
INSERT INTO phase ( sta,phase,day,msec,phid,rdid,pref_rd, author,reporter, lddate ) VALUES ('GJRN', 'Sn', '2011-12-30 06:17:04', 130, 678221259, 643877937, 643877937, 'DMN', 600214973, NOW() );
--
----
--
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('TAPN', 'Pg', 678221230, 'DMN', 600214973, NOW(), 603981793 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('TAPN', 'Sg', 678221231, 'DMN', 600214973, NOW(), 603981793 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('ODAN', 'Pg', 678221232, 'DMN', 600214973, NOW(), 603981793 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('ODAN', 'Sg', 678221233, 'DMN', 600214973, NOW(), 603981793 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('JIRN', 'Pg', 678221234, 'DMN', 600214973, NOW(), 603981793 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('RAMN', 'Pg', 678221235, 'DMN', 600214973, NOW(), 603981793 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('RAMN', 'Sg', 678221236, 'DMN', 600214973, NOW(), 603981793 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('GUN', 'Pg', 678221237, 'DMN', 600214973, NOW(), 603981793 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('GUN', 'Sg', 678221238, 'DMN', 600214973, NOW(), 603981793 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('PKI', 'Pg', 678221239, 'DMN', 600214973, NOW(), 603981793 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('PKI', 'Sn', 678221240, 'DMN', 600214973, NOW(), 603981793 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('KKN', 'Pn', 678221241, 'DMN', 600214973, NOW(), 603981793 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('KKN', 'Sn', 678221242, 'DMN', 600214973, NOW(), 603981793 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('DMN', 'Pg', 678221243, 'DMN', 600214973, NOW(), 603981793 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('DMN', 'Sn', 678221244, 'DMN', 600214973, NOW(), 603981793 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('GKN', 'Pn', 678221245, 'DMN', 600214973, NOW(), 603981793 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('KOLN', 'Pn', 678221246, 'DMN', 600214973, NOW(), 603981793 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('KOLN', 'Sn', 678221247, 'DMN', 600214973, NOW(), 603981793 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('PYUN', 'Pn', 678221248, 'DMN', 600214973, NOW(), 603981793 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('PYUN', 'Sn', 678221249, 'DMN', 600214973, NOW(), 603981793 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('HARN', 'Pn', 678221250, 'DMN', 600214973, NOW(), 603981793 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('HARN', 'Sn', 678221251, 'DMN', 600214973, NOW(), 603981793 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('PUSN', 'Pn', 678221252, 'DMN', 600214973, NOW(), 603981793 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('PUSN', 'Sn', 678221253, 'DMN', 600214973, NOW(), 603981793 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('BADN', 'Pn', 678221254, 'DMN', 600214973, NOW(), 603981793 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('BADN', 'Sn', 678221255, 'DMN', 600214973, NOW(), 603981793 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('BAYN', 'Pn', 678221256, 'DMN', 600214973, NOW(), 603981793 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('BAYN', 'Sn', 678221257, 'DMN', 600214973, NOW(), 603981793 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('GJRN', 'Pn', 678221258, 'DMN', 600214973, NOW(), 603981793 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('GJRN', 'Sn', 678221259, 'DMN', 600214973, NOW(), 603981793 );
--
----
--
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('TAPN', 'Pg', 678221230, 'ISC', 600214973, NOW(), 600223617 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('TAPN', 'Sg', 678221231, 'ISC', 600214973, NOW(), 600223617 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('ODAN', 'Pg', 678221232, 'ISC', 600214973, NOW(), 600223617 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('ODAN', 'Sg', 678221233, 'ISC', 600214973, NOW(), 600223617 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('JIRN', 'Pg', 678221234, 'ISC', 600214973, NOW(), 600223617 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('RAMN', 'Pg', 678221235, 'ISC', 600214973, NOW(), 600223617 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('RAMN', 'Sg', 678221236, 'ISC', 600214973, NOW(), 600223617 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('GUN', 'Pg', 678221237, 'ISC', 600214973, NOW(), 600223617 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('GUN', 'Sg', 678221238, 'ISC', 600214973, NOW(), 600223617 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('PKI', 'Pg', 678221239, 'ISC', 600214973, NOW(), 600223617 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('PKI', 'Sn', 678221240, 'ISC', 600214973, NOW(), 600223617 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('KKN', 'Pn', 678221241, 'ISC', 600214973, NOW(), 600223617 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('KKN', 'Sn', 678221242, 'ISC', 600214973, NOW(), 600223617 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('DMN', 'Pg', 678221243, 'ISC', 600214973, NOW(), 600223617 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('DMN', 'Sn', 678221244, 'ISC', 600214973, NOW(), 600223617 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('GKN', 'Pn', 678221245, 'ISC', 600214973, NOW(), 600223617 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('KOLN', 'Pn', 678221246, 'ISC', 600214973, NOW(), 600223617 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('KOLN', 'Sn', 678221247, 'ISC', 600214973, NOW(), 600223617 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('PYUN', 'Pn', 678221248, 'ISC', 600214973, NOW(), 600223617 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('PYUN', 'Sn', 678221249, 'ISC', 600214973, NOW(), 600223617 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('HARN', 'Pn', 678221250, 'ISC', 600214973, NOW(), 600223617 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('HARN', 'Sn', 678221251, 'ISC', 600214973, NOW(), 600223617 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('PUSN', 'Pn', 678221252, 'ISC', 600214973, NOW(), 600223617 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('PUSN', 'Sn', 678221253, 'ISC', 600214973, NOW(), 600223617 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('BADN', 'Pn', 678221254, 'ISC', 600214973, NOW(), 600223617 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('BADN', 'Sn', 678221255, 'ISC', 600214973, NOW(), 600223617 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('BAYN', 'Pn', 678221256, 'ISC', 600214973, NOW(), 600223617 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('BAYN', 'Sn', 678221257, 'ISC', 600214973, NOW(), 600223617 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('GJRN', 'Pn', 678221258, 'ISC', 600214973, NOW(), 600223617 );
INSERT INTO association ( sta,phase,phid, author,reporter, lddate, hypid ) VALUES ('GJRN', 'Sn', 678221259, 'ISC', 600214973, NOW(), 600223617 );