I have run "Generate Origin Destination Cost Matrix" in "ArcGIS Pro". But I have got ERROR 030096 telling that the maximum records for Origins limit of 1,000 has been exceeded. The number of origins for my project is nearly 67,000 points, and I don't want to split them into 67 groups; hence I am looking for a way to increase the limit from 1,000 to say 67,000 in ArcGIS pro.
Thank you in advance
You will need a field to use SplitByAttributes ....
You can load this function in the Field Calculator and calculate the grouping in a numeric (long) field.
The key is the seq_group(!OBJECTID!, XXXX) line. In the example below, if the objected mod 10 equals 0, the sequential 'cnt' value increases, thereby starting a new group of values.
Give it a shot, then split by attributes on that field
cnt = 0
def seq_group(id, val):
if id % val == 0 :
cnt += 1
Tested in ArcGIS Pro, should work in ArcMap
Thanks for your prompt response. Your solution could work, but I prefer to increase the limit from 1,000 to 67,000 if there is any way to do that in ArcGIS pro.
it will break into groups of 1000, if you want groups of 67,000, then change the 10 to 67000
seq_group(!OBJECTID!, 67000) # 67000 is the number of objects to form one group, could be 10, 100, 1000 whatever
Which means you didn't try it did you? Once you have it numbered, which you can confirm rapidly, then you splitby attribute on that field you created
How can I load seq_group function into my Field Calculator? I don't have this function in my Field Calculator .
BTW, I still prefer NOT to split my origins into groups, and instead I prefer to increase the limit of "network analysis tool" from 1,000 to 67,000 (if there is any way) in order to not get ERROR 030096 anymore.
You either split or reduce your origins... surely some can be aggregated because they are really close together...
If notthis is the only other information, which basically says what we have already covered.
030096: The maximum records for <value> limit of <value> has been exceeded.
The input features or rows cannot be added to the specified network analysis class as the maximum allowed limit has been exceeded.
Reduce the number of input features or rows that are being added to the specified network analysis class, or if possible, increase the limit.
In ArcGIS Pro, the OD Cost Matrix itself does not have a 1000 origin limit. If you have your own local network dataset then you can solve for larger number of origins.
The 1000 Origins limit is imposed when you are using ArcGIS.com to solve this problem. This is a limit imposed on the OD service. How many destinations do you have? If you have a large number of destinations then the size of the computed OD become quite large and hard to transfer that data back. So try to use the splitting it as Dan outlined.
Thank you very much Mr. Sandhu.
The number of my destinations is around 4,000. Based on your explanation, it seems that there is no way to increase origin limit when using ArcGIS.com for solving the problem.
In case I use my own local network dataset, can I calculate time taken from origin to destination based on existing traffic on the roadway (NOT distance from origin to destination)?
If your local network dataset has been built with support for live traffic and you are subscribing to a traffic feed then, Yes, you can use it to compute the OD based on a start time. But remember, that travel time (based on real-time traffic) is only valid for that start time.