[data-issues] channel ends after station ends
Philip Crotwell
crotwell at seis.sc.edu
Tue May 9 14:08:19 PDT 2006
Hi Rick and Tim
Here is another one. In the station table for CN.YKW3, there are 2
stations, one from 1989 to 2005 and one from 2005 to the future. But
in the channel table, all of the channels go from 1989 to the future.
So, the channel's effective time actually covers 2 station effective
times. This same problem seems to effect several CN stations. It has
the appearance of the station metadata being updated without the
channels being correspondingly changed.
Sue, I believe this is the cause of the dhi issue here:
http://www.iris.edu/jira/browse/DHI-13
Here is seismoquery to illustrate:
sselect channel.network, channel.station, channel.location,
channel.channel, channel.starttime, channel.endtime,
station.starttime, station.endtime FROM station , channel WHERE
channel.network = station.network AND channel.station =
station.station AND ((channel.starttime < station.starttime AND
channel.endtime > station.starttime) OR (channel.starttime <
station.endtime AND channel.endtime > station.endtime)) AND
channel.network='CN' ;
Tue May 9 14:05:07 PDT 2006
NETWORK STATION LOCATION CHANNEL STARTTIME ENDTIME STARTTIME
ENDTIME
CN FRB BHE 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN FRB BHE 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1992-06-03 00:00:00.0 1995-08-31 00:00:00.0
CN FRB BHN 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN FRB BHN 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1992-06-03 00:00:00.0 1995-08-31 00:00:00.0
CN FRB BHZ 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN FRB BHZ 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1992-06-03 00:00:00.0 1995-08-31 00:00:00.0
CN FRB LHE 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN FRB LHE 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1992-06-03 00:00:00.0 1995-08-31 00:00:00.0
CN FRB LHN 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN FRB LHN 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1992-06-03 00:00:00.0 1995-08-31 00:00:00.0
CN FRB LHZ 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN FRB LHZ 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1992-06-03 00:00:00.0 1995-08-31 00:00:00.0
CN INK LHE 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1992-06-03 15:00:00.0 2599-12-31 23:59:59.0
CN INK LHN 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1992-06-03 15:00:00.0 2599-12-31 23:59:59.0
CN INK LHZ 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1992-06-03 15:00:00.0 2599-12-31 23:59:59.0
CN LLLB LHE 1998-11-17 00:00:00.0 2599-12-31 23:59:59.0
1998-11-17 21:30:00.0 2599-12-31 23:59:59.0
CN LLLB LHN 1998-11-17 00:00:00.0 2599-12-31 23:59:59.0
1998-11-17 21:30:00.0 2599-12-31 23:59:59.0
CN LLLB LHZ 1998-11-17 00:00:00.0 2599-12-31 23:59:59.0
1998-11-17 21:30:00.0 2599-12-31 23:59:59.0
CN WHY BHE 1993-08-27 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN WHY BHE 1993-08-27 00:00:00.0 2599-12-31 23:59:59.0
1993-08-27 00:00:00.0 1995-08-31 00:00:00.0
CN WHY BHN 1993-08-27 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN WHY BHN 1993-08-27 00:00:00.0 2599-12-31 23:59:59.0
1993-08-27 00:00:00.0 1995-08-31 00:00:00.0
CN WHY BHZ 1993-08-27 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN WHY BHZ 1993-08-27 00:00:00.0 2599-12-31 23:59:59.0
1993-08-27 00:00:00.0 1995-08-31 00:00:00.0
CN WHY LHE 1993-08-27 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN WHY LHE 1993-08-27 00:00:00.0 2599-12-31 23:59:59.0
1993-08-27 00:00:00.0 1995-08-31 00:00:00.0
CN WHY LHN 1993-08-27 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN WHY LHN 1993-08-27 00:00:00.0 2599-12-31 23:59:59.0
1993-08-27 00:00:00.0 1995-08-31 00:00:00.0
CN WHY LHZ 1993-08-27 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN WHY LHZ 1993-08-27 00:00:00.0 2599-12-31 23:59:59.0
1993-08-27 00:00:00.0 1995-08-31 00:00:00.0
CN DRLN BHE 1993-12-14 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN DRLN BHE 1993-12-14 00:00:00.0 2599-12-31 23:59:59.0
1993-12-14 00:00:00.0 1995-08-31 00:00:00.0
CN DRLN BHN 1993-12-14 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN DRLN BHN 1993-12-14 00:00:00.0 2599-12-31 23:59:59.0
1993-12-14 00:00:00.0 1995-08-31 00:00:00.0
CN DRLN BHZ 1993-12-14 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN DRLN BHZ 1993-12-14 00:00:00.0 2599-12-31 23:59:59.0
1993-12-14 00:00:00.0 1995-08-31 00:00:00.0
CN DRLN LHE 1993-12-14 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN DRLN LHE 1993-12-14 00:00:00.0 2599-12-31 23:59:59.0
1993-12-14 00:00:00.0 1995-08-31 00:00:00.0
CN DRLN LHN 1993-12-14 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN DRLN LHN 1993-12-14 00:00:00.0 2599-12-31 23:59:59.0
1993-12-14 00:00:00.0 1995-08-31 00:00:00.0
CN DRLN LHZ 1993-12-14 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN DRLN LHZ 1993-12-14 00:00:00.0 2599-12-31 23:59:59.0
1993-12-14 00:00:00.0 1995-08-31 00:00:00.0
CN GAC BHE 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN GAC BHE 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1992-06-03 00:00:00.0 1995-08-31 00:00:00.0
CN GAC BHN 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN GAC BHN 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1992-06-03 00:00:00.0 1995-08-31 00:00:00.0
CN GAC BHZ 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN GAC BHZ 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1992-06-03 00:00:00.0 1995-08-31 00:00:00.0
CN GAC EHZ 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN GAC EHZ 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1992-06-03 00:00:00.0 1995-08-31 00:00:00.0
CN RES BHE 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN RES BHE 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1992-06-03 00:00:00.0 1995-08-31 00:00:00.0
CN RES BHN 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN RES BHN 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1992-06-03 00:00:00.0 1995-08-31 00:00:00.0
CN RES BHZ 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN RES BHZ 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1992-06-03 00:00:00.0 1995-08-31 00:00:00.0
CN RES LHE 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN RES LHE 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1992-06-03 00:00:00.0 1995-08-31 00:00:00.0
CN RES LHN 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN RES LHN 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1992-06-03 00:00:00.0 1995-08-31 00:00:00.0
CN RES LHZ 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN RES LHZ 1992-06-03 00:00:00.0 2599-12-31 23:59:59.0
1992-06-03 00:00:00.0 1995-08-31 00:00:00.0
CN MBC BHE 1992-08-29 00:00:00.0 2599-12-31 23:59:59.0
1995-09-01 00:00:00.0 2599-12-31 23:59:59.0
CN MBC BHE 1992-08-29 00:00:00.0 2599-12-31 23:59:59.0
1992-08-29 00:00:00.0 1995-09-01 00:00:00.0
CN MBC BHN 1992-08-29 00:00:00.0 2599-12-31 23:59:59.0
1995-09-01 00:00:00.0 2599-12-31 23:59:59.0
CN MBC BHN 1992-08-29 00:00:00.0 2599-12-31 23:59:59.0
1992-08-29 00:00:00.0 1995-09-01 00:00:00.0
CN MBC BHZ 1992-08-29 00:00:00.0 2599-12-31 23:59:59.0
1995-09-01 00:00:00.0 2599-12-31 23:59:59.0
CN MBC BHZ 1992-08-29 00:00:00.0 2599-12-31 23:59:59.0
1992-08-29 00:00:00.0 1995-09-01 00:00:00.0
CN YKW1 LHE 1994-09-01 18:05:00.0 2599-12-31 23:59:59.0
1995-09-01 00:00:00.0 2599-12-31 23:59:59.0
CN YKW1 LHE 1994-09-01 18:05:00.0 2599-12-31 23:59:59.0
1989-01-25 00:00:00.0 1995-09-01 00:00:00.0
CN YKW1 LHN 1994-09-01 18:05:00.0 2599-12-31 23:59:59.0
1995-09-01 00:00:00.0 2599-12-31 23:59:59.0
CN YKW1 LHN 1994-09-01 18:05:00.0 2599-12-31 23:59:59.0
1989-01-25 00:00:00.0 1995-09-01 00:00:00.0
CN YKW1 LHZ 1994-09-01 18:05:00.0 2599-12-31 23:59:59.0
1995-09-01 00:00:00.0 2599-12-31 23:59:59.0
CN YKW1 LHZ 1994-09-01 18:05:00.0 2599-12-31 23:59:59.0
1989-01-25 00:00:00.0 1995-09-01 00:00:00.0
CN YKW3 BHE 1989-01-25 00:00:00.0 2599-12-31 23:59:59.0
1995-09-01 00:00:00.0 2599-12-31 23:59:59.0
CN YKW3 BHE 1989-01-25 00:00:00.0 2599-12-31 23:59:59.0
1989-01-25 00:00:00.0 1995-09-01 00:00:00.0
CN YKW3 BHN 1989-01-25 00:00:00.0 2599-12-31 23:59:59.0
1995-09-01 00:00:00.0 2599-12-31 23:59:59.0
CN YKW3 BHN 1989-01-25 00:00:00.0 2599-12-31 23:59:59.0
1989-01-25 00:00:00.0 1995-09-01 00:00:00.0
CN YKW3 BHZ 1989-01-25 00:00:00.0 2599-12-31 23:59:59.0
1995-09-01 00:00:00.0 2599-12-31 23:59:59.0
CN YKW3 BHZ 1989-01-25 00:00:00.0 2599-12-31 23:59:59.0
1989-01-25 00:00:00.0 1995-09-01 00:00:00.0
CN YKW3 EHE 1989-01-25 00:01:00.0 2599-12-31 23:59:59.0
1995-09-01 00:00:00.0 2599-12-31 23:59:59.0
CN YKW3 EHE 1989-01-25 00:01:00.0 2599-12-31 23:59:59.0
1989-01-25 00:00:00.0 1995-09-01 00:00:00.0
CN YKW3 EHN 1989-01-25 00:01:00.0 2599-12-31 23:59:59.0
1995-09-01 00:00:00.0 2599-12-31 23:59:59.0
CN YKW3 EHN 1989-01-25 00:01:00.0 2599-12-31 23:59:59.0
1989-01-25 00:00:00.0 1995-09-01 00:00:00.0
CN YKW3 EHZ 1989-01-25 00:01:00.0 2599-12-31 23:59:59.0
1995-09-01 00:00:00.0 2599-12-31 23:59:59.0
CN YKW3 EHZ 1989-01-25 00:01:00.0 2599-12-31 23:59:59.0
1989-01-25 00:00:00.0 1995-09-01 00:00:00.0
CN YKW3 LHE 1994-09-20 00:00:00.0 2599-12-31 23:59:59.0
1995-09-01 00:00:00.0 2599-12-31 23:59:59.0
CN YKW3 LHE 1994-09-20 00:00:00.0 2599-12-31 23:59:59.0
1989-01-25 00:00:00.0 1995-09-01 00:00:00.0
CN YKW3 LHN 1994-09-20 00:00:00.0 2599-12-31 23:59:59.0
1995-09-01 00:00:00.0 2599-12-31 23:59:59.0
CN YKW3 LHN 1994-09-20 00:00:00.0 2599-12-31 23:59:59.0
1989-01-25 00:00:00.0 1995-09-01 00:00:00.0
CN YKW3 LHZ 1994-09-20 00:00:00.0 2599-12-31 23:59:59.0
1995-09-01 00:00:00.0 2599-12-31 23:59:59.0
CN YKW3 LHZ 1994-09-20 00:00:00.0 2599-12-31 23:59:59.0
1989-01-25 00:00:00.0 1995-09-01 00:00:00.0
CN SCHQ BHE 1994-12-22 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN SCHQ BHE 1994-12-22 00:00:00.0 2599-12-31 23:59:59.0
1994-12-22 00:00:00.0 1995-08-31 00:00:00.0
CN SCHQ BHN 1994-12-22 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN SCHQ BHN 1994-12-22 00:00:00.0 2599-12-31 23:59:59.0
1994-12-22 00:00:00.0 1995-08-31 00:00:00.0
CN SCHQ BHZ 1994-12-22 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN SCHQ BHZ 1994-12-22 00:00:00.0 2599-12-31 23:59:59.0
1994-12-22 00:00:00.0 1995-08-31 00:00:00.0
CN SCHQ LHE 1994-12-22 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN SCHQ LHE 1994-12-22 00:00:00.0 2599-12-31 23:59:59.0
1994-12-22 00:00:00.0 1995-08-31 00:00:00.0
CN SCHQ LHN 1994-12-22 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN SCHQ LHN 1994-12-22 00:00:00.0 2599-12-31 23:59:59.0
1994-12-22 00:00:00.0 1995-08-31 00:00:00.0
CN SCHQ LHZ 1994-12-22 00:00:00.0 2599-12-31 23:59:59.0
1995-08-31 00:00:00.0 2599-12-31 23:59:59.0
CN SCHQ LHZ 1994-12-22 00:00:00.0 2599-12-31 23:59:59.0
1994-12-22 00:00:00.0 1995-08-31 00:00:00.0
CN PMB BHE 1993-06-04 00:00:00.0 2599-12-31 23:59:59.0
1995-08-01 00:00:00.0 2599-12-31 23:59:59.0
CN PMB BHE 1993-06-04 00:00:00.0 2599-12-31 23:59:59.0
1993-06-04 00:00:00.0 1995-08-01 00:00:00.0
CN PMB BHN 1993-06-04 00:00:00.0 2599-12-31 23:59:59.0
1995-08-01 00:00:00.0 2599-12-31 23:59:59.0
CN PMB BHN 1993-06-04 00:00:00.0 2599-12-31 23:59:59.0
1993-06-04 00:00:00.0 1995-08-01 00:00:00.0
CN PMB BHZ 1993-06-04 00:00:00.0 2599-12-31 23:59:59.0
1995-08-01 00:00:00.0 2599-12-31 23:59:59.0
CN PMB BHZ 1993-06-04 00:00:00.0 2599-12-31 23:59:59.0
1993-06-04 00:00:00.0 1995-08-01 00:00:00.0
Tue May 9 14:05:09 PDT 2006
More information about the data-issues
mailing list