What is the record limit?

Question

Got this message today but I cannot find anywhere what the limit is?  We have some up to 8 million and I do not expect that but need to know what it is.

Also how can I limit it somehow?  We can make one excel file per state but how would I do that if I get stopped right away?  Would I have to make 12 different state maps and load from those?

A way to add a query before the pull would be pretty sweet I guess.  Is this possible at all?  Then I could pull 1 state and it would all be faster.

thanks

dougbrowning · Answer

This workaround would be way beyond all of our users.

ShannonCardoza · Answer

Hey @DougBrowning, good afternoon-ish,

and of course we just squeaked by the limit threshold you are working with. Shucks!

So currently, the short answer is no query option but I am assuming you are adding a feature layer from AGOL, so couldn't you query in AGOL, save each query for each state and then bring that layer into ArcGIS for Excel?

What is your ideal shortcut workflow? You already know I am open to ideas and we could potentially make something happen.

-SC

dougbrowning · Answer

I get it, we just happen to have one that is 1.2 million and almost makes it.  So then my next question is can I somehow add a query?  We have a national dataset but we do want to make one file per state to get around the limit and to make it faster.  But I have to add all the data before I can filter in excel and then I hit the limit.  Hope that makes sense.  I am hoping not to have to make 12 maps each with a state filter.