Creative city index 2012 - Data sources, calculation methods and tools [Report spreadsheet]

Spreadsheet for Creative City Index 2012

The big data upgrade : new dimensions in data analysis - risks and opportunities [das big data upgrade : neue dimensionen der datennutzung – chancen und risiken]

Summary: More than ever before contemporary societies are characterised by the huge amounts of data being transferred. Authorities, companies, academia and other stakeholders refer to Big Data when discussing the importance of large and complex datasets and developing possible solutions for their use. Big Data promises to be the next frontier of innovation for institutions and individuals, yet it also offers possibilities to predict and influence human behaviour with ever-greater precision

Water Sensitive Urban Design (WSUD) application auditing

Background WSUD implementation in the Gold Coast City Council area commenced more than a decade ago. As a result, Council is expected to be in possession of WSUD assets valued at over tens of million dollars. The Gold Coast City Council is responsible for the maintenance and long-term management of these WSUD assets. Any shortcoming in implementation of best WSUD practices can potentially result in substantial liabilities and ineffective expenditure for the Council in addition to reduced efficiencies and outcomes. This highlights the importance of periodic auditing of WSUD implementation. Project scope The overall study entailed the following tasks: * A state-of-the-art literature review of the conceptual hydraulic and water quality treatment principles, current state of knowledge in relation to industry standards, best practice and identification of knowledge gaps in relation to maintenance and management practices and potential barriers to the implementation of WSUD. * Council stakeholder interviews to understand current practical issues in relation to the implementation of WSUD and the process of WSUD application from development application approval to asset management. * Field auditing of selected WSUD systems for condition assessment and identification of possible strengths and weaknesses in implementation. * Review of the Land Development Guidelines in order to identify any gaps and to propose recommendations for improvement. Conclusions Given below is a consolidated summary of the findings of the study undertaken. State-of-the-art literature review Though the conceptual framework for WSUD implementation is well established, the underlying theoretical knowledge underpinning the treatment processes and maintenance regimes and life cycle costing are still not well understood. Essentially, these are the recurring themes in the literature, namely, the inadequate understanding of treatment processes and lack of guidance to ensure specificity of maintenance regimes and life cycle costing of WSUDs. The fundamental barriers to successful WSUD implementation are: * Lack of knowledge transfer – This essentially relates to the lack of appropriate dissemination of research outcomes and the common absence of protocols for knowledge transfer within the same organisation. * Cultural barriers – These relate to social and institutional factors, including institutional inertia and the lack of clear understanding of the benefits. * Fragmented responsibilities – This results from poor administrative integration within local councils in relation to WSUDs. * Technical barriers – These relate to lack of knowledge on operational and maintenance practices which is compounded by model limitations and the lack of long-term quantitative performance evaluation data. * Lack of engineering standards – Despite the availability of numerous guidelines which are non-enforceable and can sometimes be confusing, there is a need for stringent engineering standards. The knowledge gaps in relation to WSUDs are only closing very slowly. Some of the common knowledge gaps identified in recent publications have been recognised almost a decade ago. The key knowledge gaps identified in the published literature are: * lack of knowledge on operational and maintenance practices; * lack of reliable methodology for identifying life cycle issues including costs; * lack of technical knowledge on system performance; * lack of guidance on retrofitting in existing developments. Based on the review of barriers to WSUD implementation and current knowledge gaps, the following were identified as core areas for further investigation: * performance evaluation of WSUD devices to enhance model development and to assess their viability in the context of environmental, economic and social drivers; establishing realistic life cycle costs to strengthen maintenance and asset management practices; * development of guidelines specific to retrofitting in view of the unique challenges posed by existing urban precincts together with guidance to ensure site specificity; establishment of a process for knowledge translation for enhancing currently available best practice guidelines; * identification of drivers and overcoming of barriers in the areas of institutional fragmentation, knowledge gaps and awareness of WSUD practices. GCCC stakeholder interviews Fourteen staff members involved in WSUD systems management in the Gold Coast City Council, representing four Directorates were interviewed using a standard questionnaire. The primary issues identified by the stakeholders were: * standardisation of WSUD terminology; * clear protocols for safeguarding devices during the construction phase; * engagement of all council stakeholders in the WSUD process from the initial phase; * limitations in the Land Development Guidelines; * ensuring public safety through design; * system siting to avoid conflicts with environmental and public use of open space; * provision of adequate access for maintenance; * integration of social and ecosystem issues to ensure long-term viability of systems in relation to both, vandalism and visual recreation; * lack of performance monitoring and inadequacy of the maintenance budget; * lack of technical training for staff involved in WSUD design approvals and maintenance; incentives for developers for acting responsibly in stormwater management. Field auditing of WSUD systems A representative cross section of WSUD systems in the Gold Coast were audited in the field. The following strengths and weaknesses in WSUD implementation were noted: * The implementation of WSUD systems in the field is not consistent. * The concerns raised by the stakeholders during the interviews in relation to WSUD implementation was validated from the observations from the field auditing, particularly in relation to the following: * safeguarding of devices during the construction phase * public safety * accessibility for maintenance * lack of performance monitoring by Council to assess system performance * inadequate maintenance of existing systems to suit site specific requirements. * A treatment train approach is not being consistently adopted. * Most of the systems audited have satisfactorily catered for public safety. Accessibility for maintenance has been satisfactorily catered for in most of the systems that were audited. * Systems are being commissioned prior to construction activities being substantially completed. * The hydraulic design of most systems appears to be satisfactory. * The design intent of the systems is not always clear. Review of Land Development Guidelines The Land Development Guidelines (TDG) was extensively reviewed and the following primary issues were noted in relation to WSUD implementation: * the LDG appears to have been prepared primarily to provide guidance to developers. It is not clear to what extent the guidelines are applicable to Council staff involved in WSUD maintenance and management; * Section 13 is very voluminous and appears to be a compilation of a series of individual documents resulting in difficulties in locating specific information, a lack of integration and duplication of information; * the LDG has been developed with a primary focus on new urban precinct development and the retrofitting of systems in existing developments has not been specifically discussed; * WSUDs are discussed in two different sections in the LDG and it is not clear which section takes precedence as there are inconsistencies between the two sections; there is inconsistent terminology being used; * there is a need for consolidation of information provided in different sections in the LDG; * there are inconsistencies in the design criteria provided; * there is a need for regular updating of the LDG to ensure that the information provided encompasses the state-of-the-art; * there is limited guidance provided for the preparation of maintenance plans and life cycle costing to assist developers in asset handover and to assist Council staff in assessment. * Based on these observations, eleven recommendations have been provided which are discussed below. Additionally, the stakeholder provided the following specific comments during the interviews in relation to the LDG: * lack of flexibility to cover the different stages of the life cycle of the systems; * no differentiation in projects undertaken by developers and Council; * inadequate information with regards to safety issues such as maximum standing water depth, fencing and safety barriers and public access; * lack of detailed design criteria in relation to Crime Prevention through Environmental Design, safety, amenity, environment, surrounding uses and impacts on surroundings; * inadequate information regarding maintenance requirements specific to the assessment and compliance phases; * recommendations for plantings are based primarily on landscape requirements rather than pollutant uptake capability. Recommendations With regards to the Land Development Guidelines, the following specific recommendations are provided: 1. the relevant sections and their extent of applicability to Council should be clearly identified; 2. integration of the different subsections within Section 13 and re-formatting the document for easy reference; 3. the maintenance guidelines provided in Section 13 should be translated to a maintenance manual for guidance of Council staff; 4. should consider extending the Guidelines to specifically encompass retrofitting of WSUD systems to existing urban precincts; 5. Section 3 needs to be revised to be made consistent with Section 13, to ensure priority for WSUD practices in urban precincts and to move away from conventional stormwater drainage design such as kerb and channelling; 6. it would also be good to specify as to which Section takes predominance in relation to stormwater drainage. It is expected that Section 13 would take predominance over the other sections in the LDG; 7. terminology needs to be made consistent to avoid confusion among developers and Council staff. Water Sensitive Urban Design is the term commonly used in Australia for stormwater quality treatment, rather than Stormwater Quality Improvement Devices. This once again underlines the need for ensuring consistency between Section 3 and Section 13; 8. it would also be good if there is a glossary of commonly used terms in relation to WSUD for use by all stakeholders and which should also be reflected in the LDG; 9. consolidation of all WSUD information into one section should be considered together with appropriate indicators in other LDG Sections regarding the availability of WSUD information. Ensuring consistency in the information provided is implied; 10. Section 13 should be updated at regular intervals to ensure the incorporation of the latest in research outcomes and incorporating criteria and guidance based on the state-of-the-art knowledge. The updating could be undertaken, say, in five year cycles. This would help to overcome the current lack of knowledge transfer; 11. the Council should consider commissioning specialised studies to extend the current knowledge base in relation to WSUD maintenance and life cycle costing. Additionally, Recommendation 10 is also applicable in this instance. The following additional recommendations are made based on the state-of-the-art literature review, stakeholder interviews and field auditing of WSUD systems: 1. Performance monitoring of existing systems to assess improvements to water quality, identify modifications and enhancements to improve performance; 2. Appropriate and monitored maintenance during different phases of development of built assets over time is needed to investigate the most appropriate time/phase of development to commission the final WSUD asset. 3. Undertake focussed investigations in the areas of WSUD maintenance and asset management in order to establish more realistic life cycle costs of systems and maintenance schedules; 4. the engagement of all relevant Council stakeholders from the initial stage of concept planning through to asset handover, and ongoing monitoring. This close engagement of internal stakeholders will assist in building a greater understanding of responsibilities and contribute to overcoming constraints imposed by fragmented responsibilities; 5. the undertaking of a public education program to inform the community of the benefits and ecosystem functions of WSUD systems; 6. technical training to impart state-of-the-art knowledge to staff involved in the approval of designs and maintenance and management of WSUD projects; 7. during the construction phase, it is important to ensure that appropriate measures to safeguard WSUD devices are implemented; 8. risks associated with potential public access to open water zones should be minimised with the application of appropriate safety measures; 9. system siting should ensure that potential conflicts are avoided with respect to public and ecosystem needs; 10. integration of social and ecosystem issues to ensure long-term viability of systems; provide incentives to developers who are proactive and responsible in the area of stormwater management.

