MiaoTruck: Data manupulation for the NSF truck data.

title: "Vignette - transportation safety data" author: - Miao Cai^[Department of Epidemiology and Biostatistics, Saint Louis University. Email address miao.cai@slu.edu] - Amir Mehdizadeh^[Department of Industrial & Systems Engineering, Auburn University] - Fadel M. Megahed^[Farmer School of Business, Miami University. This author can be reached by email at fmegahed@miamioh.edu.]

date: "2018-09-06" output: html_document: toc: true toc_float: true number_sections: true df_print: paged code_folding: hide

The first step to make accurate crash prediction is obstaining high quality data. This vignette is a reproducible demonstration on extracting online transportation safety data.

Weather data

In this part, we show how to get both historical and real-time weather data using DarkSky API. It can be used in both Python and R. Before using the DarkSky API to get weather data, you need to register for a API key on its official website. The first 1000 API requests you make each day are free, but each API request over the 1000 daily limit will cost you $0.0001, which means a million extra API requests will cost you 100 USD.

The DarkSky API provides the following meteoreological variables:

Apparent (feels-like) temperature
Atmospheric pressure
Cloud cover
Dew point
Humidity
Liquid precipitation rate
Moon phase
Nearest storm distance
Nearest storm direction
Ozone
Precipitation type
Snowfall
Sun rise/set
Temperature
Text summaries
UV index
Wind gust
Wind speed
Wind direction

The data provided by darksky API includes 3 parts:

hourly weather data. 24 hourly observations for each 15 weather variables in that day.
daily weather data. 1 observations for each 34 weather variables in that day.
current weather data. 1 observations for each 15 weather variables at the assigned time point.

In this part of the vignette, we will show the readers how to get historical and real-time weather data for a sample of 20 observations. The orginal data include only three variables: longitude, latitude, and the local time, which are the required variables to obtain weather data from DarkSky API. Below is how the orginal data look like:

gps_sample = 
  structure(list(
    from_lat = c(41.3473127, 41.8189037, 32.8258477, 
40.6776808, 40.2366043, 41.3945561, 32.6320605, 40.5413856, 33.6287422, 
40.0692742, 41.347986, 37.7781459, 43.0843081, 41.48026, 43.495149, 
41.5228684, 41.5763081, 47.6728665, 41.0918361, 41.1537819),
    from_lon = c(-74.2850908, -73.0835104, -97.0306677, -75.1450753, 
    -76.9367494, -72.8589916, -96.8538145, -74.8547061, -113.7671634, 
    -76.762612, -74.284785, -77.4615586, -76.0977384, -73.2107541, 
    -73.7727896, -74.0739204, -88.1529175, -117.3224667, -74.1554972, 
    -74.1887031), 
  beg_time = structure(c(1453101738, 1437508088, 
    1436195038, 1435243088, 1454270680, 1432210106, 1438937772, 
    1446486480, 1450191622, 1449848630, 1457597084, 1432870446, 
    1457968284, 1451298724, 1431503502, 1443416864, 1438306368, 
    1445540454, 1452619392, 1436091072), class = c("POSIXct", 
    "POSIXt"), tzone = "UTC")), .Names = c("from_lat", "from_lon", 
"beg_time"), row.names = c(NA, 20L), class = c("tbl_df", "tbl", 
"data.frame"))

gps_sample

