O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Learning ArcGIS Geodatabases

Book Description

An all-in-one start up kit to author, manage, and administer ArcGIS geodatabases

In Detail

ArcGIS is an industry standard for geospatial development and management. A geodatabase is the database used to store and manage the spatial data.

Learning ArcGIS Geodatabases offers a comprehensive working and practical experience for readers who are interested in knowing about ArcGIS. The initial chapters guide you through authoring geodatabases and creating a geodatabase schema and datasets. Then, the book focuses extensively on modeling and optimizing geodatabases.

Finally, you will be able to work comfortably with datasets, annotations, and relationship classes, making it easier to migrate from a legacy database to an ArcGIS geodatabase.

What You Will Learn

  • Explore the benefits of geodatabases with practical illustrations
  • Work with geodatabase datasets covering feature classes, tables, relationship classes, coverage, and annotations
  • Model your geodatabase by creating a sturdy design that can sustain large edits and decrease maintenance
  • Discover various tools to optimize queries and response time, which will help you to fine-tune your geodatabase
  • Utilize Python scripting to author your geodatabase programmatically
  • Set up and configure a full-fledged networked enterprise geodatabase using ArcSDE technology
  • Add programming flavors to your geodatabase using Python

Downloading the example code for this book. You can download the example code files for all Packt books you have purchased from your account at http://www.PacktPub.com. If you purchased this book elsewhere, you can visit http://www.PacktPub.com/support and register to have the files e-mailed directly to you.

Table of Contents

  1. Learning ArcGIS Geodatabases
    1. Table of Contents
    2. Learning ArcGIS Geodatabases
    3. Credits
    4. About the Author
    5. About the Reviewers
    6. www.PacktPub.com
      1. Support files, eBooks, discount offers, and more
        1. Why subscribe?
        2. Free access for Packt account holders
    7. Preface
      1. What this book covers
      2. What you need for this book
      3. Who this book is for
      4. Conventions
      5. Reader feedback
      6. Customer support
        1. Downloading the example code
        2. Errata
        3. Piracy
        4. Questions
    8. 1. Authoring Geodatabases
      1. Bestaurants, the best restaurants in Belize
      2. Designing the geodatabase schema
      3. Creating the geodatabase
        1. The spatial reference
        2. Creating the feature classes
      4. Editing the geodatabase in ArcMap
      5. Summary
    9. 2. Working with Geodatabase Datasets
      1. Working with feature classes
        1. Adding new attributes
        2. Modifying the properties of the attributes
        3. Domains
        4. Subtypes
      2. Working with object tables and relations
      3. Working with annotations
      4. Importing other datasets
        1. Importing shape files
        2. Importing the CAD files
        3. Importing coverage classes
      5. Summary
    10. 3. Modeling Geodatabases
      1. The entity relationship diagram for Bestaurants
        1. The flaws in the current geodatabase
        2. The proposed geodatabase model
      2. Implementing the proposed model
        1. Authoring the geodatabase
        2. Creating geodatabase datasets
        3. Assigning domains to the feature class
        4. Adding subtypes to the new feature class
        5. Enabling attachments in the feature class
      3. Testing the new geodatabase in ArcMap
      4. Summary
    11. 4. Optimizing Geodatabases
      1. Geodatabase indexing
        1. Attribute indexing
        2. Adding an attribute index
        3. Spatial indexing
        4. Adding a spatial index
        5. Using indexes effectively
      2. Geodatabase compression
        1. Compressing a file geodatabase
        2. Using compression effectively
      3. Compacting
        1. Compacting a file geodatabase
        2. Using compacting effectively
      4. Summary
    12. 5. Programming Geodatabases
      1. Using Python scripting
        1. Creating a geodatabase
        2. Creating a feature class
        3. Adding and deleting fields
        4. Copying features
        5. Backing up the Bestaurants_Web geodatabase
        6. A list of arcpy commands
      2. Using the model builder
        1. Creating a model
        2. Creating a feature class
        3. Running the model
      3. Summary
    13. 6. Enterprise Geodatabases
      1. The benefits of the enterprise geodatabase
      2. Setting up a Microsoft SQL Server Express geodatabase
        1. System requirements
        2. Installing SQL Server Express
        3. Configuring SQL Server Express
          1. Enabling TCP remote pipe
          2. Enabling the firewall's database port
          3. Connecting to the database
          4. Connecting to the database from a remote machine
        4. Creating an enterprise geodatabase
      3. Working with an enterprise geodatabase
        1. Adding users
        2. Creating a connection to the enterprise geodatabase
        3. Migrating a file geodatabase to an enterprise geodatabase
        4. Assigning privileges
      4. Summary
    14. Index