Re: [postgis-users] screen copy with postgis

2017-02-22 Thread Olivier LeprĂȘtre
Hi, Thanks for this answer Thomas, you confirm what I guessed also. Before considering this way, I had a look about attributes and didn't find how I could create raster texts layer, to display gid or other information. So I wonder if I should better not carrying on with Postgis for that but t

Re: [postgis-users] screen copy with postgis

2017-02-22 Thread Tumasgiu Rossini
Hi, I'm not sure there is a function that can burns geometries on an existing raster. So I guess you will need to create a raster for each "layer" you want to draw (e.g. the polygons, the boundaries...) and merge them into a final raster using st_mapalgebra. 2017-02-22 21:48 GMT+01:00 Olivier Le

[postgis-users] screen copy with postgis

2017-02-22 Thread Olivier LeprĂȘtre
Hi, I'm trying to do a "screen copy" from a set of polygons. So I thought that I could use St_AsRaster and St_AsJpeg as follow, with the selection of two poly. SELECT ST_AsJPEG(ST_AsRaster(st_collect((Select geom from poly where gid=605530),(Select geom from poly where gid=605533)),1000,1000,

Re: [postgis-users] Intersection of three polygons

2017-02-22 Thread Giuseppe Broccolo
Hi Saranya, 2017-02-21 10:51 GMT+01:00 Saranya Kuniyil : > Hai, > yes. I am interested to retrieve all polygons which intersects any one > among three categories.. > In the above example, > 1)POLYGON((0 0,0 1,1 1,1 0,0 0)) filename as part1 > POLYGON((0 0,0 2,2 2,2 0,0 0)) filename as part2 >