تصمــــــــيم و تطبيــــــق قواعــــــــــــد البيانــــــــــــــــــــــــات الجغرافيــــــــــــــــــــــــــــــه

G I S Spatial Database Design and Implementations

 

Overview

GIS professionals often need to work with very large spatial datasets. Framework data relating to cadastre, topography, soil, land use cover, hydrography, geology, transportation and others. The processes of producing, providing, using, maintaining, exchanging and sharing these data are complex in nature, Large spatial data volumes have to be managed using geographical information systems (GIS) and database technology.

Objectives

This course explains the steps involved in the spatial database design and implementation process, from preliminary planning to schema creation. Hands-on live examples provide an exposure to basic tools used to create, use, edit, and manage spatial and attribute data stored in the GIS Database using Microsoft Access - ESRI ArcGIS 9.1 software. The course presents the GIS databases different scopes, personal and enterprise solutions.

Audience

This course is ideally suited for spatial data managers, GIS data modelers, GIS database designers, and GIS analysts. New and existing spatial data managers waiting to migrate to the GIS will benefit from this course.

Perquisites

This is an intermediate course. Participants should be familiar with GIS concepts. Prerequisite skills may be obtained in Introduction to Geographic Information Systems course

Contents

 

  Databases history, terminologies, concepts and definitions.

  Introducing the different Relationships diagramming techniques.

  Present GIS database ER diagrams. 

  Understanding the basics and concepts of GIS technologies.

  Spatial Database planning and design procedures.

  Designing a new GIS database, thinking in long term.

  Database organizations; naming conventions, documentation, creating and using metadata.

  Spatial referencing; Introducing map projections and coordinate systems.

  Implement your GIS Database design; schema, tables, layers, and relationships.

  Data automation; digitize a georeferenced satellite image, data migration from different sources to GIS database.

  Create tables' relationships to use for symbolizing, labeling and querying data.

  Producing the GIS Database implementations at both personal and Enterprise scope.

  Introducing the Database Backup, restore and recovery concepts