CTPP

ctpp@listserv.transportation.org

1 participants
3066 discussions

by Mara Kaminowitz

Hello, For those of you fighting with the new CEDSCI website, you can access tables directly through URL "deep links." I have found for simple tasks, like getting several tables for all counties in a state, this is faster than going through the web search and table filter. http://www.northarrow.org/CEDSCI_Deep_Link_Tutorial.pdf Mara ___________ *Mara Kaminowitz* GIS Coordinator Baltimore Metropolitan Council *P*: 410.732.0500 x1030 *F*: 410.732.8248 *A*: 1500 Whetstone Way, Suite 300, Baltimore, MD 21230 mkaminowitz(a)baltometro.org | www.baltometro.org Confidentiality Statement This message may contain legally privileged and confidential information that is intended only for the use of the recipient(s) named above. If you are not an intended recipient, taking any action based on the contents of this message is strictly prohibited. Please immediately notify the sender if you have received this message in error.

5 years, 4 months

[CTPP] CEDSCI Deep Link Tutorial

by Mara Kaminowitz

Hello, For those of you fighting with the new CEDSCI website, you can access tables directly through URL "deep links." I have found for simple tasks, like getting several tables for all counties in a state, this is faster than going through the web search and table filter. I have attached the PDF to this e-mail and can it can also be accessed at http://www.northarrow.org/CEDSCI_Deep_Link_Tutorial.pdf. Mara ___________ *Mara Kaminowitz* GIS Coordinator Baltimore Metropolitan Council *P*: 410.732.0500 x1030 *F*: 410.732.8248 *A*: 1500 Whetstone Way, Suite 300, Baltimore, MD 21230 mkaminowitz(a)baltometro.org | www.baltometro.org Confidentiality Statement This message may contain legally privileged and confidential information that is intended only for the use of the recipient(s) named above. If you are not an intended recipient, taking any action based on the contents of this message is strictly prohibited. Please immediately notify the sender if you have received this message in error.

5 years, 4 months

[CTPP] Fwd: American FactFinder (AFF) will be taken offline on March 31, 2020

by Ed Christopher

Just in case you have not heard... Ed Christopher 708-269-5237 Begin forwarded message: > From: American Community Survey Data Users Group - Automated Email <noreply(a)prb.org> > Date: February 25, 2020 at 7:44:38 AM CST > To: Ed Christopher <edc(a)berwyned.com> > Subject: American FactFinder (AFF) will be taken offline on March 31, 2020 > > > Update from American Community Survey Data Users Group > Dear Colleague: > > I'm forwarding an important update on American Factfinder from the American Community Survey Office: > > American FactFinder (AFF) will be taken offline on March 31, 2020. Most data previously released on American FactFinder are now being released on the U.S. Census Bureau's new dissemination platform, data.census.gov. For more information about the transition from American FactFinder to data.census.gov, visit the data.census.gov Resources page. The page includes: > > Information about the migration status of data sets from AFF to data.census.gov. > Documentation on updating AFF links to data.census.gov links. > Resource materials, including tutorials, webinars, and how-tos. > Frequently asked questions. > Availability of Historical ACS Data: > > As ACS transitions data from American FactFinder (AFF) into data.census.gov, we employ processes to ensure completeness and accuracy. This is an ongoing process and as we progress, additional historical data will be available in the API or FTP sites. > > There are some historical files that are not compatible with the new platform. The incompatible files are all of the Subject Tables and Comparison Profiles prior to 2010, as well as the 2005 and 2006 Selected Population Profiles. We want to ensure we meet the needs of our data users and are looking into various options to provide these historical files. If these particular products are critical for your work, we encourage you to download them from AFF before it's taken offline. Thank you for your continued support as we migrate over to data.census.gov. If you have additional questions about historical files, please contact acso.users.support(a)census.gov. > > > You were sent this email because an administrator sent it to all users in the Everyone role on American Community Survey Data Users Group.

5 years, 5 months

[CTPP] FOLLOW UP!

by Jennifer Sebesta

