Lonnie Hearne by 05pHue

VIEWS: 5 PAGES: 21

									Geospatially Enabled
Environmental Databases
  Rocket City Geospatial Conference
  November 17 2009
Geospatially Enabled Databases


   Enterprise decision support              Transition from “maps” to
    applications require access to             “geospatial decision tools”
    diverse data in addition to
    traditional GIS layers
   Geodatabase architectures greatly        Geodatabase allows a more
    expand ability store and access           conventional approach to data
    diverse data                              storage
   Such data is often in form of            Data in flat file format presents
    published reports, historical studies,    additional challenges
    imagery, etc.
   Capitalizing on this type of data
                                             Geographic extents must be
    requires it to be “geospatially
    enabled”                                   assigned to individual resource
                                               documents




                                                                                  2
Recent Examples of Such
Projects
   US Corps of Engineers Wolf
    Creek Dam Analysis
      Spatially enabled over 60 years of
        data, CADD drawings, images,
        boring logs, spreadsheets, and
        photos




                                               US Army National Guard
                                                Environmental Databases
                                                  Spatially enabled environmental
                                                   databases for public involvement
                                                   and environmental management




                                                                                      3
Department of Interior Ecospatial
Information Database (ESID)



   Department of Interior Minerals Management Service manages leasing
    in the Outer Continental Shelf
      Non-renewable (oil and gas)
      Renewable (wind, wave, current) energy sources

   ESID Project goals
      Support ecosystem-based management of activities permitted by MMS in
       the MMS Atlantic Planning Areas.
      Compile georeferenced ecological information resources and associated
       metadata into a searchable geospatial database.
      Provide compatible data for the MMS Multipurpose Marine Cadastre (MMC)
       system.




                                                                                4
Project Concept



                     Collect all relevant data for the
                      Atlantic MMS planning areas
                     Spatially enable relevant resources
                     Use areas of interest as basis for
                      spatial query to identify relevant
                      resources
                     Provide for data query of resources
                      within areas of interest




                                                            5
Resource Data Collection



   Assimilation of ecological data
    relative to the three MMS Atlantic
    Planning Areas of interest together
    with the scientific analysis required
    to determine what data is applicable
    to the program objectives.
      Data might be 40+ years old
      Relevance determines if it will be
       included




                                            6
Resource Categories
   Geology (including seafloor features, sediments)
   Meteorology/climate
   Air quality
   Water quality (including contaminants)
   Acoustic environment/underwater noise
   Pelagic ecology (plankton, nekton, Sargassum, etc.)
   Benthic ecology
      Seafloor features
      Infauna, meiofauna
      Demersal fishes
      Corals and hard/live bottom communities
      Seagrass beds (state waters)
   Incidental topics (included but not the focus of this study)
      Marine mammals
      Sea turtles
      Marine and coastal birds




                                                                   7
Resource Data Collection (Continued)


   Searching for studies, surveys,           Search Criteria
    scientific review papers, mapping          (Keywords)
    efforts, GIS datasets, etc.
                                            Bibliographic/ Library
   Preliminary search of bibliographic
                                                  Resource
    and library resources (e.g., Dialog®,
    OCLCTM WorldCat, govt. libraries,        Preliminary Output
    etc.) to identify titles of potential
    interest                                 Refined Keywords
                                              (as necessary)
   Output will determine whether
    search criteria must be refined         Full Resource Search




                                                                     8
Resource Data Collection (Continued)


   Search output will be analyzed       Search
    by ISRT for relevance using a        Output
    decision matrix
                                                        Decision
   Develop a Preliminary                                Matrix
    Resource List which MMS will     Internal Science
    review and approve                 Review Team


   Geographic information will be
    obtained for data as it is
    collected, where possible

                                                  Preliminary Resource
                                                           List
                                                                     9
Resource Annotation and
Geographic Characterization
                                                            Geographic
   Collected resources will be                           Characterization
    assigned geospatial data                               of Resources
    definitions describing
    geographic location within
    the three MMS Planning          Spatial location is
    Areas                          not available within
                                        resource                    Spatial location is

   Applying spatial definitions                                     available within
                                                                        resource
    of resources will allow
    spatial query within Areas        Authors and/or
    of Interest for data             collaborators are
    extraction                           Contacted
                                                                   Assign
                                                                 geographic
                                                                 coordinates



                                                                                          10
Resource Data Extraction Within
      Areas of Interest
   Relevant data/information pertinent to the needs
    of potential offshore leases will be extracted from
    resources within the ESID.
      Draft Proposed OCS Oil and Gas Leasing Program
       (2010-2015)
      The potential Virginia Lease Sale 220

   The Data Extraction Team (DET) with expertise
    within each scientific area will facilitate data
    extraction for all applicable fields of study
      Benthic Ecology
      Ichthyology
      Marine Botany
      Water Quality
      Toxicology
      Geology




                                                          11
Resource Data Extraction Within
Areas of Interest (Continued)


   Spatial extent of              Spatial query
   Areas of Interest               of collected
     defined and                    resources
      approved



    Data/information
       extracted              Data/information
        by DET                Loaded to ESID




                                                  12
Metadata
   Will be created for spatially-
    enabled database
   Geospatial resources will be
    associated with FGDC
    standards
   Support transition to ISO
    standard
   Perform evaluation of
    available metadata parsers
    (e.g.,mp)
   Produce in XML
   Perform QA




                                     13
    Metadata (Continued)

    General
     Categories:
     --Resource Info
     --Geospatial &
     Accuracy
     --Physical
     --Intellectual
     property




                       Federal Geographic Data Committee's "Content Standard for
                       Digital Geospatial Metadata" Version 2 - 1998. (FGDC-STD-001
                       June 1998)
                                                                                      14
15
ESID and Application Development

   Designing the ecospatial database architecture, which includes: creating
    the database, populating the database with properly formatted data, and
    creating useful applications that allow the data to be fully utilized for the
    MMS management task.




                                                                                    16
ESID Database and Interface
Development


   ESID Design / Creation




   ESID Population




   Create Custom Map Interface




                                  17
Arc Marine Data Model


   Collaboration involving researchers from
    Oregon State University, Duke, NOAA,
    and The Danish Hydraulic Institute

   ArcMarine model is a geodatabase
    template that provides a starting point for
    the conceptual design of the ocean
    features with spatial and temporal
    perspectives

   Integrates natural and manmade features
    of the ocean realm

   Provides a design approach to a
    volumetric model to represent the
    multidimensional and dynamic nature of
    ocean data and processes




                                                  18
Identify Potential Multi-Purpose
Cadastre Data Sources
   Potential MMC data sources will
    be identified and presented to
    the COTR for approval

   Initial stages of the resource
    data collection will tentatively
    identify relevant data sources

   Final identification of potential
    MMC data sources will be
    identified after ESID population
    and be easily retrieved by key
    word search

   MMC data structure is currently
    under investigation with NOAA
    to ensure content requirements


                                        19
Questions




            20
Contacts


 DOI/MMS Program Manager- Mr. James Sinclair, (504) 736-2789,
                  james.sinclair@mms.gov

   AMEC Technical Project Manager- Mr. Brett Fritze, (615)-333-
                  0630, brett.fritze@amec.ocm

  AMEC Program Manager- Mr. Lonnie Hearne, (615)-333-0630,
                 lonnie.hearne@amec.com




                                                                  21

								
To top