ctpp-news May 2002

ctpp-news@mailman.chrispy.net

57 participants
76 discussions

SAS code to analyze Demographic Profile 2-3-4 data

by Chuck Purvis

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/ ***********************************************

23 years, 9 months

Metropolitan Planning course offered by NTI.

by Elaine Murakami

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

23 years, 9 months

Demographic Profiles Data

by Chuck Purvis

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/ ***********************************************

23 years, 9 months

urbanized area maps

by Andrew PICKARD

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

23 years, 9 months

Re: [CTPP] Question regarding census geography

by Peter H. Van Demark

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

23 years, 9 months

Re: [CTPP] Question regarding census geography

by Peter H. Van Demark

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

23 years, 9 months

Question regarding census geography

by Chris Herrick

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?

23 years, 9 months

Procedure for Creating 2000 Urbanized Area GIS Layer

by Daryl Scott

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

23 years, 9 months

RE: [CTPP] question to list regarding study area boundary.

by Gardner, John F

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

23 years, 9 months

smoothing UAs

by fdearagon＠tompkins-co.org

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

23 years, 9 months

2026

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-news May 2002