photograph: Desert Tortoise The Advanced Resource Technology Group:
The Knowledge Base



Last updated
6/26/02

ArcGIS Geodatabase: Procedures


Information | Knowledge Base | Back

All of the following examples rely on a personal geodatabase created from Santa Rita Experimental Range (SRER) data that was created with ArcInfo 7.x, ArcView 3.x, Microsoft Excel and Microsoft Access. Again, here is the ArcCatalog tree view of the geodatabase:

Please keep in mind that there are usually several ways to complete the same task. For example, the processes described below could be done with Export options instead of import options. If you don't like the methods described below, then please search the ArcGIS help documents or try new things through trial and error.

Tree view of a personal geodatabase in ArcCatalog.

Fig. 1. Tree view of a personal geodatabase in ArcCatalog.





Create a Personal Geodatabase

  1. Open ArcCatalog.
  2. Navigate to the directory that you want the personal geodatabase to be stored in and click on it in the tree view.
  3. Right click in the window to the right of the tree view and choose New --> Personal Geodatabase (Fig. 2).
  4. Give the personal geodatabase a name.

A screenshot of how to create a personal geodatabase.

Fig. 2. How to create a personal geodatabase.





Create a Feature Dataset

  1. Open ArcCatalog.
  2. Navigate to the personal geodatabase and click on it in the tree view.
  3. Either right click on the personal geodatabase or right click in the window to the right of the tree view and choose New --> Feature Dataset (Fig. 3).
  4. A screenshot of How to create a feature dataset in a personal geodatabase.

    Fig. 3. How to create a feature dataset in a personal geodatabase.

  5. Give the feature dataset a name and click on Edit to specify the coordinate system. You will then be able to specify a coordinate system or import the parameters from an already existing data layer (i.e., coverage) or feature dataset (Fig. 4).
    • Specifying the coordinate system is very important because it helps to ensure that the data inside of the dataset is in the same coordinate system. If you try to import data into the dataset that has a different projection, you will receive a warning.

A screenshot of how to specify a coordinate system in a personal geodatabase.

Fig. 4. How to specify a coordinate system in a personal geodatabase.





Import Data (Feature Classes and Tables)

  1. Open ArcCatalog.
  2. Navigate to the personal geodatabase and click on it in the tree view.
    • If you want the data stored inside of a feature dataset, then navigate to the feature dataset before you continue.
  3. Either right click on the personal geodatabase (or feature dataset) or right click in the window to the right of the tree view and choose Import --> Cover to Geodatabase Wizard, Import --> Cover to Geodatabase, Import --> CAD to Geodatabase, Import --> Shapefile to Geodatabase, Import --> Shapefile to Geodatabase Wizard, or Import --> Table to Geodatabase (Fig. 5).
  4. No matter which option you choose, you will have the ability to change the coordinate system/projection as well as the topology you wish to import. If this is your first time and you are importing a coverage or shapefile, you should use the wizard to get an idea of the required information/processes. You can do the same things without the wizard, but the wizard makes sure you don't skip anything.

A screenshot of how to import data into a personal geodatabase.

Fig. 5. How to import data into a personal geodatabase.



Using the Import Wizard

Please refer to the images below when reading the following example.

  1. On the first screen of the wizard, you will need to browse to the data layer you wish to import and put a check next to the topology you wish to import. In this example, I am importing points.
  2. The second screen allows you to choose where to import the data. If you right clicked on a feature dataset, then this will be chosen for you. If you right clicked on a personal geodatabase, then you can choose any of the three options. In this example, I chose to import it to an existing feature dataset.
  3. The third screen allows you to specify the remaining parameters. You should always choose to specify the parameters so you can check and/or change the coordinate system.
  4. The fourth screen provides a brief overview of the spatial reference of the data you are importing. If you wish to change it or define it, click on the Change button. It is very important that you define the coordinate system at this point if it is not already defined, especially if they are going to be stored inside of a feature dataset. Remember that the coordinate system of a feature class and its feature dataset must be identical, so you can import the parameters that you defined for the feature dataset.
  5. The fifth screen allows you to name the imported data as well as choose to Set Options. In this example, I chose to set additional options instead of accepting the defaults.
  6. If you choose to set additional options, you will see this screen. It allows you to set the resolution of the grid index for the data.
  7. This screen will also appear if you choose to set the options. This screen allows you to change the field names or delete them altogether if you so desire.
  8. The final screen shows you an overview of the options you set during the wizard. When you click on finish, ArcCatalog will import your data.

