Property Attributes Assessment Data Schema - 23.1

spectrum-inline

Product type
Software
Portfolio
Enrich
Integrate
Locate
Verify
Product family
Spectrum
Product
Spectrum > Geo Addressing > Enterprise Tax
Spectrum > GeoEnrichment
Spectrum > Spectrum Platform
Spectrum > Spatial > Spectrum Spatial
Spectrum > Web Services
Spectrum > Data Integration
Spectrum > Quality > Context Graph
Spectrum > Discovery
Spectrum > Quality > Addressing
Spectrum > Quality > Spectrum Quality
Spectrum > Dataflow Designer
Version
23.1
Language
English
Product name
Precisely Spectrum
Title
spectrum-inline
First publish date
2007
Last updated
2023-06-02
Published on
2023-06-02T09:54:39.526000

Field Name Long Name Data Type (Length) Description
PAID Product ID VARCHAR (50) Unique ID for each record in the product
LINKID Link ID VARCHAR (50) ID to link Precisely Property Attributes products
PBKEY PreciselyID VARCHAR (50) Unique ID for an addressable location. Not always available.
PARENT Parent VARCHAR (50) For secondary (child) address records (e.g. units, apartments, or suites), the Precisely ID of the parent address. Only present when applicable.
PID Precisely Parcel Boundary Link ID VARCHAR (50) Link to parcel boundary dataset. Composed of state/county FIPS code and parcel APN.
OWNER (ASSESSEE) INFORMATION
FNAME Owner First Name VARCHAR (166) Property owner's first name
MNAME Owner Middle Name VARCHAR (166) Property owner's middle name
LNAME Owner Last Name VARCHAR (166) Property owner's last name. May contain suffix (Jr., Sr., I, II, etc.)
FNAME2 Owner2 First Name VARCHAR (166) First name of the second owner of the property
MNAME2 Owner2 Middle Name VARCHAR (166) Middle name of the second owner of the property
LNAME2 Owner2 Last Name VARCHAR (166) Last name of the second owner of the property. May contain suffix (Jr., Sr., I, II, etc.)
OWNTYPE Owner Type VARCHAR (1) Indicates whether the property is owned by an individual or individuals, a business or corporation, or a government entity. Possible values:
  • I - Individual
  • B - Business/corporation
Note: This field does not indicate the type of property (residential, vacant, etc.)
BUSNAME Business Name VARCHAR (255) Name of business if property is owned commercially
OWNVEST_CD Owner Vesting Code VARCHAR (5) Code indicating ownership terms. Identifies how the assessee took title (vesting) or describing the type of entity (by ID) based on conversion. Refer to the Field Value Key tab of Property Attributes Assessment Product Data Schema.xlsx for more information. Present when available.
TAX BILL (OWNER MAILING) ADDRESS INFORMATION
TAX_ADDR Tax Bill First Line Address VARCHAR (80) Formatted first line of the address to which the tax bill is sent
TAX_ADD_NUMBER Tax Bill House Number VARCHAR (13) House number
TAX_PREDIR Tax Bill Street Pre-directional VARCHAR (2) Street directional prefix (N, S, E, W, etc.)
TAX_STREETNAME Tax Bill Street Name VARCHAR (60) Street name. May also be a post office (PO) box number, rural route (RR) number, or highway contract (HC) box number.
TAX_STRTYPE Tax Bill Street Type VARCHAR (40) Street suffix (ST, AVE, PL, BLVD, etc.)
TAX_POSTDIR Tax Bill Street Post-directional VARCHAR (2) Street directional extension (N, S, E, W, etc.)
TAX_UNIT_DES Tax Bill Unit Type VARCHAR (4) Unit designator (apt, unit, etc.)
TAX_UNIT_NUM Tax Bill Unit Number VARCHAR (15) Unit number
TAX_CITY Tax Bill City VARCHAR (30) City name
TAX_STATE Tax Bill State VARCHAR (2) State abbreviation
TAX_ZIPCODE Tax Bill Zip VARCHAR (7) ZIP Code
TAX_PLUS4 Tax Bill Plus4 Zip VARCHAR (4) ZIP+4 extension
PROPERTY (SITUS) ADDRESS INFORMATION
ADDRESS Property First Line Address VARCHAR (80) Formatted first line of the property's physical address
ADD_NUMBER Property House Number VARCHAR (13) House number
PREDIR Property Street Pre-directional VARCHAR (2) Street directional prefix (N, S, E, W, etc.)
STREETNAME Property Street Name VARCHAR (60) Street name
STRTYPE Property Street Type VARCHAR (15) Street suffix (ST, AVE, PL, BLVD, etc.)
POSTDIR Property Street Post-directional VARCHAR (2) Street directional extension (N, S, E, W, etc.)
UNIT_DES Property Unit Type VARCHAR (4) Unit designator (apt, unit, etc.)
UNIT_NUM Property Unit Number VARCHAR (15) Unit number
CITY Property City VARCHAR (30) City name
STATE Property State VARCHAR (2) State abbreviation
ZIPCODE Property Zip VARCHAR (5) ZIP Code
PLUS4 Property Plus4 Zip VARCHAR (4) ZIP+4 extension
VACANT Property USPS Vacancy VARCHAR (1) Indicates whether the physical address has been determined to be vacant by the USPS:
  • Y -Vacant
  • N - Not vacant
  • U - Unknown
