generate near table woes

522
3
08-02-2011 09:05 AM
KarenGreen
New Contributor
Recently I discovered this tool and love it.  I have used it many times.  Last week, it stopped working.

I have 2 files with almost a million points.
I run the Generate Near Table and I am hoping to identify all the points within a given distance.

Previously when I have done this, my files were about the same size, may be a bit bigger this time.
The table I created was a simple .dbf

But as of last week when I run it, the .dbf gets to just over 2gb and then just hangs.
So I changed the output to be a file geodatabase to avoid the file size limitations.
I reran the job.  I had 20gbs of space on they hard drive and it filled it completely.
So then I deleted a bunch of stuff and cleared up almost 100gb.
I reran the job several times and each time it fills up the hard drive.

There is not that much data to do this.
Anyone have any ideas what could be happening.

I am using 9.3.1.
I also upgraded to patch 2 today and tried it again but got the same results.

I have made my file size smaller and still I can not get it to run.

Any ideas?????????????
I love this tool, but it just does not want to work.

Thanks in advance.
Just Me
0 Kudos
3 Replies
NobbirAhmed
Esri Regular Contributor
Could you please provide me more details, such as:

Feature type of Input Features (point, line or poly?)
Feature type of Near Features (point, line or poly?)
Spatial Reference of the data
Search Radius
Find only closest feature - checked?
Max number of closest feature - default? (that is find all)
0 Kudos
KarenGreen
New Contributor
Could you please provide me more details, such as:

Feature type of Input Features (point, line or poly?)
Feature type of Near Features (point, line or poly?)
Spatial Reference of the data
Search Radius
Find only closest feature - checked?
Max number of closest feature - default? (that is find all)


Point to Point
Nad83_utm14
5800 Meters is the radius
Searching for ALL

There are 300,000 points in each file,
But it should only find like 50,000 matches

Thanks
Just Me
0 Kudos
NobbirAhmed
Esri Regular Contributor
Ok, I ran the tool with two point feature classes - each having half million points. It took hours to finish but didn't fill up the hard drive. The final size of the output gdb was 32 MB.

I have used 9.3.1 sp1 whereas you used 9.3.1 (final?).

What's the configuration of your machine? OS? RAM? HD?
My configuration is: XP sp3, 4 GB or RAM and 120 GB of HD.
0 Kudos