/
地価公示・都道府県地価調査の地点ごとの価格を、1 地点 1 年で 1 行に持つテーブルです。1995 年からで、所在地・座標・価格と前年比・地積・用途・最寄駅・法令上の規制を持ちます。
CREATE TABLE main.mart_land_prices ( point_id BIGINT, land_price_type INTEGER, land_price_type_name VARCHAR, year BIGINT, standard_lot_number VARCHAR, prefecture_code VARCHAR, prefecture_name VARCHAR, city_code VARCHAR, municipality_name VARCHAR, place_name VARCHAR, location VARCHAR, current_price BIGINT, last_year_price BIGINT, change_rate DOUBLE, cadastral_area BIGINT, use_category VARCHAR, area_division VARCHAR, usage_status VARCHAR, surrounding_usage VARCHAR, building_structure VARCHAR, ground_floors VARCHAR, underground_floors VARCHAR, nearest_station VARCHAR, station_distance VARCHAR, front_road_condition VARCHAR, front_road_width DOUBLE, zoning_use_category VARCHAR, building_coverage_ratio INTEGER, floor_area_ratio INTEGER, fireproof_category VARCHAR, gas_supply_availability BOOLEAN, water_supply_availability BOOLEAN, sewer_supply_availability BOOLEAN, longitude DOUBLE, latitude DOUBLE, geom GEOMETRY );