![]() ![]() When you specify a query, all columns that have an unknown data type must either be excluded or changed in the query to a data type that ArcGIS supports. If the attribute column type is unknown, this indicates that ArcGIS does not support that data type. However, some less common database types are not supported. ArcGIS can work with most common database types. You can double-click the tables and columns that appear in the list to construct an SQL query by either double-clicking it or dragging it from the table list window into the Query text box.Įach column in a database has a specific data type. You can paste an SQL query in the Query text box or, if you don't have an SQL query prepared and you need to see a list of tables, check the List of Tables box. Specify an SQL query in the Query text box to access the data you need from the table or view. You can create a database connection in the Catalog pane, as explained in Database connections in ArcGIS Pro, add it to the project, and browse to it from the New Query Layer dialog box, or you can create the database connection from the New Query Layer dialog box. Connect to the databaseīefore you can define a query layer, you must connect to the database you want to query. Next, read the subsections below to gain an understanding of the workflow to follow when creating a query layer for a database using the New Query Layer dialog box. Prerequisites and workflowsīefore you create a query layer, read Database and client configurations for query layers. Query layers that access geodatabase system tables are not supported. To access data in a cloud data warehouse, see Create a query layer for data in a cloud data warehouse. ![]() This page explains how to create a query layer for a table in a database. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |