Supported data
The following data sources are supported in Insights:
- Available hosted or registered feature layers from your content, groups, or organization
- Feature layers from ArcGIS Living Atlas of the World
- Excel files (.xlsx)
- Comma-separated value files (.csv)
- Shapefiles (.zip)
- GeoJSON files (.json, .geojson, or GeoJSON files in a .zip file)
- Map image layers
- Connections to Microsoft SQL Server, SAP HANA, PostgreSQL, and Oracle databases. The following data types are supported:
- Spatial tables
- Nonspatial tables
- Relational database views
- Connections to enterprise geodatabases
Note:Map image layers require that the Feature Access capability be enabled to support statistics. If statistics are not supported, you cannot use many Insights features, including creating charts. See Troubleshoot a map image layer for tips on how to enure that statistics are supported when you publish a map image layer.
Map image layers must also have standardized query enabled. To enable standardized query, the layer must be shared as a dynamic service, rather than a tile layer.
Data from a spatiotemporal big data store can be added as a feature layer in Insights in ArcGIS Enterprise. A common way to create data in the spatiotemporal big data store is using GeoAnalytics Server in Portal for ArcGIS or ArcGIS Pro.
Insights does not support the following:
- Multipoint geometries
- Query layers
Support for the spatiotemporal big data store
The following tools and capabilities are supported in Insights for feature layers with data stored in the spatiotemporal big data store:
- Create maps*
- Filter data
- Attribute aggregation**
- Histogram
- Time series graph
- Spatial Aggregation
- Spatial Filter
- Create Buffer
- Share page
The following tools are supported with limitations in Insights for feature layers with data stored in the spatiotemporal big data store:
*Does not support styling by a number field using Counts and Amounts (Size) and Counts and Amounts (Colors).
**Does not support more than one subgroup for a statistic. An error is returned when the Subgroup option is used in a bar chart. Chord diagrams, data clocks, and heat charts are not supported for data from the spatiotemporal big data store.
Resources
Use the following resources to learn more about data in Insights: