2010 Place FIPS/ANSI Data

What are Place FIPS/ANSI Codes? Geographic place codes are used to facilitate the storage, processing, exchange and retrieval of geographic information. FIPS (Federal Information Processing Standards) is a published series of standardized codes used for interchange between government agencies and other technical communities in order to ensure uniform practice and organization.

The Business ZIP Code Database now comes with a new data table relating ZIP Codes to the Place FIPS/ANSI data. You can now match up a given ZIP Code to the Place FIPS code and relate it to other data sets. A new data table is provided in each format with the following data:

# Field Name Data Type Description
01 ZIPCODE VarChar(5) 00000-99999 Five digit numeric ZIP Code of the area.
02 STATE VarChar(2) Two character state abbreviation.
03 STATEFIPS VarChar(2) State FIPS code
04 PLACEFIPS VarChar(5) 2010 Place FIPS Code
05 PLACENAME VarChar(255) Place or county subdivision name and legal/statistical area description
06 PLACETYPE VarChar(255) Type of place or county subdivision
07 COUNTY VarChar(255) County or counties in which the place or county subdivision is located
08 FUNCSTAT VarChar(1) Functional status code
09 FUNCSTATTEXT VarChar(255) Functional status
10 CLASSFP VarChar(2) 2010 Place FIPS Class Code
11 GEOID VarChar(7) Concatenation of 2010 State and Place
12 POPPT Integer Calculated 2010 Population for the relationship record
13 HUPT Integer Calculated 2010 Housing Unit Count for the relationship record
14 AREAPT Integer Total Area for the record
15 AREALANDPT Integer Land Area for the record
16 ZPOP Integer 2010 Population of the 2010 ZCTA
17 ZHU Integer 2010 Housing Unit Count of the 2010 ZCTA
18 ZAREA Integer Total Area of the 2010 ZCTA
19 ZAREALAND Integer Total Land Area of the 2010 ZCTA
20 PLPOP Integer 2010 Population of the 2010 Place
21 PLHU Integer 2010 Housing Unit Count of the 2010 Place
22 PLAREA Integer Total Area of the 2010 Place
23 PLAREALAND Integer Total Land Area of the 2010 Place
24 ZPOPPCT Decimal(12,2) The Percentage of Total Population of the 2010 ZCTA represented by the record
25 ZHUPCT Decimal(12,2) The Percentage of Total Housing Unit Count of the 2010 ZCTA represented by the record
26 ZAREAPCT Decimal(12,2) The Percentage of Total Area of the 2010 ZCTA represented by the record
27 ZAREALANDPCT Decimal(12,2) The Percentage of Total Land Area of the 2010 ZCTA represented by the record
28 PLPOPPCT Decimal(12,2) The Percentage of Total Population of the 2010 Place represented by the record
29 PLHUPCT Decimal(12,2) The Percentage of Total Housing Unit Count of the 2010 Place represented by the record
30 PLAREAPCT Decimal(12,2) The Percentage of Total Area of the 2010 Place represented by the record
31 PLAREALANDPCT Decimal(12,2) The Percentage of Total Land Area of the 2010 Place represented by the record