2

I have a city map with digital boundaries. Each polygon has some numbers between 1 to 7. For example one of the polygon has 4,4,6,1,4,7,3,4,5,4,2 (the mode is 4 for this polygon). I wonder is there a way in Arcmap to find mode value for each polygon and make it colored by these number's value. (i.e. 1-yellow, 2- red, 3-green, etc..)?

Example

  • 2
    How are these numbers stored? As a single text field or as 12 numeric fields of as 12 polygons each with a single number? – Hornbydd Sep 11 '17 at 19:24
  • 2
    I can't access the image, blocked by a web filter. Can you not post it using the StackExchange image hosting? – HeikkiVesanto Sep 12 '17 at 8:18
  • 1
    I too cannot view the image it just takes you to a website full of crap/adverts. Edit your question and upload the image directly into stack exchange. It is unclear what you are describing. Are you saying that for example a polygon has 25 points intersecting it and these points have ID numbers ranging from 1 to 7 and it is the mode of these you want to extract? – Hornbydd Sep 12 '17 at 8:44
  • 1
    Please don't use a different website just use the Picture button that SE provides. – PolyGeo Sep 12 '17 at 9:16
  • 1
    I have edited your question and inserted the image you link to. As requested do not link to images on those sites, SE can host it. It means if others come looking for the same answer they can see what you are talking about. Those picture sites can expire images uploaded to them so your link breaks. I can answer this question but it requires re-opening. – Hornbydd Sep 12 '17 at 13:27
2

This problem can be solved with the Spatial Join tool and setting the appropriate field mapping merge rule.

Below is a screen shot of the tool set up as it should be to return the MODE number.

Spatial Join tool

As you can see you can return up to 11 statistics, mode being one of them.

So the logic is for each polygon, test for intersections with the join features (your points) and return the mode value and write that out to a new field (in my case called ID). The output is a copy of your polygon data with all the input fields, an intersection count and the chosen statistic (mode in this case).

  • No thanks required, if my answer is a solution to the problem you should tick it as such, this allows other users to know that your question got an answer which solved the problem. You tick it as solved under the vote up/down buttons. – Hornbydd Sep 13 '17 at 12:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.