[OSGeo-UK] PostGIS to Arc Geodatabase

Adrià Mercader amercader.dev at gmail.com
Thu Feb 10 04:18:47 EST 2011


I'm with Matt in ogr2ogr, It has never let me down on huge datasets.
Apart from filtering by SQL, you can also clip areas of the original
dataset to get smaller shapefiles.


On 9 February 2011 18:00, Matt Walker <walkermatt at longwayaround.org.uk> wrote:
> My initial thought would be to look at ogr2ogr writing to a file based
> format like good old Shape.
>
> 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.
>
> http://www.gdal.org/ogr2ogr.html
>
> Matt.
>
> On 9 Feb 2011 17:38, "Tyler Mitchell (OSGeo)" <tmitchell at osgeo.org> wrote:
>> Year ago I was helping with the PgArc connector
>> (http://sourceforge.net/projects/pgarc/) 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 :)
>>
>> On 2011-02-09, at 8:44 AM, Addy Pope wrote:
>>
>>> 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.
>>>
>>> Any suggestions?
>>>
>>> Thanks
>>>
>>> Addy
>>>
>>> --
>>> The University of Edinburgh is a charitable body, registered in
>>> Scotland, with registration number SC005336.
>>>
>>> _______________________________________________
>>> UK mailing list
>>> UK at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/uk
>>
>>
>> Tyler Mitchell
>> Executive Director, OSGeo
>> tmitchell at osgeo.org
>> See you in Denver @ FOSS4G 2011!
>> http://2011.foss4g.org
>>
>>
>>
>>
>>
>> _______________________________________________
>> UK mailing list
>> UK at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/uk
>
> _______________________________________________
> UK mailing list
> UK at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/uk
>
>



-- 


Adrià Mercader
-----------------------------
http://amercader.net


More information about the UK mailing list