PROP_CAT Property Category VARCHAR (1) Property type classification derived from standardized land use code:
  • R – Residential
  • C – Commercial
  • V - Vacant
  • X – Other
PROP_ABS_OWN_CD Absentee Owner Code VARCHAR (1) Absentee owner indicator code:
  • A - Absentee
  • B - Probable owner-occupied property
  • O - Owner-occupied
PHYSICAL PROPERTY INFORMATION
PROP_APN Property APN VARCHAR (45) Formatted assessor's parcel number (APN) or parcel identification number - an identifier assigned by the assessing agency to simplify the identification of parcels. APN formatting and composition vary by agency, but the APN is usually composed of map-book, page, and parcel numbers. Some jurisdictions use section-township-range values as part of the APN.
OLD_APN Old APN VARCHAR (31) APN used previously to identify the property, or an alternate APN, if available. Since this field provides a way to tie parcel information back to old APNs, the old APN will supersede an alternate APN. This field is populated for a period of no more than five years from the time an assessing agency changes its parcel numbering system.
ALT_OLD_APN_IND Alt/Old APN Indicator VARCHAR (20) Indicates whether the value in OLD_APN is an old or alternate APN.

1 - Alternate APN

2 - Old APN

3 - Parent

4 - Subdivision-Split

When an APN described one parcel in the previous year and that parcel has since been split into multiple parcels, the parcels in the current edition of the product with the single parcel number from the previous year and this field will be populated with a value of Subdivision-Split.

PROP_APNSEQNBR Property APN Sequence Number VARCHAR (3) Sequence number assigned to ensure the uniqueness of each APN. Parcels with the same APN can have different owners, addresses, or land use. A sequence number (e.g., 10132021A seq 001) is added to differentiate parcels having the same APN.
FIPSCD FIPS Code VARCHAR (5) Combination of state FIPS code (first two digits) and county FIPS code (last 3 digits)
PROP_CENSUSTRACT Census Tract VARCHAR (16) Combination of Census Tract, Census Block, and Census Block Suffix codes
PROP_ZONING Zoning Code VARCHAR (25) County or local zoning code
PROP_ST_LANDUSE Standardized Land Use Code VARCHAR (4) Standardized land use code. Refer to Field Value Key tab of Property Attributes Assessment Data Schema worksheet for more information. Note: A code of 1999 is based on the following criteria:
  • Land use in the source file is generally indicated as residential. Some jurisdictions may classify residential lots as residential properties.
  • Improvement value is greater than zero.
  • The property is owner-occupied or contains a homeowner exemption.
  • If there is no land use designation, BEDROOM and BATH fields are populated.
