Adding Meters / Buildings

Recurring Task: You may be asked to add new meters or buildings to the dashboard every now and then
Frequency: Once or twice a year

MySQL Workbench

The following tables in the SQL database should be updated each time a new meter and/or building is added:

meters
- Should update itself for new meters; the primary key id will auto-increment so you can tell new meters were added
meter_groups
- Make sure to update the building_id_2 value in meter_groups table if you are adding a new building
- Each meter group is essentially defining a separate graph. If you have multiple energy types (e.g. the building has both electricity and gas), then make sure to define a separate meter group for each energy type
  - Review this page if you forget how to tell which energy type is which
buildings
- Update building image by uploading image to osu-energy-images AWS S3 bucket (manual upload will be simplest)
- Get map ID from https://www.openstreetmap.org/ ("way" on openstreetmap = map ID in database)
meter_group_relation
- Match the corresponding meter group and meter ID together in the meter_group_relation table. One meter group can be mapped to several meters, but not the other way around
See Database document for help on updating / inserting buildings and meters

Go to AWS Web Console > S3 > Buckets > osu-energy-images
Upload a picture of the newly added building (if applicable). Google images ought to be enough to find a good result
Upload 1 picture to root directory of osu-energy-images
Resize image for thumbnail with https://imageresizer.com/
- Set width as 400px, leave the height option blank to let the height scale with original proportions
- Upload resized images to thumbnails directory of osu-energy-images
Click on uploaded image in S3 bucket > Permissions > Everyone(public access) > Object > change to Read
Go back and make sure the file name of the image you uploaded matches the image filename as listed in buildings table in the SQL database as seen in MySQL Workbench