Good morning,
A colleague of mine at a local university has a SAS/GIS challenge and I am
hoping someone on this list might know the answer. She is creating a data
processing program entirely in SAS. The data had addresses as well as
Lat/Longs for the addresses. One of the criteria is that the data
processing program should determine which Census tract the addresses fall
into. She needs to do this in the program, joining the points to the
tracts in GIS beforehand is not an option. I immediately thought of the
Census API's geocoding function but I have no idea if SAS can access it, or
anything else about SAS for that matter.
If anyone has any solutions, please feel free to e-mail me and I'll pass
your message on. I can also put you in direct contact with my colleague if
you want to discuss the problem in depth.
Thanks,
Mara
*Mara Kaminowitz, GISP*GIS Coordinator
.........................................................................
*Baltimore Metropolitan Council*
Offices @ McHenry Row
1500 Whetstone Way
Suite 300
Baltimore, MD 21230
410-732-0500 ext. 1030
mkaminowitz(a)baltometro.org
www.baltometro.org
The Census now has variance replicate estimates for certain ACS tables.
This is intended to improve certain derived MOE's. I'm looking forward to
testing it out.
http://www2.census.gov/programs-surveys/acs/replicate_estimates/2014/
*Mara Kaminowitz, GISP*GIS Coordinator
.........................................................................
*Baltimore Metropolitan Council*
Offices @ McHenry Row
1500 Whetstone Way
Suite 300
Baltimore, MD 21230
410-732-0500 ext. 1030
mkaminowitz(a)baltometro.org
www.baltometro.org
Reminder - send us your ideas by August 1!
*From:* Mara Kaminowitz [mailto:mkaminowitz@baltometro.org]
*Sent:* Monday, June 13, 2016 2:20 PM
*To:* 'mkaminow(a)gmail.com'
*Subject:* ABJ30(1) seeking ideas for research statements
Dear colleagues and friends of the Census subcommittee,
An important function of TRB is to stimulate research that addresses
concerns, issues, or problems facing the transportation community. In
support of this function, TRB committees identify and develop research need
statements (RNS) for use by practitioners and researchers. A list of RNS
can be found here: https://rns.trb.org/.
The Census Data for Transportation Planning subcommittee (ABJ30(1)) wants
to develop 2-3 research needs statements with the goal of submitting one
for NCHRP funding. We want your ideas for possible research topics. Data
methods as well as applied uses are welcome. The idea needs to involve a
Census product and should be related to transportation and urban data. You
can also include things like potential benefits, relevance to the
transportation community, and the end product you envision. We will be
assembling a small team to consider the ideas and develop some of them into
full research needs statements.
Please send an email to mkaminowitz(a)baltometro.org and
clara.reschovsky(a)dot.gov with your ideas by August 1. We look forward to
hearing from you!
Clara Reschovsky & Mara Kaminowitz, co-chairs, ABJ30(1)
*Mara Kaminowitz, GISP*GIS Coordinator
.........................................................................
*Baltimore Metropolitan Council*
Offices @ McHenry Row
1500 Whetstone Way
Suite 300
Baltimore, MD 21230
410-732-0500 ext. 1030
mkaminowitz(a)baltometro.org
www.baltometro.org
CTPP Training opportunity at CMAP in Chicago!
Planning tool workshop. Census Transportation Planning Products (CTPP) Program Trainers will hold free training on a program developed for planners who work on long-range plans, congestion management, travel forecast, or air quality analysis. The workshop will be held all day Monday, July 18, and the morning Tuesday, July 19 at CMAP (233 S. Wacker Dr., Suite 800, Chicago). The workshop is free of charge, registration is on a first come, first served basis, and participants must provide their own laptops. Contact Jon Hallas (jhallas(a)cmap.illinois.gov<mailto:jhallas@cmap.illinois.gov?subject=CTPP%20Workshop>) with questions or to register.
?
An important function of TRB is to stimulate research that addresses
concerns, issues, or problems facing the transportation community. In
support of this function, TRB committees identify and develop research need
statements (RNS) for use by practitioners and researchers. A list of RNS
can be found here: https://rns.trb.org/.
The Census subcommittee (ABJ30(1)) wants to develop 2-3 research needs
statements with the goal of submitting one for NCHRP funding. We want your
ideas for possible research topics. Data methods as well as applied uses
are welcome. The idea needs to involve a Census product (including CTPP)
and should be related to transportation and urban data. You can also
include things like potential benefits, relevance to the transportation
community, and the end product you envision. We will be assembling a small
team to consider the ideas and develop some of them into full research
needs statements.
Please send an email directly to mkaminowitz(a)baltometro.org and
clara.reschovsky(a)dot.gov with your ideas by August 1. We look forward to
hearing from you!
Clara Reschovsky & Mara Kaminowitz, co-chairs, ABJ30(1)
*Mara Kaminowitz, GISP*GIS Coordinator
.........................................................................
*Baltimore Metropolitan Council*
Offices @ McHenry Row
1500 Whetstone Way
Suite 300
Baltimore, MD 21230
410-732-0500 ext. 1030
mkaminowitz(a)baltometro.org
www.baltometro.org
Dear CTPP folks
The week of June 27th I will be in New York City for several meetings. If you would like me to come and do a crash course of CTPP at your organization I would be open to that. Please message me off list at: pweinberger(a)aashto.org<mailto:pweinberger@aashto.org> and let me know. Please feel free to share this with off list users who may benefit from some training or hands on help.
Sincerely,
Penelope Z. Weinberger
CTPP Program Manager
AASHTO
202-624-3556
ctpp.transportation.org
I added a table below the map that contains some additional information. It
isn't very intuitive and it's hard to describe in the short column headings
in the table (I'm open to suggestions) but I'll leave a couple of notes
here and add some explanation to the production page later.
In the table, I have totals for each of the counties involved in the
selected commuter flows. This includes a "median" commuting distance for
commuters who live in the county and a median commuting distance for
commuters who work in the county.
In addition at the right side of the table, there are a couple of
percentages:
- the "% This County" shows the % of that county's residents are part of
the main selected county's workers (if "workplace" is the selected view) or
the % of that county's workers who are part of the main selected county's
residents (if "residence" is the selected view.)
- the % Selected County shows the % of the selected commuters who
live/work in this county (depending on the selected view), so these should
add to 100%.
The median distances are calculated using the same number that drives the
distance range criteria: the distance between the center of each census
tract. Thus, intra-tract commutes count as 0. By sorting the tracts by
distance, I found the tract-tract flow that contained the median commuter
(if 1,000 commuters, the 500th commuter) and used that flow distance as the
median.
Anyway, if nothing else the totals on the left side of the table will show
you what I have as the total workers/residents in my tables.
Thanks and let me know if any suggestions or questions,
Mark
I would be cautious, just did a quick check, it says ACS, but unsourced as to what ACS (I’m guessing 2009 – 2013 county to county flows – otherwise OD pairs are very tricky), also looking at just Montgomery county and DC, and expanding the tool to its maximum range (zero to 293 miles) it’s missing about half the total workers in each of those. Also, tracts are referenced, but that set is not reported at tract. I welcome your thoughts.
Penelope Z. Weinberger
CTPP Program Manager
AASHTO
202-624-3556
ctpp.transportation.org
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Nancy Reger
Sent: Wednesday, May 25, 2016 4:08 PM
To: ctpp-news(a)chrispy.net
Subject: [CTPP] CTPP animation map
Check out this CTPP animation map – we didn’t make it. It’s very cool, wish we had-
http://bigbytes.mobyus.com/commute.aspx
Nancy Reger, AICP
Director, Data & Mapping | Mid-Ohio Regional Planning Commission
T: 614.233.4154 | M: 614.228.2663 | nreger(a)morpc.org<mailto:nreger@morpc.org>
111 Liberty Street, Suite 100 | Columbus, OH 43215
[MORPC_RGB_Secondary.png]<http://www.morpc.org/> [facebook button new.png] <http://www.facebook.com/morpc> [twitter button new.png] <http://www.twitter.com/morpc>
Hey - hope this goes through. I'm Mark Evans and I developed the commuter
map. Ed Christopher told me about this listserv. I'm happy to answer any
questions that you may have.
I think Penelope mentioned it elsewhere, but the data is from the 2006-2010
ACS tract-tract commuter data
<https://www.fhwa.dot.gov/planning/census_issues/ctpp/data_products/2006-201…>
.
I calculated a CV using the estimate and the MOE. I've seen some warnings
about the high level of error in some of the ACS data with recommendations
to include only data with CV < 30-40%. Unfortunately, this removes almost
all the data, so the default setting I used is 80%. Even at this high
level, it excludes a portion of the estimated commuters at the tract level.
In addition, anyone who works and lives in the same tract would not be
included.
Thanks for taking a look!
