Laserfiche WebLink
<br />. 35 <br /> <br />Summary Project Description: The purpose of the GCMRC Database Management System <br />(DBMS) is to store and deliver all tabular and spatial data, via our Spatial Data Engine (SO E), <br />gathered as the result of GCMRC investigations and legacy data. Developing the DBMS requires <br />inventorying, organizing, archiving, and developing delivery systems for many years worth of <br />environmental data collection activities representing a vast array of disparate data including <br />physical, biological, cultural, socio-economic, and climatic information. Many datasets have <br />been integrated into our DBMS with additional datasets in working progress. The additional <br />data yet to be included in our DBMS are organ.ized in Microsot1 Excel files, Microsoft Access <br />databases, SAS, or another proprietary format. The DBMS program is currently working on <br />bringing together years of disparate historical data, collected by multiple entities located in <br />databases across the southwest, in an organized fashion and then deliver it transparently to <br />stakeholders and researchers for decision making and modeling purposes. Delivering data in an <br />automated fashion is key to the success of the DBMS. Accommodating such a task will be done <br />utilizing database driven web pages and ArcIMS, a web accessible tool to allow access to our <br />spatial data. These technologies can be integrated to deliver tabular and spatial data referenced <br />through the Oracle relational database. <br /> <br />MO's and IN's ADDRESSED: Besides supporting Goal 12, the DBMS indirectly assists <br /> <br />GCMRC personnel and cooperators in completing the majority of other resource MO's and IN's. <br /> <br />Consequences of FY06 Funding Recommendations: The currently proposed budget for FY <br />2006 will allow the database development to continue through a combination of internal staff <br />expertise and a cooperative agreement with an Oracle database expert. The Grand Canyon <br />Integrated Databases is currently severely understaffed and there is a constant threat of losing the <br />knowledge base necessary for basic database maintenance as well as the development of new <br />procedures that will allow increased access to the database for scientists, resources managers and <br />the public alike. Significant progress had been made in database accessibility during the second <br />half of FY2004 and the beginning of FY2005, unfortunately, owing to a change in personnel this <br />aspect of database development is likely to be reduced until the recently vacated role of database <br />programmer can be filled. <br /> <br />GCMRC FY2006 Annual Work Plan (Draft, June 10,2005) <br /> <br />e <br />) <br /> <br />- <br /> <br />I <br />, <br /> <br />. <br />