Bug
Using the to_featurelayer function in ArcGIS API for Python returns the error message, "Maximum number of records allowed (1000) exceeded" when publishing the result of the pivot_table function.
| Bug ID Number | BUG-000130651 |
|---|---|
| Submitted | May 6, 2020 |
| Last Modified | June 5, 2024 |
| Applies to | ArcGIS Online |
| Version found | 8.1 |
| Operating System | Windows OS |
| Operating System Version | 10.0 64 Bit |
| Status | Known Limit |
Additional Information
- pivot_table results in a MulitLevel index, which is not supported in feature classes. - The maximum records message results because to_featurelayer() has to geocode the results in this case, which can only be accomplished 1000 records at a time. - Flattening the multilevel index with df.stack().reset_index() creates individual records with the multilevel index appropriately transposed for each record. - With some data engineering of column names and using the GeoAccessor.from_xy() method a valid spatial data frame can be created and the to_featurelayer() method used (Although this simply recreates the original feature layer in this case).Workaround
Use the commented out syntax of the last kernel to convert the DataFrame to a CSV file, and publish it. However, this does not always work correctly. Refer to BUG-000129950 for more information.
Steps to Reproduce
Bug ID: BUG-000130651
Software:
- ArcGIS Online
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App