Introduction to SEEDIS


description
printed documentation
databases in SEEDIS
geographic map files in SEEDIS
1970 Census data
mortality data


Description:

The Socio-Economic Environmental Demographic Information System (SEEDIS) is an integrated information system, developed at Lawrence Berkeley National Laboratory, which provides access to geographically based public data files from the 1970's and 1980's. SEEDIS includes 1980 Census data and about 100 other databases, with extensive on-line documentation.

Data selected by the user and obtained from SEEDIS are written to a formatted ASCII file suitable for downloading, printing, or further processing in the user's computer. The output file contains a complete description of each data column (data element); each row (geographic area) is identified by a unique set of geographic codes (geocodes) and a descriptive name.

SEEDIS represents approximately 100 person-years of development effort between 1970 and 1985. The first version of SEEDIS ran in a Control Data Corporation 6600 mainframe computer from 1975 until 1980. The second version ran from 1980 until 1997 in a Digital VAX computer at LBNL. In 1996-97 SEEDIS was transferred to an internal computer at the Bureau of the Census. In the future, SEEDIS data, including 1960, 1970 and 1980 Census data, will be made available through Web-based information systems currently under development at the Census Bureau.


Printed Documentation:

A printed user's guide, for the SEEDIS system installed at the Census Bureau, is available from Deane Merrill. Although the list of available databases is incomplete, that document correctly describes the current SEEDIS user interface and provides examples of use.

McCarthy J, Merrill D, Marcus A, Benson W, Gey F, Holmes H and Quong C. The SEEDIS Project: A Summary Overview of the Social, Economic, Environmental, Demographic Information System -- Lawrence Berkeley Laboratory Report PUB-424 Rev, May 1982.


Databases in SEEDIS:

There are a total of 110 databases in SEEDIS, which may be generally classified as follows:

	census		20
	energy		 3
	environment	19
	geography	11
	health		33
	socioeconomic	24

In SEEDIS a database is defined as a fixed list of data elements which are available for one or more geographic areas. The list of geographic areas may include entries from different geographic levels, for example a list of cities and a list of counties.

There are also (concidentally) 110 geographic levels in SEEDIS, including:

	nation and large interstate levels	11
	small interstate levels			20
	state parts of interstate levels	21
	state and large intrastate levels	19
	county levels				16
	place and MCD levels			10
	small subcounty levels			13

The following is a list of databases available in SEEDIS. Each database has its on-line data dictionary, which can be browsed from within SEEDIS, or downloaded and printed by the user. Each data dictionary contains

Code: Unique SEEDIS database code.

Title: Name of SEEDIS database

Lvls: Number of available geographic levels. Example of geographic levels are STATE (states including DC), COUNTY80 (1980 Census counties), TRACT80 (1980 Census tracts), etc. For a complete description of SEEDIS geographic levels, enter SEEDIS and type after the first prompt:

	area
	show

The same information is available via anonymous FTP as: cedrcd.lbl.gov:/data1/merrill/docs/cedr/level.hel

Max Scope: Scope of geographic coverage (the maximum for any geographic level). For example, US means the United States. Data bases with Max Scope equal to "NONE" are available at LBNL, but not installed in SEEDIS. For a complete description of the geographic scope of each database at each geographic level, enter SEEDIS and type after the first prompt:

	show

The same information is available via anonymous FTP as: cedrcd.lbl.gov:/data1/merrill/docs/cedr/databases.hel

Areas: Total number of geographic areas. Equal to the number of geographic areas at each level (for example 3137 COUNTY80s in the US), summed over all available geographic levels. There is double counting; for example, for a particular database, Washington DC might be counted as a STATE and a COUNTY80 and a PLACE80 (1980 Census place) and a COUNTY (1970 Census county) and a PLACE (1970 Census place).

Nde: Number of data elements (fields) available for each geographic area.

For example, SEEDIS database AQ contains data from the 1970 Census Fourth Count Population file (total of all races combined). Data are available for two geographic levels: 52 STATEs including DC and Puerto Rico, and 243 SMSA71s (Standard Metropolitan Statistical Areas as defined in 1971). There are 1178 data elements (fields) available for each geographic area.

