# Metadata

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

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

* 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-midsouth-portal/features/downloads-and-formats.md)).

**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.**

{% hint style="info" %}
**Always read the limitations note**. It tells you exactly what the data can and can't be used to conclude.
{% endhint %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.datamidsouth.org/data-midsouth-portal/data-reference/metadata.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.