spod_duckdb_set_temp

Set temp file for DuckDB connection

internal

Gain seamless access to origin-destination (OD) data from the
Spanish Ministry of Transport, hosted at
<https://www.transportes.gob.es/ministerio/proyectos-singulares/estudios-de-movilidad-con-big-data/opendata-movilidad>.
This package simplifies the management of these large datasets by
providing tools to download zone boundaries, handle associated
origin-destination data, and process it efficiently with the 'duckdb'
database interface. Local caching minimizes repeated downloads,
streamlining workflows for researchers and analysts. Methods
described in Kotov et al. (2026) <doi:10.1177/23998083251415040>.
Extensive documentation is available at
<https://ropenspain.github.io/spanishoddata/index.html>, offering
guides on creating static and dynamic mobility flow visualizations and
transforming large datasets into analysis-ready formats.

Egor Kotov

spanishoddata

Get Spanish Origin-Destination Data

Robin Lovelace

Eugeni Vidal-Tortosa

spod_duckdb_set_temp function

<dl><dt>con</dt>
<dd>A duckdb connection</dd>
<dt>temp_path</dt>
<dd>The path to the temp folder for DuckDB for <a href="https://duckdb.org/2024/07/09/memory-management.html#intermediate-spilling">intermediate spilling</a> in case the set memory limit and/or physical memory of the computer is too low to perform the query. By default this is set to the <code>temp</code> directory in the data folder defined by SPANISH_OD_DATA_DIR environment variable (set by <code>spod_set_data_dir()</code>)). Otherwise, for queries on folders of CSV files or parquet files, the temporary path would be set to the current R working directory, which probably is undesirable, as the current working directory can be on a slow storage, or storage that may have limited space, compared to the data folder.</dd></dl>

Arguments

Set temp file for DuckDB connection — spod_duckdb_set_temp

<dl>

<dt>con</dt>
<dd>A duckdb connection</dd>


<dt>temp_path</dt>
<dd>The path to the temp folder for DuckDB for <a href='https://duckdb.org/2024/07/09/memory-management.html#intermediate-spilling'>intermediate spilling</a> in case the set memory limit and/or physical memory of the computer is too low to perform the query. By default this is set to the <code>temp</code> directory in the data folder defined by SPANISH_OD_DATA_DIR environment variable (set by <code>spod_set_data_dir()</code>)). Otherwise, for queries on folders of CSV files or parquet files, the temporary path would be set to the current R working directory, which probably is undesirable, as the current working directory can be on a slow storage, or storage that may have limited space, compared to the data folder.</dd>

</dl>

spod_duckdb_set_temp: Set temp file for DuckDB connection

Description

Usage

Value

Arguments