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	city	parcel city	string	Assessor Certified Roll - Legal	yearly	MEMPHIS
6	state	parcel state	string	derived in script (all Shelby County properties are located in Tennessee)	yearly	TN
7	parzip	parcel zipcode	string	Assessor Certified Roll - Property	yearly	38114
8	year_built	year structure built	integer	Assessor Certified Roll - Dwellings & Commercial	yearly	null
9	dwel_sfla	square footage of dwelling area	integer	Assessor Certified Roll - Dwellings	yearly	null
10	propclass	property class code defined by its use, e.g. residential, industrial, commercial, farm, exempt	string	Assessor Certified Roll - Property	yearly	R
11	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
12	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
13	prop_lucdesc	human readable description of land use codes	string	Assessor Certified Roll - Property	yearly	VACANTLAND
14	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
15	living_units	total living units for property whether it is a dwelling or an apartment	integer	Assessor Certified Roll - Property, Commerical	yearly	null
16	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
17	zon_code_desc	human readable description of zoning code	string	Assessor Certified Roll - Property	yearly	RESIDENTIALURBAN1
18	acres	total acres of parcel	decimal	Assessor Certified Roll - Legal	yearly	0.14
19	lot_dim	lot dimensions of parcel	string	Assessor Certified Roll - Legal	yearly	50 X 125
20	legal_subdiv	legal subdivision of property	string	Assessor Certified Roll - Legal	yearly	PARK AVE HTS
21	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
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	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
25	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
26	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
27	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
28	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
29	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
30	occupancy_status	occupancy status of property - see Data Rules for more details	string	USPS Vacancy	yearly	Vacant
31	vacant_since	date of earliest recorded vacancy - see Data Rules for more details	date	USPS Vacancy	quarterly	4/1/2024
32	months_vacant	number of months since last recorded vacancy - see Data Rules for more details	double	USPS Vacancy	quarterly	16
33	long_term_vacancy	long term vacancy - see Data Rules for more details	string	USPS Vacancy	quarterly	Long Term Vacant
34	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
35	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
36	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
37	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
38	total_evictions	total evictions since 1/1/2016 - see Data Rules for more details	integer	General Sessions Court Eviction Filings	monthly	0
39	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
40	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
41	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
42	total_service_req	total 311 service requests from 1/1/2016	integer	City of Memphis Public Works Requests	monthly	6
43	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
44	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
45	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
46	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
47	total_permit_cost	total cost of all permits at property since 01/03/2011	decimal	Dev901 Accela Building & Demolition Permits	monthly	15000
48	total_permits	total number of all permits at property since 01/03/2011	integer	Dev901 Accela Building & Demolition Permits	monthly	2
49	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
50	owner_occupied	owner-occupied property - see Data Rules for more details	string	Assessor Certified Roll - Property, Property Owner, Apartments, Legal	yearly	N
51	investor_owned	investor-owned property - see Data Rules for more details	string	Assessor Certified Roll - Property, Property Owner, Apartments, Legal	yearly	N
52	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
53	owner_geography	location category of property owner - see Data Rules for more details	string	Assessor Certified Roll - Property, Property Owner, Apartments, Legal	yearly	City
54	owner_type	type of property ownership - see Data Rules for more details	string	Assessor Certified Roll - Property, Property Owner, Apartments, Legal	yearly	Company
55	owner_name	property owner name of record	string	Assessor Certified Roll - Property Owner	yearly	MEMPHIS 38104 LLC
56	own_addr	property owner street address of record	string	Assessor Certified Roll - Property Owner	yearly	1041 S COX ST
57	own_cityname	property owner city of record	string	Assessor Certified Roll - Property Owner	yearly	MEMPHIS
58	own_statecode	property owner state of record	string	Assessor Certified Roll - Property Owner	yearly	TN
59	own_zip	property owner zip code of record	string	Assessor Certified Roll - Property Owner	yearly	38104
60	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
61	bcs_survey_year	most recent year of bluff city snapshot survey data	string	Bluff City Snapshot Survey	intermittent	2015
62	bcs_property_rating	most recent property image from bluff city snapshot 2015 or 2020	integer	Bluff City Snapshot Survey	intermittent	2
63	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
64	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
65	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
66	council_district	memphis city coucil district id	string	Transformation using data from City of Memphis Data Hub	as needed	4
67	commission_district	shelby county commission district id	string	Transformation using data from City of Memphis Data Hub	as needed	9
68	zipcode	zip code tabulation area id 2022	string	Transformation using data from City of Memphis Data Hub	as needed	38114
69	super_district	memphis city council super district id	string	Transformation using data from City of Memphis Data Hub	as needed	8
70	tract_2020	cencus tract geoid 2020	string	Transformation using data from Census	decennial	47157006600
71	tract_2010	cencus tract geoid 2010	string	Transformation using data from Census	decennial	47157006600
72	tract_2000	cencus tract geoid 2000	string	Transformation using data from Census	decennial	47157006600
73	lat	latitude	string	Geocoded using ArcGIS	yearly	35.11178766
74	lon	longitude	string	Geocoded using ArcGIS	yearly	-89.98819913
75	cent_geopoint	combined latitude, longitude	string	Transformation of ArcGIS Geocoded data	yearly	35.11178766,-89.98819913
76	centroid	center point of shapefile polygon	string	Transformation using Assessor Certified Roll	yearly	POINT (-89.98819912526677 35.111787664366766)
77	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
78	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, .....))