You should try using the precision=no layer creation option. With the default of YES, it tries to set the precision on columns based on the first 50 values. Often you have data that can exceed that. You could either precreate the table with correct field definitions and then append, or set precision equals NO and try the load.
Michael Smith US Army Corps > On Jun 23, 2020, at 7:49 PM, Thiemo Kellner <thi...@gelassene-pferde.biz> > wrote: > > Hi all > > Eli, you are quite right. Typo of mine. > > thiemo @ thiemos-toshi /mnt/schweden % ogr2ogr test.shp SCID_v4.0.gdb > HBVSv_intrans_HQloc100_rcp85_ensembleMean_diffPerc 2>/dev/null > > Does work with me too, sort of. As you can see, I suppressed error output. > Without it, I get flooded with warnings: > > Warning 1: Value 524332509.438000023 of field AREA of feature 4961 not > successfully written. Possibly due to too larger number with respect to field > width > More than 1000 errors or warnings have been reported. No more will be > reported from now. > > It puzzles me, however, that if I explicitly give the output format, it fails > miserably. > > thiemo @ thiemos-toshi /mnt/schweden % ogr2ogr –f "ESRI Shapefile" test.shp > SCID_v4.0.gdb HBVSv_intrans_HQloc100_rcp85_ensembleMean_diffPerc > FAILURE: > Unable to open datasource `ESRI Shapefile' with the following drivers. > -> `PCIDSK' > > Jeff, suggested, I tried to load into a new empty database with. > > thiemo @ thiemos-toshi /mnt/schweden % ogr2ogr -overwrite –progress --config > PG_USE_COPY YES PG:"host='/var/run/postgresql' port='6543' > dbname='sverige_gdb' user='sverige'" SCID_v4.0.gdb > HBVSv_intrans_HQloc100_rcp45_ensembleMean_diffPerc > ERROR 1: Couldn't fetch requested layer 'SCID_v4.0.gdb'! > > But still, I get errors. > > Got it! Thomas, you are a genius! You are right with your dash assumption. > Whatever I copied from the documentation pdf was not a dash! It loads into > non-empty database (as was to be expected). > > Thanks folks, for helping! It loads > > Kind regards > > Thiemo > > > > Quoting Eli Adam <ea...@co.lincoln.or.us>: > >>> On Tue, Jun 23, 2020 at 1:40 PM Thiemo Kellner >>> <thi...@gelassene-pferde.biz> wrote: >>> >>> >>> thiemo @ thiemos-toshi /mnt/schweden :-( % ogr2ogr –f "ESRI Shapefile" >>> test.shp SCID_v4.0.gdb/gdb.shp SCID_v4.0.gdb >>> HBVSv_intrans_HQloc100_rcp85_ensembleMean_diffPerc >>> FAILURE: >>> Unable to open datasource `ESRI Shapefile' with the following drivers. >>> -> `PCIDSK' >> >> I think that ogr2ogr destination and source datasets is like this: >> dst_datasource_name src_datasource_name >> >> Can you try this: ogr2ogr test.shp SCID_v4.0.gdb >> HBVSv_intrans_HQloc100_rcp85_ensembleMean_diffPerc >> >> If that works, build from there. >> >> HTH, Eli > > > -- > S/MIME Public Key: https://oc.gelassene-pferde.biz/index.php/s/eJuAUFONag6ofnH > Signal (Safer than WhatsApp): +49 1578 7723737 > Handys: +41 78 947 36 21 | +49 1578 772 37 37 > _______________________________________________ > gdal-dev mailing list > gdal-dev@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/gdal-dev _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev
