BEST
SELECT * FROM getsignals('2004-2-22 00:00:00-05','2004-2-22 00:05:00 -05', 1)



SLOWER, but can return times when animals were scanned and no signals were obtained
> getsignals_daterange(date1, date2)
> getnosignals_daterange(date1, date2)
> getallsignals_daterange(date1, date2)
SELECT * FROM getsignals('2005-1-20 00:00:00-05','2005-1-20 05:00:00 -05') WHERE animalid=4 and aruloc = 3









TO FIND OUT HOW MANY GOOD SIGNALS ARE DETECTED IN A DAY (MODIFY WHERE: DATE RANGE, ANIMAL NAME, AND MIN SIGNAL STRENGTH). Note that this counts all signals, not just 1 per tower.

SELECT extract(year from bursts.daytime) as year,
       extract(month from bursts.daytime) as month,
       extract(day from bursts.daytime) as day,
       extract(doy from bursts.daytime) as doy,
       count(signals.signal) as countsig,
arulocs.descr as tower,
animals.id
 FROM  animals
       LEFT JOIN channelsettings ON(animals.id =
channelsettings.animal)
       LEFT JOIN bursts ON(channelsettings.id = bursts.channel)
       LEFT JOIN signals ON(bursts.id = signals.burst)
       LEFT JOIN antennas ON(antennas.id = signals.antenna)
       LEFT JOIN arulocs ON(arulocs.id = antennas.aruloc)
 Where bursts.daytime > '1-Aug-2005'  and bursts.daytime < '31-Aug-2005' and signals.signal > -12900 and animals.id = 131
      
GROUP BY 
extract(year from bursts.daytime),
       extract(month from bursts.daytime),
       extract(day from bursts.daytime),
       extract(doy from bursts.daytime),
arulocs.descr,
       animals.id
 ORDER BY year, doy, animals.id,arulocs.descr


 and bursts.daytime < '1-Dec-2005'
 and signals.signal > -12900







TO GET SIGNALS AND MOD FROM A SINGLE BURST.

SELECT
signals.sequence, signals.signal, signals.mod,
antennas.aruloc, antennas.angle, antennas.position
FROM signals
LEFT JOIN antennas ON(antennas.id = signals.antenna)
WHERE signals.burst=6848245
ORDER BY antennas.aruloc, signals.sequence, antennas.position