/
都内の区市町村が公開する「イベント一覧」(自治体標準オープンデータセット)を統合したものです。祭り・講座・展示などの開催日時・会場・料金・申込方法を持ちます。
ods.source_files にありますgeo_lat・geo_lon を使ってください(由来は geo_source)CREATE TABLE ods.event ( municipality_code VARCHAR, corporate_number VARCHAR, event_id VARCHAR, organization_name VARCHAR, name VARCHAR, name_kana VARCHAR, name_en VARCHAR, name_alias VARCHAR, subtitle VARCHAR, event_type VARCHAR, status VARCHAR, keywords VARCHAR, tags VARCHAR, schedule_pattern VARCHAR, start_date DATE, end_date DATE, start_time VARCHAR, end_time VARCHAR, schedule_notes VARCHAR, summary VARCHAR, description VARCHAR, fee INTEGER, fee_details VARCHAR, fee_type VARCHAR, organizer VARCHAR, co_organizer VARCHAR, target_audience VARCHAR, capacity VARCHAR, venue_name VARCHAR, address VARCHAR, prefecture VARCHAR, city VARCHAR, building_name VARCHAR, lat DOUBLE, lon DOUBLE, geo_lat DOUBLE, geo_lon DOUBLE, geo_source VARCHAR, geo_level VARCHAR, geometry GEOMETRY, access VARCHAR, parking VARCHAR, application_deadline_date DATE, application_deadline_time VARCHAR, application_method VARCHAR, contact_name VARCHAR, contact_phone VARCHAR, contact_extension VARCHAR, image VARCHAR, content_url VARCHAR, url VARCHAR, notes VARCHAR, extras JSON, org_code VARCHAR, org_title VARCHAR, package_id VARCHAR, source_url VARCHAR );