Some AIS devices on bouys and gear encode the battery charge state in the shipname. This causes a single MMSI to have many names like this
BOATY 99%
BOATY 72%
BOATY 23%
BOATY 100%
BOATY 99%
In 2018 there are ~15k unique MMSI that have this pattern
We can strip off the suffix to get a better identity with a regex like this
REGEXP_EXTRACT(shipname.value, "(.*)[[:space:]][0-9]+%$")
and there are another ~2200 that match this
REGEXP_EXTRACT(shipname.value, "(.*)[@]+[0-9]+V[0-9]?$")
eg NETFISHING@@@@@11V8
Some AIS devices on bouys and gear encode the battery charge state in the shipname. This causes a single MMSI to have many names like this
BOATY 99%
BOATY 72%
BOATY 23%
BOATY 100%
BOATY 99%
In 2018 there are ~15k unique MMSI that have this pattern
We can strip off the suffix to get a better identity with a regex like this
REGEXP_EXTRACT(shipname.value, "(.*)[[:space:]][0-9]+%$")and there are another ~2200 that match this
REGEXP_EXTRACT(shipname.value, "(.*)[@]+[0-9]+V[0-9]?$")eg
NETFISHING@@@@@11V8