<p>My initial thought would be to look at ogr2ogr writing to a file based format like good old Shape.</p>
<p>You can specify the SQL to extract a subset of data using the -sql option in you're ogr2ogr command which when reading from Postgres simply passes the SQL to the database.</p>
<p><a href="http://www.gdal.org/ogr2ogr.html">http://www.gdal.org/ogr2ogr.html</a></p>
<p>Matt.</p>
<div class="gmail_quote">On 9 Feb 2011 17:38, "Tyler Mitchell (OSGeo)" <<a href="mailto:tmitchell@osgeo.org">tmitchell@osgeo.org</a>> wrote:<br type="attribution">> Year ago I was helping with the PgArc connector (<a href="http://sourceforge.net/projects/pgarc/">http://sourceforge.net/projects/pgarc/</a>) I doubt it still works, but in case you wanted to see an example of how it was done. Oh boy, waaaay back in 2003 for ArcMap 8.x :)<br>
> <br>> On 2011-02-09, at 8:44 AM, Addy Pope wrote:<br>> <br>>> Any suggestions on how to take a large (>4Gb) postgis table (gml) and get it into an ArcGIS readable format? Would/should be able to split the postgis table into smaller chunks. Want to avoid ArcSDE and other proprietary packages if possible, but output has to be in ArcGIS friendly flavour.<br>
>> <br>>> Any suggestions?<br>>> <br>>> Thanks<br>>> <br>>> Addy<br>>> <br>>> -- <br>>> The University of Edinburgh is a charitable body, registered in<br>>> Scotland, with registration number SC005336.<br>
>> <br>>> _______________________________________________<br>>> UK mailing list<br>>> <a href="mailto:UK@lists.osgeo.org">UK@lists.osgeo.org</a><br>>> <a href="http://lists.osgeo.org/mailman/listinfo/uk">http://lists.osgeo.org/mailman/listinfo/uk</a><br>
> <br>> <br>> Tyler Mitchell<br>> Executive Director, OSGeo<br>> <a href="mailto:tmitchell@osgeo.org">tmitchell@osgeo.org</a><br>> See you in Denver @ FOSS4G 2011!<br>> <a href="http://2011.foss4g.org">http://2011.foss4g.org</a><br>
> <br>> <br>> <br>> <br>> <br>> _______________________________________________<br>> UK mailing list<br>> <a href="mailto:UK@lists.osgeo.org">UK@lists.osgeo.org</a><br>> <a href="http://lists.osgeo.org/mailman/listinfo/uk">http://lists.osgeo.org/mailman/listinfo/uk</a><br>
</div>