Data sets for simulation of urban construction consolidation centres

<p>Data from SUCCESS H2020 project used as input in the simulation activities of the Work Package 4</p> <p>This data sets is a public version of the data used in the simulation activities of the workpackage 4 in the SUCCESS project.</p> <p>It can be used to simulate the options of using one, several or no construction consolidation centers in an urban area.</p> <p>The dataset is composed of 7 distinct CSV files. All CSV files have headers.</p> <ol> <li>CCC_options_data.csv</li> <li>construction sites_data.csv</li> <li>material_demand.csv</li> <li>material_demand_periods.csv</li> <li>origin_destination.csv.csv</li> <li>suppliers_data.csv</li> <li>trucks_data.csv</li> </ol> <p><strong>construction sites_data </strong>file</p> <p>This file contains descriptions of construction sites that would be candidate to use the services of a Construction Consolidation Center (CCC).</p> <p>This file contains 99 observations of 11 fields :</p> <ol> <li> <p>site_id&nbsp; (<em>String</em>)<br> a unique identifier of the construction site, composed of:</p> <ul> <li> <p>one letter,&nbsp;</p> </li> <li> <p>an underscore, and&nbsp;</p> </li> <li> <p>3 digits.</p> <p>The letter represents the success pilot that provided the data. The digits sequence is the numeric identifier for the pilot.</p> </li> </ul> </li> <li> <p>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)</p> </li> <li> <p>site_profile (<em>String</em>)<br> The profile of the building under construction:</p> <ul> <li> <p><strong>Profile I</strong> is an <strong>apartments building</strong>,</p> </li> <li> <p><strong>Profile II </strong>is an <strong>offices building</strong>,</p> </li> <li> <p><strong>Profile III </strong>is a <strong>leisure </strong>construction,</p> </li> <li> <p><strong>Profile IV</strong> is a <strong>specific building </strong>like an hospital</p> </li> </ul> </li> <li> <p>Y1 (<em>Integer</em>)<br> the turnover of the construction site on the first year of operations in EUR</p> </li> <li> <p>Y2 (<em>Integer</em>)<br> the turnover of the construction site on the second year of operations in EUR</p> </li> <li> <p>Y3 (<em>Integer</em>)<br> the turnover of the construction site on the third year of operations in EUR</p> </li> <li> <p>start (<em>Date</em>)<br> The start date of the construction project</p> </li> <li> <p>end (<em>Date</em>)<br> The end date of the construction project</p> </li> <li> <p>duration (<em>Integer</em>)<br> The duration of the construction project in months</p> </li> <li> <p>total_value_eur (<em>Integer)</em><br> The total value of the construction project in EUR</p> </li> <li> <p>size_sqm (<em>Integer</em>)<br> The size of the construction project in square meters</p> </li> </ol> <p><strong>CCC_options_data </strong>file</p> <p>This file contains descriptions of Construction Consolidation Centers that could service construction sites.</p> <p>This file contains 25 observations of 40 fields :</p> <ol> <li>ccc_id (<em>String</em>)<br> a unique identifier of the CCC, composed of: <ul> <li>one letter,</li> <li>an underscore, and</li> <li>3 digits.<br> The letter represents the success pilot that provided the data. The digits is the numeric identifier for the pilot.</li> </ul> </li> <li>capacity_sqm (<em>Integer</em>)<br> The storage area capacity of the CCC in square meters</li> <li>capacity_cubic_meters (<em>Integer</em>)<br> The storage volume capacity of the CCC in cubic meters</li> <li>Activation_Cost (<em>Integer</em>)<br> The CCC activation costs in EUR</li> <li>Accessories (<em>Integer</em>)<br> The storage capacity for Accessories</li> <li>Bitumen (<em>Integer</em>)<br> The storage capacity for Bitumen</li> <li>Bricks (<em>Integer)</em><br> The storage capacity for Bricks</li> <li>Cement (Integer)<br> The storage capacity for Cement</li> <li>Coating (<em>Integer)</em><br> The storage capacity for Coating</li> <li>Electrical (Integer)<br> The storage capacity for Electrical</li> <li>Epoxi (<em>Integer)</em><br> The storage capacity for Epoxi</li> <li>External_Doors (<em>Integer</em>)<br> The storage capacity for External_Doors</li> <li>Fences (<em>Integer</em>)<br> The storage capacity for Fences</li> <li>Fire_Doors (<em>Integer</em>)<br> The storage capacity for Fire_Doors</li> <li>Gabions (<em>Integer</em>)<br> The storage capacity for Gabions</li> <li>Garden_Equipment (<em>Integer</em>)<br> The storage capacity for Garden_Equipment</li> <li>Geotexil (<em>Integer</em>)<br> The storage capacity for Geotexil</li> <li>Glass_wool (<em>Integer</em>)<br> The storage capacity for Glass_wool</li> <li>Hydraulic (<em>Integer</em>)<br> The storage capacity for Hydraulic</li> <li>Internal_Doors (<em>Integer</em>)<br> The storage capacity for Internal_Doors</li> <li>Lift (<em>Integer</em>)<br> The storage capacity for Lift</li> <li>Metal (<em>Integer</em>)<br> The storage capacity for Metal</li> <li>Metal_1 (<em>Integer</em>)<br> The storage capacity for Metal_1</li> <li>Paint (<em>Integer</em>)<br> The storage capacity for Paint</li> <li>Parquet (<em>Integer</em>)<br> The storage capacity for Parquet</li> <li>Pipes (<em>Integer</em>)<br> The storage capacity for Pipes</li> <li>Plants (<em>Integer</em>)<br> The storage capacity for Plants</li> <li>Plaster (<em>Integer</em>)<br> The storage capacity for Plaster</li> <li>Polystyrene (<em>Integer</em>)<br> The storage capacity for Polystyrene</li> <li>Precasted_Concrete (<em>Integer</em>)<br> The storage capacity for Precasted_Concrete</li> <li>Roof (<em>Integer</em>)<br> The storage capacity for Roof</li> <li>Scaffolding (<em>Integer</em>)<br> The storage capacity for Scaffolding</li> <li>Signals (<em>Integer</em>)<br> The storage capacity for Signals</li> <li>Steel (<em>Integer</em>)<br> The storage capacity for Steel</li> <li>Stone (<em>Integer</em>)<br> The storage capacity for Stone</li> <li>Store_Equipment (<em>Integer</em>)<br> The storage capacity for Store_Equipment</li> <li>Tar (<em>Integer</em>)<br> The storage capacity for Tar</li> <li>Tiles (<em>Integer</em>)<br> The storage capacity for Tiles</li> <li>Windows (<em>Integer</em>)<br> The storage capacity for Windows</li> <li>Wood (<em>Integer</em>)<br> The storage capacity for Wood</li> </ol> <p>&nbsp;</p> <p><strong>suppliers_data</strong> file</p> <p>&nbsp;</p> <p>This file contains description of suppliers that provide materials to the above construction sites.</p> <p>This file contains 407 observations of 3 fields :</p> <ol> <li>supplier_id (<em>String</em>)<br> an identifier of the supplier, composed of: <ul> <li>one letter,</li> <li>an underscore, and</li> <li>3 digits.<br> The letter represents the success pilot that provided the data. The digits is the numeric identifier for the pilot.</li> </ul> </li> <li>Material_delivered (<em>String</em>)<br> the material delivered by the supplier</li> <li>Truck (<em>Integer</em>)<br> the truck identifeir of the usual truck used by the supplier to deliver the material</li> </ol> <p><strong>trucks_data</strong> file</p> <p>This file contains description of truck used by suppliers to deliver construction sites.</p> <p>This file contains 5 observations of 6 fields:</p> <ol> <li>Truck_id (<em>Integer</em>)<br> a unique identifier for the truck</li> <li>Vehicle (<em>String</em>)<br> description of the vehicle (including the number of axles)</li> <li>Capacity_(kg) (<em>Integer</em>)<br> the material transport capacity of the truck in kilograms</li> <li>Capacity_(m3) (<em>Integer</em>)<br> the material transport capacity of the truck in cubic meters</li> <li>FlagFirstEchelon (<em>String)</em><br> a flag indicating if the truck is used in 1st echelon</li> <li>FlagSecondEchelon (<em>String</em>)<br> a flag indicating if the truck is used in 2nd echelon</li> </ol> <p><strong>origin_destination </strong>file</p> <p>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.</p> <p>This file contains 38640 observations of 4 fields:</p> <ol> <li>origin (<em>String</em>)<br> A composite identifier of the origin location, composed of: <ul> <li>the type of location (&#39;site&#39;, &#39;ccc&#39; or &#39;supplier&#39;),</li> <li>an underscore, and</li> <li>the id of such location type</li> </ul> </li> <li>destination (<em>String</em>)<br> A composite identifier of the destination location, composed of: <ul> <li>the type of location (&#39;site&#39;, &#39;ccc&#39; or &#39;supplier&#39;),</li> <li>an underscore, and</li> <li>the id of such location type</li> </ul> </li> <li>meters (<em>Integer</em>)<br> The drive distance from origin to destination in meters</li> <li>seconds (<em>Integer</em>)<br> The driving time from origin to destination in seconds</li> </ol> <p><strong>material demand </strong>file</p> <p>This file contains the qualitative data representing the material demand of construction sites per construction site profile .</p> <p>This file contains 1277 observations of 7 fields:</p> <ol> <li>demand_id (<em>Integer</em>)<br> a unique identifier for the material demand</li> <li>profile (<em>String)</em><br> the profile of the construction site for such demand</li> <li>start_date (<em>Date</em>)<br> the start date of the activity</li> <li>end_date (<em>Date</em>)<br> the end date of the activity</li> <li>number_of_days (<em>Integer</em>)<br> the duration of the activity in days</li> <li>material (<em>String</em>)<br> the type of material requested</li> <li>supplier_id (<em>String</em>)<br> the identifier of the supplier providing the material</li> </ol> <p><strong>material_demand_periods </strong>file</p> <p>This file contains the quantitative demand data per demand and per period. Units of periods are weeks.</p> <p>This file contains 93663 observations of 5 fields:</p> <ol> <li>demand_id (<em>Integer</em>)<br> the identifier for the material demand</li> <li>profile (<em>String</em>)<br> the profile type of construction for the demand</li> <li>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)</li> <li>demand_m3 (<em>Integer)</em><br> the volume of material to be delivered during the period</li> <li>demand_kg (<em>Integer)</em><br> the weight of material to be deliverd during the period</li> </ol>