PROP_LU_DESC County Land-Use Description VARCHAR (45) Land use description taken directly from the source file, edited to include user-friendly terminology without the loss of any regional or local references.
PROP_LU_CODE County Land-Use Code VARCHAR (8) This field contains the land use code used by the county for land use classification. These codes are usually numeric, but sometimes they are alphanumeric.
LAT Latitude FLOAT Parcel Latitude (DECIMAL value)
LON Longitude FLOAT Parcel Longitude (DECIMAL value)
LOC_CODE Location Code VARCHAR (4) Location match code from Precisely Spectrum Geocoding.
PROPERTY LEGAL DESCRIPTION
LEGAL_MAPREF Legal: Assessor's Map Ref VARCHAR (15) Map number assigned by assessing agency. May or may not match APN or legal map references.
LEGAL_ASSDESC Legal: Assessor Description VARCHAR (125) Narrative property description exactly as it appears in source file
LEGAL_BRIEFDESC Legal: Full Brief Description VARCHAR (400) Compilation of all legal description components
LEGAL_LOT Legal: Lot Code VARCHAR (2) Identifies properties that include more than one lot or partial lots:
  • M - More than one lot
  • MP - Multiple lots with a portion of one or more lots
  • P - Portion of a lot
LEGAL_LOTNUM Legal: Lot Number VARCHAR (7) Lot numbers of the individual lot(s) comprising the property or the actual lot number(s) of a tract or subdivision. If the property is made up of multiple lots, field will contain as many numbers as allowed by field length, separated by either commas ( , ) or ampersands ( & ). Refer to LEGAL_LOT field above.
LEGAL_LNDLOT Legal: Land Lot VARCHAR (10) Tract or portion of land in which the property is located. May encompass multiple individual lots or blocks.
LEGAL_TCTNUM Legal: Tract Number VARCHAR (10) The number of the tract in which the property is located
LEGAL_BLK Legal: Block VARCHAR (7) The block of the subdivision or city in which the property is located
LEGAL_SEC Legal: Section VARCHAR (7) Section of the city in which the property is located. Note: Not the same as Section in Section-Township-Range (see LEGAL_SECTWPRANMER field).
LEGAL_DIS Legal: District VARCHAR (12) District in which the property is located. Usually a numeric code corresponding to the literal name in LEGAL_TWPMUNI field.
LEGAL_UNIT Legal: Unit VARCHAR (6) Subdivision unit number, common for condominiums, townhomes, etc. Not necessarily the same as UNIT_NUM.
LEGAL_PHASE Legal: Phase Number VARCHAR (7) Phase number of a subdivision or tract development
LEGAL_SUB Legal: Subdivision Name VARCHAR (40) The name of the subdivision, plat, or tract in which the property is located
LEGAL_TWPMUNI Legal: City, Township, Municipality VARCHAR (30) Jurisdiction in which the property is located. Value may be Unincorporated if applicable. Provides a description of the code found in the LEGAL_DIS field. Not necessarily the same as CITY value.
LEGAL_SECTWPRANMER Legal: Section/Township/ Range/Meridian VARCHAR (30) Value format: SEC ## TWN ##D RNGD, where D is a directional (N/S for TWN and E/W for RNG)
PROPERTY CHARACTERISTIC ATTRIBUTES
PROP_ACRES Property Acres FLOAT Total land area in acres
PROP_SQFT Property Square Footage FLOAT Total land area in square feet
PROP_FRONTFT Property Frontage Footage FLOAT Frontage - length of the street-facing portion of the property, in feet. Populated when provided by the jurisdiction.
PROP_DEPTHFT Property Depth Footage FLOAT Length between the front and back of the property, in feet. Populated when provided by the jurisdiction.
BLDG_VIEW Building View VARCHAR (3) Code indicating view from building. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
PROP_INFL Site Influence VARCHAR (3) Code(s) identifying features or location characteristics that might influence the value or desirability of a parcel (e.g. waterfront location, traffic patterns, etc.). This field can contain up to two values. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BLDG_YRBLD Year Built VARCHAR (4) Year the primary structure on the property was built
BLDG_EFFYRBLD Effective Year Built VARCHAR (4) The first year in which the building was assessed with its current components. If, for example, a building was constructed in 1960 and added to in 1974, BLDG_YRBLD would be 1960 and BLDG_EFFYRBLD would be 1974.
BLDG_NAME Condo Project or Building Name VARCHAR (20) Building or complex name
BLDG_COUNT Building Count INT Total number of buildings or structures on a single parcel, as reported in assessment roll. Note: When a multi-record condition exists, this field will reflect the number of improvement records in the source file.
BLDG_SQFT Main Building Square Footage INT Area of the primary structure on the property. When multiple building areas for a structure are provided, the preferred value of this field is living area for residential structures and total area for all other structures.
BLDG_SQFT_CODE Main Building Square Footage Code VARCHAR (2) Code indicating the source used to populate the BLDG_SQFT field. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BLDG_STYLE Building Style VARCHAR (3) Type of building style (e.g., Colonial, Cape Code, Bungalow). Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BLDG_STORIES Building Stories Count VARCHAR(10) Actual number of stories in structure or code indicating number of stories (refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.). Note: A number followed by a plus sign ( + ) indicates either a fractional story less than 1/2 (i.e., 2+) or an attic/basement combination (2+AB).
BLDG_UNITNBR Building Unit Number VARCHAR (10) Number of units reported in the assessment roll. Primarily used for apartment buildings.
BLDG_QLTY Building Quality VARCHAR (2) Building quality code. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BLDG_TYPE Building Type VARCHAR (3) Primary building type code. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook..
BLDG_IMPCD Building Improvement Type VARCHAR (3) Primary improvement type code. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BLDG_MOBHOME Mobile Home VARCHAR (1) Indicates whether the property is a mobile home:
  • Y - Yes
  • N - No
