AI & Automation

Geodatabase

A database designed to store, query, and manage geographic information and spatial data, the primary data format in Esri ArcGIS.

Detailed Definition

A geodatabase is a specialized database designed to store, query, manage, and analyze geographic information and spatial data. It is the primary data storage format used in Esri's ArcGIS platform and supports both vector and raster data along with attribute information.

Types of geodatabases

File Geodatabase (.gdb): - Stored as a folder of files on disk - Maximum size: 1 TB per dataset (256 TB per geodatabase) - Best for single-user or small workgroup access - Most common format for project-level work

Enterprise Geodatabase (SDE): - Stored in a relational database (SQL Server, PostgreSQL, Oracle) - Multi-user concurrent editing - Versioned editing support - Best for organizational-scale deployments

Mobile Geodatabase (.geodatabase): - SQLite-based format for mobile devices - Used with ArcGIS Field Maps and Collector - Supports offline editing and sync

  • Feature classes: Collections of geographic features (points, lines, polygons)
  • Tables: Non-spatial attribute data
  • Raster datasets: Imagery and grid data
  • Relationship classes: Links between feature classes and tables
  • Domains: Attribute value constraints
  • Subtypes: Feature class categorization
  • Topology: Spatial integrity rules

Applications in mining and land management: - Mining claims boundary databases - Drill hole and sample databases - Land ownership and title databases - Environmental monitoring databases - Geological mapping projects

Advantages over shapefiles: - Supports longer field names - No file size limits (practical) - Maintains data integrity with domains and topology - Supports relationships between datasets - Better performance for large datasets

Geodatabases provide the foundation for organized, reliable spatial data management in GIS applications.