Log

 

020_Open Habitation

Aggregating data to search the sustainability of offered real estate

Team Readme
✨ Demo
↓  Open

Presentation slides

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.

Preview of external content.
👋 Contact ✨ Demo 💻 Source
All attendees, sponsors, partners, volunteers and staff at our hackathon are required to agree with the Hack Code of Conduct. Organisers will enforce this code throughout the event. We expect cooperation from all participants to ensure a safe environment for everybody. For more details on how the event is run, see the Guidelines on our website.

Creative Commons LicenceThe contents of this website, unless otherwise stated, are licensed under a Creative Commons Attribution 4.0 International License.


Previous
Energy Data Hackdays 2021
Next project