Skip to content

πŸ‡¨πŸ‡± Chilean Origin - Destination Survey 2012 in CSV format

Notifications You must be signed in to change notification settings

robsalasco/chilean_od_data

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

6 Commits
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

Chilean Origin - Destination data

This data has been retrieved from the MTT's EOD Survey 2012 (https://www.sectra.gob.cl/biblioteca/detalle1.asp?mfn=3253).

How I got access

library(RJDBC)
library(readr)

options(java.parameters = "-Xmx4g")

conn <- dbConnect(JDBC("net.ucanaccess.jdbc.UcanloadDriver",
                       "/Users/robsalasco/Documents/Dev/chilean_od_data/UCanAccess-4.0.4-bin/loader/ucanload.jar"),
                       "jdbc:ucanaccess:https:///Users/robsalasco/Documents/Dev/chilean_od_data/base_datos_eodStgo_2012.accdb")

dbListTables(conn)

t <- dbSendQuery(conn, "SELECT * FROM Viaje")
t <- dbFetch(t)

write_csv(t, "table_Viajes.csv")

About

πŸ‡¨πŸ‡± Chilean Origin - Destination Survey 2012 in CSV format

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published