Tag Info

Hot answers tagged


In QGIS 2.6.1, go to menu Database->DB Manager->DB Manager, set the database connection and you will see the raster table. You can drag and drop it or right click and select Add to canvas. From your description of the problem, you are using the regular "Add PostGIS Layers", which will not show your raster table, since it is for vectors and ...


Try this SELECT SUM(length) As length FROM (SELECT DISTINCT ON (r.gid) r.gid, ST_Length(r.geom) As length FROM roads AS r JOIN cadastre AS c ON ST_Intersects(r.geom,c.geom) WHERE ST_Length(r.geom)>500 AND ST_Area(c.geom)>2000 ORDER BY r.gid ) As rc; ...

Only top voted, non community-wiki answers of a minimum length are eligible