st_intersection(st_envelope(st_buffer(t1.the_geom, $radius)), t2. the_geom)
2009/8/18 Daniel Grum <[email protected]>: > Dear Mailing-List, > > I want to create a square/rectangle around a point-->via box2d(geometry) or > buffer(geometry, double precision) for example. > > If I have this rectangle I want to intersect this with another polygon--> > saved in the (geodata) table: wald_by column: the_geom, to get information > about the area the the "lumberjack" can dig. > The point in the middle of the rectangle = the point that is saved in a > table in my database in the table: holzfaeller in the column the_geom! > > Is this possible to solve? > Do I have to save this calculated square/rectangle in an extra/own table? > > Thanks for every help. > > Daniel > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- http://iap.md, The future is open _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
