The NC DEQ will continue work to build a consolidated socioeconomic database for the north carolina division of marine fisheries (NCDMF) to organize existing data for easier analysis and standardize…

The NC DEQ will continue work to build a consolidated socioeconomic database for the north carolina division of marine fisheries (NCDMF) to organize existing data for easier analysis and standardize future data entry and storage, as well as facilitate transmissions of fishery-dependent socioeconomic data to the atlantic coastal cooperative statistics program (ACCSP) data warehouse. NCDMF staff will work with their IT staff on a requirements document to detail specific needs and expectations of the new data structure and corresponding input/output (I/O) interface. NC DEQ staff will consolidate the data into a relational database within SQL server. This database will be able to interact with the NCDMF FIN database where the commercial license data are stored as well as access to the wildlife resources commission gooutdoors (formerly known as alvin) database where the recreational license data are stored. NC DEQ will build a web-based application to serve as the front-end interface for data entry and editing. The new SQL server database and web-based interface will allow for consolidation of data for optimized use by the NCDMF to meet fishery management goals. Once the data are consolidated, a file can be submitted to ACCSP for use by other state partners and in regional fishery management plans such as black sea bass, bluefin tuna, american shad, cobia, and other commercially and recreationally targeted species in north carolina.