Bborie, Is there any way to force ST_Transform(rast, srid) to produce rasters with a specific, identical alignment?
Or we have to ST_Resample them afterward? Pierre > -----Original Message----- > From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users- > boun...@postgis.refractions.net] On Behalf Of Stephen Crawford > Sent: Tuesday, February 28, 2012 11:51 AM > To: postgis-users@postgis.refractions.net > Subject: Re: [postgis-users] Transform > > ScaleX and ScaleY are identical for each tile in the original table, and are > all > different in the transformed table, which I guess should make sense on a > transform? > > I actually now think my output problem is in GDAL. I have been outputting > AAIGrids which I then use in geoserver. The values are between 0 and 1, and I > think GDAL is auto-detecting the table as int and giving me all 0. At least > I think > that is what is happening :-) I will try the process with another table. > > Steve > > On 2/28/2012 11:27 AM, Pierre Racine wrote: > >> OK, it seems ST_Transform is working for me, but I'm a bit confused > >> about the "raster_columns" table. The original (pre-transform) raster > >> table is a set of 187 tiles. In raster_columns 'scale_x', 'scale_y', > >> 'blocksize_x', 'blocksize_y' are all defined, and 'same_alignment'=t. > >> Then when I run AddRasterConstraints(output_table, 'rast'), these > >> value are either null or f. Do I need to do anything else to use the > >> reprojected data, like re-tile it or something? > > What if you display their extents (rast::geometry) in OpenJump or another > display tool? Do they align properly? > > > > Are the scalex and scaley, just to mention them, identical for every tile? > > > > Pierre > > _______________________________________________ > > postgis-users mailing list > > postgis-users@postgis.refractions.net > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > -- > Stephen Crawford > Center for Environmental Informatics > The Pennsylvania State University > src...@psu.edu > 814.865.9905 > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
