topic How do you fix error 999999 using Summarize Within? in ArcGIS Pro Questions

How do you fix error 999999 using Summarize Within?

BenKawecki — Thu, 05 Apr 2018 21:41:06 GMT

Hello,

I've been trying to use the Summarize Within script to calculate the number of points within a given number a shapes created using Generate Tessellation. Whenever I run Summarize within it gives me error 999999 (see picture below). I have been following the steps laid out in this article from learn.arcgis.com (Create supplementary charts and maps—Cartographic Creations in ArcGIS Pro | ArcGIS ). I was able to follow the article step by step and use Summarize Within with no problem. When I went to try this again using my own data in a fresh new project it didn't work. Currently my own data is in GCS WGS 1984. I have attempted to reduce my own data down to 1000 data points but its returns the same error. I have also tried to reduce the number of extra fields (fields that arn't lat/lon) to no success. I have the most up to date version of ArcGIS Pro and the error still occurs after I have rebooted. Below is step by step process I was using to get this error:

-Add data to project using add data (data is in .csv format)

-Use XY Table To Point to create a feature class containing the information from the csv file. (coordinate system GCS_WGS_1984)

-Use Generate Tessellation to create a set of bins over the extent of the feature class created in the last step.(Picture below)

-Use Summarize Within to measure the number of data points in each bin.(Picture below)

Please let me know if any of you have experienced this error before and know how to get around it.

Thanks,

Ben

Re: How do you fix error 999999 using Summarize Within?

DanPatterson_Retired — Thu, 05 Apr 2018 22:45:09 GMT

Longitude is X, latitude is Y, what do your points look like?

the points should be a featureclass in a geodatabase.

What is the warning beside your chosen units?

Re: How do you fix error 999999 using Summarize Within?

BenKawecki — Thu, 05 Apr 2018 22:54:00 GMT

All of the points are in the right spot. I have used this data set before, the full data set is roughly 1,000,000 points with lat/lon/alt.

The hexbin, data set, and output feature class are in the same geodatabase.

The warning is "converting areal units squaremiles to squareunkown no supported."

Re: How do you fix error 999999 using Summarize Within?

DanPatterson_Retired — Thu, 05 Apr 2018 23:22:39 GMT

Strange... if you have used the dataset before in this process and it worked, then something has changed.

That error message is too broad, anything from spaces in file paths, lack of memory and resources to whatever.

Try splitting the data set in half, both the hex-bins and the data (simple selection will do this) and see if half works. If that does, then it could be a memory thing, so Pro would be a next go

Re: How do you fix error 999999 using Summarize Within?

BenKawecki — Thu, 05 Apr 2018 23:27:40 GMT

Sorry, I didn't clarify that enough. I have used this data set before but not with summarize within. I have halved the data set and even taken 1/100th of the data set. It still gives the same error. When I go back into the project I created to follow the learn.arcgis.com link Summarize Within Still works fine. I'm currently running all of this in pro. I think my next step is to create a new project and try to import that data set again. See if that will fix it.

Re: How do you fix error 999999 using Summarize Within?

MervynLotter — Fri, 06 Apr 2018 08:08:38 GMT

Ben, an alternative workflow to provide the same desired output would be a spatial join. Right click on your empty hexbins feature class, go Joins and Relates/Spatial Join. Then your Join Features would be your data points. Join operation is one to one. The new output feature class will contain a field called called Join_Count with a count of the data points per polygon.