[OSGeo-UK] PostGIS to Arc Geodatabase

razmjooeis at faunalia.co.uk razmjooeis at faunalia.co.uk
Wed Feb 9 12:27:50 EST 2011


One way...(maybe not the quickest and cleanest way) is to do it in GRASS:

1- Create a grid of tiles as a shapefile
2- Fill in the attribute to represent the tile name (tile 1, tile 2)
3- Create several shapefiles from the tiles
4- Import the tiles in GRASS using v.in.ogr
5- Now, you need to set the region to match each tile and import the
postgis layer, it will ignore the data outside tileX
          g.region vect=tileX
          v.in.ogr -r dsn="PG:host=localhost dbname=postgis user=postgres"
layer=layername output=tileX_coverage
type=boundary,centroid,area etc
          v.out.ogr to shapefile


This can be looped nicely in a bash or python script.

Hope that helps
Saber






> 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
>




More information about the UK mailing list