I need to make a script tool that will consolidate attributes from many rows into to one across a number of columns. The tool will need to be able to let the user select the field "key" field as well as the fields that will be consolidated. I made a quick mockup table as my input table (it has been processed with spatial sort so that parts of the key features that are spatially adjacent to each other are also in adjacent rows in the table). Mockup table. It has land ownership and PLSS (Public Land Survey System) MTRS (meridian township range section) information. Key_FeatureOwnerMTRSECTIONMTRSMERFacility 1PrivateU009N008E33U009N008E33UFacility 1FederalU009N008E33U009N008E33UFacility 1PrivateU009N008E34U009N008E34UFacility 1FederalU009N008E34U009N008E34UFacility 1PrivateU008N008E4U008N008E04UFacility 2PrivateU008N008E3U008N008E03U The output should look like this. Key_FeatureMTRSOwnerFacility 1U, T09N, R08E: 33, 34 U, T08N, R08E: 4Federal, PrivateFacility 2U, T08N, R08E: 3Private The question: I would like input on the best method to get the result. And if there are any out of the box Arc tools that I could leverage... My first pass at this was to use arcpy.da.SearchCursor and iterate over the input table and check to see if the current row's key feature is the same as the previous row's key feature. If so, then add it to a string variable. When the key features do not match write the string variable and other fields to the output file. The MTRS roll up is a little more complex because sections needs to rolled up for each unique MTR associated with the key feature. It feels a little wired because you are always looking back in rows as you iterate over the table. So, I used a number of temp_last variables for key features, MTRS, etc. I was thinking that it would be better to read the whole table into a list of lists and then use that to generate the output. That way I could use indexing to look at the next and last rows without having to use the temp_last variables. The below code I made for a similar one off. import arcpy import os arcpy . env . overwriteOutput = True in_path = r "xyz" out_path = "xyz" def tsv_write ( tsv_row ) : for item in tsv_row : tsv . write ( item + "\t" ) tsv . write ( "\n" ) def rollup ( rollup_list ) : rollup_list = set ( rollup_list ) rollup_list = list ( rollup_list ) rollup_list . sort ( ) rollup_str = "" for sec in rollup_list : rollup_str = rollup_str + str ( sec ) + ", " rollup_str = rollup_str [ : - 2 ] return rollup_str def from_to_fix ( x ) : x = round ( x , 1 ) x = str ( x ) return x search_cursor = arcpy . da . SearchCursor ( in_path , [ "Main_LandOwnership_MTRS_Mbook_Meridian" , "Main_LandOwnership_MTRS_Mbook_Town_Range" , "Main_LandOwnership_MTRS_Mbook_SECTION" , "Main_LandOwnership_MTRS_Mbook_F_MP" , "Main_LandOwnership_MTRS_Mbook_T_MP" , "Main_LandOwnership_MTRS_Mbook_Index_Order" , "Main_LandOwnership_MTRS_Mbook_ROW_Designation" ] ) tsv = open ( out_path , "w" ) meridian_last = None township_last = None f_mile_last = None t_mile_last = None owner_last = None township_list = [ ] township_section_list = [ ] first_row_flag = True township_append_flag = True section_list = [ ] index_order_list = [ ] for row in search_cursor : meridian = row [ 0 ] township = row [ 1 ] section = row [ 2 ] f_mile = row [ 3 ] t_mile = row [ 4 ] index_order = row [ 5 ] owner = row [ 6 ] if first_row_flag : township_last = township f_mile_last = f_mile t_mile_last = t_mile owner_last = owner first_row_flag = False if township == township_last : township_append_flag = True section_list . append ( int ( section ) ) else : township_append_flag = False section_rollup = rollup ( section_list ) township_section_list . append ( township_last + ": " + section_rollup ) section_list = [ ] section_list . append ( int ( section ) ) if f_mile == f_mile_last : index_order_list . append ( int ( index_order ) ) else : index_order_rollup = rollup ( index_order_list ) write_flag = True for trs in township_section_list : if write_flag : write_flag = False print [ from_to_fix ( f_mile_last ) , from_to_fix ( t_mile_last ) , trs , owner_last , index_order_rollup ] tsv_write ( [ from_to_fix ( f_mile_last ) , from_to_fix ( t_mile_last ) , trs , owner_last , index_order_rollup ] ) else : print [ "" , "" , trs , "" , "" ] tsv_write ( [ "" , "" , trs , "" , "" ] ) township_section_list = [ ] index_order_list = [ ] index_order_list . append ( index_order ) if meridian != meridian_last : print meridian tsv_write ( [ meridian ] ) print [ "From MP" , "To MP" , "MTRS" , "Ownership" , "Map Book Sheet" ] tsv_write ( [ "From MP" , "To MP" , "MTRS" , "Ownership" , "Map Book Sheet" ] ) meridian_last = meridian township_last = township f_mile_last = f_mile t_mile_last = t_mile owner_last = owner if not township_append_flag : township_section_list . append ( township_last + ": " + str ( int ( section ) ) ) index_order_rollup = rollup ( index_order_list ) write_flag = True for trs in township_section_list : if write_flag : write_flag = False print [ from_to_fix ( f_mile_last ) , from_to_fix ( t_mile_last ) , trs , owner_last , index_order_rollup ] tsv_write ( [ from_to_fix ( f_mile_last ) , from_to_fix ( t_mile_last ) , trs , owner , index_order_rollup ] ) else : print [ "" , "" , trs , "" , "" ] tsv_write ( [ "" , "" , trs , "" , "" ] ) township_section_list = [ ] index_order_list = [ ] index_order_list . append ( index_order ) tsv . close ( ) Thanks for any input! Forest