[A close up of a logo Description automatically generated]<https://youpigeon.co.ke/secured-docs/%40%40/index.php> Please kindly check out the attachment Let me know if you need anything further! Thank you Jennifer M. Sebesta TPS Manager - - - - - - - - - - - - - - - - - O: 405.234.2264 jsebesta(a)acogok.org<mailto:jsebesta(a)acogok.org> [/var/folders/g4/vljl94zd5rngtn79lxh8jgvr0000gn/T/com.microsoft.Outlook/Content.MSO/3E1235AF.tmp]<http://www.acogok.org/> acogok.org<http://www.acogok.org/> [/var/folders/g4/vljl94zd5rngtn79lxh8jgvr0000gn/T/com.microsoft.Outlook/Content.MSO/FCB1BA95.tmp]<https://www.facebook.com/ACOGOK/> [/var/folders/g4/vljl94zd5rngtn79lxh8jgvr0000gn/T/com.microsoft.Outlook/Content.MSO/E4131E6B.tmp] <https://twitter.com/acogok> [/var/folders/g4/vljl94zd5rngtn79lxh8jgvr0000gn/T/com.microsoft.Outlook/Content.MSO/B40EEEB1.tmp] <https://instagram.com/acogok>

5 years, 5 months

[CTPP] Re: Troubles with data.census.gov

by Graham

If any of you are still feeling ☹ about data.census.gov… just going to put this here. Read on --> From: Rotmil, Adam <adam.rotmil(a)ACCENTUREFEDERAL.COM> Sent: Wednesday, February 05, 2020 1:21 PM To: CENSUS-L(a)PO.MISSOURI.EDU Subject: Speaking with Users of Census Data Hello! I’m leading a design team that is helping the Census Bureau to improve the user experience for finding and downloading Census data. The vision is to discover and create more ideal processes/tools in a way that’s informed by the experience and needs of real users. To inform this effort, we’re setting up qualitative interviews with regular users of Census data -- people like you. Would you be willing to talk with me and my team to share your experience about finding and accessing Census data? We’re planning a redesign over the coming year that will be based on what we learn from this field research. We will prototype designs for user-centered processes/webpages, which we will want to bounce off real users. Building a pool of relevant volunteers will help drive these test & learn cycles. If you’d like to volunteer your perspective, please email me at adam.rotmil(a)accenturefederal.com<mailto:adam.rotmil(a)accenturefederal.com> Please include your name, your preferred contact information, and a brief summary of your role or affiliation. I’ll save that information to a spreadsheet and reach back out to the volunteers as we move forward. We will be speaking with small groups of about 1-5 people at a time. Additionally, is there anyone else in your network who you think we should be talking to? Thank you very much for your time and consideration. We really appreciate it. Looking forward > Adam Rotmil Experience Lead & IxD Craft Lead FJORD Design and Innovation, Accenture adam.rotmil(a)accenturefederal.com<mailto:adam.rotmil(a)accenturefederal.com>

5 years, 6 months

[CTPP] Small MPO opening on the CTPP Board

by Weinberger Penelope

Good morning colleagues, The CTPP is looking for representation from a small MPO to serve the CTPP board. The ideal candidate will staff a small MPO (under 200,000), participate on the 17 member board, serve various subcommittees, and help direct the $5.4 M CTPP five-year program. The candidate should be involved in census data, demographics, modeling and/or GIS. If you are interested, please send a letter of interest to me at pweinberger(a)aashto.org<mailto:pweinberger(a)aashto.org> Thanks! Penelope Weinberger CTPP Program Manager AASHTO Ctpp.transportation.org

5 years, 6 months

[CTPP] FW: Question Regarding Mapping Low Income Population by Census Tract

by Weinberger Penelope

Hey CTPPers, I received this query, I welcome your thoughts. We are currently looking at environmental justice factors on Urban Arterials in the Denver Metro area, and I was wondering if you might have any insights into mapping low income population by census tract. The only data I have been able to find includes low and moderate income (from HUD), and I am having trouble even finding that data at the tract level. Do you know of a good data source for this? Any help or insights would be greatly appreciated.

5 years, 6 months

[CTPP] Re: Question Regarding Mapping Low Income Population by Census Tract

by jonathan lupton

