Retrieve attribute with max value by groupHow to combine rows in attribute table using ArcGIS for Desktop?Resizing polygon features in ArcGIS Desktop based on attribute value?Percentage CoverageWeighted-area averages using dissolve for SINGLE PART featuresDissolve polygons based on max attribute value and retain attributes for that feature?Combining polygon file with multiple overlapping polygons to represent only 1 attribute in given area e.g. highest/lowest/average in ArcGIS Desktop?Buffering with dissolve type: ALL for a big feature class doesnot create a single multipart featureMapping Commuting Zones from Counties for US 1990 Data in ArcMap?Dissolve on attribute field and location?Selecting max values using Dissolve + keeping other fields?

I would say: "You are another teacher", but she is a woman and I am a man

What exploit are these user agents trying to use?

Emailing HOD to enhance faculty application

A reference to a well-known characterization of scattered compact spaces

Alternative to sending password over mail?

Western buddy movie with a supernatural twist where a woman turns into an eagle at the end

What's the point of deactivating Num Lock on login screens?

Can a rocket refuel on Mars from water?

How can I make my BBEG immortal short of making them a Lich or Vampire?

Watching something be written to a file live with tail

Why does Arabsat 6A need a Falcon Heavy to launch

How to model explosives?

Arrow those variables!

prove that the matrix A is diagonalizable

What's the difference between 'rename' and 'mv'?

Why does Kotter return in Welcome Back Kotter

Why is Collection not simply treated as Collection<?>

Does a druid starting with a bow start with no arrows?

I'm flying to France today and my passport expires in less than 2 months

Can a virus destroy the BIOS of a modern computer?

Forgetting the musical notes while performing in concert

Why are electrically insulating heatsinks so rare? Is it just cost?

Theorems that impeded progress

Could gravitational lensing be used to protect a spaceship from a laser?



Retrieve attribute with max value by group


How to combine rows in attribute table using ArcGIS for Desktop?Resizing polygon features in ArcGIS Desktop based on attribute value?Percentage CoverageWeighted-area averages using dissolve for SINGLE PART featuresDissolve polygons based on max attribute value and retain attributes for that feature?Combining polygon file with multiple overlapping polygons to represent only 1 attribute in given area e.g. highest/lowest/average in ArcGIS Desktop?Buffering with dissolve type: ALL for a big feature class doesnot create a single multipart featureMapping Commuting Zones from Counties for US 1990 Data in ArcMap?Dissolve on attribute field and location?Selecting max values using Dissolve + keeping other fields?






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








0















I have a intersected counties shapefile with wind potential category attribute. What I want to do is to dissolve the features grouping them by county, and retrieve the WPC value which has the largest AREA. With Dissolve tool i am able to retrieve the area only.



Here is the data snippet:



enter image description here



So my desired output would be a layer with 1 feature for county with WPC value (with max Shape area).










share|improve this question






















  • Look at the help page. Dissolve by country field and max statistic on sum shape.

    – Hornbydd
    Apr 1 at 17:57











  • Thanks. With Dissolve tool I was able only to get SUM_Shape value, but I need WPC as well.

    – icelandico
    Apr 1 at 18:00











  • To get corresponding WPC of max area, join dissolve layer to original layer on area, you can include any fields you want.

    – klewis
    Apr 1 at 18:08











  • Sort descending by area, remove duplicate by country. Also I suggest removing spatial analyst from tags.

    – FelixIP
    2 days ago












  • Thanks, I'll check this solution.

    – icelandico
    2 days ago

















0















I have a intersected counties shapefile with wind potential category attribute. What I want to do is to dissolve the features grouping them by county, and retrieve the WPC value which has the largest AREA. With Dissolve tool i am able to retrieve the area only.



Here is the data snippet:



enter image description here



So my desired output would be a layer with 1 feature for county with WPC value (with max Shape area).










