Glenn,
I received a copy of your response to Daryl at SWRPA concerning your TIP
computer program. I would appreciate receiving the installation files as
well, if you don't mind. Thank you.
Holly Massie
Special Programs Officer
Assn. of Central Oklahoma Governments
21 E. Main Street, Suite 100
OKC, OK 73104
hmassie(a)acogok.org
(405)234-2264
-----Original Message-----
From: John Sharp [mailto:jmsharp@acogok.org]
Sent: Friday, August 23, 2002 4:06 PM
To: Holly Massie
Subject: FW: [CTPP] TIP/STIP management application
-----Original Message-----
From: owner-ctpp-news(a)chrispy.net [mailto:owner-ctpp-news@chrispy.net]On
Behalf Of CDTC
Sent: Friday, August 23, 2002 3:12 PM
To: Daryl Scott
Cc: ctpp-news(a)chrispy.net
Subject: Re: [CTPP] TIP/STIP management application
Daryl,
At CDTC we use a computer program we wrote in house. The program runs in a
Windows environment on an original Pentium or greater. It allows the user
to enter input for TIP projects, produces all relevant output required by
CDTC and has various utilities.
The output includes project listings and summary tables which go directly
into the CDTC TIP document. We only need to add page numbers, since this
varies with the version of the TIP document. At the click of a mouse, web
pages are produced for every project. These pages are uploaded directly to
the Internet and are accessible from the CDTC web site at CDTCMPO.org.
(Choose Publications, TIP, 2001-06 TIP, and Project Listings.) Utilities
include a feature to find text in a project or find projects by specific
criteria, such as fund source. Also, the data can be sent to a file
suitable for transmission to DOT for the STIP.
We've used this program for several years and find does everything we need
it to do.
I'll send you the installation files if you like.
Glenn Posca
Senior Transportation Planner
CDTC
Daryl Scott wrote:
> Do any transportation planners at MPOs use a TIP/STIP management
application that they would highly recommend to other MPOs? The South
Western Region Metropolitan Planning Organization has an outstanding
contract with a consultant to develop an application to manage the TIP/STIP
for the planning region. The application should be able to generate various
reports designed for public officials and the general public, keep track of
official decisions about projects, store important comments, and have some
document management capabilities. I need to provide detailed application
specifications to the consultants before they begin work. I hope to get some
good ideas from members of this list serve. If you use an excellent
TIP/STIP application, please send me some documentation about the program?
Thank you in advance for your assistance. Regards, Daryl
>
> --
>
> 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
TO: CTPP-News, August 27, 2002
Summary File #3 (Long Form, Sample data) has been released for an additional seven states: California, Iowa, Kansas, Massachusetts, Missouri, Montana and New Mexico.
New information for today: SF3 data planned for release on 9/10/02 include: Michigan, North Carolina, South Carolina, Tennessee.
The following "Press Release" link will be updated by the Bureau over the next month to provide expected release dates for the remaining states.
http://www.census.gov/Press-Release/www/2002/sumfile3.html
1. In terms of schedule, the Census Bureau is anticipating releasing all of SF3 by the end of this September.
2. In terms of what states will be released when, I don't know anything beyond what's posted on this press release page. You may want to talk to your state data center for more insiders information.
Enjoy!
Chuck Purvis, MTC
Marty Dowell posted the follow message in response to a TIP question.
unfortunately (or fortunately<grin>) the email bounced due the 6.8 meg
size of the attachment. anyone who is interested in the subject can see
the websites that are referenced. Also, keep in mind that this list is
for those who are interested in the use and application of census
related data for transportation planning purposes. (however, thanks for
the info)
====================
From: Dowell, Marty
Sent: Monday, August 26, 2002 10:24 AM
To: 'dscott(a)swrpa.org'; 'cdtc(a)crisny.org'
Cc: Davis, Roger
Subject: RE: [CTPP] TIP/STIP management application
There is a system called Transportation, Economic & Land Use System
(TELUS).
It is a very powerful MS Access Data-Base program developed by the
Institute
for Transportation, New Jersey Institute of Technology in conjunction
with
Center for Urban Policy Research, Rutgers University.
All 16 (now 17) MPOs in Ohio received it. It is FREE to MPOs and SDOTs.
http://www.telus-national.org/http://www.transportation.njit.edu/TELUS/overview.htmlhttp://www.transportation.njit.edu/NCTIP/final_report/telus2.htm
--
Ed Christopher
Metropolitan Activities
Midwest Resource Center
Federal Highway Administration
19900 Governors Drive
Olympia Fields, Illinois 60461
708-283-3534 (V)
708-283-3501 (F)
As of today morning b(08/26/02), Summary File 3 (SF 3) data for 19 states have been released (http://www.census.gov/Press-Release/www/2002/sumfile3.html). SF 3 offers us the first opportunity to look at commuting data at a detailed level of geography. Some of the SF 3 tables in which you may be interested are:
Key Tables Summarized at the Block Group Level
P30. Means of transportation to work [16]
P31. Travel time to work [14]
P33. Aggregate travel time to work (in minutes) by travel time to work (4) by means of transportation to work [2]
P34. Time leaving home to go to work [16]
P35. Private vehicle occupancy [10]
P52. Household income in 1999 [16]
P151a-i. Household income in 1999 [16] by race/Hispanic origin (9)
H44. Tenure [2] by vehicles available [6]
H46. Aggregate number of vehicles available by tenure [2]
Key Tables Summarized at the Census Tract Level
Pct65a-i. Means of transportation to work for workers 16 years and over [16] by race/Hispanic origin (9)
Hct33. Vehicles available (3) by race/Hispanic origin (9)
For more information on the table specifications for SF3, please visit:
http://www.census.gov/population/www/cen2000/SF3-pop.html, and
http://www.census.gov/population/www/cen2000/SF3-housing.html
Also, Darryl Scott, South Western Regional Planning Agency sent me a zipped file of a procedure to convert the SF 3 data into an oracle platform. Attached is a zipped file containing the codes. We will post this information to the FHWA website on Census issues shortly. Please bookmark at http://www.fhwa.dot.gov/planning/census/
Thank you!
Nanda Srinivasan
TO: CTPP-News, August 20, 2002
Summary File #3 (Long Form, Sample data) has been released for an additional seven states: Connecticut, Illinois, Kentucky, Nevada, North Dakota, Oklahoma and Oregon.
New information is that CALIFORNIA will be released 8/27/02. The data for OHIO will be postponed for one week.
SF3 data will be released for seven states on 8/27/02: California, Iowa, Kansas, Massachusetts, Missouri, Montana and New Mexico.
New information: SF3 data planned for release on 9/3/02 include: Arizona, Idaho, Maine, New Hampshire, Ohio, Puerto Rico and Wyoming.
The following "Press Release" link will be updated by the Bureau over the next month to provide expected release dates for the remaining states.
http://www.census.gov/Press-Release/www/2002/sumfile3.html
Please forgive any duplication - I am sending this as a bcc to a variety of
lists in the interest of time - if you get this more than once, please just
delete the other notices that originate from me. Please forward this to
others that you know of that may find this service of interest.
Peter J. Foote
PFoote(a)TransitChicago.com
Market Research/Resource Planning
Planning Division
Chicago Transit Authority
120 N. Racine Avenue
Chicago, IL 60607
(312) 733-7000 x 6840 (Voice)
(312) 432 - 7108 (Fax)
----- Original Message -----
From: "TRANSTATS" <TRANSTATS(a)inet.bts.gov>
Sent: Monday, August 19, 2002 4:46 PM
Subject: Bureau of Transportation Statistics--TranStats User Testing
We'd like your help in testing a new website--TranStats, the intermodal
transportation database.
TranStats is a new website (http://www.bts.gov/transtats) for transportation
researchers and analysts aimed at providing "one-stop shopping" for
transportation data. The premise is fairly simple: By reducing the time
needed to gather data, more time is made available for analysis. And easy
linkages across many data sets can provide new insights. Ultimately, this
should result in more timely and more informed decisions, and a better
transportation system.
Until now, the process of compiling data to analyze a transportation problem
commonly involved searching for data sources, contacting various data
providers to get the data--often many times, sorting through the data, and
integrating data from various sources for analysis. This is a very
labor-intensive process, often taking months. TranStats is an e-government
initiative aimed at streamlining this process.
TranStats offers analysts several unique features:
· A searchable index of over 100 transportation-related databases across
every mode of transportation, along with many social, economic and
demographic data sets commonly used in transportation analysis.
· Selective download--the ability to choose variables of interest and
download the data directly to your PC for analysis using any database,
spreadsheet, or statistical package.
· Online data documentation--summary information about each database, data
definitions, and code information for data variables.
· Interactive analytical tools--the ability to perform simple statistical
summaries, create time series or cross tabulations, generate graphics
online, and cut/paste results into reports.
· Interactive mapping to help visualize geographic data.
· A mapping center with the full National Transportation Atlas Database, as
well as applications for easily mapping several other key data sets.
Users can explore data by transportation mode, agency or by subject area,
use keyword searches to find relevant datasets, and get online help. And
because all the data in TranStats are indexed with a transportation
thesaurus, links to other transportation research information and data are
easy through the National Transportation Library.
The website is at http://www.bts.gov/transtats. Check out "Getting Started"
on the TranStats homepage.
Your comments and feedback will help us ensure high standards of quality and
usability before we release TranStats to the public. For example, we want to
know if the site is user friendly. Are databases easy to access? Are
database descriptions adequate? Are the analytical tools useful? Is the site
easy to navigate? Is the design intuitive?
Please explore TranStats and send us your comments and feedback through
e-mail (answers(a)bts.gov) or call us toll-free (1-800-853-1351). If you have
trouble starting up and need help, please send us an e-mail at the same
address or call the same toll-free number--our information service
specialists will be there to answer your questions. The user testing will
continue through COB Friday, August 30th, 2002.
Please feel free to spread this message to other users who might be
interested. We'll appreciate your help in making this a success.
Ashish K. Sen
Director,
Bureau of Transportation Statistics
U.S. Department of Transportation
Washington, DC.
Kevin:
>Now that the Census has released SF3, does the LIST know of way to download
>(at once) all of the Block Group SF3 data for a county, or do I have to
>download each Tract individually and merge them?
The structure of SF 3 is one header file plus 76 (!) data files, none with
more that 250 fields, to handle the 16,520 fields in the 405 tables for
Census Tracts and above. There are "only" 5558 fields in 281 tables for
Block Groups.
Each file has all summary levels mixed together, so you have to search each
file that has the tables you want to look for the block groups or other
areas you want.
TransCAD and Maptitude users have it a lot easier. TransCAD users get the
SF 3 Data CD for their state free as part of their maintenance agreement,
plus the State Data CD with Block Group and other boundaries for their
state. Maptitude users (or TransCAD users that want other states) can buy
these CDs for $195 each. Nationwide Census Tracts, ZCTAs, counties, MSAs,
etc. come with both TransCAD and Maptitude.
The SF3 Data CDs have all 77 files merged, then split into each summary
level: Block Groups, Census Tracts, etc. With the Table Chooser for SF 3,
an add-in to TransCAD and Maptitude, you can easily pick the geography and
tables that you want, and output a geographic file (with the tables
attached) or just a tabular file.
SF 3 Data CDs are being released as the Census Bureau releases the states.
12 states are out, and seven more are due tomorrow. For more information,
please visit (http://www.caliper.com/DataCDs/SF3DataCD.htm).
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
Thank you to all that answered my question. Hopefully, Washington State
DOT will follow the same procedure as they did after the 1990 census.
Eric Johnson
Spokane Regional Transportation Council
I used the CB FTP site (http://www2.census.gov/census_2000/datasets/Summary_File_3/) for the data:
The SF 3 files are built on the same lines as the previous releases (SF 1 and PL data). The package consists of one GEOGRAPHIC file, and 76 data files. The process I used to convert the data into a GIS (in my case Arcview) is:
1. Downloaded the shape file for BGs from the ESRI website at www.geographynetwork.com
2. Downloaded the geography file, and the datafiles from the Census Bureau FTP site at: http://www2.census.gov/census_2000/datasets/Summary_File_3/
3. Opened these files in MS Access. If you want detailed instructions, please refer to http://www2.census.gov/census_2000/datasets/Summary_File_3/0README_SF3.doc
OR
http://www.census.gov/support/SF3ASCII.html
There is also a specific website to help you open the data in MS Access. Please refer to: http://www.census.gov/support/2000/SF3/
4. Exported the database into DBF, and connected to the Arcview shapefile downloaded in step 1.
Steps 2, and 3 are the only "problem" areas to most users. The Census Bureau is providing LIVE online support, and telephonic support to accomplish these steps. For online support, please visit:
http://www.census.gov/support/SF3ASCII.html and click on the GREEN BOX with the title "LIVE HELP".
The telephonic and e-mail contact information is:
301-457-1324 Voice
301-457-1296 Fax
TechSupp(a)Census.gov
If you need more help on the Arcview/GIS side (steps 1, and 4), please refer to the FHWA Census Issues website note on SF 1 data.
http://www.fhwa.dot.gov/planning/census/sf1.htm
The steps are almost the same, the difference is that in the case of SF1, the data was at the level of census blocks, most of SF 3 data is at the level of Block Groups.
Hope the above is of use!
Thanks
Nanda Srinivasan
>>> kharrison(a)sarpc.org 08/19/02 10:34AM >>>
Now that the Census has released SF3, does the LIST know of way to download
(at once) all of the Block Group SF3 data for a county, or do I have to
download each Tract individually and merge them?
Has anybody downloaded SF3 by BG from Census or American Fact Finder??
Kevin Harrison
South Alabama Regional Planning Commission
651 Church St
Mobile, AL 36602
251.433.6541
Does anyone know when the FHWA will decide on whether it is going to use
the Census defined UAB or allow the development of modified ones by
MPO's?
I comparing Spokane County, WA 2000 Census UAs with our FHWA adopted
UAB, there's some quite significant differences, such as the river
flowing through the middle of the UA is non-urban, which splits the main
UA into two parts (and theoretically makes the bridges across the river
subject to rural funding programs instead of urban.)
Thanks for any information that develops.
Eric Johnson
GIS Supervisor
Spokane Regional Transportation Council