Bringing in data from another table: joins and lists of values

Bringing the protected area category and group to each alert through the CNUC code, and collapsing several values into a list, such as the municipalities of each protected area. The old scripts used dozens of lines of cursors; here it takes a few lines in each program.

Authors

Publication Details

Journal
Zenodo (CERN European Organization for Nuclear Research)
Published
2026-10-29
DOI
https://doi.org/10.5281/zenodo.23780257
Primary Topic
Engineering and Information Technology
Type
article
Field-Weighted Citation Impact
0.00
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
article

Bringing in data from another table: joins and lists of values

Hendesson Alves
Zenodo (CERN European Organization for Nuclear Research)
Engineering and Information Technology
article

Bringing in data from another table: joins and lists of values

Hendesson Alves
article en

Abstract

Bringing the protected area category and group to each alert through the CNUC code, and collapsing several values into a list, such as the municipalities of each protected area. The old scripts used dozens of lines of cursors; here it takes a few lines in each program.

Zenodo (CERN European Organization for Nuclear Research)
Openalex Percentile: Top 3%
Engineering and Information Technology
DOIOpen Access PDFOpenAlex
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.

Laika access coming soon
Bringing in data from another table: joins and lists of values — Hendesson Alves · Zenodo (CERN European Organization for Nuclear Research) (2026) | TGRS Research Map | TGRS