船舶事故等調査報告書から抽出した事故情報(事故種類、発生日時・場所、事故の概要、船舶の種類、死傷者等、気象・海象、事故の経過、原因、再発防止策 等)を有するデータ
元の資料: 船舶事故等調査報告書、海上分布予報、地方海上予報区
G空間情報センターのデータセット links-ippanryokyakuteikikourojigyou-2024 の 02_senpakujikohoukokusyo.csv を、列名を小文字にして型を付けたテーブルです。列の説明は同じデータセットのデータ仕様書から付けています。
CREATE TABLE links.ship_accidents ( no BIGINT, accident_type VARCHAR, date_and_time_of_occurrence VARCHAR, location_of_occurrence VARCHAR, accident_latitude DOUBLE, accident_longitude DOUBLE, accident_overview VARCHAR, investigation_progress VARCHAR, ship_type VARCHAR, ship_name_1 VARCHAR, gross_tonnage_1 VARCHAR, ship_number_1 VARCHAR, ship_owner_etc_1 VARCHAR, l DOUBLE, b DOUBLE, d DOUBLE, ship_material VARCHAR, engine VARCHAR, output_launch DOUBLE, crew_information VARCHAR, casualties VARCHAR, damage VARCHAR, weather_and_sea_conditions VARCHAR, accident_progress VARCHAR, other_matters VARCHAR, analysis VARCHAR, cause VARCHAR, recurrence_prevention_measures VARCHAR, reference VARCHAR, ship_type_2 VARCHAR, ship_name_2 VARCHAR, gross_tonnage_2 DOUBLE, ship_number_2 VARCHAR, ship_owner_etc_2 VARCHAR, l_2 DOUBLE, b_2 DOUBLE, d_2 DOUBLE, ship_material_2 VARCHAR, engine_2 VARCHAR, output_launch_2 DOUBLE, ship_type_3 VARCHAR, ship_name_3 VARCHAR, gross_tonnage_3 DOUBLE, ship_number_3 VARCHAR, ship_owner_etc_3 VARCHAR, l_3 DOUBLE, b_3 DOUBLE, d_3 DOUBLE, ship_material_3 VARCHAR, engine_3 VARCHAR, output_launch_3 DOUBLE, ship_type_4 VARCHAR, ship_name_4 VARCHAR, gross_tonnage_4 DOUBLE, ship_number_4 VARCHAR, ship_owner_etc_4 VARCHAR, l_4 DOUBLE, b_4 DOUBLE, d_4 DOUBLE, ship_material_4 VARCHAR, engine_4 VARCHAR, output_launch_4 DOUBLE, ship_type_5 VARCHAR, ship_name_5 VARCHAR, gross_tonnage_5 DOUBLE, ship_number_5 VARCHAR, ship_owner_etc_5 VARCHAR, l_5 DOUBLE, b_5 DOUBLE, d_5 DOUBLE, ship_material_5 VARCHAR, engine_5 VARCHAR, output_launch_5 DOUBLE, ship_type_6 VARCHAR, ship_name_6 VARCHAR, gross_tonnage_6 DOUBLE, ship_number_6 VARCHAR, ship_owner_etc_6 VARCHAR, l_6 VARCHAR, b_6 VARCHAR, d_6 VARCHAR, ship_material_6 VARCHAR, engine_6 VARCHAR, output_launch_6 VARCHAR, marine_forecast_visibility BIGINT, marine_forecast_wave_height DOUBLE, marine_forecast_wind_direction BIGINT, marine_forecast_wind_speed BIGINT, prefecture_code VARCHAR, geometry GEOMETRY, source_sha256 VARCHAR );