BLDG_COND Building Condition VARCHAR (3) Code indicating the physical condition of the building. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BLDG_CNSTR Building Construction VARCHAR (3) Code indicating primary construction method. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BLDG_EXTNW Exterior Walls VARCHAR (3) Code indicating type or finish of exterior walls. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
ROOF_FRAME Roofing Frame Type VARCHAR (3) Code indicating type of roof framing used in structure. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
ROOF_COVER Roof Cover VARCHAR (3) Code indicating type of roof covering used on the primary improvement on the property. Note: This information is not always available in the source file. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
ROOF_SHAPE Roof Shape VARCHAR (2) Code indicating architectural style of roof. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
LIVINGSQFT Living Area INT Area of a building that is used for general habitation. This is typically the area of a building that is heated or air conditioned and does not include garage, porch or basement square footage.
GROSSSQFT Gross Area INT Square footage for the entire building
ADJGROSSSQFT Gross Adjusted Area INT Square footage used by the local assessing authority to determine improvement value. This figure is typically 100 percent of the living area, plus lower percentage of non-living area.
BLDG_AREA1 Building Area 1 INT Area of building features (e.g. garage, porch, basement)
BLDG_AREAIND1 Building Area 1 Indicator VARCHAR (2) Two-character code describing feature area. Single character can be combined with F for finished or U for unfinished. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BLDG_AREA2 Building Area 2 INT Area of building features (e.g. garage, porch, basement)
BLDG_AREAIND2 Building Area 2 Indicator VARCHAR (2) Two-character code describing feature area. Single character can be combined with F for finished or U for unfinished. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BLDG_AREA3 Building Area 3 INT Area of building features (e.g. garage, porch, basement)
BLDG_AREAIND3 Building Area 3 Indicator VARCHAR (2) Two-character code describing feature area. Single character can be combined with F for finished or U for unfinished. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BLDG_AREA4 Building Area 4 INT Area of building features (e.g. garage, porch, basement)
BLDG_AREAIND4 Building Area 4 Indicator VARCHAR (2) Two-character code describing feature area. Single character can be combined with F for finished or U for unfinished. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BLDG_AREA5 Building Area 5 INT Area of building features (e.g. garage, porch, basement)
BLDG_AREAIND5 Building Area 5 Indicator VARCHAR (2) Two-character code describing feature area. Single character can be combined with F for finished or U for unfinished. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BLDG_AREA6 Building Area 6 INT Area of building features (e.g. garage, porch, basement)
BLDG_AREAIND6 Building Area 6 Indicator VARCHAR (2) Two-character code describing feature area. Single character can be combined with F for finished or U for unfinished. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BLDG_AREA7 Building Area 7 INT Area of building features (e.g. garage, porch, basement)
BLDG_AREAIND7 Building Area 7 Indicator VARCHAR (2) Two-character code describing feature area. Single character can be combined with F for finished or U for unfinished. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BSMT_TYPE Basement Type VARCHAR (3) Code indicating type of basement. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BSMTSQFT Basement Square Footage INT Total square footage of basement, including finished and unfinished areas
BLDG_FND Foundation Type VARCHAR (3) Code indicating type of foundation. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BLDG_CLASS Building Class VARCHAR (1) Fire insurance building classification code used for commercial/industrial buildings. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
INT_WALL Interior Walls VARCHAR (1) Code indicating composition of Interior walls. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
FLOOR_TYPE Flooring Type VARCHAR (3) Code indicating type of floor construction. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
ROOM_CT Total Room Count INT Total number of rooms in the primary building
BEDRM_CT Bedroom Count INT Total number of bedrooms (with closets) in the primary building
ROOM_OTHER Other Rooms VARCHAR (5) Code(s) describing rooms in the house or main building, if provided by assessing jurisdiction. Up to 5 codes may be present per parcel. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BATH_CT Number of Baths FLOAT Number of bathrooms, including partial baths
BATHPAR_CT Number of Partial Baths INT If the assessing agency provides separate fields for full and partial baths, the number of full baths will be listed in the BATH_CT field and the number of partial baths in this field.
BATHFIX_CT Count of Bath Fixtures INT Total number of bathroom fixtures - sinks, toilets, bathtubs, and shower heads
PLUMBFIX_CT Count of Plumbing Fixtures VARCHAR (3) Number of plumbing features in the primary building or improvement as reported by the assessing agency
COOL_TYPE Cooling Type VARCHAR (3) Code indicating the type of air conditioning used in the building. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
PROP_FRPL Fireplace VARCHAR (1) Actual number of fireplaces. Value of Y indicates only that a fireplace or fireplaces is/are present.
PROP_FRPLTYPE Fireplace Type VARCHAR (3) Code indicating the type of fireplace(s) in the building. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
PROP_GAR Garage Type VARCHAR (3) Code indicating type of garage or carport. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
PRKG_SQFT Parking Square Footage INT Total square footage of primary garage or parking area, including both finished and unfinished areas.
PRKG_SPACES Parking Capacity INT Total number of parking spaces or car capacity of the garage or parking area
POOL Pool VARCHAR (1) Indicates if pool is present
POOL_TYPE Pool Type VARCHAR (3) Code indicating type of pool construction and amenities. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
HEAT_TYPE Heating Type VARCHAR (3) Code indicating type of heating system. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
ENERGY_TYPE Energy Type VARCHAR (3) Code indicating type of electrical service in building. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
FUEL_TYPE Fuel Type VARCHAR (3) Code indicating type of heating fuel used. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
SEWER_TYPE Sewer Type VARCHAR (20)

