Skip to main content
Pinpoint - Smarty's free user conference - October 22nd and 23rdRegister now (opens in new tab)
Smarty's free user conferenceRegister now (opens in new tab)
Smarty

US Parcel Boundary Data attributes

he following attributes are included in US Parcel Boundary Data.

IDs & metadata attributes

Shape field identifierField IdentifierField nameDefinitionData type

smartykey

smartykey

SmartyKey®

Smarty's unique identifier for an address.

bigint

cnty_fips

county_fips

County FIPS

The 5-digit county FIPS (Federal Information Processing Standards) code. It is a combination of a 2-digit state FIPS code and a 3-digit county FIPS code.

varchar

par_num_fm

parcel_number_formatted

Parcel number formatted

The parcel ID or parcel number.

varchar

parcel_num

parcel_number

Parcel number

The parcel ID or parcel number with all non-A-Z and 0-9 characters removed.

varchar

par_num_st

parcel_number_state

Parcel number state

The statewide parcel ID number.

varchar

acc_num

account_number

Account number

The assessor or tax collector's account ID number for a property.

varchar

tax_id

tax_id

Tax ID

The assessor or tax collector's tax ID number for a property.

varchar

alt_parc_1

parcel_number_alternate_1

Parcel number alternate 1

A parcel ID number provided by the county that is not considered to be the primary parcel ID number used by the county. This could be previously used parcel ID numbers, or alternate ID numbers.

varchar

alt_parc_2

parcel_number_alternate_2

Parcel number alternate 2

A parcel ID number provided by the county that is not considered to be the primary parcel ID number used by the county. This could be previously used parcel ID numbers, or alternate ID numbers.

varchar

alt_parc_3

parcel_number_alternate_3

Parcel number alternate 3

A parcel ID number provided by the county that is not considered to be the primary parcel ID number used by the county. This could be previously used parcel ID numbers, or alternate ID numbers.

varchar

mail_smtky

mailing_smartykey

Mailing SmartyKey®

Smarty's unique identifier for a mailing address.

bigint

last_refsh

date_of_last_refresh

Date of last refresh

The date the county source data was most recently refreshed.

date

last_rev

date_of_last_revision

Date of last revision

The date of the county assessor's last revision.

date

time_updte

time_of_last_update

Time of last update

The timestamp of the most recent change of any kind to this row in the table (internal record changes and/or county updates). "date_of_last_refresh" should be used for the date of the parcel data.

timestamp with time zone

Address & location attributes

Shape field identifierField IdentifierField nameDefinitionData type

mail_dlv_1

mailing_delivery_line_1

Mailing delivery line 1

The parcel mailing address. This is where the tax and other assessor's communications are sent. Contains the first delivery line (usually the street address). This can include any of the following: mailing urbanization (Puerto Rico only), mailing primary number, mailing street predirection, mailing street name, mailing street suffix, mailing street postdirection, mailing secondary.

varchar

mail_dlv_2

mailing_delivery_line_2

Mailing delivery line 2

The second delivery line of the parcel mailing address (if needed). It is common for this field to remain empty.

varchar

mail_prim

mailing_primary_number

Mailing primary number

The house, PO Box, or building number of the parcel mailing address.

varchar

mail_pred

mailing_street_predirection

Mailing street predirection

Directional information before a parcel mailing address street name (N, SW, etc.).

varchar

mail_str

mailing_street_name

Mailing street name

The name of the parcel mailing address street.

varchar

mail_st_sf

mailing_street_suffix

Mailing street suffix

Abbreviated value describing the parcel mailing address street (St, Ave, Blvd, etc.).

varchar

mail_postd

mailing_street_postdirection

Mailing street postdirection

Directional information after a parcel mailing address street name (N, SW, etc.).

varchar

mail_scndy

mailing_secondary

Mailing secondary

Describes location within a complex/building (Ste, Apt, etc.) and its correlated unit number and/or letter (if any) of the parcel mailing address.

varchar

mail_city

mailing_city_name

Mailing city name

The parcel mailing address city name.

varchar

mail_state

