| 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 |
2395345 | 02395345 | City of Minneapolis | city | 44.9624634 | -93.267307 |
43000 | 053 | Hennepin | 05302395345 | 2705302395345 | 05343000 | active | May
13 2006 | Feb 12 2009