'
BEGIN;
UPDATE geo1
SET clr=CASE WHEN rowid IN (SELECT geo1.rowid FROM geo1, querypoly
WHERE geopoly_overlap(_shape,poly))
- THEN 'red' ELSE 'blue' END;
+ THEN 'red' ELSE '#76ccff' END;
UPDATE geo1
SET _shape=geopoly_xform(_shape,1,0,0,1,300,0)
WHERE geopoly_overlap(_shape,(SELECT poly FROM querypoly));
.print ''
+
+
+.print '
Overlap With Translated Query Polygon
'
+UPDATE querypoly SET poly=geopoly_xform(poly,1,0,0,1,300,0);
+.print ''
.print '