About this Dataset

Jefferson County KY Urban Heat Management Study

Click here to view the Metro Office of Sustainability web site about this study and here to view the complete report.

This data includes a land cover assessment for implementing the various scenarios that impact temperatures across Louisville. These include, by ½ kilometer grid cell, the percentage of deciduous forest, coniferous forest, mixed forest, grass, shrubbery, cropland, pastureland, barren land, impervious residential properties, impervious nonresidential properties, impervious streets, impervious surfaces at airports, other impervious surfaces, wooded wetland, wetland, and water. The data also show the mean average, minimum and maximum temperatures over the 2012 warm season (May – September), the number of deaths attributable to urban heat over the 2012 warm season, and the estimated avoided deaths that would be achieved by implementing the heat management scenarios. This data is available at the district level and not the entire county due to a lack of availabile health data due to small population within those cells.The distribution of grid cells is also included in the dataset, which covers Jefferson County, Kentucky. All data is presented in GIS format.Two sources of information were used to map land surface materials across Louisville. Parcel, roadway and other impervious surface information was provided by the Louisville/Jefferson County Information Consortium (LOJIC). Satellite-measured land use information was obtained from the US Geological Survey (USGS).

Attribute Definitions:

X: X coordinate of polygon vertex
Y: Y coordinate of polygon vertex
CELL_A: Grid cell area in square meters
KEYID: Unique identification code assigned to each grid cell
Heat_Death: Total number of heat related deaths over the 2012 warm season (May - September
WS_B_ApAvg: The mean average apparent temperature over 2012 warm season (May - September
WS_B_ApMin: The mean minimum apparent temperature over 2012 warm season (May - September
WS_B_ApMax: The mean maximum apparent temperature over 2012 warm season (May - September
Base_UHI: Number of heat related deaths attributable to the urban heat island over the 2012 warm season (May - September
CC_FST_DEC: Current Conditions Scenario percentage of deciduous forest in grid cell
CC_FST_CON: Current Conditions Scenario percentage of coniferous forest in grid cell
CC_FST_MIX: Current Conditions Scenario percentage of mixed forest in grid cell (this is not the sum of ‘Forest_Dec’ and ‘Forest_Con’ fields, but its own unique land cover
CC_GRASS: Current Conditions Scenario percentage of grass in grid cell
CC_SHRUB: Current Conditions Scenario percentage of shrub in grid cell
CC_PASTURE: Current Conditions Scenario percentage of pasture in grid cell
CC_CROP: Current Conditions Scenario percentage of crop in grid
CC_BARREN: Current Conditions Scenario percentage of barren in grid cell
CC_IPV_RS: Current Conditions Scenario percentage of impervious residential in grid cell
CC_IPV_NRS: Current Conditions Scenario percentage of impervious nonresidential in grid cell
CC_IPV_ST: Current Conditions Scenario percentage of impervious street in grid cell
CC_IPV_OTH: Current Conditions Scenario percentage of impervious other in grid cell (all remaining impervious cover not included in ‘IPV_RS’, ‘IPV_NRS’, ‘IPV_ST’, and ‘IPV_AP’)
CC_IPV_AP: Current Conditions Scenario percentage of impervious airport in grid cell
CC_IPV_WLW: Current Conditions Scenario percentage of wooded wetland areas in grid cell
CC_IPV_WL: Current Conditions Scenario percentage of wetland in grid cell
CC_IPV_WTR: Current Conditions Scenario percentage of water in grid cell
CM_FST_DEC: Cool Materials Scenario percentage of deciduous forest in grid cell
CM_FST_CON: Cool Materials Scenario percentage of coniferous forest in grid cell
CM_FST_MIX: Cool Materials Scenario percentage of mixed forest in grid cell (this is not the sum of ‘Forest_Dec’ and ‘Forest_Con’ fields, but its own unique land cover)
CM_GRASS: Cool Materials Scenario percentage of grass in grid cell
CM_SHRUB: Cool Materials Scenario percentage of shrub in grid cell
CM_PASTURE: Cool Materials Scenario percentage of shrub in grid cell
CM_CROP: Cool Materials Scenario percentage of crop in grid cell
CM_BARREN: Cool Materials Scenario percentage of barren in grid cell
CM_IPV_RS: Cool Materials Scenario percentage of impervious residential in grid cell
CM_IPV_NRS: Cool Materials Scenario percentage of impervious nonresidential in grid cell
CM_IPV_ST: Cool Materials Scenario percentage of impervious street in grid cell
CM_IPV_OTH: Cool Materials Scenario percentage of impervious other in grid cell (all remaining impervious cover not included in ‘IPV_RS’, ‘IPV_NRS’, ‘IPV_ST’, and ‘IPV_AP’)
CM_IPV_AP: Cool Materials Scenario percentage of impervious airport in grid cell
CM_IPV_WLW: Cool Materials Scenario percentage of wooded wetland areas in grid cell
CM_IPV_WL: Cool Materials Scenario percentage of wetland in grid cell
CM_IPV_WTR: Cool Materials Scenario percentage of water in grid cell
CS_FST_DEC: Combined Strategies Scenario percentage of deciduous forest in grid cell
CS_FST_CON: Combined Strategies Scenario percentage of coniferous forest in grid cell
CS_FST_MIX: Combined Strategies Scenario percentage of mixed forest in grid cell (this is not the sum of ‘Forest_Dec’ and ‘Forest_Con’ fields, but its own unique land cover)
CS_GRASS: Combined Strategies Scenario percentage of grass in grid cell
CS_SHRUB: Combined Strategies Scenario percentage of shrub in grid cell
CS_PASTURE: Combined Strategies Scenario percentage of pasture in grid cell
CS_CROP: Combined Strategies Scenario percentage of crop in grid cell
CS_BARREN: Combined Strategies Scenario percentage of barren in grid cell
CS_IPV_RS: Combined Strategies Scenario percentage of impervious residential in grid cell
CS_IPV_NRS: Combined Strategies Scenario percentage of impervious nonresidential in grid cell
CS_IPV_ST: Combined Strategies Scenario percentage of impervious street in grid cell
CS_IPV_OTH: Combined Strategies Scenario percentage of impervious other in grid cell (all remaining impervious cover not included in ‘IPV_RS’, ‘IPV_NRS’, ‘IPV_ST’, and ‘IPV_AP’)
CS_IPV_AP: Combined Strategies Scenario percentage of impervious airport in grid cell
CS_IPV_WLW: Combined Strategies Scenario percentage of wooded wetland areas in grid cell
CS_IPV_WL: Combined Strategies Scenario percentage of wooded wetland areas in grid cell
CS_IPV_WTR: Combined Strategies Scenario percentage of water in grid cell
EE_FST_DEC: Energy Efficiency Scenario percentage of deciduous forest in grid cell
EE_FST_CON: Energy Efficiency Scenario percentage of coniferous forest in grid cell
EE_FST_MIX: Energy Efficiency Scenario percentage of mixed forest in grid cell (this is not the sum of ‘Forest_Dec’ and ‘Forest_Con’ fields, but its own unique land cover)
EE_GRASS: Energy Efficiency Scenario percentage of grass in grid cell
EE_SHRUB: Energy Efficiency Scenario percentage of shrub in grid cell
EE_PASTURE: Energy Efficiency Scenario percentage of pasture in grid cell
EE_CROP: Energy Efficiency Scenario percentage of crop in grid cell
EE_BARREN: Energy Efficiency Scenario percentage of barren in grid cell
EE_IPV_RS: Energy Efficiency Scenario percentage of impervious residential in grid cell
EE_IPV_NRS: Energy Efficiency Scenario percentage of impervious nonresidential in grid cell
EE_IPV_ST: Energy Efficiency Scenario percentage of impervious street in grid cell
EE_IPV_OTH: Energy Efficiency Scenario percentage of impervious other in grid cell (all remaining impervious cover not included in ‘IPV_RS’, ‘IPV_NRS’, ‘IPV_ST’, and ‘IPV_AP’)
EE_IPV_AP: Energy Efficiency Scenario percentage of impervious airport in grid cell
EE_IPV_WLW: Energy Efficiency Scenario percentage of wooded wetland areas in grid cell
EE_IPV_WL: Energy Efficiency Scenario percentage of wetland in grid cell
EE_IPV_WTR: Energy Efficiency Scenario percentage of water in grid cell
GN_FST_DEC: Greening Scenario percentage of deciduous forest in grid cell
GN_FST_CON: Greening Scenario percentage of coniferous forest in grid cell
GN_FST_MIX: Greening Scenario percentage of mixed forest in grid cell (this is not the sum of ‘Forest_Dec’ and ‘Forest_Con’ fields, but its own unique land cover)
GN_GRASS: Greening Scenario percentage of grass in grid cell
GN_SHRUB: Greening Scenario percentage of shrub in grid cell
GN_PASTURE: Greening Scenario percentage of pasture in grid cell
GN_CROP: Greening Scenario percentage of crop in grid cell
GN_BARREN: Greening Scenario percentage of barren in grid cell
GN_IPV_RS: Greening Scenario percentage of impervious residential in grid cell
GN_IPV_NRS: Greening Scenario percentage of impervious nonresidential in grid cell
GN_IPV_ST: Greening Scenario percentage of impervious street in grid cell
GN_IPV_OTH: Greening Scenario percentage of impervious other in grid cell (all remaining impervious cover not included in ‘IPV_RS’, ‘IPV_NRS’, ‘IPV_ST’, and ‘IPV_AP’)
GN_IPV_AP: Greening Scenario percentage of impervious airport in grid cell
GN_IPV_WLW: Greening Scenario percentage of wooded wetland areas in grid cell
GN_IPV_WL: Greening Scenario percentage of wetland in grid cell
GN_IPV_WTR: Greening Scenario percentage of water in grid cell

Use for the following 4 attributes:

Recreate Charts from Louisville Urban Heath Management Study:

No Benefit: Minimum value - 0.0008

Low Benefit: 0.0008 - 0.0062

High Benefit: 0.0062 - Maximum value

Av_Cool: Avoided heat deaths under the Cool Materials scenario during May to September 2012 by ½ km2 grid cell.
Av_Green: Avoided heat deaths under the Greening scenario during May to September 2012 by ½ km2 grid cell.
Av_Waste: Avoided deaths under the Energy Efficiency scenario during May to September 2012 by ½ km2 grid cell.
Av_All: Avoided deaths under the Combined Strategies scenario during May to September 2012 by ½ km2 grid cell.
Organization: Louisville Metro Government
Last updated: 2023-04-13T13:21:51.967918
Tags: environment, jefferson, kentucky, lojic, louisville, modp, open-data, sustainability

Tables

Table 1

@usgov.louisville_metro_government_jefferson_county_ky_urban__9f2e6384.table_1

1.1 MB
4924 rows
96 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "x" BIGINT,
  "y" BIGINT,
  "cell_a" BIGINT,
  "keyid" BIGINT,
  "heat_death" DOUBLE,
  "ws_b_apavg" DOUBLE,
  "ws_b_apmin" DOUBLE,
  "ws_b_apmax" DOUBLE,
  "base_uhi" DOUBLE,
  "cc_fst_dec" DOUBLE,
  "cc_fst_con" DOUBLE,
  "cc_fst_mix" DOUBLE,
  "cc_grass" DOUBLE,
  "cc_shrub" DOUBLE,
  "cc_pasture" DOUBLE,
  "cc_crop" DOUBLE,
  "cc_barren" DOUBLE,
  "cc_ipv_rs" DOUBLE,
  "cc_ipv_nrs" DOUBLE,
  "cc_ipv_st" DOUBLE,
  "cc_ipv_oth" DOUBLE,
  "cc_ipv_ap" DOUBLE,
  "cc_ipv_wlw" DOUBLE,
  "cc_ipv_wl" DOUBLE,
  "cc_ipv_wtr" DOUBLE,
  "cm_fst_dec" DOUBLE,
  "cm_fst_con" DOUBLE,
  "cm_fst_mix" DOUBLE,
  "cm_grass" DOUBLE,
  "cm_shrub" DOUBLE,
  "cm_pasture" DOUBLE,
  "cm_crop" DOUBLE,
  "cm_barren" DOUBLE,
  "cm_ipv_rs" DOUBLE,
  "cm_ipv_nrs" DOUBLE,
  "cm_ipv_st" DOUBLE,
  "cm_ipv_oth" DOUBLE,
  "cm_ipv_ap" DOUBLE,
  "cm_ipv_wlw" DOUBLE,
  "cm_ipv_wl" DOUBLE,
  "cm_ipv_wtr" DOUBLE,
  "cs_fst_dec" DOUBLE,
  "cs_fst_con" DOUBLE,
  "cs_fst_mix" DOUBLE,
  "cs_grass" DOUBLE,
  "cs_shrub" DOUBLE,
  "cs_pasture" DOUBLE,
  "cs_crop" DOUBLE,
  "cs_barren" DOUBLE,
  "cs_ipv_rs" DOUBLE,
  "cs_ipv_nrs" DOUBLE,
  "cs_ipv_st" DOUBLE,
  "cs_ipv_oth" DOUBLE,
  "cs_ipv_ap" DOUBLE,
  "cs_ipv_wlw" DOUBLE,
  "cs_ipv_wl" DOUBLE,
  "cs_ipv_wtr" DOUBLE,
  "ee_fst_dec" DOUBLE,
  "ee_fst_con" DOUBLE,
  "ee_fst_mix" DOUBLE,
  "ee_grass" DOUBLE,
  "ee_shrub" DOUBLE,
  "ee_pasture" DOUBLE,
  "ee_crop" DOUBLE,
  "ee_barren" DOUBLE,
  "ee_ipv_rs" DOUBLE,
  "ee_ipv_nrs" DOUBLE,
  "ee_ipv_st" DOUBLE,
  "ee_ipv_oth" DOUBLE,
  "ee_ipv_ap" DOUBLE,
  "ee_ipv_wlw" DOUBLE,
  "ee_ipv_wl" DOUBLE,
  "ee_ipv_wtr" DOUBLE,
  "gn_fst_dec" DOUBLE,
  "gn_fst_con" DOUBLE,
  "gn_fst_mix" DOUBLE,
  "gn_grass" DOUBLE,
  "gn_shrub" DOUBLE,
  "gn_pasture" DOUBLE,
  "gn_crop" DOUBLE,
  "gn_barren" DOUBLE,
  "gn_ipv_rs" DOUBLE,
  "gn_ipv_nrs" DOUBLE,
  "gn_ipv_st" DOUBLE,
  "gn_ipv_oth" DOUBLE,
  "gn_ipv_ap" DOUBLE,
  "gn_ipv_wlw" DOUBLE,
  "gn_ipv_wl" DOUBLE,
  "gn_ipv_wtr" DOUBLE,
  "av_cool" DOUBLE,
  "av_green" DOUBLE,
  "av_waste" DOUBLE,
  "av_all" DOUBLE,
  "shapearea" DOUBLE,
  "shapelen" DOUBLE
);