Clinical data integration approach using SAS clinical data integration server (CDI) tools

The decisions people make about medical treatments have a great impact on their lives. Health care practitioners, providers and patients often make decisions about medical treatments without complete understanding of the circumstances. The main reason for this is that medical data are available in fragmented, disparate and heterogeneous data silos. Without a centralised data warehouse structure to integrate these data silos, it is highly unlikely and impractical for the users to get all the information required on time to make a correct decision. In this research paper, a clinical data integration approach using SAS Clinical Data Integration Server tools is presented.

How to Improve Cardiac Surgery Decision Making? In Data Warehousing Perspective

The health system is one sector dealing with very large amount of complex data. Many healthcare organisations struggle to utilise these volumes of health data effectively and efficiently. Therefore, there is a need for very effective system to capture, collate and distribute this health data. There are number of technologies have been identified to integrate data from different sources. Data warehousing is one technology can be used to manage clinical data in the healthcare. This paper addresses how data warehousing assist to improve cardiac surgery decision making. This research used the cardiac surgery unit at the Prince Charles Hospital (TPCH) as the case study. In order to deal with other units efficiently, it is important to integrate disparate data to a single point interrogation. We propose implementing a data warehouse for the cardiac surgery unit at TPCH. The data warehouse prototype developed using SAS enterprise data integration studio 4.2 and data was analysed using SAS enterprise edition 4.3. This improves access to integrated clinical and financial data with, improved framing of data to the clinical context, giving potentially better informed decision making for both improved management and patient care.

