Advanced system of planning and organization of classes at the university

This document is the result of a process of web development to create a tool that will allow to Cracow University of Technology consult, create and manage timetables. The technologies chosen for this purpose are Apache Tomcat Server, My SQL Community Server, JDBC driver, Java Servlets and JSPs for the server side. The client part counts on Javascript, jQuery, AJAX and CSS technologies to perform the dynamism. The document will justify the choice of these technologies and will explain some development tools that help in the integration and development of all this elements: specifically, NetBeans IDE and MySQL workbench have been used as helpful tools. After explaining all the elements involved in the development of the web application, the architecture and the code developed are explained through UML diagrams. Some implementation details related to security are also deeper explained through sequence diagrams. As the source code of the application is provided, an installation manual has been developed to run the project. In addition, as the platform is intended to be a beta that will be grown, some unimplemented ideas for future development are also exposed. Finally, some annexes with important files and scripts related to the initiation of the platform are attached. This project started through an existing tool that needed to be expanded. The main purpose of the project along its development has focused on setting the roots for a whole new platform that will replace the existing one. For this goal, it has been needed to make a deep inspection on the existing web technologies: a web server and a SQL database had to be chosen. Although the alternatives were a lot, Java technology for the server was finally selected because of the big community backwards, the easiness of modelling the language through UML diagrams and the fact of being free license software. Apache Tomcat is the open source server that can use Java Servlet and JSP technology. Related to the SQL database, MySQL Community Server is the most popular open-source SQL Server, with a big community after and quite a lot of tools to manage the server. JDBC is the driver needed to put in contact Java and MySQL. Once we chose the technologies that would be part of the platform, the development process started. After a detailed explanation of the development environment installation, we used UML use case diagrams to set the main tasks of the platform; UML class diagrams served to establish the existing relations between the classes generated; the architecture of the platform was represented through UML deployment diagrams; and Enhanced entity–relationship (EER) model were used to define the tables of the database and their relationships. Apart from the previous diagrams, some implementation issues were explained to make a better understanding of the developed code - UML sequence diagrams helped to explain this. Once the whole platform was properly defined and developed, the performance of the application has been shown: it has been proved that with the current state of the code, the platform covers the use cases that were set as the main target. Nevertheless, some requisites needed for the proper working of the platform have been specified. As the project is aimed to be grown, some ideas that could not be added to this beta have been explained in order not to be missed for future development. Finally, some annexes containing important configuration issues for the platform have been added after proper explanation, as well as an installation guide that will let a new developer get the project ready. In addition to this document some other files related to the project are provided: - Javadoc. The Javadoc containing the information of every Java class created is necessary for a better understanding of the source code. - database_model.mwb. This file contains the model of the database for MySQL Workbench. This model allows, among other things, generate the MySQL script for the creation of the tables. - ScheduleManager.war. The WAR file that will allow loading the developed application into Tomcat Server without using NetBeans. - ScheduleManager.zip. The source code exported from NetBeans project containing all Java packages, JSPs, Javascript files and CSS files that are part of the platform. - config.properties. The configuration file to properly get the names and credentials to use the database, also explained in Annex II. Example of config.properties file. - db_init_script.sql. The SQL query to initiate the database explained in Annex III. SQL statements for MySQL initialization. RESUMEN. Este proyecto tiene como punto de partida la necesidad de evolución de una herramienta web existente. El propósito principal del proyecto durante su desarrollo se ha centrado en establecer las bases de una completamente nueva plataforma que reemplazará a la existente. Para lograr esto, ha sido necesario realizar una profunda inspección en las tecnologías web existentes: un servidor web y una base de datos SQL debían ser elegidos. Aunque existen muchas alternativas, la tecnología Java ha resultado ser elegida debido a la gran comunidad de desarrolladores que tiene detrás, además de la facilidad que proporciona este lenguaje a la hora de modelarlo usando diagramas UML. Tampoco hay que olvidar que es una tecnología de uso libre de licencia. Apache Tomcat es el servidor de código libre que permite emplear Java Servlets y JSPs para hacer uso de la tecnología de Java. Respecto a la base de datos SQL, el servidor más popular de código libre es MySQL, y cuenta también con una gran comunidad detrás y buenas herramientas de modelado, creación y gestión de la bases de datos. JDBC es el driver que va a permitir comunicar las aplicaciones Java con MySQL. Tras elegir las tecnologías que formarían parte de esta nueva plataforma, el proceso de desarrollo tiene comienzo. Tras una extensa explicación de la instalación del entorno de desarrollo, se han usado diagramas de caso de UML para establecer cuáles son los objetivos principales de la plataforma; los diagramas de clases nos permiten realizar una organización del código java desarrollado de modo que sean fácilmente entendibles las relaciones entre las diferentes clases. La arquitectura de la plataforma queda definida a través de diagramas de despliegue. Por último, diagramas EER van a definir las relaciones entre las tablas creadas en la base de datos. Aparte de estos diagramas, algunos detalles de implementación se van a justificar para tener una mejor comprensión del código desarrollado. Diagramas de secuencia ayudarán en estas explicaciones. Una vez que toda la plataforma haya quedad debidamente definida y desarrollada, se va a realizar una demostración de la misma: se demostrará cómo los objetivos generales han sido alcanzados con el desarrollo actual del proyecto. No obstante, algunos requisitos han sido aclarados para que la plataforma trabaje adecuadamente. Como la intención del proyecto es crecer (no es una versión final), algunas ideas que se han podido llevar acabo han quedado descritas de manera que no se pierdan. Por último, algunos anexos que contienen información importante acerca de la plataforma se han añadido tras la correspondiente explicación de su utilidad, así como una guía de instalación que va a permitir a un nuevo desarrollador tener el proyecto preparado. Junto a este documento, ficheros conteniendo el proyecto desarrollado quedan adjuntos. Estos ficheros son: - Documentación Javadoc. Contiene la información de las clases Java que han sido creadas. - database_model.mwb. Este fichero contiene el modelo de la base de datos para MySQL Workbench. Esto permite, entre otras cosas, generar el script de iniciación de la base de datos para la creación de las tablas. - ScheduleManager.war. El fichero WAR que permite desplegar la plataforma en un servidor Apache Tomcat. - ScheduleManager.zip. El código fuente exportado directamente del proyecto de Netbeans. Contiene todos los paquetes de Java generados, ficheros JSPs, Javascript y CSS que forman parte de la plataforma. - config.properties. Ejemplo del fichero de configuración que permite obtener los nombres de la base de datos - db_init_script.sql. Las consultas SQL necesarias para la creación de la base de datos.

