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.