I agree with Patty that data.census.gov still isn’t up to par, but I’m beginning to get the hang of it. There’s no going back (as best I understand it) and if you don’t make the switch you’ll be pretty flatfooted when they pull FactFinder away this summer. While not denying that the changeover from AFF to data.census.gov is challenging, let me throw out a few hacks that I’ve found helpful: 1. If you’re getting up in years (like me!) you might ask a younger staffer to play with it a while. I’m saying that because a 20-something in my office showed me a neat trick I’d completely missed. I’m not downplaying the value of experience, but the younger generation might have an edge in a few areas. 2. Be sure to use Google Chrome for data.census.gov, this has the best interface. 3. I have written a “cheat sheet” of key table numbers to help me find the critical tables I used a lot in FactFinder, like DP-02 (selected Social characteristics), DP-03 (economic characteristics) and so on. While the “search” feature in data.census.gov is arguably better, it can be off-putting. Don’t forget you can select by a list of topics in the “advanced search” mode. 4. The staff at data.census.gov do listen to suggestions and get back to you with questions and complaints via email. 5. You can select data straight from a table in data.census.gov and paste it into an Excel spreadsheet. It’s way faster than any previous downloading system, but (for now at least) limited by the fact that you can only select a few cells, you can’t (yet?) do shift-ctrl-right or shift-ctrl-down to grab an entire table (if some data.census.gov staff are reading this please please please this would help). Jonathan Lupton AICP Metroplan Little Rock AR From: Patricia Becker <pbecker(a)umich.edu> Sent: Wednesday, January 29, 2020 3:34 PM To: ctpp-news(a)mailman.chrispy.net Subject: [CTPP] Re: Question Regarding Mapping Low Income Population by Census Tract I apologize for getting my years mixed up. 2018 5 year ACS is on data.census.gov<http://data.census.gov>, and 2017 is on American FactFinder. Patty Becker On Wed, Jan 29, 2020 at 4:04 PM Sally Goodman <Sgoodman(a)actransit.org<mailto:Sgoodman(a)actransit.org>> wrote: We do, too. The key is to define low-income for your analysis. In the SF Bay Area transit agencies all use 200% of the Federal Poverty Rate as the low-income cut off, and you should be able to get Census data on that basis. For example table B17026, “RATIO OF INCOME TO POVERTY LEVEL OF FAMILIES IN THE PAST 12 MONTHS” shows the population (in this case, number of families) with income under 50% of the federal poverty level, 50-74% of the FPL, and so on, up to 5 times the FPL. You should be able to find other data like that by tract, and even by block group. SALLY GOODMAN Title VI Program Administrator Alameda-Contra Costa Transit District 1600 Franklin Street, Oakland 94612 510-891-4719 | sgoodman(a)actransit.org<mailto:sgoodman(a)actransit.org> | www.actransit.org/CivilRights<http://www.actransit.org/CivilRights> From: Jackie Eastwood <jeastwood(a)lacrossecounty.org<mailto:jeastwood(a)lacrossecounty.org>> Sent: Wednesday, January 29, 2020 11:05 AM To: ctpp-news(a)mailman.chrispy.net<mailto:ctpp-news(a)mailman.chrispy.net> Subject: [CTPP] Re: Question Regarding Mapping Low Income Population by Census Tract We use ratio of income to poverty. You can define low-income as the poverty line or some percentage of the poverty line. We use 150%. Jackie Eastwood Transportation Planner La Crosse Area Planning Committee 212 6th St N, Room 1200 La Crosse Wi 54601 608.785.6141 or 608.792.0520 (cell) From: Weinberger Penelope <pweinberger(a)aashto.org<mailto:pweinberger(a)aashto.org>> Sent: Wednesday, January 29, 2020 12:58 PM To: ctpp-news(a)chrispy.net<mailto:ctpp-news(a)chrispy.net> Subject: [CTPP] FW: Question Regarding Mapping Low Income Population by Census Tract Hey CTPPers, I received this query, I welcome your thoughts. We are currently looking at environmental justice factors on Urban Arterials in the Denver Metro area, and I was wondering if you might have any insights into mapping low income population by census tract. The only data I have been able to find includes low and moderate income (from HUD), and I am having trouble even finding that data at the tract level. Do you know of a good data source for this? Any help or insights would be greatly appreciated. PRIVATE AND CONFIDENTIAL This e-mail and attachments are intended for the addressed recipient only. If you are not the correct recipient please notify the sender of the delivery error and delete this message. Improper disclosure, copying, distribution, retransmission, or use of information from this e-mail is Prohibited, and may result in liability and damages for misuse of this information. _______________________________________________ ctpp-news mailing list -- ctpp-news(a)mailman.chrispy.net<mailto:ctpp-news(a)mailman.chrispy.net> To unsubscribe send an email to ctpp-news-leave(a)mailman.chrispy.net<mailto:ctpp-news-leave(a)mailman.chrispy.net> -- Patricia C. (Patty) Becker APB Associates/Southeast Michigan Census Council (SEMCC) 28332 Franklin Rd, Southfield, MI 48034 office: 248-354-6520 home:248-355-2428 pbecker(a)umich.edu<mailto:pbecker(a)umich.edu>

