FAQ: Can a Query Layer Be Created from an Oracle Spatial Table, Containing Multiple Geomet

Answer

Yes, a query layer can be created by specifying any one of the spatial columns in the SELECT list of the query.

Since ArcGIS supports only one spatial column in a layer, a Query Layer can be used to work with database tables that have multiple spatial fields.

While building the query, only one spatial column is allowed in the SELECT list of the query, however other spatial columns can still be used in a WHERE clause of the query to spatially join with other tables in the database.

Alternatively, database views of the same table with one spatial column can also be registered with ArcSDE using 'sdelayer -o register' command to create layers from a table having multiple geometry columns. However, ArcSDE installation is required for using the sdelayer command.

• What is a query layer?
• Connecting to a database
• Creating a query layer
• Working with a query layer in ArcMap

Article ID:000011450

Software:

ArcMap

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Can a query layer be created from an Oracle Spatial table, containing multiple geometry columns?

Answer

Related Information

Discover more on this topic