spanishoddata::spod_codebook(ver = 2)
Codebook and cookbook for v2 (2022 onwards) Spanish mobility data
Source:vignettes/v2-2022-onwards-mitma-data-codebook.qmd
You can view this vignette any time by running:
The mobility data v2 (2022 onwards) was originally released by the Ministerio de Transportes, Movilidad y Agenda Urbana (MITMA) , now Ministerio de Transportes y Movilidad Sostenible (MITMS) (Secretaría de Estado de Transportes y Movilidad Sostenible 2024).
The dataset is produced by Nommon using the raw data from Orange España. Even though the raw data is only from one mobile phone operator, the resulting flows and other counts of number of individuals in the data set are already resampled to be representative of the total population of Spain (see details in the official methodology).
The tables in the data set provide hourly flows between zones across Spain for every day of the observation period (2022-01-01 onwards), the number of individuals making trips for each zone, the number of individuals spending the nights in one location while regularly residing in a different location, and many more advanced datasets. This document will introduce you to the available data and provide brief code snippets on how to access it using the spanishoddata R package.
Compared to the v1 data (2020-2021) this dataset has many additional variables, such as age, sex, and income, has better spatial resolution (the zones are more spatially granular) and covers a continuous period1 (2022-01-01 onward), rather than only a limited period (in v1 - 2020-02-14 to 2021-05-09).
Warning
Due to mobile network outages, the data on certain dates is missing. Kindly keep this in mind when calculating mean monthly or weekly flows.
Please check the original data page for currently known missing dates. At the time of writing, the following dates are missing: 26, 27, 30, 31 October, 1, 2 and 3 November 2023 and 4, 18, 19 April 2024. You can use
spod_get_valid_dates()function to get all available dates.
In v2 data, the datasets comparable to the v1 (2020-2021) data (hourly daily origin destination matrices and number of trips at each location) are called “basic studies” (“estudios basicos”), however there are even more advanced datasets that are already available or will be made available soon: “complete studies” (“estudios completos”) and “road routes” (“rutas de carretera”). At the moment, the spanishoddata package only provides the interface to the “basic studies” datasets, but support for “complete studies” and “road routes” will be added in the future.
Key sources for this codebook/cookbook include:
original data collection methodology and codebook in Spanish + automatically translated English version of methodology and codebook
Note
Kindly consult the documents above for any specific details on the methodology. The codebook here is only a simplified summary.
To access the data we reference in this codebook, please follow these steps:
Install the package
The package is not yet available on CRAN.
You can install the latest version of the package from rOpenSpain R universe:
install.packages("spanishoddata",
repos = c("https://ropenspain.r-universe.dev",
"https://cloud.r-project.org"))Alternative installation and developemnt
Alternative way to install the package from GitHub:
if (!require("remotes")) install.packages("remotes")
remotes::install_github("rOpenSpain/spanishoddata",
force = TRUE, dependencies = TRUE)For Developers
To load the package locally, clone it and navigate to the root of the package in the terminal, e.g. with the following:
gh repo clone rOpenSpain/spanishoddata
code spanishoddata
# with rstudio:
rstudio spanishoddata/spanishoddata.RprojThen run the following command from the R console:
devtools::load_all()Load it as follows:
Using the instructions below, set the data folder for the package to download the files into. You may need up to 400 GB to download all data and another 400 GB if you would like to convert the downloaded data into analysis ready format (a DuckDB database file, or a folder of parquet files). You can find more info on this conversion in the Download and convert OD datasets vignette.
Set the data directory
Choose where spanishoddata should download (and convert) the data by setting the data directory following command:
spod_set_data_dir(data_dir = "~/spanish_od_data")The function above will also ensure that the directory is created and that you have sufficient permissions to write to it.
Setting data directory for advanced users
You can also set the data directory with an environment variable:
Sys.setenv(SPANISH_OD_DATA_DIR = "~/spanish_od_data")The package will create this directory if it does not exist on the first run of any function that downloads the data.
To permanently set the directory for all projects, you can specify the data directory globally by setting the SPANISH_OD_DATA_DIR environment variable, e.g. with the following command:
usethis::edit_r_environ()
# Then set the data directory globally, by typing this line in the file:SPANISH_OD_DATA_DIR = "~/spanish_od_data"You can also set the data directory locally, just for the current project. Set the ‘envar’ in the working directory by editing .Renviron file in the root of the project:
file.edit(".Renviron")Overall approach to accessing the data
If you only want to analyse the data for a few days, you can use the spod_get() function. It will download the raw data in CSV format and let you analyse it in-memory. This is what we cover in the steps on this page.
If you need longer periods (several months or years), you should use the spod_convert() and spod_connect() functions, which will convert the data into special format which is much faster for analysis, for this see the Download and convert OD datasets vignette. spod_get_zones() will give you spatial data with zones that can be matched with the origin-destination flows from the functions above using zones ’id’s. Please see a simple example below, and also consult the vignettes with detailed data description and instructions in the package vignettes with spod_codebook(ver = 1) and spod_codebook(ver = 2), or simply visit the package website at https://ropenspain.github.io/spanishoddata/. The Figure 1 presents the overall approach to accessing the data in the spanishoddata package.
1. Spatial data with zoning boundaries
The boundary data is provided at three geographic levels: Distrtics, Municipalities, and Large Urban Areas. It’s important to note that these do not always align with the official Spanish census districts and municipalities. To comply with data protection regulations, certain aggregations had to be made to districts and municipalities”.
1.1 Districts
Districts correspond to official census districts in cities; however, in those with lower population density, they are grouped together. In rural areas, one district is often equal to a municipality, but municipalities with low population are combined into larger units to preserve privacy of individuals in the dataset. Therefore, there are 3792 ‘districts’ compared to the 10494 official census districts on which they are based. There are also NUTS3 statistical regions covering France (94 units) and Portugal (23 units). Therefore there is a total of 3909 zones in the Districts dataset.
districts_v2 <- spod_get_zones("dist", ver = 2)The districts_v2 object is of class sf consisting of polygons.
Data structure:
| Variable Name | Description |
|---|---|
id |
District id assigned by the data provider. Matches with id_origin, id_destination, and id in district-level origin-destination and number of trips data. |
name |
Name of the district. |
population |
Number of individuals in the district according to INE2. |
census_sections |
Semicolon-separated list of census section identifiers that correspond to each district, classified by the Spanish Statistical Office (INE). |
census_districts |
Semicolon-separated list of census district identifiers corresponding to each district, as classified by the Spanish Statistical Office (INE). |
municipalities |
Semicolon-separated list of municipality identifiers corresponding to each district, as classified by the Spanish Statistical Office (INE). |
municipalities_mitma |
Semicolon-separated list of municipality identifiers as assigned by the data provider (MITMA). |
luas_mitma |
Semicolon-separated list of Large Urban Areas (LUAs) as assigned by the data provider, corresponding to each district. |
district_ids_in_v1 |
Semicolon-separated district identifiers from v1 data corresponding to each district in v2. If no match exists, marked as NA. |
geometry |
Spatial geometry of each district stored as a MULTIPOLYGON object, projected in the ETRS89 / UTM zone 30N CRS with XY dimensions. |
1.2 Municipalities
Municipalities are made up of official municipalities in those of a certain size; however, they have also been aggregated in cases of lower population density. As a result, there are 2618 municipalities compared to the 8,125 official municipalities on which they are based. There are also NUTS3 statistical regions covering France (94 units) and Portugal (23 units). Therefore there is a total of 2735 zones in the Districts dataset.
municipalities_v2 <- spod_get_zones("muni", ver = 2)The resulting municipalities_v2 object is type sf consisting of polygons.
Data structure:
| Variable Name | Description |
|---|---|
id |
District id assigned by the data provider. Matches with id_origin, id_destination, and id in district-level origin-destination and number of trips data. |
name |
Name of the district. |
population |
Number of individuals in the district according to INE3. |
census_sections |
Semicolon-separated list of census section identifiers that correspond to each district, classified by the Spanish Statistical Office (INE). |
census_districts |
Semicolon-separated list of census district identifiers corresponding to each district, as classified by the Spanish Statistical Office (INE). |
municipalities |
Semicolon-separated list of municipality identifiers corresponding to each district, as classified by the Spanish Statistical Office (INE). |
districts_mitma |
Semicolon-separated list of district identifiers as assigned by the data provider (MITMA). |
luas_mitma |
Semicolon-separated list of Large Urban Areas (LUAs) as assigned by the data provider, corresponding to each district. |
municipality_ids_in_v1 |
Semicolon-separated district identifiers from v1 data corresponding to each district in v2. If no match exists, marked as NA. |
geometry |
Spatial geometry of each district stored as a MULTIPOLYGON object, projected in the ETRS89 / UTM zone 30N CRS with XY dimensions. |
1.3 LUAs (Large Urban Areas)
Large Urban Areas (LUAs) has essentially the same spatial units as Municipalities, but are not aggregated. Therefore, there are 2086 locations in the LUAs dataset. There are also NUTS3 statistical regions covering France (94 units) and Portugal (23 units). Therefore there is a total of 2203 zones in the LUAs dataset.
luas_v2 <- spod_get_zones("lua", ver = 2)The resulting luas_v2 object is type sf consisting of polygons.
Data structure:
| Variable Name | Description |
|---|---|
id |
District id assigned by the data provider. Matches with id_origin, id_destination, and id in district-level origin-destination and number of trips data. |
name |
Name of the district. |
population |
Number of individuals in the district according to INE4. |
census_sections |
Semicolon-separated list of census section identifiers that correspond to each district, classified by the Spanish Statistical Office (INE). |
census_districts |
Semicolon-separated list of census district identifiers corresponding to each district, as classified by the Spanish Statistical Office (INE). |
municipalities |
Semicolon-separated list of municipality identifiers corresponding to each district, as classified by the Spanish Statistical Office (INE). |
districts_mitma |
Semicolon-separated list of district identifiers as assigned by the data provider (MITMA). |
municipalities_mitma |
Semicolon-separated list of municipality identifiers as assigned by the data provider (MITMA). |
geometry |
Spatial geometry of each district stored as a MULTIPOLYGON object, projected in the ETRS89 / UTM zone 30N CRS with XY dimensions. |
2. Mobility data
All mobility data is referenced via id_origin, id_destination, or other location identifiers (mostly labelled as id) with the two sets of zones described above.
2.1. Origin-destination data
The origin-destination data contain the number of trips between districts, municipalities, or large urban areas (LUAs) in Spain for every hour of every day between 2022-02-01 and whichever currently available latest data (2024-06-30 at the time of writing). Each flow also has attributes such as the trip purpose (composed of the type of activity (home/work_or_study/frequent_activity/infrequent_activity) at both the origin and destination, but also age, sex, and income of each group of individuals traveling between the origin and destination), province of residence of individuals making this trip, distance covered while making the trip. See the detailed attributes below in a table.
Here are the variables you can find in the district, municipality and large urban area level data:
| English Variable Name | Original Variable Name | Type | Description |
|---|---|---|---|
date |
fecha |
Date |
The date of the recorded data, formatted as YYYY-MM-DD. |
time_slot |
periodo |
integer |
The time slot during which the trips occurred. |
id_origin |
origen |
factor |
The origin zone id of district, municipality, or large urban area. |
id_destination |
destino |
factor |
The destination zone id of district, municipality, or large urban area. |
distance |
distancia |
factor |
The distance range of the trip, categorized into specific intervals such as 0.5-2 (500 m to 2 km), 2-10 (2-10 km), 10-50 (10-50km), and >50 (50 or more km). |
activity_origin |
actividad_origen |
factor |
The type of activity at the origin zone, recoded from casa, trabajo_estudio, frecuente, no_frecuente to home, work_or_study, frequent_activity, infrequent_activity respectively. |
activity_destination |
actividad_destino |
factor |
The type of activity at the destination zone, similarly recoded as for activity_origin above. |
study_possible_origin |
estudio_origen_posible |
logical |
TRUE if the activity at origin may be connected with study, and FALSE otherwise. |
study_possible_destination |
estudio_destino_posible |
logical |
TRUE if the activity at destination may be connected with study, and FALSE otherwise. |
residence_province_ine_code |
residencia |
factor |
The province code of residence of individuals making the trips in n_trips, encoded as province codes as classified by the Spanish Statistical Office (INE). |
residence_province_name |
Derived from residencia
|
factor |
The full name of the residence province, derived from the province code above. |
income |
renta |
factor |
The income group of individuals making the trips in n_trips. Categorized into <10, 10-15, and >15 (thousands of euros per year). The income for each individual is assigned based on the mean census tract income per person (data source is INE Household income distribution map). |
age |
edad |
factor |
The age group of individuals making the trips in n_trips. Categorized into 0-25, 25-45, 45-65, 65-100, or NA. The data is partially imputed, for details see this blogpost by Nommon. |
sex |
sexo |
factor |
The sex of individuals making the trips in n_trips. Categorized into female, male, or NA. The data is partially imputed, for details see this blogpost by Nommon. |
n_trips |
viajes |
numeric |
The number of trips for that specific origin-destination pair and time slot. |
trips_total_length_km |
viajes_km |
numeric |
The total length of trips in kilometers, summing up all trips between the origin and destination zones. |
year |
year |
integer |
The year of the recorded data, extracted from the date. |
month |
month |
integer |
The month of the recorded data, extracted from the date. |
day |
day |
integer |
The day of the recorded data, extracted from the date. |
Getting the data
To access the data, use the spod_get() function. In this example we will use a short interval of dates:
The data for the specified dates will be automatically downloaded and cached in the SPANISH_OD_DATA_DIR directory. Existing files will not be re-downloaded.
Working with the data
The resulting objects od_dist and od_muni are of class tbl_duckdb_connection5. Basically, you can treat these as regular data.frames or tibbles. One important difference is that the data is not actually loaded into memory, because if you requested more dates, e.g. a whole month or a year, all that data would most likely not fit into your computer’s memory. A tbl_duckdb_connection is mapped to the downloaded CSV files that are cached on disk and the data is only loaded in small chunks as needed at the time of computation. You can manipulate od_dist and od_muni using dplyr functions such as select(), filter(), mutate(), group_by(), summarise(), etc. In the end of any sequence of commands you will need to add collect() to execute the whole chain of data manipulations and load the results into memory in an R data.frame/tibble like so:
library(dplyr)
od_mean_trips_by_ses_over_the_4_days <- od_dist |>
group_by(date, age, sex, income) |>
summarise(
n_trips = sum(n_trips, na.rm = TRUE),
.groups = "drop") |>
group_by(age, sex, income) |>
summarise(
daily_mean_n_trips = mean(n_trips, na.rm = TRUE),
.groups = "drop") |>
collect()
od_mean_trips_by_ses_over_the_4_days# A tibble: 39 × 4
age sex income daily_mean_n_trips
<fct> <fct> <fct> <dbl>
1 NA NA <10 7002485.
2 NA NA 10-15 16551405.
3 NA NA >15 2651481.
4 0-25 NA <10 539060.
5 0-25 NA 10-15 1950892.
6 0-25 NA >15 401557.
7 0-25 female <10 1484989.
8 0-25 female 10-15 5357785.
9 0-25 female >15 1764454.
10 0-25 male <10 1558461.
# ℹ 29 more rows
# ℹ Use `print(n = ...)` to see more rowsIn this example above, becaus the data is with hourly intervals within each day, we first summed the number of trips for each day by age, sex, and income groups. We then grouped the data again dropping the day variable and calculated the mean number of trips per day by age, sex, and income groups. The full data for all 4 days was probably never loaded into memory all at once. Rather the available memory of the computer was used up to its maximum limit to make that calculation happen, without ever exceeding the available memory limit. If you were doing the same opearation on 100 or even more days, it would work in the same way and would be possible even with limited memory. This is done transparantly to the user with the help of DuckDB (specifically, with {duckdb} R package Mühleisen and Raasveldt (2024)).
The same summary operation as provided in the example above can be done with the entire dataset for multiple years worth of data on a regular laptop with 8-16 GB memory. It will take a bit of time to complete, but it will be done. To speed things up, please also see the vignette on converting the data into formats that will increase the analsysis performance.
Note
As long as you use a table connection object created with
spod_get()function, it is much quicker to filter the dates by theyear,monthanddayvariables, rather than by thedatevariable. This is because the data for each day is in a separate CSV file located in folders that look likeyear=2020/month=2/day=14. So when filtering by thedatefield, R will have to scan all CSV files comparing the specified date with what is stored inside each CSV file. However, if you query byyear,monthanddayvariables, R only needs to check these against the path to each CSV file, which is much quicker. This caveat is only relevant as long as you usespod_get(). If you convert (see the relevant vignette) the downloaded data to a format that it optimized for quick analysis, you can use whichever field you want, it should not affect the performance.
2.2. Number of trips data
For each location, the “number of trips” data provides the number of individuals who spent the night there, with breakdown by the number of trips made, age, and sex.
| English Variable Name | Original Variable Name | Type | Description |
|---|---|---|---|
date |
fecha |
Date |
The date of the recorded data, formatted as YYYY-MM-DD. |
id |
distrito |
factor |
The identifier of the district or municipality zone. |
age |
edad |
factor |
The age group of individuals making the trips in n_trips. Categorized into 0-25, 25-45, 45-65, 65-100, or NA. The data is partially imputed, for details see this blogpost by Nommon. |
sex |
sexo |
factor |
The sex of individuals making the trips in n_trips. Categorized into female, male, or NA. The data is partially imputed, for details see this blogpost by Nommon. |
n_trips |
numero_viajes |
factor |
The number of individuals who made trips, categorized by 0, 1, 2, or 2+ trips. |
n_persons |
personas |
factor |
The number of persons making the trips from district, municipality, or large urban area (LUA) with zone id. |
year |
year |
integer |
The year of the recorded data, extracted from the date. |
month |
month |
integer |
The month of the recorded data, extracted from the date. |
day |
day |
integer |
The day of the recorded data, extracted from the date. |
Getting the data
To access it use spod_get() with type set to “number_of_trips”, or just “nt”.
Because this data is small, we can actually load it completely into memory:
nt_dist_tbl <- nt_dist |> dplyr::collect()2.3. Overnight stays
This dataset provides the number of people who spend the night in each location, also identifying their place of residence down to the census district level according to the INE encoding.
Here are the variables you can find in the district, municipality and large urban area level data:
| English Variable Name | Original Variable Name | Type | Description |
|---|---|---|---|
date |
fecha |
Date |
The date of the recorded data, formatted as YYYY-MM-DD. |
id_residence |
zona_residencia |
factor |
The identifier of the census district according to the INE encoding. |
id_overnight_stay |
zona_pernoctacion |
factor |
The identifier of the district, municipality, or large urban area (LUA) zone. |
n_persons |
personas |
factor |
The number of persons making the trips from district, municipality, or large urban area with zone id. |
year |
year |
integer |
The year of the recorded data, extracted from the date. |
month |
month |
integer |
The month of the recorded data, extracted from the date. |
day |
day |
integer |
The day of the recorded data, extracted from the date. |
Getting the data
To access it use spod_get() with type set to “number_of_trips”, or just “nt”.
Because this data is small, we can actually load it completely into memory:
os_dist_tbl <- os_dist |> dplyr::collect()
Mühleisen, Hannes, and Mark Raasveldt. 2024. Duckdb: DBI Package for the DuckDB Database Management System. https://doi.org/10.32614/CRAN.package.duckdb.
Secretaría de Estado de Transportes y Movilidad Sostenible. 2024. “Estudio de movilidad de viajeros de ámbito nacional aplicando la tecnología Big Data. Informe metodológico (Study of National Traveler mobility Using Big Data Technology. Methodological Report).” https://www.transportes.gob.es/ministerio/proyectos-singulares/estudio-de-movilidad-con-big-data.