Hey guys,
So I have events that contain a lat / long. Here's an example of an event from the access log
/search?queryText=somesearch&lat=37.812889&lon=-122.432615
I have a lookup table with Zip Codes, population, and Lat Longs of the center of the zip code
Here's an example of a row in the csv that was uploaded
94109, 55984, 37.7955808980854, -122.422218643082
I'd like to do a geostats where I can aggregate number of events against Population. Aka "in this general blob we are seeing this many events per estimated population."
I'm not entirely sure where to start and if this is possible?
FYI, I'm going down the path of getting zip codes into those events to do a straight up lookup, but for now, I'd like to see what I can do.
... View more