search

GreenInfo-Network / seattle-building-dashboard

Energy benchmarking for Seattle
https://greeninfo-network.github.io/seattle-building-dashboard/
ISC License
1 stars 0 forks source link

Process Documentation (SOW 2024 Task 3.5) #98

Open danrademacher opened 5 months ago

danrademacher commented 5 months ago

Looking at documentation, we have these overall buckets from SOW:

Provide written guidance (log-in info, procedure, screen shots) that will enable OSE users to implement data updates for:

  • The Intro.JS tutorial
  • Tabular data uploads in Carto
  • Property footprints

We have these existing documents:

  1. Uploading to CARTO: https://github.com/GreenInfo-Network/seattle-building-dashboard/blob/master/documentation/Update_building_energy_data.md. This could mainly use confirmation of completeness by someone who hasn't done it before/recently, and deleting the old instructions
  2. Updating footprints, https://github.com/GreenInfo-Network/seattle-building-dashboard/blob/master/documentation/Building_outlines.md. Note that this in turn relies on a Python script, https://github.com/GreenInfo-Network/seattle-building-dashboard/tree/master/documentation/scripts. (Interesting to imagine Mike Roos running this!). We will need to provide all the files that are referenced with P:\ server paths
  3. And then we have the Intro.js code here, https://github.com/GreenInfo-Network/seattle-building-dashboard/blob/master/src/app/views/layout/tutorial.js. Well commented but really not friendly for a non-developer.

This task and budget is pure documentation, so we are not on the hook to make this easy for Mike.

┆Issue is synchronized with this Asana task ┆Due Date: 2024-06-17

danrademacher commented 4 months ago

Mike wants to be able to modify footprints in GIS, so yes. Try to make sure the documentation is as simple and clear as possible. Focus on data types and avoiding damage to file in round tripping out of CARTO into GIS and back into CARTO,

danrademacher commented 4 months ago

Footprints:

  1. Download data with query from https://cityenergy-seattle.carto.com/dataset/footprints_production using the following query to remove CartoDB ID and the_geom_webmercator columns: 
    SELECT the_geom,buildingid,opendataid,source FROM public.footprints_production

    Download as shapefile.

  2. Edit in ArcPro, making sure to retain the values in all the non geography fields
  3. Save that shp and zip it into a single .zip file
  4. Upload to CARTO. CARTO will automatically name it footprints_production_1
  5. Rename the old footprints_production table to footprints_previous
  6. Rename the new file you just uploaded to footprints_production
  7. Make sure the site is loading footprints as expected. If after step 7, footprints are not loading or there's some other issue, roll back by renaming footprints_production to footprints_production_problem and then rename footprints_previous to footprints_production
  8. Once the new footprints are working as expected, download footprints_previous file to your local machine for reference
  9. Delete footprints_previous from CARTO.com to keep the online data repo clean.
danrademacher commented 3 months ago

Enhanced documentation here: https://docs.google.com/document/d/1RuMem-OeKfVFh51vDMzg3ZPkqpyLr6JaB8xFut9wxZw/edit

Need to add images and process for ArcPro work

danrademacher commented 3 months ago

And also upload the ArcPro project file