Over time assessment data analysis tracking a school's on-going performance

In Australia, as in some other western nations, governments impose accountability measures on educational institutions (Earl, 2005). One such accountability measure is the National Assessment Program - Literacy and Numeracy (NAPLAN) from which high-stakes assessment data is generated. In this article, a practical method of data analysis known as the Over Time Assessment Data Analysis (OTADA) is offered as an analytical process by which schools can monitor their current and over time performances. This analysis developed by the author, is currently used extensively in schools throughout Queensland. By Analysing in this way, teachers, and in particular principals, can obtain a quick and insightful performance overview. For those seeking to track the achievements and progress of year level cohorts, the OTADA should be considered.

Data warehousing model for integrating fragmented electronic health records from disparate and heterogeneous clinical data stores

This research was a step forward in developing a data integration framework for Electronic Health Records. The outcome of the research is a conceptual and logical Data Warehousing model for integrating Cardiac Surgery electronic data records. This thesis investigated the main obstacles for the healthcare data integration and proposes a data warehousing model suitable for integrating fragmented data in a Cardiac Surgery Unit.

Assessment of precision timing and real-time data networks for digital substation automation

This project researched the performance of emerging digital technology for high voltage electricity substations that significantly improves safety for staff and reduces the potential impact on the environment of equipment failure. The experimental evaluation used a scale model of a substation control system that incorporated real substation control and networking equipment with real-time simulation of the power system. The outcomes confirm that it is possible to implement Ethernet networks in high voltage substations that meet the needs of utilities; however component-level testing of devices is necessary to achieve this. The assessment results have been used to further develop international standards for substation communication and precision timing.

Cross-layer design and optimization for wireless networked control systems

