colouring-montreal/migrations/040.ui_revamp_sources.up.sql

ALTER TABLE buildings ADD COLUMN IF NOT EXISTS location_address_source text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS location_address_links text[];
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS location_coordinates_source text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS location_coordinates_links text[];
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS is_domestic_source text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS is_domestic_links text[];
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS size_storeys_source_type text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS size_storeys_source_links text[];
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS size_height_apex_source_type text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS size_height_apex_source_links text[];
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS size_height_eaves_source_type text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS size_height_eaves_source_links text[];
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS size_height_eaves text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS size_floor_area_source_type text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS size_floor_area_source_links text[];
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS size_width_frontage_source_type text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS size_width_frontage_source_links text[];
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS survival_source_links text[];
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS landowner_source_type text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS designers_source_type text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS builder_source_type text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS extension_source_type text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS extension_source_links text[];
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS size_far_ratio text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS size_far_ratio_source_type text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS size_far_ratio_source_links text[];
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS size_plot_area_total text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS size_plot_area_total_source_type text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS size_plot_area_total_source_links text[];
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS size_parcel_geometry text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS size_parcel_geometry_source_type text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS size_parcel_geometry_source_links text[];
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS context_front_garden text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS context_back_garden text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS context_flats_garden text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS context_garden_source_type text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS context_garden_source_links text[];
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS context_street_width text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS context_street_width_source_type text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS context_street_width_source_links text[];
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS context_pavement_width text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS context_pavement_width_source_type text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS context_pavement_width_source_links text[];
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS context_green_space_distance text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS context_green_space_distance_source_type text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS context_green_space_distance_source_links text[];
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS context_tree_distance text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS context_tree_distance_source_type text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS context_tree_distance_source_links text[];
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS context_street_geometry text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS context_street_geometry_source_type text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS context_street_geometry_source_links text[];
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS age_cladding_date text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS age_cladding_date_source_type text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS age_cladding_date_source_links text[];
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS age_extension_date text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS age_extension_date_source_type text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS age_extension_date_source_links text[];
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS age_retrofit_date text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS age_retrofit_date_source_type text;
ALTER TABLE buildings ADD COLUMN IF NOT EXISTS age_retrofit_date_source_links text[];