Data sets for simulation of urban construction consolidation centres

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

construction sites_data 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  (String)
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 (String)
The mention whether the site builds a public building, a private building or a mixed building (both public and private)

site_profile (String)
The profile of the building under construction:

Profile I is an apartments building,

Profile II is an offices building,

Profile III is a leisure construction,

Profile IV is a specific building like an hospital

Y1 (Integer)
the turnover of the construction site on the first year of operations in EUR

Y2 (Integer)
the turnover of the construction site on the second year of operations in EUR

Y3 (Integer)
the turnover of the construction site on the third year of operations in EUR

start (Date)
The start date of the construction project

end (Date)
The end date of the construction project

duration (Integer)
The duration of the construction project in months

total_value_eur (Integer)
The total value of the construction project in EUR

size_sqm (Integer)
The size of the construction project in square meters

CCC_options_data file

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

This file contains 25 observations of 40 fields :

ccc_id (String)
a unique identifier of the CCC, composed of:

one letter,

an underscore, and

3 digits.
The letter represents the success pilot that provided the data. The digits is the numeric identifier for the pilot.

capacity_sqm (Integer)
The storage area capacity of the CCC in square meters

capacity_cubic_meters (Integer)
The storage volume capacity of the CCC in cubic meters

Activation_Cost (Integer)
The CCC activation costs in EUR

Accessories (Integer)
The storage capacity for Accessories

Bitumen (Integer)
The storage capacity for Bitumen

Bricks (Integer)
The storage capacity for Bricks

Cement (Integer)
The storage capacity for Cement

Coating (Integer)
The storage capacity for Coating

Electrical (Integer)
The storage capacity for Electrical

Epoxi (Integer)
The storage capacity for Epoxi

External_Doors (Integer)
The storage capacity for External_Doors

Fences (Integer)
The storage capacity for Fences

Fire_Doors (Integer)
The storage capacity for Fire_Doors

Gabions (Integer)
The storage capacity for Gabions

Garden_Equipment (Integer)
The storage capacity for Garden_Equipment

Geotexil (Integer)
The storage capacity for Geotexil

Glass_wool (Integer)
The storage capacity for Glass_wool

Hydraulic (Integer)
The storage capacity for Hydraulic

Internal_Doors (Integer)
The storage capacity for Internal_Doors

Lift (Integer)
The storage capacity for Lift

Metal (Integer)
The storage capacity for Metal

Metal_1 (Integer)
The storage capacity for Metal_1

Paint (Integer)
The storage capacity for Paint

Parquet (Integer)
The storage capacity for Parquet

Pipes (Integer)
The storage capacity for Pipes

Plants (Integer)
The storage capacity for Plants

Plaster (Integer)
The storage capacity for Plaster

Polystyrene (Integer)
The storage capacity for Polystyrene

Precasted_Concrete (Integer)
The storage capacity for Precasted_Concrete

Roof (Integer)
The storage capacity for Roof

Scaffolding (Integer)
The storage capacity for Scaffolding

Signals (Integer)
The storage capacity for Signals

Steel (Integer)
The storage capacity for Steel

Stone (Integer)
The storage capacity for Stone

Store_Equipment (Integer)
The storage capacity for Store_Equipment

Tar (Integer)
The storage capacity for Tar

Tiles (Integer)
The storage capacity for Tiles

Windows (Integer)
The storage capacity for Windows

Wood (Integer)
The storage capacity for Wood

suppliers_data 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 (String)
an identifier of the supplier, composed of:

one letter,

an underscore, and

3 digits.
The letter represents the success pilot that provided the data. The digits is the numeric identifier for the pilot.

Material_delivered (String)
the material delivered by the supplier

Truck (Integer)
the truck identifeir of the usual truck used by the supplier to deliver the material

trucks_data file

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

This file contains 5 observations of 6 fields:

Truck_id (Integer)
a unique identifier for the truck

Vehicle (String)
description of the vehicle (including the number of axles)

Capacity_(kg) (Integer)
the material transport capacity of the truck in kilograms

Capacity_(m3) (Integer)
the material transport capacity of the truck in cubic meters

FlagFirstEchelon (String)
a flag indicating if the truck is used in 1st echelon

FlagSecondEchelon (String)
a flag indicating if the truck is used in 2nd echelon

origin_destination 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 (String)
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 (String)
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 (Integer)
The drive distance from origin to destination in meters

seconds (Integer)
The driving time from origin to destination in seconds

material demand 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 (Integer)
a unique identifier for the material demand

profile (String)
the profile of the construction site for such demand

start_date (Date)
the start date of the activity

end_date (Date)
the end date of the activity

number_of_days (Integer)
the duration of the activity in days

material (String)
the type of material requested

supplier_id (String)
the identifier of the supplier providing the material

material_demand_periods 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 (Integer)
the identifier for the material demand

profile (String)
the profile type of construction for the demand

period (Integer)
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 (Integer)
the volume of material to be delivered during the period

demand_kg (Integer)
the weight of material to be deliverd during the period