SmartFabric EFS Schema Notes

Print
Dark
Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

The Assessment layer does not contain every variable found in the standard data model.

Certain variables have been removed from the schema to ensure optimal performance when querying and streaming large volumes of Assessment data. This tables below list all variables found in SmartFabric EFS as of October 2024.

Future versions of SmartFabric EFS may include some amount of these variables.

Note:
This is the variable list; variable descriptions can be found in the SmartFabric schema documents.

Expand the tables below to view more.

Click on a category below to expand.

Parcels with Assessments

ID	Field Names	Description
1	PARCEL_LID	A proprietary LightBox identifier for parcel that is unique and persistent.
2	ASSESSMENT_LID	A proprietary LightBox identifier for assessment record that is unique and persistent.
3	FIPS_CODE	Federal Information Processing Code for the State + Federal Information Processing Code for the County. The first two digits are the state FIPs code. The last three digits are the county FIPs code.
4	PARCEL_APN	Master Parcel APN. This is the master/main APN number associated with the primary parcel in a location where multiple parcels with identical geometry exist. This can occur where there are multiple taxable properties in a location (condos, timeshares, mobile home parks)
5	AGGR_ACREAGE	Sum of lot acreage owned by the same ownership entity, within a single county extent. (see AGGR_GROUP for more detail on how ownership is identified)
6	AGGR_GROUP	ID indicating the grouping (ownership) of parcels for a single owner. Ownership identified by proprietary model that leverages both owner name and owner address. Parcels are identified within 300ft of adjacency, within a single county extent.
7	AGGR_LOT_WIDTH_MEDIAN	Median lot width of all parcels within the aggregated owner group (AGGR_GROUP).
8	AGGR_LOT_COUNT	Number of parcels owned by the same ownership entity, within a single county extent. (see AGGR_GROUP for more detail on how ownership is identified)
9	ASSOCIATED_ASSESSMENT_COUNT	Number of properties associated with a parcel.
10	UNIQUE_PARCEL_APN	Unique parcel APN derived from the parcel geometry. (note: may differ from unique apn derived from the tax assessor)
11	COUNTY	County Name
12	TAXAPN	Property APN/ID as inventoried by the tax assessor. Excludes APN sequence number (DUPE_TAXAPN_SEQ) EX: 07-08-34.001
13	ALTERNATE_TAXAPN	Deprecated or historical parcel number as inventoried by the tax assessor.
14	ALTERNATE_TAXAPN_INDICATOR	A code indicating if the APN is a deprecated or historical parcel number as inventoried by the tax assessor. Refer to the field ALTERNATE_TAXAPN_INDICATOR_DESC for the corresponding description.
15	ALTERNATE_TAXAPN_INDICATOR_DESC	Description for the ALTERNATE_TAXAPN_INDICATOR field.
16	SITE_ADDR	Address where the physical property is located. Comprised of all site address components excluding city, Zip code and zip + 4 code. (e.g. 125 Main St E Unit # 5)
17	SITE_CITY	Property city name returned from corrected address process (EX "Anytown" in 123 main street unit A Anytown CA")
18	SITE_STATE	Property state returned from corrected address process (EX "CA" in 123 main street unit A Anytown CA")
19	SITE_ZIP	Property zip code returned from corrected address process (EX "92120" in 123 main street unit A Anytown CA 92120 ")
20	SITE_PLUS_4	4 digit "plus 4 code" or "add on code" where the physical property resides used by the US Postal service to identify a geographic segment within a 5 digit postal ZIP code. (e.g. 5437)
21	CENSUS_TRACT	Small, relatively permanent statistical subdivisions of a county or equivalent entity that are updated by local participants prior to each decennial census as part of the Census Bureau's Participant Statistical Areas Program
22	CENSUS_BLOCK_GROUP	Block Group: Geographical unit used by the United States Census Bureau which is between the Census Tract and the Census Block.
23	CENSUS_BLOCK	The Census block of the subdivision or city in which the property is located.
24	CBSA_CODE	Code indicating Core Based Statistical Area from spatial overlay.
25	MUNICIPALITY	The Jurisdiction In Which The Property Is Located.
26	MSA_CODE	The Metropolitan Statistical Area code. Refer to MSA_CODE_DESC for the corresponding description.
27	MSA_CODE_DESC	Description of MSA_CODE.
28	OWNER_OCCUPIED	Indicates if the property is occupied by the owner (Y/N)
29	OWNER_NAME	Owner full name provided as reported by the local taxing/assessment authority at the time of the tax roll release. Contains multiple owners if present.
30	OWNER_NAME_1	Current First Owner full name (first middle last)
31	OWNER_NAME_2	Owner 2 full name (first middle last) provided by the local taxing/assessment authority
32	OWNERSHIP_STATUS_CODE	Ownership status code for the last sale of a property. See Ownership_Status_Desc
33	OWNERSHIP_STATUS_DESC	Description of the OWNERSHIP_STATUS_CODE field.
34	COMPANY_FLAG	Flag indicating if property is occupied by a company
35	MAIL_CITY	City portion of the owner mailing address. (e.g. CHICAGO, ATLANTA, DENVER).
36	MAIL_STATE	Two letter state code of the owner mailing address .(e.g. CA, NV WA)
37	MAIL_ZIP	Postal Code portion of the current owner mailing address. (e.g. 92675)
38	MAIL_PLUS_4	4 digit "plus 4 code" or "add on code" of the current owner mailing address. Used by the US Postal service to identify a geographic segment within a 5 digit postal ZIP code. (e.g. 5437)
39	MAIL_ADDR	Current Owner Mailing Street Address. Comprised of Street name, Street Directional Prefix, Street Number, Street Suffix, Unit type and Unit number. EX: "125 Main Street S Unit 5"
40	USE_CODE_MUNI	Local/Municipal Use Code of a property. Refer to USE_CODE_MUNI_DESC field for the corresponding description.
41	USE_CODE_MUNI_DESC	Description of the USE_CODE_MUNI field
42	USE_CODE_STD_LPS	Standardized Land Use Code normalized across all counties. Indicates the use of a property.
43	USE_CODE_STD_DESC_LPS	Description of the Standardized Land Use Code.
44	USE_CODE_STD_CTGR_DESC_LPS	Description of the Standardized Land Use Category Code.
45	USE_CODE_STD_CTGR_LPS	Standardized land Use Category Code.
46	STATE_LAND_USE_CODE	The land use code used by the state for land use classification. This field is only populated if this code differs from county land use code. Refer to the STATE_LAND_USE_CODE_DESC field for the corresponding description.
47	STATE_LAND_USE_CODE_DESC	Description for STATE_LAND_USE_CODE field.
48	LOT_WIDTH	The linear feet across the front of the lot, often the side of the property facing the street.
49	LOT_DEPTH	The linear feet between the front and back of the lot.
50	ACREAGE	The size of the property, in acres. Derived from the assessment record when possible, otherwise calculated from associated parcel geometry.
51	LAND_SQFT	The size of the property, in square feet Derived from the assessment record when possible, otherwise calculated from associated parcel geometry.
52	ASSR_ACREAGE	Assessed acreage of the property as reported by the assessor.
53	ASSR_SQFT	Lot size square feet as reported by the assessor.
54	CAL_ACREAGE	Calculated acreage derived from the associated parcel geometry
55	CAL_SQFT	Calculated square feet derived from the associated parcel geometry
56	LOT_SIZE_AREA	The total area of the land from the assessor. Units for area are in LOT_SIZE_AREA_UNIT field.
57	LOT_SIZE_AREA_UNIT	Units of measurement referenced used Lot Size Area
58	LOT_SIZE_AREA_ORGN	The Total Square Footage Of The Land.
59	TOPOGRAPHY	Contains code representing the physical (including man-made) or natural features of the land.
60	TOPOGRAPHY_DESC	Description of the TOPOGRAPHY field.
61	AVM_VALUE	Property value determined by an Automated Valuation Model. Often based on comparable properties at a specific point in time.
62	VAL_ASSD	The Total Assessed Value of both Land & Improvement values (before exemptions, if any) for the property as provided by the county or local taxing/assessment authority.
63	VAL_ASSD_LAND	The Assessed Land Value (before exemptions, if any) as provided by the county or local taxing/assessment authority.
64	VAL_ASSD_IMPRV	The Assessed Improvement Values (before exemptions, if any) as provided by the county or local taxing/assessment authority
65	VAL_MARKET	Total Market value as determined by the county or local taxing/assessment authority
66	DATE_CERT	The date that the file was certified by the county in the format YYYYMMDD.
67	VAL_MRKT_LAND	Market value of the land as provided by the county or local taxing/assessment authority
68	VAL_MRKT_IMPRV	Market value of improvements as provided by the county or local taxing/assessment authority
69	YR_MRKT_VAL	Year that market values were established.
70	DATE_ASSR_TAPE_CUT	Date the county assessor or tax collector generated the tax roll data.
71	BLOCK_NUMBER	The block number in which the property is located as indicated in legal reporting.
72	LOT_NUMBER	The individual lot(s) which comprise the property. The actual lot number(s) such as in a tract or subdivision as indicated in legal reporting.
73	SUBDIVISION	The name of the subdivision, plat, or tract in which the property is located as indicated in legal reporting.
74	TRACT_NUMBER	The number of the tract in which the property is located as indicated in legal reporting.
75	LEGAL_1	Narrative legal description of the property as documented by the assessor
76	LOT_CODE	Identifies Properties Which Include More Than One Lot Or Partial Lots. (M = multiple, P = portion, MP = multiple with portions)
77	LAND_LOT	A Large Portion Or Tract Of Land (Which May Also Encompass Many Individual Blocks Or Lots) In Which The Property Is Located.
78	DISTRICT	The District In Which The Property Is Located. Usually A Numeric Code Corresponding To The Literal Name In Legal: City, Municipality, Township.
79	LEGAL_UNIT	The subdivision unit number. Common for condominiums, townhomes, etc. Not necessarily the same as the property unit number.
80	PHASE_NBR	The Phase Number Of The Subdivision Or Tract Development.
81	ASSR_MAP_REF	The map number assigned by the County Assessor; may or may not be the same as either the APN or legal map references.
82	CITY_SECTION	The Section Of The City In Which The Property Is Located.
83	LEGAL_FULL	Full Legal Description of property (compilation of all legal descriptions).
84	LEGAL_SEC_TWP_RNG	Section Township and Range as indicated in the legal reporting
85	ZONING	Actual City Zoning, unique to each incorporated area as reported to the County. Please note that it is not always current, nor reported.
86	TOWNSHIP	The "township" portion of geographical coordinates based on local surveys. Townships typically run north or south of pre-determined "meridian". Nominally six (U.S. Survey) miles (~9.7 km) on a side. Each 36-square-mile (~93 km2) township is divided into 36 one-square-mile (~2.6 km2) sections.
87	RANGE	The "range" portion of geographical coordinates based on local surveys. Ranges typically run east or west of pre-determined "meridian" in six mile intervals.
88	SECTION	The "section" portion of geographical coordinates based on local surveys. Sections are 1 square mile one square mile (2.6 square kilometers), containing 640 acres (260 hectares). There are 36 sections making up one survey township on a rectangular grid.
89	TAX_RATE_CODE_AREA	This is a county specific code or description that represent the tax entity(s) for which a parcel is taxed.
90	TAX_ACCT_NBR	When Provided In The Assessment Files, An Arbitrary Parcel Identifier Usually Assigned By The County Treasurer For Tax Purposes. Sometimes referred to as the Tax Id number
91	TAX_YEAR	The tax or assessment year for which the taxes were billed.
92	TAX_AMOUNT	The Total Tax amount provided by the county or local taxing authority.
93	TAX_EXEMPT_CODES	Tax Exemption code(s) of the property, up to four (4) property tax exemptions. Refer to TAX_EXEMPT_CODES_DESC for corresponding description.
94	TAX_EXEMPT_CODES_DESC	Description of the TAX_EXEMPT_CODES field.
95	YR_BLT	Year the primary structure on the property was built.
96	YR_BLT_EFFECT	This is the first year the building was assessed with its current components (e.g., a building is originally constructed in 1960 and a bedroom and bath was added to the building in 1974. The Year Built would be 1960 and the Effective Year Built would be 1974
97	BLDG_NUMBER	Total number of buildings or structures on a single parcel as reported on the assessment roll
98	BUILDING_SQFT	The building area of the primary structure on the property. If there are multiple residential units this is primarily the area of the largest residential structure. If the building is comprised of multiple uses (ex: Commercial plus Residential), then the value is typically equal to the residential living area.
99	BSMT_1_CODE	Code indicating the type of basement found in the building (e.g., unfinished, partial etc.). Refer to BASEMENT_FINISH_DESC field for the corresponding description.
100	BASEMENT_FINISH_DESC	Description of the BSMT_1_CODE field.
101	ELECT_AVAIL_CODE	Total number of elevators/escalators or Y/N indicating presence. Refer to ELECT_AVAIL_CODE_DESC field for the corresponding description.
102	ELECT_AVAIL_CODE_DESC	Description of the Elect_Avail_Code field.
103	BEDROOMS	Count of bedrooms (with closet). Residential only.
104	TOTAL_ROOMS	Total number of rooms reported on the assessment roll.
105	TOTAL_BATHS_CALCULATED	Number of full baths plus partial baths.
106	TOTAL_BATHS	Total count of full and partial bathrooms. Ex. 2 Full Bath + 2 Half Bath = 4
107	PARTIAL_BATHS	The Total Count Of Partial Baths as a whole number. Ex. 1/2 bath and a 3/4 bath = 2 Partial Bath
108	AIR_CONDITIONING	Code indicating the type of air conditioning method used to cool the building (e.g., Central, Evaporative). Refer to AIR_CONDITIONING_TYPE_DESC field for corresponding description.
109	AIR_CONDITIONING_TYPE_DESC	Description of the AIR_CONDITIONING field.
110	CONSTRUCTION_CODE	Code indicating the type of construction (e.g., Brick / Concrete etc.). Refer to CONSTRUCTION_CODE_DESC field for corresponding description.
111	CONSTRUCTION_CODE_DESC	Description of the CONSTRUCTION_CODE field.
112	EXTERIOR_WALL_TYPE	Code indicating the type and/or finish of the exterior walls (e.g., Vinyl Siding, Brick Veneer). Refer to EXTERIOR_WALL_DESC field for corresponding description.
113	EXTERIOR_WALL_DESC	Description of the EXTERIOR_WALL_TYPE field.
114	FIREPLACE_TYPE	Reported differently in counties - can be either the number of fireplaces or a "Y" indicating that a fireplace is present, "N" indicating there is no fireplace, blank is unknown.
115	FOUNDATION_TYPE	The code that defines the type of foundation (e.g., Continuous Footing, Pier, Mud Sill). Refer to FOUNDATION_TYPE_DESC field for corresponding description.
116	FOUNDATION_TYPE_DESC	Description of the FOUNDATION_TYPE field.
117	GARAGE_CARPORT_TYPE	Code indicating type of garage or carport present (e.g., Attached Finished, Enclosed Carport, Basement Garage). Refer to GARAGE_CODE_DESC field for corresponding description.
118	GARAGE_CODE_DESC	Description of the GARAGE_CARPORT_TYPE field.
119	HEATING_TYPE	Code indicating type of fuel used for heating of water and building (e.g., Electric, Central, Solar, Propane). Refer to HEATING_DESC field for corresponding description.
120	HEATING_DESC	Description of the HEATING_TYPE field.
121	PARKING_SPACES	Total number of parking spaces or car capacity associated with the garage or parking area.
122	POOL_INDICATOR	Code indicating type of pool on the property (e.g., Above Ground, In Ground, Spa). Refer to POOL_INDICATOR_DESC field for corresponding description.
123	POOL_INDICATOR_DESC	Description of the POOL_INDICATOR field.
124	ROOF_COVER_TYPE	Code indicating the type of roof covering (e.g., Clay Tile, Aluminum, Shake). Refer to ROOF_COVER_DESC field for corresponding description.
125	ROOF_COVER_DESC	Description of the ROOF_COVER_TYPE field.
126	STORIES_NUMBER	Code indicating the number of stories of the main structure on the property. Refer to STORIES_NUMBER_DESC for corresponding description.
127	STORIES_NUMBER_DESC	Description of the STORIES_NUMBER field.
128	STYLE_TYPE	Code Indicating type of building style (e.g., Colonial, Cape Code, Bungalow). Refer to STYLE_DESC field for corresponding description.
129	STYLE_DESC	Description of the STYLE_TYPE field.
130	UNITS_NUMBER	Number of units reported on the assessment roll. Primarily used for reporting of apartment buildings.
131	BLDG_CLASS	Fire Insurance Building Classification Code used for Commercial/Industrial buildings. Refer to BLDG_CLASS_DESC for corresponding description.
132	BLDG_CLASS_DESC	Description of the BLDG_CLASS field.
133	BUILDING_QUALITY	A code reflecting the quality of a building. Usually comes as a grade from the county.
134	FLOOR_COVER	A code reflecting the type of flooring used in improvements on the property. Refer to the FLOOR_COVER_DESC field for the corresponding description.
135	FLOOR_COVER_DESC	Description for the FLOOR_COVER field.
136	PLUMBING_FIXTURES	This is a numerical field identifying the number of plumbing features reported by the county assessor in the primary building/improvement on the property.
137	HEATING_FUEL_TYPE	Code for type of heating fuel. Refer to the HEATING_FUEL_TYPE_DESC field for the corresponding description.
138	HEATING_FUEL_TYPE_DESC	Description for the HEATING_FUEL_TYPE field.
139	AIR_CONDITIONING_TYPE	A code describing the type of air conditioning. Some counties may also provide an air conditioning method or system. Refer to the AIR_CONDITIONING_DESC field for the corresponding description.
140	AIR_CONDITIONING_DESC	Description for the AIR_CONDITIONING_TYPE field.
141	INTERIOR_WALLS	A code reflecting the composition of the interior walls. Refer to the INTERIOR_WALLS_DESC field for the corresponding description.
142	INTERIOR_WALLS_DESC	Description of the INTERIOR_WALLS field.
143	BLDG_AREA_1	The area associated with the building1 indicator - This field is not standardized and therefore the data is not easily consumable.
144	BLDG_AREA_1_INDICATOR	Indicates area of structure associated with the associated building 1 area (EX 1st floor, attic , porch etc.).Refer to BLDG_AREA_1_DESC field for the corresponding description.
145	BLDG_AREA_1_DESC	Description for BLDG_AREA_1_INDICATOR field.
146	BLDG_AREA_2	The area associated with the building 2 indicator This field is not standardized and therefore the data is not easily consumable.
147	BLDG_AREA_2_INDICATOR	Indicates area of structure associated with the associated building 2 area (EX 1st floor, attic , porch etc.).Refer to BLDG_AREA_2_DESC field for the corresponding description.
148	BLDG_AREA_2_DESC	Description for BLDG_AREA_2_INDICATOR field.
149	BLDG_AREA_3	The area associated with the building 3 indicator This field is not standardized and therefore the data is not easily consumable.
150	BLDG_AREA_3_INDICATOR	Indicates area of structure associated with the associated building 3 area (EX 1st floor, attic , porch etc.).Refer to BLDG_AREA_3_DESC field for the corresponding description.
151	BLDG_AREA_3_DESC	Description for BLDG_AREA_3_INDICATOR field.
152	BLDG_AREA_4	The area associated with the building 4 indicator This field is not standardized and therefore the data is not easily consumable.
153	BLDG_AREA_4_INDICATOR	Indicates area of structure associated with the associated building 4 area (EX 1st floor, attic , porch etc.).Refer to BLDG_AREA_4_DESC field for the corresponding description.
154	BLDG_AREA_4_DESC	Description for BLDG_AREA_4_INDICATOR field.
155	BLDG_AREA_5	The area associated with the building 5 indicator This field is not standardized and therefore the data is not easily consumable.
156	BLDG_AREA_5_INDICATOR	Indicates area of structure associated with the associated building 5 area (EX 1st floor, attic , porch etc.).Refer to BLDG_AREA_5_DESC field for the corresponding description.
157	BLDG_AREA_5_DESC	Description for BLDG_AREA_5_INDICATOR field.
158	BLDG_AREA_6	The area associated with the building 6 indicator This field is not standardized and therefore the data is not easily consumable.
159	BLDG_AREA_6_INDICATOR	Indicates area of structure associated with the associated building 6 area (EX 1st floor, attic , porch etc.).Refer to BLDG_AREA_6_DESC field for the corresponding description.
160	BLDG_AREA_6_DESC	Description for BLDG_AREA_6_INDICATOR field.
161	BLDG_AREA_7	The area associated with the building 7 indicator This field is not standardized and therefore the data is not easily consumable.
162	BLDG_AREA_7_INDICATOR	Indicates area of structure associated with the associated building 7 area (EX 1st floor, attic , porch etc.).Refer to BLDG_AREA_7_DESC field for the corresponding description.
163	BLDG_AREA_7_DESC	Description for BLDG_AREA_7_INDICATOR field.
164	SITE_INFLUENCE	A code identifying the features or characteristics of a location which might influence the value or desirability of a parcel, such as waterfront or traffic patterns. The field can contain up to two codes. Refer to the SITE_INFLUENCE_DESCRIPTION field for the corresponding description.
165	SITE_INFLUENCE_DESCRIPTION	Describes the features/characteristics of location
166	ROOF_TYPE	A code describing the architectural style of the roof (gable, mansard, etc.). Refer to the ROOF_TYPE_DESC field for the corresponding description.
167	ROOF_TYPE_DESC	Description of the ROOF_TYPE field.
168	BUILDING_CONDITION	Additional information regarding a parcel. This information may come from a comments field provided by the county or can be information added by the analyst. If Duplicate parcels are present, this field contains a Summary of multiple building records and should contain the Improvement # and any available physical characteristics. Refer to the BUILDING_CONDITION_DESC field for the corresponding description.
169	BUILDING_CONDITION_DESC	Describes the BUILDING_CONDITION field.
170	WATER	A code indicating the type of water system for the property. Refer to the WATER_CODE_DESC field for the corresponding description.
171	WATER_CODE_DESC	Description for the WATER field.
172	SEWER	A code indicating the type of waste disposal/sewage system for the property. Refer to the SEWER_DESC field for the corresponding description.
173	SEWER_DESC	Description for the SEWER field.
174	BUILDING_AREA_INDICATOR	Identifies the value moved to BUILDING AREA [86]. Some examples are living area, basement area, 1st floor area. When a county provides multiple areas, the preferred value to move to BUILDING AREA [86] is Living Area. Refer to the BUILDING_AREA_INDICATOR_DESC field for the corresponding description.
175	BUILDING_AREA_INDICATOR_DESC	Description for the BUILDING_AREA_INDICATOR field.
176	MULTI_TAXAPN_FLAG	Indicates multiple or split parcel sales. Ex. When a sale occurs that includes multiple parcels.
177	LAST_MARKET_SALE_DOC_TYPE_DESC	Description of the LAST_MARKET_SALE_DOC_TYPE field.
178	LAST_MARKET_SALE_DOC_TYPE	Code indicating the description of the document type associated with last market sale. Refer to LAST_MARKET_SALE_DOC_TYPE_DESC for the corresponding description.
179	LAST_MARKET_SALE_LOAN_DUE_DATE	Loan Due date associated with the latest market sale.
180	LAST_MARKET_SALE_VAL_TRANSFER	Price of the last market sale.
181	LAST_MARKET_SALE_DOC_NUMBER	The document number used to record the last market sale transaction.
182	LAST_MARKET_SALE_DATE_TRANSFER	The date the property sold to the owner during the latest market sale.
183	LAST_MARKET_SALE_BOOK	Assessors book number associated with the latest market sale.
184	LAST_MARKET_SALE_PAGE	Assessors page number associated with the latest market sale.
185	LAST_MARKET_SALE_SELLER_NAME	Seller name(s) (first and last) associated with the latest market sale
186	LAST_MARKET_SALE_SELLER_1_FIRST_MID	Seller 1 first and middle name associated with the latest market sale
187	LAST_MARKET_SALE_SELLER_1_LAST	Seller 1 last name associated with the latest market sale
188	LAST_MARKET_SALE_SELLER_1_CODE	Seller 1 code associated with the latest market sale. Refer to the LAST_MARKET_SALE_SELLER_1_CODE_DESC field for the corresponding description.
189	LAST_MARKET_SALE_SELLER_1_CODE_DESC	Description of LAST_MARKET_SALE_SELLER_1_CODE field.
190	LAST_MARKET_SALE_SELLER_2_FIRST_MID	Seller 2 first and middle name associated with the latest market sale
191	LAST_MARKET_SALE_SELLER_2_LAST	Seller 2 last name associated with the latest market sale
192	LAST_MARKET_SALE_BUYER_NAME	Buyer name(s) (First and last) associated with the latest market sale
193	LAST_MARKET_SALE_BUYER_1_FIRST_MID	Buyer 1 first and middle name associated with the latest market sale
194	LAST_MARKET_SALE_BUYER_1_LAST	Buyer 1 last name associated with the latest market sale
195	LAST_MARKET_SALE_BUYER_1_CODE	Buyer 1 code associated with the latest market sale of a property. Refer to the LAST_MARKET_SALE_BUYER_1_CODE_DESC field for the corresponding description.
196	LAST_MARKET_SALE_BUYER_1_CODE_DESC	Description of LAST_MARKET_SALE_BUYER_1_CODE field.
197	LAST_MARKET_SALE_BUYER_2_FIRST_MID	Buyer 2 first and middle name associated with the latest market sale
198	LAST_MARKET_SALE_BUYER_2_LAST	Buyer 2 last name associated with the latest market sale
199	LAST_MARKET_SALE_BUYER_2_CODE	Buyer 2 code associated with the latest market sale of a property. Refer to the LAST_MARKET_SALE_BUYER_2_CODE_DESC field for the corresponding description.
200	LAST_MARKET_SALE_BUYER_2_CODE_DESC	Description of LAST_MARKET_SALE_BUYER_2_CODE field.
201	LAST_MARKET_SALE_RCDRS_MAP_REF	The map number assigned by the county assessor associated with the latest market sale.
202	LAST_MARKET_SALE_TRAN_TYPE	Code indicating the deed transaction type. Refer to LAST_MARKET_SALE_TRAN_TYPE_DESC for the corresponding description.
203	LAST_MARKET_SALE_BUYER_VESTING_CODE	Code indicating how the buyers took title of the subject property during the latest market sale. Refer to the LAST_MARKET_SALE_BUYER_VESTING_CODE_DESC field for the corresponding description.
204	LAST_MARKET_SALE_BUYER_VESTING_CODE_DESC	Description of LAST_MARKET_SALE_BUYER_VESTING_CODE field.
205	LAST_MARKET_SALE_ORIGINAL_SALE_DATE	The last market sale date.
206	LAST_MARKET_SALE_TRAN_TYPE_DESC	Description of the LAST_MARKET_SALE_TRAN_TYPE field.
207	LAST_MARKET_SALE_SALE_CODE	The code indicating the methodology used to determine the price of the last market sale (VAL_TRANSFER). Refer to LAST_MARKET_SALE_SALE_CODE_DESC field for the corresponding description.
208	LAST_MARKET_SALE_SALE_CODE_DESC	Description of the LAST_MARKET_SALE_SALE_CODE field.
209	LAST_MARKET_SALE_FULL_PART_CODE	Code that inventories %ownership transfer when less than 100% ownership interest is transferred by the recorded instrument. For example, a partner sells only his 50% interest. This also applies to transfers where the Grantors entire ownership interest is LESS than 100%. For example, the Grantor conveys all of his interest in the property, which is a 25% interest. When the percentage is a single digit (1-9), it is preceded with a zero: 5% = 05. When interest shown is a whole number plus a value after the decimal or fraction, it is rounded to nearest whole number only: 75.5% = 76; 33 1/3% = 33, etc.
210	LAST_MARKET_SALE_SOURCE_CODE	The code indicating the source associated with the last market sale of a property. D=DEED; A=ASSESSMENT
211	IS_PRIMARY_ASSESSMENT	Value 1 indicates that the record is the primary assessment record when there are multiple assessment records linked to one parcel (e.g. condo). The primary assessment record is defined as the record which carries the lowest APN among the group of assessment records linked to the same parcel.
212	GEOMETRY	Parcel polygon geometry

Orphan Assessments

ID	Field Names	Description
1	ASSESSMENT_LID	A proprietary LightBox identifier for assessment record that is unique and persistent.
2	FIPS_CODE	Federal Information Processing Code for the State + Federal Information Processing Code for the County. The first two digits are the state FIPs code. The last three digits are the county FIPs code.
3	UNIQUE_PARCEL_APN	Unique parcel APN derived from the parcel geometry. (note: may differ from unique apn derived from the tax assessor)
4	PARCEL_APN	Master Parcel APN. This is the master/main APN number associated with the primary parcel in a location where multiple parcels with identical geometry exist. This can occur where there are multiple taxable properties in a location (condos, timeshares, mobile home parks)
5	COUNTY	County Name
6	TAXAPN	Property APN/ID as inventoried by the tax assessor. Excludes APN sequence number (DUPE_TAXAPN_SEQ) EX: 07-08-34.001
7	ALTERNATE_TAXAPN	Deprecated or historical parcel number as inventoried by the tax assessor.
8	ALTERNATE_TAXAPN_INDICATOR	A code indicating if the APN is a deprecated or historical parcel number as inventoried by the tax assessor. Refer to the field ALTERNATE_TAXAPN_INDICATOR_DESC for the corresponding description.
9	ALTERNATE_TAXAPN_INDICATOR_DESC	Description for the ALTERNATE_TAXAPN_INDICATOR field.
10	SITE_ADDR	Address where the physical property is located. Comprised of all site address components excluding city, Zip code and zip + 4 code. (e.g. 125 Main St E Unit # 5)
11	SITE_CITY	Property city name returned from corrected address process (EX "Anytown" in 123 main street unit A Anytown CA")
12	SITE_STATE	Property state returned from corrected address process (EX "CA" in 123 main street unit A Anytown CA")
13	SITE_ZIP	Property zip code returned from corrected address process (EX "92120" in 123 main street unit A Anytown CA 92120 ")
14	SITE_PLUS_4	4 digit "plus 4 code" or "add on code" where the physical property resides used by the US Postal service to identify a geographic segment within a 5 digit postal ZIP code. (e.g. 5437)
15	CENSUS_TRACT	Small, relatively permanent statistical subdivisions of a county or equivalent entity that are updated by local participants prior to each decennial census as part of the Census Bureau's Participant Statistical Areas Program
16	CENSUS_BLOCK_GROUP	Block Group: Geographical unit used by the United States Census Bureau which is between the Census Tract and the Census Block.
17	CENSUS_BLOCK	The Census block of the subdivision or city in which the property is located.
18	CBSA_CODE	Code indicating Core Based Statistical Area from spatial overlay.
19	MUNICIPALITY	The Jurisdiction In Which The Property Is Located.
20	MSA_CODE	The Metropolitan Statistical Area code. Refer to MSA_CODE_DESC for the corresponding description.
21	MSA_CODE_DESC	Description of MSA_CODE.
22	OWNER_OCCUPIED	Indicates if the property is occupied by the owner (Y/N)
23	OWNER_NAME	Owner full name provided as reported by the local taxing/assessment authority at the time of the tax roll release. Contains multiple owners if present.
24	OWNER_NAME_1	Current First Owner full name (first middle last)
25	OWNER_NAME_2	Owner 2 full name (first middle last) provided by the local taxing/assessment authority
26	OWNERSHIP_STATUS_CODE	Ownership status code for the last sale of a property. See Ownership_Status_Desc
27	OWNERSHIP_STATUS_DESC	Description of the OWNERSHIP_STATUS_CODE field.
28	COMPANY_FLAG	Flag indicating if property is occupied by a company
29	MAIL_CITY	City portion of the owner mailing address. (e.g. CHICAGO, ATLANTA, DENVER).
30	MAIL_STATE	Two letter state code of the owner mailing address .(e.g. CA, NV WA)
31	MAIL_ZIP	Postal Code portion of the current owner mailing address. (e.g. 92675)
32	MAIL_PLUS_4	4 digit "plus 4 code" or "add on code" of the current owner mailing address. Used by the US Postal service to identify a geographic segment within a 5 digit postal ZIP code. (e.g. 5437)
33	MAIL_ADDR	Current Owner Mailing Street Address. Comprised of Street name, Street Directional Prefix, Street Number, Street Suffix, Unit type and Unit number. EX: "125 Main Street S Unit 5"
34	USE_CODE_MUNI	Local/Municipal Use Code of a property. Refer to USE_CODE_MUNI_DESC field for the corresponding description.
35	USE_CODE_MUNI_DESC	Description of the USE_CODE_MUNI field
36	USE_CODE_STD_LPS	Standardized Land Use Code normalized across all counties. Indicates the use of a property.
37	USE_CODE_STD_DESC_LPS	Description of the Standardized Land Use Code.
38	USE_CODE_STD_CTGR_DESC_LPS	Description of the Standardized Land Use Category Code.
39	USE_CODE_STD_CTGR_LPS	Standardized land Use Category Code.
40	STATE_LAND_USE_CODE	The land use code used by the state for land use classification. This field is only populated if this code differs from county land use code. Refer to the STATE_LAND_USE_CODE_DESC field for the corresponding description.
41	STATE_LAND_USE_CODE_DESC	Description for STATE_LAND_USE_CODE field.
42	LOT_WIDTH	The linear feet across the front of the lot, often the side of the property facing the street.
43	LOT_DEPTH	The linear feet between the front and back of the lot.
44	ACREAGE	The size of the property, in acres. Derived from the assessment record when possible, otherwise calculated from associated parcel geometry.
45	LAND_SQFT	The size of the property, in square feet Derived from the assessment record when possible, otherwise calculated from associated parcel geometry.
46	ASSR_ACREAGE	Assessed acreage of the property as reported by the assessor.
47	ASSR_SQFT	Lot size square feet as reported by the assessor.
48	CAL_ACREAGE	Calculated acreage derived from the associated parcel geometry
49	CAL_SQFT	Calculated square feet derived from the associated parcel geometry
50	LOT_SIZE_AREA	The total area of the land from the assessor. Units for area are in LOT_SIZE_AREA_UNIT field.
51	LOT_SIZE_AREA_UNIT	Units of measurement referenced used Lot Size Area
52	LOT_SIZE_AREA_ORGN	The Total Square Footage Of The Land.
53	TOPOGRAPHY	Contains code representing the physical (including man-made) or natural features of the land.
54	TOPOGRAPHY_DESC	Description of the TOPOGRAPHY field.
55	AVM_VALUE	Property value determined by an Automated Valuation Model. Often based on comparable properties at a specific point in time.
56	VAL_ASSD	The Total Assessed Value of both Land & Improvement values (before exemptions, if any) for the property as provided by the county or local taxing/assessment authority.
57	VAL_ASSD_LAND	The Assessed Land Value (before exemptions, if any) as provided by the county or local taxing/assessment authority.
58	VAL_ASSD_IMPRV	The Assessed Improvement Values (before exemptions, if any) as provided by the county or local taxing/assessment authority
59	VAL_MARKET	Total Market value as determined by the county or local taxing/assessment authority
60	DATE_CERT	The date that the file was certified by the county in the format YYYYMMDD.
61	VAL_MRKT_LAND	Market value of the land as provided by the county or local taxing/assessment authority
62	VAL_MRKT_IMPRV	Market value of improvements as provided by the county or local taxing/assessment authority
63	YR_MRKT_VAL	Year that market values were established.
64	DATE_ASSR_TAPE_CUT	Date the county assessor or tax collector generated the tax roll data.
65	BLOCK_NUMBER	The block number in which the property is located as indicated in legal reporting.
66	LOT_NUMBER	The individual lot(s) which comprise the property. The actual lot number(s) such as in a tract or subdivision as indicated in legal reporting.
67	SUBDIVISION	The name of the subdivision, plat, or tract in which the property is located as indicated in legal reporting.
68	TRACT_NUMBER	The number of the tract in which the property is located as indicated in legal reporting.
69	LEGAL_1	Narrative legal description of the property as documented by the assessor
70	LOT_CODE	Identifies Properties Which Include More Than One Lot Or Partial Lots. (M = multiple, P = portion, MP = multiple with portions)
71	LAND_LOT	A Large Portion Or Tract Of Land (Which May Also Encompass Many Individual Blocks Or Lots) In Which The Property Is Located.
72	DISTRICT	The District In Which The Property Is Located. Usually A Numeric Code Corresponding To The Literal Name In Legal: City, Municipality, Township.
73	LEGAL_UNIT	The subdivision unit number. Common for condominiums, townhomes, etc. Not necessarily the same as the property unit number.
74	PHASE_NBR	The Phase Number Of The Subdivision Or Tract Development.
75	ASSR_MAP_REF	The map number assigned by the County Assessor; may or may not be the same as either the APN or legal map references.
76	CITY_SECTION	The Section Of The City In Which The Property Is Located.
77	LEGAL_FULL	Full Legal Description of property (compilation of all legal descriptions).
78	LEGAL_SEC_TWP_RNG	Section Township and Range as indicated in the legal reporting
79	ZONING	Actual City Zoning, unique to each incorporated area as reported to the County. Please note that it is not always current, nor reported.
80	TOWNSHIP	The "township" portion of geographical coordinates based on local surveys. Townships typically run north or south of pre-determined "meridian". Nominally six (U.S. Survey) miles (~9.7 km) on a side. Each 36-square-mile (~93 km2) township is divided into 36 one-square-mile (~2.6 km2) sections.
81	RANGE	The "range" portion of geographical coordinates based on local surveys. Ranges typically run east or west of pre-determined "meridian" in six mile intervals.
82	SECTION	The "section" portion of geographical coordinates based on local surveys. Sections are 1 square mile one square mile (2.6 square kilometers), containing 640 acres (260 hectares). There are 36 sections making up one survey township on a rectangular grid.
83	TAX_RATE_CODE_AREA	This is a county specific code or description that represent the tax entity(s) for which a parcel is taxed.
84	TAX_ACCT_NBR	When Provided In The Assessment Files, An Arbitrary Parcel Identifier Usually Assigned By The County Treasurer For Tax Purposes. Sometimes referred to as the Tax Id number
85	TAX_YEAR	The tax or assessment year for which the taxes were billed.
86	TAX_AMOUNT	The Total Tax amount provided by the county or local taxing authority.
87	TAX_EXEMPT_CODES	Tax Exemption code(s) of the property, up to four (4) property tax exemptions. Refer to TAX_EXEMPT_CODES_DESC for corresponding description.
88	TAX_EXEMPT_CODES_DESC	Description of the TAX_EXEMPT_CODES field.
89	YR_BLT	Year the primary structure on the property was built.
90	YR_BLT_EFFECT	This is the first year the building was assessed with its current components (e.g., a building is originally constructed in 1960 and a bedroom and bath was added to the building in 1974. The Year Built would be 1960 and the Effective Year Built would be 1974
91	BLDG_NUMBER	Total number of buildings or structures on a single parcel as reported on the assessment roll
92	BUILDING_SQFT	The building area of the primary structure on the property. If there are multiple residential units this is primarily the area of the largest residential structure. If the building is comprised of multiple uses (ex: Commercial plus Residential), then the value is typically equal to the residential living area.
93	BSMT_1_CODE	Code indicating the type of basement found in the building (e.g., unfinished, partial etc.). Refer to BASEMENT_FINISH_DESC field for the corresponding description.
94	BASEMENT_FINISH_DESC	Description of the BSMT_1_CODE field.
95	ELECT_AVAIL_CODE	Total number of elevators/escalators or Y/N indicating presence. Refer to ELECT_AVAIL_CODE_DESC field for the corresponding description.
96	ELECT_AVAIL_CODE_DESC	Description of the Elect_Avail_Code field.
97	BEDROOMS	Count of bedrooms (with closet). Residential only.
98	TOTAL_ROOMS	Total number of rooms reported on the assessment roll.
99	TOTAL_BATHS_CALCULATED	Number of full baths plus partial baths.
100	TOTAL_BATHS	Total count of full and partial bathrooms. Ex. 2 Full Bath + 2 Half Bath = 4
101	PARTIAL_BATHS	The Total Count Of Partial Baths as a whole number. Ex. 1/2 bath and a 3/4 bath = 2 Partial Bath
102	AIR_CONDITIONING	Code indicating the type of air conditioning method used to cool the building (e.g., Central, Evaporative). Refer to AIR_CONDITIONING_TYPE_DESC field for corresponding description.
103	AIR_CONDITIONING_TYPE_DESC	Description of the AIR_CONDITIONING field.
104	CONSTRUCTION_CODE	Code indicating the type of construction (e.g., Brick / Concrete etc.). Refer to CONSTRUCTION_CODE_DESC field for corresponding description.
105	CONSTRUCTION_CODE_DESC	Description of the CONSTRUCTION_CODE field.
106	EXTERIOR_WALL_TYPE	Code indicating the type and/or finish of the exterior walls (e.g., Vinyl Siding, Brick Veneer). Refer to EXTERIOR_WALL_DESC field for corresponding description.
107	EXTERIOR_WALL_DESC	Description of the EXTERIOR_WALL_TYPE field.
108	FIREPLACE_TYPE	Reported differently in counties - can be either the number of fireplaces or a "Y" indicating that a fireplace is present, "N" indicating there is no fireplace, blank is unknown.
109	FOUNDATION_TYPE	The code that defines the type of foundation (e.g., Continuous Footing, Pier, Mud Sill). Refer to FOUNDATION_TYPE_DESC field for corresponding description.
110	FOUNDATION_TYPE_DESC	Description of the FOUNDATION_TYPE field.
111	GARAGE_CARPORT_TYPE	Code indicating type of garage or carport present (e.g., Attached Finished, Enclosed Carport, Basement Garage). Refer to GARAGE_CODE_DESC field for corresponding description.
112	GARAGE_CODE_DESC	Description of the GARAGE_CARPORT_TYPE field.
113	HEATING_TYPE	Code indicating type of fuel used for heating of water and building (e.g., Electric, Central, Solar, Propane). Refer to HEATING_DESC field for corresponding description.
114	HEATING_DESC	Description of the HEATING_TYPE field.
115	PARKING_SPACES	Total number of parking spaces or car capacity associated with the garage or parking area.
116	POOL_INDICATOR	Code indicating type of pool on the property (e.g., Above Ground, In Ground, Spa). Refer to POOL_INDICATOR_DESC field for corresponding description.
117	POOL_INDICATOR_DESC	Description of the POOL_INDICATOR field.
118	ROOF_COVER_TYPE	Code indicating the type of roof covering (e.g., Clay Tile, Aluminum, Shake). Refer to ROOF_COVER_DESC field for corresponding description.
119	ROOF_COVER_DESC	Description of the ROOF_COVER_TYPE field.
120	STORIES_NUMBER	Code indicating the number of stories of the main structure on the property. Refer to STORIES_NUMBER_DESC for corresponding description.
121	STORIES_NUMBER_DESC	Description of the STORIES_NUMBER field.
122	STYLE_TYPE	Code Indicating type of building style (e.g., Colonial, Cape Code, Bungalow). Refer to STYLE_DESC field for corresponding description.
123	STYLE_DESC	Description of the STYLE_TYPE field.
124	UNITS_NUMBER	Number of units reported on the assessment roll. Primarily used for reporting of apartment buildings.
125	BLDG_CLASS	Fire Insurance Building Classification Code used for Commercial/Industrial buildings. Refer to BLDG_CLASS_DESC for corresponding description.
126	BLDG_CLASS_DESC	Description of the BLDG_CLASS field.
127	BUILDING_QUALITY	A code reflecting the quality of a building. Usually comes as a grade from the county.
128	FLOOR_COVER	A code reflecting the type of flooring used in improvements on the property. Refer to the FLOOR_COVER_DESC field for the corresponding description.
129	FLOOR_COVER_DESC	Description for the FLOOR_COVER field.
130	PLUMBING_FIXTURES	This is a numerical field identifying the number of plumbing features reported by the county assessor in the primary building/improvement on the property.
131	HEATING_FUEL_TYPE	Code for type of heating fuel. Refer to the HEATING_FUEL_TYPE_DESC field for the corresponding description.
132	HEATING_FUEL_TYPE_DESC	Description for the HEATING_FUEL_TYPE field.
133	AIR_CONDITIONING_TYPE	A code describing the type of air conditioning. Some counties may also provide an air conditioning method or system. Refer to the AIR_CONDITIONING_DESC field for the corresponding description.
134	AIR_CONDITIONING_DESC	Description for the AIR_CONDITIONING_TYPE field.
135	INTERIOR_WALLS	A code reflecting the composition of the interior walls. Refer to the INTERIOR_WALLS_DESC field for the corresponding description.
136	INTERIOR_WALLS_DESC	Description of the INTERIOR_WALLS field.
137	BLDG_AREA_1	The area associated with the building1 indicator - This field is not standardized and therefore the data is not easily consumable.
138	BLDG_AREA_1_INDICATOR	Indicates area of structure associated with the associated building 1 area (EX 1st floor, attic , porch etc.).Refer to BLDG_AREA_1_DESC field for the corresponding description.
139	BLDG_AREA_1_DESC	Description for BLDG_AREA_1_INDICATOR field.
140	BLDG_AREA_2	The area associated with the building 2 indicator This field is not standardized and therefore the data is not easily consumable.
141	BLDG_AREA_2_INDICATOR	Indicates area of structure associated with the associated building 2 area (EX 1st floor, attic , porch etc.).Refer to BLDG_AREA_2_DESC field for the corresponding description.
142	BLDG_AREA_2_DESC	Description for BLDG_AREA_2_INDICATOR field.
143	BLDG_AREA_3	The area associated with the building 3 indicator This field is not standardized and therefore the data is not easily consumable.
144	BLDG_AREA_3_INDICATOR	Indicates area of structure associated with the associated building 3 area (EX 1st floor, attic , porch etc.).Refer to BLDG_AREA_3_DESC field for the corresponding description.
145	BLDG_AREA_3_DESC	Description for BLDG_AREA_3_INDICATOR field.
146	BLDG_AREA_4	The area associated with the building 4 indicator This field is not standardized and therefore the data is not easily consumable.
147	BLDG_AREA_4_INDICATOR	Indicates area of structure associated with the associated building 4 area (EX 1st floor, attic , porch etc.).Refer to BLDG_AREA_4_DESC field for the corresponding description.
148	BLDG_AREA_4_DESC	Description for BLDG_AREA_4_INDICATOR field.
149	BLDG_AREA_5	The area associated with the building 5 indicator This field is not standardized and therefore the data is not easily consumable.
150	BLDG_AREA_5_INDICATOR	Indicates area of structure associated with the associated building 5 area (EX 1st floor, attic , porch etc.).Refer to BLDG_AREA_5_DESC field for the corresponding description.
151	BLDG_AREA_5_DESC	Description for BLDG_AREA_5_INDICATOR field.
152	BLDG_AREA_6	The area associated with the building 6 indicator This field is not standardized and therefore the data is not easily consumable.
153	BLDG_AREA_6_INDICATOR	Indicates area of structure associated with the associated building 6 area (EX 1st floor, attic , porch etc.).Refer to BLDG_AREA_6_DESC field for the corresponding description.
154	BLDG_AREA_6_DESC	Description for BLDG_AREA_6_INDICATOR field.
155	BLDG_AREA_7	The area associated with the building 7 indicator This field is not standardized and therefore the data is not easily consumable.
156	BLDG_AREA_7_INDICATOR	Indicates area of structure associated with the associated building 7 area (EX 1st floor, attic , porch etc.).Refer to BLDG_AREA_7_DESC field for the corresponding description.
157	BLDG_AREA_7_DESC	Description for BLDG_AREA_7_INDICATOR field.
158	SITE_INFLUENCE	A code identifying the features or characteristics of a location which might influence the value or desirability of a parcel, such as waterfront or traffic patterns. The field can contain up to two codes. Refer to the SITE_INFLUENCE_DESCRIPTION field for the corresponding description.
159	SITE_INFLUENCE_DESCRIPTION	Describes the features/characteristics of location
160	ROOF_TYPE	A code describing the architectural style of the roof (gable, mansard, etc.). Refer to the ROOF_TYPE_DESC field for the corresponding description.
161	ROOF_TYPE_DESC	Description of the ROOF_TYPE field.
162	BUILDING_CONDITION	Additional information regarding a parcel. This information may come from a comments field provided by the county or can be information added by the analyst. If Duplicate parcels are present, this field contains a Summary of multiple building records and should contain the Improvement # and any available physical characteristics. Refer to the BUILDING_CONDITION_DESC field for the corresponding description.
163	BUILDING_CONDITION_DESC	Describes the BUILDING_CONDITION field.
164	WATER	A code indicating the type of water system for the property. Refer to the WATER_CODE_DESC field for the corresponding description.
165	WATER_CODE_DESC	Description for the WATER field.
166	SEWER	A code indicating the type of waste disposal/sewage system for the property. Refer to the SEWER_DESC field for the corresponding description.
167	SEWER_DESC	Description for the SEWER field.
168	BUILDING_AREA_INDICATOR	Identifies the value moved to BUILDING AREA [86]. Some examples are living area, basement area, 1st floor area. When a county provides multiple areas, the preferred value to move to BUILDING AREA [86] is Living Area. Refer to the BUILDING_AREA_INDICATOR_DESC field for the corresponding description.
169	BUILDING_AREA_INDICATOR_DESC	Description for the BUILDING_AREA_INDICATOR field.
170	MULTI_TAXAPN_FLAG	Indicates multiple or split parcel sales. Ex. When a sale occurs that includes multiple parcels.
171	LAST_MARKET_SALE_DOC_TYPE_DESC	Description of the LAST_MARKET_SALE_DOC_TYPE field.
172	LAST_MARKET_SALE_DOC_TYPE	Code indicating the description of the document type associated with last market sale. Refer to LAST_MARKET_SALE_DOC_TYPE_DESC for the corresponding description.
173	LAST_MARKET_SALE_LOAN_DUE_DATE	Loan Due date associated with the latest market sale.
174	LAST_MARKET_SALE_VAL_TRANSFER	Price of the last market sale.
175	LAST_MARKET_SALE_DOC_NUMBER	The document number used to record the last market sale transaction.
176	LAST_MARKET_SALE_DATE_TRANSFER	The date the property sold to the owner during the latest market sale.
177	LAST_MARKET_SALE_BOOK	Assessors book number associated with the latest market sale.
178	LAST_MARKET_SALE_PAGE	Assessors page number associated with the latest market sale.
179	LAST_MARKET_SALE_SELLER_NAME	Seller name(s) (first and last) associated with the latest market sale
180	LAST_MARKET_SALE_SELLER_1_FIRST_MID	Seller 1 first and middle name associated with the latest market sale
181	LAST_MARKET_SALE_SELLER_1_LAST	Seller 1 last name associated with the latest market sale
182	LAST_MARKET_SALE_SELLER_1_CODE	Seller 1 code associated with the latest market sale. Refer to the LAST_MARKET_SALE_SELLER_1_CODE_DESC field for the corresponding description.
183	LAST_MARKET_SALE_SELLER_1_CODE_DESC	Description of LAST_MARKET_SALE_SELLER_1_CODE field.
184	LAST_MARKET_SALE_SELLER_2_FIRST_MID	Seller 2 first and middle name associated with the latest market sale
185	LAST_MARKET_SALE_SELLER_2_LAST	Seller 2 last name associated with the latest market sale
186	LAST_MARKET_SALE_BUYER_NAME	Buyer name(s) (First and last) associated with the latest market sale
187	LAST_MARKET_SALE_BUYER_1_FIRST_MID	Buyer 1 first and middle name associated with the latest market sale
188	LAST_MARKET_SALE_BUYER_1_LAST	Buyer 1 last name associated with the latest market sale
189	LAST_MARKET_SALE_BUYER_1_CODE	Buyer 1 code associated with the latest market sale of a property. Refer to the LAST_MARKET_SALE_BUYER_1_CODE_DESC field for the corresponding description.
190	LAST_MARKET_SALE_BUYER_1_CODE_DESC	Description of LAST_MARKET_SALE_BUYER_1_CODE field.
191	LAST_MARKET_SALE_BUYER_2_FIRST_MID	Buyer 2 first and middle name associated with the latest market sale
192	LAST_MARKET_SALE_BUYER_2_LAST	Buyer 2 last name associated with the latest market sale
193	LAST_MARKET_SALE_BUYER_2_CODE	Buyer 2 code associated with the latest market sale of a property. Refer to the LAST_MARKET_SALE_BUYER_2_CODE_DESC field for the corresponding description.
194	LAST_MARKET_SALE_BUYER_2_CODE_DESC	Description of LAST_MARKET_SALE_BUYER_2_CODE field.
195	LAST_MARKET_SALE_RCDRS_MAP_REF	The map number assigned by the county assessor associated with the latest market sale.
196	LAST_MARKET_SALE_TRAN_TYPE	Code indicating the deed transaction type. Refer to LAST_MARKET_SALE_TRAN_TYPE_DESC for the corresponding description.
197	LAST_MARKET_SALE_BUYER_VESTING_CODE	Code indicating how the buyers took title of the subject property during the latest market sale. Refer to the LAST_MARKET_SALE_BUYER_VESTING_CODE_DESC field for the corresponding description.
198	LAST_MARKET_SALE_BUYER_VESTING_CODE_DESC	Description of LAST_MARKET_SALE_BUYER_VESTING_CODE field.
199	LAST_MARKET_SALE_ORIGINAL_SALE_DATE	The last market sale date.
200	LAST_MARKET_SALE_TRAN_TYPE_DESC	Description of the LAST_MARKET_SALE_TRAN_TYPE field.
201	LAST_MARKET_SALE_SALE_CODE	The code indicating the methodology used to determine the price of the last market sale (VAL_TRANSFER). Refer to LAST_MARKET_SALE_SALE_CODE_DESC field for the corresponding description.
202	LAST_MARKET_SALE_SALE_CODE_DESC	Description of the LAST_MARKET_SALE_SALE_CODE field.
203	LAST_MARKET_SALE_FULL_PART_CODE	Code that inventories %ownership transfer when less than 100% ownership interest is transferred by the recorded instrument. For example, a partner sells only his 50% interest. This also applies to transfers where the Grantors entire ownership interest is LESS than 100%. For example, the Grantor conveys all of his interest in the property, which is a 25% interest. When the percentage is a single digit (1-9), it is preceded with a zero: 5% = 05. When interest shown is a whole number plus a value after the decimal or fraction, it is rounded to nearest whole number only: 75.5% = 76; 33 1/3% = 33, etc.
204	LAST_MARKET_SALE_SOURCE_CODE	The code indicating the source associated with the last market sale of a property. D=DEED; A=ASSESSMENT
205	GEOMETRY_SOURCE	Indicates method use to geocode property point location
206	GEOMETRY	Point geometry of the property location

Buildings

ID	Field Names	Description
1	BUILDING_LID	A proprietary LightBox identifier for building that is unique and persistent.
2	FIPS_CODE	The 5-digit FIPS code where the first two digits identify the state and the last three digits identify the county.
3	COUNTY	The name of the county.
4	AREA_SQFT	The building footprint area in square feet
5	HEIGHT_MIN_FT	The minimum building height in feet
6	HEIGHT_AVG_FT	The average building height in feet
7	HEIGHT_MAX_FT	The maximum building height in feet
8	GROUND_ELEVATION_MIN_FT	The minimum building ground elevation in feet
9	GROUND_ELEVATION_AVG_FT	The average building ground elevation in feet
10	GROUND_ELEVATION_MAX_FT	The maximum building ground elevation in feet
11	PRIMARY_ADDRESS_LID	The primary address associated with the building
12	PRIMARY_PARCEL_LID	The primary parcel that the building overlaps
13	UBID	Legacy Building ID: based on spatial location and extents of the building polygon. Added on version 20221015.
14	BF_STORIES_NUMBER	A modeled value that estimates the number of stories (floors) in a building by using the building’s height and property type as an input into the model
15	BF_BLDG_AREA	A modeled value that estimates the building’s square footage found in a building using the modeled number of stories (BF_STORIES_NUMBER) and the building’s planimetric area as input into the model
16	GEOMETRY	The building polygon geometry

Addresses

ID	Field Names	Description
1	ADDRESS_LID	A proprietary LightBox identifier for address that is unique and persistent.
2	FIPS_CODE	The 5-digit FIPS code where the first two digits identify the state and the last three digits identify the county.
3	COUNTY	The name of the county.
4	STATE	The two-character abbreviation for a US state.
5	CITY	The name of the city.
6	ADDRESS	The house number, street prefix direction, street name, street suffix, street suffix direction all formatted as a single line.
7	HOUSE_NUMBER	The address numbers, letters, and separators. (ex: the '123A' in '123A Main St'.)
8	PREFIX_DIRECTION	The street prefix direction (ex: N,S,E,W)
9	PREFIX_TYPE	The street prefix name (ex: Rue, Ave)
10	STREET_NAME	The street name without types or directions. (ex: the 'Main' in '123 Main St')
11	SUFFIX_TYPE	The street suffix type. (ex: Avenue, Street)
12	SUFFIX_DIRECTION	The street suffix direction (ex: N,S,E,W)
13	UNIT	The unit type and unit value. (ex: 'Apt A')
14	ZIP	The zip code including the first five digits along with the zip4 extension, where available.
15	COUNTRY_CODE	The two-character country code (US, CA).
16	RESBUS_USPS	A USPS field classifying an address as Business, Residential, Unknown, or NULL.
17	PRECISION_CODE	Address Location Precision: 1. BC for building centroid; 2. PC for parcel centroid; 3. BEP for building entry point; 4. BIP for building interior point associated with a specific unit or other designation within the building; 5. STR for street interpolated; 6. BGC for the centroid of a group of buildings.
18	IS_PRIMARY_ADDRESS	A True/False value indicating if the address the main address used for that location. The primary address is a proprietary LightBox classifier reserved for the most important address associated with a location. Primary addresses typically do not have secondary unit information.
19	PRIMARY_ADDRESS_LID	The address_LID for the related primary address for the location if the address is not a primary address. The primary_address_lid may be equal to the parent_address_lid if the record is a secondary address.
20	PARENT_ADDRESS_LID	The address_LID for the related parent address when the address is a child address. Child addresses will also have a related primary_address_LID which may or may not be equal to the parent_address_LID.
21	CENSUS_CODE	A 15-digit code that uniquely identifies a census block using the following schema: 2-digit state fips code + 3-digit county fips code + 6-digit Census tract code + 4-digit Census block code
22	BUILDING_NAME_USPS	The name of the structure containing the address, provided by USPS. This field is sparsely populated; most values pertain to large commercial buildings.
23	ADDRESS_CONFIDENCE_SCORE	A number ranging from 1 (low confidence) to 5 (high confidence) indicating the likelihood that an address exists and if it’s used or can be used.
24	LATITUDE	latitude
25	LONGITUDE	longitude
26	GEOMETRY	The spatial point location (latitude and longitude) of the address.

Was this article helpful?

What's Next

LightBox API Documentation

Table of contents