Published November 8, 2023 | Version V1

Data associated to "The Direct Cost of Contaminated Brownfield Sites on Real Estate in France: A Quasi-Exhaustive Hedonic Price Analysis"

  • 1. ROR icon Bureau de Recherches Géologiques et Minières

Contributors

Contact person:

Project manager:

  • 1. ROR icon Bureau de Recherches Géologiques et Minières

Description

Data for replication of main results in "The Direct Cost of Contaminated Brownfield Sites on Real Estate in France: A Quasi-Exhaustive Hedonic Price Analysis". The folder "data_estim" contains all necessary data to replicate all estimations in the article (see the R code "codes_cbs-cost") with three .csv files: dvf_estim.csv, dvfbasol_estim.csv and cell200_simulation.csv. The variable names in these files are as follow:

 

Identifier Variables:

- IDMUTATION: identifier for each transacted property

- comm_code: identifier for each commune defined in 2021

- admin_code: identifier for urban areas defined in 2021

- iris2014_code: identifier for each neighborhood defined in 2014

- cell200_code: identifier for each 200-meters gredded cells

- dvf_x: longitude of each transacted property (EPSG: 2154, Lambert-93, RGF93)

- dvf_y: latitude of each transacted property (EPSG: 2154, Lambert-93, RGF93)

- basol_code: identifier for each CBS (only reported in dvfbasol_estim.csv)

- anneemut: year of transaction for each property

 

Dependent Variable:

- pm2: price in euro per square meter of transacted properties

 

Interest Variables:

- areaha_basol250: area in hectare of CBS between 0 and 250 meters from transacted property

- areaha_basol500: area in hectare of CBS between 250 and 500 meters from transacted property

- areaha_basol1000: area in hectare of CBS between 500 and 1000 meters from transacted property

- areaha_basol2000: area in hectare of CBS between 1000 and 2000 meters from transacted property

- areaha_basol3000: area in hectare of CBS between 2000 and 3000 meters from transacted property

- area250_indpro: area in hectare of CBS with industrial manufacturing activities between 0 and 250 meters from transacted property

- area500_indpro: area in hectare of CBS with industrial manufacturing activities between 250 and 500 meters from transacted property

- area1000_indpro: area in hectare of CBS with industrial manufacturing activities between 500 and 1000 meters from transacted property

- area2000_indpro: area in hectare of CBS with industrial manufacturing activities between 1000 and 2000 meters from transacted property

- area3000_indpro: area in hectare of CBS with industrial manufacturing activities between 2000 and 3000 meters from transacted property

- area250_indoth: area in hectare of CBS with industrial non-manufacturing activities (extractive) between 0 and 250 meters from transacted property

- area500_indoth: area in hectare of CBS with industrial non-manufacturing activities (extractive) between 250 and 500 meters from transacted property

- area1000_indoth: area in hectare of CBS with industrial non-manufacturing activities (extractive) between 500 and 1000 meters from transacted property

- area2000_indoth: area in hectare of CBS with industrial non-manufacturing activities (extractive) between 1000 and 2000 meters from transacted property

- area3000_indoth: area in hectare of CBS with industrial non-manufacturing activities (extractive) between 2000 and 3000 meters from transacted property

- area250_othact: area in hectare of CBS with other or unknown activities between 0 and 250 meters from transacted property

- area500_othact: area in hectare of CBS with other or unknown activities between 250 and 500 meters from transacted property

- area1000_othact: area in hectare of CBS with other or unknown activities between 500 and 1000 meters from transacted property

- area2000_othact: area in hectare of CBS with other or unknown activities between 1000 and 2000 meters from transacted property

- area3000_othact: area in hectare of CBS with other or unknown activities between 2000 and 3000 meters from transacted property

- areaha_specific250: area in hectare of CBS specific to a unique CBS between 0 and 250 meters from transacted property (only reported in dvfbasol_estim.csv)

- areaha_specific500: area in hectare of CBS specific to a unique CBS between 250 and 500 meters from transacted property (only reported in dvfbasol_estim.csv)

- areaha_specific1000: area in hectare of CBS specific to a unique CBS between 500 and 1000 meters from transacted property (only reported in dvfbasol_estim.csv)

- areaha_specific2000: area in hectare of CBS specific to a unique CBS between 1000 and 2000 meters from transacted property (only reported in dvfbasol_estim.csv)

 

Robustness Variables:

- pm2mean_iris: average transaction price per square meter of neighborhood IRIS

- shpoorhouse: share in percentage of poor households  

- dvfschool_nb250: number of schools within 250 meters of property

- dvfschool_nb500: number of schools within 500 meters of property

- dvfschool_nb1000: number of schools within 1000 meters of property

- dvfschool_nb2000: number of schools within 2000 meters of property

