spatialIntersects method

Future<List<Map<String, Object?>>> spatialIntersects(
  1. String table,
  2. String geomColumn,
  3. String wkt
)

The rows of table whose geomColumn intersects the geometry described by wkt.

Implementation

Future<List<Map<String, Object?>>> spatialIntersects(
  String table,
  String geomColumn,
  String wkt,
) => rawQuery(
  'SELECT t.* FROM $table AS t '
  'WHERE t.ROWID IN ('
  '  SELECT ROWID FROM ${_rtreeName(table, geomColumn)}'
  '  WHERE xmin <= MbrMaxX(GeomFromText(?)) AND xmax >= MbrMinX(GeomFromText(?))'
  '    AND ymin <= MbrMaxY(GeomFromText(?)) AND ymax >= MbrMinY(GeomFromText(?))'
  ') '
  'AND ST_Intersects(GeomFromText(?), t.$geomColumn) = 1',
  [wkt, wkt, wkt, wkt, wkt],
);