Aistarget
Aistarget
Aistarget
at_mmsi,
at_callsign,
at_imo,
at_name,
'Draught' = at_draught/10.0,
'Length ' = at_length,
'Width '= at_width,
'ShipType' = at_shiptype
from aistarget
where at_mmsi is not null
and at_imo is not null
and at_callsign is not null
and at_length is not null
and at_width is not null
and at_name is not null
and at_mmsi > 100000
and at_draught> 0
and at_imo > 0
and at_callsign not like '%@%'
and at_name not like '%@%'
order by 1 asc