020_Open Habitation
Aggregating data to search the sustainability of offered real estate
We created a minimal API that aggregates data from GeoAdmin (Swisstopo) and PVGIS (EU) to calculate a score for any building property which is in the Open Data sources. Plans to build on this and add crowdsourcing capabilites have been discussed.
Please note: At the moment, the calculation of PV production does not work properly. But the rough procedure as well as the API-queries are correct. We have to change little things and we will update as soon as possible.
Presentation
Next steps
(1) Complete basic functionality of the prototype
- https://marshmallow-sqlalchemy.readthedocs.io/en/latest/index.html to persist the DB properly
- https://swagger.io/docs/specification/describing-request-body/ to create a valid spec
- https://frictionlessdata.io/standards/ for making the data portable and valid
- https://github.com/PWZER/swagger-ui-py/issues/29 to integrate OpenAPI
(2) Build on the (Falcon based) Web API
- https://github.com/falconry/falcon/wiki/Complementary-Packages for extra features
- https://github.com/arivero/SampleAnonAPI is an example Falcon data anonymization project
- https://github.com/vicinityh2020/vicinity-vas-dreven example Falcon smart charging project
- https://github.com/bookla-foundation/meerkat more info on RESTful Falcon apps
- https://apispec.readthedocs.io/en/latest/using_plugins.html for integrating Marshmallow
(3) Make further improvements to the data model
- https://www.opendataphilly.org/dataset/housing-production
- https://data.stadt-zuerich.ch/dataset/bau_best_geb_jahr_gebart_bauperiode_quartier_od5087
- https://www.housing-stat.ch/de/home.html
- http://carboncoop.greenopenhomes.net/
- https://wikirateproject.org/About_Us
- http://ecofriendlyhouses.net/
Challenge
How sustainable is this property?
- The building sector still has huge impact on climate change, altough co2-reduction is relatively easy (and cheap) to reach.
- When choosing the next property (rental or buying), the environment plays a role that is too small. As a result, investors are less interested in green solutions. One reason why ecological aspects are not taken into account in the selection is that no (or not enough) information is available for home-seekers.
- let's provide this information!
- "collect and combine" public information of offered real estate (heating system and - if time remains - photovoltaics, building standard, access to green mobility ...). Provide this information for real estate marketplaces.
Open Habitation API
This is a project started at the Energy Data Hackdays 2021. Please see our project page for background and have fun.
Service
This repository contains a minimal backend service API based on the Falcon framework, Pandas DataPackage Reader, and the Falcon plugin for apispec.
Use pip with requirements.txt or install the Poetry dependency manager, and:
poetry install
poetry shell
python api.py
To update the requirements file:
poetry export --without-hashes -f requirements.txt > requirements.txt
License
This package is licensed by its maintainers under the MIT License.
If you intended to use these data in a public or commercial product, please check the data sources themselves for any specific restrictions.
The contents of this website, unless otherwise stated, are licensed under a Creative Commons Attribution 4.0 International License.