mailing_state_abbreviation

Mailing state abbreviation

The two-letter state abbreviation of the parcel mailing address.

varchar

mail_zip

mailing_zipcode

Mailing ZIP Code

The parcel mailing address ZIP Code.

varchar

mail_cntry

mailing_country

Mailing country

The parcel mailing address country.

varchar

mail_urban

mailing_urbanization

Mailing urbanization

The neighborhood, or city subdivision of the parcel mailing address; used with Puerto Rican addresses.

varchar

dlv_line_1

delivery_line_1

Delivery line 1

The physical street address for the parcel - the address of the parcel itself. Not every parcel has a street address, especially in agricultural areas, or for larger parcels. Also called the "situs address" or "site address". Contains the first delivery line (usually the street address). This can include any of the following: urbanization (Puerto Rico only), primary number, street predirection, street name, street suffix, street postdirection, secondary.

varchar

dlv_line_2

delivery_line_2

Delivery line 2

The second delivery line of the parcel address (if needed). It is common for this field to remain empty.

varchar

prim_num

primary_number

Primary number

The house, PO Box, or building number of the parcel address.

varchar

pre_dir

street_predirection

Street predirection

Directional information before a parcel address street name (N, SW, etc.).

varchar

str_name

street_name

Street name

The name of the parcel address street.

varchar

str_sfx

street_suffix

Street suffix

Abbreviated value describing the parcel address street (St, Ave, Blvd, etc.).

varchar

post_dir

street_postdirection

Street postdirection

Directional information after a parcel address street name (N, SW, etc.)

varchar

secondary

secondary

Secondary

Describes location within a complex/building (Ste, Apt, etc.) and its correlated unit number and/or letter (if any) of the parcel address.

varchar

city_name

city_name

City name

The parcel address city name.

varchar

cnty_sbdvn

census_county_subdivision

Census county subdivision

The US Census County Subdivision. Used for organizational purposes. Refer to city_name for the city associated with the site address.

varchar

county

county

County

The parcel address county.

varchar

state

state_abbreviation

State abbreviation

The two-letter state abbreviation of the parcel address.

varchar

plus4_code

plus4_code

Plus4 Code

The 4-digit add-on code of the parcel address (more specific than 5-digit ZIP Code).

varchar

zipcode

zipcode

ZIP Code

The 5-digit ZIP Code of the parcel address.

varchar

site_urban

site_urbanization

Site urbanization

The neighborhood, or city subdivision of the parcel address; used with Puerto Rican addresses.

varchar

qual_op_zn

us_federal_qualified_opportunity_zone

US Federal Qualified Opportunity Zone

Indicates whether this parcel is in a US Federal Qualified Opportunity Zone.

varchar

elem_schl

elementary_school_district

Elementary school district

Elementary School District. Census defined "elementary" school districts provide education for children ages 5-17. If local authorities divide students by age, younger students fall under "elementary" school districts, while older students fall under "secondary" school districts.

varchar

sec_schl

secondary_school_district

Secondary school district

Secondary School District. Census defined "secondary" school districts provide education for children aged 5-17 that are determined to be above a specified age by local authorities.

varchar

unif_schl

unified_school_district

Unified school district

Unified School District. Census designated "unified" school districts provide education for all children ages 5-17.

varchar

Shape field identifierField IdentifierField nameDefinitionData type

use_code

use_code

Use code

The parcel use code.

varchar

use_desc

use_desc

Use description

The parcel use description.

varchar

zoning

zoning

Zoning

The governing municipality's zoning code.

varchar

zon_desc

zoning_desc

Zoning description

The governing municipality's zoning code description.

varchar

zon_type

zoning_type

Zoning type

A standardized zoning type.

varchar

zon_subtp

zoning_subtype

Zoning subtype

A standardized zoning subtype.

varchar

structure

structure

Structure

Indicates if there is a structure on the parcel.

varchar

num_struct

num_structures

Number structures

The number of structures on the parcel.

integer

parvaltype

parcel_value_type

Parcel value type

The parcel value type. This field describes the type or method used by the assessor to determine the parcel values listed in market_value and agricultural_value.

