What if you do this instead? SELECT rid, Box2D(rast::geometry) As rastbox FROM dummy_rast;
> -----Original Message----- > From: [email protected] [mailto:postgis-users- > [email protected]] On Behalf Of uyen dang > Sent: Sunday, October 09, 2011 7:31 AM > To: [email protected] > Subject: [postgis-users] NOTICE: compute_serialized_box3d called on unknown > type 0 > > Hello, > > > I'm a new postgis-user and i have a postgis raster project for a moment. I > installed postgres-8.4, postgis-2.0, gdal driver, geos-3.2, proj-4.6 in > ubuntu. But > when i use the raster table of dummy rasters formed from the site : > http://postgis.refractions.net/documentation/manual-svn/RT_reference.html > <http://postgis.refractions.net/documentation/manual-svn/RT_reference.html> > > > CREATE TABLE dummy_rast(rid integer, rast raster); > INSERT INTO dummy_rast(rid, rast) > VALUES (1, > ('01' -- little endian (uint8 ndr) > || > '0000' -- version (uint16 0) > || > '0000' -- nBands (uint16 0) > || > '0000000000000040' -- scaleX (float64 2) > || > '0000000000000840' -- scaleY (float64 3) > || > '000000000000E03F' -- ipX (float64 0.5) > || > '000000000000E03F' -- ipY (float64 0.5) > || > '0000000000000000' -- skewX (float64 0) > || > > - Ignored: > '0000000000000000' -- skewY (float64 0) > || > '00000000' -- SRID (int32 0) > || > '0A00' -- width (uint16 10) > || > '1400' -- height (uint16 20) > )::raster > ), > -- Raster: 5 x 5 pixels, 3 bands, PT_8BUI pixel type, NODATA = 0 > (2, ('01000003009A9999999999A93F9A9999999999A9BF000000E02B274A' || > > '41000000007719564100000000000000000000000000000000FFFFFFFF0500050 > 00400FDFEFDFEFEFDFEFEFDF9FAFEF' || > > 'EFCF9FBFDFEFEFDFCFAFEFEFE04004E627AADD16076B4F9FE6370A9F5FE59637 > AB0E54F58617087040046566487A1506CA2E3FA5A6CAFFBFE4D566DA4CB3E454 > C5665')::raster); > > and then i run this command : > > SELECT rid, Box2D(rast) As rastbox > FROM dummy_rast; > > i get NOTICE and no result : > > NOTICE: compute_serialized_box3d called on unknown type 0 > NOTICE: compute_serialized_box3d called on unknown type 0 > rid | rastbox > -----+--------- > 1 | > 2 | > (2 rows) > > Can you help me to find out what's going wrong here ? > > Thanks in advance, > Dang Uyen. > > - Done. > > > Hello, > I'm a new postgis-user and i have a postgis raster project for a moment. I > installed postgres-8.4, postgis-2.0, gdal driver, geos-3.2, proj-4.6 in > ubuntu. But > when i use the raster table of dummy rasters formed from the site : > > http://postgis.refractions.net/documentation/manual-svn/RT_reference.html > > > CREATE TABLE dummy_rast(rid integer, rast raster); INSERT INTO > dummy_rast(rid, rast) VALUES (1, ('01' -- little endian (uint8 ndr) > || > '0000' -- version (uint16 0) > || > '0000' -- nBands (uint16 0) > || > '0000000000000040' -- scaleX (float64 2) > || > '0000000000000840' -- scaleY (float64 3) > || > '000000000000E03F' -- ipX (float64 0.5) > || > '000000000000E03F' -- ipY (float64 0.5) > || > '0000000000000000' -- skewX (float64 0) > || > '0000000000000000' -- skewY (float64 0) > || > '00000000' -- SRID (int32 0) > || > '0A00' -- width (uint16 10) > || > '1400' -- height (uint16 20) > )::raster > ), > -- Raster: 5 x 5 pixels, 3 bands, PT_8BUI pixel type, NODATA = 0 (2, > ('01000003009A9999999999A93F9A9999999999A9BF000000E02B274A' || > '41000000007719564100000000000000000000000000000000FFFFFFFF0500050 > 00400FDFEFDFEFEFDFEFEFDF9FAFEF' || > 'EFCF9FBFDFEFEFDFCFAFEFEFE04004E627AADD16076B4F9FE6370A9F5FE59637 > AB0E54F58617087040046566487A1506CA2E3FA5A6CAFFBFE4D566DA4CB3E454 > C5665')::raster); > > and then i run this command : > > SELECT rid, Box2D(rast) As rastbox > FROM dummy_rast; > > i get NOTICE and no result : > > NOTICE: compute_serialized_box3d called on unknown type 0 > NOTICE: compute_serialized_box3d called on unknown type 0 rid | rastbox > -----+--------- > 1 | > 2 | > (2 rows) > > Can you help me to find out what's going wrong here ? > > Thanks in advance, > Dang Uyen. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
