Register of green-roof activities: database application

DOI

This repository contains a web application (written in Flask, Python) that allows green roofs (and other locations) to register held activities. All entires are 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 registers internal and external activities, alongside different fields of data that allow the characterisation of indicators related to the social performance of the roof. The menu is offered in Catalan, but can be customised for other languages. The list of external activity types can be expanded and edited. Moreover, each activity entry 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 sigle SQLite file that can be edited and processed with any SQLite application, like DB Browser for SQLite.

Identifier
DOI https://doi.org/10.34810/data919
Metadata Access https://dataverse.csuc.cat/oai?verb=GetRecord&metadataPrefix=oai_datacite&identifier=doi:10.34810/data919
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/data919
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 2419; 6398; 752; 355; 2377; 4836; 28672; 1832; 18222; 4718; 1497
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