I'm new to ArcGIS Desktop. I have created a layer representing zip codes and overlayed it with a layer containing some data points. I want to find the min and max value of the data points in each zip code. Currently, I am manually checking the values if all the data points in each zip code but this is becoming very time-consuming and cumbersome.

Is there a faster way to do this?


You can do an INTERSECT of the data points with the Zip Code polygon layer - then with your result - do a SUMMARY STATISTICS with the Data point as your Statistics Field - Min and/or Max statistic type and your Zip Code as your Case Field.



Do a Select by Location -- selecting from = data points layer, source layer = zip codes layer, spatial relationship "within source layer."

Open the attribute table for the data points layer, right-click on the attribute column you're interested in and select Statistics. In the window that comes up, you'll see the min and max values (as well as other basic stats).

  • Hi! I tried to do the Select by Location, but my data points layer didn't show up in the Target Layer/selecting from layer.
    – V_N
    May 27 '14 at 17:46
  • @V_N Is your data points layers added to the map document you are working in? May 27 '14 at 18:09
  • 1
    @V_N I think you need to convert it to shapefile for it to display in the Select By Location tool. You can do this by right-clicking your layer and going to Data, then Export Data. May 27 '14 at 18:28
  • 1
    One more note - when you follow Erica's answer, make sure you select the zip code you are interested in before doing the "Select by Location" tool, so it only selects the points in that zip code. If I read her answer right, you'll need to do the zip codes one by one. Someone may be able to come up with an automated solution for you if you really have a lot to do. May 27 '14 at 18:48
  • 1
    @V_N While this solution does simplify the calculation portion of the problem by displaying the min/max of a group of selected points, it still relies on selecting and checking each zip code individually. The other answer is a faster solution where by combining your two datasets into one you can get all the desired values in a single table with a single command.
    – Chris W
    May 28 '14 at 20:05

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.