New building footprints needed

GreenInfo-Network / seattle-building-dashboard

Energy benchmarking for Seattle

ISC License

1 stars 0 forks source link

Closed tomay closed 4 months ago

tomay commented 4 months ago

The following buildings are new and need footprints:

building_id	Property Name	Street Address	City	State	zip	Latitude	Longitude
27455	Queen Anne Exchange	1529 4TH AVE W	SEATTLE	WA	98119	47.63333	-122.36277
26938	CLAIREMONT APT HOMES	2010 E YESLER WAY	SEATTLE	WA	98122	47.60183	-122.30582
50755	740 HARVARD AVE E	740 HARVARD AVE E	SEATTLE	WA	98102	47.62628	-122.32211
19863	815 2ND AVE	815 2ND AVE	SEATTLE	WA	98104	47.60403	-122.33452
24359	JEFFERSON BUILDING	1401 E JEFFERSON ST	SEATTLE	WA	98122	47.60592	-122.31367
49775	SAFEWAY 2932 (SVF ADMIRAL)	2622 CALIFORNIA AVE SW	SEATTLE	WA	98116	47.57984	-122.38577

┆Issue is synchronized with this Asana task

tomay commented 4 months ago

27455 already has a footprint:

26938 already has a footprint:

24539 already has a building footprint

49775 already has a building footprint:

tomay commented 4 months ago

Done - hand digitized in QGIS referencing OSM and Google Maps imagery

That's this building Done - hand digitized in QGIS referencing OSM and Google Maps imagery

tomay commented 4 months ago

Attaching the GeoJSON for these two new FP

tomay commented 4 months ago

I've uploaded these and inserted them into the existing table seattle_building_outlines_2022 with:

INSERT INTO seattle_building_outlines_2022(the_geom, buildingid, source)
SELECT the_geom, buildingid, source
FROM new_footprints;

Note: I ignored the_geom_webmercator but that should be okay? This is present, but updated in the background (I think?)

These FPs are now showing up on the app: