[postgis-users] raster2pgsql is not creating a raster table in postgis

[Pierre Racine]

Try 

SELECT (ST_Metadata(rast)).* FROM chp1.tmax1 LIMIT 1;

instead. It's more verbose. Your raster is there. Don't worry.

Pierre
________________________________________
From: postgis-users-bounces at lists.osgeo.org [postgis-users-bounces at lists.osgeo.org] On Behalf Of garret [garretlewis at gmail.com]
Sent: Sunday, January 04, 2015 11:04 PM
To: postgis-users at lists.osgeo.org
Subject: Re: [postgis-users] raster2pgsql is not creating a raster table in     postgis

Hi Borie,

Thank you for you quick response, especially on a New Years Eve.

I took a look at the meta data,

Here is what I get:

    SELECT ST_Metadata(rast) FROM chp1.tmax1 LIMIT 1;
    "(-180,90,100,100,0.166666666666667,-0.166666666666667,0,0,4326,1)"


    SELECT ST_BandMetadata(rast, 1) FROM chp1.tmax1 LIMIT 1;
    "(16BSI,-9999,f,)"

Since this is my first time using rasters in postgis, I dont know if this is
typical output or not.

fyi, here is the gdalinfo output from the original file:

Files: tmax1.bil
       tmax1.hdr
Size is 2160, 900
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.000000000000057,90.000000000000000)
Pixel Size = (0.166666666666667,-0.166666666666667)
Corner Coordinates:
Upper Left  (-180.0000000,  90.0000000) (180d 0' 0.00"W, 90d 0' 0.00"N)
Lower Left  (-180.0000000, -60.0000000) (180d 0' 0.00"W, 60d 0' 0.00"S)
Upper Right ( 180.0000000,  90.0000000) (180d 0' 0.00"E, 90d 0' 0.00"N)
Lower Right ( 180.0000000, -60.0000000) (180d 0' 0.00"E, 60d 0' 0.00"S)
Center      (   0.0000000,  15.0000000) (  0d 0' 0.00"E, 15d 0' 0.00"N)
Band 1 Block=2160x1 Type=Int16, ColorInterp=Undefined
  Min=-478.000 Max=418.000
  NoData Value=-9999

the statement; SELECT * FROM raster_columns;
comes out a little odd, but again Im not sure what to expect. The output is
long but I can post a summary of it if you think it would be helpful.

So Im not sure where to go from here. Any recommendations?

Thank you,
Garret



--
View this message in context: http://postgis.17.x6.nabble.com/raster2pgsql-is-not-creating-a-raster-table-in-postgis-tp5007520p5007525.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users