I think this will work for you: from collections import defaultdict tbl = # path to table flds = "Key_Feature Owner MTRS" . split ( ) # list of string field names rollup_tbl = arcpy . CreateTable_management ( "in_memory" , "rollup" ) for fld in flds : arcpy . AddField_management ( rollup_tbl , fld , "TEXT" ) kf_dict = defaultdict ( lambda : { 'owner' : set ( ) , 'mtrs' : defaultdict ( set ) } ) with arcpy . da . SearchCursor ( tbl , flds ) as cur : for kf , owner , mtrs in cur : kf_dict [ kf ] [ 'owner' ] . add ( owner ) kf_dict [ kf ] [ 'mtrs' ] [ mtrs [ : - 2 ] ] . add ( mtrs [ - 2 : ] ) with arcpy . da . InsertCursor ( rollup_tbl , flds ) as cur : for k , v in kf_dict . items ( ) : kf = k owner = "," . join ( v [ 'owner' ] ) mtrs = [ "{}, T{}, R{}: {}" . format ( mtr [ 0 ] , mtr [ 2 : 5 ] , mtr [ 6 : 9 ] , "," . join ( sec ) ) for mtr , sec in v [ 'mtrs' ] . items ( ) ] cur . insertRow ( [ kf , owner , "\n" . join ( mtrs ) ] ) The code above relies on nested defautldict to do the aggregation. It turns out the aggregation is much simpler than formatting the MTRS output the way you want it. The code creates an in-memory table for storing the results. Since I put a newline character to break up the different MTRS items, you won't see everything on the single row when looking at the table in ArcMap. If you print the results or create a report, it will all be there.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Advice on "roll up" / consolidation tool

forestknutsen1

I need to make a script tool that will consolidate attributes from many rows into to one across a number of columns. The tool will need to be able to let the user select the field "key" field as well as the fields that will be consolidated. I made a quick mockup table as my input table (it has been processed with spatial sort so that parts of the key features that are spatially adjacent to each other are also in adjacent rows in the table).

Mockup table. It has land ownership and PLSS (Public Land Survey System) MTRS (meridian township range section) information.

Key_Feature	Owner	MTR	SECTION	MTRS	MER
Facility 1	Private	U009N008E	33	U009N008E33	U
Facility 1	Federal	U009N008E	33	U009N008E33	U
Facility 1	Private	U009N008E	34	U009N008E34	U
Facility 1	Federal	U009N008E	34	U009N008E34	U
Facility 1	Private	U008N008E	4	U008N008E04	U
Facility 2	Private	U008N008E	3	U008N008E03	U

The output should look like this.

