Attributes for County CTU Lookup Table: 
  
COCTU_ID:   11 digit identifier for the combination of county and CTU  
            (concatination of CO_CODE and CTU_ID_CEN).  This is the  
            official U.S. Census Bureau format. 
 
COCTU_CODE: 8 digit code (concatenation of CO_CODE and CTU_CODE below). 
            As of 2006 the FIPS55 codes upon which the CTU_CODEs based,  
            have been official retired by the federal governement.  They  
            are replaced by the GNIS codes used in the COCTU_ID field  
            described above.  The retired codes will continue to be  
            included in this dataset, but codes will not be created for  
            new cities after the 2010 Census. 
  
CO_CODE:    3 digit ID for the county in which the MCD resides.  This is the  
            official state and federal county code and is to be treated as text  
            with leading zeros. e.g. 163, 003 
 
CTU_ID:     The Geographic Names Information System (GNIS) official federal 
            unique identifier for each city, township or unorganized territory. 
            This field is an integer data type of 6 to 7 digits. 
 
CTU_ID_CEN: This is a text representation of the CTU_ID above.  This format is  
            used by the Census Bureau (8 digits, right justified with leading 
            zeros included). 
 
CTU_CODE:   5 digit FIPS55 'Place' code for CTU.  As of 2006 these codes have  
            been official retired by the federal government.  They are replaced 
            by the GNIS codes above. The Census Bureau will continue to create 
            FIPS55 Place codes for new cities and townships through the 2010 
            Census.  After that, no new FIPS55 codes will be created. Note that 
            for townships that wholly incorporate into cities, the same FIPS55 
            code for the former township will usually be used for the new city.  
            Conversely, GNIS creates a new ID for the new city. 
 
CTU_NAME:   Name of the city, township or unorganized territory - format 1.   
            e.g. Burns Twp., Blaine 
 
CTU_NAME2:  Name of the city, township or unorganized territory - format 2. 
            e.g. Burns Township, Blaine 
 
CTU_NAME3:  Name of the city, township or unorganized territory - format 3. 
            e.g. Township of Burns, City of Blaine 
 
CTU_NAME4:  Name of the city, township or unorganized territory - format 4 
            e.g. Burns, Township of; Blaine, City of 
 
CTU_NAME5:  Name of the city, township or unorganized territory - format 5 
            e.g. Burns, Blaine 
 
COCTU_DESC: Description of the COCTU, including portion of county and  
            historical designation if applicable;  
            e.g. Burns Township, Blaine (Anoka Co. part), Elko (historical) 
 
CTU_PARTEX: Indicates that the whole city is part external 
            T = Whole city has part that is external to seven county metro. 
            F = Whole city is within seven county metro. 
 
CO_NAME:    Name of the county (e.g. Carver) 
  
CTU_ABBREV: 6 character unique abbreviation for the CTU developed by Met.  
            Council GIS staff for file naming purposes  e.g. ANDOVE, ANOKAX. 
 
COMCD_CENS: The Census Bureau's old 6 digit county-MCD code  
            (concatenation of FIPS county code and old Census MCD code) 
            This code was retired in the 1990s. 
  
CTU_TYPE:   Type of CTU 
            C = city 
            T = township 
            U = unorganized territory 
            H = historical CTU.  No longer legally exists (e.g. City of Elko) 
            O = other (not a CTU, but useful as an entity in this table  
                e.g. MSP airport,) 
 
CTU_STATUS: Indicates status of CTU 
            A = Active CTU 
            H = Historic CTU 
            P = Pending CTU 
 
DUP_CTYTWP: Identifies cities and townships with the same name (e.g. City of  
            Vermillion and Vermillion Township) 
  
ABC_SORT:   3 digit integer that will sort alphabetically e.g. 'St.' is  
            sorted as 'Saint' 
  
FIVE_COLOR: Numbers 1 to 5 for shading polygons so that adjacent CTUs have  
            different colors. 
 
