[postgis-users] ST_MakeEmptyRaster

Mark Wynter mark at dimensionaledge.com
Fri Jun 22 22:51:40 PDT 2012


When making an empty raster, is there a way to control the direction of the raster?  

The starting point for the raster is upperleftx, upperlefty.  So If I'm in the southern hemisphere, the upperlefty value is a negative number, hence the grid builds in a northerly direction

INSERT INTO dummy_rast(rid,rast)
VALUES(1, ST_MakeEmptyRaster(100, 100, 570344, -3781663, 1000, 1000, 0, 0, 3577));

If I change the width to -100 in the hope of reversing the direction, no luck...

INSERT INTO dummy_rast(rid,rast)
VALUES(1, ST_MakeEmptyRaster(100, -100, 570344, -3781663, 1000, 1000, 0, 0, 3577));

The blocksize_y doesn't accept negative numbers, and defaults according...

srid | scale_x | scale_y | blocksize_x | blocksize_y | num_bands | pixel_types | nodata_values 
------+---------+---------+-------------+-------------+-----------+-------------+---------------
 3577 |    1000 |    1000 |         100 |       65436 |         1 | {8BUI}      | {NULL}
(1 row)

I understand the logic of why it's doing what it is.

Is there a way of making the grid build in a southerly direction if I'm in the southern hemisphere? 





More information about the postgis-users mailing list