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, 48104Parcel Mailing Address1.0
36
mail_address2textAPT # 2Mailing address second line2.0
37
careoftextMIKE SMITHParcel 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; 48105Site Address 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.pdf. Used for organizational purposes. Refer to scity for the city associated with the site address.1.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_sourcetextopenaddresses;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
qoztextYes or NoIs this parcel in a US Federal Qualified Opportunity Zone4.0
74
qoz_tracttext30059000100, 30107000100Census tract number as it was defined in Dec 2018 when QOZs were designated.
Data from: https://www.cdfifund.gov/Pages/Opportunity-Zones.aspx
https://www.irs.gov/newsroom/opportunity-zones-frequently-asked-questions
4.0
75
census_blocktext2010 Census block2.0
76
census_blockgrouptext2010 Census blockgroup2.0
77
census_tracttext2010 Census tract2.0
78
sourcereftextA county provided reference for the parcel record1.0
79
sourcedatedateA county provided date for the parcel record1.0
80
sourceurltextA county provided url to the county parcel record online1.0
81
recrdareatxtextRecorded Area (text) (depricated - to be removed)1.0
82
recrdareanodouble precisionRecorded Area (number) (depricated - to be removed)1.0
83
gisacredouble precisionAcres value provided by the source (depricated - to be renamed 'source_gisacre')1.0
84
ll_gisacredouble precisionParcel acres as calculated by Loveland from county parcel geometry5.0
85
sqftnumericParcel Square Feet value provided by the source (depricated - to be renamed 'source_sqft')3.0
86
ll_gissqftnumericParcel square feet as calculated by Loveland from supplied parcel geometry (not populated yet)5.0
87
ll_bldg_footprint_sqft
numericTotal building footprint in square feet as calculated by Loveland5.0
88
ll_bldg_countnumericTotal number of buildings on the parcel as calculated by Loveland5.0
89
reviseddatedateThe last date of last revision as provided by the county assessor's office if available. 1.0
90
pathtext/us/mi/wayne/detroit/123, /us/fl/456Landgrid human-readable ID for this parcel. Not guarnteed to be stable between updates.1.0
91
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
92
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
93
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
94
dpv_statustextV/NUSPS delivery point validation status code2.0
95
dpv_codestextDetailed delivery point validation codes2.0
96
dpv_notestextDelivery point validation notes2.0
97
dpv_typetextH (High Rise), S (Street)Type of the delivery point match2.0
98
cass_errornotextCASS Certification error codes2.0
99
rditextY/NResidential Delivery Indicator2.0
100
usps_vacancytextY for VacantUSPS vacancy indicator2.0
Loading...