Harvesting in green roofs: database application

DOI

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.

The application is written in Flask (Python) and needs to be run on a Linux/BSD server. Once on a server, the application runs in any browser. The resulting database is a single SQLite file that can be edited and processed with any SQLite application, like DB Browser for SQLite.

Identifier
DOI https://doi.org/10.34810/data918
Metadata Access https://dataverse.csuc.cat/oai?verb=GetRecord&metadataPrefix=oai_datacite&identifier=doi:10.34810/data918
Provenance
Creator Alva, Aleix (ORCID: 0000-0001-7966-371X)
Publisher CORA.Repositori de Dades de Recerca
Contributor Alva, Aleix; Universitat Politècnica de Catalunya; 210 (MS)
Publication Year 2024
Funding Reference Ajuntament de Barcelona 21S09258-001 ; La Caixa Foundation 2021 Pla de Barcelona Ciència
Rights Custom Dataset Terms; info:eu-repo/semantics/openAccess; https://dataverse.csuc.cat/api/datasets/:persistentId/versions/1.0/customlicense?persistentId=doi:10.34810/data918
OpenAccess true
Contact Alva, Aleix (Universitat Politècnica de Catalunya)
Representation
Resource Type Program source code; Dataset
Format text/html; application/octet-stream; text/x-python; text/plain; application/sql
Size 2733; 1515; 667; 1124; 338; 3082; 28672; 1100; 11644; 4518; 954
Version 1.0
Discipline Agricultural Sciences; Agriculture, Forestry, Horticulture, Aquaculture; Agriculture, Forestry, Horticulture, Aquaculture and Veterinary Medicine; Life Sciences; Social Sciences; Social and Behavioural Sciences; Soil Sciences