A series of trials in the UK as part of the Ofcom TV white spaces pilot

“Copyright © [2014] IEEE. Reprinted from 1st International Workshop on Cognitive Cellular Systems 2014 . ISBN: 978-1-4799-4139-1 .This material is posted here with permission of the IEEE. Internal or personal use of this material is permitted. However, permission to reprint/republish this material for advertising or promotional purposes or for creating new collective works for resale or redistribution must be obtained from the IEEE by writing to pubs-permissions@ieee.org. By choosing to view this document, you agree to all provisions of the copyright laws protecting it.”

Some initial results and observations from a series of trials within the Ofcom TV white spaces pilot

“Copyright © [2015] IEEE. Reprinted from Vehicular Technology Conference (VTC Spring), 2015 IEEE 81st. ISBN: 978-1-4799-8088-8. This material is posted here with permission of the IEEE. Internal or personal use of this material is permitted. However, permission to reprint/republish this material for advertising or promotional purposes or for creating new collective works for resale or redistribution must be obtained from the IEEE by writing to pubs-permissions@ieee.org. By choosing to view this document, you agree to all provisions of the copyright laws protecting it.”

Scaling geospatial searches in large spatial databases

Modern geographical databases, which are at the core of geographic information systems (GIS), store a rich set of aspatial attributes in addition to geographic data. Typically, aspatial information comes in textual and numeric format. Retrieving information constrained on spatial and aspatial data from geodatabases provides GIS users the ability to perform more interesting spatial analyses, and for applications to support composite location-aware searches; for example, in a real estate database: “Find the nearest homes for sale to my current location that have backyard and whose prices are between $50,000 and $80,000”. Efficient processing of such queries require combined indexing strategies of multiple types of data. Existing spatial query engines commonly apply a two-filter approach (spatial filter followed by nonspatial filter, or viceversa), which can incur large performance overheads. On the other hand, more recently, the amount of geolocation data has grown rapidly in databases due in part to advances in geolocation technologies (e.g., GPS-enabled smartphones) that allow users to associate location data to objects or events. The latter poses potential data ingestion challenges of large data volumes for practical GIS databases. In this dissertation, we first show how indexing spatial data with R-trees (a typical data pre-processing task) can be scaled in MapReduce—a widely-adopted parallel programming model for data intensive problems. The evaluation of our algorithms in a Hadoop cluster showed close to linear scalability in building R-tree indexes. Subsequently, we develop efficient algorithms for processing spatial queries with aspatial conditions. Novel techniques for simultaneously indexing spatial with textual and numeric data are developed to that end. Experimental evaluations with real-world, large spatial datasets measured query response times within the sub-second range for most cases, and up to a few seconds for a small number of cases, which is reasonable for interactive applications. Overall, the previous results show that the MapReduce parallel model is suitable for indexing tasks in spatial databases, and the adequate combination of spatial and aspatial attribute indexes can attain acceptable response times for interactive spatial queries with constraints on aspatial data.

International review of environmental assessment tools and databases

Existing widely known environmental assessment models, primarily those for Life Cycle Assessment of manufactured products and buildings, were reviewed to grasp their characteristics, since the past several years have seen a significant increase in interest and research activity in the development of building environmental assessment methods. Each method or tool was assessed under the headings of description, data requirement, end-use, assessment criteria (scale of assessment and scoring/ weighting system)and present status

Copyright in databases in Australia

A database will be protected under Australian law if it is a literary work; expressed in material form; meets the originality test; and has a relevant connection with Australia. Facts and data in themselves are not protected by copyright. However, a collection of data, a dataset, or a database may be protected by copyright if it is sufficiently original. Whether a work is sufficiently original to be protected by copyright depends on whether it has been produced by the application of independent intellectual effort by the author/s, which may involve the exercise of skill, judgement, or creativity in selecting, presenting, or arranging the information. This summary synthesises recent cases regarding originality in factual compilations.

Impact of opening a new emergency department on healthcare service and patient outcomes : analyses based on linking ambulance, emergency and hospital databases

Background Emergency department (ED) crowding caused by access block is an increasing public health issue and has been associated with impaired healthcare delivery, negative patient outcomes and increased staff workload. Aim To investigate the impact of opening a new ED on patient and healthcare service outcomes. Methods A 24-month time series analysis was employed using deterministically linked data from the ambulance service and three ED and hospital admission databases in Queensland, Australia. Results Total volume of ED presentations increased 18%, while local population growth increased by 3%. Healthcare service and patient outcomes at the two pre-existing hospitals did not improve. These outcomes included ambulance offload time: (Hospital A PRE: 10 min, POST: 10 min, P < 0.001; Hospital B PRE: 10 min, POST: 15 min, P < 0.001); ED length of stay: (Hospital A PRE: 242 min, POST: 246 min, P < 0.001; Hospital B PRE: 182 min, POST: 210 min, P < 0.001); and access block: (Hospital A PRE: 41%, POST: 46%, P < 0.001; Hospital B PRE: 23%, POST: 40%, P < 0.001). Time series modelling indicated that the effect was worst at the hospital furthest away from the new ED. Conclusions An additional ED within the region saw an increase in the total volume of presentations at a rate far greater than local population growth, suggesting it either provided an unmet need or a shifting of activity from one sector to another. Future studies should examine patient decision making regarding reasons for presenting to a new or pre-existing ED. There is an inherent need to take a ‘whole of health service area’ approach to solve crowding issues.

Digital image databases support GIS operations

Evaluates trends in the imagery built into GIS applications to supplement existing vector data of streets, boundaries, infrastructure and utilities. These include large area digital orthophotos, Landsat and SPOT data. Future developments include 3 to 5 metre pixel resolutions from satellites, 1 to 2 metres from aircraft. GPS and improved image analysis techniques will also assist in improving resolution and accuracy.