Skip to content

Name normalization for bouys #84

Description

@pwoods25443

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions