{"id":249,"date":"2014-08-06T16:27:41","date_gmt":"2014-08-06T16:27:41","guid":{"rendered":"https:\/\/virtuallearn.wpengine.com\/fits\/?p=249"},"modified":"2017-08-06T16:32:02","modified_gmt":"2017-08-06T16:32:02","slug":"fins-the-fish-database-web-application-in-missouri","status":"publish","type":"post","link":"https:\/\/units.fisheries.org\/fits\/2014\/08\/06\/fins-the-fish-database-web-application-in-missouri\/","title":{"rendered":"FINS: The Fish Database Web Application in Missouri"},"content":{"rendered":"<h3>Submitted by Dave Mayers &amp; Rodney Britt<\/h3>\n<p>Have you ever wanted to look at fish population indices from a body of water on the other side of the state?\u00a0 Or needed to compare the present fish population in a lake to that found 10 years ago?\u00a0 These are questions asked all the time by fisheries managers and researchers.<\/p>\n<div class=\"media-thumbnail-frame\"><img decoding=\"async\" class=\"media-image\" src=\"http:\/\/www.fishdata.org\/sites\/default\/files\/styles\/large\/public\/201404\/header.jpg?itok=XR9YEBz5\" alt=\"\" width=\"480\" height=\"95\" \/><\/div>\n<p>Fisheries Information Network System (FINS) is a software package developed by the Missouri Department of Conservation (MDC) to 1) manage and record fish management and research data and 2) provide detailed analysis and reporting of these data.\u00a0 FINS is a web application housed on MDC\u2019s intranet with all program data being stored on MDC\u2019s central servers .\u00a0 The decision to develop a web based application over a desktop application was based on the web\u2019s advantages of easily shared data, efficient and complete updates of the program as needed, and long term data security.\u00a0 The application was developed by a team of fisheries biologists, research scientists and IT program specialists.<\/p>\n<p>This software package details information for individual fish and metadata about the sample; 1) WHY the Collection was made,\u00a0 2) WHEN it was made, 3) WHERE it was performed, and 4) HOW it was done (what gear). Having this metadata entered into FINS is extremely valuable for future biologists who need to understand the whole story behind the fish data.<\/p>\n<p>The primary categories recorded within FINS are:<\/p>\n<ul>\n<li>Water Body \u2013 Which Missouri water body the fish sample was obtained from.<\/li>\n<li>Collection \u2013 A grouping of related fish samples.\u00a0 Usually all the fish samples performed on a body of water for a particular year.<\/li>\n<li>Sites \u2013 Description of the physical location on the water body where the fish sample was performed. This includes UTM information.<\/li>\n<li>Runs \u2013 Records each \u201crun\u201d or event when fish were collected. Records 1) date of run, 2) portion of the site where the run occurred, and 3) the method used to capture the fish (electrofishing, netting, hooking, or observation).<\/li>\n<li>Fish Data \u2013 Detailed information such as length, frequency, weight, tags, population estimate marks, and age for each fish.<\/li>\n<li>Bony Part\/Annuli \u2013 Record age\/growth information from the bony part of a fish.<\/li>\n<\/ul>\n<h2><strong>Bony Part Analysis<\/strong><\/h2>\n<p>FINS contains a special screen called the \u201cHeads Up Display\u201d (HUDS) to measure the distance between annuli on a bony part. HUDS allows an image of a Bony Part to be loaded on the screen where a biologist can \u201cclick\u201d on each annuli. HUDS then saves the distance between each annuli.\u00a0 These measurements are used to create several different age reports.<\/p>\n<div class=\"media-thumbnail-frame\"><img fetchpriority=\"high\" decoding=\"async\" class=\"media-image\" src=\"http:\/\/www.fishdata.org\/sites\/default\/files\/styles\/large\/public\/201404\/2.jpg?itok=2u4HSVsN\" alt=\"\" width=\"451\" height=\"480\" \/><\/div>\n<h2><strong>Reports<\/strong><\/h2>\n<p>Once information is stored into FINS, a series of reports are available that allows detailed analysis of the fish samples. The report generator allows users to filter data by input parameters such as waterbody, fish species, sites, runs, and tag information.\u00a0 Reports currently available in FINS are:<\/p>\n<ul>\n<li>Age &#8211; Growth Summary<\/li>\n<li>Average Annual Increments of Back Calculated Lengths for Each Age Class<\/li>\n<li>Average Back Calculated Lengths by Age<\/li>\n<li>Individual Back Calculated Annual Increments<\/li>\n<li>Individual Back Calculated Lengths<\/li>\n<li>Length Frequency by Age Class<\/li>\n<li>Length Frequency Listing<\/li>\n<li>Length Frequency Summary<\/li>\n<li>Population Estimate \u2013 Chapman Method<\/li>\n<li>Population Estimate \u2013 Schnabel Method<\/li>\n<li>Relative Weight by Length Category<\/li>\n<li>Relative Weight by Size Increment<\/li>\n<li>Relative Weight Table (Individuals)<\/li>\n<li>Species Frequency<\/li>\n<li>Fish Sample data can also be exported to Excel for quality control analysis and individualized graph and table creation.<\/li>\n<\/ul>\n<p>All reports generate a \u201ccover sheet\u201d showing all the input metadata used to generate the report.\u00a0 Exportable tables and graphs are part of most reports.<\/p>\n<p><u>Report Examples:<\/u><\/p>\n<div class=\"media-thumbnail-frame\"><img decoding=\"async\" class=\"media-image\" src=\"http:\/\/www.fishdata.org\/sites\/default\/files\/styles\/large\/public\/201404\/3.jpg?itok=yMCux8qi\" alt=\"\" width=\"480\" height=\"350\" \/><\/div>\n<div class=\"media-thumbnail-frame\"><img loading=\"lazy\" decoding=\"async\" class=\"media-image\" src=\"http:\/\/www.fishdata.org\/sites\/default\/files\/styles\/large\/public\/201404\/4.jpg?itok=6XXA12y-\" alt=\"\" width=\"480\" height=\"339\" \/><\/div>\n<h2><strong>Data Security<\/strong><\/h2>\n<p>One common question we get from new FINS users is, \u201cif everyone on our intranet can see my data, how do I know it will not be deleted or changed?\u201d\u00a0 Only approved FINS users can access the application and the creator of the collection can designate up to three additional users with editing rights.\u00a0 After a collection is quality checked, the collection coordinator \u201cApproves\u201d the collection which locks down the data set, thus preventing any editing.\u00a0 Only the coordinator can unapproved a collection so it can be edited again.\u00a0 Once the collection is approved, other users can still view, run reports on the data, and export data for further analysis.\u00a0 This system assures long term security of the data.<\/p>\n<p>Another good information archiving feature of FINS is the option to add notes and attachments to most levels (Collection, Site, Run, and Fish Data).\u00a0 Attachments can include any file type.\u00a0 Common attachments are sample site maps, research proposals, final reports, and bony part images.<\/p>\n<h2><strong>Technical Details<\/strong><\/h2>\n<p>FINS is a .net application written in C# with an MSSQL database. The reports are developed on SQL Server Reporting Services (SSRS) and T-SQL stored procedures.<\/p>\n<p>Missouri\u2019s fisheries managers and researchers now have a powerful and secure application they can use to easily store, view, analyze, and share their fish data.<\/p>\n<p>&nbsp;<\/p>\n<hr \/>\n<p>For more information about FINS contact Missouri Department of Conservation Fisheries Division in Jefferson City, 5573\/751-4115<\/p>\n<p>Dave Mayers<br \/>\nFisheries Regional Supervisor &#8211; Retired<br \/>\nMissouri Department of Conservation<br \/>\n551 Joe Jones Blvd.<br \/>\nWest Plains, MO 65775<br \/>\n417\/256-7161<\/p>\n<p>Rodney Britt<br \/>\nContractor Project Manager<br \/>\nMissouri Department of Conservation<br \/>\n2901 W Truman Blvd<br \/>\nPO Box 180<br \/>\nJefferson City, MO 65102<br \/>\n573\/751-4115<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Submitted by Dave Mayers &amp; Rodney Britt Have you ever wanted to look at fish population indices from a body of water on the other side of the state?\u00a0 Or needed to compare the present fish population in a lake to that found 10 years ago?\u00a0 These are questions asked all the time by fisheries [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[7,4],"tags":[14,12],"class_list":["post-249","post","type-post","status-publish","format-standard","hentry","category-member-contributions","category-news","tag-data-management","tag-software","odd","first-child","last-child"],"wppr_data":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>FINS: The Fish Database Web Application in Missouri - Data and Technology Section<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/units.fisheries.org\/fits\/2014\/08\/06\/fins-the-fish-database-web-application-in-missouri\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"FINS: The Fish Database Web Application in Missouri - Data and Technology Section\" \/>\n<meta property=\"og:description\" content=\"Submitted by Dave Mayers &amp; Rodney Britt Have you ever wanted to look at fish population indices from a body of water on the other side of the state?\u00a0 Or needed to compare the present fish population in a lake to that found 10 years ago?\u00a0 These are questions asked all the time by fisheries [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/units.fisheries.org\/fits\/2014\/08\/06\/fins-the-fish-database-web-application-in-missouri\/\" \/>\n<meta property=\"og:site_name\" content=\"Data and Technology Section\" \/>\n<meta property=\"article:published_time\" content=\"2014-08-06T16:27:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-08-06T16:32:02+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.fishdata.org\/sites\/default\/files\/styles\/large\/public\/201404\/header.jpg?itok=XR9YEBz5\" \/>\n<meta name=\"author\" content=\"Rebecca Krogman\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Rebecca Krogman\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/units.fisheries.org\/fits\/2014\/08\/06\/fins-the-fish-database-web-application-in-missouri\/\",\"url\":\"https:\/\/units.fisheries.org\/fits\/2014\/08\/06\/fins-the-fish-database-web-application-in-missouri\/\",\"name\":\"FINS: The Fish Database Web Application in Missouri - Data and Technology Section\",\"isPartOf\":{\"@id\":\"https:\/\/units.fisheries.org\/fits\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/units.fisheries.org\/fits\/2014\/08\/06\/fins-the-fish-database-web-application-in-missouri\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/units.fisheries.org\/fits\/2014\/08\/06\/fins-the-fish-database-web-application-in-missouri\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.fishdata.org\/sites\/default\/files\/styles\/large\/public\/201404\/header.jpg?itok=XR9YEBz5\",\"datePublished\":\"2014-08-06T16:27:41+00:00\",\"dateModified\":\"2017-08-06T16:32:02+00:00\",\"author\":{\"@id\":\"https:\/\/units.fisheries.org\/fits\/#\/schema\/person\/f31c10ee61e3e94e31a9d1574a7f290c\"},\"breadcrumb\":{\"@id\":\"https:\/\/units.fisheries.org\/fits\/2014\/08\/06\/fins-the-fish-database-web-application-in-missouri\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/units.fisheries.org\/fits\/2014\/08\/06\/fins-the-fish-database-web-application-in-missouri\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/units.fisheries.org\/fits\/2014\/08\/06\/fins-the-fish-database-web-application-in-missouri\/#primaryimage\",\"url\":\"http:\/\/www.fishdata.org\/sites\/default\/files\/styles\/large\/public\/201404\/header.jpg?itok=XR9YEBz5\",\"contentUrl\":\"http:\/\/www.fishdata.org\/sites\/default\/files\/styles\/large\/public\/201404\/header.jpg?itok=XR9YEBz5\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/units.fisheries.org\/fits\/2014\/08\/06\/fins-the-fish-database-web-application-in-missouri\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/units.fisheries.org\/fits\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"FINS: The Fish Database Web Application in Missouri\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/units.fisheries.org\/fits\/#website\",\"url\":\"https:\/\/units.fisheries.org\/fits\/\",\"name\":\"Data and Technology Section\",\"description\":\"Connecting fisheries professionals with the tools they need\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/units.fisheries.org\/fits\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/units.fisheries.org\/fits\/#\/schema\/person\/f31c10ee61e3e94e31a9d1574a7f290c\",\"name\":\"Rebecca Krogman\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/units.fisheries.org\/fits\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8b7aaddbccb1023f7dadfb8b9772ad829421a9953e9b8549db00ba1206f76153?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8b7aaddbccb1023f7dadfb8b9772ad829421a9953e9b8549db00ba1206f76153?s=96&d=mm&r=g\",\"caption\":\"Rebecca Krogman\"},\"url\":\"https:\/\/units.fisheries.org\/fits\/author\/rebeccakrogman\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"FINS: The Fish Database Web Application in Missouri - Data and Technology Section","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/units.fisheries.org\/fits\/2014\/08\/06\/fins-the-fish-database-web-application-in-missouri\/","og_locale":"en_US","og_type":"article","og_title":"FINS: The Fish Database Web Application in Missouri - Data and Technology Section","og_description":"Submitted by Dave Mayers &amp; Rodney Britt Have you ever wanted to look at fish population indices from a body of water on the other side of the state?\u00a0 Or needed to compare the present fish population in a lake to that found 10 years ago?\u00a0 These are questions asked all the time by fisheries [&hellip;]","og_url":"https:\/\/units.fisheries.org\/fits\/2014\/08\/06\/fins-the-fish-database-web-application-in-missouri\/","og_site_name":"Data and Technology Section","article_published_time":"2014-08-06T16:27:41+00:00","article_modified_time":"2017-08-06T16:32:02+00:00","og_image":[{"url":"http:\/\/www.fishdata.org\/sites\/default\/files\/styles\/large\/public\/201404\/header.jpg?itok=XR9YEBz5","type":"","width":"","height":""}],"author":"Rebecca Krogman","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Rebecca Krogman","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/units.fisheries.org\/fits\/2014\/08\/06\/fins-the-fish-database-web-application-in-missouri\/","url":"https:\/\/units.fisheries.org\/fits\/2014\/08\/06\/fins-the-fish-database-web-application-in-missouri\/","name":"FINS: The Fish Database Web Application in Missouri - Data and Technology Section","isPartOf":{"@id":"https:\/\/units.fisheries.org\/fits\/#website"},"primaryImageOfPage":{"@id":"https:\/\/units.fisheries.org\/fits\/2014\/08\/06\/fins-the-fish-database-web-application-in-missouri\/#primaryimage"},"image":{"@id":"https:\/\/units.fisheries.org\/fits\/2014\/08\/06\/fins-the-fish-database-web-application-in-missouri\/#primaryimage"},"thumbnailUrl":"http:\/\/www.fishdata.org\/sites\/default\/files\/styles\/large\/public\/201404\/header.jpg?itok=XR9YEBz5","datePublished":"2014-08-06T16:27:41+00:00","dateModified":"2017-08-06T16:32:02+00:00","author":{"@id":"https:\/\/units.fisheries.org\/fits\/#\/schema\/person\/f31c10ee61e3e94e31a9d1574a7f290c"},"breadcrumb":{"@id":"https:\/\/units.fisheries.org\/fits\/2014\/08\/06\/fins-the-fish-database-web-application-in-missouri\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/units.fisheries.org\/fits\/2014\/08\/06\/fins-the-fish-database-web-application-in-missouri\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/units.fisheries.org\/fits\/2014\/08\/06\/fins-the-fish-database-web-application-in-missouri\/#primaryimage","url":"http:\/\/www.fishdata.org\/sites\/default\/files\/styles\/large\/public\/201404\/header.jpg?itok=XR9YEBz5","contentUrl":"http:\/\/www.fishdata.org\/sites\/default\/files\/styles\/large\/public\/201404\/header.jpg?itok=XR9YEBz5"},{"@type":"BreadcrumbList","@id":"https:\/\/units.fisheries.org\/fits\/2014\/08\/06\/fins-the-fish-database-web-application-in-missouri\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/units.fisheries.org\/fits\/"},{"@type":"ListItem","position":2,"name":"FINS: The Fish Database Web Application in Missouri"}]},{"@type":"WebSite","@id":"https:\/\/units.fisheries.org\/fits\/#website","url":"https:\/\/units.fisheries.org\/fits\/","name":"Data and Technology Section","description":"Connecting fisheries professionals with the tools they need","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/units.fisheries.org\/fits\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/units.fisheries.org\/fits\/#\/schema\/person\/f31c10ee61e3e94e31a9d1574a7f290c","name":"Rebecca Krogman","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/units.fisheries.org\/fits\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8b7aaddbccb1023f7dadfb8b9772ad829421a9953e9b8549db00ba1206f76153?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8b7aaddbccb1023f7dadfb8b9772ad829421a9953e9b8549db00ba1206f76153?s=96&d=mm&r=g","caption":"Rebecca Krogman"},"url":"https:\/\/units.fisheries.org\/fits\/author\/rebeccakrogman\/"}]}},"_links":{"self":[{"href":"https:\/\/units.fisheries.org\/fits\/wp-json\/wp\/v2\/posts\/249","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/units.fisheries.org\/fits\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/units.fisheries.org\/fits\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/units.fisheries.org\/fits\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/units.fisheries.org\/fits\/wp-json\/wp\/v2\/comments?post=249"}],"version-history":[{"count":0,"href":"https:\/\/units.fisheries.org\/fits\/wp-json\/wp\/v2\/posts\/249\/revisions"}],"wp:attachment":[{"href":"https:\/\/units.fisheries.org\/fits\/wp-json\/wp\/v2\/media?parent=249"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/units.fisheries.org\/fits\/wp-json\/wp\/v2\/categories?post=249"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/units.fisheries.org\/fits\/wp-json\/wp\/v2\/tags?post=249"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}