SEEDIS database AR contains the same data for whites only. These data cover only the US (excluding Puerto Rico): 51 STATEs including DC, and 243 SMSA71s.

		    CENSUS (20 databases)
                    ------------------------------------------------
                                                Max                            
   Code Title                              Lvls Scope  Areas     Nde
   ---- ---------------------------------- ---- ----- ------ -------
   AQ   1970 Census 4th Count, all races      2 US+PR    295    1178 
   AR   1970 Census 4th Count, whites         2 US       294    1178 
   AS   1970 Census 4th Count, blacks         2 US       294    1178 
   AT   1970 Census 4th Count, other race     2 US       294    1178 
   AU   1970 Census 4th Count, Spanish        2 US       294    1178 
   CA   1980 Census: Summary Tape File 1     22 US    547093     342 
   CF   1980 Census: Summary Tape File 3     23 US    650301    1153 
   CG   1980 Census: Equl Emp Opportunity     5 US      3969   13188 
   CL   1980 Census: STF4 Pop RecA            4 US     57358    1020 
   CM   1980 Census: STF4 Pop RecB  7races    2 US     42915   13944 
   CN   1980 Census: STF4 HousRecA            4 US     53103    3905 
   CO   1980 Census: STF4 HousRecB 39races    2 US      3458   61464 
   CP   1980 Census: STF2 Rec A, File A       5 889CY  42915    1098 
   CQ   1980 Census: STF4 HousRecB  7races    2 US     42915   11032 
   CU   1980 Census: STF2 Rec B, 7 Races      5 889CY  42915    6776 
   CV   1980 Census: STF2 Rec B, 28 Races     1 NONE    3137   27104 
   CW   1980 Census: STF2 Rec A, File C       1 NONE    3137    1364 
   DD   1980 Census: STF3: Puerto Rico        7 PR      1913     912 
   DS   1980 Census: STF4 Pop RecB 39races    2 US         0   77688 
   DX   1970 Census 5th Count                 3 US    275664     928 
                    
                    ENERGY (3 databases)
                    ------------------------------------------------
                                                Max                  
   Code Title                              Lvls Scope  Areas     Nde 
   ---- ---------------------------------- ---- ----- ------ ------- 
   B    Biomass Resources, 1976 and 2025      1 CA        58      55 
   D    1970 Residential Housing+Heating      1 CA        58     233 
   E    1960-95 Elec Generating Capacity     17 US      6429      18 
                    
                    ENVIRONMENT (19 databases)
                    ------------------------------------------------
                                                Max                  
   Code Title                              Lvls Scope  Areas     Nde 
   ---- ---------------------------------- ---- ----- ------ ------- 
   AO   1974-1976 air quality                 1 TNCS    4476      41 
   AZ   1974-76 Air Qual, 1- & 24-hr          1 US      6625      14 
   CD   1974-76 Air Quality by Location       1 US+4    5777      25 
   I    1974-76 Air Quality                   1 US      6625     127 
   JA   1974-76 Air Qual, CO, Hourly          1 SF       722      39 
   JB   1974-76 Air Qual, Tot HC, Hourly      1 SF       722      39 
   JC   1974-76 Air Qual, NO2, Daily          1 SF       722      39 
   JD   1974-76 Air Qual, NO2, Hourly         1 SF       722      39 
   JE   1974-76 Air Qual, Oxidant, Hourly     1 SF       722      39 
   JF   1974-76 Air Qual, Ozone, Hourly       1 SF       722      39 
   JG   1974-76 Air Qual, SO2, Daily          1 SF       722      39 
   JH   1974-76 Air Qual, SO2, Hourly         1 SF       722      39 
   JI   1974-76 Air Qual, TSP, Daily          1 SF       722      39 
   JJ   1974-76 Air Qual, Sulfate, Daily      1 SF       722      39 
   L    1974-1976 Air Quality (complete)      1 US+PV   3220     257 
   M    1974-1976 Air Quality (summary)       1 US+PV   3220      30 
   QA   1975-2000 SEAS Gross Envir Resid      1 US       243     976 
   QB   1975-2000 SEAS Net Envir Resid        1 US       243     976 
   Z    1974-1976 Air Qual: county vs PUS     1 US+PV   3220      30 
                    
                    GEOGRAPHY (11 databases)
                    ------------------------------------------------
                                                Max                  
   Code Title                              Lvls Scope  Areas     Nde 
   ---- ---------------------------------- ---- ----- ------ -------
   AE   MEDX:1970 Pop, Hshlds, Centroids      1 US     35198       7 
   AG   MEDX:1970 Pop, Hshlds, Centroids     12 US      3177       6 
   AH   Geocodes of 1970 Census Tracts        1 US     34645       1 
   AL   Areas and Cntrds of Census Tracts     1 467CY  31691       8 
   AM   Areas, Centroids, and Boundaries      1 US+PV   3220      35 
   BL   MEDX:1970 Pop, Hshlds, Centroids      1 US    249189       7 
   DY   1980 Census: Geographic Base Maps     2       134263       4 
   H    Air Quality Monitoring Stations       1 US      6625      59 
   W    Census Place Location File            1 US     20466       7 
   ZY   Seedis Geocode file (no data)         2 US+PR  94385       0 
   ZZ   SEEDIS Geocode file (no data)         1 US     35197       0 
                    
                    HEALTH (33 databases)
                    ------------------------------------------------
                                                Max                  
   Code Title                              Lvls Scope  Areas     Nde 
   ---- ---------------------------------- ---- ----- ------ ------- 
   A    Extract, Pop at Risk to Air Poll      1 CA        58      25 
   AA   1968-72 Age Spec Mortality, White     4 US      3644     198 
   AB   1968-72 Age Spec Mortality, Black     4 US      3644     198 
   AC   Expectation of Life (1968-72 data)    4 US      3644      44 
   AN   1969-71 TNCS cancer incid by site     1 TNCS    4538     136 
   AV   1969-71 TNCS cancer incid by hist     1 TNCS    4538     216 
   BA   1969-77 Annual Leukemia Mortality     6 US      7211     960 
   BB   1973-76 Age Adj Mortality WM35-74     6 US      3644     145 
   BC   1973-76 Age Adj Mortality WF35-74     6 US      3644     145 
   BD   1973-76 Age Adj Mortality BM35-74     6 US      3644     145 
   BE   1973-76 Age Adj Mortality BF35-74     6 US      3644     145 
   BF   1973-76 Age Adj Mortality WM, All     6 US      3644     145 
   BG   1973-76 Age Adj Mortality WF, All     6 US      3644     145 
   BH   1973-76 Age Adj Mortality BM, All     6 US      3644     145 
   BI   1973-76 Age Adj Mortality BF, All     6 US      3644     145 
   BN   1968-72 Age Adj Mortality WM35-74     6 US      9922      82 
   BO   1968-72 Age Adj Mortality WF35-74     6 US      9922      82 
   BP   1968-72 Age Adj Mortality BM35-74     6 US      9922      82 
   BQ   1968-72 Age Adj Mortality BF35-74     6 US      9922      82 
   BR   1968-72 Age Adj Mortality WM, All     6 US      9922      82 
   BS   1968-72 Age Adj Mortality WF, All     6 US      9922      82 
   BT   1968-72 Age Adj Mortality BM, All     6 US      9922      82 
   BU   1968-72 Age Adj Mortality BF, All     6 US      9922      82 
   BZ   1973-77 SEER cancer incid by hist     4 SEER5   3689     308 
   CE   1968-72 Age Spec Mortality, White     5 US      6785      76 
   CK   1968-78 Annual age spec mortality     5 US      9353 1796696 
   CT   1973-81 SEER cancer incidences        8 SEER3  10712   95040 
   DJ   Epidemiologic Surveillance Proj       4 WI       217 5025240 
   DN   1979-84 Annual Age Spec Mortality     7 US     15739 2835648 
   DT   1968-78 Annual age spec mortality     8 US     18658 2940388 
   P    1968-1972 Age Adjusted Mortality      1 US      3141     652 
   V    1977 Area Resource File               1 EXAK    3112     889 
   X    Cancer Mortality, 1950-1969           1 US-AH   3108     424 
                    
                    POPULATION (21 databases)
                    -------------------------------------------------
                                                Max                  
   Code Title                              Lvls Scope  Areas     Nde 
   ---- ---------------------------------- ---- ----- ------ ------- 
   AF   1970-77 Population Age/Sex/Race       6 US      7211     608 
   AP   1980 Census Population (prelim)       4 US       168       3 
   BW   1980 Census Population by Age         2 US        52      15 
   BX   1980 Population by Race              11 US    166035      13 
   BY   1980 Population by Race               1 US    319105       7 
   CJ   1950-80 Population Age/Sex/Race       5 US      6260     306 
   DA   1970-80 Population Race Corrected     5 US      6331    2964 
   DB   1980-82 Population Race Corrected     4 US      6330     513 
   DC   1970/1980 County Correspondence       8 US     15780      11 
   DE   1980-84 Population Estimates          6 US      9472       5 
   DG   1980 Race Corr Pop Age/Sx/Rc/Span     6 US      9472    3324 
   DH   1980-87 Race Corr Pop by Race/Sex     7 NONE       0      72 
   DI   1980-87 Wkly/Monthly Pop Estimate     7 NONE       0    4122 
   DL   1980-85 Pop w/ Comp of Change         4 NONE       0       9 
   DO   1980-86 Pop Estimate  by Race         8 US     12628      28 
   DP   1980-86 Pop Est by Race/Sex/Age       8 US     12628    1197 
   DQ   1969-84 SEER Population Estimates     3 US        20   10032 
   DR   1968-83 Pop Est for Mort Surv Sys     7 US     15543    2880 
   O    1970-75 Population Age/Sex/Race       1 US      3141     432 
   R    Revised 1970 Pop'n Age/Sex/Race       2 US      3192     138 
   T    1970 Pop Age/Sex/Race/Mar Status      1 US      3141     216 
                    
                    SOCIOECONOMIC (24 databases)
                    ------------------------------------------------
                                                Max                  
   Code Title                              Lvls Scope  Areas     Nde 
   ---- ---------------------------------- ---- ----- ------ ------- 
   AD   1974-79 Labor Force, Unemployment     3 US       867      72 
   AI   1970 4th Cnt Census Socioecon Data    1 TNCS    4587      20 
   AJ   1971-1976 Employment by Industry      2 US      3192     284 
   AW   1980 Presidential Vote                2 US        52       5 
   AX   1969-2030 BEA State Econ Proj         2 US        52    1820 
   AY   1969-2030 BEA Regnl Econ Proj         6 US      1094     560 
   BJ   Pop,labor force,migr,fertility        3 US      1860     463 
   BK   Pop 60,70,77,82 Income 69,76          2 US     60984      16 
   C    Selected Socioeconomic Data           1 US        51      61 
   CB   1970 4th Count Census Demogr Data     1 TNCS+   6077      25 
   CC   World Data                            1 WORLD    223      12 
   CH   1979-1981 IRS Data                    1 US      3137      30 
   CI   1963 Employment by Industry           4 US      6247     391 
   CR   1940-70 Employment by Industry        5 US      6326     200 
   CS   1982 Population and 1981 Income       2 NONE       0       4 
   CX   1983 City-County Data/County File     4 US      6330     457 
   CY   1983 City-County Data/Cities File     2 US      1008     361 
   CZ   1982 U. S. Census of Agriculture      3 US      6329    3365 
   DK   1980-84 Pop & 79-83 percap Income     7 NONE       0       6 
   F    1947-1977 County Data Book            3 US      6329    1022 
   G    1974 U. S. Census of Agriculture      3 US      6329    1200 
   N    Farms and Wholesale Trade             1 US       173       2 
   U    1970 Socio-Econ Characteristics       1 US      3141     228 
   Y    1976 SIE Tabulations (14 tables)      1 US        51    4103 


