AnsweredAssumed Answered

Trouble interpolating 7M points

Question asked by sjacksonesriaustralia-com-au-esridist Employee on Jun 9, 2017
Latest reply on Jun 11, 2017 by xander_bakker

I have a layer with over 7 million records.  This is in a fine mesh grid (output from a 3rd party modelling package.

The source data is a simple table in SQL Server containing a geometry column (4326).

 

I need to interpolate this using either Natural Neighbour or IDW using a variable in the dataset.

I have used a smaller area and have been happy with the results I have been getting.

 

I have replicated the below in ArcGIS Pro 1.4 and 2.0 beta and also in ArcMap 10.5.

I have 16GB RAM and a decent CPU and a dedicated GPU.

 

 

Using Spatial Analyst IDW

 

Using the Query Layer

Completes ~5 minutes

Result is an empty raster with no data.

 

Using Enterprise GeoDatabase

Completes ~2 minutes

Result is an empty raster with no data.


 

File GeoDatabase

Completes ~2 minutes

Result is an empty raster with no data.

 

Using Spatial Analyst Natural Neighbour

Query Layer ~5 minutes = Empty Raster

File Geodatabase 38 seconds = Empty Raster

 

I also have Geostatistical Analyst, and did see it had some options for parallel processing, but I also spotted that IDW does not have a search distance which I need.

 

Can anyone give me some pointers on how to interpolate this dataset?  

Outcomes