1.251/11.526 Comparative Land Use and Transportation Planning
Spring 2011
Instructor: P. Christopher Zegras
TAs: Vignesh Krishnamurthy, Lulu Xue
Lecture: TR11-12.30 (5-217)
Announcements
Tomorrow (4/12): Baltimore studio pin-up 4-8 @ 3-450A
Please inform your respective team members that the Baltimore studio will be having a pin-up tomorrow from 4.15pm to 8pm @ 3-405A . If you are interested in knowing the details of your intervention sites, please send one rep to the pin-up.
If your team cannot make the pin-up, shortly after it, your client groups will furnish you with the following information:
· a short paragraph summary on the plan/vision and its major goals;
· a table quantifying proposed land use changes (addition or demolition of housing units, new types of land uses envisioned, approximate square footage change in land use by land use type).
· a sentence or two on any anticipated social changes in the area (changes in family structure, income, employment, incomes)
· a description of any proposed transportation changes (to infrastructure or to service); and
· a rough map sketching where the expect proposed changes will occur.
Feel free to contact your clients for any missing pieces of information that concern your assignment and may or may not be included in the above checklist.
Good luck.
Lulu
Announced on 11 April 2011 2:38 p.m. by Lulu Xue
TAZ IDs for table join
Some of you have asked about the common TAZ IDs to join the travel survey to the TAZ shapefile, hope this would be useful: the fields of TAZ00 and home_bmc_taz point to the same TAZ.
1. Join the household table in the survey to the TAZ shapefile: use the field home_bmc_taz in the survey (or bmctaz in the access database that we just posted to the class locker) and the field TAZ00 in the TAZ shapefile
2. Join the peak-hour skim to the TAZ shapefile: use the field TAZ00 in the TAZ shapefile and the field hbw1 in the skim matrix (note that the rows of the matrix indicate origins, and the columns indicate destinations; therefore, you may need to transpose the matrix before you perform table join).
Also, for your convenience, we uploaded an Access database to the class locker that includes all the tables from the travel survey so that you can join these tables using the query tools in Access.
Best,
Lulu
Announced on 07 April 2011 9:25 p.m. by Lulu Xue
More Questions and Answers about 3A data
Dear Class: I have received a few questions about how to join together the different tables in the BaltimoreTravelSurvey file, and so I wanted to share the answer with you all.FIRST: a couple of more glitches have been spotted, and so, BaltimoreTravelSurvey has been again revised to BaltimoreTravelSurvey_rev2.xlsx. Major revision is that the PersonDataTable has been fixed (somehow it was just a duplicated of the hhld table before).
Also, there were truncations in the data for skimOffPK_2020.xls and skimPK_2020.xls. New and complete versions are in the locker (skimOffPK_2020_rev1.xls and skimPK_2020_rev1.xls)
JOINING TABLES
The two important fields are "sampn" and
"personid"
"sampn" identifies the household that each record belongs to. There is a one-to-many relationship between "sampn" and records in the Person Table, Trip Table and Vehicle Table (because each household can have more than one person, make more than one trip, and own multiple vehicles). 'sampn' exists in all the 4 data tables.
"personid" identifies persons in households (sampn+two digits). You will find it in 2 tables: the Person Table and the Trip Table. One 'sampn' can be associated with several "personid" values, and in the Trip Table, each "personid" may have multiple records that reflect the same individual making several trips.
For those comfortable with Access, it could be useful to import
the tables since it handles one-to-many relationships in a much
cleaner way.
If you want to work in Excel, the 'VLOOKUP' function can be
a very efficient way to call up fields from one table and display
them in another based on a shared field (e.g. if you want to relate
each record in Trip Table with the appropriate gender value for
that person from the Person Table)
LASTLY
The slides for the HCM recitation have been posted on Stellar under
the 'goodies' section.
Cheers,
Vig
Announced on 06 April 2011 9:45 p.m. by Vignesh Krishnamurthy
Assignment 3 TAs and Course Locker
Hi Class: As you have probably heard from Prof Zegras, Lulu and I are sharing the TA responsibilities for Assignment 3 by assigning your groups to either one of us as the primary 'go to person.' This is so you have a more consistent relationship with one of us over the two parts of the assignment. I do not have the full team memberships, and so, apologies for identifying the teams by only one member (as well as the delay in sending this out).Teams with Vig (vig@mit.edu) as lead TA
- Naomi and company
- Rachel B and company
- Ann-Ariel and company
Teams with Lulu (luluxue@mit.edu) as lead TA
- Jessica and company
- Yonah and company
IMPORTANT NOTE ABOUT COURSE LOCKER!
One of the shortcomings of the course locker is that everyone has
read/write privileges. To avoid any accidental alteration to the
original data, please copy the data to another location (local disk
or your own athena space) before doing ANY analysis.
Also, one of your classmates noted that the header row for the HHLD table in Baltimore Travel Survey.xlsx is missing. This file has been removed ans a new revised 'Baltimore Travel Survey_rev1.xlsx' has been placed in the locker. Sorry for any trouble.
Good luck with your analysis for part 3A!
Cheers,
Vig
Announced on 05 April 2011 10:02 p.m. by Vignesh Krishnamurthy
MD Census Data and Recitation Location
Hi Class: One of your classmates has kindly asked us to share the Maryland GIS website as a source of data for your Assignment 3A. The site has 2010 Census Tract boundary shapefiles available. (2010 block group boundaries available as well though the block group data isn't available yet)http://planning.maryland.gov/MSDC/S5_Map_GIS.shtml
For those coming to the HCM recitation, the location is 9-450A (2-3pm Wednesday).
Vig
Announced on 05 April 2011 10:04 a.m. by Vignesh Krishnamurthy
