fix benchmarking data for a few buildings from footprint work

[tomay]

Here's the doc: https://docs.google.com/spreadsheets/d/1S3ftokz4nCtDrrEmpBPLNyr5fnd0YlbnjasbCqZTiHI/edit#gid=1932132457

• [x] Make the specified changes in CARTO
• [x] Email Mike so he can make the changes upstream

[tomay]

Here are the queries as applied in CARTO:

Addresses

UPDATE public.seattle_buildings_2021_update SET reported_address = '709 N 35th St' WHERE id = 21122
UPDATE public.seattle_buildings_2021_update SET reported_address = '1155 N 130th St' WHERE id = 21216 
UPDATE public.seattle_buildings_2021_update SET reported_address = '3520 NE 89th St' WHERE id = 24560 
UPDATE public.seattle_buildings_2021_update SET reported_address = '6201 33rd Ave NE' WHERE id = 20888 
UPDATE public.seattle_buildings_2021_update SET reported_address = '3200 3rd Ave W' WHERE id = 21150
UPDATE public.seattle_buildings_2021_update SET reported_address = '12600 Stone Ave N' WHERE id = 21218
UPDATE public.seattle_buildings_2021_update SET reported_address = '1201 Summit Ave' WHERE id = 21341 
UPDATE public.seattle_buildings_2021_update SET reported_address = '1305 Dexter Ave N' WHERE id = 24235
UPDATE public.seattle_buildings_2021_update SET reported_address = '1601 W Armory Way' WHERE id = 302

# Checking:

SELECT id, reported_address, zip FROM public.seattle_buildings_2021_update where id = 21122
SELECT id, reported_address, zip FROM public.seattle_buildings_2021_update where id = 21216
SELECT id, reported_address, zip FROM public.seattle_buildings_2021_update where id = 24560
SELECT id, reported_address, zip FROM public.seattle_buildings_2021_update where id = 20888
SELECT id, reported_address, zip FROM public.seattle_buildings_2021_update where id = 21150
SELECT id, reported_address, zip FROM public.seattle_buildings_2021_update where id = 21218
SELECT id, reported_address, zip FROM public.seattle_buildings_2021_update where id = 21341
SELECT id, reported_address, zip FROM public.seattle_buildings_2021_update where id = 24235
SELECT id, reported_address, zip FROM public.seattle_buildings_2021_update where id = 302

# Lat/Lng

UPDATE public.seattle_buildings_2021_update SET latitude = 47.710487738719, longitude = -122.3191361 WHERE id = 28874
UPDATE public.seattle_buildings_2021_update SET latitude = 47.66049228, longitude = -122.311532 WHERE id = 50101
UPDATE public.seattle_buildings_2021_update SET latitude = 47.57576545, longitude = -122.3209074 WHERE id = 694
UPDATE public.seattle_buildings_2021_update SET latitude = 47.61385, longitude = -122.323 WHERE id = 27241
UPDATE public.seattle_buildings_2021_update SET latitude = 47.63723088, longitude = -122.37931 WHERE id = 302

# Checking: 

SELECT latitude, longitude FROM public.seattle_buildings_2021_update WHERE id = 28874
SELECT latitude, longitude FROM public.seattle_buildings_2021_update WHERE id = 50101
SELECT latitude, longitude FROM public.seattle_buildings_2021_update WHERE id = 694
SELECT latitude, longitude FROM public.seattle_buildings_2021_update WHERE id = 27241
SELECT latitude, longitude FROM public.seattle_buildings_2021_update WHERE id = 302

[tomay]

Shared the above doc with Mike on 10/26