Opened 13 years ago

Last modified 7 years ago

#1247 new enhancement

ST_AsRaster aggregate function — at Initial Version

Reported by: robe Owned by: pramsey
Priority: medium Milestone: PostGIS Fund Me
Component: postgis Version: master
Keywords: Cc:

Description

Pierre,

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.

http://www.postgis.org/documentation/manual-svn/RT_ST_AsRaster.html 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.

Change History (0)

Note: See TracTickets for help on using tickets.