Massachusetts Institute of Technology
Department of Urban Studies and Planning


11.521
Spatial Database Management and Advanced Geographic Information Systems
11.523
Fundamentals of Spatial Database Management

1980 Census Data


This page describes the CENSUS data table and other tables that you may find useful.

Table: CENSUS
(Data from the 1980 Census)

Field  Field Name   Type          Explanation
-----  -----------  ------------  -------------------------------------------  
  1    NSA_CODE     number(5)     Which of 64 neighborhood statistical areas
  2    TOTALPOP     number(10)    Total population
  3    FAMILIES     number(10)    Number of families
  4    HOUSEHOLDS   number(10)    Number of households
  5    TOTHSUNITS   number(10)    Total housing units
  6    OCCHSUNITS   number(10)    Total occupied housing units
  7    VACHSUNITS   number(10)    Total vacant housing units
  8    RENTEROCC    number(10)    Total renter-occupied housing units
  9    MEDIANRENT   number(10)    Median gross rent
 10    WHITEPOP     number(10)    White population
 11    BLACKPOP     number(10)    Black population
 12    MEDIANHINC   number(10)    Median household income (in 1979) 
 13    MEDIANFINC   number(10)    Median family income (in 1979)
 14    WORKERS_0    number(10)    Workers in fam. (families with no workers) 
 15    WORKERS_1    number(10)    Workers in fam. (families with 1 worker)
 16    WORKERS_2    number(10)    Workers in fam. (fam. w/ 2 or more workers)
 17    TOTSFD       number(10)    Single family detached units (total)
 18    TOTSFA       number(10)    Single family attached units (total)
 19    OCCSFD       number(10)    Single family detached units (occupied)
 20    OCCSFA       number(10)    Single family attached units (occupied)
 21    ROCCSFD      number(10)    Single family detached units (renter occ.)
 22    ROCCSFA      number(10)    Single family attached units (renter occ.)

Table: DECISION

Field  Field Name   Type          Explanation
-----  -----------  ------------  -------------------------------------------  
  1    DEC_CODE     number(5)     Code for decision variables (brarecom
                                    and boarddecis)
  2    DECISION     varchar2(25)  Type of decision corresponding to
                                    previous code

Table: USE

Field  Field Name   Type         Explanation
-----  -----------  -----------  -------------------------------------------  
  1    USE_CODE     number(2)    Code for landuse variables (existuse
                                   and prpseduse)
  2    LANDUSE      varchar(25)  Landuse (existing or proposed)
                                   corresponding to previous code

Table: NSA

Field  Field Name   Type          Explanation
-----  -----------  ------------  -------------------------------------------  
  1    NSA_CODE     number(10)    Code for subneighborhood areas (subnghbrhd)
  2    NSA_AREA     varchar2(33)  Neighborhood statistical area (i.e., sub-
                                    neighborhood) corresponding to previous
                                    code
  3    NSA_SUBAREA  varchar2(60)  Subareas included within neighborhood
                                    statistical areas

Table: NEIGHBRHD

Field  Field Name   Type          Explanation
-----  -----------  ------------  -------------------------------------------  
  1    NEI_CODE     number(5)     Code for neighborhood areas (neighbrhd)
  2    NEIGHBRHD    varchar2(20)  Neighborhood area corresponding to 
                                    previous code

Back to the 11.521 Home Page
Back to the CRL Home Page
Back to the MIT Home Page

Written by Joseph Ferreira, Jr.
Edited and converted to HTML by Thomas H. Grayson, 15 February 2000.
Last modified: 19 February 2000 [jf]