Building Geodatabases Class Resources

RudyProsser

Note: Building Geodatabases resources have been revised and updated for ArcGIS 10.5. Please note any errors or omissions in the comments.

Esri Resources:

• Esri.com – Esri’s primary website
  • Training – Esri Training website for instructor-led and virtual training
• ArcGIS Resources – ArcGIS Help and software resources
  
• Esri Support – Esri’s online support center
  • GIS Dictionary
• GeoNet
• ArcGIS Online
• ArcGIS Blogs
• Ideas

---

Building Geodatabases resource by course topic

Geodata

• Manage data
• Databases
• Geodatabases
• Administering geodatabases
• Data types

Geodatabases

• Essential readings about the geodatabase
• An overview of the geodatabase
  • What is a geodatabase?
  • The architecture of a geodatabase
  • A quick tour of the geodatabase

Types of geodatabases

• Types of geodatabases
• A comparison of geodatabase types

Creating geodatabases

• An overview of creating geodatabases
• Creating a personal geodatabase
• Creating a file geodatabase
• Creating a geodatabase on a database server
• Create an enterprise geodatabase

Tutorial

• Building a geodatabase tutorial
  Note: Only available with the 10.3 documentation

Videos

• 2013 Esri International User Conference

Types of Geodatabases: Which One is Right for Me?

Esri Training – Web Courses

• Getting started with the Geodatabase
• Working with Coordinate Systems in ArcGIS

Feature classes and tables

Tables and feature classes

• Table basics
• Feature class basics
• Geodatabase table properties
• Defining tables
• Defining feature class properties
• ArcGIS field data types

Data types

• Tables
• Feature classes

Adding datasets and other geodatabase elements

• An overview of adding datasets to the geodatabase
• Exporting data
• Loading data
• Object Loader

Tools

• Append
• Simple Data Loader
• Object Loader
• Conversion tools

Rasters – Raster datasets and mosaic datasets

• Raster basics

Data types

• Rasters and images
  • Fundamentals of raster data
  • Building and managing a raster database
    • Raster datasets
    • Mosaic datasets

Rasters and images tutorials and workflows

• ArcGIS raster tutorial
• ArcGIS raster workflows

Esri Training – Training Seminars

• Managing imagery with ArcGIS 10
• Processing Raster Data Using ArcGIS
• Organizing Raster Data Using ArcGIS
• Displaying Raster Data Using ArcGIS
• Managing Raster Data Using ArcGIS

Articles

• On-the-Fly Processing and Dynamic Raster Mosaicking Mosaic datasets resolve many traditional raster management issues (ArcUser, Summer 2010)

Subtypes

Subtypes

• A quick tour of subtypes
• Working with subtypes
• Creating subtypes
• Modifying and deleting subtypes

Maintaining attribute integrity

• About maintaining attribute integrity
• Editing attributes with subtypes and domains
• Validating features and relationships in ArcMap

Subtypes toolset

Building a geodatabase tutorial

• Exercise 3: Creating subtypes and attribute domains

Esri Training – Web Courses

• Working with Geodatabase Domains and Subtypes in ArcGIS

Domains

Domains

• A quick tour of attribute domains
• Creating a new attribute range domain
• Creating a new coded value domains
• Modifying and deleting attribute domains
• Browsing the domains of a geodatabase
• Browsing the attribute domains of a geodatabase from the a feature class or table
• Associating default values and domains with tables and feature classes

Maintaining attribute integrity

• About maintaining attribute integrity while editing
• Editing attributes with subtypes and domains
• Validating features and relationships in ArcMap

Domains toolset

Building a geodatabase tutorial

• Exercise 3: Creating subtypes and attribute domains

Esri Training – Web Courses

• Working with Geodatabase Domains and Subtypes in ArcGIS

Relationship classes

Joining and relating tables by attributes

Relationships and related objects

