Metadata

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, .....))

Standard metadata section expands on the basics: full title, description, themes, keywords, category, creation date, last update date, and creator.

• This is the information to reference when citing the dataset in a report or grant application.

Application and Case Studies section surfaces context that helps you understand how the data has been or could be used. It includes use cases, relevant case studies, and related reports.

• If you're building a grant narrative or researching a topic, this section can save you significant time — the related reports are linked directly.

Contact and Support Information lists the agency website (memphistn.gov) and any available user support materials. For questions, use the key contact email in the sidebar.

Data Asset section contains the practical details for working with the data: years available, access type (whether the data lives directly on the DMS portal, not on an external site), and data export formats (for more guidance, see Downloads & formats).

Data Quality and Limitations is one of the most important sections to read before using any dataset. It includes the Geographic level, Data limitations, and Data collection and cleaning methods.

Always read the limitations note. It tells you exactly what the data can and can't be used to conclude.