Products and Services

Database Access | Special Reports and Services | Geocoding | Thematic Mapping

Database Access

The Urban Information Center, as part of its mission as a coordinating agency within the Missouri State Census Data Center, maintains one of the most extensive collections of public data files in the country. This data archive, which is somewhat biased towards data produced by the U.S. Census Bureau, consists almost entirely of data stored as SAS(r) datasets. Most of the datasets were converted with SAS programs written by the UIC and kept on the archive in special "Tools" subdirectories. Because we do our own custom conversions, we are able to create a certain amount of standardization and coding consistency within the data collection. It also forces us to learn things about the data in our collection that we might not otherwise doscover if we were not in the habit of "standardizing" our data. We provide a tool for allowing users to access the data archive via the WWW, but it is not generally accessible for anything beyond basic extractions for users not familiar with the organization and coding conventions used. This web interface tool, called uexplore, is actually a series of SAS applications that permit various types of access to the data (i.e. access metadata, create a user-specified extract, generate a custom report, etc.) We hope to create more extensive user docuentation for this system in the near future, but that is dependent on levels of funding.

Requests that require access to this database and that involve custom programming are our specialty. If a client has their own data that they need to combine with the public information, we specialize in such applications (usually requiring an address matching and aggregation process.)

While we maintain our data in a proprietary database format, we have software tools that make it very easy to provide our clients with data in a wide variety of commonly used formats. Comma delimited, .dbf, .xls (Excel) and fixed format ascii are among the most popular formats.

The UIC staff of three full time persons has a combined experience of over 50 years working with these kinds of data and applications.

The link we provided to you above to our uexplore application is actually just one of several "doors" that can be used to enter the application. We have a number of more guided paths that will help guide you to particular type of data you are searching for before dropping you off in the set of parameter-driven SQL-flavored form fillout screens that you will need to negotiate in order to access your data. To access the archive with some additional navigational front ends, return to our home page and follow the link there to the MSCDC Public data archive. (Or just click right here, of course.)

Just to give you a hint at the scope of the archive, we can tell you that it includes:


Special Reports and Services


This page maintained by: John Blodgett
john_blodgett@umsl.edu

University of Missouri-St. Louis
211 Lucas Hall
8001 Natural Bridge Rd
St. Louis, MO 63121-4499
FAX (314) 516-6274

Return to Urban Information Center Home Page

URL: http://www.oseda.missouri.edu/uic/uic1.html
Updated Mar 16, 1998