• Relationship class properties
• An overview of creating and maintaining relationship classes
  • Creating a simple relationship class
  • Creating a composite relationship class
  • Creating an attributed relationship class
• Creating relationship rules

Editing relationships and related features

• About editing relationships in ArcMap
• Creating a relationship between selected features
• Editing the attributes of related features

Relationship Classes toolset

Building a geodatabase tutorial

• Exercise 4: Creating relationships between objects

Attachments

Attaching files to features

• Enabling attachments
• Adding attachments to features
• Viewing attachments

An overview of the Attachments toolset

Geodatabase topology

Topologies

• An overview of topology in ArcGIS
• Topology basics
• Topology in ArcGIS
• Designing a geodatabase topology
• Creating a topology
• Validating a topology

Editing topology

• Editing shared geometry with topology
• Geodatabase topology
  • Geodatabase topology rules and topology error fixes
  • Validating a geodatabase topology

Building a geodatabase tutorial

• Exercise 8: Creating a topology

Topology Rules Poster

• C:\Program Files (x86)\ArcGIS\Desktop10.3\Documentation\topology_rules_poster.pdf

Esri Training – Web Courses

• Getting started with Geodatabase Topology

XML Workspace

XML workspace document

• Geodatabase XML
• Exporting a geodatabase schema to an XML workspace document
• Importing a geodatabase schema from an XML workspace document

Packages

About packaging and sharing data

• About packaging and sharing data
• Creating a layer package
• Creating a map package
• Creating a tile package

Esri Training – Web Courses

• Creating and Sharing Map Packages in ArcGIS
• Sharing Maps and Layers with ArcGIS Pro
• Creating and Sharing GIS Content Using ArcGIS Online

Geodata services

Geodata services

• What types of services can you publish?
• How to publish a service
• Geodata services
• Analyzing your GIS resource
• Manage service data

Geodatabase design

Designing a geodatabase

• An overview of geodatabase design
• Geodatabase design steps
• Documenting your geodatabase design
• Modeling feature classes
• Design tips

Designing a table

Data model sources

• Esri Support > Data Models
• ArcGIS Online > Search “data model”
• ArcGIS Solutions

Example data models

• Local Government Information Model
• Forestry Data Model 2013
• Fiber Network Data Model
• Utility and Pipeline Data Model

Books

• Modeling Our World, Second Edition: The Esri Guide to Geodatabase Concepts
• Designing Geodatabases : Case Studies in GIS Data Modeling
• Designing Geodatabases for Transportation
• Thinking About GIS: Geographic Information System Planning for Managers, 4th ed. Roger Tomlinson
• Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design, 3rd ed by Michael Hernandez

---

Old and/or deprecated resources

ArcGIS Functionality Matrixes - Desktop and server functionality by license level

• ArcGIS for Desktop
• ArcGIS for Server

Geodatabase

• Geodatabase / Geodata Community
• Geodata in ArcGIS 10.2 Help
• Geodata

References

Essential readings on the geodatabase

• Essential readings about the geodatabase
• What is a geodatabase?
• The architecture of a geodatabase
• A quick tour of the geodatabase
• Types of geodatabases
• A comparison of geodatabase types
• Building a geodatabase tutorial - A multi-lesson tutorial on organizing, importing, and creating geodatabase elements. Requires you to install the ArcGIS for Desktop tutorial data.

Creating a geodatabase

• Creating a geodatabase
• Creating a file geodatabase
• Creating a geodatabase on a database server

Feature classes and tables

• Feature class basics
• Feature classes – provides details on feature classes in the geodatabase
• Table basics
• Tables – provides details on tables in the geodatabase

Rasters and mosaic datasets

• Raster basics - Provides the basics of raster data
• Rasters and images – Provides details on raster data
• Raster datasets
• Mosaic datasets
• Raster tutorials - A multi-lesson tutorial on mosaic datasets. Requires you to install the ArcGIS for Desktop tutorial data.
• Raster workflows

Subtypes

