Spatial join of 200 milions of points to poly feature

2392
3
Jump to solution
11-30-2015 08:43 AM
by Anonymous User
Not applicable

I'm trying to spatial join the average value of point data to the respective polygon... but the point are about 200 millions, but the process takes days to run. Any suggestions?

0 Kudos
1 Solution

Accepted Solutions
VinceAngelo
Esri Esteemed Contributor

Each query, no matter what source, has a fixed setup cost. Try joining the polygons to the points instead -- instead of 200M point in polygon queries you'll have N polygon contains point queries.  Either way, you'll have a possibility of point on polygon boundary (either two polys or none) as well as points not in any polygon.

If the points are spatially fragmented, the query time may still be significant.  You could address this by using Sort (Data Management) to organize the features with a spatial sorting order (requires Advanced license) or by sorting on an attribute which is spatially correlated (zip code, map book tile,...)

- V

View solution in original post

3 Replies
ChristianWells
Esri Regular Contributor

Hi Ivan,

Where is your data stored? File geodatabase, personal geodatabase, shapefile, SDE?

0 Kudos
by Anonymous User
Not applicable

In a file geodb

0 Kudos
VinceAngelo
Esri Esteemed Contributor

Each query, no matter what source, has a fixed setup cost. Try joining the polygons to the points instead -- instead of 200M point in polygon queries you'll have N polygon contains point queries.  Either way, you'll have a possibility of point on polygon boundary (either two polys or none) as well as points not in any polygon.

If the points are spatially fragmented, the query time may still be significant.  You could address this by using Sort (Data Management) to organize the features with a spatial sorting order (requires Advanced license) or by sorting on an attribute which is spatially correlated (zip code, map book tile,...)

- V