spod_read_sql

Load an SQL query from a specified file in package installation directory, glue::collapse it, glue::glue it in case of any variables that need to be replaced, and dplyr::sql it for additional safety.

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. 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_read_sql function

<dl><dt>sql_file_name</dt>
<dd>The name of the SQL file to load from the package installation directory.</dd></dl>

Arguments

Load an SQL query, glue it, dplyr::sql it — spod_read_sql

<dl>

<dt>sql_file_name</dt>
<dd>The name of the SQL file to load from the package installation directory.</dd>

</dl>

spod_read_sql: Load an SQL query, glue it, dplyr::sql it

Description

Usage

Value

Arguments