I use the near function in ArcInfo and try to calculate the distance from residential single family to the nearest transportation links (highway, tollway, light rail and freight line) but failed.
Actually I want to examine the relationship between the change of appraised housing value and the distance to each type of roads by using regression. Firstly I used the quarter mile buffer to classify every property into 5 group: within 1/4 mile from each type of roads, 1/4 - 1/2 mile, 1/2 - 3/4 mile , 1 mile and outside of 1 mile and created dummy variable 1-5 to define them. But when I run regression the result is not signifcant. So now I try to calculate the actual distance, and the idea is that if I get the distance for every parcels, the error for regression will minimized.
The problem is that I cannot apply near function to calculate the distance. I try directly calculate the distance from property which is polygon to road (line). I also use feature to point function to convert all polygons to points and then calcuate the distance between property (point) to road (line). Both way failed with the error code "ERROR 999999: Error executing function.
Failed to execute (Near)." My study area is three counties in Texas so the sample size is around 200,000 to 300,000 properties for each one. I assume the problem may be the sample size is too large to execute the near function or the near function could only calculate the distance to one apointted road but cannot get the nearest distance to many roads? If so, is there any alternative way to achieve my hypotheis metioned above? If someone could help me to figure it out, I will really appreciate it.
