Okanagan Nation Alliance Data Portal

[vc_row][vc_column][vc_column_text]

Okanagan Nation Alliance Data Portal

The Okanagan Nation Alliance Fisheries Department Data Portal (ONAFD) is an enterprise relational database developed in SQL Server, with an emphasis on a custom metadata standard for the Skaha Lake Experimental sockeye reintroduction program.

This metadata database serves as the central storage facility for all ONAFD raw data files associated with the Skaha Lake Experimental Sockeye reintroduction program.

It became clear in 2008 that there was a higher priority need to develop a more complete metadata standard and improve management of raw data files related to ongoing monitoring in the Skaha program that was being conducted by the ONA fisheries department. A new secure web-enabled data portal was created for organizing all raw data and related metadata for the Skaha Lake Experimental Sockeye Reintroduction Program.

ESSA created a “keep alive” upload process for large heterogeneous file uploads, added a search feature, and a “one zip” download functionality to make it easy to obtain all attached files associated with a particular upload. In addition, we developed administrative features that enable the system administrator to add users, reset passwords, and control user access levels.

A fundamental concept in the design of the Data Portal is that all raw data files that are uploaded to the system are actually stored in this database, rather than the file server. This maximizes protection against accidental deletion of files from the file server, and ensures that all files are fundamentally traceable, backed up and “go with” this SQL Server enterprise data store that includes standardized metadata tags.

ESSA also continued to host the web portal application and underlying database, to enable full scale testing by ONA staff and Skaha Experimental Reintroduction Program investigators.[/vc_column_text][vc_column_text css=”.vc_custom_1513641560598{margin-bottom: 20px !important;padding-top: 15px !important;padding-right: 5% !important;padding-bottom: 15px !important;padding-left: 5% !important;background-color: #efefef !important;}”]

Keywords & Themes: Data management / Integrated data / Open crowd sourced data / Web application / Fisheries resources

[/vc_column_text][/vc_column][/vc_row][vc_row][vc_column][vc_separator color=”white”][vc_btn title=”Back to Tools” style=”flat” shape=”square” link=”url:https%3A%2F%2Fdev2026.essa.com%2Fexplore-essa%2Ftools%2F|||”][vc_separator color=”white”][/vc_column][/vc_row]

Scroll to Top
OUR APPROACH
Lorem ipsum dolor sit amet, consectetur adipiscing elit. In eget justo dui. Mauris.
WHO WE SERVE
Lorem ipsum dolor sit amet, consectetur adipiscing elit. In eget justo dui. Mauris dignissim
We bring science and people together to help navigate complex environmental decisions.
FEATURE PROJECT
Natural Resource & Energy