Hacks

An Open Source Mapping Application for Hatchery Release Data in the Columbia River Basin

Session Type: 
Poster
Presenter(s): 
Lynnae Sutton, Fish Passage Center

The Fish Passage Center (FPC) maintains a hatchery database of anadromous salmonid species released from State, Federal, and Tribal hatcheries in the Columbia River Basin. This database is updated routinely throughout the fish passage season. Over the past year, the location of the hatcheries and the release sites were mapped and an online mapping application was developed to allow the users of this database a spatial view of where hatcheries have released anadromous salmonids throughout the Columbia River Basin since 1979. Additionally, it allows users to map and download real-time release data for the current year. Application users spatially query for and select a specific hatchery and all of the locations where the selected salmonid species have been released by that hatchery. The map zooms to the spatial extent of the selected sites and a table containing the release data is opened and the data are made available for download in several formats. There are other spatial queries available in the application including: selecting release sites and data by watershed, major river or by major river zone. The release data provide regional Salmon Managers with the information needed to assess the current year’s migration of juvenile hatchery fish through the hydrosystem. In addition, the release data have been used to access present and historical production releases, timing and magnitude of salmon runs, population estimates and the proportion of hatchery fish that are tagged or clipped. This presentation / poster describes the development of the hatchery mapping application. The open source software stack used for the FPC Hatchery Mapping Application includes: MapServer, PostgreSQL, PostGIS, and p.mapper.

Speaker Bio: 

Lynnae Sutton has a BS in Biology with a certificate in Computer Programming and an MS in Geography from PSU. She currently works as an IT Database Management Specialist/Web Developer for the Fish Passage Center.

Beyond Markers: a new approach to interactive realtime weather maps

Session Type: 
Tech Session
Presenter(s): 
Fergal Walsh, National Centre for Geocomputation, NUI Maynooth
Dr Christian Kaiser

Markers must go! At least when things concern continuous-space processes such as weather. Could anyone care less about a sensor with its exact measurement unless it is mounted exactly where the person is? Why not move beyond markers and point measurements and instead show values everywhere as surface overlays? Markers are interactive and can link to a pop-up timeline - but so are the surface overlays! This is now possible thanks to the availability of fast spatial predictors, efficient storage mechanisms and fast client side rendering.

This talk will outline an open source web application for realtime modelling and visualisation of time-varying continuous-space fields. We will discuss the technical challenges of building this application from the server side perspective of data collection, modelling and storage and from the client side perspective of visualisation and interactivity.

We will describe our approach to an integrated spatio-temporal modelling and visualization of temperatures and rainfall. The predicted temperature surfaces and rain radar data are displayed as overlays in OpenLayers using a custom layer which renders the data on the client side using the HTML5 Canvas Element. The timeline for arbitrary spatial location is built upon the Flot plotting library and is rendered the same way. These elements are backed by a server side raster cube, implemented as a georeferenced multidemensional memory mapped Numpy array. We developed this data structure specifically for storing timestamped raster data in a way that allows for very efficient spatial and temporal slicing. And for those curious ones interested in sub-raster resolutions there is always a live server-side stream oracle ready to compute predictions with MapReduce on multicore.

Speaker Bio: 

Fergal Walsh is a Phd student at the National Centre for Geocomputation at NUI Maynooth. His research interests include spatio-temporal data analysis and visualisation and understanding human communication and movement patterns. He is also interested in software development and is the lead developer i2maps, an open source software project at NCG.

Schedule info

Bringing the oceans to life using OGC services and dynamic visualization

Session Type: 
Tech Session
Presenter(s): 
Kyle Wilcox, Applied Science Associates
Stephen Sontag

Public domain data about the ocean is all over the place. Different formats, different standards, and what about that metadata? Putting these distributed datasets behind OGC services allow for the visualization and analysis on an even playing field. By leveraging these OGC services, powerful visualizations for scientists and general users alike can be created and extended to almost any area of the world.

Applied Science Associates is a global science and technology solutions company. Through consulting, environmental modeling, and application development, ASA helps a diverse range of clients solve a wide range of spatial challenges.

This presentation will include practical examples of using OGC services to change the way we look at dynamic (real-time) ocean data.

Technologies include: Flex, OpenScales, NetCDF, AXIIS, Degrafa, SOS, WMS, WFS, AIS

Speaker Bio: 

Mr. Wilcox is a senior data manager and software engineer at Applied Science Associates in South Kingstown, RI, USA.  He has extensive experience working on ocean observing systems around the world and specializes in software development, GIS / data integration, crisis management, met-ocean data, and integration of a wide variety of computer models for simulation of physical, chemical and biological processes in the marine environment.

Mr. Sontag is a Software Developer with Applied Science Associates (ASA) who implements geographic data management principles into easy to use web applications. He is an active web developer that incorporates his broad background in GIS data visualization and management skills to create resource management systems.  Stephen has development multiple rich client web applications leveraging standard and non-standard geographic data formats integrating spatial metadata services.

Schedule info

WFS and SQL Injection

Session Type: 
Lightning Talk
Presenter(s): 
Olivier Courtin, Oslandia

OGC WFS-T allows client apps to have write access on features stored server side through a Web Service API.

Commonly such features are stored in a spatial databases.

Forthcoming WFS 2.0 would even add stored query sent from the WFS client, which could then execute them on demand.

All theses great features have security counterparst, and could lead to SQL Injection vulnerabilities.

The issues raised and answered in this lightning talk will be :

  • Where are the main SQL Injection risks in WFS specs implementations ? (WFS-T, Filter Encoding and WFS 2.0 ?
  • What tools or tests could help to detect them?

 

Speaker Bio: 

Olivier is the main developper and maintainer of TinyOWS since 2007. He's also involved in PostGIS project, as both projects are somewhere tied.

 
Olivier is with Vincent Picavet owner of Oslandia, a small company focused on Open Source GIS.

Schedule info

Social Networks on OpenLayers

Session Type: 
Tech Session
Presenter(s): 
Jorge Sanz, Prodevelop
Vicente Sanjaime

As part of the web 2.0 movement, a number of social networks are adding geospatial information to their contents. Thus, a large amount of information can be shown on a map from different sources like twitter, foursquare, flickr and others.

With just a few chunks of JavaScript code and thanks to the great Open Layers capabilities, it's easy to add real time social features to any web mapping application.

On this presentation we will show how we added those services as OpenLayers classes getting as much information as possible (descriptions, thumbnails, links, etc.) displayed on top of any base layer.

Speaker Bio: 

Jorge Sanz is consultant in geospatial technologies at Prodevelop since 2006. He's also part of the gvSIG team, Charter Member of the OSGeo Foundation, as well as part of the Spanish language OSGeo Local Chapter. He also maintains with several friends and colleagues a blog about GIS, cartography and other geoscience topics since 2006 called http://geomaticblog.net.

Schedule info

Syndicate content