Type of waste disposal/sewage system:

1 - None

2 - Public

3 - Cesspool

4 - Septic

5 - Private

6 - Storm

7 - Commercial

8 - Yes

WATER_TYPE Water Type VARCHAR (20) Water system type:
  • None
  • Cistern
  • Commercial
  • Private
  • Public
  • Public Well
  • Spring-Creek
  • Well
  • Yes
ELEVATOR Elevator VARCHAR (1) Indicates presence or number of elevators
AMENITIES Amenities VARCHAR (5) Identifies the extra selling features that add to the value of property, such as a tennis court or golf course. This data is provided by the jurisdiction, but typically does not indicate the size of the amenity. This field can contain up to five codes. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
BLDG_OTHER1 Other Improvement Building Indicator 1 VARCHAR (2) Code describing buildings not attached to the main building or house, and other improvements. Refer to Field Value Key 'Other Impr Building Indicator 1-5' for codes. When provided by the jurisdiction, size or area of buildings/improvements is listed in BLDG_OTHER1_AREA#
BLDG_OTHER1_AREA Other Improvement Building Area 1 VARCHAR (9) Area or measurement of buildings/improvements described in BLDG_OTHER#
BLDG_OTHER2 Other Improvement Building Indicator 2 VARCHAR (2) See description for Other Improvement Building Indicator 1
BLDG_OTHER2_AREA Other Improvement Building Area 2 VARCHAR (9) Area or measurement of buildings/improvements described in BLDG_OTHER#
BLDG_OTHER3 Other Improvement Building Indicator 3 VARCHAR (2) See description for Other Improvement Building Indicator 1
BLDG_OTHER3_AREA Other Improvement Building Area 3 VARCHAR (9) Area or measurement of buildings/improvements described in BLDG_OTHER#
BLDG_OTHER4 Other Improvement Building Indicator 4 VARCHAR (2) See description for Other Improvement Building Indicator 1
BLDG_OTHER4_AREA Other Improvement Building Area 4 VARCHAR (9) Area or measurement of buildings/improvements described in BLDG_OTHER#
BLDG_OTHER5 Other Improvement Building Indicator 5 VARCHAR (2) See description for Other Improvement Building Indicator 1
BLDG_OTHER5_AREA Other Improvement Building Area 5 VARCHAR (9) Area or measurement of buildings/improvements described in BLDG_OTHER#
EXT_FEAT1 Extra Features 1 Indicator VARCHAR (2) Code identifying an exterior feature that potentially adds value to the property but is not a building or attribute described in the BLDG_OTHER# fields. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook. Note: It is possible for this field to be populated without the associated EXT_FEAT#_AREA having a value.
EXT_FEAT1_AREA Extra Features 1 Area VARCHAR (9) Area of extra feature expressed in square feet and/or actual dimensions. Note: It is not necessary for this field to be populated when the corresponding EXT_FEAT# field is populated.
EXT_FEAT2 Extra Features 2 Indicator VARCHAR (2) See description for Extra Features 1-4 Indicator
EXT_FEAT2_AREA Extra Features 2 Area VARCHAR (9) Area of extra feature expressed in square feet and/or actual dimensions. Note: It is not necessary for this field to be populated when the corresponding EXT_FEAT# field is populated.
EXT_FEAT3 Extra Features 3 Indicator VARCHAR (2) See description for Extra Features 1-4 Indicator
EXT_FEAT3_AREA Extra Features 3 Area VARCHAR (9) Area of extra feature expressed in square feet and/or actual dimensions. Note: It is not necessary for this field to be populated when the corresponding EXT_FEAT# field is populated.
EXT_FEAT4 Extra Features 4 Indicator VARCHAR (2) See description for Extra Features 1-4 Indicator
EXT_FEAT4_AREA Extra Features 4 Area VARCHAR (9) Area of extra feature expressed in square feet and/or actual dimensions. Note: It is not necessary for this field to be populated when the corresponding EXT_FEAT# field is populated.
PROP_LASTUPDATE Record Last Update VARCHAR (8) Date on which property information was last updated
PROPERTY TAX ASSESSMENT INFORMATION
TAX_ACCT_NUM Tax Account Number VARCHAR (30) Arbitrary parcel identifier, assigned by the assessing agency for tax purposes. Present when provided in assessment file.
TAPE_CUT_DATE Assessment Source File Date ("Tape Cut") VARCHAR (10) Date (YYYYMMDD format) on which the assessment file was generated or on which it was received by the vendor
REC_DATE Recording Date from Assessment VARCHAR (8) Date (YYYYMMDD format) of the most recent sale as listed in assessment records, if available, otherwise the date on which the property was sold to the current owner
DOC_TYPE Document Type from Assessment VARCHAR (25) Code describing the type of document listed in tax/assessment records as being used to transfer the property during the most recent sale (if available). Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
SALE_AMT Sales Price from Assessment BIGINT Most recent sale price of the parcel (if available), expressed in whole dollars. Availability varies by jurisdiction.
SALE_CD Sales Price Code from Assessment VARCHAR (2) Sales price code. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
REC_BK_NUM Recorder's Book Number from Assessment VARCHAR (10) If available, the book or folio number assigned to the most recent sale by the assessing jurisdiction. Used for identification purposes and to establish the order in which the sale was recorded.
REC_PG_NUM Recorder's Page Number from Assessment VARCHAR (10) If available, the page number assigned to the most recent sale by the assessing jurisdiction. Used for identification purposes and to establish the order in which the sale was recorded.
REC_DOC_NUM Recorder's Document Number from Assessment VARCHAR (20) Sequential number assigned to property transfer documents at the time of sale.
PRIOR_SALE_REC_DATE Prior Sale Date VARCHAR (8) If available, date of sale (YYYYMMDD format) to previous owner, as recorded in assessment records
PRIOR_SALE_DOC_TYPE Prior Sale - Document Type Code VARCHAR (2) Sale price code for previous transfer. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
PRIOR_SALE_AMT Prior Sales Price BIGINT If available, sale price of previous transfer as listed in assessment records
PRIOR_SALE_CD Prior Sales Price Code VARCHAR (2) Price code for previous sale price. Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
PRIOR_SALE_BK_NUM Prior Sale - Book Number VARCHAR (10) If available, the book or folio number assigned to the previous sale by the assessing jurisdiction. Used for identification purposes and to establish the order in which the sale was recorded.
PRIOR_SALE_PG_NUM Prior Sale - Page Number VARCHAR (10) If available, the page number assigned to the previous sale by the assessing jurisdiction. Used for identification purposes and to establish the order in which the sale was recorded.
PRIOR_SALE_DOC_NUM Prior Sale - Document Number VARCHAR (20) Sequential number assigned to property transfer documents at the time of previous transfer.
TAX_AMT Tax Amount DECIMAL(11,2) The amount of property tax for which the taxpayer was billed for the tax year, expressed in dollars and cents.
Note:
  • In some states, tax amounts are not available at the time that tax rolls are certified. Decisions to wait for tax amounts are made on a county-by-county basis.
  • In cases where gross and net tax amounts are provided, net tax takes precedence over gross tax.
