{"queries":[{"id":"comp_count","compiledQueryString":"SELECT \n COUNT(*) AS count,\n satellite,\n 'MODIS' as sensor\nFROM \n ta.modis_ta_effis\nWHERE acquired::date > '2024-07-31' and acquired::date < '2024-09-01'\nGROUP BY \n satellite, sensor\n\nUNION ALL\n\nSELECT \n COUNT(*) AS count,\n satellite,\n 'SLSTR' as sensor\nFROM\n ta.ard_ta_s3t_effis\nWHERE acquired::date > '2024-07-31' and acquired::date < '2024-09-01'\nGROUP BY \n satellite, sensor","inputQueryString":"SELECT \n COUNT(*) AS count,\n satellite,\n 'MODIS' as sensor\nFROM \n ta.modis_ta_effis\nWHERE acquired::date > '2024-07-31' and acquired::date < '2024-09-01'\nGROUP BY \n satellite, sensor\n\nUNION ALL\n\nSELECT \n COUNT(*) AS count,\n satellite,\n 'SLSTR' as sensor\nFROM\n ta.ard_ta_s3t_effis\nWHERE acquired::date > '2024-07-31' and acquired::date < '2024-09-01'\nGROUP BY \n satellite, sensor","compiled":false,"inline":true},{"id":"comp_daynight","compiledQueryString":"SELECT \n COUNT(*) AS count,\n CASE \n WHEN daynight = 'D' THEN 'day'\n WHEN daynight = 'N' THEN 'night'\n ELSE daynight -- This handles any unexpected values; you can remove it if not needed\n END AS daynight,\n 'MODIS' as sensor\nFROM \n ta.modis_ta_effis\nWHERE acquired::date > '2024-07-31' and acquired::date < '2024-10-01'\nGROUP BY \n daynight, sensor\n\nUNION ALL\n\nSELECT \n COUNT(*) AS count,\n daynight,\n 'SLSTR' as sensor\nFROM\n ta.ard_ta_s3t_effis\nWHERE acquired::date > '2024-07-31' and acquired::date < '2024-10-01'\nGROUP BY \n daynight, sensor","inputQueryString":"SELECT \n COUNT(*) AS count,\n CASE \n WHEN daynight = 'D' THEN 'day'\n WHEN daynight = 'N' THEN 'night'\n ELSE daynight -- This handles any unexpected values; you can remove it if not needed\n END AS daynight,\n 'MODIS' as sensor\nFROM \n ta.modis_ta_effis\nWHERE acquired::date > '2024-07-31' and acquired::date < '2024-10-01'\nGROUP BY \n daynight, sensor\n\nUNION ALL\n\nSELECT \n COUNT(*) AS count,\n daynight,\n 'SLSTR' as sensor\nFROM\n ta.ard_ta_s3t_effis\nWHERE acquired::date > '2024-07-31' and acquired::date < '2024-10-01'\nGROUP BY \n daynight, sensor","compiled":false,"inline":true},{"id":"comp_sensor","compiledQueryString":"SELECT \n acquired::date as date,\n COUNT(*) AS count,\n 'MODIS' as sensor\nFROM \n ta.modis_ta_effis\nWHERE acquired::date > '2024-07-31' and acquired::date < '2024-10-01'\nGROUP BY \n date, sensor\n\nUNION ALL\n\nSELECT \n acquired::date as date,\n COUNT(*) AS count,\n 'SLSTR' as sensor\nFROM\n ta.ard_ta_s3t_effis\nWHERE acquired::date > '2024-07-31' and acquired::date < '2024-10-01'\nGROUP BY \n date, sensor\nORDER BY \n date, sensor;","inputQueryString":"SELECT \n acquired::date as date,\n COUNT(*) AS count,\n 'MODIS' as sensor\nFROM \n ta.modis_ta_effis\nWHERE acquired::date > '2024-07-31' and acquired::date < '2024-10-01'\nGROUP BY \n date, sensor\n\nUNION ALL\n\nSELECT \n acquired::date as date,\n COUNT(*) AS count,\n 'SLSTR' as sensor\nFROM\n ta.ard_ta_s3t_effis\nWHERE acquired::date > '2024-07-31' and acquired::date < '2024-10-01'\nGROUP BY \n date, sensor\nORDER BY \n date, sensor;","compiled":false,"inline":true},{"id":"frp_comp","compiledQueryString":"SELECT \n acquired::date as date,\n AVG(frp) AS frp_avg,\n 'MODIS' AS sensor\nFROM \n ta.modis_ta_effis\nWHERE acquired::date > '2024-07-31' and acquired::date < '2024-10-01'\nGROUP BY \n date\n\nUNION ALL\n\nSELECT \n acquired::date as date,\n AVG(frp) AS frp_avg,\n 'SLSTR' AS sensor\nFROM\n ta.ard_ta_s3t_effis\nWHERE acquired::date > '2024-07-31' and acquired::date < '2024-10-01'\nGROUP BY \n date\nORDER BY \n date;","inputQueryString":"SELECT \n acquired::date as date,\n AVG(frp) AS frp_avg,\n 'MODIS' AS sensor\nFROM \n ta.modis_ta_effis\nWHERE acquired::date > '2024-07-31' and acquired::date < '2024-10-01'\nGROUP BY \n date\n\nUNION ALL\n\nSELECT \n acquired::date as date,\n AVG(frp) AS frp_avg,\n 'SLSTR' AS sensor\nFROM\n ta.ard_ta_s3t_effis\nWHERE acquired::date > '2024-07-31' and acquired::date < '2024-10-01'\nGROUP BY \n date\nORDER BY \n date;","compiled":false,"inline":true},{"id":"frp_ordered","compiledQueryString":"SELECT \n CASE \n WHEN frp < 10 THEN '< 10'\n WHEN frp >= 10 AND frp < 50 THEN '10 - 50'\n WHEN frp >= 50 AND frp < 100 THEN '50 - 100'\n WHEN frp >= 100 AND frp < 400 THEN '100 - 400'\n WHEN frp >= 400 AND frp < 1000 THEN '400 - 1000'\n ELSE '> 1000'\n END AS frp_bin,\n count(*) as count,\n 'SLSTR' AS sensor\nFROM ta.ard_ta_s3t_effis\nWHERE acquired::date > '2024-07-31' and acquired::date < '2024-10-01'\nGROUP BY sensor, frp_bin\n\nUNION ALL\n\nSELECT \n CASE \n WHEN frp < 10 THEN '< 10'\n WHEN frp >= 10 AND frp < 50 THEN '10 - 50'\n WHEN frp >= 50 AND frp < 100 THEN '50 - 100'\n WHEN frp >= 100 AND frp < 400 THEN '100 - 400'\n WHEN frp >= 400 AND frp < 1000 THEN '400 - 1000'\n ELSE '> 1000'\n END AS frp_bin,\n count(*) as count,\n 'MODIS' AS sensor\nFROM ta.modis_ta_effis\nWHERE acquired::date > '2024-07-31' and acquired::date < '2024-10-01'\nGROUP BY sensor, frp_bin","inputQueryString":"SELECT \n CASE \n WHEN frp < 10 THEN '< 10'\n WHEN frp >= 10 AND frp < 50 THEN '10 - 50'\n WHEN frp >= 50 AND frp < 100 THEN '50 - 100'\n WHEN frp >= 100 AND frp < 400 THEN '100 - 400'\n WHEN frp >= 400 AND frp < 1000 THEN '400 - 1000'\n ELSE '> 1000'\n END AS frp_bin,\n count(*) as count,\n 'SLSTR' AS sensor\nFROM ta.ard_ta_s3t_effis\nWHERE acquired::date > '2024-07-31' and acquired::date < '2024-10-01'\nGROUP BY sensor, frp_bin\n\nUNION ALL\n\nSELECT \n CASE \n WHEN frp < 10 THEN '< 10'\n WHEN frp >= 10 AND frp < 50 THEN '10 - 50'\n WHEN frp >= 50 AND frp < 100 THEN '50 - 100'\n WHEN frp >= 100 AND frp < 400 THEN '100 - 400'\n WHEN frp >= 400 AND frp < 1000 THEN '400 - 1000'\n ELSE '> 1000'\n END AS frp_bin,\n count(*) as count,\n 'MODIS' AS sensor\nFROM ta.modis_ta_effis\nWHERE acquired::date > '2024-07-31' and acquired::date < '2024-10-01'\nGROUP BY sensor, frp_bin","compiled":false,"inline":true},{"id":"frp_ordered_day","compiledQueryString":"SELECT \n DATE_TRUNC('hour', acquired) AS hour,\n COUNT(*) AS record_count,\n 'SLSTR' as sensor\nFROM \n ta.ard_ta_s3t_effis\nWHERE acquired::date = '2024-09-16'\nGROUP BY hour, sensor\n\nUNION ALL\n\nSELECT \n DATE_TRUNC('hour', acquired) AS hour, \n COUNT(*) AS record_count,\n 'MODIS' as sensor\nFROM \n ta.modis_ta_effis\nWHERE acquired::date = '2024-09-16'\nGROUP BY hour, sensor\nORDER BY \n hour;","inputQueryString":"SELECT \n DATE_TRUNC('hour', acquired) AS hour,\n COUNT(*) AS record_count,\n 'SLSTR' as sensor\nFROM \n ta.ard_ta_s3t_effis\nWHERE acquired::date = '2024-09-16'\nGROUP BY hour, sensor\n\nUNION ALL\n\nSELECT \n DATE_TRUNC('hour', acquired) AS hour, \n COUNT(*) AS record_count,\n 'MODIS' as sensor\nFROM \n ta.modis_ta_effis\nWHERE acquired::date = '2024-09-16'\nGROUP BY hour, sensor\nORDER BY \n hour;","compiled":false,"inline":true},{"id":"fire_count_day","compiledQueryString":"SELECT \n ROW_NUMBER() OVER (ORDER BY frp) AS order_number,\n FLOOR(frp / 5) * 5 AS frp_bin,\n 'SLSTR' as sensor,\nFROM ta.ard_ta_s3t_effis\nWHERE acquired::date = '2024-09-16' and frp >= 30\n\nUNION ALL\n\nSELECT \n ROW_NUMBER() OVER (ORDER BY frp) AS order_number,\n FLOOR(frp / 5) * 5 AS frp_bin,\n 'MODIS' as sensor,\nFROM ta.modis_ta_effis\nWHERE acquired::date = '2024-09-16' and frp >= 30\nORDER BY \n order_number;","inputQueryString":"SELECT \n ROW_NUMBER() OVER (ORDER BY frp) AS order_number,\n FLOOR(frp / 5) * 5 AS frp_bin,\n 'SLSTR' as sensor,\nFROM ta.ard_ta_s3t_effis\nWHERE acquired::date = '2024-09-16' and frp >= 30\n\nUNION ALL\n\nSELECT \n ROW_NUMBER() OVER (ORDER BY frp) AS order_number,\n FLOOR(frp / 5) * 5 AS frp_bin,\n 'MODIS' as sensor,\nFROM ta.modis_ta_effis\nWHERE acquired::date = '2024-09-16' and frp >= 30\nORDER BY \n order_number;","compiled":false,"inline":true},{"id":"fire_count_day2","compiledQueryString":"SELECT \n ROW_NUMBER() OVER (ORDER BY frp ASC) AS rank, -- Add a ranking column to keep track of the order\n frp,\n sensor\nFROM (\n SELECT frp, 'SLSTR' as sensor FROM ta.ard_ta_s3t_effis WHERE acquired::date = '2024-09-16' and frp > 80\n UNION ALL\n SELECT frp, 'MODIS' as sensor FROM ta.modis_ta_effis WHERE acquired::date = '2024-09-16' and frp > 80\n) combined_data\nORDER BY frp;","inputQueryString":"SELECT \n ROW_NUMBER() OVER (ORDER BY frp ASC) AS rank, -- Add a ranking column to keep track of the order\n frp,\n sensor\nFROM (\n SELECT frp, 'SLSTR' as sensor FROM ta.ard_ta_s3t_effis WHERE acquired::date = '2024-09-16' and frp > 80\n UNION ALL\n SELECT frp, 'MODIS' as sensor FROM ta.modis_ta_effis WHERE acquired::date = '2024-09-16' and frp > 80\n) combined_data\nORDER BY frp;","compiled":false,"inline":true},{"id":"fire_count_day3","compiledQueryString":"SELECT \n ROW_NUMBER() OVER (ORDER BY frp ASC) AS rank, -- Add a ranking column to keep track of the order\n frp,\n sensor\nFROM (\n SELECT frp, 'SLSTR' as sensor FROM ta.ard_ta_s3t_effis WHERE acquired::date = '2024-09-16' \n UNION ALL\n SELECT frp, 'MODIS' as sensor FROM ta.modis_ta_effis WHERE acquired::date = '2024-09-16' \n) combined_data\nORDER BY frp;","inputQueryString":"SELECT \n ROW_NUMBER() OVER (ORDER BY frp ASC) AS rank, -- Add a ranking column to keep track of the order\n frp,\n sensor\nFROM (\n SELECT frp, 'SLSTR' as sensor FROM ta.ard_ta_s3t_effis WHERE acquired::date = '2024-09-16' \n UNION ALL\n SELECT frp, 'MODIS' as sensor FROM ta.modis_ta_effis WHERE acquired::date = '2024-09-16' \n) combined_data\nORDER BY frp;","compiled":false,"inline":true}]}

SLSTR - MODIS

Two Month Comparison

Single Day Comparison