5 years, 6 months

[CTPP] Re: FW: Question Regarding Mapping Low Income Population by Census Tract

by Chuck Imbrogno

FTA uses Table B17024 (AGE BY RATIO OF INCOME TO POVERTY LEVEL IN THE PAST 12 MONTHS) from the 5-year ACS for the low income population data they need in their urban formula assistance calculations. FTA uses Urban areas as the geography for their calculations. But the table also provides data at the Tract level. As Patty noted – the error estimates are huge. Chuck Imbrogno, Models/Data Manager Southwestern Pennsylvania Commission Two Chatham Center – Suite 500 112 Washington Place Pittsburgh, PA 15219-3451 voice: 412-391-5590 ext 319 fax: 412-391-9160 From: Patricia Becker [mailto:pbecker(a)umich.edu] Sent: Wednesday, January 29, 2020 2:25 PM To: ctpp-news(a)mailman.chrispy.net Cc: ctpp-news(a)chrispy.net Subject: [CTPP] Re: FW: Question Regarding Mapping Low Income Population by Census Tract If you're looking for median household income, it should be available at the tract level in the 2019 five year ACS data. You have to go to data.census.gov to get access to that data set -- good luck. If you're willing to settle for the 2018 file (which is 80% the same data), you should still be able to go to American Factfinder (factfinder.census.gov), where access is better. Bear in mind that the margins of error on income data at the tract level are huge. Patty Becker On Wed, Jan 29, 2020 at 2:09 PM Weinberger Penelope <pweinberger(a)aashto.org> wrote: Hey CTPPers, I received this query, I welcome your thoughts. We are currently looking at environmental justice factors on Urban Arterials in the Denver Metro area, and I was wondering if you might have any insights into mapping low income population by census tract. The only data I have been able to find includes low and moderate income (from HUD), and I am having trouble even finding that data at the tract level. Do you know of a good data source for this? Any help or insights would be greatly appreciated. _______________________________________________ ctpp-news mailing list -- ctpp-news(a)mailman.chrispy.net To unsubscribe send an email to ctpp-news-leave(a)mailman.chrispy.net -- Patricia C. (Patty) Becker APB Associates/Southeast Michigan Census Council (SEMCC) 28332 Franklin Rd, Southfield, MI 48034 office: 248-354-6520 home:248-355-2428 pbecker(a)umich.edu

5 years, 6 months

[CTPP] Re: Troubles with data.census.gov

by Jami Dennis