varchar

mkt_val

market_value

Market value

The total parcel value (in USD) from assessor's data.

double

agr_val

agricultural_value

Agricultural value

The agricultural value (in USD) from assessor's data.

double

hmstd_exem

homestead_exemption

Homestead exemption

A county-provided indicator that the parcel qualifies for homeowner or homestead tax exemptions.

varchar

unit_count

unit_count

Unit count

A count of all known addresses on the parcel.

integer

location_name

name

Name

The name associated with the parcel.

varchar

legal_desc

legal_description

Legal description

The legal description.

varchar

plat

plat

Plat

The plat number the parcel is recorded on.

varchar

book

book

Book

The book/liber the parcel is recorded in.

varchar

page

page

Page

The page/folio the parcel is recorded on.

varchar

block

block

Block

The parcel block.

varchar

lot

lot

Lot

The parcel lot.

varchar

nbhd_name

neighborhood_name

Neighborhood name

The neighborhood name.

varchar

nbhd_code

neighborhood_code

Neighborhood code

An alphanumeric neighborhood code.

varchar

subdvsn

subdivision

Subdivision

The subdivision of the parcel.

varchar

Land measures attributes

Shape field identifierField IdentifierField nameDefinitionData type

bldg_sqft

building_sqft

Building sqft

The assessor's recorded structure square footage.

integer

bldg_area

building_area

Building area

The total area (in square feet) of all of the structures on the property. This can include hallways, gyms, laundry rooms, mail rooms, pools, etc.

text

bldg_def

building_area_definition

Building area definition

Describes the area in the "building_area" field.

text

deed_acres

deed_acres

Deed acres

The acres listed as "deeded acres" by the county. Often different from the acreage calculated by GIS.

double

acres

acres

Acres

The acres value.

double

sqft

sqft

Sqft

The parcel square footage value.

double

acres_calc

acres_calculated

Acres calculated

The parcel acres value as calculated from county parcel geometry.

double

sqft_calc

sqft_calculated

Sqft calculated

The parcel square footage as calculated from supplied parcel geometry.

bigint

bldg_fp_sq

building_footprint_sqft

Building footprint sqft

The total building footprint (in square feet).

integer

num_bldgs

number_of_buildings_on_parcel

Number of buildings on parcel

The total number of buildings on the parcel.

integer

cdl_raw

cropland_data_layer_raw

Cropland Data Layer raw

An array of 2-member arrays with the Cropland Data Layer (CDL) values in position 1, and the percentage of the parcel area covered by that value in position 2. The term "value" is a USDA term for the numeric code that corresponds to a particular crop or land cover type.

varchar

cdl_m_cat

cropland_data_layer_majority_category

Cropland Data Layer majority category

The human-readable category for the majority CDL value.

varchar

cdl_m_perc

cropland_data_layer_majority_percent

Cropland Data Layer majority percent

The percentage of the parcel that the "cropland_data_layer_majority_category" covers.

double

cdl_date

cropland_data_layer_date

Cropland Data Layer date

The Cropland Data Layer (CDL) date, usually released annually in February for the previous year.

varchar

plss_twnsh

public_land_survey_system_township

Public Land Survey System township

The Public Land Survey System township the parcel is located in (based on the centroid of the parcel). Derived from Bureau of land management (BLM) designated polygons.

varchar

plss_sectn

public_land_survey_system_section

Public Land Survey System section

The Public Land Survey System section the parcel is located in (based on the centroid of the parcel). Derived from Bureau of land management (BLM) designated polygons.

varchar

plss_range

public_land_survey_system_range

Public Land Survey System range

The Public Land Survey System range the parcel is located in (based on the centroid of the parcel). Derived from Bureau of land management (BLM) designated polygons.

varchar

row_parcel

right_of_way

Right-of-way

Indicates a right-of-way parcel or similar function parcel.

varchar

dem_var

elevation_variability

Elevation variability

