The Journey to the Geodatabase

1
The Journey to the Geodatabase

• Kendis Scharenbroich Jennifer Ward
• Pro-West Associates
• Black Hills Digital Mapping
  Association, May 2-3

2
Pro-WestWho We Are

• GIS Consulting Firm
• Established 1987 Walker, MN
• ESRI Business Partner
• Consultants-Programmers-Technicians
• Services
• Data development, custom programming, web
  mapping, training, technical advising

3
In the Beginning
AS400 Database Access Database
?
Tabular Data
Spatial Data
Pro-West Associates
4
First Generation Storage/Linking

• Spatial data is linked outside the RDBMS
• Links occur using unique IDs.Parcel Numbers

Pro-West Associates
5
First Generation Storage/Linking

• Tabular/Spatial data is linked outside the
  database
• Links occur using unique IDs.Parcel Numbers
• Storage is still in separate locations

Pro-West Associates
6
Second Generation Storage/LinkingGeodatabases

• Tabular/Spatial data is stored/linked in a single
  location!!

Pro-West Associates
7
Geodatabase

• Personal Geodatabase
• Access database, 2GB limit
• SDE Geodatabase
• Uses SQL, Oracle.

8
Benefits of A Geodatabase

• Spatial attribute data integrity
• Intelligent Behavior
• Centralized Data Storage
• Increased Performance
• Advanced Analysis Capabilities
• Multi-user editing (SDE format)

9
Benefits of Migrating to a GeodatabaseData
Integrity

• Maintain tabular data more efficiently
• Reduce typological data errors
• Maintain spatial data more efficiently
• Reduce spatial errors

Pro-West Associates
10
Parcel Editing in Geodatabases

• Topology rule setup
• i.e. Parcel boundary must be closed
• Updated COGO functionality
• Bearing, distance, proportion, etc.
• Annotation
• Bearing, distance, radius

Pro-West Associates
11
Benefits of a Geodatabase
Geodatabase
12
The Personal GeodatabaseIts not Scary!

• Stores spatial and tabular data in an Access
  database format
• Sets the stage for future SDE geodatbase
  migration
• Edit in ArcView, ArcEditor or ArcInfo

13
Terminology
14
Sample Geodatabase
View from ArcCatalog
15
Design Elements

• Organize your data
• Topology
• Maintain coincidence
• Parcel section lines
• Eliminate overlaps and gaps
• Spatial Reference
• Projection
• Extent (City limits, County, other?)
• Precision

16
ESRI Data Models

• Make implementation to the geodatabase
  environment easier
• Create consistency between organizations
• Support existing FGDC standards
• Designed with both Users and ESRI
• TIP
• You do not need to use the entire model

17
Parcel Data Model Example
Pro-West Associates
18
Data Model Resource

• ESRI website www.esri.com
• http//support.esri.com/index.cfm?fadownloads.dat
  aModels.matrix

Pro-West Associates
19
How Do I Get Started?
20
Geodatabase Basics

• Creating new personal geodatabases
• Creating Feature Datasets
• Importing existing data
• Setting subtypes and domains
• Creating and using topologies

21
Creating a new personal geodatabase

• Open ArcCatalog
• Choose a folder location
• Right click Choose New lt Personal Geodatabase

22
Creating Feature Datasets
Right click your geodatabase Choose New lt
Feature Dataset
23
Feature Datasets Setting the
spatial reference

• Set the Projection
• Set the Domain
• Precision
• Extent

http//arcscripts.esri.com/ Search on Spatial
Domain
24
Import existing data

• Navigate to the feature dataset or geodatabase
  icon in ArcCatalog
• Right Click
• Choose Import

Use this to import any existing format!
25
Subtypes Domains

• Subtype
• Distinguish features within a single layer
• Maintain different domains within the same field
• Need ArcEditor or ArcInfo
• Domain
• Identify constrain attribute values
• Can utilize in ArcView

26
Subtypes DomainsParcels
Example Subtype Boundary Line Domains
ROW Type
27
Subtypes

• Must be long or short integer fields
• Created in ArcEditor or ArcInfo
• Increases the efficiency of the editing process
• Use when
• Standardizing a legend
• distinguishing different default values/domains
  within the same field

28
Creating Subtypes

• In ArcCatalog
• Double click on a feature class
• Select the Subtype tab

29
Creating Domains

• Created in
• ArcCatalog
• Double Click on the Personal Geodatabase Icon
• Choose the Domains tab

30
Range Code Domains

• Range

31
Creating DomainsAssigning to Feature Classes

• In ArcCatalog
• Double click a feature class
• Choose the Fields tab
• Highlight a field
• Click Domain under the Field properties section

32
Creating DomainsAssigning default values
Set in the Field Properties section
33
Using Domains during the Editing Process
34
Geodatabase TopologyPutting the power into your
hands

• Topology Rules
• Preset rules to define topological relationships
  to ensure connectivity, adjacency and coincidence
• Can be changed at any time
• Topology Tools
• Maintain spatial relationships
• Toolbar and Tasks

Pro-West Associates
35
Creating Topology

• Rules
• Land use boundaries overlap parcel boundaries
• Manholes overlap sanitary line endpoints
• Cluster Tolerance
• Min distance where vertices within tolerance are
  snapped
• Ranks
• Control what features move during validating
• Surveyed points will not move (snap) during the
  validation process

Pro-West Associates
36
Validating Topology

• Validate edited features using set topology rules
• Evaluate rules/tolerance and generates error
  notifications
• Snaps vertices using set cluster tolerance and
  ranks

Pro-West Associates
37
Create a New Topology

• Created in ArcCatalog
• Created within a Feature Dataset
• Topology Wizard
• Allows user to set Rules, Ranks, Tolerance, and
  perform initial Validation

Pro-West Associates
38
Final Topology
When added to ArcMap, will show errors from the
validation process
39
Managing Topologies

• Right click on the Topology in ArcCatalog

40
Topology ToolsMaintenance

• Standard toolbar in ArcView-ArcInfo
• Used in an editing environment in ArcMap
• Use in conjunction with Topology Tasks in Editor
  Toolbar

Pro-West Associates
41
Editor ToolbarMaintenance

• Topology Tasks
• Modify, Auto Complete Polygon and Reshape
• Allows user to use basic editing tools to alter
  vertices, replace lines, add adjacent polygons or
  alter existing polygons
• Use in conjunction with the Topology Edit Tool on
  the Topology Toolbar
• Remember
• Set snapping and snapping tolerance

42
Flexible Editing

• Topology edit tool
• Allows for editing shared boundaries
• Builds a temporary topology cache within a given
  extent
• Faster performance
• Must use each time your extent changes
• Show shared features tool
• Move a boundary without effecting shared
  boundaries (temporary)
• Parcels land use
• Parcels and easements

Pro-West Associates
43
Validate Fix

• Validate after editing is complete
• Errors are highlighted
• Click the Fix Error button
• Select a feature and right click
• Fix
• Mark as an Exception
• Do Nothing

44
Process in Review

• Plan for success
• Import data
• Set Subtypes Domains
• Create Topology
• Start editing!

Pro-West Associates
45
Thank You!

• Visit Us At
• WWW.PROWESTGIS.COM