Wireless networked control systems (WNCSs) have been widely used in the areas of manufacturing and industrial processing over the last few years. They provide real-time control with a unique characteristic: periodic traffic. These systems have a time-critical requirement. Due to current wireless mechanisms, the WNCS performance suffers from long time-varying delays, packet dropout, and inefficient channel utilization. Current wirelessly networked applications like WNCSs are designed upon the layered architecture basis. The features of this layered architecture constrain the performance of these demanding applications. Numerous efforts have attempted to use cross-layer design (CLD) approaches to improve the performance of various networked applications. However, the existing research rarely considers large-scale networks and congestion network conditions in WNCSs. In addition, there is a lack of discussions on how to apply CLD approaches in WNCSs. This thesis proposes a cross-layer design methodology to address the issues of periodic traffic timeliness, as well as to promote the efficiency of channel utilization in WNCSs. The design of the proposed CLD is highlighted by the measurement of the underlying network condition, the classification of the network state, and the adjustment of sampling period between sensors and controllers. This period adjustment is able to maintain the minimally allowable sampling period, and also maximize the control performance. Extensive simulations are conducted using the network simulator NS-2 to evaluate the performance of the proposed CLD. The comparative studies involve two aspects of communications, with and without using the proposed CLD, respectively. The results show that the proposed CLD is capable of fulfilling the timeliness requirement under congested network conditions, and is also able to improve the channel utilization efficiency and the proportion of effective data in WNCSs.

Improved earthwork allocation planning for fuel consumption and emissions reduction in linear infrastructure construction – case study data

This document provides data for the case study presented in our recent earthwork planning papers. Some results are also provided in a graphical format using Excel.

Energy efficient virtual machine placement in data centers

Electricity cost has become a major expense for running data centers and server consolidation using virtualization technology has been used as an important technology to improve the energy efficiency of data centers. In this research, a genetic algorithm and a simulation-annealing algorithm are proposed for the static virtual machine placement problem that considers the energy consumption in both the servers and the communication network, and a trading algorithm is proposed for dynamic virtual machine placement. Experimental results have shown that the proposed methods are more energy efficient than existing solutions.

Assessing the suitability of existing spatial data for disaster planning and mitigation in Queensland

The Council of Australian Governments (COAG) in 2003 gave in-principle approval to a best-practice report recommending a holistic approach to managing natural disasters in Australia incorporating a move from a traditional response-centric approach to a greater focus on mitigation, recovery and resilience with community well-being at the core. Since that time, there have been a range of complementary developments that have supported the COAG recommended approach. Developments have been administrative, legislative and technological, both, in reaction to the COAG initiative and resulting from regular natural disasters. This paper reviews the characteristics of the spatial data that is becoming increasingly available at Federal, state and regional jurisdictions with respect to their being fit for the purpose for disaster planning and mitigation and strengthening community resilience. In particular, Queensland foundation spatial data, which is increasingly accessible by the public under the provisions of the Right to Information Act 2009, Information Privacy Act 2009, and recent open data reform initiatives are evaluated. The Fitzroy River catchment and floodplain is used as a case study for the review undertaken. The catchment covers an area of 142,545 km2, the largest river catchment flowing to the eastern coast of Australia. The Fitzroy River basin experienced extensive flooding during the 2010–2011 Queensland floods. The basin is an area of important economic, environmental and heritage values and contains significant infrastructure critical for the mining and agricultural sectors, the two most important economic sectors for Queensland State. Consequently, the spatial datasets for this area play a critical role in disaster management and for protecting critical infrastructure essential for economic and community well-being. The foundation spatial datasets are assessed for disaster planning and mitigation purposes using data quality indicators such as resolution, accuracy, integrity, validity and audit trail.

Health complaints commissions in Australia : Time for a national approach to data collection

Health complaint commissions in Australia: Time for a national approach • There is considerable variation between jurisdictions in the ways complaint data are defined, collected and recorded by the Health complaint commissions. • Complaints from the public are an important accountability mechanism and an indicator of service quality. • The lack of a consistent approach leads to fragmentation of complaint data and a lost opportunity to use national data to assist policy development and identify the main areas causing consumers to complain. • We need a national approach to complaints data collection by the Health complaints commissions in order to better respond to patients’ concerns

Recommending people in social networks using data mining

This thesis improves the process of recommending people to people in social networks using new clustering algorithms and ranking methods. The proposed system and methods are evaluated on the data collected from a real life social network. The empirical analysis of this research confirms that the proposed system and methods achieved improvements in the accuracy and efficiency of matching and recommending people, and overcome some of the problems that social matching systems usually suffer.

Outsourcing data storage without outsourcing trust in cloud computing

The main theme of this thesis is to allow the users of cloud services to outsource their data without the need to trust the cloud provider. The method is based on combining existing proof-of-storage schemes with distance-bounding protocols. Specifically, cloud customers will be able to verify the confidentiality, integrity, availability, fairness (or mutual non-repudiation), data freshness, geographic assurance and replication of their stored data directly, without having to rely on the word of the cloud provider.