We invite you to join us on Friday, January 7, 2022 from 11:00 AM - 1:00 PM ET for a Virtual Census Data for Transportation Planning Subcommittee Meeting (AED20(1)). Our speakers are covering an exciting lineup of Census topics:
* Disclosure Avoidance Procedures in the 2020 Decennial Census
* Urban Areas from the 2020 Decennial Census
* Census Transportation Planning Product and AASHTO Updates
Below is the Zoom Meeting information to add to your calendar so you don’t miss out! You do not need to be registered for the 2022 TRB annual meeting in order to attend the AED20(1) subcommittee meeting.
Please feel free to contact Clara Reschovsky at clara.reschovsky(a)dot.gov<mailto:clara.reschovsky@dot.gov> or Kathy Yu at kyu(a)nctcog.org<mailto:kyu@nctcog.org> if you have any additional questions.
ZOOM MEETING INFO:
Join from PC, Mac, Linux, iOS or Android: https://nasem.zoom.us/j/97241572754?pwd=UkQrZHU3ZkliWHhybjd2Z0NMQURNUT09
Password: 385153
Or iPhone one-tap :
US: +13017158592,,97241572754# or +13126266799,,97241572754#
Or Telephone:
Dial(for higher quality, dial a number based on your current location):
US: +1 301 715 8592 or +1 312 626 6799 or +1 470 250 9358 or +1 470 381 2552 or +1 646 518 9805 or +1 646 558 8656 or +1 651 372 8299 or +1 786 635 1003 or +1 267 831 0333 or +1 720 928 9299 or +1 971 247 1195 or +1 213 338 8477 or +1 253 215 8782 or +1 346 248 7799 or +1 602 753 0140 or +1 669 219 2599 or +1 669 900 6833
Meeting ID: 972 4157 2754
Password: 385153
International numbers available: https://nasem.zoom.us/u/addQLX3gGO
If calling in via phone, first open the web link to retrieve the Participant ID. Enter the Participant ID after the prompt on the phone.
Would you like to test your Zoom connection? Please click on the link below.
https://nasem.zoom.us/test
NOTICE: The Zoom service allows audio and any materials exchanged or viewed during the session to be recorded and shared. Please be aware that by participating in this activity, you consent to your voice, likeness, and any materials you provide, being recorded for use and dissemination, without payment of any compensation for such use, in any language, format, or media now known or later devised, and you release the National Academies of Sciences, Engineering, and Medicine from any and all claims, liability, or damages arising from any such use. The Academies will proceed in reliance upon such consent and release. If you do not consent to the foregoing, please do not join the session.
Code of Conduct: The National Academies of Sciences, Engineering, and Medicine (NASEM) follows the NASEM guidelines in preventing discrimination, harassment, and bullying of participants at NASEM events, including conferences. http://www.nationalacademies.org/about/NA_186023.html<https://gcc02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.nation…>
Clara Reschovsky
Survey Statistician/Confidentiality Officer
Bureau of Transportation Statistics
Department of Transportation
This was posted on the new CTPP mailing list this morning. You must
subscribe at
https://listserv.transportation.org/mailman3/lists/ctpp.listserv.transporta…
to stay connected.
------------------------------------
Hi all,
Join us on Wednesday, September 22 at 2-4 pm ET for a CTPP training
course on software basics:
* CTPP Data Access Software Basics on September 22 at 2-4 pm ET*
The CTPP Program is offering a two-hour training session where you'll
learn the basics of the CTPP data access software. You'll learn how to
navigate the software, select geographies, find tables, and more! Click
the link below to register today.
https://aashto.adobeconnect.com/software1/event/registration.html
<https://aashto.adobeconnect.com/software1/event/registration.html>
This is the start of a new monthly training series that will cover a
range of topics, including basic and advanced software instruction, data
issues, charts and graphs, feature presentations, and more.
Hope to see you there!
Team CTPP
Kyla Elzinga, AASHTO
-------------------------------------
--
Ed Christopher
Transportation Planning Consultant
708-269-5237
Don't forget to head over to listserv.transportation.org to sign up for the new CTPP news list. This one will be discontinued soon. You have likely received an invitation to the new list - 156 of you have accepted, and there's a new message there today.
Penelope Weinberger
She/They
CTPP Program Manager
AASHTO
Ctpp.transportation.org
Hello researchers!
CTPP is hosting a Census Data for Transportation Planning conference (and a call for presentations is coming) but attached please see a call for commissioned papers. Letters of interest with quals and an abstract are due Sept.10. Please be aware that your successful submission expects your attendance at our conference in Reno, NV, June 7 - 9, 2022
Penelope Weinberger
She/They
CTPP Program Manager
AASHTO
Ctpp.transportation.org
Hello CTPPers!
At long last the CTPP list is being migrated. The new list address will be:
ctpp(a)listserv.transportation.org
You will be migrated automatically.
The list lives at listserve.transportation.org and it is called CTPP
Penelope Weinberger
She/They
CTPP Program Manager
AASHTO
Ctpp.transportation.org
Hi,
I am new to the list and I want to post 2 questions:
1. Since CTPP data is based on ACS data and the lowest level of geography of ACS data is block groups, how was CTPP data generated at TAZ level?
2. Since TAZ level CTPP data will be discontinued, what will be the best practice to get TAZ level demographic, socioeconomic and housing characteristics data as input layers to travel demand model?
Thanks!
Best,
Xinbo Mi
Transportation Engineer
Evansville Metropolitan Planning Organization
1NW Martin Luther King Jr. Blvd. Room 316
Evansville, Indiana 47708
Office Main Line 812.436.7833
www.evansvillempo.com<http://www.evansvillempo.com/>
[new logo_smaller]
Hello CTPP-News:
Well, the newest news is that Census 2020 PL94-171 data is re-scheduled for release this coming Thursday, August 12th. Hope everyone is ready.
I did a lot of messing around with the R package TIGRIS this past spring. I’m not sure why I didn’t share it at that time, but here it is now. Hope it helps.
https://www.rdocumentation.org/packages/tigris/versions/1.4.1 <https://www.rdocumentation.org/packages/tigris/versions/1.4.1>
from the author’s page:
tigris is an R package that allows users to directly download and use TIGER/Line shapefiles (https://www.census.gov/geographies/mapping-files/time-series/geo/tiger-line… <https://www.census.gov/geographies/mapping-files/time-series/geo/tiger-line…>) from the US Census Bureau.
Here is Kyle Walker’s March 2021 lecture on “Spatial Analysis of US Census Data” on youtube.com <http://youtube.com/>. Watch it!
https://youtu.be/GqC1HjAKui4 <https://youtu.be/GqC1HjAKui4>
TIGRIS is working and ready for Census 2020 geographies!! So when the PL94-171 data is available this coming Thursday, I’m expecting a lot of people to get really busy with it!
(Refer back to my 7/23/21 post regarding the R package PL94171. My next example might be some stitching the TIGER files with the PL 94-171 demographic data!)
I’m attaching two of my R scripts that test a ton of the capability of TIGRIS. I’m not “attaching” any demographic data to the geographic layers, just yet. The purpose here is to get a hold of these TIGER/Line shapefiles, and get ready for newer (or older) census data from the decennial census or the American Community Survey.
My Part I script includes the following examples:
# 1.1 -- County Boundaries in California (Detailed TIGER/Highest Resolution)
# 1.2 -- Exporting SHP files to a local computer drive
# 2 -- County Boundaries in California (Medium Resolution)
# 3 -- County Boundaries in California (Lowest Resolution)
# 4.1 -- Tract Boundaries for One County
# 4.2 -- Tract Boundaries for One County, Multiple Census Years (1990-2020)
# 5 -- Tract Boundaries for Multiple Counties in a State
# 6 -- Block Group Boundaries for Multiple Counties in a State
# 7 -- Block Boundaries for Multiple Counties in a State
# 8 -- Place Boundaries within a State
# 9 -- PUMA Boundaries within a State
# 10 -- Consolidated Statistical Areas in the USA
# 11 -- Core-Based Statistical Areas in the USA
# 12 -- Congressional Districts in the USA, single state, and filtering states
# 13 -- Urbanized Areas in the USA
# 14 -- State Legislative Districts (Upper/Lower House) for a State
# 15 -- Zip Code Tabulation Areas, Selected for a State and within state
# 16 -- State Boundaries in the USA
My Part II script includes the following examples:
# 1 -- Roads for Counties, Multiple Counties within State
# 2 -- Primary & Secondary Roads within a State
# 3 -- Rails for the USA
# 4.1 -- Water Areas for Multiple Counties within a State
# 4.2 -- Water Lines for Multiple Counties within a State
# 5 -- Point & Area Landmarks within a State
That’s all for now. Happy Saturday afternoon, and IPA Day!
Chuck Purvis,
Hayward, Califorina
Attachments:
One of the great things about the Beyond 2020 web software for the CTPP 2012/16 is the ability to export GIS-ready “shapefiles” for use in your GIS applications. This works very well for limited numbers of geographic areas, say anywhere from one to a couple of thousand pieces of geography. I’m not sure what the upper limit on geographic areas it can export? Perhaps 5,000?
But the downside of the shapefiles exported from Beyond 2020 is that the output variables are given names like F0 to F35. Maybe there’s a magic button in Beyond 2020 that provides “mnemonic” variable names in the exported shapefiles? I can’t seem to find it.
Mnemonic variable names are basically memory clues as to what the variable is about: “transit” is probably transit commuters. “Total” is probably the total number of commuters, persons, households, etc., depending on the data universe. “VHH1_WHH0_est” is (obvious to me) “estimate of households with one vehicle and zero workers."
I wrote a R script that imports the shapefile’s DBF file (exported from Beyond2020); renames the variables to something more useful; adds a few extra variables; and exports a new DBF file. I’m also writing out csv and Excel workbooks, since I might use them for other analytical tasks.
Attached is my R script. It’s basic purpose is to read a DBF file, rename the varibles, add a few new variables, and write out DBF, csv, and XLSX file.
It’s using California county (n=58) for the workplace table A202105: Means of Transportation to Work (18 categories.) The process works, and I’m able to import these GIS files into QGIS with the renamed variables.
Well, only a few more hundred tables to go!!
Any advice or hints on how to improve on this process would be welcome!
cheers,
Chuck Purvis
Hayward, Califora