When data from a cloud-hosted feature service is loaded into ArcMap, it queries the first 1,000 features "to enhance performance"... I, however, need to see all the features. How can I add all features to my map? I want to do a selection on the service directly according to this blog post: https://blogs.esri.com/esri/arcgis/2013/10/10/quick-tips-consuming-feature-services-with-geoprocessing/
Max Records
If you’ve already performed some analysis on a hosted feature service from arcgis.com, you may have encountered the following warning:
WARNING 001406: Query operation has exceeded the feature service transfer limit
Only the first 1000 records will be used by the geoprocessing tools. Hosted feature services have their maximum query set to 1000 records. 1000 is also the default maximum with a local ArcGIS for Server. However you have the option to increase this value in your local deployment. To work with a feature service that has more than 1000 records you will have to iterate through the records 1000 (or less) at a time. Remember that geoprocessing tools honor selection sets. You can manually select 1000 records at a time, or you can use a geoprocessing tool like Select Layer by Attribute. Tools like Merge and Append can be used to combine all your features into a single feature class depending on your needs.
However, when I go to use the tool, Select Layer By Attribute, I am unable to use the hosted feature service directly as my Input layer. Is there a specific way I have to do this? Has anyone created a custom tool or script to do this?