日野市が公開する「ゴミ集積所一覧」(自治体標準オープンデータセット)です。ゴミ集積所の位置・ゴミの種類・収集日を持ちます。データ時点は 2024-03-28 です。
CREATE TABLE ods.garbage_collection_place ( municipality_code VARCHAR, facility_id VARCHAR, collection_place_id VARCHAR, name VARCHAR, name_kana VARCHAR, name_en VARCHAR, address VARCHAR, prefecture VARCHAR, city VARCHAR, town VARCHAR, street_number VARCHAR, building_name VARCHAR, postal_code VARCHAR, phone_number VARCHAR, lat DOUBLE, lon DOUBLE, geo_lat DOUBLE, geo_lon DOUBLE, geo_source VARCHAR, geo_level VARCHAR, geometry GEOMETRY, garbage_type VARCHAR, collection_day VARCHAR, district VARCHAR, description VARCHAR, caution VARCHAR, url VARCHAR, extras JSON, as_of VARCHAR, source_url VARCHAR, source_page VARCHAR, local_government_code VARCHAR, full_address VARCHAR, latitude DOUBLE, longitude DOUBLE );