Planning and community development: case studies

Planning and Comunity Development: Case Studies, presents the findings of the inter-university Seminar held on 28?29 July 2011 and organized by researchers from the Technical University of Madrid and the University of California, Berkeley, who were fortunate to have the presence of the renowned Professor John Friedmann. Professors, researchers and PhD students from our research groups presented their works as scientific communications that were enriched by the debate among the different researches who attended the Seminar. All of them appear in the picture below in front of the gate of Haviland Hall at UC Berkeley. This book analyses the concept of planning and its evolution so far, leading to the conceptualization of governance as an expression of the planning practice. It also studies the role of social capital and cooperation as tools for the community development. The conceptual analysis is complemented by the development of six case studies that put forward experiences of planning and community development carried out in diverse social and cultural contexts of Latin-America, Europe and North America. This publication comes after more than 20 years of work of the researchers that met at the seminar. Through their work in managing development initiatives, they have learned lessons and have contribute to shape their own body of teaching that develops and analyses the role of planning in public domain to promote community development. This knowledge is synthesized in the model Planning as Working With People, that shows that development is not effective unless is promoted in continuous collaboration with all the actors involved in the process.

Accessibility instruments for planning practice: bridging the gap between academic research and decision-making.

One of the core objectives of urban planning practice is to provide spatial equity in terms of opportunities and use of public space and facilities. Accessibility is the element that serves this purpose as a concept linking the reciprocal relationship between transport and land use, thus shaping individual potential mobility to reach the desired destinations. Accessibility concepts are increasingly acknowledged as fundamental to understand the functioning of cities and urban regions. Indeed, by introducing them in planning practice, better solutions can be achieved in terms of spatial equity. The COST Action TU1002 "Accessibility instruments for planning practice" was specifically designed to address the gap between scientific research in measuring and modelling accessibility, and the current use of indicators of accessibility in urban planning practice. This paper shows the full process of introducing an easily understandable measure of accessibility to planning practitioners in Madrid, which is one of the case studies of the above-mentioned COST action. Changes in accessibility after the opening of a new metro line using contour measures were analyzed and then presented to a selection of urban planners and practitioners in Madrid as part of a workshop to evaluate the usefulness of this tool for planning practice. Isochrone maps were confirmed as an effective tool, as their utility can be supplemented by other indicators, and being GIS-based, it can be easily computed (when compared with transport models) and integrated with other datasets.

