Presentations on Building a Geodatabase - PDF

Document Sample
Presentations on Building a Geodatabase - PDF Powered By Docstoc
					Geodatabase
Geodatabase
 Concepts
 Concepts


              Geodatabase-
              Geodatabase-   1
          Agenda
          Agenda

• Why a GDB?   Database
• Multi-User
  Concepts
• Resources        1 -1   1 -M




                             Geodatabase-
                             Geodatabase-   2
   Why a
   Why a
Geodatabase?
Geodatabase?


               Geodatabase-
               Geodatabase-   3
           Geodatabase
           Geodatabase

• A better GIS       Database
  data format:
  – Data Types
  – Data integrity    1 -1      1 -M


  – Scalability

                                       Geodatabase-
                                       Geodatabase-   4
  Not Just a Database
  Not Just a Database
           Data
           Model    Metadata
                                       ArcGIS

 Rules/
Behavior



                               Maps


 Models/                        . . . Simple Table
 Scripts                              Structure
                   Data               Re-usable
                                and Interoperable




                                                     Geodatabase-
                                                     Geodatabase-   5
More Data Types
More Data Types



                  Geodatabase-
                  Geodatabase-   6
          GDB Data Types
          GDB Data Types
•   Points, Lines, and
    Polygons (of
    course!)
•   M’s and Z’s
•   True Curves
    (circular,
    elliptical, bezier)

                           Geodatabase-
                           Geodatabase-   7
      More GDB Data Types
      More GDB Data Types
•   Annotation
•   Raster (Mosaics,
    Catalogs, Attributes)
•   Logical Networks
    (“Geometric”,
    Survey,
    Transportation,
    Topological)
•   Other (e.g.
    Dimensions)
                            Geodatabase-
                            Geodatabase-   8
Scalability
Scalability



              Geodatabase-
              Geodatabase-   9
                            What is Scalability?
                            What is Scalability?
Performance
              Local Files




                                 File Server




                                               RDBMS
              Local Files




                                 File Server




                                               RDBMS
                               More Data / More Users
                                                        Geodatabase-
                                                        Geodatabase-   10
    Two Flavors
    Two Flavors
•  Personal
  – For moderate amounts of data
  – Small numbers of editors
• Multi-User (ArcSDE/RDBMS)
  – Any amount of data
  – More than a few editors
  – Scalability / performance
                            Geodatabase-
                            Geodatabase-   11
RDBMS Scalability in Context
RDBMS Scalability in Context




                           Geodatabase-
                           Geodatabase-   12
           Why This And Not That?
           Why This And Not That?

                                 GIS
       GIS
    Business logic




                            Business logic and
         Data                data structures
      Structures




ESRI GDB Design            Other Design          Geodatabase-
                                                 Geodatabase-   13
Put Business Logic Where You Want It
Put Business Logic Where You Want It
Desktop GIS   Embedded GIS                            Mobile GIS

 ArcGIS       Other App                                Mobile
                                     Server GIS
                                                        GIS
                                                       Business

   GIS           GIS                                     logic
                Business
  Business        logic
    logic




                             Server Integration
                             Environ.    GIS
                                           Business
                                             logic



                             RDBMS                          Geodatabase-
                                                            Geodatabase-   14
Data Integrity
Data Integrity



                 Geodatabase-
                 Geodatabase-   15
Data Integrity = Rules
Data Integrity = Rules
 •   Flexibility
 •   Extensibility
 •   Scalability
 •   Additional, multi-
     user rules



                          Geodatabase-
                          Geodatabase-   16
         Scalable Integrity
         Scalable Integrity
•  Attribute Rules
  – Attribute values
  – Relationship
    Classes
• Spatial Rules
  – Topology
  – Networks
• Custom Rules
                              Geodatabase-
                              Geodatabase-   17
     Multi-User Integrity
     Multi-User Integrity
•  Versions
  – Integrity for concurrent editing
• Geometric Integrity
  – Precision
  – Meaning
• Security, etc. (via RDBMS)

                                       Geodatabase-
                                       Geodatabase-   18
     The Geodatabase is
     The Geodatabase is
      Part of a System
       Part of a System
No Other Spatial Database System Gives You:

•   Guaranteed geometric integrity
•   True scalability (1 user to 1000’s)
•   Better admin tools
•   A more complete GIS solution

                                          Geodatabase-
                                          Geodatabase-   19
Multi-User
Multi-User
Concepts
Concepts


             Geodatabase-
             Geodatabase-   20
                  Versions
                  Versions
•    A Version = “A Transaction” = “A State”
•    Many different uses:
    – Manage performance with many editors
    – Controls conflicting edits
    – Track many alternatives concurrently
    – Maintain history                Default


                                     QA Version

                             Qian’s Edits         Molly’s Edits
                                                        Geodatabase-
                                                        Geodatabase-   21
    If There Were No Versions …
    If There Were No Versions …
•  Lock
   propagation:
  – Blocks edit
    activity.
                                 1 -1
  – Slows whole
    system.
                         1 -M
