Spatial Layers -- Fields and controls

Use this window to see a list of the spatial layers that are defined for the selected table. You can define new spatial layers, edit the geocoding properties of defined spatial layers, run a geocoder in batch mode on a spatial layer, or delete spatial layers.

A spatial layer is defined in terms of its base table, a column of this table that has a spatial data type, and the spatial reference system that is used for the representation of coordinate values in the spatial data column. The column that has spatial data type and that is registered for a spatial layer is called the layer column.

Spatial layers

Create

Edit

Delete

Run Geocoder

Close

Spatial layers

This box lists the spatial layers that are defined on the table. You can select a spatial layer for which you want to change some of the properties or that you want to delete. Click Create to define a new spatial layer on this table.

Create

Click this push button to open a window where you can create a new spatial layer for the table.

Edit

Click this push button to open a window where you can change some of the properties of the selected spatial layer.

This push button is only available when one spatial layer is selected.

Delete

Click this push button to delete the selected spatial layers. A confirmation window will open for you to confirm the removal of the layers before the spatial layers are actually deleted from the system.

This push button is only available when one spatial layer is selected.

Run Geocoder

Click this push button to run a geocoder on the data in the table. This push button is available only when one spatial layer is selected.

A geocoder converts data such as address data to a spatial format; for example, to a latitude and longitude. For example, if you have a table named CUSTOMERS that has the following columns:

and a column named LOCATION with spatial data type ST_Point, you could select the ADDRESS, CITY, STATE, and ZIP columns to have their data passed to the geocoder to be used for the spatial data column LOCATION. The geocoder transforms the information from the address format to the spatial format.