Frequently asked question

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

Last Published: April 25, 2020


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

  • ArcMap

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options