Database Description: The State of Minnesota Codes for the Identification of Cities, Townships and Unorganized Territories (CTU)

Prepared by the MnGeo Standards Committee
May 4, 2009
 

Column Name Field Name Description Data Type Size Unique Allow Nulls Example
GNIS_FEATURE_ID_INTEGER Feature Id The formal GNIS Feature ID as designated by the USGS for a city, township or unorganized territory expressed as an integer as defined in ANSI standard INCITS 446-2008 Integer   No No 2395345
GNIS_FEATURE_ID_TEXT Feature Id Text The formal GNIS Feature ID for the same city, township or unorganized territory and presented as an 8 character text string with zeros padding to the left Character 8 No No 02395345
FEATURE_NAME Feature Name The formal name of the city, township or unorganized territory and defined in ANSI standard INCITS 446-2008 and preceded with: ‘City of <city name>’, ‘Township of <township name>’, or ‘Unorganized Territory of <UT name>’ Character 128 No No City of Minneapolis
CTU_TYPE CTU Type Domain: ‘city’, ‘township’, ‘unorganized territory’ Character 32 No No city
LATITUDE Latitude North latitude (positive real number) of a representative feature location point at, or near, the center of the CTU and expressed in decimal degrees as defined in ANSI standard INCITS 446-2008 Real 8 byte No No 44.9624634
LONGITUDE Longitude West longitude (negative real number) of a representative feature location point at, or near, the center of the CTU and expressed in decimal degrees as defined in ANSI standard INCITS 446-2008 Real 8 byte No No -93.267307
CENSUS_CODE Census Code Content of the Entity Code (a.k.a. Place Code) field in the  FIPS-55 coding standard (retired) Character 5 No Yes 43000
ANSI_COUNTY_CODE ANSI County Code Three-digit county code within which the CTU is located as defined by MN State Standard (ANSI standard INCITS 31-200X;formerly FIPS6-4) Character 3 No No 053
COUNTY_NAME County Name The name of the county without abbreviation Character 32 No No Hennepin
COUNTY_CODE_AND_FEATURE_ID County Code and Feature Id County code and GNIS feature ID text concatenated Character 11 Yes No 05302395345
STATE_COUNTY_CODES_FEATURE_ID State County Codes Feature Id Codes for 1) the State of Minnesota as defined by MN State Standard (ANSI standard INCITS 38-200X ; formerly FIPS 5-2) which is ‘27’, 2) county code and, 3) GNIS feature ID integer concatenated Character 13 Yes No 2705302395345
COUNTY_CODE_AND_CENSUS_CODE County Code and Census Code County code and Census code concatenated Character 8 Yes Yes 05343000
ACTIVE_OR_HISTORICAL Active or Historical Domain: ‘active’, ‘historical’.  Indicates that this CTU is either currently a valid entity or that it has been superseded and is being retained in the database for its historical reference Character 10 No No Active
DATE_CREATED Date Created The date the original record was created Date   No No May 13 2006
DATE_EDITED Date Edited The date the record was last edited Date   No Yes Feb 12 2009

Sample record of the MN CTU Database:


2395345 | 02395345 | City of Minneapolis | city | 44.9624634 | -93.267307 | 43000 | 053 | Hennepin | 05302395345 | 2705302395345 | 05343000 | active | May 13 2006 | Feb 12 2009