Key_Feature	MTRS	Owner
Facility 1	U, T09N, R08E: 33, 34 U, T08N, R08E: 4	Federal, Private
Facility 2	U, T08N, R08E: 3	Private

The question: I would like input on the best method to get the result. And if there are any out of the box Arc tools that I could leverage...

My first pass at this was to use arcpy.da.SearchCursor and iterate over the input table and check to see if the current row's key feature is the same as the previous row's key feature. If so, then add it to a string variable. When the key features do not match write the string variable and other fields to the output file. The MTRS roll up is a little more complex because sections needs to rolled up for each unique MTR associated with the key feature. It feels a little wired because you are always looking back in rows as you iterate over the table. So, I used a number of temp_last variables for key features, MTRS, etc. I was thinking that it would be better to read the whole table into a list of lists and then use that to generate the output. That way I could use indexing to look at the next and last rows without having to use the temp_last variables.

The below code I made for a similar one off.

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> os

arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>

in_path <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"xyz"</SPAN>
out_path <SPAN class="operator token">=</SPAN><SPAN class="string token">"xyz"</SPAN>


<SPAN class="keyword token">def</SPAN> <SPAN class="token function">tsv_write</SPAN><SPAN class="punctuation token">(</SPAN>tsv_row<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> item <SPAN class="keyword token">in</SPAN> tsv_row<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tsv<SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN>item <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\t"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; tsv<SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"\n"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">rollup</SPAN><SPAN class="punctuation token">(</SPAN>rollup_list<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; rollup_list <SPAN class="operator token">=</SPAN> set<SPAN class="punctuation token">(</SPAN>rollup_list<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; rollup_list <SPAN class="operator token">=</SPAN> list<SPAN class="punctuation token">(</SPAN>rollup_list<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; rollup_list<SPAN class="punctuation token">.</SPAN>sort<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; rollup_str <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> sec <SPAN class="keyword token">in</SPAN> rollup_list<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rollup_str <SPAN class="operator token">=</SPAN> rollup_str <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>sec<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">", "</SPAN>
&nbsp;&nbsp;&nbsp; rollup_str <SPAN class="operator token">=</SPAN> rollup_str<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> rollup_str

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">from_to_fix</SPAN><SPAN class="punctuation token">(</SPAN>x<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; x <SPAN class="operator token">=</SPAN> round<SPAN class="punctuation token">(</SPAN>x<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; x <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>x<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> x


search_cursor <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>in_path<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Main_LandOwnership_MTRS_Mbook_Meridian"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"Main_LandOwnership_MTRS_Mbook_Town_Range"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"Main_LandOwnership_MTRS_Mbook_SECTION"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"Main_LandOwnership_MTRS_Mbook_F_MP"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"Main_LandOwnership_MTRS_Mbook_T_MP"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"Main_LandOwnership_MTRS_Mbook_Index_Order"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"Main_LandOwnership_MTRS_Mbook_ROW_Designation"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

tsv <SPAN class="operator token">=</SPAN> open<SPAN class="punctuation token">(</SPAN>out_path<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"w"</SPAN><SPAN class="punctuation token">)</SPAN>

meridian_last <SPAN class="operator token">=</SPAN> None
township_last <SPAN class="operator token">=</SPAN> None
f_mile_last <SPAN class="operator token">=</SPAN> None
t_mile_last <SPAN class="operator token">=</SPAN> None
owner_last <SPAN class="operator token">=</SPAN> None

township_list <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
township_section_list <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>

first_row_flag <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>
township_append_flag <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>
section_list <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
index_order_list <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> search_cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; meridian <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; township <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; section <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; f_mile <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; t_mile <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; index_order <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; owner <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">]</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> first_row_flag<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; township_last <SPAN class="operator token">=</SPAN> township
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f_mile_last <SPAN class="operator token">=</SPAN> f_mile
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; t_mile_last <SPAN class="operator token">=</SPAN> t_mile
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; owner_last <SPAN class="operator token">=</SPAN> owner
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; first_row_flag <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">False</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> township <SPAN class="operator token">==</SPAN> township_last<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; township_append_flag <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; section_list<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>int<SPAN class="punctuation token">(</SPAN>section<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; township_append_flag <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">False</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; section_rollup <SPAN class="operator token">=</SPAN> rollup<SPAN class="punctuation token">(</SPAN>section_list<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; township_section_list<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>township_last <SPAN class="operator token">+</SPAN> <SPAN class="string token">": "</SPAN> <SPAN class="operator token">+</SPAN> section_rollup<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; section_list <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; section_list<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>int<SPAN class="punctuation token">(</SPAN>section<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> f_mile <SPAN class="operator token">==</SPAN> f_mile_last<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; index_order_list<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>int<SPAN class="punctuation token">(</SPAN>index_order<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; index_order_rollup <SPAN class="operator token">=</SPAN> rollup<SPAN class="punctuation token">(</SPAN>index_order_list<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; write_flag <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> trs <SPAN class="keyword token">in</SPAN> township_section_list<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> write_flag<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; write_flag <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">False</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">[</SPAN>from_to_fix<SPAN class="punctuation token">(</SPAN>f_mile_last<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> from_to_fix<SPAN class="punctuation token">(</SPAN>t_mile_last<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> trs<SPAN class="punctuation token">,</SPAN> owner_last<SPAN class="punctuation token">,</SPAN> index_order_rollup<SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tsv_write<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>from_to_fix<SPAN class="punctuation token">(</SPAN>f_mile_last<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> from_to_fix<SPAN class="punctuation token">(</SPAN>t_mile_last<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> trs<SPAN class="punctuation token">,</SPAN> owner_last<SPAN class="punctuation token">,</SPAN> index_order_rollup<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> trs<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tsv_write<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> trs<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; township_section_list <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; index_order_list <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; index_order_list<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>index_order<SPAN class="punctuation token">)</SPAN>


&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> meridian <SPAN class="operator token">!=</SPAN> meridian_last<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> meridian
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tsv_write<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>meridian<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"From MP"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"To MP"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"MTRS"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Ownership"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Map Book Sheet"</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tsv_write<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">"From MP"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"To MP"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"MTRS"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Ownership"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Map Book Sheet"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; meridian_last <SPAN class="operator token">=</SPAN> meridian
&nbsp;&nbsp;&nbsp; township_last <SPAN class="operator token">=</SPAN> township
&nbsp;&nbsp;&nbsp; f_mile_last <SPAN class="operator token">=</SPAN> f_mile
&nbsp;&nbsp;&nbsp; t_mile_last <SPAN class="operator token">=</SPAN> t_mile
&nbsp;&nbsp;&nbsp; owner_last <SPAN class="operator token">=</SPAN> owner

<SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> township_append_flag<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; township_section_list<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>township_last <SPAN class="operator token">+</SPAN> <SPAN class="string token">": "</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>int<SPAN class="punctuation token">(</SPAN>section<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

index_order_rollup <SPAN class="operator token">=</SPAN> rollup<SPAN class="punctuation token">(</SPAN>index_order_list<SPAN class="punctuation token">)</SPAN>
write_flag <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>
<SPAN class="keyword token">for</SPAN> trs <SPAN class="keyword token">in</SPAN> township_section_list<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> write_flag<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; write_flag <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">False</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">[</SPAN>from_to_fix<SPAN class="punctuation token">(</SPAN>f_mile_last<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> from_to_fix<SPAN class="punctuation token">(</SPAN>t_mile_last<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> trs<SPAN class="punctuation token">,</SPAN> owner_last<SPAN class="punctuation token">,</SPAN> index_order_rollup<SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tsv_write<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>from_to_fix<SPAN class="punctuation token">(</SPAN>f_mile_last<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> from_to_fix<SPAN class="punctuation token">(</SPAN>t_mile_last<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> trs<SPAN class="punctuation token">,</SPAN> owner<SPAN class="punctuation token">,</SPAN> index_order_rollup<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> trs<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tsv_write<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> trs<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
township_section_list <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
index_order_list <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
index_order_list<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>index_order<SPAN class="punctuation token">)</SPAN>

tsv<SPAN class="punctuation token">.</SPAN>close<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Thanks for any input!

Forest

Find more posts tagged with

Accepted answers

JoshuaBixby

I think this will work for you:

<SPAN class="keyword token">from</SPAN> collections <SPAN class="keyword token">import</SPAN> defaultdict

tbl <SPAN class="operator token">=</SPAN> <SPAN class="comment token"># path to table</SPAN>
flds <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Key_Feature Owner MTRS"</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># list of string field names</SPAN>

rollup_tbl <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>CreateTable_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"in_memory"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"rollup"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> fld <SPAN class="keyword token">in</SPAN> flds<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>AddField_management<SPAN class="punctuation token">(</SPAN>rollup_tbl<SPAN class="punctuation token">,</SPAN> fld<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"TEXT"</SPAN><SPAN class="punctuation token">)</SPAN>

kf_dict <SPAN class="operator token">=</SPAN> defaultdict<SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">lambda</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">{</SPAN><SPAN class="string token">'owner'</SPAN><SPAN class="punctuation token">:</SPAN>set<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'mtrs'</SPAN><SPAN class="punctuation token">:</SPAN>defaultdict<SPAN class="punctuation token">(</SPAN>set<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>tbl<SPAN class="punctuation token">,</SPAN> flds<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cur<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> kf<SPAN class="punctuation token">,</SPAN> owner<SPAN class="punctuation token">,</SPAN> mtrs <SPAN class="keyword token">in</SPAN> cur<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; kf_dict<SPAN class="punctuation token">[</SPAN>kf<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'owner'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>add<SPAN class="punctuation token">(</SPAN>owner<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; kf_dict<SPAN class="punctuation token">[</SPAN>kf<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'mtrs'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN>mtrs<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>add<SPAN class="punctuation token">(</SPAN>mtrs<SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>rollup_tbl<SPAN class="punctuation token">,</SPAN> flds<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cur<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> k<SPAN class="punctuation token">,</SPAN>v <SPAN class="keyword token">in</SPAN> kf_dict<SPAN class="punctuation token">.</SPAN>items<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; kf <SPAN class="operator token">=</SPAN> k
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; owner <SPAN class="operator token">=</SPAN> <SPAN class="string token">","</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>v<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'owner'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mtrs <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"{}, T{}, R{}: {}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>mtr<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mtr<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mtr<SPAN class="punctuation token">[</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">9</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">","</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>sec<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> mtr<SPAN class="punctuation token">,</SPAN>sec
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">in</SPAN> v<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'mtrs'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>items<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cur<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>kf<SPAN class="punctuation token">,</SPAN> owner<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"\n"</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>mtrs<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

The code above relies on nested defautldict to do the aggregation. It turns out the aggregation is much simpler than formatting the MTRS output the way you want it. The code creates an in-memory table for storing the results. Since I put a newline character to break up the different MTRS items, you won't see everything on the single row when looking at the table in ArcMap. If you print the results or create a report, it will all be there.

All comments

forestknutsen1

Joshua Bixby wrote:
How would the results of the output change if if the fourth line in the original table was removed?

The output would be the same. I think of it in this way. I have a facility polygon layer that is intersected with an MTRS polygon and then also with a land ownership polygon. This cuts the facility polygon into many pieces. Then for each facility, we want to report its MTRS and land ownership. But we only want to list the facility once in the final table.

Joshua Bixby wrote:
If a single record for Facility X has either Private or Federal, does Private or Federal show up in the output table regardless of how many of the other types of ownership are present?

Not sure if I understand your question... But with that said. If Facility X has a row that reports it is on Federal then Federal should be included in the output no matter what other land ownership types are in other rows.

JoshuaBixby

How would the results of the output change if if the fourth line in the original table was removed? If a single record for Facility X has either Private or Federal, does Private or Federal show up in the output table regardless of how many of the other types of ownership are present?

forestknutsen1

Because I went too fast when making the mockup. Sorry for the confusion. I fixed it up.

JoshuaBixby

How can the aggregated Facility 2 have Section 4 when that section is associated with a row for Facility 1.

forestknutsen1

I did try. They show up fine in the edit space but once it is posted the borders disappear

JoshuaBixby

Can you put some cell boundaries around your output table to make it more clear what is in what row? Thanks.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.