These are the six screens from the Import to Geodatabase Wizard in ArcCatalog.
  1. Import to Geodatabase Wizard: Screen 1

  2. Import to Geodatabase Wizard: Screen 2

  3. Import to Geodatabase Wizard: Screen 3

  4. Import to Geodatabase Wizard: Screen 4

  5. Import to Geodatabase Wizard: Screen 5

  6. Import to Geodatabase Wizard: Screen 6

  7. Import to Geodatabase Wizard: Screen 7

  8. Import to Geodatabase Wizard: Screen 8





Create Feature Classes and Tables

  1. Open ArcCatalog.
  2. Navigate to the personal geodatabase and click on it in the tree view.
    • If you want the feature class stored inside of a feature dataset, then navigate to the feature dataset before you continue. Remember that you cannot put tables inside of a feature dataset.
  3. Either right click on the personal geodatabase or right click in the window to the right of the tree view and choose New --> Feature Class or New --> Table (Fig. 6).
  4. A screenshot of how to create a new feature class or table in a personal geodatabase.

    Fig. 6. How to create a new feature class or table in a personal geodatabase.

    See the figures below as a reference for the remaining steps.

  5. Give the feature class or table a name and an alias, then click Next.
    • If you are making a new feature class, you must specify if it will be storing simple features (such as points) or annotation, network, or dimension features.
  6. Accept the default storage parameters (unless you know a keyword that will specify the parameters for you) and click on Next.
  7. Either specify field names or click on Import to import field names from an existing table or feature class. Click on Finish.

These are the three screens from the Create a New Feature Class process in ArcCatalog. The Create a New Table process is identical except for the first screen.
  1. Create a New Feature Class: Screen 1

  2. Create a New Feature Class: Screen 2

  3. Create a New Feature Class: Screen 3





Create Relationship Classes

  1. Open ArcCatalog.
  2. Navigate to the personal geodatabase and click on it in the tree view.
    • If you want the relationship class stored inside of a feature dataset, then navigate to the feature dataset before you continue.
  3. Either right click on the personal geodatabase or right click in the window to the right of the tree view and choose New --> Relationship Class (Fig. 7).
  4. A screenshot of how to create a new relationship class or table in a personal geodatabase.

    Fig. 7. How to create a new relationship class or table in a personal geodatabase.

    See the figures below as a reference for the remaining steps.

  5. Give the relationship a name, and then choose the origin and the destination datasets. Click Next.
    • In a "One to Many" relationship (which you specify later), the origin dataset should be the one with the "One" side of the relationship, and the destination dataset is the one on the "Many" side of the relationship.
  6. Specify whether you want a "Simple" or a "Composite" relationship. Only choose the composite relationship if you want records in your database to be deleted when you delete geographic features. Click Next.
  7. Give labels to the relationship directions so that you can differentiate between actions that move in one direction or the other. Click Next.
  8. Specify what type of relationship it is (one to one, one to many, or many to many). Click Next.
  9. You now have the opportunity to specify if there will be attributes for this relationship. Usually there is not. Click Next.
  10. Now you must select the primary and foreign keys that relate the data. Click Next.
  11. The final screen shows an overview of the options that you chose. Click Finish.

These are the seven screens from the Create a New Relationship Class process in ArcCatalog.
  1. Create a New Relationship Class: Screen 1

  2. Create a New Relationship Class: Screen 2

  3. Create a New Relationship Class: Screen 3

  4. Create a New Relationship Class: Screen 4

  5. Create a New Relationship Class: Screen 5

  6. Create a New Relationship Class: Screen 6

  7. Create a New Relationship Class: Screen 7





Information | Knowledge Base | Back


The School of Renewable Natural Resources   The College of Agriculture & Life Sciences

CALS Privacy Statement