Splitting large point data layer problem!!!

[BineshMaharjan1]

Hi Folks,
I am trying to clip a point data layer by another polygon file. This point file is pretty large (millions of points - address points in the US). Every time i try using clip or select, it either freezes with "Not responding" or takes forever (~14 hrs with no results). I am trying to use Dice tool, but I am not sure if I can use Dice tool on point feature. If so, what am i supposed to put on "vertex limit"? BTW, the data is on SDE server. I also tried exporting it to the local drive, but with no success. Any help will be greatly appreciated.

Thanks,
Binesh

[curtvprice]

Hi Folks,
I am trying to clip a point data layer by another polygon file. This point file is pretty large (millions of points - address points in the US). Every time i try using clip or select, it either freezes with "Not responding" or takes forever (~14 hrs with no results). I am trying to use Dice tool, but I am not sure if I can use Dice tool on point feature. If so, what am i supposed to put on "vertex limit"? BTW, the data is on SDE server. I also tried exporting it to the local drive, but with no success. Any help will be greatly appreciated.

Thanks,
Binesh

Have you tried select by location? That may perform better than doing a full topological clip.

If the online help isn't providing enough background for you, Dale Honeycutt posted a very helpful blog post on the topic.


'>Dicing Godzillas (features with too many vertices)

(moved to Geoprocessing forum)

[TOMKONG · Accepted solution]

Hi Folks,
I am trying to clip a point data layer by another polygon file. This point file is pretty large (millions of points - address points in the US). Every time i try using clip or select, it either freezes with "Not responding" or takes forever (~14 hrs with no results). I am trying to use Dice tool, but I am not sure if I can use Dice tool on point feature. If so, what am i supposed to put on "vertex limit"? BTW, the data is on SDE server. I also tried exporting it to the local drive, but with no success. Any help will be greatly appreciated.

Thanks,
Binesh

Your source data is in the SDE, so you couldn't select too many features due to the table space issue.
You can ask the Database Adm to increase your table space to do this, or you can export your SDE source data to your local drive first, then to do data clip.

[BineshMaharjan1]

Your source data is in the SDE, so you couldn't select too many features due to the table space issue.
You can ask the Database Adm to increase your table space to do this, or you can export your SDE source data to your local drive first, then to do data clip.

Thanks so much TKONG. 🙂 That is what causing the problem.