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 |