Export Spatial Data -- Fields and controls

You can use the Export Spatial Data window to export data from a table or view that has a spatial layer into a file of a shape format type.

You can export a subset of the rows by specifying a WHERE clause. If you do not specify a WHERE clause, all non-spatial data columns as well as the specified spatial data column will be exported. The specified spatial data column must be registered as a spatial layer.

If the table or view contains more than one spatial data column, only the named spatial data column will be exported.

Layer column

WHERE clause

File name

File format

OK

Cancel

Layer column

Use this box to specify the name of the spatial data column of the spatial layer for this table or view.

Use one of these methods:

• Select from the list of spatial data columns.
• Type the name of an existing spatial data column into the box.

WHERE clause

Optional: If you want to export only a subset of the rows in the table or view, use this box to specify a SELECT WHERE clause that will specify the criteria for the rows that you want. The WHERE clause can refer only to columns in the table or view from which you are exporting.

For example, type

File name

Use this box to specify the path and name of the file to which the exported data will be written. You should specify a file that does not already exist.

Use one of these methods:

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

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

File format

This box displays the format type (Shape) of the export file. You cannot change this field.