Mobile Solution for Inventory and Monitoring Case Study

Design and Development of a Mobile Solution for Inventory and Monitoring

Client

US DOI, National Park Service, Southeast Coast Network (SECN)

Project Highlights

  • Worked in direct partnership with National Park Service staff to create detailed object model for Inventory and Compliance Business.
  • Prepared technical solution alternatives, and detailed design specification. Full life-cycle development services including design and build, testing, user technical support and maintenance services.
  • Mobile solution linking field forms to SQL Server Database within a SharePoint environment.
  • Continues to provide technical user support and maintenance services.
  • Web services and Bing spatial analysis and viewer engine.
  • DataLOGIC met schedule requirements and the project was performed within budget.

Case Description

The DOI National Park Service, Southeast Coast Network (SECN), required the design, development and deployment of a data capture, storage and reporting solution to support mobile inventory and monitoring workflows in parks throughout the southeastern US, in accordance with various written data collection protocols. The project involved identification of user needs; database design and development; document storage, retrieval and access control; development of data entry forms; and database query and reporting.

DataLOGIC performed the initial Information Needs Assessment (INA) for this project, which identified both spatial and non- spatial data requirements. Using the results of the INA, DataLOGIC developed a conceptual object model and database design using Microsoft Visio. This system architecture was then used to create a SQL Server database that was used to store data for the various protocol components.

Data input in this system is supported through the use of forms developed using Microsoft InfoPath, which were designed to simulate field data collection forms included in the protocols. These forms utilized a web service developed in ASP.NET to submit the data to the SQL Server database and also to retrieve domain values from lookup tables in the SQL Server database, which were then used to provide valid values in the forms. Bing was used as the spatial analysis and viewing engine and integrated within the application environment. This solution provided a light platform for user data entry, reduced data errors and met user needs for quick input of data into the enterprise SQL Server database. InfoPath forms were deployed to the client’s Microsoft SharePoint MOSS website portal, which handles document management, access control, and versioning.

Reporting capabilities were provided through fixed reports developed using SQL Server Business Intelligence Development Studio (BIDS) and the Microsoft SQL Server Reporting Services Add-in for SharePoint. Additional reporting capabilities were provided via a custom Data Exploration Tool developed using Visual Studio, which allows users to generate their own custom queries against the database, and reports the results of these queries. The query results can then be exported in several formats, including PDF, Excel and plain text. We are currently designing a report tool to meet additional end-user demands. This system supports data collection efforts conducted at multiple client offices throughout the SECN.

Client Satisfaction Highlights

  • The agency was very satisfied with the quality of services offered.
  • There were no cost overruns.
  • All schedule requirements were met.