TO: State Data Center listserv; Census Transportation listserv
FR: Chuck Purvis, SF Bay Area Regional Data Center
We've uploaded our SAS code to help in analysis of the new demographic profile #2, 3, and 4 data. Our very simple SAS code, and the edited California CSV files, are at:
ftp://ftp.abag.ca.gov/pub/mtc/census2000/DP2-4/SAS-codes-data/
Essentially, we edited the California CSV files to include two additional records: a variable name record, and a dummy record that gives correct dimensions to the numeric and string variables. The variable names that we use ARE THE SAME AS the Census Bureau's DP234 documentation, that is dp2001-dp2102, dp3001-dp3107, and dp4001-dp4100. (That's 309 different variables, not including the geographic identifiers!)
In these SAS jobs, these variable names are then reset to more mnemonic variable names, and then are exported into CSV files using PROC EXPORT. In addition, we subset the California places to extract Bay Area only places.
We are using SAS Version 8 on PCs.
In addition, we've created a new page examining the transportation-related data from DP234. (That's because our interests are as the MPO - transportation planning agency for our region.) Interesting trends and results!
http://www.mtc.ca.gov/datamart/census/dp234/Census-Transportation-Related.h…
Hope this helps!
Chuck Purvis, MTC Oakland
***********************************************
Charles L. Purvis, AICP
Senior Transportation Planner/Analyst
Metropolitan Transportation Commission
101 Eighth Street
Oakland, CA 94607-4700
(510) 464-7731 (office)
(510) 464-7848 (fax)
www: http://www.mtc.ca.gov/
Census WWW: http://census.mtc.ca.gov/
***********************************************
This email is not directly related to CTPP, but IS related to urbanized area definition and new urbanized areas!
Since many of you may be working with areas which are new Urbanized Areas which are NOT in areas with existing MPOs, you may want to let your colleagues know about this 3-day course offered by the National Transit Institute. There is no charge to public sector employees. The fee for others is $450.
http://www.ntionline.com/CourseInfo.asp?CourseNumber=PLN11
Elaine Murakami
FHWA Office of Metropolitan Planning
TO: CTPP-News
The Census Bureau has released the "Demographic Profile #2, 3 and 4" data products for 13 states as of 5/14/02. Data for 16 more states are due out this week, and the full set and U.S. totals will be available by the first week in June.
This is the FIRST RELEASE of regular, census "long form" data with a limited amount of journey-to-work data. Data is available ONLY for states, counties, places, congressional districts, and American Indian reservations. (In this release you won't get the number of bicycle commuters, but you will get the number of homes with incomplete plumbing or heated by solar energy!)
Follow the Census Bureau's Press Release Link for more information, at:
http://www.census.gov/Press-Release/www/2002/demoprofiles.html
MPO folks may be interested in how we've analyzed the new data for the SF Bay Area. This has been helpful to the media in terms of reporting historical changes in means of transportation to work, average commute duration, household vehicle ownership, etc. Our page is at:
http://www.mtc.ca.gov/datamart/census/dp234/Census-Transportation-Related.h…
Or, go to MTC's census datamart page at: http://www.mtc.ca.gov/datamart/census.htm and follow the links.
Here is an example of a good article from one of our suburban dailies. Typically they will balance the factual with vast & overwhelming anecdotal evidence.
http://www.bayarea.com/mld/cctimes/news/transportation/3294799.htm
My recommendation to MPO/States with upcoming DP 2-3-4 data:
1. Assemble historical data of interest to your organization. Be ready to "drop in" the new 2000 data when it arrives. Provide these pre-assembled data sets (XLS workbooks appears to be the spreadsheet of choice) to your media contacts BEFORE the data is released (before the "embargo" is lifted.) (Typically work with the city desk of your newspaper. The TV stations will typically follow the lead of the city newspapers.)
2. Know how you're going to analyze the data once it arrives. You can print out the PDF reports for all of your counties and places (see link below), but you can also download the CSV files from the Census Burea's FTP site, then analyze the data in SAS, EXCEL, ArcView or whatever software you can deal with. I would recommend analyzing an existing data set, say, Nevada's, in setting up your procedures to extract your data. Be ready to map out the place-level (or county-level if you're a state DOT) data using your GIS system.
By the way, here is the link to the Census Bureau's PDF version of the profiles pages. Be sure to bookmark it - - it's the best place to get the PDFs for your counties and places!!!
http://censtats.census.gov/pub/Profiles.shtml
3. Be on hand to discuss the results / trends, with your management, your policy board, and the media. Definitely the ACS (actually, C2SS) data released this past November allows you to anticipate some of the new data and trends coming out this month.
4. Sometimes management/policy board/media have troubles with numbers. An example is San Francisco County, where the transit share is decreasing (from 33.5 to 31.1 percent of the commute) but the number of transit commuters is increasing (from 128,160 transit commuters in 1990 to 130,311 transit commuters in 2000.) I haven't seen these yet, but the uncareful journalist could write: "Transit Commuting in San Francisco is down 2.4 percent between 1990 and 2000" whereas the more accurate depiction is a drop in the SHARE of commuters taking transit, along with an INCREASE IN THE NUMBER OF TRANSIT COMMUTERS. (This means that the non-transit commuting is increasing faster than the transit commuting.) The media may also confuse transit commuting (home-to-work and work-to-home trips) with transit use (all trip purposes, including journey-to-school, journey-to-shop, etc.)
5. Get your public information staff involved in issuing a press release. It will be very helpful to the media/public to assemble and analyze the data as soon as possible.
One of the interesting trends that I'm picking up is a general stability in journey-to-work modes shares, 1990 to 2000 - - at the REGIONAL level. We're showing a slight increase in our work-at-home share (3.4 to 4.0 %, 1990 to 2000) and a slight increase in transit commute share (9.5 to 9.7 %). We are showing slight decreases in drive alone (-0.2% from 68.2 to 68.0), carpooling (-0.1, from 13.0 to 12.9) and walking-to-work (-0.4% from 3.6% to 3.2%).
The majority of the INCREASE in our transit commuting is coming from suburban transit communities (that is, *not* from San Francisco/ Oakland/ Berkeley). This suburban transit commuting phenomena is interesting, and it will useful once the full national datasets are out in early June to try to see if this suburban transit growth is a national pattern or an isolated metro area pattern. (Very difficult, though, at a national level to distinguish urban from suburban.)
Hope this helps, and if others have interesting results and trends to share, please post to this listserv!
Chuck Purvis
***********************************************
Charles L. Purvis, AICP
Senior Transportation Planner/Analyst
Metropolitan Transportation Commission
101 Eighth Street
Oakland, CA 94607-4700
(510) 464-7731 (office)
(510) 464-7848 (fax)
www: http://www.mtc.ca.gov/
Census WWW: http://census.mtc.ca.gov/
***********************************************
Does anyone know if there exists some ready-made maps of the urbanized area boundaries for 1990 and for 2000? Perhaps pdf files for specific metro areas. Thanks for your help!
Andrew Pickard
Senior Transportation Engineer
Hampton Roads Planning District Commission
723 Woodlake Drive
Chesapeake, VA 23320
Phone: (757) 420-8300 Fax: (757) 523-4881
E-mail: apickard(a)hrpdc.org
Web: www.hrpdc.org
Chris:
By the way, TransCAD users get one set of SF 1 and State Data CDs free, by
request, per license. There will a similar program for the SF 3 Data CDs,
when those data become available this summer.
Peter
----------------------------------------------------------------
Peter Van Demark
Director of GIS Products and Training Phone: 617-527-4700
Caliper Corporation Fax: 617-527-5113
1172 Beacon Street E-mail: peter(a)caliper.com
Newton MA 02461-9926 Web site: http://www.caliper.com
Chris:
>When will 2000 census data be released for census geography (Tracts, block
>groups, blocks) for the state of Kansas and where do I find it?
The SF 1 (short form) data are already available. You can get the raw data
at the Census Bureau web site.
Caliper Corporation has two sets of Data CDs for use with its GIS products,
each with data organized by state. One set has the SF 1 tables and a Table
Chooser for easy access, and the other has all of the geographic files from
state to block boundaries. For more information on the SF 1 Data CDs visit
(http://www.caliper.com/DataCDs/SF1DataCD.htm), and for more information on
the State Data CDs, visit (http://www.caliper.com/DataCDs/StateDataCD2000.htm).
We will be producing SF 3 (long form) Data CDs, also by state, when those
data come out this summer. All of these Data CDs cost $195 each, plus shipping.
Peter
----------------------------------------------------------------
Peter Van Demark
Director of GIS Products and Training Phone: 617-527-4700
Caliper Corporation Fax: 617-527-5113
1172 Beacon Street E-mail: peter(a)caliper.com
Newton MA 02461-9926 Web site: http://www.caliper.com
I used the following procedure to create the urbanized area GIS layer for the Bridgeport-Stamford-CT, NY urbanized area. Because I already had Census Blocks in my GIS system, I only wanted a table that would allow me to join the urbanized area information to the Census Blocks. Perhaps the following procedure and sample file will help others generate maps of the new urbanized areas. I am a busy person and apologize in advance for the hastily written directions.
* Download UA TIGER/Line files.
* Rename tgrxxxxxx.rta to tgrxxxxxxa.txt
* Rename tgrxxxxxx.rts to tgrxxxxxxs.txt <<ua2000_example.zip>>
* Rename tgrxxxxxx.rtc to tgrxxxxxxc.txt
*
* The xxxxxx is the state and county fips code.
*
* Open the Access file.
* Choose File -> Get External Data -> Import...
* Select the tgrxxxxxxa.txt text file and click the "Import" button.
* Click the "Advanced" Button.
* Click the "Specs..." Button.
* Choose the "Tgr09001a Import Specification"
* Click "OK".
* If you do not mind Access automatically inserting a primary key, simply click "Finish". Otherwise, work through the wizard and choose the appropriate options.
*
* Repeat the above process for the record type s and record type c files. Use the "Tgr09001c Import Specification" for tgrxxxxxxc.txt and "Record Type S Import Specification3" for the tgrxxxxxxs.txt.
*
* At this point, all the necessary information is now in Access.
* Copy the "UrbanRuralBlocks09005" query to a different name.
* Edit the query in SQL view and rename the table names to match the table names of the tables for one county.
Afterwards, display the query in datasheet view. At this point, I would compare the number of records in the table to the number of blocks in the cooresponding GIS layer. I would also check to make sure that the urbanized area names make sense. If there are any irregularities, you will need to correct mistakes in the query.
If the results are correct, then you can join the results to the Census Blocks in GIS software. The table can be exported to a dBase IV file or text file. In some cases, you can connect the Access database to the GIS software directly or through ODBC. Once the join is performed, you can perform spatial aggregation to get the anticlimactic urbanized area GIS layer.
Good luck,
Daryl Scott
--
Daryl Scott
South Western Regional Planning Agency
Stamford Government Center
888 Washington Blvd., 3rd Floor
Stamford, CT 06901
Tel: (203) 316-5190
Fax: (203) 316-4995
E-mail: dscott(a)swrpa.org
We have similar issues in SC. You have some flexibility.
Key question is whether your population projections for your plan horizon
year produce the necessary densities for the [Saraland?] urban cluster to
become part of the [I assume it's Mobile] Urbanized Area, or will it remain
non-contiguous with Mobile? You may have to expand your population
projections to include all of Mobile County (or at least the UC in question)
to make a reasonable determination of that.
Your study area boundary has to include "the UZA(s) and the contiguous
geographic areas likely to become urbanized within the 20-year forecast
period covered by the transportation plan . . ." {23 CFR 450.306(a)}. So
if the urban cluster is "likely" to be part of the CONTIGUOUS Mobile
Urbanized Area (based on future population density) in 20 years, you should
include it in the MPO study area. If it doesn't become contiguous, you
don't have to include it, but you do have the flexibility to include as much
of the MSA as you want. You should also consider whether the UC will be
included in your nonattainment area, if that's an issue in Mobile.
Hope that helps. That's how we hope to evaluate new boundaries, by looking
at the projected population densities in areas being considered for
inclusion to be sure that the densities actually are urban and the area is
contiguous.
John Gardner, AICP
SCDOT Office of Planning
gardnerjf(a)dot.state.sc.us
-----Original Message-----
From: kharrison [mailto:kharrison@sarpc.org]
Sent: Friday, May 17, 2002 1:41 PM
To: ctpp-news(a)chrispy.net
Subject: [CTPP] question to list regarding study area boundary.
I have a question regarding MPO study area boundary. Our existing MPO
covers 1 urban area. 3 miles from the new urban area boundary there is a
newly designated urban cluster. Our existing study area boundary bisects
the new urban cluster. We are looking at our options for expanding the MPO
study area boundary. Would we have to include the entire adjacent urban
cluster or can our study area be adjacent to or bisect the urban cluster?
Since by definition the MPO study area is supposed to include all the area
that will be urbanized within 25 years, can it exclude or bisect an adjacent
urban cluster?
Kevin Harrison
Transportation Planner
South Alabama Regional Planning Commission
651 Church St
Mobile, AL 36602
251.433.6541
I've heard a couple of references to 'smoothing' the urban area
boundaries. What is the policy and procedure on this issue??
Fernando de Aragon
ITCTC, Director
==================
==================
Fernando de Aragon, AICP
Director
Ithaca-Tompkins County Transportation Council
121 E. Court St.
Ithaca, NY 14850
phone: 607-274-5570
fax: 607-274-5578
ITCTC(a)tompkins-co.org
www.tompkins-co.org/itctc
