max value of a field as variable

AlfonsZitterbacke

Hello, 

With the following script I was able to determine the maximum values of a column [POINT_Z] for certain groups from [ID_1].

    <SPAN class="comment token">#creating a list ->"mast_value" with unique values of field [ID_1]</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>inLAS<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">'_POLE_POINTS.SHP'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'ID_1'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> max_cursor<SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> max_cursor<SPAN class="punctuation token">:</SPAN>
            mast_value <SPAN class="operator token">=</SPAN> sorted<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">{</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>