Skip To Content

View data from a database in ArcGIS

You can view the data in your database tables by dragging them from the Catalog pane onto the map.

ArcGIS follows these rules when working with data:

  • Data types that do not map to an ArcGIS data type will not appear in ArcGIS.
  • Feature classes must contain one spatial reference and one type of geometry: either points, lines, or polygons. ArcGIS determines the spatial reference and geometry type from the table metadata or from the first row in the table. Only features of that type and spatial reference will be displayed. If the spatial reference cannot be determined, you will be prompted to provide spatial reference information.
  • Feature classes can contain only one spatial column. ArcGIS uses the first spatial column it encounters, reading the feature class table from left to right.
  • ArcGIS does not place delimiters around table and field names. Tables with names or field names that require delimiters cannot be displayed in the map. See Database data and ArcGIS for more information.
  • Features must pass ArcGIS geometry validation.

View your data in the map

The following steps describe how you can view your data in ArcGIS Pro:

  1. Connect to your database in the Catalog pane.

    You see a list of tables to which you have access in the database. Tables that contain a spatial column (feature classes) have a blank square icon Empty feature class.

  2. Click the table or feature class in the expanded database connection to select it.
  3. To view the data, drag the table from the Catalog pane to the Contents pane or the map.

    If you dragged in a feature class, ArcGIS calculates the spatial extent of the data. If you are adding a table that contains a lot of features, extent calculation can take a while. If you know the extent of the data or want to use the extent of your spatial reference instead of waiting for the extent to be calculated, you can do so. Click the appropriate button on the Calculate Extent dialog box. If you click Input Extent, you must type a valid extent that includes all the features in the table. If you click Use Spatial Reference Extent, the data extent is set to the full extent of the spatial reference of the feature class.

    Alternate ways to calculate extent
  4. To see the attribute data in both feature classes and tables, right-click the table in the Contents pane and click Attribute Table.

If you need to change what data is displayed, open the query layer definition and change the properties or query. See Modify a query layer for more information on changing the properties and definition of a query layer.