I have a large 1.1gb CSV table of points in Lat/Long WGS84 for which I'd like to generate a point density raster. I'm taking the following steps but the process is extremely slow. I welcome any advice on how to improve this or better understand where exactly my bottlenecks are.
In ModelBuilder I have the following steps
- XY Table to Points - output to in_memory workspace;
- Project - reproject in_memory output from LatLong WGS84 to WGS84 Web Mercator (Auxiliary Sphere) - here I'm unable to store the output in_memory (not sure why) so I write it to the gdb;
- Point Density - calculate my point density raster from the output of 2.
I'm running on Windows Server 2019 with Intel Xeon Platinum 8175M CPU @2.5GHz (2 processors), 760GB RAM, 64-bit OS which I've spun up an AWS instance with 500GB hard disk.
Currently my ModelBuilder is on step 1 at 1% and it has been there for a while. My CPU usage is at 1% and Memory also at 1%
How can I speed up my process?