Thanks. Would you recommend QGIS do that instead of the expensive query on
the view?
BTW, turns out there was a QGIS option to limit the expensive query to 100
rows, but it was kind of buried.
On Sun, Jan 30, 2011 at 11:40 PM, Bruno Friedmann wrote:
> On 01/30/2011 09:43 PM, Aren Cambre wrote:
I guess what I meant was:
select st_difference(streets,st_intersection(streets,forests)) as streets
from streets, forests
where st_intersects(streets,forests)
union
select streets
from streets, forests
where not st_intersects(streets,forests)
-Original Message-
From: postgis-users-boun
Seems like the difference of the streets with the intersection of the forests
and the streets should do that.
st_difference(streets,st_intersection(streets,forests))
Eric
-Original Message-
From: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.
I think I got a more or less nice solution:
-- Some test data:
DROP TABLE IF EXISTS lines;
CREATE TABLE lines (geom geometry);
INSERT INTO lines(geom)
SELECT 'LINESTRING(1 1, 2 3, 3 4, 5 4, 6 4)'::geometry -- L1
UNION SELECT 'LINESTRING(4 4, 5 4, 7 4, 10 2)'::geometry -- L2
UNION SELEC
RBFDB ? :-)
Maybe Paul Ramsey can provide a link to his presentation on Open Source for
Management (something like that).
Sounds like it might be relevant in your case. I don't have the link handy,
Paul ? Thanks.
Eric
-Original Message-
From: postgis-users-boun...@postgis.refraction
hello
I am in favor of using OSS and postgresql - postgis.
I am challenged in my working area that how postgresql - postgis
are trustable and not having support.
Just curious.
What is the actul big DBMS of your company ?
Andrea.
___
postgis-users
Il giorno lun, 31/01/2011 alle 20.55 +0200, ahmet temiz ha scritto:
> hello
>
> I am in favor of using OSS and postgresql - postgis.
> I am challenged in my working area that how postgresql - postgis
> are trustable and not having support.
>
> Could you supply me the some of the names of the we
hello
I am in favor of using OSS and postgresql - postgis.
I am challenged in my working area that how postgresql - postgis
are trustable and not having support.
Could you supply me the some of the names of the well known big projects
to defend OSS and postgresql - postgis.
regards
--
Ahmet T
Thanks Etienne.
I guess that was the last version (1.8)?
Even if the driver is working fine, we have to check that clients (like
MapServer) are using it fine and we have to compare the performance compared
with, say, file system raster files.
Pierre
From: postgis-users-boun...@postgis.refract
Just to mention that I did try the gdal driver for PGRaster and it is
working. I can't tell the speed, and like mentionnend Simon it depends of
many things. But I did succeed to render (query and write to disk as an
ascii file with prj file) a 100x100 pixels 32b float, single band using
gdal_transl
Just FYI:
I defined some test queries over at postgis-dev mailinglist with the
thread "Behavior of LineString-LineString ST_Intersection and
LineString-Polygon ST_Difference".
Yours, S.
2011/1/30 Stefan Keller :
> Hi,
>
> Given streets linestrings and forest polygons, think of all streets
> segm
Sunny,
There are two planned options for serving raster from PostGIS raster:
The first (1) is to just register the raster as out-of db raster. Only the
georeferences of each tile/raster is stored in the database along with the path
to the raster itself in the filesystem (you can add any other a
12 matches
Mail list logo