[postgis-tickets] [PostGIS] #2249: [raster] Implement ST_MakeEmptyCoverage

PostGIS trac at osgeo.org
Fri Sep 26 05:26:30 PDT 2014


#2249: [raster] Implement ST_MakeEmptyCoverage
-------------------------+--------------------------------------------------
 Reporter:  dzwarg       |       Owner:  dzwarg       
     Type:  enhancement  |      Status:  assigned     
 Priority:  medium       |   Milestone:  PostGIS 2.2.0
Component:  raster       |     Version:  trunk        
 Keywords:  raster       |  
-------------------------+--------------------------------------------------

Comment(by ainomieli):

 Here is boilerplate for creating tile set with bounds (:x0, :y0, :x1, :y1)
 and grid dimensions (:width, :height):

 {{{
 SELECT cell FROM ST_MakeEmptyCoverage(
   1, 1, -- tile width, tile height
   :width, :height, -- grid columns, grid rows
   :x0, :y0, -- upperleftx, upperlefty
   (:x1 - :x0)/(:width)::float, -- scalex
   (:y1 - :y0)/(:height)::float, -- scaley
   0., 0., -- skewx, skewy
   4326 -- srid
   ) cell;
 }}}

  * (:x0, :y0) is the upper left corner
  * (:x1, :y1) is the lower right corner
  * :width is the number of columns in the grid
  * :height is the number of rows in the grid

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2249#comment:10>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-tickets mailing list