I am not sure how to deal with sdc file.
Can I export into file geodatabase?
I think the bottleneck I have is about transforming the sdc file at the moment.
What program do you intend to use as a postGIS program to work with the date.
A shapefile may or may not be necessary.
I believe it would go faster if you import to a personal or file geodatabase first.
Also, when you are selecting and exporting pause the drawing.
The length of time required is a direct relation to size of the data file and the power of your computer.
close all programs on your computer and ONLY have the program you need running.
I would personally try to use the Split tool - use the 40 million as the input and your states polygon as the split feature. From memory, this outputs a new feature class (or shapefile) for each split field (in your case the state name). I think this is an ArcInfo level tool though. You can then use each shapefile import into PostGIS.
Alternatively I would use python to iterate through each state feature, select all those that intersect and then write the output to a shapefile.
The idea of using python to iterate is really intrigueing. But what would the code look like?
Currently I am manually paste into the python window the code of arcpy.selectionmanagement...and then use arcpy to export the states, but I haven't try a loop or anything that I can use to get the data.
Would you like to give me a sense what the code will be like?
import arcpy fc = r"C:\temp.gdb\states" with arcpy.da.SearchCursor(fc, "State") as cursor: for row in cursor: # your code here
Maybe take your logic to do the selection, and export that you've used in the python window and put it into a search cursor. For example the following would iterate through each state in a feature class:import arcpy fc = r"C:\temp.gdb\states" with arcpy.da.SearchCursor(fc, "State") as cursor: for row in cursor: # your code here
See http://resources.arcgis.com/en/help/main/10.1/index.html#//018w00000011000000 for more information on the search cursor.