[data-issues] overlapping channels in XB96

[Philip Crotwell]

Hi

There are 6 pairs of channels with overlaps in time in the oracle  
database. Seems like that shouldn't happen to me. All are on the  
XB.CARO station.

thanks,
Philip

select a.network, a.station, a.location, a.channel, a.starttime,  
a.endtime, b.starttime, b.endtime FROM channel a, channel b WHERE  
a.network=b.network AND a.station=b.station AND a.location=b.location  
AND a.channel=b.channel AND a.starttime < b.starttime AND a.endtime >  
b.starttime;

Tue May 9 11:28:09 PDT 2006

NETWORK 	STATION 	LOCATION 	CHANNEL 	STARTTIME 	ENDTIME 	STARTTIME 	 
ENDTIME 	
XB 	CARO 		BHE 	1996-05-16 19:48:34.0 	1996-12-31 23:59:59.0 	 
1996-08-17 21:17:56.0 	1996-12-31 23:59:59.0 	
XB 	CARO 		BHN 	1996-05-16 19:48:34.0 	1996-12-31 23:59:59.0 	 
1996-08-17 21:17:56.0 	1996-12-31 23:59:59.0 	
XB 	CARO 		BHZ 	1996-05-16 19:48:34.0 	1996-12-31 23:59:59.0 	 
1996-08-17 21:17:56.0 	1996-12-31 23:59:59.0 	
XB 	CARO 		LHE 	1996-05-16 19:48:34.0 	1996-12-31 23:59:59.0 	 
1996-08-17 21:17:56.0 	1996-12-31 23:59:59.0 	
XB 	CARO 		LHN 	1996-05-16 19:48:34.0 	1996-12-31 23:59:59.0 	 
1996-08-17 21:17:56.0 	1996-12-31 23:59:59.0 	
XB 	CARO 		LHZ 	1996-05-16 19:48:34.0 	1996-12-31 23:59:59.0 	 
1996-08-17 21:17:56.0 	1996-12-31 23:59:59.0 	
Tue May 9 11:28:13 PDT 2006