[postgis-users] Make Union between 2 layers

2016-02-05 Thread Alain Benard
Hi, I would like to make an operation between two tables with geometry (polygon) - user's GIS call this operation a UNION. I think this : * Step1 : make st_intersection (where st_intersects) and obtains the 4 little square with attributes from the two table. I call the result

Re: [postgis-users] loading raster colour heatmap data or converting to a shape file

2016-02-05 Thread Pierre Racine
This all depends on the kind of operations you want to do... Some might be easier keeping rasters as raster. Others are easier if you convert everything to vector. You can easily convert raster loaded in PostGIS to vector using ST_DumpAsPolygons(). The reverse operation is done through a mix

[postgis-users] loading raster colour heatmap data or converting to a shape file

2016-02-05 Thread dave . potts
Hi list, I have some heat map files which I want to do some spatial analyisis on. I am wondering what the best way to proceed. I admin that I have never used the raster part of postgis before. I have two choices 1. Convert the raster files to shape files and load the shape files in to