Education Planning Evolution for Forest Engineering in Spain

Forest engineering in Spain has a long tradition and active presence in the engineering field. It is also one of the first educational institutions that shaped the Spanish technological panorama in the mid nineteenth century. The actual situation of the forest systems in Spain is the result of 166 years of observation, research, education and the application of specific techniques and principles that forest engineers acquired with the successive study plans that were implanted in educational institutions. In this paper, the planning historical process of education in Forest engineer is analyzed, differentiating between four historical periods. The analysis of the stages focuses on the contents of the study plans, the orientation towards educational objectives, the duration of the studies and the causes for the modifications that had an impact on the evolution through time within the framework of the acquired experience and the technological advances

Rapid plant diversification: Planning for an evolutionary future

Systematic conservation planning is a branch of conservation biology that seeks to identify spatially explicit options for the preservation of biodiversity. Alternative systems of conservation areas are predictions about effective ways of promoting the persistence of biodiversity; therefore, they should consider not only biodiversity pattern but also the ecological and evolutionary processes that maintain and generate species. Most research and application, however, has focused on pattern representation only. This paper outlines the development of a conservation system designed to preserve biodiversity pattern and process in the context of a rapidly changing environment. The study area is the Cape Floristic Region (CFR), a biodiversity hotspot of global significance, located in southwestern Africa. This region has experienced rapid (post-Pliocene) ecological diversification of many plant lineages; there are numerous genera with large clusters of closely related species (flocks) that have subdivided habitats at a very fine scale. The challenge is to design conservation systems that will preserve both the pattern of large numbers of species and various natural processes, including the potential for lineage turnover. We outline an approach for designing a system of conservation areas to incorporate the spatial components of the evolutionary processes that maintain and generate biodiversity in the CFR. We discuss the difficulty of assessing the requirements for pattern versus process representation in the face of ongoing threats to biodiversity, the difficulty of testing the predictions of alternative conservation systems, and the widespread need in conservation planning to incorporate and set targets for the spatial components (or surrogates) of processes.

Initiation process of earthquakes and its implications for seismic hazard reduction strategy.

