fslogisticskampala

The goal of fslogisticskampala is to provide data sources on faecal sludge transporting logistics in Kampala, Uganda collected from 30th March 2015 until 25th June 2015.

Installation

You can install the development version of fslogisticskampala from GitHub with:

# install.packages("devtools")
devtools::install_github("openwashdata/fslogisticskampala")

## Run the following code in console if you don't have the packages
## install.packages(c("dplyr", "knitr", "readr", "stringr", "gt", "kableExtra". "leaflet"))
library(dplyr)
library(knitr)
library(readr)
library(stringr)
library(gt)
library(kableExtra)
library(leaflet)

Alternatively, you can download the individual datasets as a CSV or XLSX file from the table below.

dataset	CSV	XLSX
trips	Download CSV	Download XLSX
trucks	Download CSV	Download XLSX

Data

The package provides access to two datasets trips and trucks.

library(fslogisticskampala)

trips

The dataset trips contains data about the GPS locations of faecal sludge trucks collecting sludge from pit latrines and septic tanks in Kampala, Uganda. Each trip is recorded with a unique identifier, the numberplate of the truck, the date and time of the record. Data was collected from 30th March 2015 until 25th June 2015. It has 5653 observations and 7 variables

trips |> 
  head(3) |> 
  gt::gt() |>
  gt::as_raw_html()

fid	numberplate	date	time	lat	lon	plant
117	AUS 119X	2015-03-30	10:53:03	0.358437	32.55036	Bugolobi
118	AUS 119X	2015-03-31	03:53:41	0.348626	32.57229	Bugolobi
119	AUS 119X	2015-03-31	10:33:01	0.322447	32.56255	Bugolobi

For an overview of the variable names, see the following table.

variable_name	variable_type	description
fid	numeric	Running ID for each recorded GPS location of a truck.
numberplate	character	Numberplate of the truck, can be joined with `trucks` resource.
date	Date	Date of the record in ISO 8601 format.
time	c(“hms”, “difftime”)	Time of the record in hours, minutes, seconds.
lat	numeric	Latitude of the record.
lon	numeric	Longitude of the record.
plant	character	Treatment plant that the truck delivered faecal sludge to.

trucks

The dataset trucks contains data about additional information on the volume of each truck used in the dataset trips. It has 35 observations and 2 variables

trucks |> 
  head(3) |> 
  gt::gt() |>
  gt::as_raw_html()

numberplate	volume
AUS 119X	3
UAG 448X	35
UAN 030N	3

For an overview of the variable names, see the following table.

variable_name	variable_type	description
numberplate	character	Numberplate of the truck, can be joined with `trips` resource.
volume	numeric	Volume of the truck in cubic meters.

Example 1

A plot showing the collection locations of the truck with number plate “AUS 119X”

library(fslogisticskampala)
library(ggplot2)
library(lubridate)

aus <- trips |>
  dplyr::filter(numberplate == "AUS 119X") |>
  dplyr::filter(date < ymd("2015-04-06"))

ggplot(aus, aes(x = lon, y = lat, color = date)) +
  geom_point() +
  labs(title = "GPS Locations of Faecal Sludge Trucks",
       x = "Longitude",
       y = "Latitude",
       color = "Treatment Plant") +
  theme_minimal()

Example 2

An interactive map of all collection points

map = leaflet(data = trips) |>
   addTiles() |>
   addCircleMarkers(~lon, ~lat 
                    ,popup = ~as.character(plant)
                    , color = ~ifelse(plant == "Bugolobi" , "red", "blue")
                    , radius = 0.5
                    ) |>
  addMarkers(lng = ~c(32.6071673,32.5458844)
             ,lat = ~c(0.3190139,0.3472747)
             ,popup = ~c("Bugolobi FS treatment plant","Lubigi FS treatment plant")
             )
map

Map with collection locations and the existing treatment plants

License

Data are available as CC-BY.

Citation

Please cite this package using:

citation("fslogisticskampala")
#> To cite package 'fslogisticskampala' in publications use:
#> 
#>   Schöbitz L (2024). _fslogisticskampala: Data on faecal sludge
#>   transporting logistics in Kampala, Uganda_. R package version
#>   0.0.0.9000, commit bd332898fba450fc7e0af6d514c9dad9e20f6b11,
#>   <https://github.com/openwashdata/fslogisticskampala>.
#> 
#> A BibTeX entry for LaTeX users is
#> 
#>   @Manual{,
#>     title = {fslogisticskampala: Data on faecal sludge transporting logistics in Kampala, Uganda},
#>     author = {Lars Schöbitz},
#>     year = {2024},
#>     note = {R package version 0.0.0.9000, commit bd332898fba450fc7e0af6d514c9dad9e20f6b11},
#>     url = {https://github.com/openwashdata/fslogisticskampala},
#>   }

Name		Name	Last commit message	Last commit date
.github		.github
R		R
data-raw		data-raw
data		data
docs		docs
inst/extdata		inst/extdata
man		man
.Rbuildignore		.Rbuildignore
.Rhistory		.Rhistory
.gitignore		.gitignore
CITATION.cff		CITATION.cff
DESCRIPTION		DESCRIPTION
LICENSE.md		LICENSE.md
NAMESPACE		NAMESPACE
README.Rmd		README.Rmd
README.md		README.md
_pkgdown.yml		_pkgdown.yml
fslogisticskampala.Rproj		fslogisticskampala.Rproj

Navigation Menu

Repository files navigation

fslogisticskampala

Installation

Data

trips

trucks

Example 1

Example 2

License

Citation

About

Releases

Packages

Contributors

Languages

Latest commit

History

Folders and files

Repository files navigation

fslogisticskampala

Installation

Data

trips

trucks

Example 1

Example 2

License

Citation

About

Resources

Stars

Watchers

Forks

Releases

Packages

Contributors

Languages