Creatinng table with lat*long corresponding to the max value of continues variable

4499
5
04-19-2015 06:28 AM
BayarmagnaiMunkhjargal
New Contributor III

Hi all

Do you know how to import lat and long corresponding to the max value of the variable of my interest that I selected in "Summarize" function? Summarize function creates nice max rainfall values by each counties but no geographic coordinates. I am interested in mapping the maximum rainfall values only.

Thanks bunch

0 Kudos
5 Replies
DanPatterson_Retired
MVP Emeritus

Are the longitude/latitude values in the same table?  If they are point data, just use the Calculate Geometry option from within the table to get these values and use them as another inclusion in the Summarize procedure

0 Kudos
BayarmagnaiMunkhjargal
New Contributor III

Yes, log/lat values are in the same table. This is NOAA rainfall daily observed values at certain locations as provided with lat*long coordinates. I am only interested in max rainfall inches a given day thus used summarize function to create a table with the maximum rainfall value by each county. However, when I select lat/long in the step 2 of summarize function, for instance, I am prompted to select min, max, average, sum. std or variance from dropdown menu. No option to keep lay/long as they are.

Is there something I am missing?

0 Kudos
BayarmagnaiMunkhjargal
New Contributor III

summarize.png

0 Kudos
DanPatterson_Retired
MVP Emeritus

experiment...try min and then max or both...if they yield the same results then there is no difference... report back as to what you found

0 Kudos
BayarmagnaiMunkhjargal
New Contributor III

I figured out. I joined summarize output table with max rainfall by each counties to Census counties. Now I have my max rainfall values as attributed to polygons of counties in census. joined with census.png

0 Kudos