For the average citizen and the public, "earthquake prediction" means "short-term prediction," a prediction of a specific earthquake on a relatively short time scale. Such prediction must specify the time, place, and magnitude of the earthquake in question with sufficiently high reliability. For this type of prediction, one must rely on some short-term precursors. Examinations of strain changes just before large earthquakes suggest that consistent detection of such precursory strain changes cannot be expected. Other precursory phenomena such as foreshocks and nonseismological anomalies do not occur consistently either. Thus, reliable short-term prediction would be very difficult. Although short-term predictions with large uncertainties could be useful for some areas if their social and economic environments can tolerate false alarms, such predictions would be impractical for most modern industrialized cities. A strategy for effective seismic hazard reduction is to take full advantage of the recent technical advancements in seismology, computers, and communication. In highly industrialized communities, rapid earthquake information is critically important for emergency services agencies, utilities, communications, financial companies, and media to make quick reports and damage estimates and to determine where emergency response is most needed. Long-term forecast, or prognosis, of earthquakes is important for development of realistic building codes, retrofitting existing structures, and land-use planning, but the distinction between short-term and long-term predictions needs to be clearly communicated to the public to avoid misunderstanding.

RADIANCE-A planning software for intra-operative radiation therapy

In the last decades accumulated clinical evidence has proven that intra-operative radiation therapy (IORT) is a very valuable technique. In spite of that, planning technology has not evolved since its conception, being outdated in comparison to current state of the art in other radiotherapy techniques and therefore slowing down the adoption of IORT. RADIANCE is an IORT planning system, CE and FDA certified, developed by a consortium of companies, hospitals and universities to overcome such technological backwardness. RADIANCE provides all basic radiotherapy planning tools which are specifically adapted to IORT. These include, but are not limited to image visualization, contouring, dose calculation algorithms-Pencil Beam (PB) and Monte Carlo (MC), DVH calculation and reporting. Other new tools, such as surgical simulation tools have been developed to deal with specific conditions of the technique. Planning with preoperative images (preplanning) has been evaluated and the validity of the system being proven in terms of documentation, treatment preparation, learning as well as improvement of surgeons/radiation oncologists (ROs) communication process. Preliminary studies on Navigation systems envisage benefits on how the specialist to accurately/safely apply the pre-plan into the treatment, updating the plan as needed. Improvements on the usability of this kind of systems and workflow are needed to make them more practical. Preliminary studies on Intraoperative imaging could provide an improved anatomy for the dose computation, comparing it with the previous pre-plan, although not all devices in the market provide good characteristics to do so. DICOM.RT standard, for radiotherapy information exchange, has been updated to cover IORT particularities and enabling the possibility of dose summation with external radiotherapy. The effect of this planning technology on the global risk of the IORT technique has been assessed and documented as part of a failure mode and effect analysis (FMEA). Having these technological innovations and their clinical evaluation (including risk analysis) we consider that RADIANCE is a very valuable tool to the specialist covering the demands from professional societies (AAPM, ICRU, EURATOM) for current radiotherapy procedures.

A methodology for evacuation route planning inside buildings using geospatial technology

Evacuation route planning is a fundamental task for building engineering projects. Safety regulations are established so that all occupants are driven on time out of a building to a secure place when faced with an emergency situation. As an example, Spanish building code requires the planning of evacuation routes on large and, usually, public buildings. Engineers often plan these routes on single building projects, repeatedly assigning clusters of rooms to each emergency exit in a trial-and-error process. But problems may arise for a building complex where distribution and use changes make visual analysis cumbersome and sometimes unfeasible. This problem could be solved by using well-known spatial analysis techniques, implemented as a specialized software able to partially emulate engineer reasoning. In this paper we propose and test an easily reproducible methodology that makes use of free and open source software components for solving a case study. We ran a complete test on a building floor at the University of Alicante (Spain). This institution offers a web service (WFS) that allows retrieval of 2D geometries from any building within its campus. We demonstrate how geospatial technologies and computational geometry algorithms can be used for automating the creation and optimization of evacuation routes. In our case study, the engineers’ task is to verify that the load capacity of each emergency exit does not exceed the standards specified by Spain’s current regulations. Using Dijkstra’s algorithm, we obtain the shortest paths from every room to the most appropriate emergency exit. Once these paths are calculated, engineers can run simulations and validate, based on path statistics, different cluster configurations. Techniques and tools applied in this research would be helpful in the design and risk management phases of any complex building project.

