geopackage-sdk/src/main/java/mil/nga/geopackage/extension/RTreeIndexTableDao.java
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();
    }
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();
    }
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

@param minX min x
@param minY min y
@param maxX max x
@param maxY max y
@return where clause
Build a where clause from the bounds for overlapping ranges