|Basic Tables Profile Generator - Vers. 2|
|All States in the U.S.|
OverviewThis application permits access to the Missouri Census Data Center's "Basic Tables" profile reports for the most commonly requested geographic summary units for the entire country. This is the menu-driven version of the Basic Tables: 1990 Demographic Profile Generator web application (delivers the same results, but the interface is quite different). To utilize that application requires that you enter the geographic codes for the area you want. This application is entirely menu driven and requires no code input from the user.
The source of all the data in these reports is the 1990 Decennial Census. More specifically, all data are extracted from the 1990 Summary Tape File 3 products distributed by the Census Bureau. These files were specially processed by the MSCDC to create standard STF3 extract datasets, which are the direct data source for these reports. The reports generated by this application are all done "on the fly" using a SAS(r) program which is dynamically invoked. (This is why you will normally experience a several second wait between when you click on the link for a report and when the report actually appears in your browser.)
The geographic units for which reports are available include
- states (accessed from the County menus),
- cities and towns (of any size),
- metropolitan areas,
- census tracts,
- block groups (there are no menus for these but you can get data for them - see the following paragraph)
- ZIP codes (from STF3B, vintage 1991), and,
- for selected states only, MCD's (county subdivisions).
Using the original version of the application without menus (see above) you can also generate reports for the U.S. Totals, regions, divisions and block groups. Or, if you are URL-savvy, you can edit the appropriate codes. To get a block group report for a specific census tract you can use this application to select the census tract in which the BG is located. Generate the tract report. Then go to your browser's Location window and edit the URL. Add "&bg=1" (or "bg=2" to see block group 2, etc.) to the end of the URL and resubmit.
Background information about the tables is available in a Table Descriptions and Definitions page. Links to the various sections of this page are embedded in the report pages themselves to facilitate access while browsing the data.
New for Version 2Version 2 provides dramatically improved response time. The performance improvement is primarily due to the fact that the application now runs on a new server which is about ten times faster than it's predecessor.
A subset of the data items in the report have been designated as "key indicators" and the cells containing these items are now color coded to indicate their percentile ranking. See http://mcdc.missouri.edu/xtabs3_colorcodes.html for details (there is a link to this page at the bottom of each generated report.)
The option to display tables in plain text, or to display with no cell borders in html has been dropped from this version. Log files indicated nobody was using the option.
The way in which multiple simultaneous requests are handled is different in Version 2. In the previous version, the system would start up a new process (i.e. instance of SAS) to handle each request for a profile. A counter was kept and the system would not allow more than 12 requests to be running at one time. The current version involves just a single instance of SAS to handle all requests sequentially. There is no limit on the number of requests, but your request will be queued. This should not be much of a problem since requests are generally handled in about a second.
Access to the Data Used in the ProfilesThese data are stored as SAS datasets on the MCDC server site at the U. of Missouri. You can access these data (and convert them to several standard formats including comma-delimited and dbf -- you do NOT need to know SAS) using the uexplore web application on that site and going to the filetype (subdirectory) stf903x. Use this link to go directly to the stf903x directory. At some point you need to view the on-line tutorial.
These data are also available as part of the Archive of Census Related Products at the CIESIN/SEDAC site. Go to the "Standard Extract Files" section. These files were created in conjunction with a series of map boundary files that can be used with the data to generate thematic maps. In fact, CIESIN also provides a DDViewer application that allows you to generate such maps live via the web.
Go to: MCDC Home Page | MCDC Demographic Profile Products | Blodgett's home page
Source: USDC, Bureau of the Census, Summary Tape File 3, 1990 Census.
The Missouri Census Data Center Program is sponsored by the Missouri Secretary of State'f office,  Missouri State Library.
Questions and comments can be addressed to John Blodgett at OSEDA.