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
- Should update itself for new meters; the primary key
meter_groups
- Make sure to update the
building_id_2
value inmeter_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
- Make sure to update the
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)
- Update building image by uploading image to
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 toRead
- 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