Everything

Overlap Query

SELECT *
  FROM geo1, querypoly
 WHERE geopoly_overlap(_shape, poly);

QUERY PLAN
|--SCAN TABLE querypoly
`--SCAN TABLE geo1 VIRTUAL TABLE INDEX 2:rtree

Overlap Query And Result Bounding Box

Bounding-Box Overlap Query

| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |

Within Query

SELECT *
  FROM geo1, querypoly
 WHERE geopoly_within(_shape, poly);

QUERY PLAN
|--SCAN TABLE querypoly
`--SCAN TABLE geo1 VIRTUAL TABLE INDEX 3:rtree

Bounding-Box WITHIN Query

| | | | | | | | | | | | | | | | | | | | | | | | | | | |

Not Overlap Query

SELECT *
  FROM geo1, querypoly
 WHERE NOT geopoly_overlap(_shape, poly);

QUERY PLAN
|--SCAN TABLE geo1 VIRTUAL TABLE INDEX 4:fullscan
`--SCAN TABLE querypoly

Not Within Query

SELECT *
  FROM geo1, querypoly
 WHERE NOT geopoly_within(_shape, poly);

QUERY PLAN
|--SCAN TABLE geo1 VIRTUAL TABLE INDEX 4:fullscan
`--SCAN TABLE querypoly

Color-Change For Overlapping Elements

Color-Change And Move Overlapping Elements

Overlap With Translated Query Polygon

Regular Polygons