- dvfschool_nb3000: number of schools within 3000 meters of property

- dvfroad_nb250: number of road connections within 250 meters of property

- dvfroad_nb500: number of road connections within 500 meters of property

- dvfroad_nb1000: number of road connections within 1000 meters of property

- dvfroad_nb2000: number of road connections within 2000 meters of property

- dvfroad_nb3000: number of road connections within 30000 meters of property

- dvfrail_nb250: number of railway stations within 250 meters of property

- dvfrail_nb500: number of railway stations within 500 meters of property

- dvfrail_nb1000: number of railway stations within 1000 meters of property

- dvfrail_nb2000: number of railway stations within 2000 meters of property

- dvfrail_nb3000: number of railway stations within 3000 meters of property

 

Control Variables:

- center_dist: distance in kilometers of transacted property from urban area center

- sterr: surface area in square meter of parcel of each property

- sbati: surface area in square meter of building surfaces

- vente_cla: transaction through a classical process (binary variable)

- vente_adj: transaction through adjudicated process (binary variable)

- vente_ech: transaction through special exchange process (binary variable)

- vente_exp: transaction through expropriation process (binary variable)

- vente_efa: transaction before completion (binary variable)

- nblocmai: number of houses in each transaction

- nblocapt: number of apartments in each transaction

- nblocdep: number of building dependencies in each transaction

- nblocact: number of properties for commercial purpose in each transaction

- nbapt1pp: number of apartment with 1 room in each transaction

- nbapt2pp: number of apartment with 2 rooms in each transaction

- nbapt3pp: number of apartment with 3 rooms in each transaction

- nbapt4pp: number of apartment with 4 rooms in each transaction

- nbapt5pp: number of apartment with 5 and more rooms in each transaction

- nbmai1pp: number of house with 1 room in each transaction

- nbmai2pp: number of house with 2 rooms in each transaction

- nbmai3pp: number of house with 3 rooms in each transaction

- nbmai4pp: number of house with 4 rooms in each transaction

- nbmai5pp: number of house with 5 and more rooms in each transaction

- pm2mean_comm: average transaction price in euro per square meter of commune

- dvfmonument_nb500: number of historical monuments between 0 and 500 meters from transacted property

- dvfmonument_nb1000: number of historical monuments between 500 and 1000 meters from transacted property

- dvfmonument_nb2000: number of historical monuments between 1000 and 2000 meters from transacted property

- dvfindus_nb500: number of active industrial sites between 0 and 500 meters from transacted property

- dvfindus_nb1000: number of active industrial sites between 500 and 1000 meters from transacted property

- dvfindus_nb2000: number of active industrial sites between 1000 and 2000 meters from transacted property

- sh_apt: share of apartments in neighborhood IRIS

- sh_1945: share in percentage of properties with a building age before 1945

- sh_1970: share in percentage of properties with a building age before 1970

- sh_1990: share in percentage of properties with a building age before 1990

- sh_ap90: share in percentage of properties with a building age between 1990 and 2015

- sh_2015: share in percentage of properties with a building age after 2015

- clc1000_urbanhousing: share in percentage of land within 1000 meters of transacted properties with housing

- clc1000_urbanpark: share in percentage of land within 1000 meters of transacted properties with urban parks

- clc1000_recreation: share in percentage of land within 1000 meters of transacted properties with recreative activities

- clc1000_industrial: share in percentage of land within 1000 meters of transacted properties with industrial activities

- clc1000_transport: share in percentage of land within 1000 meters of transacted properties with transport infrastructures

- clc1000_nature: share in percentage of land within 1000 meters of transacted properties with natural land use

- clc1000_agr: share in percentage of land within 1000 meters of transacted properties with agricultural land use

- clc1000_forest: share in percentage of land within 1000 meters of transacted properties with forest

- clc1000_water: share in percentage of land within 1000 meters of transacted properties with water

 

 

Files

basol.csv

Files (955.4 MB)

Name Size
md5:afe4897eca5437d733b551e8e374afd0
33.0 kB Download
md5:584b2434d675b192dc1614bd62b5b93e
218 Bytes Download
md5:098c3d754f60a0abf3aebf1739b72854
191.1 kB Preview Download
md5:b1ff496c393a612a4c8dbc2490582b8c
54.6 MB Preview Download
md5:f2cb75444f310e22f811a3bf2bd45aa6
46.0 kB Download
md5:d10c6f40fb037e7de20a79625d259e39
712.8 MB Preview Download
md5:039db98cda1467424f851bd4c2a6e236
187.7 MB Preview Download
md5:073ba02501fad2c1ffbe138da4e95c2e
9.3 kB Preview Download

Additional details

Funding

Le réseau des Carnot

Dates

Submitted
2023-11-08