1 / 11

Organizing and Storing Building Data

This guide focuses on effective methods for organizing and storing building data gathered from existing monitoring systems and sensors. By leveraging SCADA systems and utilizing data from temperature sensors, facilities can enhance their monitoring capabilities. The process involves acquiring data, dumping it into a database, and executing relevant queries for visualization and modeling. We highlight practical SQL examples, including querying temperature sensors installed on various floors, and provide details on implementing a storage system using JSON schema tailored for building layouts.

calida
Télécharger la présentation

Organizing and Storing Building Data

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Organizing and Storing Building Data Jorge Ortiz

  2. Making Use of Building Data • While continuing to build and deploy a dense monitoring fabric… • Use data from sensors already in the building • SCADA system often already in place • much can be learned from it • Acquire the data from facilities, dump into database, and query • Use data for visualization, modeling, etc.

  3. SCADA SystemsSupervisory Control and Data Acquisition SODA4R787__ART + + Data

  4. Capturing Building Layout

  5. Organization of Building Entities

  6. Relevant Queries • List temperature sensors on 4th floor of Soda hall • SELECT id FROM zone_sensors WHERE building=‘Soda’ and floor=4 AND id LIKE ‘%ART’ • Get all temperature sensor data in the last day on the 4th floor of Soda • SELECT * FROM sensor_data WHERE id=[list of sensors] AND timestamp >= ’ 2009-12-16 00:00:00’ and timestamp<=now()

  7. Visualization

  8. More information • http://webs.cs.berkeley.edu/building_schema • JSON version of schema available • Storage system currently being implemented based on JSON schema

  9. Extra Slides

  10. Storage System Design

  11. Capturing Building Layout (JSON Schema Organization)

More Related