Extract some data from a shape file

624
2
01-09-2013 06:05 AM
DavidOrchard
New Contributor
Sorry it's such a basic problem.

I've a shape file with around 15million rows and around 20 columns.
I want to extract a subset (50k rows) of this data based on geographic location. (i.e if it occures inside a predifined area).
Every method I try ArcGIS closes down. (I've 10.1 on win 7 and 9.3 on XP).
Could some kind soul advise me the best way to proceed?

TIA
Tags (2)
0 Kudos
2 Replies
michaelcollins1
Occasional Contributor III
What methods have you tried?
How large in the shape file, and would exporting it to a FGDB first help?
0 Kudos
LucasDanzinger
Esri Frequent Contributor
If every method does not work (Select by location, Clip, Intersect, etc), You might have to first break the 15 million record shapefile into 2, 3, or 4 separate shapefiles. Then, do a Select by Location and once you have the subsets selected by location, you can append the outputs all back together using the Append GP tool.
0 Kudos