Generating Reports from the Database Clause Samples

Generating Reports from the Database. A third-party user (city authorities, researchers or other stakeholders of the ICT- Emissions project) can access the information in the database via another web interface, which is shown in Figure 13. This web interface is also an XHTML page which can be opened in a common web browser.The user can make selections for the criteria which are used to query the database and to generate reports. These criteria are the ICT measure, the city and the simulation scale. The ICT measure can be chosen from the finite set of ICT measures for which simulations are performed in the ICT-Emissions project. This set is defined in WP 6 of the project and comprises currently the measures Green Navigation, Urban Traffic Control (UTC), Variable Speed Limits (VSL), Eco Drive, Start & Stop, Cruise Control and Adaptive Cruise Control (ACC). Among the cities the user can choose between the cities Madrid, Rome and Turin. For the scale the user has the two options macroscopic and microscopic. For the ICT measure, the city and the scale multiple selections are possible. This means that a user can simultaneously retrieve data for multiple ICT measures, from multiple cities or for both macroscopic and microscopic simulations in the database reports. After the user has made the selection in the three list boxes, he can trigger the generation of a brief summary report by pressing the button Generate summary which is located below the list boxes. This report appears as a table right of the list boxes. It contains for each data set a consecutive number, the ICT measure, the subscenario description, the city, the scale and the relative benefit of an ICT measure over the basecase. The benefit is computed as 𝑏𝑒𝑛𝑒𝑓𝑖𝑡 = − 𝑒𝑚𝐼𝐶𝑇 − 𝑒𝑚𝐵𝐶 𝑒𝑚𝐵𝐶 where 𝑒𝑚��𝐶�� is the total amount of CO2 emissions in kg from the ICT measure simulation and 𝑒𝑚𝐵𝐶 is the total amount of CO2 emissions in kg from the basecase simulation. The intention of this brief summary is to give the user a coarse overview of the effectiveness of an ICT measure over the basecase. If the user would like to have more detailed information on a simulation, e.g., on the microscopic driving statistics or on the emissions per vehicle type or per road class, the user can generate a CSV report which contains all the attributes which are stored for the simulation in the database (see Annex). This CSV report is generated by pressing the button Export details to CSV … on the bottom left of the web page. In this context the user can also select the sym...