I have a large database of point data throughout all of Eastern Australia. Each point represents species presence/absence data and has attached about 18 predictor variables. To account for sampling intensity, I would like to make a 1km x 1km grid and count the frequency of the number of presence records (this would be my response variable) and create another column in the data frame that is the sum of all points within the cell (this would become an offset variable in a GLMM).

What is the best approach to this problem? I know of the Point to Raster tool, however I dont think it allows for keeping the other predictor variables. Aggregate Points is another option, however I am using ArcGIS 10.3 and I dont have access to the ArcGIS GeoAnalytics Server.

  • 3
    Create a fishnet (1k x 1k) covering your area of interest and then overlay your fishnet over your points (spatial join) then you can use summary statistics with your polygon ID as a case field to find statistics per grid cell. – Michael Stimson Jul 25 '18 at 0:22
  • 1
    You are referencing the documentation of two ArcGIS Pro tools but appear to be using ArcGIS Desktop 10.3. Both tools exist in ArcGIS Desktop 10.3 but Aggregate Points in that architecture has less functionality. – PolyGeo Jul 25 '18 at 1:34

Your Answer

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

Browse other questions tagged or ask your own question.