[FWTools] PGeo->Postgres on Ubuntu 9.04. Can virtualbox help?

[David Epstein]

Roald,


Thank you for explaining these details. After converting the PGeo file,
the shapefile dbf is over 2GB. This fails to load into postgres with
both shp2pgsql & ogr2ogr. With the former I get an fseek error & with
the latter:

ERROR 1: INSERT command for new feature failed.
ERROR:  new row for relation "parcel_esri_exp" violates check constraint
"enforce_geotype_wkb_geometry"

Do you know if this problem will exist regardless of the source format?
Do I need to divide the geometry, load, and then recombine in postGIS?
I'm certain 2GB is not the largest file people are working with--what do
people do to move between formats?


thank you,
-david



On Thu, 2010-07-22 at 13:05 +1000, Roald de Wit wrote:
> David,
> 
> Shapefiles also tend to lose date/time formats (they get turned into 
> strings). In order to overcome this issue and the column name length 
> one, I tend to convert to MapInfo files. You can load those files into 
> PostGIS with ogr2ogr just as easily as shapefiles.
> 
> Regards,
> 
> Roald