Data dictionary
We extract, clean, and transform all property data we receive into The Memphis Property Hub schema detailed below.
parid
Parcel ID
string
assessor_land_housing.property
yearly
parid_key
Parcel ID standardized key
string
assessor_land_housing.property
yearly
taxyr
assessor tax year
int
assessor_land_housing.property
yearly
address
parcel address
string
assessor_land_housing.property
yearly
city
parcel city
string
assessor_land_housing.property_legal
yearly
state
parcel state
string
derived in script
yearly
parzip
parcel zipcode
string
assessor_land_housing.property
yearly
year_built
year built
int
assessor_land_housing.property_dwellings; assessor_land_housing.property_commercial
yearly
dwel_sfla
square footage of dwelling area
int
assessor_land_housing.property_dwellings
yearly
propclass
property class
string
assessor_land_housing.property
yearly
prop_luc
land use code
string
assessor_land_housing.property
yearly
prop_lucdesc
land use code description
string
assessor_land_housing.property
yearly
lu_category
land use category
string
assessor_land_housing.property
yearly
prop_livunit
total living units for property
int
assessor_land_housing.property
yearly
zon_code
zoning code of parcel
string
assessor_land_housing.property
yearly
acres
total acres of parcel
int
assessor_land_housing.property_legal
yearly
lot_dim
dimensions of parcel
string
assessor_land_housing.property_legal
yearly
legal_subdiv
legal subdivision of property
string
assessor_land_housing.property_legal
yearly
total_appraisal
total appraised value of property
int
assessor_land_housing.land_property_assessment
yearly
total_assessment
tax assessed
int
assessor_land_housing.land_property_assessment
yearly
percent_change_appraisal
change in appraisal - prior year to current year
double
assessor_land_housing.land_property_assessment
yearly
owner1name
property owner name of record
string
assessor_land_housing.property_owner
yearly
own_addr
property owner address of record
string
assessor_land_housing.property_owner
yearly
own_cityname
property owner city of record
string
assessor_land_housing.property_owner
yearly
own_statecode
property owner state of record
string
assessor_land_housing.property_owner
yearly
own_zip
property owner zip code of record
string
assessor_land_housing.property_owner
yearly
sales_1yr
total aggregate sales - one year
bigint
assessor_land_housing.property_sale
yearly
sales_5yr
total aggregate sales - five years
bigint
assessor_land_housing.property_sale
yearly
total_sales
total aggregate sales - all time
bigint
assessor_land_housing.property_sale
yearly
investor_owned
investor-owned property
string
assessor_land_housing.property; assessor_land_housing.property_owner
yearly
local_investor_individual
string
yearly
local_investor_corporate
string
yearly
non_local_corporate_investor
string
yearly
evictions_6mo
total evictions over 6 months
bigint
mem_property_hub.eviction_court_cases
evictions_1yr
total evictions over 1 year
bigint
mem_property_hub.eviction_court_cases
total_evictions
total evictions
bigint
mem_property_hub.eviction_court_cases
long_term_vacant
long term vacancy
string
mem_property_hub.usps_vacancy
service_req_6mo
total 311 service requests over 6 months
bigint
mem_property_hub.public_works_request
service_req_1yr
total 311 service requests over 1 year
bigint
mem_property_hub.public_works_request
total_service_req
total 311 service requests
bigint
mem_property_hub.public_works_request
building permits
bigint
mem_property_hub.building_permits_demo
demolition permits
bigint
mem_property_hub.building_permits_demo
permit cost
bigint
mem_property_hub.building_permits_demo
land_bank
land bank property
string
npa
neighborhood preservation act court case
string
property_image
most recent property image from bluff city snapshot 2015 or 2020
hyperlink
mem_property_hub.bluff_city_snapshot_survey
intermittent
bcs_image_2015
property image from bluff city snapshot 2015
hyperlink
mem_property_hub.bluff_city_snapshot_survey
intermittent
bsc_2015_rating
bigint
mem_property_hub.bluff_city_snapshot_survey
intermittent
bcs_image_2020
property image from bluff city snapshot 2020
hyperlink
mem_property_hub.bluff_city_snapshot_survey
intermittent
bsc_2020_rating
bigint
mem_property_hub.bluff_city_snapshot_survey
intermittent
full_address
full parcel address including city, state, zip
string
assessor_land_housing.property
yearly
own_full_addr
full address of property owner including city, state, zip
string
assessor_land_housing.property_owner
yearly
tract_2020
cencus tract geoid 2020
string
geometry_bridge.parcels_geobridge
decennial
tract_2010
cencus tract geoid 2010
string
geometry_bridge.parcels_geobridge
decennial
tract_2000
cencus tract geoid 2000
string
geometry_bridge.parcels_geobridge
decennial
council_district
memphis city counil district id
string
geometry_bridge.parcels_geobridge
commission_district
shelby county commission district id
string
geometry_bridge.parcels_geobridge
zip_code_2022
zip code tabulation area id 2022
string
geometry_bridge.parcels_geobridge
super_district
memphis city counil super district id
string
geometry_bridge.parcels_geobridge
geo_id
string
geometry_bridge.master_shapefile
yearly
lat
string
geometry_bridge.master_shapefile
yearly
lon
string
geometry_bridge.master_shapefile
yearly
cent_geopoint
string
geometry_bridge.master_shapefile
yearly
centroid
centerpoint of shapefile
string
geometry_bridge.master_shapefile
yearly
h3_index
string
geometry_bridge.master_shapefile
yearly
geometry
shapefile geometry
string
geometry_bridge.master_shapefile
yearly
Last updated
Was this helpful?