Unable to set ArcGIS Insights scatter plot to its default extent, when working with feature services referenced from PostgreSQL databases.

解决办法

Expose the Area and Length fields of the feature class

1. On ArcGIS Pro, use the Calculate Geometry Attributes tool to add the shape Area and Shape Length fields on the feature Class.

Add a PostgreSQL Connector in Insights

1. Click the Settings tab > Connector Types.
2. Click Add a connector type > PostgreSQL.

Configure the PostgreSQL Connection

1. Click the Data tab.
2. Select Connections to add a new data connection.
3. Choose Add Database Connection.
4. Select PostgreSQL as the database type.
5. Enter the necessary connection details (server, database, authentication).
6. Click Connect to establish the connection to the PostgreSQL database.

Add the Polygon Feature Class from PostgreSQL

1. Once connected, navigate to the Workbook again and click on Add Data.
2. Select Databases > User's database connection > Select the same Feature Layer.
3. Click 'Add to Workbook' to add the polygon data directly from the database to your Insights workbook.
4. In the workbook, select the area and length fields created on Step 1 from the dataset.
5. Drag the selection to any area in the workbook and select Chart > Scatter Plot. The chart is created.
6. Click on the center of the newly added chart and move the mouse wheel to zoom in/zoom out in the chart.
7. Click on the Default Extent and it works as expected.

重现步骤