Data dictionary

We extract, clean, and transform all property data we receive into The Memphis Property Hub schema detailed below.

#	Column Name	Column Description	Data Format	Data Source	Update Frequency	Sample Data
1	parid	parcel id	string	Assessor Certified Roll - Property	yearly	029042 00037
2	parid_key	standardized parcel id that formats parid consistently across agencies	string	Assessor Certified Roll - Property	yearly	02904200000370
3	taxyr	Assessor tax year	integer	Assessor Certified Roll - Property	yearly	2025
4	address	parcel street address	string	Assessor Certified Roll - Property	yearly	2232 ZANONE AVE
5	addr_num	parcel street address number, used for zooming in on parcels	string	Assessor Certified Roll - Property	yearly	2232
6	city	parcel city	string	Assessor Certified Roll - Legal	yearly	MEMPHIS
7	state	parcel state	string	derived in script (all Shelby County properties are located in Tennessee)	yearly	TN
8	parzip	parcel zipcode	string	Assessor Certified Roll - Property	yearly	38114
9	year_built	year structure built	integer	Assessor Certified Roll - Dwellings & Commercial	yearly	null
10	dwel_sfla	square footage of dwelling area	integer	Assessor Certified Roll - Dwellings	yearly	null
11	propclass	property class code defined by its use, e.g. residential, industrial, commercial, farm, exempt	string	Assessor Certified Roll - Property	yearly	R
12	propclassdesc	human readable description of property class code defined by its use, e.g. residential, industrial, commercial, farm, exempt	string	Assessor Certified Roll - Property	yearly	RESIDENTIAL
13	prop_luc	numerical code designating specific use of land according to professional standards and contains detailed categories such as single and multi-family dwellings, offices, agricultural land etc.; assists planners with analyzing land use patterns and change	string	Assessor Certified Roll - Property	yearly	0
14	prop_lucdesc	human readable description of land use codes	string	Assessor Certified Roll - Property	yearly	VACANTLAND
15	land_use_category	land use category is a broader categorization of land use codes to simplify analysis	string	Transformation using Assessor Certified Roll - Property	yearly	Vacant Land
16	living_units	total living units for property whether it is a dwelling or an apartment	integer	Assessor Certified Roll - Property, Commerical	yearly	1
17	living_units_category	total living units categorized: 0 units, 1 unit, 2 units, 3-4 units, 5-12 units, 13-49 units, 50-149 units, 150-249 units, 250+ units	string	Assessor Certified Roll - Property, Commerical	yearly	5-12 units
18	zon_code	codes used to identify the use allowed in a physical geographic area; designed to promote the health, safety, and welfare of the public by regulating land use and development	string	Assessor Certified Roll - Property	yearly	RU-1
19	zon_code_desc	human readable description of zoning code	string	Assessor Certified Roll - Property	yearly	RESIDENTIALURBAN1
20	acres	total acres of parcel	decimal	Assessor Certified Roll - Legal	yearly	0.14
21	lot_dim	lot dimensions of parcel	string	Assessor Certified Roll - Legal	yearly	50 X 125
22	legal_subdiv	legal subdivision of property	string	Assessor Certified Roll - Legal	yearly	PARK AVE HTS
23	total_assessment	total tax assessed as a percentage of the parcel's appraisal value based on land and structures	integer	Assessor Certified Roll - Assessment	yearly	1125
24	total_assmt_per_acre	total assessed value divided by total acreage of the parcel	decimal	Assessor Certified Roll - Assessment, Legal	yearly	10.05
25	land_assessment	assessed value of just the land	integer	Assessor Certified Roll - Assessment	yearly	125
26	land_assmt_per_acre	assessed value of just the land divided by total acreage of the parcel	decimal	Assessor Certified Roll - Assessment, Legal	yearly	1.05
27	building_assessment	assessed value of just the building/structures	integer	Assessor Certified Roll - Assessment	yearly	1000
22	total_appraisal	total appraised value of property based on land and structures	integer	Assessor Certified Roll - Assessment	yearly	4500
23	change_in_value	percent change in appraised property from prior tax year to current tax year	decimal	Assessor Certified Roll - Assessment	yearly	80
24	change_in_assmnt_10year	change in assessed value over the past 10 years	decimal	Assessor Certified Roll - Assessment	yearly	1000.00
25	change_in_asmtland_10year	change in assessed value (land only) over the past 10 years	decimal	Assessor Certified Roll - Assessment	yearly	500.00
26	change_in_asmtbldg_10year	change in assessed value (building only) over the past 10 years	decimal	Assessor Certified Roll - Assessment	yearly	500.00
27	valuation_data_last_modified	most recent date the Assessor's Assessment table was updated	timestamp	Assessor Certified Roll - Assessment	yearly	2020-06-11T00:00:00.000+00:00
28	most_recent_sale	date of most recent property sale recorded for the parcel	timestamp	Assessor Certified Roll - Sale	yearly	2020-06-11T00:00:00.000+00:00
29	most_recent_sale_price	sale price of most recent property sale recorded for the parcel	decimal	Assessor Certified Roll - Sale	yearly	400214.00
30	months_since_last_sold	number of months since the most recent property sale recorded for the parcel	integer	Assessor Certified Roll - Sale	yearly	48
31	sales_1yr	total aggregate sales of the parcel in last 12 months from sale_data_last_modified_date	integer	Assessor Certified Roll - Sale	yearly	0
32	sales_5yr	total aggregate sales of the parcel in the last five years from sale_data_last_modified_date	integer	Assessor Certified Roll - Sale	yearly	1
33	total_sales	total aggregate of all recorded sales of the parcel property between 1757 and latest tax year.	integer	Assessor Certified Roll - Sale	yearly	5
34	sales_data_last_modified	most recent date the Assessor's Sale table was updated	timestamp	Assessor Certified Roll - Sale	yearly	2020-06-11T00:00:00.000+00:00
35	occupancy_status	occupancy status of property - see Data Rules for more details	string	USPS Vacancy	yearly	Vacant
36	vacant_since	date of earliest recorded vacancy - see Data Rules for more details	date	USPS Vacancy	quarterly	4/1/2024
37	months_vacant	number of months since last recorded vacancy - see Data Rules for more details	double	USPS Vacancy	quarterly	16
38	long_term_vacancy	long term vacancy - see Data Rules for more details	string	USPS Vacancy	quarterly	Long Term Vacant
39	occupancy_data_last_modified	most recent date the USPS Vacancy data table was updated	timestamp	USPS Vacancy	quarterly	2025-06-11T00:00:00.000+00:00
40	eviction_filing_date	date of most recent eviction filed - see Data Rules for more details	timestamp	General Sessions Court Eviction Filings	monthly	2020-06-11T00:00:00.000+00:00
41	evictions_6mo	total evictions over 6 months from eviction_data_last_modified_date - see Data Rules for more details	integer	General Sessions Court Eviction Filings	monthly	0
42	evictions_1yr	total evictions over 1 year from eviction_data_last_modified_date - see Data Rules for more details	integer	General Sessions Court Eviction Filings	monthly	0
43	total_evictions	total evictions since 1/1/2016 - see Data Rules for more details	integer	General Sessions Court Eviction Filings	monthly	0
44	evictions_data_last_modified	most recent date the evictions data table was updated	timestamp	General Sessions Court Eviction Filings	monthly	2025-06-11T00:00:00.000+00:00
45	service_req_6mo	total 311 service requests over 6 months from evictions_data_last_modified_date	integer	City of Memphis Public Works Requests	monthly	0
46	service_req_1yr	total 311 service requests over 1 year from evictions_data_last_modified_date	integer	City of Memphis Public Works Requests	monthly	0
47	total_service_req	total 311 service requests from 1/1/2016	integer	City of Memphis Public Works Requests	monthly	6
48	sr_data_last_updated	most recent date the public works data table was updated	timestamp	City of Memphis Public Works Requests	monthly	2025-06-11T00:00:00.000+00:00
49	permit_cost_1year	total cost of permits in the last year from evictions_data_last_modified_date	double	Dev901 Accela Building & Demolition Permits	monthly	0
50	demo_permit_1year	total number of demolition permits in last year from evictions_data_last_modified_date	integer	Dev901 Accela Building & Demolition Permits	monthly	0
51	building_permit_1year	total number of building permits in last year from evictions_data_last_modified_date	integer	Dev901 Accela Building & Demolition Permits	monthly	0
52	total_permit_cost	total cost of all permits at property since 01/03/2011	decimal	Dev901 Accela Building & Demolition Permits	monthly	15000
53	total_permit_cost_10years	total cost of all permits at property over the past 10 years	decimal	Dev901 Accela Building & Demolition Permits	monthly	15000
54	total_demo_permit_cost	total cost of all demolition permits at property since 01/03/2011	decimal	Dev901 Accela Building & Demolition Permits	monthly	10000.00
55	total_building_permit_cost	total cost of all building permits at property since 01/03/2011	decimal	Dev901 Accela Building & Demolition Permits	monthly	5000.00
56	total_permits	total number of all permits at property since 01/03/2011	integer	Dev901 Accela Building & Demolition Permits	monthly	2
57	total_permits_1year	total number of permits at property over the past year	integer	Dev901 Accela Building & Demolition Permits	monthly	1
58	total_permits_10years	total number of permits at property over the past 10 years	integer	Dev901 Accela Building & Demolition Permits	monthly	2
59	most_recent_permit_date	Date of the most recent permit	timestamp	Dev901 Accela Building & Demolition Permits	monthly	2025-06-11T00:00:00.000+00:00
60	demo_permit_10years	total number of demolition permits at property over the past 10 years	integer	Dev901 Accela Building & Demolition Permits	monthly	1
61	building_permit_10years	total number of demolition permits at property over the past 10 years	integer	Dev901 Accela Building & Demolition Permits	monthly	1
62	permit_data_last_updated	most recent date the permits data table was updated	timestamp	Dev901 Accela Building & Demolition Permits	monthly	2025-06-11T00:00:00.000+00:00
63	owner_occupied	owner-occupied property - see Data Rules for more details	string	Assessor Certified Roll - Property, Property Owner, Apartments, Legal	yearly	N
64	investor_owned	investor-owned property - see Data Rules for more details	string	Assessor Certified Roll - Property, Property Owner, Apartments, Legal	yearly	N
65	owner_location	local vs non local status of property owner - see Data Rules for more details	string	Assessor Certified Roll - Property, Property Owner, Apartments, Legal	yearly	Local
66	owner_geography	location category of property owner - see Data Rules for more details	string	Assessor Certified Roll - Property, Property Owner, Apartments, Legal	yearly	City
67	owner_type	type of property ownership - see Data Rules for more details	string	Assessor Certified Roll - Property, Property Owner, Apartments, Legal	yearly	Company
68	owner_name	property owner name of record	string	Assessor Certified Roll - Property Owner	yearly	MEMPHIS 38104 LLC
69	own_addr	property owner street address of record	string	Assessor Certified Roll - Property Owner	yearly	1041 S COX ST
70	own_cityname	property owner city of record	string	Assessor Certified Roll - Property Owner	yearly	MEMPHIS
71	own_statecode	property owner state of record	string	Assessor Certified Roll - Property Owner	yearly	TN
72	own_zip	property owner zip code of record	string	Assessor Certified Roll - Property Owner	yearly	38104
73	owner_data_last_modified	most recent date the Assessor's Property Owner data table was updated	timestamp	Assessor Certified Roll - Property Owner	yearly	2020-06-11T00:00:00.000+00:00
74	bcs_survey_year	most recent year of bluff city snapshot survey data	string	Bluff City Snapshot Survey	intermittent	2015
75	bcs_property_rating	most recent property image from bluff city snapshot 2015 or 2020	integer	Bluff City Snapshot Survey	intermittent	2
76	bcs_property_image	most recent property image from bluff city snapshot 2015 or 2020	hyperlink	Bluff City Snapshot Survey	intermittent	https://memparcel-photos.s3.amazonaws.com/photos/bcs/02904200037-IMG2015-10-12T19%3A38%3A07.136Z-833.jpg
77	property_address	full parcel address including city, state, zip that is standardized and geocoded - see Data Rules for more details	string	Geocoded and formatted using ArcGIS	yearly	2232 Zanone Ave, Memphis, Tennessee, 38114
78	owner_address	full address of property owner including city, state, zip that is standardized and geocoded - see Data Rules for more details	string	Geocoded and formatted using ArcGIS	yearly	1041 S Cox St, Memphis, Tennessee, 38104
79	council_district	memphis city coucil district id	string	Transformation using data from City of Memphis Data Hub	as needed	4
80	commission_district	shelby county commission district id	string	Transformation using data from City of Memphis Data Hub	as needed	9
81	zipcode	zip code tabulation area id 2022	string	Transformation using data from City of Memphis Data Hub	as needed	38114
81	super_district	memphis city council super district id	string	Transformation using data from City of Memphis Data Hub	as needed	8
82	tract_2020	cencus tract geoid 2020	string	Transformation using data from Census	decennial	47157006600
83	tract_2010	cencus tract geoid 2010	string	Transformation using data from Census	decennial	47157006600
84	tract_2000	cencus tract geoid 2000	string	Transformation using data from Census	decennial	47157006600
85	lat	latitude	string	Geocoded using ArcGIS	yearly	35.11178766
86	lon	longitude	string	Geocoded using ArcGIS	yearly	-89.98819913
87	cent_geopoint	combined latitude, longitude	string	Transformation of ArcGIS Geocoded data	yearly	35.11178766,-89.98819913
88	centroid	center point of shapefile polygon	string	Transformation using Assessor Certified Roll	yearly	POINT (-89.98819912526677 35.111787664366766)
89	h3_index	powerful and efficient way to organize and analyze location-based data by dividing the Earth into a system of hierarchical hexagonal cells	string	Transformation using Assessor Certified Roll	yearly	8f2659a056d2093
90	geometry	shapefile geometry	string	Assessor Certified Roll	yearly	POLYGON ((-89.98810895613269 35.11195638094608, -89.98811155018404 35.11187387538133, -89.98811968907393 35.11161345946176, -89.98828852836989 35.111619059788886, .....))