yunkex

How to export the 40 million records in a SDC file into shapefile?

Discussion created by yunkex on Jul 16, 2013
Latest reply on Jul 17, 2013 by yunkex
Dear All,
I am working on a project where I need to process in postGIS.
In order to do so, I need shapefile as input.
However, what I have at hand are SDC files. So I need to transform the SDC file into shapefiles in order to put the results in postGIS.

But the problem is, the dataset contains 40 million records which is too big to be "save as shapefile" in one time.
What I am doing now is to divide the records in some logical ways (such as select be the STATES) and then once I have the selection, I will create a layer from the selection and then export it into shapefile.

To process 1/50 of the whole dataset takes me 50minutes to select, and another an hour or so to export.
Which is too tedious.

Does anyone know any other approach that can speed up this process?
Will model builder help at all? (I am looking for automatically way of select and export so that I can leave my computer running over night.)
Thanks.

Best

Outcomes