[postgis-users] ST_Intersection

jj.wag at gmx.de jj.wag at gmx.de
Fri May 21 02:00:40 PDT 2010


I have a polygon table (alk_flurstuecke) and create a view with a 40-meter 
buffer on an object:

CREATE VIEW buffer_flur_40 AS
SELECT gid, ST_SetSRID(st_buffer(the_geom,40), 31466 )
AS the_geom FROM alk_flurstuecke WHERE fkz = '0726900330002300000';

No problem, Ican see it in QGIS.
Now I try to make an intersection on this buffer-view with my table:

CREATE VIEW intersect_flur_40 (gid, flur, zaehler, nenner, the_geom) AS
SELECT p.gid, p.flur, p.zaehler, p.nenner, 
ST_SetSRID(ST_Intersection(p.the_geom, b.the_geom) ,31466)
AS the_geom FROM alk_flurstuecke AS p, buffer_flur_40 AS b
WHERE p.fkz <> '0726900330002300000' AND IsEmpty 
(ST_Intersection(p.the_geom, b.the_geom) ) = FALSE;

This view is created without errors too but there is no result. If I try to 
load the view in QGIS it diapears.
Any idea?


More information about the postgis-users mailing list