[postgis-users] raster2pgsql loader error

[Andreas Forø Tollefsen]

Hi Mateusz,

Thanks for your advice. I tested both files using GDAL Info, and both works
fine and shows up with the correct information.
What i dont understand is why some of my rasters will not load when they
loaded without a hitch using the python script.

Output from gdal_info:
Driver: AIG/Arc/Info Binary Grid
Files: c:\prio_grid\source\gpw\lrc30p90\glp90ag30
       c:\prio_grid\source\gpw\lrc30p90\glp90ag30.aux
       c:\prio_grid\source\gpw\lrc30p90\glp90ag30\dblbnd.adf
       c:\prio_grid\source\gpw\lrc30p90\glp90ag30\gpw90.dbf
       c:\prio_grid\source\gpw\lrc30p90\glp90ag30\gpw90.prj
       c:\prio_grid\source\gpw\lrc30p90\glp90ag30\gpw90.shp
       c:\prio_grid\source\gpw\lrc30p90\glp90ag30\gpw90.shx
       c:\prio_grid\source\gpw\lrc30p90\glp90ag30\hdr.adf
       c:\prio_grid\source\gpw\lrc30p90\glp90ag30\log
       c:\prio_grid\source\gpw\lrc30p90\glp90ag30\prj.adf
       c:\prio_grid\source\gpw\lrc30p90\glp90ag30\sta.adf
       c:\prio_grid\source\gpw\lrc30p90\glp90ag30\w001001.adf
       c:\prio_grid\source\gpw\lrc30p90\glp90ag30\w001001x.adf
Size is 720, 286
Coordinate System is:
GEOGCS["WGS 84",
    DATUM["WGS_1984",
        SPHEROID["WGS 84",6378137,298.257223563,
            AUTHORITY["EPSG","7030"]],
        TOWGS84[0,0,0,0,0,0,0],
        AUTHORITY["EPSG","6326"]],
    PRIMEM["Greenwich",0,
        AUTHORITY["EPSG","8901"]],
    UNIT["degree",0.0174532925199433,
        AUTHORITY["EPSG","9108"]],
    AUTHORITY["EPSG","4326"]]
Origin = (-180.000000000000000,85.000000000114397)
Pixel Size = (0.500000000000400,-0.500000000000400)
Corner Coordinates:
Upper Left  (-180.0000000,  85.0000000)
Lower Left  (-180.0000000, -58.0000000)
Upper Right ( 180.0000000,  85.0000000)
Lower Right ( 180.0000000, -58.0000000)
Center      (   0.0000000,  13.5000000)
Band 1 Block=360x4 Type=Float32, ColorInterp=Undefined
  Min=0.000 Max=16172424.000
  NoData Value=-3.4028234663852886e+038
  Metadata:
    LAYER_TYPE=athematic


Driver: AIG/Arc/Info Binary Grid
Files: c:\prio_grid\source\Access\access_50k\acc_50k
       c:\prio_grid\source\Access\access_50k\acc_50k.aux
       c:\prio_grid\source\Access\access_50k\acc_50k.rrd
       c:\prio_grid\source\Access\access_50k\acc_50k.aux.xml
       c:\prio_grid\source\Access\access_50k\acc_50k\dblbnd.adf
       c:\prio_grid\source\Access\access_50k\acc_50k\hdr.adf
       c:\prio_grid\source\Access\access_50k\acc_50k\log
       c:\prio_grid\source\Access\access_50k\acc_50k\metadata.xml
       c:\prio_grid\source\Access\access_50k\acc_50k\prj.adf
       c:\prio_grid\source\Access\access_50k\acc_50k\sta.adf
       c:\prio_grid\source\Access\access_50k\acc_50k\vat.adf
       c:\prio_grid\source\Access\access_50k\acc_50k\w001001.adf
       c:\prio_grid\source\Access\access_50k\acc_50k\w001001x.adf
Size is 43200, 21600
Coordinate System is:
GEOGCS["WGS 84",
    DATUM["WGS_1984",
        SPHEROID["WGS 84",6378137,298.257223563,
            AUTHORITY["EPSG","7030"]],
        TOWGS84[0,0,0,0,0,0,0],
        AUTHORITY["EPSG","6326"]],
    PRIMEM["Greenwich",0,
        AUTHORITY["EPSG","8901"]],
    UNIT["degree",0.0174532925199433,
        AUTHORITY["EPSG","9108"]],
    AUTHORITY["EPSG","4326"]]
Origin = (-180.000000000000000,89.999999999280021)
Pixel Size = (0.008333333333300,-0.008333333333300)
Corner Coordinates:
Upper Left  (-180.0000000,  90.0000000)
Lower Left  (-180.0000000, -90.0000000)
Upper Right ( 180.0000000,  90.0000000)
Lower Right ( 180.0000000, -90.0000000)
Center      (  -0.0000000,  -0.0000000)
Band 1 Block=256x4 Type=Int32, ColorInterp=Undefined
  Min=0.000 Max=108536.000
  Minimum=0.000, Maximum=108536.000, Mean=1543.449, StdDev=2736.378
  NoData Value=-2147483647
  Overviews: 10800x5400, 5400x2700, 2700x1350, 1350x675, 675x338, 338x169,
169x8
5, 85x43
  Metadata:
    LAYER_TYPE=athematic
    STATISTICS_MINIMUM=0
    STATISTICS_MAXIMUM=108536
    STATISTICS_MEAN=1543.4487145611
    STATISTICS_STDDEV=2736.3775076303

2012/2/2 Mateusz Loskot <mateusz at loskot.net>

> Check your data files with gdalinfo (http://gdal.org).
> The loader relies on GDAL, so if GDAL can't open, the loader will fail too.
>
> Mateusz Loskot
> (Sent from my mobile, so apology for top-posting or no quoting)
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120202/875f1d9e/attachment.html>