Two versions of the query have been copied to the folder.
v6 - Written to select high confidence matches. In the last test this had a 0% ship mismatch rate. Matches are also filtered to only include those active for atleast one month in 2015
v4 - Some name and callsign matches are included. We found a 3% ship mismatch rate.
Anyone interested in intermediate versions of the query can find them here.
https://github.com/SkyTruth/vessel-lists/tree/master/clav_matching Just add the queries for the clav matcing as sql files in this folder.