• Subtypes
• Creating subtypes – Subtype workflow
• Building a geodatabase tutorial > Exercise 3: Creating subtypes and attribute domains

Domains

• Domains
• Creating a new attribute range domain – Workflow for creating range domains
• Creating a new coded value domain – Workflow for creating coded value domains
• Building a geodatabase tutorial > Exercise 3: Creating subtypes and attribute domains

Relationship classes

• Relationships and related objects
• Deciding between relationship classes, joins, and relates
• Creating a simple relationship class
• Creating a composite relationship class
• Creating relationship rules
• Editing relationships and related objects
• Building a geodatabase tutorial > Exercise 4: Creating relationships between objects

Attachments

• Attaching files to features

Geodatabase topologies

• Topologies
• Designing a geodatabase topology
• Common topology tasks
• Helpful hints when using topologies
• Editing a geodatabase topology
• Geodatabase topology rules and topology error fixes
• Topology rules poster [ C:\Program Files (x86)\ArcGIS\Desktop10.x\Documentation\topology_rules_poster.pdf
• Building a geodatabase tutorial > Exercise 8: Creating a topology

Geodata services & packages

• Geodata services
• Sharing data through packages

Geodatabase design

• Designing a geodatabase

Esri Press books on geodatabase design

• Modeling Our World, 2^nd ed: The Esri Guide to Geodatabase Concepts
• Designing Geodatabases: Case Studies in GIS Data Modeling
• Designing Geodatabases for Transportation
• Thinking About GIS: Geographic Information System Planning for Managers, 4^th ed. Roger Tomlinson

Other books

• Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design, 3^rd ed here.

Data Models

• KB40585 Index: Data Models

ArcGIS for Local Government Community

• Local Government Information Model (ArcGIS 10)
• Local Government Information Model (ArcGIS 10.1)
• Local Government Information Model for ArcGIS 10.2

ArcGIS for Utilities

• ArcGIS for Water Utilities Water Distribution Network
• ArcGIS for Gas Utilities Gas Data Model
• ArcGIS for Electric Utilities Foundational Solutions
• ArcGIS for Telecommunications
• Fiber Data Management Tools
• Pipeline
  • ArcGIS Pipeline Data Model (APDM)
  • GIS for Pipeline
  • Pipeline Open Data Standard (PODS)

Tools and utilities

• ArcGIS Diagrammer for 10.2
• X-Ray for ArcCatalog (ArcGIS 10.2)
• ArcGIS Diagrammer for 10.1
• X-Ray for ArcCatalog (ArcGIS 10.1)
• Geodatabase Diagrammer for 10x
• X-Ray for ArcCatalog (ArcGIS 10)

Videos

2014 Esri International Developer Summit

• Understanding & Using Geometry, Projections, and Spatial Reference Systems in ArcGIS

2013 Esri International User Conference

• Types of Geodatabases: Which One is Right for Me?
• Migrating Data to the Geodatabase

Recommended Training/Follow-on Classes

On geodatabases

• Configuring and Managing the Multiuser
• Implementing Versioned Workflows in a Multiuser Geodatabase
• Distributing Data Using Geodatabase Replication
• Archiving Data in a Multiuser Geodatabase (for ArcGIS 10.1)

On editing and sharing geodatabases

• Creating and Sharing Map Packages (for ArcGIS 10.1)
• Editing Data with ArcGIS for Desktop (10.2)
• ArcGIS for Server: Sharing GIS Content on the Web (for 10.1)
• ArcGIS 4: Sharing Content on the Web (for ArcGIS 10.2)

On Python

• Python for Everyone Using ArcGIS 10.1
• Basics of Python (for ArcGIS 10.1)
• Introduction to Geoprocessing Scripts Using Python

George_Thompson

adding other groups that may benefit from these. Thanks again Rudy Prosser​!!

Geodatabase​

Managing Data​

Enterprise GIS​

​

Mapping and Charting Enterprise Databases​