Teaching-learning process of historical heritage: a Journey as a beginning, path and end

The implantation of new university degrees within the European Higher Education Area implies the need of innovative methodologies in teaching and learning to improve the skills and competencies of students and to answer the growing needs that society continuously demands to heritage management experts. The present work shows an application of the teaching methodology proposed during the international workshop entitled “I International Planning Preservation Workshop. Learning from Al Andalus”, which included the participation of the University of Alicante and Granada, Università Politecnico di Milano and Hunter College City University of New York; where we tried to dissolve traditional boundaries derived of interuniversity cooperation programs. The main objective of the workshop was to discuss and debate the role of urban Historical Centers within the Global Heritage by the integrated work through multidisciplinary teams and the creation of a permanent international working group between these universities to both teach and research. The methodology of this workshop was very participatory and considered the idea of a new learning process generated by "a journey experience." A trip from global to local (from the big city to the small village) but also a trip from the local (historical) part of a big city to the global dimension of contemporary historical villages identified by the students through a system of exhibition panels in affinity groups, specific projects proposed by lecturers and teachers or the generation of publications in various areas (texts, photographs, videos, etc.). So, the participation of the students in this multidisciplinary meeting has enhanced their capacity for self-criticism in several disciplines and has promoted their ability to perform learning and research strategies in an autonomous way. As a result, it has been established a permanent international work structure for the development of projects of the Historical City. This relationship has generated the publication of several books whose contents have reflected the conclusions developed in the workshop and several teaching proposals shared between those institutions. All these aspects have generated a new way of understanding the teaching process through a journey, in order to study the representative role of university in the historical heritage and to make students (from planning, heritage management, architecture, geography, sociology, history or engineering areas) be compromised on searching strategies for sustainable development in the Contemporary City.

Strasbourg, France, City Planning, 1880 (Raster Image)

This layer is a georeferenced raster image of the historic paper map entitled: Bebauungsplan für die Erweiterung der Stadt Strassburg. It was published by Druck und Verlag R. Schultz & Cie. in 1880. Scale 1:5,000. Covers Strasbourg, France. Map in German. The image inside the map neatline is georeferenced to the surface of the earth and fit to the 'European Datum 1950 UTM Zone 32N' coordinate system. All map collar and inset information is also available as part of the raster image, including any inset maps, profiles, statistical tables, directories, text, illustrations, index maps, legends, or other information associated with the principal map. This map shows development plans for the expansion of the city of Strasbourg. It includes features such as existing and proposed roads (with measurements), railroads and stations, drainage, built-up areas and selected buildings, fortification, ground cover, parks, and more. This layer is part of a selection of digitally scanned and georeferenced historic maps from The Harvard Map Collection as part of the Imaging the Urban Environment project. Maps selected for this project represent major urban areas and cities of the world, at various time periods. These maps typically portray both natural and manmade features at a large scale. The selection represents a range of regions, originators, ground condition dates, scales, and purposes.

Strasbourg, France, City Planning, 1910 (Raster Image)

This layer is a georeferenced raster image of the historic paper map entitled: Plan der Stadt Strassburg : aufgestellt nach dem amtlichen Bebauungsplan. It was published by W. Heinrich in 1910. Scale 1:7,500. Covers Strasbourg, France. Map in German. The image inside the map neatline is georeferenced to the surface of the earth and fit to the 'European Datum 1950 UTM Zone 32N' coordinate system. All map collar and inset information is also available as part of the raster image, including any inset maps, profiles, statistical tables, directories, text, illustrations, index maps, legends, or other information associated with the principal map. This map shows development plans for the expansion of the city of Strasbourg. It includes features such as existing and proposed roads, railroads and stations, street-railroads, drainage, built-up areas and selected buildings, ground cover, parks, city district boundaries, and more. Includes black pen-and-ink manuscript additions and type-script paper pasted over map in English; red and yellow lines showing the public lands & buildings & lands owned by municpality. This layer is part of a selection of digitally scanned and georeferenced historic maps from The Harvard Map Collection as part of the Imaging the Urban Environment project. Maps selected for this project represent major urban areas and cities of the world, at various time periods. These maps typically portray both natural and manmade features at a large scale. The selection represents a range of regions, originators, ground condition dates, scales, and purposes.

