Building Geodatabases Class Resources

[#1]

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 ... (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

[JoshuaBixby]

Rudy Prosser‌, thanks for pulling this information together in one place.  Although I have been working with geodatabases for years, this compilation of geodatabase-related information will be great to share with others in our organization that are newer to geodatabases.

Since 10.3 is right around the corner, get ready to update most of the links!

[RebeccaStrauch__GISP]

Thanks for posting Rudy. It's great to have this info handy in one place, for my own reference and for others in the department that are learning.

[curtvprice]

• Start Dataset And Field Names With A Letter
• Names Should Only Use A..Z_ With No Spaces
• A Compacted Workspace Is A Happy Workspace
• Remember: The Snap Raster Is Your Friend,
• Keep Object Names Unique,
• You Have Been Warned.

[George_Thompson]

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

Geodatabase​

Managing Data​

Enterprise GIS​

Mapping and Charting Enterprise Databases​