• Not scalable.   1 -1



                                Geodatabase-
                                Geodatabase-   22
       Versions Enable Better
       Versions Enable Better
        Business Processes
        Business Processes
         Street Layer                                           Street Name
         Maintainers                                            Maintainers




                                 Workflow-driven validation
            DEFAULT
                                                                   6 mo.
                                                                  Back-log
  Our work          Integrity
 done; not        checked with
yet validated       back-log
   against           system
back-log sys
                                                              Short-transaction
                                                                  system
Long-transaction System                                                      Geodatabase-
                                                                             Geodatabase-   23
         Geometric Integrity
         Geometric Integrity
•   Geometry is a type that has
    special integrity                                           Good Doughnut

    requirements
•   Integrity is a matter of
    preserving meaning,
    correct interpretation, and                            Parcel

    performance   Non-homogeneous element                           Bad Doughnut

                                     d                      c

                                            Vertex Order

                                     a                      b           Geodatabase-
                                                                        Geodatabase-   24
                              Geometry Integrity
                              Geometry Integrity

                     ESRI                                               Other GIS
                                                SDO
                            Annotation                               Annotation

                                         Circular Arcs
       Long Transactions
                                                    Heterogeneous

                         Raster                   Points*
                                                                                     Planar Topology
       Planar Topology                            Lines*
                                                                                  Network Topology
         Network Topology                       Polygons*
                 Elliptical Curves                                      Other Great Features
                                                  Etype0
                    Bezier Curves

                                                         Long Transactions                     Geodatabase-
                                                                                               Geodatabase-   25
* With some exceptions
      Geodatabase Precision
      Geodatabase Precision
             1/3 + 1/3 <> 2/3
•   PRECISE DECIMAL: “Floating point”
    numbers are not precise. The
    geodatabase uses a “precise decimal”
    to ensure persistent accuracy. (“No
    fuzzy creep”)

            0.33 + 0.33 = 0.66
                                      Geodatabase-
                                      Geodatabase-   26
      Geodatabase Topology
      Geodatabase Topology
Lot Lines              Build


         •   Workflow-driven validation. Parcel
                                        Polygons
         •   Allows quality with
             flexibility.
         •   Maximum scalability

                                      Validate
   Fix                Errors
                                            Geodatabase-
                                            Geodatabase-   27
       Two Topology Strategies
       Two Topology Strategies
          GDB                    Other
•    Dynamic Topology     •  Static Topology
    – Discover “on-the-     – Store All Relations
      fly”                  – Constrain Every
    – Store Rules             Edit
    – Store Errors          – No Exceptions
√    Editing                – Storage Intensive
√    Query                  – Complicated
√    Seamless             √ Editing
√    Scalable             √ Query             Geodatabase-
                                              Geodatabase-   28
  ArcSDE GDB’s
  ArcSDE
Additional Requirements
Additional Requirements




                          Geodatabase-
                          Geodatabase-   29
      ArcSDE GDB’s Need
      ArcSDE GDB’s Need
•   An RDBMS
•   A DBA
•   A Test Environment (separate from
    your Production environment)
•   Control over client and server
    patches and releases.


                                    Geodatabase-
                                    Geodatabase-   30
A Simple GIS Query
A Simple GIS Query




                     Geodatabase-
                     Geodatabase-   31
      Software Releases
      Software Releases
      and Service Packs
      and Service Packs
 ArcGIS
             ArcSDE
Client OS               •   Patches
             RDBMS      •   Service
            Server OS       Packs
                        •   Upgrades


                                 Geodatabase-
                                 Geodatabase-   32
Resources
Resources



            Geodatabase-
            Geodatabase-   33
            Online Training
            Online Training
•   Creating Editing and Managing
    Geodatabases for ArcGIS 9 (12 hours)
•   Creating and Editing Geodatabase Features
    with ArcGIS 9 (for ArcEditor and ArcInfo (6
    hours)
•   Creating and Editing Geodatabase Topology
    with ArcGIS 9 (for ArcEditor and ArcInfo (6
    hours)
•   Creating and Editing Linearly Referenced
    Features with ArcGIS 9 (for ArcEditor and
    ArcInfo (6 hours)
                                            Geodatabase-
                                            Geodatabase-   34
       Instructor-Led Training
       Instructor-Led Training
•   System Architecture Design (2 days)
•   Building a Geodatabase I (3 days)
•   Building a Geodatabase II (2 days)
•   Geodatabase Design Concepts (2 days)
•   Modeling a Geodatabase Using CASE tools
    (3 days)
•   ArcSDE Administration for <RDBMS> (5
    days)
•   Managing a Versioned Geodatabase (3
    days)
                                         Geodatabase-
                                         Geodatabase-   35
              White Papers
              White Papers
•   System Design Strategies
•   Working with the Geodatabase Using SQL
•   Versioning
•   Versioning Workflows
•   Configuring ArcSDE to Use Oracle Spatial
    Third Party Data
•   Raster Data in ArcGIS X
•   Multiuser Geographic Information Systems
    with ArcInfo 8
                                           Geodatabase-
                                           Geodatabase-   36

				
DOCUMENT INFO
Description: Presentations on Building a Geodatabase document sample