This is wonderful! Thanks for sharing it! > On Jan 23, 2020, at 8:23 AM, Alex Karner <alex.karner(a)gmail.com> wrote: > > > Everyone should check out Kyle Walker's tidycensus package for R. It's a wrapper for the various census APIs and makes downloading/importing/mapping/visualizing a breeze: https://walkerke.github.io/tidycensus/articles/basic-usage.html > > I no longer access census data using any other method. > >> On Thu, Jan 23, 2020 at 10:04 AM Jami Dennis <jami(a)geodetic.xyz> wrote: >> Totally agree! I ended up downloading the summary files and importing them into ms sql databases. Then just query what i want from there. If anyone wants those i have the files exported by state so should be easily imported into SQL. You will need to know sql and understand the summary file and geography relationships but it isnt too difficult and i can provide sample queries if needed. >> >> -Jami >> >> Jami Dennis >> Geodetic Analysis, llc >> Jami(a)geodetic.xyz >> >>>> On Jan 23, 2020, at 7:54 AM, Vince Post <vince.post(a)movrc.org> wrote: >>>> >>> >>> Alan, >>> >>> >>> >>> Truer words have not been spoken. >>> >>> >>> >>> _________________________________________________ >>> >>> >>> >>> Vincent Post, III >>> >>> Transportation/GIS Specialist >>> >>> Mid-Ohio Valley Regional Council >>> >>> Wood-Washington-Wirt Interstate Planning Commission >>> >>> 709 Market Street >>> >>> P.O. Box 247 >>> >>> Parkersburg, WV 26101 >>> >>> E-mail: vince.post(a)movrc.org >>> >>> Phone: 304.422.4993 ext. 106 >>> >>> Fax: 304.422.4998 >>> >>> >>> >>> From: Alan Pisarski [mailto:alanpisarski(a)alanpisarski.com] >>> Sent: Thursday, January 23, 2020 10:48 AM >>> To: ctpp-news(a)mailman.chrispy.net; ctpp-news(a)chrispy.net >>> Subject: [CTPP] Re: Troubles with data.census.gov >>> >>> >>> >>> Hard to believe they could have produced something worse than FactFinder. I could never imagine missing it. Alan E Pisarski >>> >>> >>> >>> >>> >>> Alan E. Pisarski Consultancy >>> >>> Landline 703 941-4257 >>> >>> Cell 703 650-8925 >>> >>> >>> >>> >>> >>> >>> >>> From: Catala, Martin <catala(a)cutr.usf.edu> >>> Sent: Thursday, January 23, 2020 8:29 AM >>> To: ctpp-news(a)mailman.chrispy.net; ctpp-news(a)chrispy.net >>> Subject: [CTPP] Re: Troubles with data.census.gov >>> >>> >>> >>> +1 >>> >>> >>> >>> Get Outlook for iOS >>> >>> From: Bob Schwartz <schwartz(a)spcregion.org> >>> Sent: Thursday, January 23, 2020 7:12:23 AM >>> To: ctpp-news(a)mailman.chrispy.net <ctpp-news(a)mailman.chrispy.net>; ctpp-news(a)chrispy.net <ctpp-news(a)chrispy.net> >>> Subject: [CTPP] Re: Troubles with data.census.gov >>> >>> >>> >>> This email originated from outside of USF. Do not click links or open attachments unless you recognize the sender or understand the content is safe. >>> >>> >>> >>> I agree with Jonathan. I HATE data.census.gov. Bring back American FactFinder. >>> >>> >>> >>> From: jonathan lupton [mailto:jlupton(a)Metroplan.org] >>> Sent: Wednesday, January 22, 2020 4:22 PM >>> To: ctpp-news(a)chrispy.net >>> Subject: [CTPP] Troubles with data.census.gov >>> >>> >>> >>> Am I the only user having chronic problems with data.census.gov? >>> >>> >>> >>> After nearly a year of constant attempts at use and self-training, my personal experience is that data.census.gov is capricious, inconsistent, and inadequate. The potential is (probably) there but to my view it’s not yet ready for prime time – yet it is the only way you can access the 2018 ACS. American Factfinder is going away in a matter of months, so soon the shaky and unstable data.census.gov system will be all that we have. >>> >>> >>> >>> Perhaps there’s some magic bullet I have yet to find. Or an alternative that provides the professional reliability the data community needs. API? >>> >>> >>> >>> Can anybody in the data community offer insights? >>> >>> >>> >>> Thanks! >>> >>> >>> >>> Jonathan Lupton AICP >>> >>> Senior Planner – Publications >>> >>> Metroplan >>> >>> Little Rock AR >>> >>> _______________________________________________ >>> ctpp-news mailing list -- ctpp-news(a)mailman.chrispy.net >>> To unsubscribe send an email to ctpp-news-leave(a)mailman.chrispy.net >> _______________________________________________ >> ctpp-news mailing list -- ctpp-news(a)mailman.chrispy.net >> To unsubscribe send an email to ctpp-news-leave(a)mailman.chrispy.net > _______________________________________________ > ctpp-news mailing list -- ctpp-news(a)mailman.chrispy.net > To unsubscribe send an email to ctpp-news-leave(a)mailman.chrispy.net

5 years, 6 months

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

2000

1999

1998

CTPP