港湾別の効率性や稼動性を判定するための、総トン数別の隻数や合計総トン数の集計データ、船舶の長さ別の移出入量に関する集計データ(1622レコード)
元の資料: 港湾調査(様式NO.1 入港船舶集計表)、港湾調査(様式NO.3-3 海上貨物集計表(移出))、港湾調査(様式NO.3-4 海上貨物集計表(移入))、港湾調査(様式NO4-3 コンテナ個数・シャーシ台数集計表(移出))、港湾調査(様式NO4-4 コンテナ個数・シャーシ台数集計表(移入))
G空間情報センターのデータセット links-naikoukaiungyou-2024 の 03_kouwanchousa.csv を、列名を小文字にして型を付けたテーブルです。列の説明は同じデータセットのデータ仕様書から付けています。
CREATE TABLE links.port_survey ( port_name VARCHAR, port_rank_codei_koshu BIGINT, year BIGINT, prefecture_name VARCHAR, number_of_berths BIGINT, mooring_status_ship_count BIGINT, mooring_status_gross_tonnage BIGINT, mooring_status_total_time BIGINT, cargo_ship_count BIGINT, cargo_ship_gross_tonnage BIGINT, cargo_weight_loading BIGINT, cargo_weight_unloading BIGINT, cargo_weight_total BIGINT, mooring_status_ship_count_per_berth DOUBLE, mooring_status_gross_tonnage_per_berth DOUBLE, mooring_status_total_time_per_berth DOUBLE, cargo_ship_count_per_berth DOUBLE, cargo_ship_gross_tonnage_per_berth DOUBLE, cargo_weight_loading_per_berth DOUBLE, cargo_weight_unloading_per_berth DOUBLE, cargo_weight_total_per_berth DOUBLE, all_ship_gt_total BIGINT, all_ship_count_total BIGINT, type_domestic_merchant_gt BIGINT, type_domestic_private_count BIGINT, type_domestic_private_gt BIGINT, type_domestic_private_count_1 BIGINT, over_30000gt_count_all BIGINT, over_30000gt_gt_all BIGINT, over_30000gt_count_domestic_merchant BIGINT, over_30000gt_gt_domestic_merchant BIGINT, over_30000gt_count_domestic_private BIGINT, over_30000gt_gt_domestic_private BIGINT, over_10000gt_under_30000gt_count_all BIGINT, over_10000gt_under_30000gt_gt_all BIGINT, over_10000gt_under_30000gt_count_domestic_merchant BIGINT, over_10000gt_under_30000gt_gt_domestic_merchant BIGINT, over_10000gt_under_30000gt_count_domestic_private BIGINT, over_10000gt_under_30000gt_gt_domestic_private BIGINT, over_6000gt_under_10000gt_count_all BIGINT, over_6000gt_under_10000gt_gt_all BIGINT, over_6000gt_under_10000gt_count_domestic_merchant BIGINT, over_6000gt_under_10000gt_gt_domestic_merchant BIGINT, over_6000gt_under_30000gt_count_domestic_private BIGINT, over_10000gt_under_30000gt_gt_domestic_private_1 BIGINT, over_3000gt_under_6000gt_count_all BIGINT, over_3000gt_under_6000gt_gt_all BIGINT, over_3000gt_under_6000gt_count_domestic_merchant BIGINT, over_3000gt_under_6000gt_gt_domestic_merchant BIGINT, over_3000gt_under_30000gt_count_domestic_private BIGINT, over_3000gt_under_6000gt_gt_domestic_private BIGINT, over_1000gt_under_3000gt_count_all BIGINT, over_1000gt_under_3000gt_gt_all BIGINT, over_1000gt_under_3000gt_count_domestic_merchant BIGINT, over_1000gt_under_3000gt_gt_domestic_merchant BIGINT, over_1000gt_under_10000gt_count_domestic_private BIGINT, over_1000gt_under_3000gt_gt_domestic_private BIGINT, under_1000gt_count_all BIGINT, under_1000gt_gt_all BIGINT, under_1000gt_count_domestic_merchant BIGINT, under_1000gt_gt_domestic_merchant BIGINT, under_1000gt_count_domestic_private BIGINT, under_1000gt_gt_domestic_private BIGINT, export_all_ton_count BIGINT, export_container_cargo_ton BIGINT, export_chassis_cargo_ton BIGINT, export_chassis_container_ton BIGINT, export_others_cargo_ton BIGINT, import_all_ton_count BIGINT, import_container_cargo_ton BIGINT, import_chassis_cargo_ton BIGINT, import_chassis_container_ton BIGINT, import_others_cargo_ton BIGINT, export_length_8ft BIGINT, export_length_10ft BIGINT, export_length_12ft BIGINT, export_length_20ft BIGINT, export_length_24ft BIGINT, export_length_35ft BIGINT, export_length_40ft BIGINT, export_length_45ft BIGINT, export_length_chassis BIGINT, export_empty_container_chassis_count BIGINT, export_empty_container_chassis_count_1 BIGINT, export_portion_empty_countainer DOUBLE, import_length_8ft BIGINT, import_length_10ft BIGINT, import_length_12ft BIGINT, import_length_20ft BIGINT, import_length_24ft BIGINT, import_length_35ft BIGINT, import_length_40ft BIGINT, import_length_45ft BIGINT, import_length_chassis BIGINT, import_empty_container_chassis_count BIGINT, import_empty_container_chassis_count_1 BIGINT, import_portion_empty_countainer DOUBLE, lon DOUBLE, lat DOUBLE, prefecture_code VARCHAR, source_sha256 VARCHAR );