Global Data Integration...

The Wildlife Conservation Society runs the Global Avian Influenza Network for Surveillence (GAINS) program, to which scientists from around the world submit data. The highly normalized epidemiological database that houses this data has well over 50,000 records from all around the planet. The challenge was to provide a high-performance spatial context to this data, while still allowing users to issue complex queryies againt the rich dataset.

Click on an image to enlarge.

Project Goals

Performance

Previous versions of the GAINS mapping system had unacceptable performance profiles - it would take 5 seconds or more to render a map. The bottle neck was handling the mix of spatial and tabular queries - the GIS environment could do the fast spatial queries (which points are in the current visible extent) and the tabular environment could handle the attribute queries ("show me only H5N1 Positive cases"), but linking the two was problematic.

Since the system was only dealing with point data, the team opted to skip the spatial query, and do everything in the database using simple Latitude and Longitude fields embedded within the epidemiological datasets. This facilitated the bounding box queries to be combined with the complex attribute queries, and still have query times in the 100's of milliseconds.

Focused Tools

Creating a very focused application helps ensure that the system is easy to use. By not trying to be all things to all users" the development effort was put into a small set of tools which are both easy to use, and very fast.

High-Performance

Since the release of Google Maps, end user expectations for web-based mapping application are very high. And in a high-energy environment like an emergency response operations center, time is of the essence. This system utilizes map caches for the majority of the data sets, thus making most map interactions nearly instantaneous. Analytical operations utilize the ArcGIS Server SOAP API which is also extremely responsive.


Project Workflow

Design Phase

The design phase of this project focused on the creation of mock-ups for the system. These gave the WCS team a better feel for how the system would look, as well as how the workflows would be implemented.

Agile Development

Through the development process, the team released the software to the client every two weeks. This transparency during development ensured that both the team and our clients knew exactly what was being built, and that it was meeting the actual needs of the users.


technologies

DotNetNuke (DNN)

DNN is an open source content managment system built on Microsoft ASP.NET. The Wildlife Conservation Society runs a number of web sites based on DNN, and the modular nature of the system allows them to plug-and-play components across their whole ecosystem of sites.

Microsoft Virtual Earth

Since the GAINS dataset is global in nature, WCS needed a map canvas with a high-quality global dataset. The Virtual Earth control easily facilitated fetching and rendering points from a custom web service. By using Ajax techniques, the team was able to minimize the amount of data transmitted to the browser, thus increasing the performance of the system.

ArcGIS Server

Although the point data comes directly from the SQL Server database, ArcGIS Server is used to fetch the species flyway polygons from an layer in ArcSDE. A custom webservice was created which uses the ArcGIS Server SOAP API to get the feature geometry from ArcSDE, and then transform it into GeoJSON, which is then used within Virtual Earth to create the flyway polygon.

Dojo Toolkit

The Dojo Toolkit is a comprehensive javascript application framework that can be used to build rich client application in the browser. It is used for the menu's and the dialog boxes on the GAINS application.

Technologies:

  • DotNetNuke
  • ASP.NET
  • SQL Server 2005
  • ArcGIS Server 9.3
  • Microsoft Ajax
  • Virtual Earth
  • DojoToolkit

Project Team:

Mike Juniper Avatar Dave Bouwman Avatar

DTSAgile cares about your business problems, your customers, your users, and we know intimately how much difference having the right software can make in your day to day operations.


From traditional GIS applications to the latest web 2.0 mapping apps, from asset management to financial reporting, from GIS analysis to high-end cartography and design, DTS has done it all.


Use this handy contact form to get in touch with us and take the first step in learning how DTSAgile ships quality on time, every time.

Name

Email

Message Subject

Your Message