This repository contains a database designed for asset management of solar panels in hospitals. The database is built using SQL, PostgreSQL, PostGIS, QGIS, and FME and is based on dummy data (not from a real hospital).
The goal of this project is to assist asset managers in:
- Monitoring asset health to ensure optimal solar panel performance.
- Supporting decision-making on energy production, maintenance, and budgeting.
- Tracking asset details such as location, condition, and installation date.
- Asset Health Monitoring 🛠️: Detect faulty sensors and panels needing replacement.
- Energy Production Analysis ⚡: Evaluate solar energy output and expansion feasibility.
- Budget & Cost Management 💰: Estimate maintenance costs and budget allocations.
- Identify faulty temperature sensors that need replacement.
- Determine if solar panels need renewal based on condition and performance.
- Analyze annual energy production to assess whether more panels are needed.
- Estimate budget requirements for asset maintenance and replacements.
The database includes the following tables under the 'ucesafs' schema:
- hospital_buildings 🏥 – Hospital facility information
- solar_panels ☀️ – Solar panel assets
- panel_temperature_sensors 🌡 – Temperature sensors
- solar_panel_values 🔋 – Energy output tracking
- temperature_sensor_values 📈 – Sensor temperature records
- solar_panel_condition 🔎 – Panel physical condition reports
- parameters ⚙️ – System parameters and thresholds
- SQL & PostgreSQL – Database management
- PostGIS – Geospatial data integration
- QGIS – Visualization and spatial analysis
- FME – Data transformation and automation
Visualization of solar panel locations within the hospital in QGIS, displaying asset location in 2D space.
Visualization of asset data transformation using FME, linking solar panel data from the PostgreSQL database to real-time condition and performance metrics. This visualization incorporates 3D geometries to ensure alignment with real-world structures. The solar panels are modeled in 3D space and correctly positioned on the hospital roof to reflect their actual placement.
🚀 Feel free to explore and contribute!