Log in
Register
Menu
Log in
Register
Home
What's new
Latest activity
Authors
Forums
New posts
Search forums
What's new
New posts
Latest activity
Members
Current visitors
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Linux Based Receivers
Linux Receivers General
Using Linux Receivers To Create Signal Graphs
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Huevos" data-source="post: 873563" data-attributes="member: 301161"><p>All of them. Let me explain.</p><p></p><p>Contains 110 hours of data. That is all the data since switch-on of 2E.</p><p>Blue = 2F, all QPSK transponders.</p><p>Magenta = 2F, all 8PSK transponders.</p><p>Red = 2E, all QPSK transponders.</p><p>Green = 2E, all 8PSK transponders.</p><p></p><p>If it helps you understand here is the MySQL query and the graph created from that query.</p><p>[CODE]SELECT SEC_TO_TIME(FLOOR(TIME_TO_SEC(TIME(updated))/600)*600) AS `FROM`</p><p> , SEC_TO_TIME(FLOOR(TIME_TO_SEC(TIME(updated))/600)*600+600) AS `TO`</p><p> , round((AVG(`10773`) + AVG(`10788`) + AVG(`10803`) + AVG(`10817`) + AVG(`10862`) + AVG(`10876`) + AVG(`10921`))/7, 2) AS `2E-QPSK`</p><p> , round((AVG(`10964`) + AVG(`10994`) + AVG(`11053`) + AVG(`11126`))/4, 2) AS `2F-QPSK`</p><p> , round((AVG(`11023`) + AVG(`11067`) + AVG(`11097`))/3, 2) AS `2F-8PSK`</p><p> , round((AVG(`10847`) + AVG(`10935`))/2, 2) AS `2E-8PSK`</p><p> FROM snr</p><p>WHERE</p><p> updated > '2014-02-06 06:00:00'</p><p>GROUP</p><p> BY FLOOR(TIME_TO_SEC(TIME(updated))/600)[/CODE]</p><p></p><p>[ATTACH=full]61745[/ATTACH]</p></blockquote><p></p>
[QUOTE="Huevos, post: 873563, member: 301161"] All of them. Let me explain. Contains 110 hours of data. That is all the data since switch-on of 2E. Blue = 2F, all QPSK transponders. Magenta = 2F, all 8PSK transponders. Red = 2E, all QPSK transponders. Green = 2E, all 8PSK transponders. If it helps you understand here is the MySQL query and the graph created from that query. [CODE]SELECT SEC_TO_TIME(FLOOR(TIME_TO_SEC(TIME(updated))/600)*600) AS `FROM` , SEC_TO_TIME(FLOOR(TIME_TO_SEC(TIME(updated))/600)*600+600) AS `TO` , round((AVG(`10773`) + AVG(`10788`) + AVG(`10803`) + AVG(`10817`) + AVG(`10862`) + AVG(`10876`) + AVG(`10921`))/7, 2) AS `2E-QPSK` , round((AVG(`10964`) + AVG(`10994`) + AVG(`11053`) + AVG(`11126`))/4, 2) AS `2F-QPSK` , round((AVG(`11023`) + AVG(`11067`) + AVG(`11097`))/3, 2) AS `2F-8PSK` , round((AVG(`10847`) + AVG(`10935`))/2, 2) AS `2E-8PSK` FROM snr WHERE updated > '2014-02-06 06:00:00' GROUP BY FLOOR(TIME_TO_SEC(TIME(updated))/600)[/CODE] [ATTACH=full]61745[/ATTACH] [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Linux Based Receivers
Linux Receivers General
Using Linux Receivers To Create Signal Graphs
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.
Accept
Learn more…
Top