The Loveland Parcel Schema

We clean and convert all parcel data we recieve into this standard schema. Some counties may include additional fields. Wherever possible, we include those in our exports, but we do not have a key available for those fields. Each tier includes all of the fields in any tiers below it.

Field Description Tier Datatype
ogc_fid Object ID basic serial primary key
geoid FIPS Code basic text
sourceagent Source Agent basic text
parcelnumb Parcel ID

Examples: 02004940, 001-020-4624-001

basic text
usecode Parcel Use Code

Examples: 104

standard text
usedesc Parcel Use Description

Examples: Residential

standard text
zoning Zoning Code

Examples: R-1

standard text
zoning_description Zoning Description

Examples: Residential

standard text
struct Structure on Parcel standard boolean
multistruct Multiple Structures on Parcel standard boolean
structno Number of Structures on Parcel standard integer
yearbuilt Structure Year Built standard integer
numstories Number of Stories standard double precision
numunits Number of Units standard integer
structstyle Structure Style standard text
parvaltype Parcel Value Type

Examples: Appraised, Assessed, Taxable, Market, Market Value

standard text
improvval Improvement Value standard double precision
landval Land Value standard double precision
parval Total Parcel Value standard double precision
agval Agricultural Value standard double precision
saleprice Last Sale Price standard double precision
saledate Last Sale Date standard date
taxamt Annual Tax Bill standard double precision
owntype Owner Type standard text
owner Owner Name basic text
ownfrst Owner First Name basic text
ownlast Owner Last Name basic text
owner2 Second Owner Name basic text
owner3 Third Owner Name basic text
owner4 Fourth Owner Name basic text
subsurfown Subsurface Owner standard text
subowntype Subsurface Owner Type standard text
mailadd Mailing Address standard text
mail_address2 Mailing Address Second Line standard text
careof Mailing Address Care Of standard text
mail_addno Mailing Address Street Number

Examples: 402

standard text
mail_addpref Mailing Address Street Prefix

Examples: S

standard text
mail_addstr Mailing Address Street Name

Examples: FOURTH

standard text
mail_addsttyp Mailing Address Street Type

Examples: AVE

standard text
mail_addstsuf Mailing Address Street Suffix

Examples: NW

standard text
mail_unit Mailing Address Unit Number

Examples: APT # 2

standard text
mail_city Mailing Address City

Examples: Ann Arbor

standard text
mail_state2 Mailing Address State

Examples: MI

standard text
mail_zip Mailing Address ZIP Code standard text
mail_country Mailing Address Country

Examples: US, Bolivia, Canada

standard text
mail_urbanization Mailing Address Urbanizacion (Puerto Rico) standard text
address Parcel Address

Examples: 12109 KATZ RD

basic text
address2 Parcel Address Second Line

Examples: Apt 2, Unit B, 6th floor

basic text
saddno Parcel Address Number

Examples: 12109

basic text
saddpref Parcel Address Prefix

Examples: N

basic text
saddstr Parcel Address Street Name

Examples: GLENN

basic text
saddsttyp Parcel Address Street Type

Examples: RD

basic text
saddstsuf Parcel Address Street Suffix

Examples: NW

basic text
sunit Parcel Address Unit basic text
scity Parcel Address City

Examples: GRASS LAKE

basic text
original_address Original Parcel Address

Examples: 12109 Katz Rd; NW; Ann Arbor; MI; 48105

basic text
city US Census County Subdivision basic text
county Parcel Address County basic text
state2 Parcel Address State

Examples: MI

basic text
szip Parcel Address Zip Code

Examples: 48103, 48104-3423

basic text
urbanization Parcel Urbanizacion basic text
location_name Location Name basic text
address_source Primary Address Source

Examples: -openaddresses -accuzip -county

basic text
legaldesc Legal Description standard text
plat Plat

Examples: A

standard text
book Book

Examples: 231

standard text
page Page

Examples: 2

standard text
block Block standard text
lot Lot standard text
neighborhood Neighborhood standard text
subdivision Subdivision standard text
qoz Federal Qualified Opportunity Zone

Examples: Yes, No

standard text
qoz_tract Qualified Opportunity Zone Tract Number

Examples: 30059000100, 30107000100

standard text
census_tract Census 2010 Tract standard text
census_block Census 2010 Block standard text
census_blockgroup Census 2010 Blockgroup standard text
sourceref Source Document Reference basic text
sourcedate Source Document Date basic date
sourceurl Source URL basic text
recrdareatx Recorded Area (text) standard text
recrdareano Recorded Area (number) standard double precision
gisacre County-Provided Acres standard double precision
sqft County-Provided Parcel Square Feet standard double precision
ll_gisacre Loveland Calculated Parcel Acres standard double precision
ll_gissqft Loveland Calculated Parcel Square Feet standard bigint
ll_bldg_footprint_sqft Loveland Calculated Building Footprint Square Feet premium integer
ll_bldg_count Loveland Calculated Building Count premium integer
cdl_raw Cropland Data Layer Raw Values

Examples: 36, 60.0, 75, 20.0, 87, 10.0, 190, 10.0

premium text
cdl_majority_category Cropland Data Layer Majority Category

Examples: Alfalfa

premium text
cdl_majority_percent Cropland Data Layer Majority Percent

Examples: 60.0

premium double precision
cdl_date Cropland Data Layer Date

Examples: 2021

premium text
reviseddate Date of Last Revision basic date
path Parcel Path

Examples: /us/mi/wayne/detroit/123, /us/ny/new-york/manhattan/375553

basic text
ll_stable_id Stable ID Status

Examples: preserved (if unchanged)

basic text
ll_uuid UUID

Examples: 4cc9eda6-883c-4f38-9a07-b44900a64b16

basic uuid
ll_updated_at Updated At

Examples: 2019-06-06 12:45:21.285102-04

basic timestamp with time zone
dpv_status USPS Delivery Point Validation

Examples: V, N

premium text
dpv_codes Delivery Point Validation Codes premium text
dpv_notes Delivery Point Validation Notes premium text
dpv_type Delivery Point Match Type

Examples: H (High Rise), S (Street)

premium text
cass_errorno CASS Error Codes premium text
rdi Residential Delivery Indicator

Examples: Y, N

premium text
usps_vacancy USPS Vacancy Indicator

Examples: Y

premium text
usps_vacancy_date USPS Vacancy Indicator Date premium date
lbcs_activity LBCS Activity Code standard numeric
lbcs_activity_desc LBCS Activity Code Description standard text
lbcs_function LBCS Function Code standard numeric
lbcs_function_desc LBCS Function Code Description standard text
lbcs_structure LBCS Structure Code standard numeric
lbcs_structure_desc LBCS Structure Code Description standard text
lbcs_site LBCS Site Code standard numeric
lbcs_site_desc LBCS Site Code Description standard text
lbcs_ownership LBCS Ownership Code standard numeric
lbcs_ownership_desc LBCS Ownership Code Description standard text