{"columns":[{"label":[""],"name":["_rn_"],"type":[""],"align":["left"]},{"label":["from_lat"],"name":[1],"type":["dbl"],"align":["right"]},{"label":["from_lon"],"name":[2],"type":["dbl"],"align":["right"]},{"label":["beg_time"],"name":[3],"type":["S3: POSIXct"],"align":["right"]}],"data":[{"1":"41.34731","2":"-74.28509","3":"2016-01-18 07:22:18","_rn_":"1"},{"1":"41.81890","2":"-73.08351","3":"2015-07-21 19:48:08","_rn_":"2"},{"1":"32.82585","2":"-97.03067","3":"2015-07-06 15:03:58","_rn_":"3"},{"1":"40.67768","2":"-75.14508","3":"2015-06-25 14:38:08","_rn_":"4"},{"1":"40.23660","2":"-76.93675","3":"2016-01-31 20:04:40","_rn_":"5"},{"1":"41.39456","2":"-72.85899","3":"2015-05-21 12:08:26","_rn_":"6"},{"1":"32.63206","2":"-96.85381","3":"2015-08-07 08:56:12","_rn_":"7"},{"1":"40.54139","2":"-74.85471","3":"2015-11-02 17:48:00","_rn_":"8"},{"1":"33.62874","2":"-113.76716","3":"2015-12-15 15:00:22","_rn_":"9"},{"1":"40.06927","2":"-76.76261","3":"2015-12-11 15:43:50","_rn_":"10"},{"1":"41.34799","2":"-74.28478","3":"2016-03-10 08:04:44","_rn_":"11"},{"1":"37.77815","2":"-77.46156","3":"2015-05-29 03:34:06","_rn_":"12"},{"1":"43.08431","2":"-76.09774","3":"2016-03-14 15:11:24","_rn_":"13"},{"1":"41.48026","2":"-73.21075","3":"2015-12-28 10:32:04","_rn_":"14"},{"1":"43.49515","2":"-73.77279","3":"2015-05-13 07:51:42","_rn_":"15"},{"1":"41.52287","2":"-74.07392","3":"2015-09-28 05:07:44","_rn_":"16"},{"1":"41.57631","2":"-88.15292","3":"2015-07-31 01:32:48","_rn_":"17"},{"1":"47.67287","2":"-117.32247","3":"2015-10-22 19:00:54","_rn_":"18"},{"1":"41.09184","2":"-74.15550","3":"2016-01-12 17:23:12","_rn_":"19"},{"1":"41.15378","2":"-74.18870","3":"2015-07-05 10:11:12","_rn_":"20"}],"options":{"columns":{"min":{},"max":[10]},"rows":{"min":[10],"max":[10]},"pages":{}}}

library(darksky)
library(tidyverse)

Sys.setenv(DARKSKY_API_KEY = "9f219edf4689a0f26a83aa4d9a46f25a")

t = get_forecast_for(38.642105, -90.244440, Sys.time())

The following 39 meteoreological variables can be obtained from DarkSky API.

time
summary
icon
sunriseTime
sunsetTime
moonPhase
precipIntensity
precipIntensityMax
precipIntensityMaxTime
precipProbability
precipType
temperatureHigh
temperatureHighTime
temperatureLow
temperatureLowTime
apparentTemperatureHigh
apparentTemperatureHighTime
apparentTemperatureLow
apparentTemperatureLowTime
dewPoint
humidity
pressure
windSpeed
windGust
windGustTime
windBearing
cloudCover
uvIndex
uvIndexTime
visibility
ozone
temperatureMin
temperatureMinTime
temperatureMax
temperatureMaxTime
apparentTemperatureMin
apparentTemperatureMinTime
apparentTemperatureMax
apparentTemperatureMaxTime

A example of these daily variables for the observation t is shown as below:

as.data.frame(t[[2]])

The following 18 meteoreological variables can be obtained from DarkSky API. For each variabele, there are 24 observations for them, which represents the hourly weather data in that day.

time
summary
icon
precipIntensity
precipProbability
temperature
apparentTemperature
dewPoint
humidity
pressure
windSpeed
windGust
windBearing
cloudCover
uvIndex
visibility
ozone
precipType

The hourly historical weather data for the observation t is shown below:

t[[1]]

time
summary
icon
precipIntensity
precipProbability
temperature
apparentTemperature
dewPoint
humidity
pressure
windSpeed
windGust
windBearing
cloudCover
uvIndex
visibility
ozone

The sample real-time data for the observation t is shown below:

as.data.frame(t[[3]])

