private String buildWhere ( double minX , double minY , double maxX , double maxY ) { StringBuilder where = new StringBuilder ( ) ; where . append ( buildWhere ( RTreeIndexExtension . COLUMN_MIN_X , maxX , "<=" ) ) ; where . append ( " AND " ) ; where . append ( buildWhere ( RTreeIndexExtension . COLUMN_MIN_Y , maxY , "<=" ) ) ; where . append ( " AND " ) ; where . append ( buildWhere ( RTreeIndexExtension . COLUMN_MAX_X , minX , ">=" ) ) ; where . append ( " AND " ) ; where . append ( buildWhere ( RTreeIndexExtension . COLUMN_MAX_Y , minY , ">=" ) ) ; return where . toString ( ) ; }
Build a where clause from the bounds for overlapping ranges