Spatial Heterogeneity in Hedonic Price Effects for Lake Water Quality

Kristen Swedberg, Diego S. Cardoso, Adriana Castillo-Castillo, Saleh Mamun, Kevin J. Boyle, Christoph Nolte, Michael Papenfus and Stephen Polasky

Article Figures & Data

  • Table 1

    Sample Selection Criteria and Modeling Choices

    CategoryCriterion TypeSubcategoryBaseline ChoiceAlternative
    Water qualityMeasurementWater quality statisticSummer meanSummer minimum, summer maximum
    Water qualityMeasurementWater quality timingClosest within ± 5 yearsYear of sale, year prior to sale, closest within previous 5 years
    Water qualityMinimum thresholdCoefficient of variation for Secchi depth0.25N/A
    PropertyMeasurementProperty attributesLot size; building size; building ageNone, bedrooms and bathroomsa
    PropertyMaximum thresholdLakefront property buffer150 m300 m
    PropertyMinimum thresholdSales in buffer10, 25
    PropertyMaximum thresholdProperty distance to lake1,000 m2,500 m
    Modeling Choices
    Functional formSale price, water qualityLog, logLog, linear
    Functional formCovariatesbLogN/A
    Fixed effectsSpatial unitCensus tractBlock group
    Fixed effectsInteractionsSpatial unit × sale yearSpatial unit + sale year
    • a All combinations of property attributes are considered (e.g., individual attributes, two at a time, three at a time, and all attributes). Bedrooms and bathrooms are always included together.

    • b In addition to the selected property attributes, model covariates include distance to lake, lake area, median income of block group, and slope and elevation of the parcel.

  • Table 2

    Descriptive Statistics by Region

    NortheastMidwestSouthWest
    Full Sample
    Sale price (2020 $)450,060344,023356,748642,456
    (426,614)(250,921)(282,424)(377,061)
    Secchi depth (m)2.491.671.492.93
    (1.61)(1.22)(0.87)(1.85)
    Lake distance (m)1,0169241,0161,325
    (734)(687)(708)(695)
    Lake distance < 150 m (1/0)0.130.140.110.04
    (0.34)(0.34)(0.32)(0.19)
    Lake distance 150–300 m (1/0)0.090.100.090.05
    (0.29)(0.30)(0.28)(0.21)
    Lake area (ha)8,9449675,3342,451
    (28,427)(5,083)(17,441)(7,227)
    Urbanized area (1/0)0.600.670.670.76
    (0.49)(0.47)(0.47)(0.43)
    Median income (2016 $)83,76978,56566,22882,623
    (35,013)(32,392)(30,839)(37,863)
    Slope (degrees)3.892.693.413.93
    (3.27)(2.22)(3.41)(3.88)
    Elevation (m)148.95291.20136.82885.74
    (130.50)(59.09)(142.42)(791.58)
    N396,9881,241,1941,388,818344,394
    Lakes1,1124,012830308
    States9121610
    Ecoregions51078
    Samples Restricted by Property Attribute Availability
    Lot size (sq. ft.)43,19030,91631,00817,659
    (78,291)(64,055)(55,912)(40,489)
    n = 380,289n = 1,057,113n = 1,291,411n = 323,733
    Building age (years)48.6043.1927.2332.70
    (29.12)(30.09)(21.85)(27.29)
    n = 318,287n = 870,459n = 1,069,065n = 286,611
    Building size (sq. ft.)1,9241,8202,0571,969
    (871)(972)(1,024)(846)
    n = 345,396n = 860,124n = 684,586n = 271,974
    Bathrooms2.072.392.712.24
    (0.92)(1.33)(1.30)(0.84)
    n = 258,968n = 725,467n = 473,398n = 170,154
    Bedrooms3.203.593.613.27
    (0.98)(1.46)(1.36)(0.97)
    n = 258,968n = 725,467n = 473,398n = 170,154

    Note: The means are reported with standard deviations in parentheses.

    • Table 3

      National Regression Results

      ParameterEstimateStd. ErrorParameterEstimateStd. Error
      Const7.123***(0.207)Secchi * MD−0.259**(0.085)
      Secchia, b, c0.231***(0.034)Secchi* ME2.428***(0.077)
      Secchi * lake area demeanedc0.009*(0.004)Secchi * MI−0.0680(0.048)
      Secchi * < 150 m0.025**(0.009)Secchi * MO0.6730(0.739)
      Secchi * lake distance−0.034***(0.005)Secchi * MT−2.021***(0.465)
      Secchi * urband−0.0150(0.014)Secchi * NC−0.1830(0.123)
      Secchi * ecoregion 5.2d0.075*(0.036)Secchi * ND−0.2230(0.292)
      Secchi * ecoregion 5.30.0430(0.033)Secchi * NE−0.1790(0.101)
      Secchi * ecoregion 6.20.5940(0.462)Secchi * NH−0.0650(0.047)
      Secchi * ecoregion 7.10.9910(0.596)Secchi * NJ−0.0030(0.052)
      Secchi * ecoregion 8.20.0570(0.077)Secchi * NY−0.0740(0.04)
      Secchi * ecoregion 8.30.0550(0.048)Secchi * OH−0.1980(0.16)
      Secchi * ecoregion 8.4−0.0170(0.069)Secchi * OK−0.1240(0.266)
      Secchi * ecoregion 8.50.0260(0.031)Secchi * OR−0.8670(0.525)
      Secchi * ecoregion 9.20.150(0.1)Secchi * PA0.154***(0.036)
      Secchi * ecoregion 9.30.2230(0.201)Secchi * RI0.102*(0.047)
      Secchi * ecoregion 9.40.2030(0.149)Secchi * SC−0.0530(0.084)
      Secchi * ecoregion 10.20.3060(0.462)Secchi * SD−0.1270(0.287)
      Secchi * ecoregion 11.10.6620(0.462)Secchi * TN−0.1130(0.078)
      Secchi * ecoregion 13.10.3660(0.475)Secchi * TX−0.3930(0.233)
      Secchi * ecoregion 15.40.0320(0.048)Secchi * VA−0.1340(0.083)
      Secchi * ALd0.0030(0.202)Secchi * VT−0.0780(0.129)
      Secchi * AR0.1210(0.15)Secchi * WA−0.9890(0.597)
      Secchi * AZ−0.3960(0.475)Secchi * WI−0.0330(0.08)
      Secchi * CA−0.7280(0.465)< 150 m0.124***(0.009)
      Secchi * CO−0.4980(0.461)Lake distance−0.095***(0.005)
      Secchi * CT−0.266*(0.12)Lake areae0.013*(0.005)
      Secchi * DE−0.0860(0.402)Median income0.131***(0.014)
      Secchi * FL−0.0190(0.037)Slope0.019***(0.002)
      Secchi * GA0.0330(0.128)Elevation−0.0230(0.023)
      Secchi * IA−0.221*(0.11)Lot size0.101***(0.004)
      Secchi * IL−0.1070(0.08)Building age−0.125***(0.003)
      Secchi * IN0.20(0.515)Building size0.547***(0.01)
      Secchi * KY−1.956***(0.058)Quarter 20.044***(0.002)
      Secchi * LA0.0840(0.211)Quarter 30.05***(0.002)
      Secchi * MA−0.0270(0.024)Quarter 40.015***(0.002)

      Note: N = 485,860, standard errors clustered at tract level.

      • a Interaction terms for MN and ecoregion 8.1 were preselected as the excluded categories, because the area intersection contains the most observations in the sample.

      • b During estimation, interaction terms for KS, NM, WV, ecoregion 10.1, and ecoregion 12.1 were fully absorbed by fixed effects and dropped from model. Observations for ecoregion 12.1 all fall within AZ. Variation in estimates for KS, NM, and WV can be explained by the corresponding ecoregion interactions.

      • c The log of lake area is demeaned in the interaction term with Secchi. Thus, the Secchi coefficient alone can be interpreted as the effect of water quality for a lake with the mean log-lake area. Secchi * Lake area demeaned can be interpreted as the effect of an increase in lake size over the sample mean.

      • d Because this model is estimated with census tract by year fixed effects, it is not necessary to include urban, ecoregion, and state constituents as control variables.

      • e The lake area when not interacted with Secchi is not demeaned, as it only serves as a control variable in the model not a coefficient of interest.

      • * p < 0.005

      • ** p < 0.01

      • *** p < 0.001.