Creating an XY Table
Spectrum Spatial Manager allows you to create a named table that points to a JDBC database table which has columns representing longitude (X) and latitude (Y) values.
To create an XY table in Spectrum Spatial Manager:
-
From the Create drop-down located in the toolbar, select
XY Table.
Note: This is disabled if you do not have sufficient permissions.The Create XY Table page appears.
-
In the Choose a Datasource section, select a connection
from the Connection list. Because XY Tables can only be
created from database tables, you must select a database connection.
Information about the connection appears to the right (its location in the repository and its URL).
-
From the Datasource list, select the source of the data
for the XY table.
Information about the datasource appears to the right.Note: If a table has a spatial column already defined in the map catalog, it is not an XY table and therefore you cannot specify columns. If the table already has X and Y columns defined in the map catalog, it is already considered an XY table. If the table does not have two numeric columns to represent X and Y values, you cannot create an XY table. In all cases, proceed to step 7 to complete the Repository Info section and create a non-XY named table.
-
In the Settings section:
- In the Create Points section, select X (longitude) and Y (latitude) columns if default values are not provided or if you want to change them. Then specify the coordinate system you would like to use. Numeric longitude and latitude columns as well as a coordinate system are all required to create an XY table.
-
In the Display Style section, the MI_STYLE column is
selected by default if it is present. Select a styling option if a default
option is either not selected or you want to change it:
- Use style information from selected datasource
- Choose a style column from the selected datasource.
- Use a named style
- Specify an existing named style in the repository. If you are using a named style, you must include the entire path from the root (for example, /NamedStyles/PointStylePin).
- None
- In the Repository Info section, the New Table Name field uses the name of the chosen datasource as the default. You can accept the default name or change it. Spectrum Spatial Manager will warn you if another named table exists with that name. Names are case sensitive and cannot contain the following characters: / \ : [ ] | * { } "
- The Repository Folder field defaults to the location you were at in the repository when you selected . You can accept the default path or change it.
-
Click Create.
The details page for the new XY table appears.