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 <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