倉庫業登録申請(倉庫の所在地・種類、保管物品の種類、主要構造、建築年月、階数別面積等の規模、冷蔵施設等)に関する情報を有するデータ(4,876レコード)
元の資料: 倉庫業登録申請書、倉庫明細書第1号様式、冷蔵施設明細書(冷蔵室表)、国土数値情報 行政区域データ
G空間情報センターのデータセット links-soukogyou-2024 の 01_soukogyoutourokushinseisyo.csv を、列名を小文字にして型を付けたテーブルです。列の説明は同じデータセットのデータ仕様書から付けています。
CREATE TABLE links.warehouse_registrations ( business_operator_id BIGINT, office_id BIGINT, warehouse_id BIGINT, latitude DOUBLE, longitude DOUBLE, warehouse_type VARCHAR, type_of_stored_goods VARCHAR, main_structure VARCHAR, construction_date_or_planned_completion_date DATE, building_completion_date_bracket VARCHAR, land_and_warehouse_usage_rights_land VARCHAR, land_and_warehouse_usage_rights_building VARCHAR, floor1_scale_area DOUBLE, floor1_scale_eaves_height_floor_height_or_ceiling_height DOUBLE, floor1_scale_volume DOUBLE, floor2_scale_area DOUBLE, floor2_scale_eaves_height_floor_height_or_ceiling_height DOUBLE, floor2_scale_volume DOUBLE, floor3_scale_area DOUBLE, floor3_scale_eaves_height_floor_height_or_ceiling_height DOUBLE, floor3_scale_volume DOUBLE, floor4_scale_area DOUBLE, floor4_scale_eaves_height_floor_height_or_ceiling_height DOUBLE, floor4_scale_volume DOUBLE, floor5_scale_area DOUBLE, floor5_scale_eaves_height_floor_height_or_ceiling_height DOUBLE, floor5_scale_volume DOUBLE, floor6_scale_area BIGINT, floor6_scale_eaves_height_floor_height_or_ceiling_height DOUBLE, floor6_scale_volume VARCHAR, total_area DOUBLE, structure_details_frame_post VARCHAR, structure_details_frame_floor_frame VARCHAR, structure_details_wall_external_wall VARCHAR, structure_details_wall_partition_wall VARCHAR, structure_details_wall_firewall VARCHAR, structure_details_roof VARCHAR, structure_details_ceiling VARCHAR, structure_details_floor VARCHAR, structure_details_window_side_window VARCHAR, structure_details_window_skylight VARCHAR, structure_details_entrance_entrance_in_external_wall VARCHAR, structure_details_entrance_entrance_in_partition_wall VARCHAR, structure_details_entrance_entrance_in_firewall VARCHAR, ancillary_equipment_rat_proof_equipment VARCHAR, ancillary_equipment_heat_shield_device VARCHAR, ancillary_equipment_other_equipment VARCHAR, other VARCHAR, cooling_method VARCHAR, evaporation_method VARCHAR, refrigeration_capacity_kw DOUBLE, type_of_refrigerant_used VARCHAR, compressor_type VARCHAR, compressor_motor_kw DOUBLE, compressor_motor_kw_1 BIGINT, refrigeration_room_scale_area_m2 DOUBLE, refrigeration_room_scale_height_m DOUBLE, refrigeration_room_scale_volume_m3 DOUBLE, storage_capacity_tons DOUBLE, storage_temperature_c BIGINT, total_heat_loss_w BIGINT, cooling_pipe_surface_area_m2_ceiling DOUBLE, cooling_pipe_surface_area_m2_wall BIGINT, heat_insulation_material_type_thermal_conductivity_and_thickness_ceiling VARCHAR, heat_insulation_material_type_thermal_conductivity_and_thickness_floor VARCHAR, heat_insulation_material_type_thermal_conductivity_and_thickness_external_wall VARCHAR, heat_insulation_material_type_thermal_conductivity_and_thickness_partition_wall VARCHAR, lighting_kw DOUBLE, electric_fan_kw DOUBLE, main_structure_frame VARCHAR, main_structure_fire_resistant VARCHAR, business_location_administrative_area_code BIGINT, business_location_prefecture_name VARCHAR, business_location_subprefecture_name VARCHAR, business_location_county_or_designated_city_name VARCHAR, business_location_municipality_name VARCHAR, office_location_administrative_area_code BIGINT, office_location_prefecture_name VARCHAR, office_location_subprefecture_name VARCHAR, office_location_county_or_designated_city_name VARCHAR, office_location_municipality_name VARCHAR, warehouse_location_administrative_area_code BIGINT, warehouse_location_prefecture_name VARCHAR, warehouse_location_subprefecture_name VARCHAR, warehouse_location_county_or_designated_city_name VARCHAR, warehouse_location_municipality_name VARCHAR, geometry GEOMETRY, source_sha256 VARCHAR );