Geographic map files in SEEDIS:

Geographic map files in SEEDIS include:

	boundaries of 1970 census tracts
	centroids of 1970 block groups
	boundaries of 1980 census tracts
	boundaries of 1980 minor civil divisions (MCDs)
	centroids of 1980 block groups
	boundaries of most larger units (counties, SMSAs, states, etc.)

The 1980 tract and MCD boundary files were purchased from a private vendor and may be used only within SEEDIS, or by special license arrangement.


1970 Census data:

In addition to SEEDIS, LBNL had 1970 Census data that are not fully installed for online access in SEEDIS. In 1994-95 these data were transferred from tape to LBNL's on-line mass storage system (MSS), and in 1996-97 to an internal computer at the Census Bureau. These data are in a compressed format suitable for installation in SEEDIS. Software is available to convert the data to ASCII text files.

	count			in SEEDIS		not in SEEDIS
	1st count		none			county and above
	2nd count		none			tract and above
	4th count population	state and SMSA		place, tract, MCD
	5th count population	block group, MCD	none
	6th count population	none			county and above


mortality data:

In addition to SEEDIS, LBNL had comprehensive county level mortality data that are not installed in SEEDIS. The original data are anonymous unit records (microdata) containing age, sex, race, date of death, county of residence, and underlying cause of death (4-digit ICD code). In 1994-95 these data were transferred from tape to LBNL's on-line mass storage system (MSS), and in 1996-97 to an internal computer at the Census Bureau. These data are ASCII flat files suitable for processing with a statistical analysis system such as SAS.

	dates		in SEEDIS		  not in SEEDIS
	1950-61		none			  unit records, cancer only
	1962-67		none			  unit records, all causes
	1968-78		county totals, all causes unit records, all causes
	1979-84		county totals, all causes unit records, all causes


back to: SEEDIS home page


seedis/intro.txt.html 4/19/98 in:

http://parep2.lbl.gov/mdocs
http://merrill.wwh.net/mdocs
http://imap.chesapeake.net/~merrill/mdocs

merrill@crocker.com