Skip to main content

  • ​
    filterByGeometry

    public FilterByGeometryResponse filterByGeometry(FilterByGeometryRequest request) throws GPUdbException
    Applies a geometry filter against a geospatial geometry column in a given table or view. The filtering geometry is provided by inputWkt.
    Parameters:
    request - Request object containing the parameters for the operation.
    Returns:
    Response object containing the results of the operation.
    Throws:
    GPUdbException - if an error occurs during the operation.

  • ​
    filterByGeometry

    public FilterByGeometryResponse filterByGeometry(String tableName, String viewName, String columnName, String inputWkt, String operation, Map<String,String> options) throws GPUdbException
    Applies a geometry filter against a geospatial geometry column in a given table or view. The filtering geometry is provided by inputWkt.
    Parameters:
    tableName - Name of the table on which the filter by geometry will be performed, in [schema_name.]table_name format, using standard name resolution rules. Must be an existing table or view containing a geospatial geometry column.
    viewName - If provided, then this will be the name of the view containing the results, in [schema_name.]view_name format, using standard name resolution rules and meeting table naming criteria. Must not be an already existing table or view. The default value is ”.
    columnName - Name of the column to be used in the filter. Must be a geospatial geometry column.
    inputWkt - A geometry in WKT format that will be used to filter the objects in tableName. The default value is ”.
    operation - The geometric filtering operation to perform. Supported values:
    • CONTAINS: Matches records that contain the given WKT in inputWkt, i.e. the given WKT is within the bounds of a record’s geometry.
    • CROSSES: Matches records that cross the given WKT.
    • DISJOINT: Matches records that are disjoint from the given WKT.
    • EQUALS: Matches records that are the same as the given WKT.
    • INTERSECTS: Matches records that intersect the given WKT.
    • OVERLAPS: Matches records that overlap the given WKT.
    • TOUCHES: Matches records that touch the given WKT.
    • WITHIN: Matches records that are within the given WKT.
    options - Optional parameters.
    • CREATE_TEMP_TABLE: If TRUE, a unique temporary table name will be generated in the sys_temp schema and used in place of viewName. This is always allowed even if the caller does not have permission to create tables. The generated name is returned in QUALIFIED_VIEW_NAME. Supported values:The default value is FALSE.
    • COLLECTION_NAME: [DEPRECATED—please specify the containing schema for the view as part of viewName and use createSchema to create the schema if non-existent] Name of a schema for the newly created view. If the schema provided is non-existent, it will be automatically created.
    The default value is an empty Map.
    Returns:
    Response object containing the results of the operation.
    Throws:
    GPUdbException - if an error occurs during the operation.