Import Spatial Data -- Fields and controls

You can use this window to do one of the following tasks:

• If the table does not already have a spatial data column, use this window to add a new spatial data column to the table, register a spatial layer on this column, and import spatial data from a file into that table.

• If the table has one spatial data column and has a spatial layer on this column, use this window to import the spatial data into this spatial layer. In this case, the table can only have one spatial data column and all table columns (non-spatial and spatial data types) must match the specification of the import spatial data file.

File name

File format

Commit scope

Layer schema

Layer table

Layer column

Spatial reference name

Exception file

OK

Cancel

File name

Use this box to specify the path and name of the file that contains the spatial data to be imported. The file must be accessible from the server.

Use one of these methods:

• Click on the push button to open a window in which you can browse for the file that you want.

• Type the path and name of the file that you want.

File format

This box displays the format of the file that is specified in the File name field. For importing into a table, the file must have shape format, and you cannot change this field. Shape files are an industry standard format for exchanging geometry and attributes. This format is freely distributed and is supported by all major GIS and CAD suppliers.

Commit scope

The Commit scope box contains the number of records to import before a commit is done on those records. For example, if this box contains the number 100, a commit is done for every 100 records that are imported.

The default is 1000 records. To change this number, use one of these methods:

• Select the up or down arrows to spin through the available choices.
• Type in a value.

Layer schema

This box displays the schema name of the spatial layer that is the target of this import process. You cannot change this value when importing into an existing spatial layer.

Layer table

Use this box to specify the name of the table that is the target for this import process.

You cannot change this value when importing into an existing spatial layer.

Layer column

Use this box to specify the name of the spatial data column that is the target of this import process.

Use one of these methods:

• Select the name of an existing spatial data column from the list.
• Type the name of a spatial data column in the box.

Spatial reference name

Use this box to specify the spatial reference system that is to be associated with the spatial data column specified in the Layer column field.

Use one of these methods:

• Select an existing spatial reference system from the list.
• Type the name of an existing spatial reference system into the box.

If ESRI_SDE is specified for the file format, then this field displays the name of the spatial reference system associated with the ESRI_SDE transfer file and you cannot change this value.

Exception file

Optional: Use this box to specify the path and name of a file of shape format. This file is used to collect any shapes from the import data file that are not processed during the import. Shapes from the import data file might not be processed because there is some error in their definition in the data file. After the import process, you can fix the shapes in the exception file and use it as the source file to import the corrected shapes.

Use one of these methods:

• Click on the push button to open a window in which you can browse for an existing file that you want to use. If you specify an existing file, the file will be overwritten.

• Type the path and name of a file.

This field is available only if Shape is specified for the file format.