{"columns":[{"label":["time"],"name":[1],"type":["S3: POSIXct"],"align":["right"]},{"label":["summary"],"name":[2],"type":["chr"],"align":["left"]},{"label":["icon"],"name":[3],"type":["chr"],"align":["left"]},{"label":["sunriseTime"],"name":[4],"type":["S3: POSIXct"],"align":["right"]},{"label":["sunsetTime"],"name":[5],"type":["S3: POSIXct"],"align":["right"]},{"label":["moonPhase"],"name":[6],"type":["dbl"],"align":["right"]},{"label":["precipIntensity"],"name":[7],"type":["dbl"],"align":["right"]},{"label":["precipIntensityMax"],"name":[8],"type":["dbl"],"align":["right"]},{"label":["precipIntensityMaxTime"],"name":[9],"type":["S3: POSIXct"],"align":["right"]},{"label":["precipProbability"],"name":[10],"type":["dbl"],"align":["right"]},{"label":["precipType"],"name":[11],"type":["chr"],"align":["left"]},{"label":["temperatureHigh"],"name":[12],"type":["dbl"],"align":["right"]},{"label":["temperatureHighTime"],"name":[13],"type":["int"],"align":["right"]},{"label":["temperatureLow"],"name":[14],"type":["dbl"],"align":["right"]},{"label":["temperatureLowTime"],"name":[15],"type":["int"],"align":["right"]},{"label":["apparentTemperatureHigh"],"name":[16],"type":["dbl"],"align":["right"]},{"label":["apparentTemperatureHighTime"],"name":[17],"type":["int"],"align":["right"]},{"label":["apparentTemperatureLow"],"name":[18],"type":["dbl"],"align":["right"]},{"label":["apparentTemperatureLowTime"],"name":[19],"type":["int"],"align":["right"]},{"label":["dewPoint"],"name":[20],"type":["dbl"],"align":["right"]},{"label":["humidity"],"name":[21],"type":["dbl"],"align":["right"]},{"label":["pressure"],"name":[22],"type":["dbl"],"align":["right"]},{"label":["windSpeed"],"name":[23],"type":["dbl"],"align":["right"]},{"label":["windGust"],"name":[24],"type":["dbl"],"align":["right"]},{"label":["windGustTime"],"name":[25],"type":["int"],"align":["right"]},{"label":["windBearing"],"name":[26],"type":["int"],"align":["right"]},{"label":["cloudCover"],"name":[27],"type":["dbl"],"align":["right"]},{"label":["uvIndex"],"name":[28],"type":["int"],"align":["right"]},{"label":["uvIndexTime"],"name":[29],"type":["int"],"align":["right"]},{"label":["visibility"],"name":[30],"type":["int"],"align":["right"]},{"label":["ozone"],"name":[31],"type":["dbl"],"align":["right"]},{"label":["temperatureMin"],"name":[32],"type":["dbl"],"align":["right"]},{"label":["temperatureMinTime"],"name":[33],"type":["S3: POSIXct"],"align":["right"]},{"label":["temperatureMax"],"name":[34],"type":["dbl"],"align":["right"]},{"label":["temperatureMaxTime"],"name":[35],"type":["S3: POSIXct"],"align":["right"]},{"label":["apparentTemperatureMin"],"name":[36],"type":["dbl"],"align":["right"]},{"label":["apparentTemperatureMinTime"],"name":[37],"type":["S3: POSIXct"],"align":["right"]},{"label":["apparentTemperatureMax"],"name":[38],"type":["dbl"],"align":["right"]},{"label":["apparentTemperatureMaxTime"],"name":[39],"type":["S3: POSIXct"],"align":["right"]}],"data":[{"1":"2018-09-06","2":"Light rain starting in the afternoon.","3":"rain","4":"2018-09-06 06:36:15","5":"2018-09-06 19:25:13","6":"0.89","7":"0.0162","8":"0.0511","9":"2018-09-06 22:00:00","10":"0.74","11":"rain","12":"85.42","13":"1536260400","14":"70.63","15":"1536325200","16":"89.12","17":"1536256800","18":"71.98","19":"1536325200","20":"70.05","21":"0.76","22":"1019.92","23":"4.37","24":"14.52","25":"1536289200","26":"96","27":"0.51","28":"7","29":"1536256800","30":"10","31":"273.17","32":"71.27","33":"2018-09-06 07:00:00","34":"85.42","35":"2018-09-06 14:00:00","36":"72.54","37":"2018-09-06 07:00:00","38":"89.12","39":"2018-09-06 13:00:00"}],"options":{"columns":{"min":{},"max":[10]},"rows":{"min":[10],"max":[10]},"pages":{}}}

We can also customize our data by pooled the daily, hourly and real-time weather variables together in one table using loops. One example has been shown as below:

caimiao0714/MiaoTruck documentation built on May 28, 2019, 7:14 p.m.

rdrr.io home R language documentation Run R code online

CRAN packages Bioconductor packages R-Forge packages GitHub packages

Note that we can't provide technical support on individual packages. You should contact the package authors for that.

Tweet to @rdrrHQ

GitHub issue tracker

ian@mutexlabs.com