share|improve this question






















  • Look at the help page. Dissolve by country field and max statistic on sum shape.

    – Hornbydd
    Apr 1 at 17:57











  • Thanks. With Dissolve tool I was able only to get SUM_Shape value, but I need WPC as well.

    – icelandico
    Apr 1 at 18:00











  • To get corresponding WPC of max area, join dissolve layer to original layer on area, you can include any fields you want.

    – klewis
    Apr 1 at 18:08











  • Sort descending by area, remove duplicate by country. Also I suggest removing spatial analyst from tags.

    – FelixIP
    2 days ago












  • Thanks, I'll check this solution.

    – icelandico
    2 days ago













0












0








0








I have a intersected counties shapefile with wind potential category attribute. What I want to do is to dissolve the features grouping them by county, and retrieve the WPC value which has the largest AREA. With Dissolve tool i am able to retrieve the area only.



Here is the data snippet:



enter image description here



So my desired output would be a layer with 1 feature for county with WPC value (with max Shape area).










share|improve this question














I have a intersected counties shapefile with wind potential category attribute. What I want to do is to dissolve the features grouping them by county, and retrieve the WPC value which has the largest AREA. With Dissolve tool i am able to retrieve the area only.



Here is the data snippet:



enter image description here



So my desired output would be a layer with 1 feature for county with WPC value (with max Shape area).







arcgis-desktop arcpy spatial-analyst dissolve






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Apr 1 at 17:52









icelandicoicelandico

402211




402211












  • Look at the help page. Dissolve by country field and max statistic on sum shape.

    – Hornbydd
    Apr 1 at 17:57











  • Thanks. With Dissolve tool I was able only to get SUM_Shape value, but I need WPC as well.

    – icelandico
    Apr 1 at 18:00











  • To get corresponding WPC of max area, join dissolve layer to original layer on area, you can include any fields you want.

    – klewis
    Apr 1 at 18:08











  • Sort descending by area, remove duplicate by country. Also I suggest removing spatial analyst from tags.

    – FelixIP
    2 days ago












  • Thanks, I'll check this solution.

    – icelandico
    2 days ago

















  • Look at the help page. Dissolve by country field and max statistic on sum shape.

    – Hornbydd
    Apr 1 at 17:57











  • Thanks. With Dissolve tool I was able only to get SUM_Shape value, but I need WPC as well.

    – icelandico
    Apr 1 at 18:00











  • To get corresponding WPC of max area, join dissolve layer to original layer on area, you can include any fields you want.

    – klewis
    Apr 1 at 18:08











  • Sort descending by area, remove duplicate by country. Also I suggest removing spatial analyst from tags.

    – FelixIP
    2 days ago












  • Thanks, I'll check this solution.

    – icelandico
    2 days ago
















Look at the help page. Dissolve by country field and max statistic on sum shape.

– Hornbydd
Apr 1 at 17:57





Look at the help page. Dissolve by country field and max statistic on sum shape.

– Hornbydd
Apr 1 at 17:57













Thanks. With Dissolve tool I was able only to get SUM_Shape value, but I need WPC as well.

– icelandico
Apr 1 at 18:00





Thanks. With Dissolve tool I was able only to get SUM_Shape value, but I need WPC as well.

– icelandico
Apr 1 at 18:00













To get corresponding WPC of max area, join dissolve layer to original layer on area, you can include any fields you want.

– klewis
Apr 1 at 18:08





To get corresponding WPC of max area, join dissolve layer to original layer on area, you can include any fields you want.

– klewis
Apr 1 at 18:08













Sort descending by area, remove duplicate by country. Also I suggest removing spatial analyst from tags.

– FelixIP
2 days ago






Sort descending by area, remove duplicate by country. Also I suggest removing spatial analyst from tags.

– FelixIP
2 days ago














Thanks, I'll check this solution.

– icelandico
2 days ago





Thanks, I'll check this solution.

– icelandico
2 days ago










0






active

oldest

votes












Your Answer








StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "79"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);













draft saved

draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f317398%2fretrieve-attribute-with-max-value-by-group%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown

























0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes















draft saved

draft discarded
















































