🔗 lnkd.in/gSrKySCw
🔗 lnkd.in/gSrKySCw
I think the answers are "a meaningful amount" and "yes."
I think the answers are "a meaningful amount" and "yes."
SELECT
date_diff(date, "2012-01-01", day) days,
floor(cell_ll_lat*4) lat_index,
sum(fishing_hours) fishing_hours
FROM
`global-fishing-watch.fishing_effort_v3.fleet_daily_100_v3`
where
fishing_hours > 0
group
by days, lat_index
SELECT
date_diff(date, "2012-01-01", day) days,
floor(cell_ll_lat*4) lat_index,
sum(fishing_hours) fishing_hours
FROM
`global-fishing-watch.fishing_effort_v3.fleet_daily_100_v3`
where
fishing_hours > 0
group
by days, lat_index