#POSTGIS IRC Log - 2008-06-02

For logs after Feb 3, 2007, all times are GMT-8. Prior logs are GMT-9.
Back to Logs
13:42:20 someotherdude: hello
13:42:30 someotherdude: noob licensing question
13:42:45 someotherdude: what is the postgis jdbc licensed under?
13:45:14 someotherdude: nevermind, found it
17:05:57 brough: have a bit of a design prob looking for lines that cover one anoter. geom_a: '1----4' covers geom_b '1----4' also coveredby a union of geom_c and geom_d: '1--2/2--4'. the geom_a covers geom_b query is fast and easy. is there a simple way of finding if geom_b is coveredby a combination of geoms?
17:09:20 brough: I just need to return true if geom_a covers a geometry on table_b with a particular foreign key ( obviously trivial ), or return true if geom_a is exactly covered by two or more geometries on table_b of the same foreign key.
17:09:57 brough: ie the 'matching' geom on table_b can be broken up.
17:13:06 brough: I think creating a union of all geoms on table_b, on union for each fkey condition, and querying those unions, would be the fastest way?
17:13:23 brough: *one union for each foreign key condition.