topic Re: Extract some data from a shape file in ArcGIS Enterprise Portal Questions https://community.esri.com/t5/arcgis-enterprise-portal-questions/extract-some-data-from-a-shape-file/m-p/201198#M2652 <HTML><HEAD></HEAD><BODY><SPAN>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.</SPAN></BODY></HTML> Wed, 09 Jan 2013 15:24:44 GMT LucasDanzinger 2013-01-09T15:24:44Z Extract some data from a shape file https://community.esri.com/t5/arcgis-enterprise-portal-questions/extract-some-data-from-a-shape-file/m-p/201196#M2650 <HTML><HEAD></HEAD><BODY><SPAN>Sorry it's such a basic problem.</SPAN><BR /><BR /><SPAN>I've a shape file with around 15million rows and around 20 columns.</SPAN><BR /><SPAN>I want to extract a subset (50k rows) of this data based on geographic location. (i.e if it occures inside a predifined area).</SPAN><BR /><SPAN>Every method I try ArcGIS closes down. (I've 10.1 on win 7 and 9.3 on XP).</SPAN><BR /><SPAN>Could some kind soul advise me the best way to proceed?</SPAN><BR /><BR /><SPAN>TIA</SPAN></BODY></HTML> Wed, 09 Jan 2013 14:05:24 GMT https://community.esri.com/t5/arcgis-enterprise-portal-questions/extract-some-data-from-a-shape-file/m-p/201196#M2650 DavidOrchard 2013-01-09T14:05:24Z Re: Extract some data from a shape file https://community.esri.com/t5/arcgis-enterprise-portal-questions/extract-some-data-from-a-shape-file/m-p/201197#M2651 <HTML><HEAD></HEAD><BODY><SPAN>What methods have you tried?</SPAN><BR /><SPAN>How large in the shape file, and would exporting it to a FGDB first help?</SPAN></BODY></HTML> Wed, 09 Jan 2013 14:55:26 GMT https://community.esri.com/t5/arcgis-enterprise-portal-questions/extract-some-data-from-a-shape-file/m-p/201197#M2651 michaelcollins1 2013-01-09T14:55:26Z Re: Extract some data from a shape file https://community.esri.com/t5/arcgis-enterprise-portal-questions/extract-some-data-from-a-shape-file/m-p/201198#M2652 <HTML><HEAD></HEAD><BODY><SPAN>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.</SPAN></BODY></HTML> Wed, 09 Jan 2013 15:24:44 GMT https://community.esri.com/t5/arcgis-enterprise-portal-questions/extract-some-data-from-a-shape-file/m-p/201198#M2652 LucasDanzinger 2013-01-09T15:24:44Z