Harvesting in green roofs: database application

This dataset contains a web application (written in Flask, Python) that allows green roofs (an other locations) to collect harvesting data that is automatically added to an SQLite database. In its presented form, six green roofs of Barcelona are included, but this can be customised as wished.

An empty database file is provided along with the SQLite schema to generate the tables. The Python code is also included in order to allow the application to be offered through a server.

The application allows harvesting events to be registered, where data needs to be recorded in kg. The menu is offered in Catalan, but can be customised for other languages. The list of available products is dynamic and can be expanded and edited. The list of uses is also expandable and editable. Moreover, each harvest can be edited after its creation.

该数据集包含一个基于Python Flask框架编写的Web应用程序，可用于绿色屋顶（及其他地点）收集收获数据，这些数据会自动添加至SQLite数据库。在当前呈现版本中，包含巴塞罗那的6个绿色屋顶，但用户可根据需求进行自定义配置。

数据集提供了空数据库文件及用于生成表的SQLite模式（schema），同时包含Python代码以支持通过服务器部署该应用程序。

该应用程序支持记录收获事件，数据需以千克（kg）为单位录入。菜单界面采用加泰罗尼亚语（Catalan），但可根据需要适配其他语言。可用产品列表为动态配置，支持扩展与编辑；用途列表同样支持扩展与编辑。此外，每条收获记录创建后均可进行编辑。