- Dissertation: Mi Diao (2010),
"Sustainable Metropolitan Growth Strategies:Exploring the Role of
the Built Environment" in MIT's DSpace:
https://dspace.mit.edu/handle/1721.1/62125, pages 1-44.
- What key question(s) is Mi Diao exploring in his dissertation
- What does literature say about relationship between built
environment and VMT?
- What datasets does he utilize?
- What built environment attributes are linked to VMT, vehicle
ownership, total travel...?
- What are key advantages and limitations regarding indicator choices?
- Review datasets and factor analysis in Chapter 2
- MassGIS basemaps & 250x250m grid cells (as shapefiles and
PostGIS geometry tables)
- Empty 250x250m grid cells for entire state (g_all_stategrid)
- Metro Boston grid cells with >0 vehicles (g_bos_vmt_grid)
- Massachusetts 351 cities and towns (g_ma_towns00)
- Mass 2000 census block groups (g_ma2000bg_stateplane)
- Mass 2008 traffic analysis zones [TAZ] with codas
(g_taz2727_codas)
- Massachusetts tabular data
- Built environment characteristics of grid cells
(built_environment_250m)
- MAPC Community type designation of grid cells (ct_grid)
- Census data for 2000 Mass block groups (demographic_bg)
- Vehicle miles traveled (VMT) estimate for grid cells (vmt_250m)
- Illustrate use of Software to explore datasets
- Next Tuesday's Lab #1
- Use Rstudio to explore Postgres datasets and
rebuild Mi Diao's indicators and models
- Pull Postgres tables into Rstudio
- Connect R to Postgres using RPostgreSQL
library (in lab #1 next week)
UAchannel <- dbConnect("PostgreSQL", dbname = "class946", host =
"cronpgsql.mit.edu", port = 5432, user = "myUserName", password
= "myPassword")
- Illustrate by grabbing several rows and columns of vmt_250m
select g250m_id, hshld_2000, no_vin, vmt_vin, vmt_hh
from vmtdata.vmt_250m limit 100;
Before Lecture #2 on Thursday
- Read rest of Chapter 3 in Prof. Mi Diao's dissertation (through page
55)
- Begin getting comfortable with datasets and software
- Do 'warmup' Lab: http://web.mit.edu/11.s946/www/lab_warmup/
- Login to Postgres on cronpgsql.mit.edu and change temporary password
to a new strong password without spaces or special
characters
- Try using 'startup' QGIS project in class locker, but DO NOT save
name/password in project file
- Use Friday's lab (from 2:30 - 4:30 in 9-554) to finish getting
comfortable
Readings
These additional readings are available on Stellar (http://stellar.mit.edu):
- PDF of slides from Mi Diao's dissertation defense (Aug. 2010) - diaomi_dissertation_defense_v6.pdf
- Cervero & Kockelman paper on 3Ds: "Travel Demand and the 3Ds: Density, Diversity, and Design," - Cervero_1997.pdf
- Link to review of VMT/Land-use/Transportation relationships (2012) - VMT_readings.txt
- Journal article on Chapter 3: M. Diao and J. Ferreira, "Vehicle miles
traveled and the built environment:
evidence from vehicle safety inspection data," EPA, v.46 (2014),
doi:10.1068/a140039p.
Created by Joe Ferreira (2017); Last
modified: October 17, 2017 [jf]
Back to DUSP | CRON
| MIT | MiniClass
Homepage