MCDIST2003: Metropolitan Council District number in which the MCD resides, as 
            enacted in 2003.  Districts are numbered 1-16.  Three cities are  
            split into multiple districts and have been given an alternate  
            value in this dataset.  Eagan = 97 (split into districts 15 and  
            16).  Minneapolis = 98 (split into districts (6,7 and 8).  St. Paul  
            = 99 (split into districts 14 and 15).  Cities exempt from Council  
            jurisdiction are coded as 0. 
 
MCDIST1993: Metropolitan Council District number in which the MCD resides, as  
            enacted in 1993.  Districts are numbered 1-16.  Three cities are  
            split into multiple districts and have been given an alternate  
            value in this dataset.  Maplewood = 96 (split into districts 11 and  
            12).  Minneapolis = 98 (split into districts 6,7 and 8).  St. Paul  
            = 99 (split into districts 13 and 14).  Cities exempt from Council  
            jurisdiction are coded as 0. 
 
MCFIN_CODE: The Metropolitan Council Finance Dept. accounting codes for those  
            cities and townships that are connected to Council owned waste  
            water treatment plants and are paying sewer access charges (SAC).   
            Not all cities and townships in the metro area will have a code. 
 
MNREV_CODE: Minnesota Department of Revenue code for CTU; e.g. 1400, 500, 6  
            (unique within county only) 
 
OLD_CO2D:   Old state 2 digit county code (Note 3 digit code is state standard) 
 
CO2D_MNREV: MN Dept. of Revenue code for CTU preceded by 2 digit county code 
 
MNDES_CODE: Minnesota Department of Economic Security 'community' code for  
            CTU, e.g. 0025, 0215  (unique within county only) 
  
HENN_CODE:  'Municipal' code used by Hennepin County 
  
POP_2000:   2000 population for county-CTU based on the 2000 census (does  
            not including any subsequent corrections of the data by the  
            Census Bureau, if any) 
 
POP_1990:   1990 population for county-CTU based on the 1990 census  
            (including subsequent corrections of the data by the Census  
            Bureau) 
 
ACRES_MCD:  The calculated acreage of the minor civil division based on the  
            quarterly MetroGIS county_ctu dataset.  Note that where cities fall  
            within two counties, each portion is a single MCD.  Both must be  
            summed to get the acreage for the entire city.  Where an MCD  
            contains multiple polygons (in the same county), this field  
            reflects the sum of those polygons. 
 
ACRES_CTU:  The calculated acreage of the entire city, township or unorganized  
            territory based on the quarterly MetroGIS county_ctu dataset.  Note  
            that where a CTU resides within two counties, BOTH records in this  
            MCD table will contain the same total acreage for the entire CTU.  
            All polygons for a CTU are summed to create this acreage.   
 
MIN_X:      Minimum X Coordinate of CTU in UTM zone 15, meters, NAD83 coordinates 
 
MAX_X:      Maximum X Coordinate of CTU in UTM zone 15, meters, NAD83 coordinates 
 
MIN_Y:      Minimum Y Coordinate of CTU in UTM zone 15, meters, NAD83 coordinates 
 
MAX_Y:      Maximum Y Coordinate of CTU in UTM zone 15, meters, NAD83 coordinates 
 
MC_EXEMPT:  Exempt from Met. Council authority (Y/N) (e.g. Northfield) 
 
BPPA_CODE : Metropolitan Council Blueprint 2030 planning area designations for  
            cities and townships. 
             10 = central cities 
             20 = developed communities 
             30 = developing communities 
             40 = rural growth centers 
             51 = rural communities: diversified rural communities 
             52 = rural communities: rural residential area 
             53 = rural communities: ag preserve 
             60 = 3 non-Council communities 
 
RDF_AREA:   Metropolitan Council Regional Development Framework 2030 planning  
            area designations for cities and townships. 
             21 = central cities (part of developed communities) 
             22 = developed communities 
             30 = developing communities 
             40 = rural centers & growth centers 
             51 = rural communities: diversified rural communities 
             52 = rural communities: rural residential areas 
             53 = rural communities: ag preserve 
             60 = 4 non-Council communities 
 
RES_QUAD:   Metropolitan Council Research Dept. quadrants used for aggregating 
            certain types of statistics (NE, NW, SE & SW) 
 
SECTOR_REP: Metropolitan Council planning sector representative for each  
            community 
 
START_DATE: The date the CTU became active (status) 
 
END_DATE:   The date the CTU became historical (status) 
 
CHANGE_DAT: The date of the most recent change to a record in this table 
            (e.g. new or historical CTU, corrections to table, etc.) 
 
NOTES:      Notes or comments about this a record (e.g. date of incorporation) 
 
COCTU_ID_O: Old 11 digit identifier for the combination of county and CTU  
            (concatination of CO_CODE and CTU_ID_C_O).   
 
CTU_ID_OLD: The OLD Geographic Names Information System (GNIS) official  
            federal unique identifier for each city, township or 
            unorganized territory.  This field is an integer data type  
            of 6 to 7 digits.  Cities are not 'Civil' features, but  
            'Populated Places' 
 
CTU_ID_C_O: This is a text representation of the CTU_ID_OLD above.  This 
            format is used by the Census Bureau (8 digits, right  
            justified with leading zeros included). 
 
 
 
----------------------------------------------------------------------------- 
  
Field types and lengths 
                            Decimal 
Name        Type    Length  Places 
----------  ------  ------  ------ 
COCTU_ID    string    11 
COCTU_CODE  string     8 
CO_CODE     string     3 
CTU_ID      number     8 
CTU_ID_CEN  string     8 
CTU_CODE    string     5 
CTU_NAME    string    24 
CTU_NAME2   string    30 
CTU_NAME3   string    40 
CTU_NAME4   string    40 
CTU_NAME5   string    24 
COCTU_DESC  string    60 
CTU_PARTEX  string     1 
CO_NAME     string    10 
CTU_ABBREV  string     6 
COMCD_CENS  number    10 
CTU_TYPE    string     1 
CTU_STATUS  string     1 
DUP_CTYTWP  string     1 
ABC_SORT    numeric    4 
FIVE_COLOR  numeric    1 
MCDIST2003  numeric    2 
MCDIST1993  numeric    2 
MCFIN_CODE  string     4 
COMCD_CENS  numeric    6 
MNREV_CODE  numeric    4 
OLD_CO2D    numeric    2 
CO2D_MNREV  numeric    6 
MNDES_CODE  string     7 
HENN_CODE   numeric    4 
POP_2000    numeric    9 
POP_1990    numeric    9 
ACRES_MCD   numeric    9 
ACRES_CTU   numeric    9   
MIN_X       numeric    9  
MAX_X       numeric    9 
MIN_Y       numeric    9 
MAX_Y       numeric    9 
MCEXEMPT    string     1 
BPPA_CODE   numeric    2 
RDF_AREA    numeric    2 
RES_QUAD    string     2 
SECTOR_REP  string    40 
REV_FOLDER  string    40 
START_DATE  date       8 
END_DATE    date       8 
CHANGE_DAT  date       8 
NOTES       string   150 
COCTU_ID_O  string    11 
CTU_ID_OLD  number     8 
CTU_ID_C_O  string     8