Database Description: The State of Minnesota Codes for the Identification of Cities, Townships and Unorganized Territories (CTU)
Prepared by the MnGeo Standards CommitteeMay 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[2013] | 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[2013] 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[2013] | 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[2013] | 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-3 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