Kolkata, India, City Planning, 1913 (Raster Image)

This layer is a georeferenced raster image of the historic paper map entitled: City of Calcutta, E. P. Richards. It was printed by Jennings & Bewley in 1913. Scale 1:21,120. Covers Kolkata and a portion of Hāora, India. The image inside the map neatline is georeferenced to the surface of the earth and fit to the 'WGS 1984 UTM Zone 45N' coordinate system. All map collar and inset information is also available as part of the raster image, including any inset maps, profiles, statistical tables, directories, text, illustrations, index maps, legends, or other information associated with the principal map. This map shows features such as residential and industrial zoning districts and redevelopment zones, roads, railroads, drainage, canals, built-up areas and selected buildings, fortification, docks, parks, and more. Includes index, note, legend of class dwellings, and census "map" (i.e., chart). This layer is part of a selection of digitally scanned and georeferenced historic maps from The Harvard Map Collection as part of the Imaging the Urban Environment project. Maps selected for this project represent major urban areas and cities of the world, at various time periods. These maps typically portray both natural and manmade features at a large scale. The selection represents a range of regions, originators, ground condition dates, scales, and purposes.

Energizing the Oak Ridges Moraine? Analyzing the Policy Implications of Three Wind Energy Developments on the Oak Ridges Moraine and their Potential Impact on the Coordinated Land Use Planning Review through the Involvement of First Nations and Environmental Non-governmental Organizations

This research explores the policy implications of the approval of three wind energy projects on the Oak Ridges Moraine, and their impact on the Coordinated Land Use Planning Review process. Specifically, it focuses on the involvement of First Nations and environmental non-governmental organizations (ENGOs). This research was conducted through analyzing submissions to the Coordinated Land Use Planning Review, related legislation and policy, Environmental Review Tribunal hearing documents, and interviews with key informants. This research culminates in a number of recommendations to the Coordinated Review informed by the analysis.

The Western Balkans: deadlock in the EU enlargement process. OSW Commentary No. 43, 2010-11-24

On 9 November the European Commission presented the annual reports assessing the progress of the Balkans states in their preparations for EU membership, the enlargement strategy up to autumn 2011, and the assessment of the EU membership applications submitted by Albania and Macedonia. All these documents show that the reform process in the Balkan states has slowed down in comparison to previous years. The main reason for this slowdown is the negative consequences of the global economic crisis for these countries. Nonetheless, the transformation process is continuing, despite these difficulties. Another increasingly serious challenge for integrating the Balkan states is the EU's growing reluctance to enlarge any further. Among other measures, the EU states have blocked the formal acknowledgement of the integration progress (objections have been raised to the submission of membership applications by Albania, Serbia and Montenegro, and to granting Albania candidate status), which has significantly prolonged the accession process. In fact, this illustrates the lack of political will to accept new members. The European Commission is aware that the integration process may be blocked, and so in the coming year it is planning to focus on fostering the idea of enlargement among the EU member states. It will also focus on persuading the Balkan states to move on with reforms, especially those designed to strengthen state institutions (administration, the judiciary), even if their progress will not be formally considered during the integration process. The Commission assumes that by the end of next year, the reforms implemented by the Balkan states will be comprehensive enough to persuade the EU states to step up the integration process in subsequent years. However, if the EU member states' standpoint on the enlargement process does not change, the Commission's efforts will not bring about the expected results. Considering that their prospects for EU membership are receding, the Balkan states may not have sufficient motivation to go on with long-term reform efforts. As a result, the transformation process may become impeded, and in the longer perspective, the situation in the entire region may be destabilised.