Presentations on Building a Geodatabase - PowerPoint by dwq67540


More Info
									       Class 8
 Geodatabase Review

        December 1, 2008

           GEOG CP250
“GIS Data and Database Design”
     GIS Certificate Program
University of Washington Extension
         Fall Quarter 2008
             Agenda for tonight
• Housekeeping items (project selection, turning in assignments,
• End of Quarter presentations
• Bad Maps presentations
   – Group 1 (Ed)
   – Group 2 (Rachel)
• Lecture: review Geodatabase Design

• Break

• Imagery Exercise Demo
• Exercise
   – Complete Last week’s exercise
   – This weeks exercise
• Team Project time
 End of Quarter Presentations
• Limit yourselves to 15 minutes
  – Leaves time for questions
• Give everyone a chance to speak
• Assume we, your audience, do not know
• Assume we know nothing about your
    End of Quarter Presentations
•   Team Introductions
•   Project Name and Project Sponsor
•   Project Description and rough Scope
•   Team member roles
•   Proposed deliverables
•   Potential challenges & unique aspects
             Bad Maps
• Map/Group 1 (Ed)
• Map/Group 2 (Rachel)
Geodatabase: reading the icons
• The geodatabase is the top “container”
• It can contain feature datasets, feature classes, or a number of other classes.
• Feature datasets are like subfolders in the geodatabase, containing feature
  classes or any of the other classes

                                                  feature dataset
                                                  geometric network

                                                  feature class

                                                  relationship class

                                                  annotation class

Database Fundamentals…
Databases are collections of tables with relationships
  established between them

… and programs that allow users interact with data

… or a more complex application like MS Access,
 Oracle, SQL Server, Informix, DB2, Sybase

… or product-specific proprietary applications
             Feature datasets
• A collection of related classes that share a
  common coordinate system.
• Used to spatially or thematically integrate related
  feature classes.
• Their primary purpose is for organizing related
  feature classes into a common dataset for
  building a topology, a network dataset, a terrain
  dataset, or a geometric network.
Feature Data Set Example
You must decide where it is appropriate to use subtypes and
where additional feature classes are required.

Keep the following in mind when deciding between creating subtypes
or new feature classes:
•   It is recommended that you create separate subtypes for a single feature
    class or table when you are trying to distinguish objects by their default
    values, attribute domains, connectivity rules, and relationship rules.
     –   Example: Streets: arterials, highways, residential subtypes

•   When you want to distinguish objects based on different behaviors,
    attributes, or access privileges or whether the objects are multiversioned,
    you must create additional feature classes.
     –   Example: Parcels, Lots, Easements

Subtypes behave as separate feature classes while editing in Arcmap
Object-relational data model
     Attribute domains…
                        Feature class PowerPoles

Range and coded value   Subtypes Wood           Steel
                        Domain      Height:    Height:
                                     20-30      30-50

   Feature class  Streets               PowerPoles
   based on Primary   Secondary      Wood       Steel
   Domain     ST, RD,    Ln, Cir,    Height:   Height:
             AV, BLVD      Pl         20-30     30-50
               Next Week….

• More Bad Maps
• Topology
  – lecture
  – Exercise
• Project & Exercise work
       Tonight’s activities…
• Project [selection] work
• Complete prior exercises
• Imagery Exercise
Feature Classes

To top