DOI: 10.5281/zenodo.1249519
title: Data Sets For Simulation Of Urban Construction Consolidation Centres

description: Data from SUCCESS H2020 project used as input in the simulation activities of the Work Package 4

This data sets is a public version of the data used in the simulation activities of the workpackage 4 in the SUCCESS project.

It can be used to simulate the options of using one, several or no construction consolidation centers in an urban area.

The dataset is composed of 7 distinct CSV files. All CSV files have headers.


	CCC_options_data.csv
	construction sites_data.csv
	material_demand.csv
	material_demand_periods.csv
	origin_destination.csv.csv
	suppliers_data.csv
	trucks_data.csv


<strong>construction sites_data </strong>file

This file contains descriptions of construction sites that would be candidate to use the services of a Construction Consolidation Center (CCC).

This file contains 99 observations of 11 fields :


	
	site_id  (<em>String</em>)<br>
	a unique identifier of the construction site, composed of:

	
		
		one letter, 
		
		
		an underscore, and 
		
		
		3 digits.

		The letter represents the success pilot that provided the data. The digits sequence is the numeric identifier for the pilot.
		
	
	
	
	private_public (<em>String</em>)<br>
	The mention whether the site builds a public building, a private building or a mixed building (both public and private)
	
	
	site_profile (<em>String</em>)<br>
	The profile of the building under construction:

	
		
		<strong>Profile I</strong> is an <strong>apartments building</strong>,
		
		
		<strong>Profile II </strong>is an <strong>offices building</strong>,
		
		
		<strong>Profile III </strong>is a <strong>leisure </strong>construction,
		
		
		<strong>Profile IV</strong> is a <strong>specific building </strong>like an hospital
		
	
	
	
	Y1 (<em>Integer</em>)<br>
	the turnover of the construction site on the first year of operations in EUR
	
	
	Y2 (<em>Integer</em>)<br>
	the turnover of the construction site on the second year of operations in EUR
	
	
	Y3 (<em>Integer</em>)<br>
	the turnover of the construction site on the third year of operations in EUR
	
	
	start (<em>Date</em>)<br>
	The start date of the construction project
	
	
	end (<em>Date</em>)<br>
	The end date of the construction project
	
	
	duration (<em>Integer</em>)<br>
	The duration of the construction project in months
	
	
	total_value_eur (<em>Integer)</em><br>
	The total value of the construction project in EUR
	
	
	size_sqm (<em>Integer</em>)<br>
	The size of the construction project in square meters
	


<strong>CCC_options_data </strong>file

This file contains descriptions of Construction Consolidation Centers that could service construction sites.

This file contains 25 observations of 40 fields :


	ccc_id (<em>String</em>)<br>
	a unique identifier of the CCC, composed of:
	
		one letter,
		an underscore, and
		3 digits.<br>
		The letter represents the success pilot that provided the data. The digits is the numeric identifier for the pilot.
	
	
	capacity_sqm (<em>Integer</em>)<br>
	The storage area capacity of the CCC in square meters
	capacity_cubic_meters (<em>Integer</em>)<br>
	The storage volume capacity of the CCC in cubic meters
	Activation_Cost (<em>Integer</em>)<br>
	The CCC activation costs in EUR
	Accessories (<em>Integer</em>)<br>
	The storage capacity for Accessories
	Bitumen (<em>Integer</em>)<br>
	The storage capacity for Bitumen
	Bricks (<em>Integer)</em><br>
	The storage capacity for Bricks
	Cement (Integer)<br>
	The storage capacity for Cement
	Coating (<em>Integer)</em><br>
	The storage capacity for Coating
	Electrical (Integer)<br>
	The storage capacity for Electrical
	Epoxi (<em>Integer)</em><br>
	The storage capacity for Epoxi
	External_Doors (<em>Integer</em>)<br>
	The storage capacity for External_Doors
	Fences (<em>Integer</em>)<br>
	The storage capacity for Fences
	Fire_Doors (<em>Integer</em>)<br>
	The storage capacity for Fire_Doors
	Gabions (<em>Integer</em>)<br>
	The storage capacity for Gabions
	Garden_Equipment (<em>Integer</em>)<br>
	The storage capacity for Garden_Equipment
	Geotexil (<em>Integer</em>)<br>
	The storage capacity for Geotexil
	Glass_wool (<em>Integer</em>)<br>
	The storage capacity for Glass_wool
	Hydraulic (<em>Integer</em>)<br>
	The storage capacity for Hydraulic
	Internal_Doors (<em>Integer</em>)<br>
	The storage capacity for Internal_Doors
	Lift (<em>Integer</em>)<br>
	The storage capacity for Lift
	Metal (<em>Integer</em>)<br>
	The storage capacity for Metal
	Metal_1 (<em>Integer</em>)<br>
	The storage capacity for Metal_1
	Paint (<em>Integer</em>)<br>
	The storage capacity for Paint
	Parquet (<em>Integer</em>)<br>
	The storage capacity for Parquet
	Pipes (<em>Integer</em>)<br>
	The storage capacity for Pipes
	Plants (<em>Integer</em>)<br>
	The storage capacity for Plants
	Plaster (<em>Integer</em>)<br>
	The storage capacity for Plaster
	Polystyrene (<em>Integer</em>)<br>
	The storage capacity for Polystyrene
	Precasted_Concrete (<em>Integer</em>)<br>
	The storage capacity for Precasted_Concrete
	Roof (<em>Integer</em>)<br>
	The storage capacity for Roof
	Scaffolding (<em>Integer</em>)<br>
	The storage capacity for Scaffolding
	Signals (<em>Integer</em>)<br>
	The storage capacity for Signals
	Steel (<em>Integer</em>)<br>
	The storage capacity for Steel
	Stone (<em>Integer</em>)<br>
	The storage capacity for Stone
	Store_Equipment (<em>Integer</em>)<br>
	The storage capacity for Store_Equipment
	Tar (<em>Integer</em>)<br>
	The storage capacity for Tar
	Tiles (<em>Integer</em>)<br>
	The storage capacity for Tiles
	Windows (<em>Integer</em>)<br>
	The storage capacity for Windows
	Wood (<em>Integer</em>)<br>
	The storage capacity for Wood


 

