Published January 4, 2025 | Version v1
Dataset Open

Bibliographic search on agro-hydrological infrastructures: query design strategies and refinement process for a literature review

  • 1. ROR icon Laboratoire d'Etude des Interactions entre Sol-Agrosystème-Hydrosystème

Description

This dataset contains bibliographic search queries conducted in the Scopus and Web of Science databases for a literature review on agro-hydrological infrastructures. Different query design strategies cover key topics such as soil management, water conservation, runoff control, and green water management. Metadata includes query identifiers, dates, search terms, number of results, and qualitative comments. The dataset supports a broader bibliometric analysis, although some queries tested a regional focus on the Mediterranean. Search terms such as 'water', 'green water', and 'runoff' were combined with 'management', 'conservation,' and 'structures' to identify documents on runoff management structures or water harvesting structures, with a possible focus on rainfed agriculture. Despite the refinement, the results remained broad and still included irrelevant results such as urban runoff studies or soil and water conservation practices. The query results were used to identify highly cited documents to narrow the scope. Their references and citing documents were then used to analyze agricultural contexts. Studies on storage structures or related to irrigation were excluded. A manuscript (in preparation) based on these searches addresses a global review of case studies, key findings, and knowledge gaps on onsite runoff management structures and their maintenance.

Technical info (En)

 

Sheets  Database Search strategy
scopus-soil Scopus soil related terms
scopus-water Scopus water related terms
scopus-runoff Scopus runoff related terms
wos-water Web of Science green water related terms
     
Field Type Content
date date date of the execution of the search
query-id text unique identifier for the query
subarea boolean y/n restriction to specific subareas of the database
query text the actual query utilized for the search
results integer total number of documents retrieved
examine boolean y/n indicates whether the results are relevant to be examined in detail
error boolean y/n is there a factual error in the query?
main text id of the main query in case of a derivated query, * if original
difference text what has been changed from the main query, in case of a derivated query
remarks  text main element noted from the first page of results (date-newest)
Cortext boolean y/n indicates if the literature body has been exported to the CorTexT platform for semantic analyses https://www.cortext.net/
reported boolean y/n reported in the manuscript that describes the results of the literature review
     
Remark  -  Some descriptive fields have been left partially incomplete
Color code  -  To facilitate the retrieval of interesting queries (optional); mostly automated as conditional formatting
     
Creation 02/06/2023 Dataset structure
Last update 04/01/2025 Metadata documentation and upload

Notes (En)

Davide Rizzo received support from the French National Research Agency (ANR, grant n. ANR-22-CPJ1-0050-01), the French National Research Institute for Sustainable Development (IRD) and the University of Montpellier Experimental Public Institution Excellence Program (UM EPE) as a contribution to the Junior Professorship in Landscape Agronomy. 

Files

bibliographic-search-queries-agro-hydrological-infrastructures-rizzo-2025.csv

Additional details

Related works

Is published in
Journal article: https://hal.inrae.fr/hal-04962256 (URL)
Journal article: 10.1016/j.jenvman.2025.124718 (DOI)
Is supplemented by
Dataset: 10.5281/zenodo.14919677 (DOI)
Is variant form of
Poster: 10.5281/zenodo.14510112 (DOI)

Funding

Agence Nationale de la Recherche
Chaire de Professeur Junior en Géoagronomie ANR-22-CPJ1-0050-01

Dates

Created
2023-06-02
First structure of the dataset and query design
Available
2025-01-04
Metadata update and publication

Software

Development Status
Concept