Skip to main content

Adding Meters / Buildings

info
  • 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. 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

AWS S3

  • 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