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; } } }

Points Max and Min

Anonymous User

Hello everyone,

I have a layer with:

*LINK ID

*Road_Point_ID

*House Number

*Lat

*Lon

I want to take the Max and Min House Number of each Link ID, but I could not found the correct way to do this; I tried with Summary Statitics tool, although if give me the information I require, it removes the Lon and Lat values and those values are necessary; I will try with the Select by Attributes tool, using a SQL sentence: "HOUSE_NUMBER = (SELECT MIN(HOUSE_NUMBER) FROM name_table", but this only select the max or min of the all table and not of each Link ID;

Do you have any idea to solve this question?

Thank you so much for your support;

Regards.

Najděte více příspěvků označených jako

Accepted answers

bixb0012

There are several ways this can be addressed. If the feature class is already loaded into a map, and thus has a corresponding layer, I think the easiest approach is to iterate over the feature class finding the OIDs that correspond to the max and min values you want, then you can select those OIDs and export the selection to a new feature class.

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

lyr_name <SPAN class="operator token">=</SPAN> <SPAN class="string token">"minmax_example"</SPAN>

max_values <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>None<SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN>math<SPAN class="punctuation token">.</SPAN>inf<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
min_values <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>None<SPAN class="punctuation token">,</SPAN>math<SPAN class="punctuation token">.</SPAN>inf<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>lyr_name<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"OID@"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"LINK_ID"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"HOUSE_NUMBER"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cur<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">for</SPAN> oid<SPAN class="punctuation token">,</SPAN> lid<SPAN class="punctuation token">,</SPAN> hn <SPAN class="keyword token">in</SPAN> cur<SPAN class="punctuation token">:</SPAN>
        max_values<SPAN class="punctuation token">[</SPAN>lid<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> max<SPAN class="punctuation token">(</SPAN>max_values<SPAN class="punctuation token">[</SPAN>lid<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">(</SPAN>oid<SPAN class="punctuation token">,</SPAN>hn<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> key<SPAN class="operator token">=</SPAN><SPAN class="keyword token">lambda</SPAN> x<SPAN class="punctuation token">:</SPAN> x<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
        min_values<SPAN class="punctuation token">[</SPAN>lid<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> min<SPAN class="punctuation token">(</SPAN>min_values<SPAN class="punctuation token">[</SPAN>lid<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">(</SPAN>oid<SPAN class="punctuation token">,</SPAN>hn<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> key<SPAN class="operator token">=</SPAN><SPAN class="keyword token">lambda</SPAN> x<SPAN class="punctuation token">:</SPAN> x<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

max_oids <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>oid <SPAN class="keyword token">for</SPAN> oid<SPAN class="punctuation token">,</SPAN>_ <SPAN class="keyword token">in</SPAN> max_values<SPAN class="punctuation token">.</SPAN>values<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN>
min_oids <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>oid <SPAN class="keyword token">for</SPAN> oid<SPAN class="punctuation token">,</SPAN>_ <SPAN class="keyword token">in</SPAN> min_values<SPAN class="punctuation token">.</SPAN>values<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN>

lyr <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mp<SPAN class="punctuation token">.</SPAN>ArcGISProject<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"CURRENT"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>activeMap<SPAN class="punctuation token">.</SPAN>listLayers<SPAN class="punctuation token">(</SPAN>lyr_name<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
lyr<SPAN class="punctuation token">.</SPAN>setSelectionSet<SPAN class="punctuation token">(</SPAN>max_oids <SPAN class="operator token">+</SPAN> min_oids<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>

All comments

Anonymous User

Hello Joshua,

That was awesome, it works!!!.

Just one final question, the HOUSE_NUMBER field is data type "Text" and the other fields are "Numeric"; so when i run the scrip an error message appears that said "TypeError: '>' not supported between instances of 'str' and 'float'"; I did a research about this and I found the problem is because the fields are not equal. I said before the scrip works because I did a test with all the fields as Data Type "Numeric" and is working fine but do you know if something can do to avoid that error?;

Thank you so much for your support.

bixb0012

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

lyr_name <SPAN class="operator token">=</SPAN> <SPAN class="string token">"minmax_example"</SPAN>

max_values <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>None<SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN>math<SPAN class="punctuation token">.</SPAN>inf<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
min_values <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>None<SPAN class="punctuation token">,</SPAN>math<SPAN class="punctuation token">.</SPAN>inf<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>lyr_name<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"OID@"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"LINK_ID"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"HOUSE_NUMBER"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cur<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">for</SPAN> oid<SPAN class="punctuation token">,</SPAN> lid<SPAN class="punctuation token">,</SPAN> hn <SPAN class="keyword token">in</SPAN> cur<SPAN class="punctuation token">:</SPAN>
        max_values<SPAN class="punctuation token">[</SPAN>lid<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> max<SPAN class="punctuation token">(</SPAN>max_values<SPAN class="punctuation token">[</SPAN>lid<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">(</SPAN>oid<SPAN class="punctuation token">,</SPAN>hn<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> key<SPAN class="operator token">=</SPAN><SPAN class="keyword token">lambda</SPAN> x<SPAN class="punctuation token">:</SPAN> x<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
        min_values<SPAN class="punctuation token">[</SPAN>lid<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> min<SPAN class="punctuation token">(</SPAN>min_values<SPAN class="punctuation token">[</SPAN>lid<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">(</SPAN>oid<SPAN class="punctuation token">,</SPAN>hn<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> key<SPAN class="operator token">=</SPAN><SPAN class="keyword token">lambda</SPAN> x<SPAN class="punctuation token">:</SPAN> x<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

max_oids <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>oid <SPAN class="keyword token">for</SPAN> oid<SPAN class="punctuation token">,</SPAN>_ <SPAN class="keyword token">in</SPAN> max_values<SPAN class="punctuation token">.</SPAN>values<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN>
min_oids <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>oid <SPAN class="keyword token">for</SPAN> oid<SPAN class="punctuation token">,</SPAN>_ <SPAN class="keyword token">in</SPAN> min_values<SPAN class="punctuation token">.</SPAN>values<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN>

lyr <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mp<SPAN class="punctuation token">.</SPAN>ArcGISProject<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"CURRENT"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>activeMap<SPAN class="punctuation token">.</SPAN>listLayers<SPAN class="punctuation token">(</SPAN>lyr_name<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
lyr<SPAN class="punctuation token">.</SPAN>setSelectionSet<SPAN class="punctuation token">(</SPAN>max_oids <SPAN class="operator token">+</SPAN> min_oids<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>

Anonymous User

Hello Joshua,

I will try to generate a new layer with only the max and min values of each LINK ID, for that reason I need the Lat/Lon values.

Anonymous User

Hello L R,

I tried that but I can't figure out how to join the information correctly, what value can I use from one table and the other that matches correctly? I mean the only two values that match, are the Link_ID and House Number values, but the problem is:
-If I select to join based on LINK_ID the original table has several equal values of Link_ID
-If I select to join based on House Number, there are several numbers that are the same
It causes me to join Lat/Lon incorrectly.

bixb0012

I want to take the Max and Min House Number of each Link ID

So after you get the Max and Min house number, what do you want to do with it or where do you want to store it? Do you want the information in a new table, or do you want to update the existing table?

Why not join your result table with the input table to append the info you need? Alternatively try Excel with pivot tables.

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Přihlásit se
Registrovat

Rychlé odkazy

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