[FWTools] PGeo->Postgres on Ubuntu 9.04. Can virtualbox help?
David Epstein
davideps at umich.edu
Wed Jul 21 22:33:28 EST 2010
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
More information about the FWTools
mailing list