Thanks for contributing an answer to Geographic Information Systems Stack Exchange!


  • Please be sure to answer the question. Provide details and share your research!

But avoid


  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f317398%2fretrieve-attribute-with-max-value-by-group%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

រឿង រ៉ូមេអូ និង ហ្ស៊ុយលីយេ សង្ខេបរឿង តួអង្គ បញ្ជីណែនាំ

Crop image to path created in TikZ? Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)Crop an inserted image?TikZ pictures does not appear in posterImage behind and beyond crop marks?Tikz picture as large as possible on A4 PageTransparency vs image compression dilemmaHow to crop background from image automatically?Image does not cropTikzexternal capturing crop marks when externalizing pgfplots?How to include image path that contains a dollar signCrop image with left size given

Romeo and Juliet ContentsCharactersSynopsisSourcesDate and textThemes and motifsCriticism and interpretationLegacyScene by sceneSee alsoNotes and referencesSourcesExternal linksNavigation menu"Consumer Price Index (estimate) 1800–"10.2307/28710160037-3222287101610.1093/res/II.5.31910.2307/45967845967810.2307/2869925286992510.1525/jams.1982.35.3.03a00050"Dada Masilo: South African dancer who breaks the rules"10.1093/res/os-XV.57.1610.2307/28680942868094"Sweet Sorrow: Mann-Korman's Romeo and Juliet Closes Sept. 5 at MN's Ordway"the original10.2307/45957745957710.1017/CCOL0521570476.009"Ram Leela box office collections hit massive Rs 100 crore, pulverises prediction"Archived"Broadway Revival of Romeo and Juliet, Starring Orlando Bloom and Condola Rashad, Will Close Dec. 8"Archived10.1075/jhp.7.1.04hon"Wherefore art thou, Romeo? To make us laugh at Navy Pier"the original10.1093/gmo/9781561592630.article.O006772"Ram-leela Review Roundup: Critics Hail Film as Best Adaptation of Romeo and Juliet"Archived10.2307/31946310047-77293194631"Romeo and Juliet get Twitter treatment""Juliet's Nurse by Lois Leveen""Romeo and Juliet: Orlando Bloom's Broadway Debut Released in Theaters for Valentine's Day"Archived"Romeo and Juliet Has No Balcony"10.1093/gmo/9781561592630.article.O00778110.2307/2867423286742310.1076/enst.82.2.115.959510.1080/00138380601042675"A plague o' both your houses: error in GCSE exam paper forces apology""Juliet of the Five O'Clock Shadow, and Other Wonders"10.2307/33912430027-4321339124310.2307/28487440038-7134284874410.2307/29123140149-661129123144728341M"Weekender Guide: Shakespeare on The Drive""balcony"UK public library membership"romeo"UK public library membership10.1017/CCOL9780521844291"Post-Zionist Critique on Israel and the Palestinians Part III: Popular Culture"10.2307/25379071533-86140377-919X2537907"Capulets and Montagues: UK exam board admit mixing names up in Romeo and Juliet paper"Istoria Novellamente Ritrovata di Due Nobili Amanti2027/mdp.390150822329610820-750X"GCSE exam error: Board accidentally rewrites Shakespeare"10.2307/29176390149-66112917639"Exam board apologises after error in English GCSE paper which confused characters in Shakespeare's Romeo and Juliet""From Mariotto and Ganozza to Romeo and Guilietta: Metamorphoses of a Renaissance Tale"10.2307/37323537323510.2307/2867455286745510.2307/28678912867891"10 Questions for Taylor Swift"10.2307/28680922868092"Haymarket Theatre""The Zeffirelli Way: Revealing Talk by Florentine Director""Michael Smuin: 1938-2007 / Prolific dance director had showy career"The Life and Art of Edwin BoothRomeo and JulietRomeo and JulietRomeo and JulietRomeo and JulietEasy Read Romeo and JulietRomeo and Julieteeecb12003684p(data)4099369-3n8211610759dbe00d-a9e2-41a3-b2c1-977dd692899302814385X313670221313670221