TAX_YR Tax Year VARCHAR (4) Year in which the amount in TAX_AMT field was levied.
TAX_DEL_YR Tax Delinquent Year VARCHAR (4) Year in which any unpaid property taxes became delinquent
ASSESS_YR Assessment Year VARCHAR (4) Year for which values in Assessed Value fields (below) are calculated. If a fiscal year (e.g. 2020-2021), only the starting year of the range is listed.
ASSED_VAL Total Assessed Value BIGINT The total assessed value of the property's land and improvement values as provided by the county or local tax/assessment authority.
ASSED_LANDVAL Land Assessed Value BIGINT The assessed land values as provided by the county or local tax/assessment authority.
ASSED_IMPVAL Improve Assessed Value BIGINT The assessed improvement values as provided by the county or local tax/assessment authority.
MRKETVAL_YR Market Value Year VARCHAR (4) The year the Market Values fields were established. Normally, this is a constant year for all records with a market value > zero, although there are cases where the county file contains the year each parcel was physically appraised and in such cases we move the Market Value year specific to each parcel resulting in several different values per county.
MRKTVAL_TOTAL Total Market Value BIGINT Total market value of the property's land and improvement values as provided by the county or local tax/assessment authority.
MRKTVAL_LAND Land Market Value BIGINT Market land values as provided by the county or local tax/assessment authority.
MRKTVAL_IMP Improve Market Value BIGINT Market improvement values as provided by the county or local tax/assessment authority.
APPRAISED_VAL Total Appraised Value BIGINT Total appraised value of land and improvements, as provided by the county or local tax/assessment authority.
APPRAISED_VAL_LAND Land Appraised Value BIGINT The appraised land values as provided by the county or local tax/assessment authority.
APPRAISED_VAL_IMP Improve Appraised Value BIGINT The appraised improvement values as provided by the county or local tax/assessment authority.
REPLACE_CALC Replacement Cost BIGINT Replacement cost as calculated for insurance purposes.
TAX_EXEMPT_CODE Tax Exemption Codes VARCHAR (4) Property tax exemption code(s) (maximum 4). Refer to Field Value Key tab of the Property Attributes Assessment data schema workbook.
CA_EXEMPT California Homeowner's Exemption VARCHAR (1) Indicates if a California homeowner's exemption applies to the property. Note: This is not the same as a homestead tax exemption.
TAXRATE_CODE Tax Rate Code Area VARCHAR (18) Represents separate tax jurisdictions within the county as provided on the county tax/assessment roll.
CHANGE_TYPE Change Type CHAR (1) Change type:

A – Added

D – Deleted

U – Updated

Note: The Change_Type field is only available in Change Log files.