[postgis-devel] [PostGIS] #1247: ST_AsRaster aggregate function

PostGIS trac at osgeo.org
Tue Oct 18 23:42:22 PDT 2011

#1247: ST_AsRaster aggregate function
 Reporter:  robe         |       Owner:  pramsey              
     Type:  enhancement  |      Status:  new                  
 Priority:  medium       |   Milestone:  PostGIS Raster Future
Component:  postgis      |     Version:  trunk                
 Keywords:               |  

 Not sure if this is what you had in mind when you said "Burn In" function
 in your talk.  A common need I have which I am sure is that of many BI
 analysts is the need to show simple thematic maps in reports.

 What came to mind to me was an aggregate ST_AsRaster function that takes a
 set of geomval rows (or multicolumn geom, value) and builds a raster.
 Basically a reverse of the ST_DumpAsPolgons function.

 This would make it trivial to do a query such as

 SELECT ST_AsPNG(ST_AsRaster(gval),300,300) As mymap
 FROM (SELECT ROW(ST_Union(geom), SUM(pop))::geomval As gval
 FROM sumregion
 GROUP BY region_name) As fii }}}

 Which is big considering many report writers allow their picture box
 controls to be bound to query fields.  We might have a new crowd of BI
 analysts looking to get a piece of PostGIS action.


Ticket URL: <http://trac.osgeo.org/postgis/ticket/1247>
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-devel mailing list