Data Dictionary - Loveland Standardized Schema
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
FieldTypeExamplesDescription
First seen
2
wkb_geometrybinaryThe Well Known Binary (wkb) representation of the parcel shape. Shapes are in WGS 84 / EPSG:4326 CRS1.0
3
ogc_fidserial primary keyobject ID1.0
4
geoidtextFIPS code (state + county FIPS codes)1.0
5
sourceagenttextSource Agent1.0
6
parcelnumbtext2004940Parcel ID/Parcel Number1.0
7
usecodetext104Parcel Use Code1.0
8
usedesctextResidentialParcel Use Description1.0
9
zoningtextR-1Governing municipality's zoning code2.0
10
zoning_descriptiontextResidentialGoverning municipality's zoning code description2.0
11
structbooleanStructure On Parcel1.0
12
multistructbooleanMultiple Structures on Parcel1.0
13
structnointegerNumber of Structures on Parcel1.0
14
yearbuiltintegerStructure Year Built1.0
15
numstoriesdouble precisionNumber of Stories1.0
16
numunitsintegerNumber of Units1.0
17
structstyletextStructure Style1.0
18
parvaltypetext
Appraised, Assessed, Taxable, Market, Market Value
Parcel Value Type1.0
19
improvvaldouble precisionImprovement Value - in US Dollars1.0
20
landvaldouble precisionLand Value - in US Dollars1.0
21
parvaldouble precisionTotal Parcel Value - in US Dollars1.0
22
agvaldouble precisionAgricultural Value - in US Dollars1.0
23
salepricedouble precisionLast Sale Price - in US Dollars1.0
24
saledatedateLast Sale Date1.0
25
taxamtdouble precisionAnnual Tax Bill - in US Dollars1.0
26
owntypetextOwner Type1.0
27
ownertextOwner Name1.0
28
ownfrsttextOwner First Name (note field name uses "frst" instead of first.)1.0
29
ownlasttextOwner Last Name1.0
30
owner2textRosalind FranklinSecond owner's name2.0
31
owner3textAda LovelaceThird owner's name2.0
32
owner4textBarbara McClintockFourth owner's name2.0
33
subsurfowntextSubsurface Owner1.0
34
subowntypetextSubsurface Owner Type1.0
35
mailaddtext402 S FOURTH AVE, ANN ARBOR, MI, 48104Owner Mailing Address1.0
36
mail_address2textAPT # 2Mailing address second line2.0
37
careoftextMIKE SMITHOwner Mailing Address Care Of3.0
38
mail_addnotext402Mailing address street number2.0
39
mail_addpreftextSMailing address street prefix2.0
40
mail_addstrtextFOURTHMailing address street name2.0
41
mail_addsttyptextAVEMailing address street type2.0
42
mail_addstsuftextNWMailing address street suffix2.0
43
mail_unittextAPT # 2Mailng address unit number2.0
44
mail_citytextAnn ArborMailing address city2.0
45
mail_state2textMIMailing address state2.0
46
mail_ziptext48103; 48104-3423Mailing address zip code2.0
47
mail_urbanizationtextCaguasMailing Urbanización (Puerto Rico)2.0
48
addresstext12109 KATZ RDSite Address1.0
49
address2textApt 2, Unit B, 6th floorAdditional mailing address details2.0
50
original_addresstext12109 Katz Rd; NW; Ann Arbor; MI; 48105Address fields as originally provided by the county, separated by a semicolon and a space2.0
51
saddnotext12109Site Address Number1.0
52
saddpreftextNSite Address Prefix1.0
53
saddstrtextGLENNSite Address Street Name1.0
54
saddsttyptextRDSite Address Street Type1.0
55
saddstsuftextNWSite Address Street Suffix1.0
56
sunittextSite Address Unit1.0
57
scitytextGRASS LAKESite Address City1.0
58
citytextUS Census County Subdivision - https://www2.census.gov/geo/pdfs/reference/GARM/Ch8GARM.pdf1.0
59
countytextSite Address County1.0
60
state2textMISite Address State1.0
61
sziptext49240Site Address Zip Code1.0
62
urbanizationtextCaguasSite Urbanización (Puerto Rico)2.0
63
location_nametextBriarwood MallA name commonly associated with this parcel2.0
64
address_sourcetestopenaddresses;accuzip;county;ZCTAPrimary source of the address data for this row. Default source if none is listed is the county.2.0
65
legaldesctextLegal Description1.0
66
plattextAPlat number the parcel is recorded on2.0
67
booktext231Book/Liber the parcel is recorded in2.0
68
pagetext2Page/Folio the parcel is recorded on2.0
69
blocktextParcel block2.0
70
lottextParcel lot2.0
71
neighborhoodtextOld West SideNeighborhood name2.0
72
subdivisiontextSubdivision1.0
73
census_blocktext2010 Census block2.0
74
census_blockgrouptext2010 Census blockgroup2.0
75
census_tracttext2010 Census tract2.0
76
sourcereftextSource Document Reference1.0
77
sourcedatedateSource Document Date1.0
78
sourceurltextSource URL1.0
79
recrdareatxtextRecorded Area (text)1.0
80
recrdareanodouble precisionRecorded Area (number)1.0
81
gisacredouble precisionAcres1.0
82
sqftnumericParcel Square Feet3.0
83
reviseddatedateThe last date of last revision as provided by the county assessor's office if available. 1.0
84
pathtext/us/mi/wayne/detroit/123, /us/fl/456Loveland unique, human-readable ID for this parcel. Not guarnteed to be stable between updates.1.0
85
ll_stable_idtext
Boolean, "preserved" or null, "preserved" if unchanged.
Indicates if the 'path' value has changed during the last refresh from the county.2.0
86
ll_uuiduuid4cc9eda6-883c-4f38-9a07-b44900a64b16Uniquely identifies a single parcel with a v4 uuid. This is a stable parcel id across county data refreshes and is the value that should be used for tracking indiviual parcels.3.0
87
ll_updated_attimestamptz2019-06-06 12:45:21.285102-04Timestamp of last update of any kind to this row, internal changes to row, and/or county updates.3.0
88
dpv_statustextV/NUSPS delivery point validation status code2.0
89
dpv_codestextDetailed delivery point validation codes2.0
90
dpv_notestextDelivery point validation notes2.0
91
dpv_typetextH (High Rise), S (Street)Type of the delivery point match2.0
92
cass_errornotextCASS Certification error codes2.0
93
rditextResidential, CommercialResidential Delivery Indicator2.0
94
usps_vacancytextY for VacantUSPS vacancy indicator2.0
95
usps_vacancy_datedateDate the vacancy indicator was collected2.0
96
lbcs_activitynumeric
1000,2000,3000 (100% standardized values, see url)
Actual use of land: farming, shopping, manufacturing. See https://www.planning.org/lbcs/standards/activity.htm2.0
97
lbcs_functionnumeric
1000,2000,3000 (100% standardized values, see url)
Economic function or type of establishment: agricultural, commercial, industrial. See https://www.planning.org/lbcs/standards/function.htm2.0
98
lbcs_structurenumeric
1000,2000,3000 (100% standardized values, see url)
Type of structure or building: single-family house, office building, warehouse. See https://www.planning.org/lbcs/standards/structure.htm2.0
99
lbcs_sitenumeric
1000,2000,3000 (100% standardized values, see url)
What is on the land. See https://www.planning.org/lbcs/standards/site.htm2.0
100
lbcs_ownershipnumeric
1000,2000,3000 (100% standardized values, see url)
Ownership structure: public, private. See https://www.planning.org/lbcs/standards/ownership.htm2.0
Loading...