<strong>suppliers_data</strong> file

 

This file contains description of suppliers that provide materials to the above construction sites.

This file contains 407 observations of 3 fields :


	supplier_id (<em>String</em>)<br>
	an identifier of the supplier, composed of:
	
		one letter,
		an underscore, and
		3 digits.<br>
		The letter represents the success pilot that provided the data. The digits is the numeric identifier for the pilot.
	
	
	Material_delivered (<em>String</em>)<br>
	the material delivered by the supplier
	Truck (<em>Integer</em>)<br>
	the truck identifeir of the usual truck used by the supplier to deliver the material


<strong>trucks_data</strong> file

This file contains description of truck used by suppliers to deliver construction sites.

This file contains 5 observations of 6 fields:


	Truck_id (<em>Integer</em>)<br>
	a unique identifier for the truck
	Vehicle (<em>String</em>)<br>
	description of the vehicle (including the number of axles)
	Capacity_(kg) (<em>Integer</em>)<br>
	the material transport capacity of the truck in kilograms
	Capacity_(m3) (<em>Integer</em>)<br>
	the material transport capacity of the truck in cubic meters
	FlagFirstEchelon (<em>String)</em><br>
	a flag indicating if the truck is used in 1st echelon
	FlagSecondEchelon (<em>String</em>)<br>
	a flag indicating if the truck is used in 2nd echelon


<strong>origin_destination </strong>file

This file contains the quantitative data of distance and time to travel from construction sites, suppliers, and CCCs to construction sites, suppliers and CCCs using a delivery truck.

This file contains 38640 observations of 4 fields:


	origin (<em>String</em>)<br>
	A composite identifier of the origin location, composed of:
	
		the type of location ('site', 'ccc' or 'supplier'),
		an underscore, and
		the id of such location type
	
	
	destination (<em>String</em>)<br>
	A composite identifier of the destination location, composed of:
	
		the type of location ('site', 'ccc' or 'supplier'),
		an underscore, and
		the id of such location type
	
	
	meters (<em>Integer</em>)<br>
	The drive distance from origin to destination in meters
	seconds (<em>Integer</em>)<br>
	The driving time from origin to destination in seconds


<strong>material demand </strong>file

This file contains the qualitative data representing the material demand of construction sites per construction site profile .

This file contains 1277 observations of 7 fields:


	demand_id (<em>Integer</em>)<br>
	a unique identifier for the material demand
	profile (<em>String)</em><br>
	the profile of the construction site for such demand
	start_date (<em>Date</em>)<br>
	the start date of the activity
	end_date (<em>Date</em>)<br>
	the end date of the activity
	number_of_days (<em>Integer</em>)<br>
	the duration of the activity in days
	material (<em>String</em>)<br>
	the type of material requested
	supplier_id (<em>String</em>)<br>
	the identifier of the supplier providing the material


<strong>material_demand_periods </strong>file

This file contains the quantitative demand data per demand and per period. Units of periods are weeks.

This file contains 93663 observations of 5 fields:


	demand_id (<em>Integer</em>)<br>
	the identifier for the material demand
	profile (<em>String</em>)<br>
	the profile type of construction for the demand
	period (<em>Integer</em>)<br>
	the period of the construction project during which the material has to be delivered (in number of weeks from the beginning of the construction project)
	demand_m3 (<em>Integer)</em><br>
	the volume of material to be delivered during the period
	demand_kg (<em>Integer)</em><br>
	the weight of material to be deliverd during the period
description: The data are made available under a dual licence: 
Creative Commons - Attribution - Non commercial - Share Alike by default AND 
Creative Commons - Attribution 4.0 on request to the contact persons and through specific agreement.