The amount of elevation variability within a parcel. Calculated per parcel from Digital Elevation Model (DEM).
0 = a level terrain surface
1 = a nearly level terrain surface
2 = a slightly rugged terrain surface
3 = an intermediately rugged terrain surface
4 = a moderately rugged terrain surface
5 = a highly rugged terrain surface
6 = an extremely rugged terrain surface.

double

hi_elev_m

highest_elevation

Highest elevation

The highest elevation value (in meters) within the parcel.

double

low_elev_m

lowest_elevation

Lowest elevation

The lowest elevation value (in meters) within the parcel.

double

parcel

Parcel

The geometry of the parcel boundary.

wkt, wkb, embedded

Market & environment attributes

Shape field identifierField IdentifierField nameDefinitionData type

usgs_padus

usgs_protected_areas_database_us

USGS Protected Areas Database US

United States Geological Survey Protected Areas Database of the United States Public Access designation.

varchar

lbcs_act

land_based_classification_standards_activity

Land-based classification standards activity

Numeric code indicating the use of land (farming, shopping, manufacturing, etc.).

double

lbcs_actde

land_based_classification_standards_activity_desc

Land-based classification standards activity description

Description of the Land-based classification standards (LBCS) activity numeric code.

varchar

lbcs_fun

land_based_classification_standards_function

Land-based classification standards function

Numeric code indicating the economic function or type of establishment (agricultural, commercial, industrial, etc.).

double

lbcs_funde

land_based_classification_standards_function_desc

Land-based classification standards function description

Description of the Land-based classification standards (LBCS) function numeric code.

varchar

lbcs_strct

land_based_classification_standards_structure

Land-based classification standards structure

Numeric code indicating the type of structure or building (single-family house, office building, warehouse, etc.).

double

lbcs_strde

land_based_classification_standards_structure_desc

Land-based classification standards structure description

Description of the Land-based classification standards (LBCS) structure numeric code.

varchar

lbcs_site

land_based_classification_standards_site

Land-based classification standards site

Numeric code indicating what is on the land (national monument, wilderness parks, national preserve, etc.).

double

lbcs_sitde

land_based_classification_standards_site_desc

Land-based classification standards site description

Description of the Land-based classification standards (LBCS) site’s numeric code.

varchar

lbcs_own

land_based_classification_standards_ownership

Land-based classification standards ownership

Numeric code indicating the ownership structure (federal government, state government, public restrictions, etc.).

double

lbcs_ownde

land_based_classification_standards_ownership_desc

Land-based classification standards ownership description

Description of the Land-based classification standards (LBCS) ownership numeric code.

varchar

hs_aff_ind

housing_affordability_index

Housing affordability index

The Housing Affordability Index (HAI), which measures the ability of a typical resident to purchase a home within the geographic area.

double

popden_mi2

population_density_per_sqmi

Population density per sqmi

An estimate of the population density (per square mile) in the geographic area.

double

popgrow_p5

population_growth_past_5_years

Population growth past five years

The population Compound Annual Growth Rate (CAGR) for the previous five-year period.

double

popgrow_n5

population_growth_next_5_years

Population growth next five years

The five-year forecast for population growth (Compound Annual Growth Rate).

double

hu_grow_p5

housing_units_growth_past_5_years

Housing units growth past five years

The housing units Compound Annual Growth Rate (CAGR) for the previous five-year period.

double

hu_grow_n5

housing_units_growth_next_5_years

Housing units growth next five years

The five-year forecast for the housing units (Compound Annual Growth Rate).

double

hi_grow_n5

median_household_income_growth_next_5_years

Median household income growth next five years

The five-year forecast for the median household income (Compound Annual Growth Rate).

double

m_hs_in_p1

median_household_income_past_1_year

Median household income past one year

An estimate of the median household income in the geographic area for the previous year.

double

tline_dist

distance_to_nearest_transmission_line

Distance to nearest transmission line

The distance (in meters) between the parcel boundary and the nearest relatively high voltage (69kv - 765kv) electric transmission line as available within the Homeland Infrastructure Foundation-Level Data (HIFLD) Transmission Line dataset.

double

This chat is powered by Help Scout. Chats are recorded. Privacy Policy