In [1]:
import bq
import time
import numpy as np
import matplotlib.pyplot as plt
import matplotlib.pyplot as plt
from mpl_toolkits.basemap import Basemap
import matplotlib
from matplotlib import colors,colorbar
import matplotlib
%matplotlib inline
import csv
import math
from math import radians, cos, sin, asin, sqrt
from scipy import stats
import matplotlib.dates as mdates
client = bq.Client.Get()
/Users/David/Desktop/Jobs/GlobalFishingWatch/github/vessel-maps/utilities/pipa_paper/venv/lib/python2.7/site-packages/matplotlib/font_manager.py:273: UserWarning: Matplotlib is building the font cache using fc-list. This may take a moment.
warnings.warn('Matplotlib is building the font cache using fc-list. This may take a moment.')
In [20]:
# create a bounding box:
max_lat = 82
min_lat = 68
max_lon = 54
min_lon = 16
In [21]:
def Query(q):
t0 = time.time()
answer = client.ReadTableRows(client.Query(q)['configuration']['query']['destinationTable'])
print 'Query time: ' + str(time.time() - t0) + ' seconds.'
return answer
In [22]:
q = '''
select count(distinct mmsi)
FROM
[tilesets.pipeline_2015_08_24_08_19_01]
WHERE
latitude > '''+str(min_lat)+'''
AND latitude <'''+str(max_lat)+'''
AND longitude > '''+str(min_lon)+'''
AND longitude < '''+str(max_lon)+'''
AND weight >=.5'''
number_of_mmsi = Query(q)
Waiting on bqjob_r252e375b306b77ca_0000015434c2414e_8 ... (2s) Current status: DONE
Query time: 4.58446598053 seconds.
In [23]:
print "Number of unique MMSI:",int(number_of_mmsi[0][0])
Number of unique MMSI: 1165
In [24]:
q = '''
select a.mmsi mmsi,
a.number number,
if(b.country is null, "invalid mmsi",b.country) country,
b.continent continent
from
(select mmsi,
integer(if(length(string(mmsi))= 9,LEFT(STRING(mmsi),3), '0')) code,
count(*) number from
(SELECT
mmsi,
date(timestamp) date,
first(latitude) lat,
first(longitude) lon
FROM
[tilesets.pipeline_2015_08_24_08_19_01]
WHERE
latitude > '''+str(min_lat)+'''
AND latitude <'''+str(max_lat)+'''
AND longitude > '''+str(min_lon)+'''
AND longitude < '''+str(max_lon)+'''
AND weight >=.5
group by mmsi, date)
group by mmsi, code
)
a
left join [scratch_roan.country_code] b
on a.code = b.code
order by number desc'''
days_by_mmsi = Query(q)
Waiting on bqjob_r2eaa1bfde877409d_0000015434c25343_9 ... (2s) Current status: DONE
Query time: 4.46662902832 seconds.
In [25]:
for r in days_by_mmsi:
if "Taiwan" in r[2]:
r[2] = "Taiwan"
print "mmsi:", r[0]," fishing days:", r[1], " country: ", r[2].split(" (")[0]
mmsi: 273412090 fishing days: 557 country: Russian Federation
mmsi: 257490700 fishing days: 550 country: Norway
mmsi: 273313560 fishing days: 538 country: Russian Federation
mmsi: 257312540 fishing days: 533 country: Norway
mmsi: 273510600 fishing days: 531 country: Russian Federation
mmsi: 273290400 fishing days: 530 country: Russian Federation
mmsi: 259635000 fishing days: 522 country: Norway
mmsi: 273516500 fishing days: 521 country: Russian Federation
mmsi: 273853400 fishing days: 511 country: Russian Federation
mmsi: 273559500 fishing days: 506 country: Russian Federation
mmsi: 258185000 fishing days: 505 country: Norway
mmsi: 273312270 fishing days: 493 country: Russian Federation
mmsi: 257030600 fishing days: 492 country: Norway
mmsi: 273433400 fishing days: 488 country: Russian Federation
mmsi: 251222540 fishing days: 485 country: Iceland
mmsi: 273212500 fishing days: 484 country: Russian Federation
mmsi: 257326020 fishing days: 480 country: Norway
mmsi: 273415090 fishing days: 476 country: Russian Federation
mmsi: 257302620 fishing days: 475 country: Norway
mmsi: 273352280 fishing days: 474 country: Russian Federation
mmsi: 231107000 fishing days: 473 country: Faroe Islands - Denmark
mmsi: 273211900 fishing days: 472 country: Russian Federation
mmsi: 258535000 fishing days: 470 country: Norway
mmsi: 273429300 fishing days: 467 country: Russian Federation
mmsi: 225436000 fishing days: 466 country: Spain
mmsi: 257586600 fishing days: 464 country: Norway
mmsi: 273219300 fishing days: 462 country: Russian Federation
mmsi: 258128000 fishing days: 462 country: Norway
mmsi: 273454800 fishing days: 459 country: Russian Federation
mmsi: 273357560 fishing days: 458 country: Russian Federation
mmsi: 257174420 fishing days: 456 country: Norway
mmsi: 257326920 fishing days: 456 country: Norway
mmsi: 273424080 fishing days: 455 country: Russian Federation
mmsi: 273440730 fishing days: 453 country: Russian Federation
mmsi: 273213500 fishing days: 452 country: Russian Federation
mmsi: 257488920 fishing days: 450 country: Norway
mmsi: 257246420 fishing days: 447 country: Norway
mmsi: 273514800 fishing days: 445 country: Russian Federation
mmsi: 257895500 fishing days: 441 country: Norway
mmsi: 273421520 fishing days: 440 country: Russian Federation
mmsi: 258553000 fishing days: 439 country: Norway
mmsi: 258099000 fishing days: 433 country: Norway
mmsi: 257022340 fishing days: 432 country: Norway
mmsi: 257133000 fishing days: 430 country: Norway
mmsi: 273211500 fishing days: 429 country: Russian Federation
mmsi: 273355290 fishing days: 427 country: Russian Federation
mmsi: 273848010 fishing days: 425 country: Russian Federation
mmsi: 257089640 fishing days: 424 country: Norway
mmsi: 273331070 fishing days: 423 country: Russian Federation
mmsi: 273212000 fishing days: 422 country: Russian Federation
mmsi: 257188540 fishing days: 422 country: Norway
mmsi: 273298000 fishing days: 420 country: Russian Federation
mmsi: 257177120 fishing days: 420 country: Norway
mmsi: 257126040 fishing days: 419 country: Norway
mmsi: 257201020 fishing days: 417 country: Norway
mmsi: 273430630 fishing days: 417 country: Russian Federation
mmsi: 273317270 fishing days: 412 country: Russian Federation
mmsi: 257056600 fishing days: 411 country: Norway
mmsi: 273421600 fishing days: 410 country: Russian Federation
mmsi: 273550600 fishing days: 409 country: Russian Federation
mmsi: 273298800 fishing days: 409 country: Russian Federation
mmsi: 259217000 fishing days: 407 country: Norway
mmsi: 273811080 fishing days: 407 country: Russian Federation
mmsi: 257259320 fishing days: 403 country: Norway
mmsi: 257437220 fishing days: 399 country: Norway
mmsi: 259637000 fishing days: 399 country: Norway
mmsi: 257143420 fishing days: 398 country: Norway
mmsi: 257311940 fishing days: 394 country: Norway
mmsi: 257122820 fishing days: 390 country: Norway
mmsi: 273817400 fishing days: 390 country: Russian Federation
mmsi: 257156240 fishing days: 390 country: Norway
mmsi: 231053000 fishing days: 388 country: Faroe Islands - Denmark
mmsi: 257647500 fishing days: 387 country: Norway
mmsi: 273555500 fishing days: 386 country: Russian Federation
mmsi: 273420560 fishing days: 386 country: Russian Federation
mmsi: 257489500 fishing days: 383 country: Norway
mmsi: 273427000 fishing days: 383 country: Russian Federation
mmsi: 273525900 fishing days: 382 country: Russian Federation
mmsi: 273450930 fishing days: 382 country: Russian Federation
mmsi: 273336280 fishing days: 379 country: Russian Federation
mmsi: 259252000 fishing days: 378 country: Norway
mmsi: 257156320 fishing days: 374 country: Norway
mmsi: 273294400 fishing days: 374 country: Russian Federation
mmsi: 258052000 fishing days: 374 country: Norway
mmsi: 273523100 fishing days: 371 country: Russian Federation
mmsi: 257250320 fishing days: 368 country: Norway
mmsi: 273451570 fishing days: 367 country: Russian Federation
mmsi: 257549800 fishing days: 367 country: Norway
mmsi: 257135020 fishing days: 364 country: Norway
mmsi: 257466000 fishing days: 363 country: Norway
mmsi: 231751000 fishing days: 363 country: Faroe Islands - Denmark
mmsi: 273298100 fishing days: 363 country: Russian Federation
mmsi: 257312840 fishing days: 361 country: Norway
mmsi: 273444750 fishing days: 360 country: Russian Federation
mmsi: 273552400 fishing days: 360 country: Russian Federation
mmsi: 273350610 fishing days: 358 country: Russian Federation
mmsi: 273316960 fishing days: 354 country: Russian Federation
mmsi: 273550500 fishing days: 353 country: Russian Federation
mmsi: 259106000 fishing days: 351 country: Norway
mmsi: 259666000 fishing days: 350 country: Norway
mmsi: 257153500 fishing days: 345 country: Norway
mmsi: 257136420 fishing days: 345 country: Norway
mmsi: 275444000 fishing days: 343 country: Latvia
mmsi: 273559400 fishing days: 341 country: Russian Federation
mmsi: 257528700 fishing days: 341 country: Norway
mmsi: 273296700 fishing days: 339 country: Russian Federation
mmsi: 257167020 fishing days: 338 country: Norway
mmsi: 277512000 fishing days: 338 country: Lithuania
mmsi: 273436830 fishing days: 337 country: Russian Federation
mmsi: 273292400 fishing days: 333 country: Russian Federation
mmsi: 258529000 fishing days: 333 country: Norway
mmsi: 277511000 fishing days: 332 country: Lithuania
mmsi: 273214110 fishing days: 329 country: Russian Federation
mmsi: 276388000 fishing days: 329 country: Estonia
mmsi: 273323130 fishing days: 328 country: Russian Federation
mmsi: 273218900 fishing days: 327 country: Russian Federation
mmsi: 258387000 fishing days: 324 country: Norway
mmsi: 273211800 fishing days: 322 country: Russian Federation
mmsi: 257306140 fishing days: 321 country: Norway
mmsi: 258154000 fishing days: 320 country: Norway
mmsi: 257312140 fishing days: 320 country: Norway
mmsi: 258141000 fishing days: 319 country: Norway
mmsi: 257035940 fishing days: 318 country: Norway
mmsi: 257549600 fishing days: 317 country: Norway
mmsi: 257194440 fishing days: 316 country: Norway
mmsi: 257886500 fishing days: 313 country: Norway
mmsi: 257260720 fishing days: 312 country: Norway
mmsi: 258147000 fishing days: 312 country: Norway
mmsi: 257577500 fishing days: 312 country: Norway
mmsi: 273443790 fishing days: 308 country: Russian Federation
mmsi: 273414800 fishing days: 306 country: Russian Federation
mmsi: 273297100 fishing days: 305 country: Russian Federation
mmsi: 257074140 fishing days: 304 country: Norway
mmsi: 257405320 fishing days: 303 country: Norway
mmsi: 257222222 fishing days: 301 country: Norway
mmsi: 276458000 fishing days: 300 country: Estonia
mmsi: 257923140 fishing days: 299 country: Norway
mmsi: 257668500 fishing days: 299 country: Norway
mmsi: 273326830 fishing days: 298 country: Russian Federation
mmsi: 273211700 fishing days: 298 country: Russian Federation
mmsi: 257408500 fishing days: 298 country: Norway
mmsi: 257655600 fishing days: 297 country: Norway
mmsi: 273431480 fishing days: 297 country: Russian Federation
mmsi: 258874000 fishing days: 297 country: Norway
mmsi: 259383000 fishing days: 296 country: Norway
mmsi: 257667600 fishing days: 295 country: Norway
mmsi: 273213010 fishing days: 293 country: Russian Federation
mmsi: 257483620 fishing days: 293 country: Norway
mmsi: 277442000 fishing days: 292 country: Lithuania
mmsi: 224905000 fishing days: 291 country: Spain
mmsi: 257435500 fishing days: 287 country: Norway
mmsi: 257588700 fishing days: 286 country: Norway
mmsi: 257423000 fishing days: 286 country: Norway
mmsi: 257481720 fishing days: 284 country: Norway
mmsi: 257617500 fishing days: 282 country: Norway
mmsi: 257164700 fishing days: 279 country: Norway
mmsi: 257560800 fishing days: 275 country: Norway
mmsi: 273430750 fishing days: 273 country: Russian Federation
mmsi: 273516000 fishing days: 273 country: Russian Federation
mmsi: 273457950 fishing days: 272 country: Russian Federation
mmsi: 259092000 fishing days: 272 country: Norway
mmsi: 259247000 fishing days: 270 country: Norway
mmsi: 273433220 fishing days: 267 country: Russian Federation
mmsi: 273518800 fishing days: 265 country: Russian Federation
mmsi: 273293400 fishing days: 264 country: Russian Federation
mmsi: 257135500 fishing days: 264 country: Norway
mmsi: 259282000 fishing days: 263 country: Norway
mmsi: 257309840 fishing days: 262 country: Norway
mmsi: 257460500 fishing days: 261 country: Norway
mmsi: 259641000 fishing days: 261 country: Norway
mmsi: 273295700 fishing days: 259 country: Russian Federation
mmsi: 273554600 fishing days: 258 country: Russian Federation
mmsi: 273555000 fishing days: 258 country: Russian Federation
mmsi: 257218440 fishing days: 256 country: Norway
mmsi: 273449630 fishing days: 254 country: Russian Federation
mmsi: 257565500 fishing days: 252 country: Norway
mmsi: 257463500 fishing days: 252 country: Norway
mmsi: 257589800 fishing days: 251 country: Norway
mmsi: 273896810 fishing days: 251 country: Russian Federation
mmsi: 259302000 fishing days: 249 country: Norway
mmsi: 257209500 fishing days: 244 country: Norway
mmsi: 257401420 fishing days: 242 country: Norway
mmsi: 259102000 fishing days: 242 country: Norway
mmsi: 273352230 fishing days: 241 country: Russian Federation
mmsi: 257147920 fishing days: 240 country: Norway
mmsi: 273212110 fishing days: 240 country: Russian Federation
mmsi: 273355780 fishing days: 239 country: Russian Federation
mmsi: 259474000 fishing days: 239 country: Norway
mmsi: 232555000 fishing days: 238 country: United Kingdom of Great Britain and Northern Ireland
mmsi: 257812500 fishing days: 237 country: Norway
mmsi: 224871000 fishing days: 236 country: Spain
mmsi: 257307940 fishing days: 234 country: Norway
mmsi: 257618500 fishing days: 234 country: Norway
mmsi: 231045000 fishing days: 234 country: Faroe Islands - Denmark
mmsi: 257880500 fishing days: 233 country: Norway
mmsi: 273425330 fishing days: 232 country: Russian Federation
mmsi: 273841710 fishing days: 231 country: Russian Federation
mmsi: 273458300 fishing days: 230 country: Russian Federation
mmsi: 257001410 fishing days: 230 country: Norway
mmsi: 257121000 fishing days: 229 country: Norway
mmsi: 257317000 fishing days: 224 country: Norway
mmsi: 257850500 fishing days: 224 country: Norway
mmsi: 257100740 fishing days: 224 country: Norway
mmsi: 257225000 fishing days: 223 country: Norway
mmsi: 273448120 fishing days: 222 country: Russian Federation
mmsi: 261383000 fishing days: 221 country: Poland
mmsi: 273351680 fishing days: 220 country: Russian Federation
mmsi: 231124000 fishing days: 220 country: Faroe Islands - Denmark
mmsi: 273241100 fishing days: 214 country: Russian Federation
mmsi: 273435580 fishing days: 212 country: Russian Federation
mmsi: 257220320 fishing days: 212 country: Norway
mmsi: 273217010 fishing days: 212 country: Russian Federation
mmsi: 273517900 fishing days: 212 country: Russian Federation
mmsi: 257105040 fishing days: 210 country: Norway
mmsi: 257783500 fishing days: 208 country: Norway
mmsi: 257117920 fishing days: 207 country: Norway
mmsi: 257059240 fishing days: 207 country: Norway
mmsi: 257237420 fishing days: 207 country: Norway
mmsi: 257452900 fishing days: 206 country: Norway
mmsi: 273291400 fishing days: 203 country: Russian Federation
mmsi: 273212100 fishing days: 202 country: Russian Federation
mmsi: 259627000 fishing days: 202 country: Norway
mmsi: 273348330 fishing days: 200 country: Russian Federation
mmsi: 259023000 fishing days: 199 country: Norway
mmsi: 257221740 fishing days: 199 country: Norway
mmsi: 277030000 fishing days: 199 country: Lithuania
mmsi: 258563000 fishing days: 198 country: Norway
mmsi: 251153000 fishing days: 197 country: Iceland
mmsi: 257536700 fishing days: 196 country: Norway
mmsi: 257204240 fishing days: 195 country: Norway
mmsi: 273311280 fishing days: 195 country: Russian Federation
mmsi: 257245220 fishing days: 195 country: Norway
mmsi: 257511600 fishing days: 193 country: Norway
mmsi: 257499800 fishing days: 193 country: Norway
mmsi: 259485000 fishing days: 193 country: Norway
mmsi: 231066000 fishing days: 193 country: Faroe Islands - Denmark
mmsi: 257313700 fishing days: 193 country: Norway
mmsi: 257576600 fishing days: 192 country: Norway
mmsi: 257611500 fishing days: 190 country: Norway
mmsi: 257530500 fishing days: 189 country: Norway
mmsi: 257064900 fishing days: 188 country: Norway
mmsi: 273523400 fishing days: 187 country: Russian Federation
mmsi: 257109120 fishing days: 183 country: Norway
mmsi: 259203000 fishing days: 181 country: Norway
mmsi: 258380500 fishing days: 181 country: Norway
mmsi: 257066740 fishing days: 181 country: Norway
mmsi: 257125040 fishing days: 180 country: Norway
mmsi: 257136500 fishing days: 180 country: Norway
mmsi: 257109340 fishing days: 180 country: Norway
mmsi: 257178940 fishing days: 179 country: Norway
mmsi: 257004610 fishing days: 178 country: Norway
mmsi: 257004010 fishing days: 178 country: Norway
mmsi: 257345120 fishing days: 178 country: Norway
mmsi: 259565000 fishing days: 177 country: Norway
mmsi: 257213740 fishing days: 177 country: Norway
mmsi: 257400900 fishing days: 176 country: Norway
mmsi: 25852310 fishing days: 175 country: invalid mmsi
mmsi: 257207740 fishing days: 175 country: Norway
mmsi: 273328330 fishing days: 173 country: Russian Federation
mmsi: 257301640 fishing days: 173 country: Norway
mmsi: 273527500 fishing days: 173 country: Russian Federation
mmsi: 257574600 fishing days: 173 country: Norway
mmsi: 257592500 fishing days: 172 country: Norway
mmsi: 257611600 fishing days: 172 country: Norway
mmsi: 257313620 fishing days: 172 country: Norway
mmsi: 251123000 fishing days: 171 country: Iceland
mmsi: 257326120 fishing days: 170 country: Norway
mmsi: 257315620 fishing days: 170 country: Norway
mmsi: 258057000 fishing days: 170 country: Norway
mmsi: 257605500 fishing days: 169 country: Norway
mmsi: 257311240 fishing days: 169 country: Norway
mmsi: 257165320 fishing days: 167 country: Norway
mmsi: 257726500 fishing days: 167 country: Norway
mmsi: 257123220 fishing days: 167 country: Norway
mmsi: 257532500 fishing days: 166 country: Norway
mmsi: 257305040 fishing days: 165 country: Norway
mmsi: 273448380 fishing days: 164 country: Russian Federation
mmsi: 259489000 fishing days: 164 country: Norway
mmsi: 257541790 fishing days: 163 country: Norway
mmsi: 273329820 fishing days: 162 country: Russian Federation
mmsi: 258503000 fishing days: 162 country: Norway
mmsi: 257124840 fishing days: 161 country: Norway
mmsi: 273341920 fishing days: 161 country: Russian Federation
mmsi: 273413800 fishing days: 160 country: Russian Federation
mmsi: 258516910 fishing days: 160 country: Norway
mmsi: 257323620 fishing days: 159 country: Norway
mmsi: 273297800 fishing days: 159 country: Russian Federation
mmsi: 257271600 fishing days: 159 country: Norway
mmsi: 273517500 fishing days: 159 country: Russian Federation
mmsi: 257004510 fishing days: 159 country: Norway
mmsi: 257599500 fishing days: 158 country: Norway
mmsi: 259683000 fishing days: 158 country: Norway
mmsi: 273210800 fishing days: 158 country: Russian Federation
mmsi: 257095900 fishing days: 157 country: Norway
mmsi: 257027000 fishing days: 157 country: Norway
mmsi: 273431450 fishing days: 156 country: Russian Federation
mmsi: 257205540 fishing days: 155 country: Norway
mmsi: 257106040 fishing days: 155 country: Norway
mmsi: 257309640 fishing days: 155 country: Norway
mmsi: 257479800 fishing days: 154 country: Norway
mmsi: 257128000 fishing days: 154 country: Norway
mmsi: 257137420 fishing days: 154 country: Norway
mmsi: 273376220 fishing days: 154 country: Russian Federation
mmsi: 258381500 fishing days: 154 country: Norway
mmsi: 257441120 fishing days: 153 country: Norway
mmsi: 257307720 fishing days: 153 country: Norway
mmsi: 257703500 fishing days: 152 country: Norway
mmsi: 257034840 fishing days: 152 country: Norway
mmsi: 257657600 fishing days: 151 country: Norway
mmsi: 257121720 fishing days: 150 country: Norway
mmsi: 257307340 fishing days: 150 country: Norway
mmsi: 257686500 fishing days: 150 country: Norway
mmsi: 258351000 fishing days: 150 country: Norway
mmsi: 257340820 fishing days: 149 country: Norway
mmsi: 258228000 fishing days: 149 country: Norway
mmsi: 257124520 fishing days: 148 country: Norway
mmsi: 257782500 fishing days: 148 country: Norway
mmsi: 257007500 fishing days: 146 country: Norway
mmsi: 257421500 fishing days: 145 country: Norway
mmsi: 257842500 fishing days: 145 country: Norway
mmsi: 257102540 fishing days: 145 country: Norway
mmsi: 331070000 fishing days: 144 country: Greenland - Denmark
mmsi: 273459300 fishing days: 143 country: Russian Federation
mmsi: 257196340 fishing days: 142 country: Norway
mmsi: 257097440 fishing days: 141 country: Norway
mmsi: 257460220 fishing days: 140 country: Norway
mmsi: 257093440 fishing days: 140 country: Norway
mmsi: 257210240 fishing days: 140 country: Norway
mmsi: 257288820 fishing days: 140 country: Norway
mmsi: 257601150 fishing days: 140 country: Norway
mmsi: 257352620 fishing days: 137 country: Norway
mmsi: 257087440 fishing days: 137 country: Norway
mmsi: 259309000 fishing days: 137 country: Norway
mmsi: 257469320 fishing days: 135 country: Norway
mmsi: 257114440 fishing days: 135 country: Norway
mmsi: 257132820 fishing days: 135 country: Norway
mmsi: 257191500 fishing days: 134 country: Norway
mmsi: 257313740 fishing days: 134 country: Norway
mmsi: 257416000 fishing days: 134 country: Norway
mmsi: 257260120 fishing days: 134 country: Norway
mmsi: 257594800 fishing days: 133 country: Norway
mmsi: 257621800 fishing days: 133 country: Norway
mmsi: 257176640 fishing days: 131 country: Norway
mmsi: 273420660 fishing days: 130 country: Russian Federation
mmsi: 257038740 fishing days: 129 country: Norway
mmsi: 257317020 fishing days: 128 country: Norway
mmsi: 257356320 fishing days: 128 country: Norway
mmsi: 259616000 fishing days: 128 country: Norway
mmsi: 257093900 fishing days: 128 country: Norway
mmsi: 257138820 fishing days: 127 country: Norway
mmsi: 257511800 fishing days: 126 country: Norway
mmsi: 257445500 fishing days: 126 country: Norway
mmsi: 219257000 fishing days: 126 country: Denmark
mmsi: 257604600 fishing days: 125 country: Norway
mmsi: 257457620 fishing days: 125 country: Norway
mmsi: 259137000 fishing days: 124 country: Norway
mmsi: 257593500 fishing days: 124 country: Norway
mmsi: 273213300 fishing days: 121 country: Russian Federation
mmsi: 257108500 fishing days: 121 country: Norway
mmsi: 257096440 fishing days: 120 country: Norway
mmsi: 257526600 fishing days: 120 country: Norway
mmsi: 224298000 fishing days: 118 country: Spain
mmsi: 257480500 fishing days: 118 country: Norway
mmsi: 257785980 fishing days: 118 country: Norway
mmsi: 257263320 fishing days: 117 country: Norway
mmsi: 257343120 fishing days: 116 country: Norway
mmsi: 257388000 fishing days: 116 country: Norway
mmsi: 257055040 fishing days: 116 country: Norway
mmsi: 257167320 fishing days: 116 country: Norway
mmsi: 257543600 fishing days: 115 country: Norway
mmsi: 257091140 fishing days: 115 country: Norway
mmsi: 257140140 fishing days: 115 country: Norway
mmsi: 257419800 fishing days: 115 country: Norway
mmsi: 257003710 fishing days: 114 country: Norway
mmsi: 257068740 fishing days: 114 country: Norway
mmsi: 257181020 fishing days: 114 country: Norway
mmsi: 225318000 fishing days: 114 country: Spain
mmsi: 257101640 fishing days: 114 country: Norway
mmsi: 257150240 fishing days: 113 country: Norway
mmsi: 257120340 fishing days: 113 country: Norway
mmsi: 257309440 fishing days: 113 country: Norway
mmsi: 257141040 fishing days: 112 country: Norway
mmsi: 257486020 fishing days: 112 country: Norway
mmsi: 257409700 fishing days: 111 country: Norway
mmsi: 257558500 fishing days: 111 country: Norway
mmsi: 257171940 fishing days: 110 country: Norway
mmsi: 273294000 fishing days: 108 country: Russian Federation
mmsi: 257025740 fishing days: 107 country: Norway
mmsi: 257435020 fishing days: 107 country: Norway
mmsi: 257767490 fishing days: 106 country: Norway
mmsi: 257302720 fishing days: 105 country: Norway
mmsi: 258002220 fishing days: 105 country: Norway
mmsi: 257150120 fishing days: 105 country: Norway
mmsi: 259165000 fishing days: 105 country: Norway
mmsi: 257133620 fishing days: 105 country: Norway
mmsi: 273354540 fishing days: 104 country: Russian Federation
mmsi: 257285420 fishing days: 103 country: Norway
mmsi: 257004040 fishing days: 103 country: Norway
mmsi: 257131740 fishing days: 102 country: Norway
mmsi: 251079000 fishing days: 102 country: Iceland
mmsi: 259244000 fishing days: 102 country: Norway
mmsi: 257855500 fishing days: 101 country: Norway
mmsi: 331165000 fishing days: 101 country: Greenland - Denmark
mmsi: 273348570 fishing days: 100 country: Russian Federation
mmsi: 257148020 fishing days: 100 country: Norway
mmsi: 257611700 fishing days: 100 country: Norway
mmsi: 257154540 fishing days: 100 country: Norway
mmsi: 257674500 fishing days: 100 country: Norway
mmsi: 257265320 fishing days: 99 country: Norway
mmsi: 257104240 fishing days: 99 country: Norway
mmsi: 257548600 fishing days: 98 country: Norway
mmsi: 257131320 fishing days: 97 country: Norway
mmsi: 257563500 fishing days: 96 country: Norway
mmsi: 257125440 fishing days: 96 country: Norway
mmsi: 259375000 fishing days: 95 country: Norway
mmsi: 257165340 fishing days: 95 country: Norway
mmsi: 257153700 fishing days: 95 country: Norway
mmsi: 258290000 fishing days: 93 country: Norway
mmsi: 257806500 fishing days: 92 country: Norway
mmsi: 257600800 fishing days: 92 country: Norway
mmsi: 258084000 fishing days: 91 country: Norway
mmsi: 257406500 fishing days: 91 country: Norway
mmsi: 258510310 fishing days: 91 country: Norway
mmsi: 257215140 fishing days: 90 country: Norway
mmsi: 257058040 fishing days: 90 country: Norway
mmsi: 257438220 fishing days: 90 country: Norway
mmsi: 257213620 fishing days: 90 country: Norway
mmsi: 257224020 fishing days: 90 country: Norway
mmsi: 258529810 fishing days: 89 country: Norway
mmsi: 257167800 fishing days: 89 country: Norway
mmsi: 257600500 fishing days: 89 country: Norway
mmsi: 257424820 fishing days: 88 country: Norway
mmsi: 257863500 fishing days: 88 country: Norway
mmsi: 227489000 fishing days: 87 country: France
mmsi: 257336000 fishing days: 87 country: Norway
mmsi: 257116240 fishing days: 87 country: Norway
mmsi: 257413420 fishing days: 86 country: Norway
mmsi: 257114140 fishing days: 86 country: Norway
mmsi: 257307040 fishing days: 85 country: Norway
mmsi: 257105740 fishing days: 85 country: Norway
mmsi: 257298920 fishing days: 85 country: Norway
mmsi: 257292620 fishing days: 85 country: Norway
mmsi: 257107120 fishing days: 84 country: Norway
mmsi: 257486720 fishing days: 84 country: Norway
mmsi: 257103940 fishing days: 84 country: Norway
mmsi: 257312040 fishing days: 84 country: Norway
mmsi: 257137220 fishing days: 84 country: Norway
mmsi: 273377320 fishing days: 84 country: Russian Federation
mmsi: 257224500 fishing days: 83 country: Norway
mmsi: 257867500 fishing days: 83 country: Norway
mmsi: 257643900 fishing days: 83 country: Norway
mmsi: 251318000 fishing days: 82 country: Iceland
mmsi: 257216940 fishing days: 82 country: Norway
mmsi: 257206640 fishing days: 82 country: Norway
mmsi: 257201540 fishing days: 82 country: Norway
mmsi: 257695700 fishing days: 82 country: Norway
mmsi: 257457700 fishing days: 82 country: Norway
mmsi: 235103197 fishing days: 81 country: United Kingdom of Great Britain and Northern Ireland
mmsi: 257141820 fishing days: 81 country: Norway
mmsi: 257145820 fishing days: 81 country: Norway
mmsi: 273425630 fishing days: 80 country: Russian Federation
mmsi: 257289720 fishing days: 79 country: Norway
mmsi: 257030540 fishing days: 79 country: Norway
mmsi: 257106340 fishing days: 79 country: Norway
mmsi: 257955500 fishing days: 78 country: Norway
mmsi: 257269420 fishing days: 78 country: Norway
mmsi: 211214200 fishing days: 78 country: Germany
mmsi: 257166220 fishing days: 78 country: Norway
mmsi: 251038000 fishing days: 78 country: Iceland
mmsi: 257345820 fishing days: 77 country: Norway
mmsi: 257311640 fishing days: 77 country: Norway
mmsi: 257002810 fishing days: 77 country: Norway
mmsi: 257208840 fishing days: 76 country: Norway
mmsi: 257210940 fishing days: 76 country: Norway
mmsi: 257046900 fishing days: 75 country: Norway
mmsi: 257308620 fishing days: 75 country: Norway
mmsi: 257164320 fishing days: 75 country: Norway
mmsi: 257095540 fishing days: 75 country: Norway
mmsi: 257220620 fishing days: 74 country: Norway
mmsi: 257263800 fishing days: 74 country: Norway
mmsi: 257353420 fishing days: 74 country: Norway
mmsi: 273240700 fishing days: 74 country: Russian Federation
mmsi: 257218700 fishing days: 74 country: Norway
mmsi: 257335820 fishing days: 74 country: Norway
mmsi: 257006700 fishing days: 73 country: Norway
mmsi: 273437080 fishing days: 73 country: Russian Federation
mmsi: 257307220 fishing days: 72 country: Norway
mmsi: 257522600 fishing days: 72 country: Norway
mmsi: 257305340 fishing days: 72 country: Norway
mmsi: 257178340 fishing days: 71 country: Norway
mmsi: 257468700 fishing days: 71 country: Norway
mmsi: 257135220 fishing days: 71 country: Norway
mmsi: 257201640 fishing days: 71 country: Norway
mmsi: 224572000 fishing days: 71 country: Spain
mmsi: 257341320 fishing days: 70 country: Norway
mmsi: 258002120 fishing days: 70 country: Norway
mmsi: 257641500 fishing days: 70 country: Norway
mmsi: 275455000 fishing days: 70 country: Latvia
mmsi: 257367000 fishing days: 69 country: Norway
mmsi: 273529900 fishing days: 69 country: Russian Federation
mmsi: 259154000 fishing days: 68 country: Norway
mmsi: 257271620 fishing days: 68 country: Norway
mmsi: 257175420 fishing days: 68 country: Norway
mmsi: 275453000 fishing days: 68 country: Latvia
mmsi: 257671700 fishing days: 68 country: Norway
mmsi: 259478000 fishing days: 68 country: Norway
mmsi: 257000410 fishing days: 68 country: Norway
mmsi: 257541500 fishing days: 68 country: Norway
mmsi: 257776500 fishing days: 67 country: Norway
mmsi: 257097840 fishing days: 67 country: Norway
mmsi: 257171020 fishing days: 67 country: Norway
mmsi: 257266920 fishing days: 66 country: Norway
mmsi: 331426000 fishing days: 66 country: Greenland - Denmark
mmsi: 275171000 fishing days: 66 country: Latvia
mmsi: 257104940 fishing days: 65 country: Norway
mmsi: 257414820 fishing days: 65 country: Norway
mmsi: 257296820 fishing days: 65 country: Norway
mmsi: 257213840 fishing days: 65 country: Norway
mmsi: 257410800 fishing days: 65 country: Norway
mmsi: 257183140 fishing days: 64 country: Norway
mmsi: 257128420 fishing days: 64 country: Norway
mmsi: 257163840 fishing days: 64 country: Norway
mmsi: 257110940 fishing days: 64 country: Norway
mmsi: 257204840 fishing days: 64 country: Norway
mmsi: 257738500 fishing days: 63 country: Norway
mmsi: 257117820 fishing days: 63 country: Norway
mmsi: 257102440 fishing days: 63 country: Norway
mmsi: 251360110 fishing days: 63 country: Iceland
mmsi: 257648500 fishing days: 63 country: Norway
mmsi: 257580600 fishing days: 62 country: Norway
mmsi: 257933500 fishing days: 62 country: Norway
mmsi: 257333220 fishing days: 62 country: Norway
mmsi: 257130240 fishing days: 62 country: Norway
mmsi: 257452620 fishing days: 62 country: Norway
mmsi: 259519000 fishing days: 61 country: Norway
mmsi: 257773500 fishing days: 61 country: Norway
mmsi: 273894000 fishing days: 61 country: Russian Federation
mmsi: 257085900 fishing days: 61 country: Norway
mmsi: 257134720 fishing days: 61 country: Norway
mmsi: 257418120 fishing days: 61 country: Norway
mmsi: 257201940 fishing days: 60 country: Norway
mmsi: 211373830 fishing days: 60 country: Germany
mmsi: 258002320 fishing days: 60 country: Norway
mmsi: 257149000 fishing days: 60 country: Norway
mmsi: 257195420 fishing days: 60 country: Norway
mmsi: 257391620 fishing days: 59 country: Norway
mmsi: 257697340 fishing days: 59 country: Norway
mmsi: 257817500 fishing days: 59 country: Norway
mmsi: 211272580 fishing days: 58 country: Germany
mmsi: 257072440 fishing days: 58 country: Norway
mmsi: 257374320 fishing days: 58 country: Norway
mmsi: 257209940 fishing days: 58 country: Norway
mmsi: 257008720 fishing days: 58 country: Norway
mmsi: 257405500 fishing days: 58 country: Norway
mmsi: 257262700 fishing days: 58 country: Norway
mmsi: 257599800 fishing days: 58 country: Norway
mmsi: 257589500 fishing days: 57 country: Norway
mmsi: 257169320 fishing days: 57 country: Norway
mmsi: 257446500 fishing days: 57 country: Norway
mmsi: 257543500 fishing days: 57 country: Norway
mmsi: 257382220 fishing days: 56 country: Norway
mmsi: 257437020 fishing days: 56 country: Norway
mmsi: 258519510 fishing days: 56 country: Norway
mmsi: 257148620 fishing days: 56 country: Norway
mmsi: 257634700 fishing days: 55 country: Norway
mmsi: 257119940 fishing days: 55 country: Norway
mmsi: 257185440 fishing days: 55 country: Norway
mmsi: 257103840 fishing days: 54 country: Norway
mmsi: 257618800 fishing days: 53 country: Norway
mmsi: 257508600 fishing days: 53 country: Norway
mmsi: 257012540 fishing days: 53 country: Norway
mmsi: 259563000 fishing days: 53 country: Norway
mmsi: 257285220 fishing days: 53 country: Norway
mmsi: 257205040 fishing days: 53 country: Norway
mmsi: 257164340 fishing days: 52 country: Norway
mmsi: 257432500 fishing days: 52 country: Norway
mmsi: 257084040 fishing days: 52 country: Norway
mmsi: 257362320 fishing days: 52 country: Norway
mmsi: 227360000 fishing days: 52 country: France
mmsi: 257101030 fishing days: 51 country: Norway
mmsi: 257440420 fishing days: 51 country: Norway
mmsi: 251026000 fishing days: 51 country: Iceland
mmsi: 257308840 fishing days: 51 country: Norway
mmsi: 257569600 fishing days: 51 country: Norway
mmsi: 257071640 fishing days: 51 country: Norway
mmsi: 257311740 fishing days: 50 country: Norway
mmsi: 331036000 fishing days: 50 country: Greenland - Denmark
mmsi: 257082720 fishing days: 49 country: Norway
mmsi: 257106540 fishing days: 49 country: Norway
mmsi: 273524300 fishing days: 49 country: Russian Federation
mmsi: 257150920 fishing days: 49 country: Norway
mmsi: 257317340 fishing days: 49 country: Norway
mmsi: 257308940 fishing days: 49 country: Norway
mmsi: 257208940 fishing days: 49 country: Norway
mmsi: 257105640 fishing days: 48 country: Norway
mmsi: 257301840 fishing days: 48 country: Norway
mmsi: 273449510 fishing days: 48 country: Russian Federation
mmsi: 257345220 fishing days: 48 country: Norway
mmsi: 257012640 fishing days: 48 country: Norway
mmsi: 250103700 fishing days: 48 country: Ireland
mmsi: 257008740 fishing days: 47 country: Norway
mmsi: 257192240 fishing days: 47 country: Norway
mmsi: 257460720 fishing days: 47 country: Norway
mmsi: 257650500 fishing days: 47 country: Norway
mmsi: 275454000 fishing days: 46 country: Latvia
mmsi: 257835170 fishing days: 46 country: Norway
mmsi: 257300940 fishing days: 46 country: Norway
mmsi: 257128920 fishing days: 46 country: Norway
mmsi: 251486540 fishing days: 46 country: Iceland
mmsi: 257729500 fishing days: 46 country: Norway
mmsi: 257223620 fishing days: 45 country: Norway
mmsi: 257359120 fishing days: 45 country: Norway
mmsi: 257249020 fishing days: 45 country: Norway
mmsi: 257074640 fishing days: 45 country: Norway
mmsi: 266273000 fishing days: 45 country: Sweden
mmsi: 257124640 fishing days: 45 country: Norway
mmsi: 257470500 fishing days: 44 country: Norway
mmsi: 257035600 fishing days: 44 country: Norway
mmsi: 331208000 fishing days: 44 country: Greenland - Denmark
mmsi: 257606600 fishing days: 44 country: Norway
mmsi: 257123840 fishing days: 44 country: Norway
mmsi: 257210340 fishing days: 44 country: Norway
mmsi: 257189040 fishing days: 44 country: Norway
mmsi: 257161320 fishing days: 44 country: Norway
mmsi: 257404120 fishing days: 43 country: Norway
mmsi: 257074540 fishing days: 43 country: Norway
mmsi: 257023540 fishing days: 43 country: Norway
mmsi: 273529800 fishing days: 43 country: Russian Federation
mmsi: 257309020 fishing days: 43 country: Norway
mmsi: 257742500 fishing days: 43 country: Norway
mmsi: 257445000 fishing days: 43 country: Norway
mmsi: 257142520 fishing days: 43 country: Norway
mmsi: 257809500 fishing days: 43 country: Norway
mmsi: 257172820 fishing days: 43 country: Norway
mmsi: 257170340 fishing days: 43 country: Norway
mmsi: 257775500 fishing days: 43 country: Norway
mmsi: 257177500 fishing days: 43 country: Norway
mmsi: 257138620 fishing days: 42 country: Norway
mmsi: 257547600 fishing days: 42 country: Norway
mmsi: 259127000 fishing days: 42 country: Norway
mmsi: 257205220 fishing days: 42 country: Norway
mmsi: 257098320 fishing days: 42 country: Norway
mmsi: 257311140 fishing days: 42 country: Norway
mmsi: 257853190 fishing days: 42 country: Norway
mmsi: 259396000 fishing days: 42 country: Norway
mmsi: 257282120 fishing days: 41 country: Norway
mmsi: 257360020 fishing days: 41 country: Norway
mmsi: 257215920 fishing days: 40 country: Norway
mmsi: 257302140 fishing days: 40 country: Norway
mmsi: 257162600 fishing days: 40 country: Norway
mmsi: 257597600 fishing days: 40 country: Norway
mmsi: 257101940 fishing days: 40 country: Norway
mmsi: 257075540 fishing days: 40 country: Norway
mmsi: 257147020 fishing days: 40 country: Norway
mmsi: 257670500 fishing days: 40 country: Norway
mmsi: 257310740 fishing days: 40 country: Norway
mmsi: 257716720 fishing days: 40 country: Norway
mmsi: 257423900 fishing days: 40 country: Norway
mmsi: 257086840 fishing days: 39 country: Norway
mmsi: 257484700 fishing days: 39 country: Norway
mmsi: 257337120 fishing days: 39 country: Norway
mmsi: 257714500 fishing days: 39 country: Norway
mmsi: 257172920 fishing days: 39 country: Norway
mmsi: 257151240 fishing days: 39 country: Norway
mmsi: 257160640 fishing days: 39 country: Norway
mmsi: 257200620 fishing days: 39 country: Norway
mmsi: 257612500 fishing days: 39 country: Norway
mmsi: 257354920 fishing days: 39 country: Norway
mmsi: 257070940 fishing days: 38 country: Norway
mmsi: 251015000 fishing days: 38 country: Iceland
mmsi: 258503910 fishing days: 38 country: Norway
mmsi: 257587600 fishing days: 38 country: Norway
mmsi: 259263000 fishing days: 38 country: Norway
mmsi: 257348620 fishing days: 37 country: Norway
mmsi: 257085540 fishing days: 37 country: Norway
mmsi: 257559600 fishing days: 37 country: Norway
mmsi: 251174000 fishing days: 37 country: Iceland
mmsi: 257148520 fishing days: 36 country: Norway
mmsi: 257251600 fishing days: 36 country: Norway
mmsi: 257053440 fishing days: 36 country: Norway
mmsi: 257152740 fishing days: 35 country: Norway
mmsi: 251793540 fishing days: 35 country: Iceland
mmsi: 273299100 fishing days: 35 country: Russian Federation
mmsi: 257201900 fishing days: 35 country: Norway
mmsi: 259146000 fishing days: 35 country: Norway
mmsi: 257079240 fishing days: 35 country: Norway
mmsi: 257570500 fishing days: 35 country: Norway
mmsi: 257066540 fishing days: 35 country: Norway
mmsi: 220544000 fishing days: 34 country: Denmark
mmsi: 257297120 fishing days: 34 country: Norway
mmsi: 257152520 fishing days: 34 country: Norway
mmsi: 257198000 fishing days: 33 country: Norway
mmsi: 257043540 fishing days: 33 country: Norway
mmsi: 257054800 fishing days: 33 country: Norway
mmsi: 257309740 fishing days: 33 country: Norway
mmsi: 257001210 fishing days: 33 country: Norway
mmsi: 257126740 fishing days: 33 country: Norway
mmsi: 259607000 fishing days: 32 country: Norway
mmsi: 273298600 fishing days: 32 country: Russian Federation
mmsi: 257219020 fishing days: 32 country: Norway
mmsi: 257109540 fishing days: 32 country: Norway
mmsi: 257152420 fishing days: 31 country: Norway
mmsi: 257216020 fishing days: 31 country: Norway
mmsi: 257645800 fishing days: 31 country: Norway
mmsi: 259245000 fishing days: 31 country: Norway
mmsi: 257014600 fishing days: 31 country: Norway
mmsi: 257168240 fishing days: 31 country: Norway
mmsi: 258541000 fishing days: 31 country: Norway
mmsi: 257213920 fishing days: 31 country: Norway
mmsi: 257413500 fishing days: 30 country: Norway
mmsi: 263565000 fishing days: 30 country: Portugal
mmsi: 258308000 fishing days: 30 country: Norway
mmsi: 257303920 fishing days: 30 country: Norway
mmsi: 257130040 fishing days: 30 country: Norway
mmsi: 257662500 fishing days: 30 country: Norway
mmsi: 257515600 fishing days: 30 country: Norway
mmsi: 257155740 fishing days: 30 country: Norway
mmsi: 273439220 fishing days: 29 country: Russian Federation
mmsi: 259689000 fishing days: 29 country: Norway
mmsi: 257020940 fishing days: 29 country: Norway
mmsi: 257095640 fishing days: 29 country: Norway
mmsi: 257233520 fishing days: 29 country: Norway
mmsi: 257485320 fishing days: 29 country: Norway
mmsi: 257259220 fishing days: 29 country: Norway
mmsi: 257488620 fishing days: 29 country: Norway
mmsi: 235092091 fishing days: 29 country: United Kingdom of Great Britain and Northern Ireland
mmsi: 257211340 fishing days: 28 country: Norway
mmsi: 257108620 fishing days: 28 country: Norway
mmsi: 257034800 fishing days: 28 country: Norway
mmsi: 257004640 fishing days: 28 country: Norway
mmsi: 667001255 fishing days: 27 country: Sierra Leone
mmsi: 231210000 fishing days: 27 country: Faroe Islands - Denmark
mmsi: 257302420 fishing days: 27 country: Norway
mmsi: 257215240 fishing days: 27 country: Norway
mmsi: 257561500 fishing days: 26 country: Norway
mmsi: 257636600 fishing days: 26 country: Norway
mmsi: 257422320 fishing days: 26 country: Norway
mmsi: 257125020 fishing days: 26 country: Norway
mmsi: 257505700 fishing days: 26 country: Norway
mmsi: 258078000 fishing days: 26 country: Norway
mmsi: 259200000 fishing days: 25 country: Norway
mmsi: 257499500 fishing days: 25 country: Norway
mmsi: 257069740 fishing days: 25 country: Norway
mmsi: 258194000 fishing days: 25 country: Norway
mmsi: 245267000 fishing days: 25 country: Netherlands
mmsi: 257303940 fishing days: 25 country: Norway
mmsi: 257141720 fishing days: 25 country: Norway
mmsi: 273240600 fishing days: 25 country: Russian Federation
mmsi: 257062640 fishing days: 25 country: Norway
mmsi: 257050440 fishing days: 25 country: Norway
mmsi: 257649500 fishing days: 24 country: Norway
mmsi: 257345720 fishing days: 24 country: Norway
mmsi: 257883500 fishing days: 24 country: Norway
mmsi: 257614700 fishing days: 24 country: Norway
mmsi: 258054000 fishing days: 24 country: Norway
mmsi: 257969500 fishing days: 24 country: Norway
mmsi: 257107700 fishing days: 24 country: Norway
mmsi: 257573800 fishing days: 24 country: Norway
mmsi: 257087040 fishing days: 24 country: Norway
mmsi: 257459500 fishing days: 24 country: Norway
mmsi: 257150140 fishing days: 24 country: Norway
mmsi: 257665700 fishing days: 23 country: Norway
mmsi: 258015500 fishing days: 23 country: Norway
mmsi: 257567500 fishing days: 23 country: Norway
mmsi: 257307240 fishing days: 23 country: Norway
mmsi: 257233500 fishing days: 23 country: Norway
mmsi: 251097000 fishing days: 23 country: Iceland
mmsi: 257128020 fishing days: 22 country: Norway
mmsi: 257124420 fishing days: 22 country: Norway
mmsi: 258130630 fishing days: 22 country: Norway
mmsi: 257124500 fishing days: 22 country: Norway
mmsi: 257116740 fishing days: 22 country: Norway
mmsi: 257088540 fishing days: 22 country: Norway
mmsi: 257651500 fishing days: 22 country: Norway
mmsi: 257179640 fishing days: 21 country: Norway
mmsi: 257679500 fishing days: 21 country: Norway
mmsi: 257304840 fishing days: 21 country: Norway
mmsi: 257177040 fishing days: 21 country: Norway
mmsi: 257010940 fishing days: 21 country: Norway
mmsi: 257774500 fishing days: 21 country: Norway
mmsi: 257475120 fishing days: 21 country: Norway
mmsi: 257985270 fishing days: 21 country: Norway
mmsi: 258324000 fishing days: 21 country: Norway
mmsi: 257409820 fishing days: 21 country: Norway
mmsi: 257132720 fishing days: 20 country: Norway
mmsi: 257041940 fishing days: 20 country: Norway
mmsi: 257005640 fishing days: 20 country: Norway
mmsi: 257119340 fishing days: 20 country: Norway
mmsi: 257115220 fishing days: 20 country: Norway
mmsi: 257156040 fishing days: 20 country: Norway
mmsi: 257638500 fishing days: 20 country: Norway
mmsi: 257031140 fishing days: 20 country: Norway
mmsi: 257559800 fishing days: 20 country: Norway
mmsi: 257237800 fishing days: 20 country: Norway
mmsi: 259392000 fishing days: 20 country: Norway
mmsi: 257859260 fishing days: 20 country: Norway
mmsi: 257117500 fishing days: 20 country: Norway
mmsi: 257251900 fishing days: 20 country: Norway
mmsi: 258045000 fishing days: 19 country: Norway
mmsi: 263533000 fishing days: 19 country: Portugal
mmsi: 257675500 fishing days: 19 country: Norway
mmsi: 257071340 fishing days: 19 country: Norway
mmsi: 257074740 fishing days: 19 country: Norway
mmsi: 258149700 fishing days: 19 country: Norway
mmsi: 258996140 fishing days: 18 country: Norway
mmsi: 257645500 fishing days: 17 country: Norway
mmsi: 257003910 fishing days: 17 country: Norway
mmsi: 251458000 fishing days: 17 country: Iceland
mmsi: 257591600 fishing days: 17 country: Norway
mmsi: 257162640 fishing days: 17 country: Norway
mmsi: 257735500 fishing days: 17 country: Norway
mmsi: 257938500 fishing days: 17 country: Norway
mmsi: 257116000 fishing days: 17 country: Norway
mmsi: 257163120 fishing days: 17 country: Norway
mmsi: 257202940 fishing days: 17 country: Norway
mmsi: 259682000 fishing days: 16 country: Norway
mmsi: 257209040 fishing days: 16 country: Norway
mmsi: 257688500 fishing days: 16 country: Norway
mmsi: 257625500 fishing days: 16 country: Norway
mmsi: 257005610 fishing days: 16 country: Norway
mmsi: 257430820 fishing days: 16 country: Norway
mmsi: 257823500 fishing days: 16 country: Norway
mmsi: 257613500 fishing days: 15 country: Norway
mmsi: 257310840 fishing days: 15 country: Norway
mmsi: 257608600 fishing days: 15 country: Norway
mmsi: 258036000 fishing days: 15 country: Norway
mmsi: 259508000 fishing days: 15 country: Norway
mmsi: 257053240 fishing days: 15 country: Norway
mmsi: 273428300 fishing days: 15 country: Russian Federation
mmsi: 257212520 fishing days: 15 country: Norway
mmsi: 257671500 fishing days: 15 country: Norway
mmsi: 258547000 fishing days: 15 country: Norway
mmsi: 257816940 fishing days: 14 country: Norway
mmsi: 259111000 fishing days: 14 country: Norway
mmsi: 257226520 fishing days: 14 country: Norway
mmsi: 257011140 fishing days: 14 country: Norway
mmsi: 259130000 fishing days: 14 country: Norway
mmsi: 257221640 fishing days: 14 country: Norway
mmsi: 257254920 fishing days: 14 country: Norway
mmsi: 273217700 fishing days: 14 country: Russian Federation
mmsi: 257083340 fishing days: 14 country: Norway
mmsi: 257593600 fishing days: 14 country: Norway
mmsi: 257200220 fishing days: 14 country: Norway
mmsi: 259697000 fishing days: 14 country: Norway
mmsi: 257183500 fishing days: 13 country: Norway
mmsi: 258035000 fishing days: 13 country: Norway
mmsi: 257134620 fishing days: 13 country: Norway
mmsi: 259281000 fishing days: 13 country: Norway
mmsi: 257102940 fishing days: 13 country: Norway
mmsi: 257305840 fishing days: 13 country: Norway
mmsi: 257173620 fishing days: 13 country: Norway
mmsi: 257215000 fishing days: 13 country: Norway
mmsi: 259132000 fishing days: 13 country: Norway
mmsi: 257361320 fishing days: 13 country: Norway
mmsi: 257151420 fishing days: 13 country: Norway
mmsi: 273310630 fishing days: 13 country: Russian Federation
mmsi: 257079040 fishing days: 13 country: Norway
mmsi: 257501600 fishing days: 13 country: Norway
mmsi: 257004110 fishing days: 12 country: Norway
mmsi: 257132340 fishing days: 12 country: Norway
mmsi: 257357120 fishing days: 12 country: Norway
mmsi: 257488600 fishing days: 12 country: Norway
mmsi: 257045240 fishing days: 12 country: Norway
mmsi: 259122000 fishing days: 12 country: Norway
mmsi: 257439820 fishing days: 12 country: Norway
mmsi: 257287500 fishing days: 12 country: Norway
mmsi: 257578600 fishing days: 12 country: Norway
mmsi: 273332560 fishing days: 12 country: Russian Federation
mmsi: 257429720 fishing days: 12 country: Norway
mmsi: 257303000 fishing days: 12 country: Norway
mmsi: 258544000 fishing days: 12 country: Norway
mmsi: 257632500 fishing days: 12 country: Norway
mmsi: 258412000 fishing days: 11 country: Norway
mmsi: 257193820 fishing days: 11 country: Norway
mmsi: 257725500 fishing days: 11 country: Norway
mmsi: 257066940 fishing days: 11 country: Norway
mmsi: 257222620 fishing days: 11 country: Norway
mmsi: 257183920 fishing days: 11 country: Norway
mmsi: 257313040 fishing days: 11 country: Norway
mmsi: 257451820 fishing days: 11 country: Norway
mmsi: 257129840 fishing days: 11 country: Norway
mmsi: 257795500 fishing days: 10 country: Norway
mmsi: 257767390 fishing days: 10 country: Norway
mmsi: 259324000 fishing days: 10 country: Norway
mmsi: 257140920 fishing days: 10 country: Norway
mmsi: 259675000 fishing days: 10 country: Norway
mmsi: 257395520 fishing days: 10 country: Norway
mmsi: 257030740 fishing days: 10 country: Norway
mmsi: 259612000 fishing days: 10 country: Norway
mmsi: 257416420 fishing days: 10 country: Norway
mmsi: 273532110 fishing days: 10 country: Russian Federation
mmsi: 257966500 fishing days: 10 country: Norway
mmsi: 257810500 fishing days: 10 country: Norway
mmsi: 257537500 fishing days: 10 country: Norway
mmsi: 273558300 fishing days: 10 country: Russian Federation
mmsi: 257218040 fishing days: 10 country: Norway
mmsi: 257154020 fishing days: 9 country: Norway
mmsi: 257364120 fishing days: 9 country: Norway
mmsi: 257865500 fishing days: 9 country: Norway
mmsi: 257831500 fishing days: 9 country: Norway
mmsi: 257412800 fishing days: 9 country: Norway
mmsi: 258518710 fishing days: 9 country: Norway
mmsi: 257469820 fishing days: 9 country: Norway
mmsi: 257732500 fishing days: 9 country: Norway
mmsi: 257154220 fishing days: 9 country: Norway
mmsi: 257174220 fishing days: 9 country: Norway
mmsi: 257591700 fishing days: 9 country: Norway
mmsi: 257487700 fishing days: 9 country: Norway
mmsi: 257144240 fishing days: 9 country: Norway
mmsi: 258217000 fishing days: 9 country: Norway
mmsi: 257096140 fishing days: 9 country: Norway
mmsi: 257757000 fishing days: 9 country: Norway
mmsi: 257040440 fishing days: 8 country: Norway
mmsi: 257024900 fishing days: 8 country: Norway
mmsi: 257328520 fishing days: 8 country: Norway
mmsi: 257061640 fishing days: 8 country: Norway
mmsi: 259432000 fishing days: 8 country: Norway
mmsi: 257571600 fishing days: 8 country: Norway
mmsi: 257202320 fishing days: 8 country: Norway
mmsi: 257026440 fishing days: 8 country: Norway
mmsi: 257304820 fishing days: 8 country: Norway
mmsi: 258138000 fishing days: 8 country: Norway
mmsi: 257156500 fishing days: 8 country: Norway
mmsi: 257160020 fishing days: 8 country: Norway
mmsi: 257256420 fishing days: 8 country: Norway
mmsi: 257079740 fishing days: 8 country: Norway
mmsi: 257327000 fishing days: 8 country: Norway
mmsi: 257102640 fishing days: 7 country: Norway
mmsi: 257139120 fishing days: 7 country: Norway
mmsi: 259619000 fishing days: 7 country: Norway
mmsi: 257129140 fishing days: 7 country: Norway
mmsi: 258314000 fishing days: 7 country: Norway
mmsi: 257166920 fishing days: 7 country: Norway
mmsi: 257768500 fishing days: 7 country: Norway
mmsi: 257564600 fishing days: 7 country: Norway
mmsi: 257104720 fishing days: 7 country: Norway
mmsi: 257212500 fishing days: 7 country: Norway
mmsi: 331480000 fishing days: 7 country: Greenland - Denmark
mmsi: 257117320 fishing days: 7 country: Norway
mmsi: 257333120 fishing days: 7 country: Norway
mmsi: 273534110 fishing days: 7 country: Russian Federation
mmsi: 258095000 fishing days: 7 country: Norway
mmsi: 257081240 fishing days: 7 country: Norway
mmsi: 257437000 fishing days: 6 country: Norway
mmsi: 257077240 fishing days: 6 country: Norway
mmsi: 257309220 fishing days: 6 country: Norway
mmsi: 259113000 fishing days: 6 country: Norway
mmsi: 259651000 fishing days: 6 country: Norway
mmsi: 257189640 fishing days: 6 country: Norway
mmsi: 258987930 fishing days: 6 country: Norway
mmsi: 258071000 fishing days: 6 country: Norway
mmsi: 257120500 fishing days: 6 country: Norway
mmsi: 257160140 fishing days: 6 country: Norway
mmsi: 259374000 fishing days: 6 country: Norway
mmsi: 257157740 fishing days: 6 country: Norway
mmsi: 257392600 fishing days: 6 country: Norway
mmsi: 246429000 fishing days: 6 country: Netherlands
mmsi: 257346120 fishing days: 6 country: Norway
mmsi: 257018140 fishing days: 6 country: Norway
mmsi: 257518600 fishing days: 6 country: Norway
mmsi: 257042640 fishing days: 6 country: Norway
mmsi: 257138120 fishing days: 6 country: Norway
mmsi: 257204940 fishing days: 5 country: Norway
mmsi: 257629000 fishing days: 5 country: Norway
mmsi: 257629500 fishing days: 5 country: Norway
mmsi: 257131020 fishing days: 5 country: Norway
mmsi: 257497500 fishing days: 5 country: Norway
mmsi: 257601600 fishing days: 5 country: Norway
mmsi: 257195840 fishing days: 5 country: Norway
mmsi: 257059340 fishing days: 5 country: Norway
mmsi: 257071440 fishing days: 5 country: Norway
mmsi: 257147900 fishing days: 5 country: Norway
mmsi: 240137000 fishing days: 5 country: Greece
mmsi: 257313640 fishing days: 5 country: Norway
mmsi: 257422120 fishing days: 5 country: Norway
mmsi: 263516000 fishing days: 5 country: Portugal
mmsi: 224430000 fishing days: 5 country: Spain
mmsi: 257190720 fishing days: 5 country: Norway
mmsi: 244799000 fishing days: 5 country: Netherlands
mmsi: 259476000 fishing days: 5 country: Norway
mmsi: 259475000 fishing days: 5 country: Norway
mmsi: 257312220 fishing days: 4 country: Norway
mmsi: 257277620 fishing days: 4 country: Norway
mmsi: 259855000 fishing days: 4 country: Norway
mmsi: 257308140 fishing days: 4 country: Norway
mmsi: 257434720 fishing days: 4 country: Norway
mmsi: 257587500 fishing days: 4 country: Norway
mmsi: 257000810 fishing days: 4 country: Norway
mmsi: 257035040 fishing days: 4 country: Norway
mmsi: 259242000 fishing days: 4 country: Norway
mmsi: 257006704 fishing days: 4 country: Norway
mmsi: 257004210 fishing days: 4 country: Norway
mmsi: 257022900 fishing days: 4 country: Norway
mmsi: 257176620 fishing days: 4 country: Norway
mmsi: 238102540 fishing days: 4 country: Croatia
mmsi: 257620500 fishing days: 4 country: Norway
mmsi: 259597000 fishing days: 4 country: Norway
mmsi: 257964500 fishing days: 4 country: Norway
mmsi: 257313720 fishing days: 4 country: Norway
mmsi: 259388000 fishing days: 4 country: Norway
mmsi: 258265000 fishing days: 4 country: Norway
mmsi: 238000005 fishing days: 4 country: Croatia
mmsi: 257062940 fishing days: 4 country: Norway
mmsi: 257160600 fishing days: 4 country: Norway
mmsi: 257134500 fishing days: 4 country: Norway
mmsi: 245084000 fishing days: 4 country: Netherlands
mmsi: 257440500 fishing days: 4 country: Norway
mmsi: 864000143 fishing days: 4 country: invalid mmsi
mmsi: 257187740 fishing days: 4 country: Norway
mmsi: 237697000 fishing days: 4 country: Greece
mmsi: 257791500 fishing days: 4 country: Norway
mmsi: 257602250 fishing days: 3 country: Norway
mmsi: 259595000 fishing days: 3 country: Norway
mmsi: 257681500 fishing days: 3 country: Norway
mmsi: 257226320 fishing days: 3 country: Norway
mmsi: 259501000 fishing days: 3 country: Norway
mmsi: 257312640 fishing days: 3 country: Norway
mmsi: 257017440 fishing days: 3 country: Norway
mmsi: 259205000 fishing days: 3 country: Norway
mmsi: 257452220 fishing days: 3 country: Norway
mmsi: 247121730 fishing days: 3 country: Italy
mmsi: 257603600 fishing days: 3 country: Norway
mmsi: 258303000 fishing days: 3 country: Norway
mmsi: 257180440 fishing days: 3 country: Norway
mmsi: 259290000 fishing days: 3 country: Norway
mmsi: 257731500 fishing days: 3 country: Norway
mmsi: 257215740 fishing days: 3 country: Norway
mmsi: 257143740 fishing days: 3 country: Norway
mmsi: 239233000 fishing days: 3 country: Greece
mmsi: 259653000 fishing days: 3 country: Norway
mmsi: 273240900 fishing days: 3 country: Russian Federation
mmsi: 257000440 fishing days: 3 country: Norway
mmsi: 257038940 fishing days: 3 country: Norway
mmsi: 257317120 fishing days: 3 country: Norway
mmsi: 257345520 fishing days: 3 country: Norway
mmsi: 259340000 fishing days: 3 country: Norway
mmsi: 258654000 fishing days: 3 country: Norway
mmsi: 257106520 fishing days: 3 country: Norway
mmsi: 257180500 fishing days: 3 country: Norway
mmsi: 259286000 fishing days: 2 country: Norway
mmsi: 257189600 fishing days: 2 country: Norway
mmsi: 257057440 fishing days: 2 country: Norway
mmsi: 251138640 fishing days: 2 country: Iceland
mmsi: 257190540 fishing days: 2 country: Norway
mmsi: 247122030 fishing days: 2 country: Italy
mmsi: 257319420 fishing days: 2 country: Norway
mmsi: 257122120 fishing days: 2 country: Norway
mmsi: 257060440 fishing days: 2 country: Norway
mmsi: 257330820 fishing days: 2 country: Norway
mmsi: 238987910 fishing days: 2 country: Croatia
mmsi: 257167540 fishing days: 2 country: Norway
mmsi: 257331920 fishing days: 2 country: Norway
mmsi: 257118520 fishing days: 2 country: Norway
mmsi: 257145220 fishing days: 2 country: Norway
mmsi: 257677600 fishing days: 2 country: Norway
mmsi: 257225020 fishing days: 2 country: Norway
mmsi: 246315000 fishing days: 2 country: Netherlands
mmsi: 257187246 fishing days: 2 country: Norway
mmsi: 257171220 fishing days: 2 country: Norway
mmsi: 257109240 fishing days: 2 country: Norway
mmsi: 257284600 fishing days: 2 country: Norway
mmsi: 257193500 fishing days: 2 country: Norway
mmsi: 237801000 fishing days: 2 country: Greece
mmsi: 257770500 fishing days: 2 country: Norway
mmsi: 982325550 fishing days: 2 country: invalid mmsi
mmsi: 259586000 fishing days: 2 country: Norway
mmsi: 257111940 fishing days: 2 country: Norway
mmsi: 257157120 fishing days: 2 country: Norway
mmsi: 257057240 fishing days: 2 country: Norway
mmsi: 257190440 fishing days: 2 country: Norway
mmsi: 257888000 fishing days: 2 country: Norway
mmsi: 237431000 fishing days: 2 country: Greece
mmsi: 257150700 fishing days: 2 country: Norway
mmsi: 257104340 fishing days: 2 country: Norway
mmsi: 257028500 fishing days: 2 country: Norway
mmsi: 238000010 fishing days: 2 country: Croatia
mmsi: 258317500 fishing days: 2 country: Norway
mmsi: 273258100 fishing days: 2 country: Russian Federation
mmsi: 238998210 fishing days: 2 country: Croatia
mmsi: 257108040 fishing days: 1 country: Norway
mmsi: 25920500 fishing days: 1 country: invalid mmsi
mmsi: 257113220 fishing days: 1 country: Norway
mmsi: 259893000 fishing days: 1 country: Norway
mmsi: 367618990 fishing days: 1 country: United States of America
mmsi: 257193220 fishing days: 1 country: Norway
mmsi: 247092320 fishing days: 1 country: Italy
mmsi: 316001843 fishing days: 1 country: Canada
mmsi: 257372000 fishing days: 1 country: Norway
mmsi: 257151120 fishing days: 1 country: Norway
mmsi: 412203247 fishing days: 1 country: China
mmsi: 257197020 fishing days: 1 country: Norway
mmsi: 257399720 fishing days: 1 country: Norway
mmsi: 257814610 fishing days: 1 country: Norway
mmsi: 247122130 fishing days: 1 country: Italy
mmsi: 261002530 fishing days: 1 country: Poland
mmsi: 701000869 fishing days: 1 country: Argentine Republic
mmsi: 258449000 fishing days: 1 country: Norway
mmsi: 257140040 fishing days: 1 country: Norway
mmsi: 257405920 fishing days: 1 country: Norway
mmsi: 257149500 fishing days: 1 country: Norway
mmsi: 247145190 fishing days: 1 country: Italy
mmsi: 257939500 fishing days: 1 country: Norway
mmsi: 238905540 fishing days: 1 country: Croatia
mmsi: 257172500 fishing days: 1 country: Norway
mmsi: 273297700 fishing days: 1 country: Russian Federation
mmsi: 257537000 fishing days: 1 country: Norway
mmsi: 247121790 fishing days: 1 country: Italy
mmsi: 257633500 fishing days: 1 country: Norway
mmsi: 701000840 fishing days: 1 country: Argentine Republic
mmsi: 247125340 fishing days: 1 country: Italy
mmsi: 257198540 fishing days: 1 country: Norway
mmsi: 257159920 fishing days: 1 country: Norway
mmsi: 257358020 fishing days: 1 country: Norway
mmsi: 238000003 fishing days: 1 country: Croatia
mmsi: 257157540 fishing days: 1 country: Norway
mmsi: 257005340 fishing days: 1 country: Norway
mmsi: 257461920 fishing days: 1 country: Norway
mmsi: 238288740 fishing days: 1 country: Croatia
mmsi: 237656000 fishing days: 1 country: Greece
mmsi: 257014540 fishing days: 1 country: Norway
mmsi: 259845000 fishing days: 1 country: Norway
mmsi: 247140770 fishing days: 1 country: Italy
mmsi: 257662450 fishing days: 1 country: Norway
mmsi: 257529800 fishing days: 1 country: Norway
mmsi: 257448500 fishing days: 1 country: Norway
mmsi: 247130410 fishing days: 1 country: Italy
mmsi: 256000656 fishing days: 1 country: Malta
mmsi: 237149000 fishing days: 1 country: Greece
mmsi: 257072740 fishing days: 1 country: Norway
mmsi: 257106640 fishing days: 1 country: Norway
mmsi: 239383000 fishing days: 1 country: Greece
mmsi: 238279740 fishing days: 1 country: Croatia
mmsi: 238390540 fishing days: 1 country: Croatia
mmsi: 238901340 fishing days: 1 country: Croatia
mmsi: 230941050 fishing days: 1 country: Finland
mmsi: 241063000 fishing days: 1 country: Greece
mmsi: 412435592 fishing days: 1 country: China
mmsi: 257071140 fishing days: 1 country: Norway
mmsi: 248000150 fishing days: 1 country: Malta
mmsi: 238308040 fishing days: 1 country: Croatia
mmsi: 247120180 fishing days: 1 country: Italy
mmsi: 247121020 fishing days: 1 country: Italy
mmsi: 238654710 fishing days: 1 country: Croatia
mmsi: 257400020 fishing days: 1 country: Norway
mmsi: 238299840 fishing days: 1 country: Croatia
mmsi: 257952500 fishing days: 1 country: Norway
mmsi: 257302040 fishing days: 1 country: Norway
mmsi: 261004050 fishing days: 1 country: Poland
mmsi: 271056019 fishing days: 1 country: Turkey
mmsi: 247082820 fishing days: 1 country: Italy
mmsi: 701000814 fishing days: 1 country: Argentine Republic
mmsi: 701000627 fishing days: 1 country: Argentine Republic
mmsi: 257300740 fishing days: 1 country: Norway
mmsi: 235006280 fishing days: 1 country: United Kingdom of Great Britain and Northern Ireland
mmsi: 257138720 fishing days: 1 country: Norway
mmsi: 238429040 fishing days: 1 country: Croatia
mmsi: 257003330 fishing days: 1 country: Norway
mmsi: 257029240 fishing days: 1 country: Norway
mmsi: 257741500 fishing days: 1 country: Norway
mmsi: 247125680 fishing days: 1 country: Italy
mmsi: 238104240 fishing days: 1 country: Croatia
mmsi: 238117240 fishing days: 1 country: Croatia
In [26]:
# Now Group by Country
q = '''
SELECT
country,
sum(number) number
from
(select a.mmsi mmsi,
a.number number,
if(b.country is null, "invalid mmsi",b.country) country,
b.continent continent
from
(select mmsi,
integer(if(length(string(mmsi))= 9,LEFT(STRING(mmsi),3), '0')) code,
count(*) number from
(SELECT
mmsi,
date(timestamp) date,
first(latitude) lat,
first(longitude) lon
FROM
[tilesets.pipeline_2015_08_24_08_19_01]
WHERE
latitude > '''+str(min_lat)+'''
AND latitude <'''+str(max_lat)+'''
AND longitude > '''+str(min_lon)+'''
AND longitude < '''+str(max_lon)+'''
AND weight >=.5
group by mmsi, date)
group by mmsi, code
)
a
left join [scratch_roan.country_code] b
on a.code = b.code)
group by country
order by number desc'''
country_groups = Query(q)
Waiting on bqjob_rff9f1bef0215549_0000015434c264e8_10 ... (3s) Current status: DONE
Query time: 5.40917086601 seconds.
In [27]:
print "days\tcountry"
for c in country_groups:
print c[1],'\t', c[0].split(" (")[0]
days country
80096 Norway
36251 Russian Federation
1898 Faroe Islands - Denmark
1427 Iceland
1301 Spain
1161 Lithuania
629 Estonia
593 Latvia
412 Greenland - Denmark
349 United Kingdom of Great Britain and Northern Ireland
223 Poland
196 Germany
182 invalid mmsi
160 Denmark
139 France
54 Portugal
48 Ireland
45 Sweden
42 Netherlands
27 Sierra Leone
26 Croatia
20 Greece
16 Italy
4 Argentine Republic
2 Malta
2 China
1 Canada
1 Turkey
1 United States of America
1 Finland
In [28]:
objects = [c[0].split(" (")[0] for c in country_groups]
y_pos = np.arange(len(objects))
performance = [c[1] for c in country_groups]
plt.figure(figsize=(12,4))
plt.bar(y_pos-4, performance, align='center', alpha=0.5,)
plt.xticks(y_pos-4+.2, objects, fontsize=12) # rotation=45
locs, labels = plt.xticks()
plt.setp(labels, rotation=45,ha='right')
plt.ylabel('Usage',fontsize=12)
plt.title('Fishing Days by Country in Mascarene Plateau, Jan 2014 to July 2015',fontsize=15)
ax = plt.axes()
ax.xaxis.set_ticks_position('none')
plt.savefig("fishing_effort_mascarene_by_Country.png",bbox_inches='tight',dpi=150,transparent=True,pad_inches=.1)
plt.show()
In [29]:
# Now Group by Country
q = '''
SELECT
lat,
lon,
count(*) fishing_days
from
(SELECT
mmsi,
date(timestamp) date,
integer(first(latitude)*4) lat,
integer(first(longitude)*4) lon
FROM
[tilesets.pipeline_2015_08_24_08_19_01]
WHERE
latitude > '''+str(min_lat)+'''
AND latitude <'''+str(max_lat)+'''
AND longitude > '''+str(min_lon)+'''
AND longitude < '''+str(max_lon)+'''
AND weight >=.5
group by mmsi, date)
group by lat, lon
'''
fishing_grid = Query(q)
Waiting on bqjob_r4ad3af582b718a54_0000015434c27df7_11 ... (2s) Current status: DONE
Query time: 4.65414690971 seconds.
In [30]:
cellsize = .25
one_over_cellsize = 4
num_lats = (max_lat-min_lat)*one_over_cellsize+1
num_lons = (max_lon-min_lon)*one_over_cellsize+1
grid = np.zeros(shape=(num_lats,num_lons))
for row in fishing_grid:
lat = int(row[0])
lon = int(row[1])
lat_index = lat-min_lat*one_over_cellsize
lon_index = lon-min_lon*one_over_cellsize
grid[lat_index][lon_index] = int(row[2])
In [32]:
plt.rcParams["figure.figsize"] = [8,9]
firstlat = max_lat
lastlat = min_lat
firstlon = min_lon
lastlon = max_lon
scale = cellsize
numlats = int((firstlat-lastlat)/scale+.5)
numlons = int((lastlon-firstlon)/scale+.5)
lat_boxes = np.linspace(lastlat,firstlat,num=numlats,endpoint=False)
lon_boxes = np.linspace(firstlon,lastlon,num=numlons,endpoint=False)
fig = plt.figure()
extra = 0
m = Basemap(llcrnrlat=lastlat-extra, urcrnrlat=firstlat+extra,
llcrnrlon=firstlon-extra, urcrnrlon=lastlon+extra, lat_ts=0, projection='mill',resolution="h")
m.drawmapboundary()#fill_color='#111111')
m.drawcoastlines(linewidth=.2)
m.fillcontinents('#cccccc',lake_color='#cccccc')#, lake_color, ax, zorder, alpha)
x = np.linspace(firstlon, lastlon, -(firstlon-lastlon)*one_over_cellsize+1)
y = np.linspace(lastlat, firstlat, (firstlat-lastlat)*one_over_cellsize+1)
x, y = np.meshgrid(x, y)
converted_x, converted_y = m(x, y)
from matplotlib import colors,colorbar
maximum = grid.max()
minimum = 1
norm = colors.LogNorm(vmin=minimum, vmax=maximum)
# norm = colors.Normalize(vmin=0, vmax=1000)
m.pcolormesh(converted_x, converted_y, grid, norm=norm, vmin=minimum, vmax=maximum, cmap = plt.get_cmap('viridis'))
t = "Fishing Days Jan 2014 to July 2015"
plt.title(t, color = "#000000", fontsize=18)
ax = fig.add_axes([0.2, 0.1, 0.65, 0.02]) #x coordinate ,
norm = colors.LogNorm(vmin=minimum, vmax=maximum)
# norm = colors.Normalize(vmin=0, vmax=1000)
lvls = np.logspace(np.log10(minimum),np.log10(maximum),num=8)
cb = colorbar.ColorbarBase(ax,norm = norm, orientation='horizontal', ticks=lvls, cmap = plt.get_cmap('viridis'))
#cb.ax.set_xticklabels(["0" ,round(m3**.5,1), m3, round(m3**1.5,1), m3*m3,round(m3**2.5,1), str(round(m3**3,1))+"+"], fontsize=10)
cb.ax.set_xticklabels([int(i) for i in lvls], fontsize=10, color = "#000000")
cb.set_label('Fishing Days',labelpad=-40, y=0.45, color = "#000000")
plt.savefig("fishing_effort_barents.png",bbox_inches='tight',dpi=300,transparent=True,pad_inches=.1)
plt.show()
In [ ]:
Content source: GlobalFishingWatch/vessel-maps
Similar notebooks: