| java.lang.Object org.geotools.data.jdbc.FilterToSQL org.geotools.data.db2.filter.SQLEncoderDB2
SQLEncoderDB2 | public class SQLEncoderDB2 extends FilterToSQL (Code) | | Generate a WHERE clause for DB2 Spatial Extender based on a spatial filter.
The following spatial filter operations are supported:
-
GEOMETRY_BBOX
-
GEOMETRY_CONTAINS
-
GEOMETRY_CROSSES
-
GEOMETRY_DISJOINT
-
GEOMETRY_EQUALS
-
GEOMETRY_INTERSECTS
-
GEOMETRY_OVERLAPS
-
GEOMETRY_TOUCHES
-
GEOMETRY_WITHIN
-
GEOMETRY_DWITHIN
author: David Adler - IBM Corporation |
Method Summary | |
protected void | addSelectivity() | protected FilterCapabilities | createFilterCapabilities() Sets the DB2 filter capabilities. | public String | db2Geom(Geometry geom) | public HashMap | getPredicateMap() | public void | setSRID(int srid) Set the value of the srid value to be used if a DB2 Spatial Extender
geometry needs to be constructed. | public void | setSelectivityClause(String string) Sets a SELECTIVITY clause that can be included with the spatial
predicate to influence the query optimizer to exploit a spatial index
if it exists.
The parameter should be of the form:
"SELECTIVITY 0.001"
where the numeric value is the fraction of rows that will be returned
by using the index scan. | public Object | visit(Id filter, Object extraData) Encodes an FidFilter. | public Object | visit(DWithin filter, Object extraData) | public Object | visit(Beyond filter, Object extraData) | public Object | visit(BBOX filter, Object extraData) | public Object | visit(Contains filter, Object extraData) | public Object | visit(Crosses filter, Object extraData) | public Object | visit(Disjoint filter, Object extraData) | public Object | visit(Equals filter, Object extraData) | public Object | visit(Intersects filter, Object extraData) | public Object | visit(Overlaps filter, Object extraData) | public Object | visit(Touches filter, Object extraData) | public Object | visit(Within filter, Object extraData) | protected Object | visitBinarySpatialOperator(BinarySpatialOperator filter, Object extraData) | protected Object | visitBinarySpatialOperator(BinarySpatialOperator filter, Object extraData, String db2Predicate) | public void | visitLiteralGeometry(Literal expression) |
SQLEncoderDB2 | public SQLEncoderDB2()(Code) | | Construct an SQLEncoderDB2
|
createFilterCapabilities | protected FilterCapabilities createFilterCapabilities()(Code) | | Sets the DB2 filter capabilities.
FilterCapabilities for DB2 |
db2Geom | public String db2Geom(Geometry geom)(Code) | | Construct a geometry from the WKT representation of a geometry
Parameters: geom - the constructor for the geometry. |
setSRID | public void setSRID(int srid)(Code) | | Set the value of the srid value to be used if a DB2 Spatial Extender
geometry needs to be constructed.
This is specifically the DB2 Spatial Extender spatial reference system
identifier and not a coordinate system identifier ala EPSG.
Parameters: srid - Spatial reference system identifier to be used. |
setSelectivityClause | public void setSelectivityClause(String string)(Code) | | Sets a SELECTIVITY clause that can be included with the spatial
predicate to influence the query optimizer to exploit a spatial index
if it exists.
The parameter should be of the form:
"SELECTIVITY 0.001"
where the numeric value is the fraction of rows that will be returned
by using the index scan. This doesn't have to be true. The value
0.001 is typically used to force the use of the spatial in all cases if
the spatial index exists.
Parameters: string - a selectivity clause |
visitBinarySpatialOperator | protected Object visitBinarySpatialOperator(BinarySpatialOperator filter, Object extraData)(Code) | | |
visitBinarySpatialOperator | protected Object visitBinarySpatialOperator(BinarySpatialOperator filter, Object extraData, String db2Predicate)(Code) | | |
visitLiteralGeometry | public void visitLiteralGeometry(Literal expression) throws IOException(Code) | | Construct the appropriate geometry type from the WKT representation of a literal
expression
Parameters: expression - the expression turn into a geometry constructor. throws: IOException - Passes back exception if generated bythis.out.write() |
Methods inherited from org.geotools.data.jdbc.FilterToSQL | protected FilterCapabilities createFilterCapabilities()(Code)(Java Doc) public void encode(Filter filter) throws FilterToSQLException(Code)(Java Doc) public String encodeToString(Filter filter) throws FilterToSQLException(Code)(Java Doc) public String escapeName(String name)(Code)(Java Doc) final public synchronized FilterCapabilities getCapabilities()(Code)(Java Doc) public void setFIDMapper(FIDMapper mapper)(Code)(Java Doc) public void setFeatureType(FeatureType featureType)(Code)(Java Doc) public void setSqlNameEscape(String escape)(Code)(Java Doc) public Object visit(ExcludeFilter filter, Object extraData)(Code)(Java Doc) public Object visit(IncludeFilter filter, Object extraData)(Code)(Java Doc) public Object visit(PropertyIsBetween filter, Object extraData) throws RuntimeException(Code)(Java Doc) public Object visit(PropertyIsLike filter, Object extraData)(Code)(Java Doc) public Object visit(And filter, Object extraData)(Code)(Java Doc) public Object visit(Not filter, Object extraData)(Code)(Java Doc) public Object visit(Or filter, Object extraData)(Code)(Java Doc) protected Object visit(BinaryLogicOperator filter, Object extraData)(Code)(Java Doc) public Object visit(PropertyIsEqualTo filter, Object extraData)(Code)(Java Doc) public Object visit(PropertyIsGreaterThanOrEqualTo filter, Object extraData)(Code)(Java Doc) public Object visit(PropertyIsGreaterThan filter, Object extraData)(Code)(Java Doc) public Object visit(PropertyIsLessThan filter, Object extraData)(Code)(Java Doc) public Object visit(PropertyIsLessThanOrEqualTo filter, Object extraData)(Code)(Java Doc) public Object visit(PropertyIsNotEqualTo filter, Object extraData)(Code)(Java Doc) public Object visit(PropertyIsNull filter, Object extraData) throws RuntimeException(Code)(Java Doc) public Object visit(Id filter, Object extraData)(Code)(Java Doc) public Object visit(BBOX filter, Object extraData)(Code)(Java Doc) public Object visit(Beyond filter, Object extraData)(Code)(Java Doc) public Object visit(Contains filter, Object extraData)(Code)(Java Doc) public Object visit(Crosses filter, Object extraData)(Code)(Java Doc) public Object visit(Disjoint filter, Object extraData)(Code)(Java Doc) public Object visit(DWithin filter, Object extraData)(Code)(Java Doc) public Object visit(Equals filter, Object extraData)(Code)(Java Doc) public Object visit(Intersects filter, Object extraData)(Code)(Java Doc) public Object visit(Overlaps filter, Object extraData)(Code)(Java Doc) public Object visit(Touches filter, Object extraData)(Code)(Java Doc) public Object visit(Within filter, Object extraData)(Code)(Java Doc) public Object visit(PropertyName expression, Object extraData) throws RuntimeException(Code)(Java Doc) public Object visit(Literal expression, Object context) throws RuntimeException(Code)(Java Doc) public Object visit(Add expression, Object extraData)(Code)(Java Doc) public Object visit(Divide expression, Object extraData)(Code)(Java Doc) public Object visit(Multiply expression, Object extraData)(Code)(Java Doc) public Object visit(Subtract expression, Object extraData)(Code)(Java Doc) protected Object visit(BinaryExpression expression, Object extraData) throws RuntimeException(Code)(Java Doc) public Object visit(Function expression, Object extraData) throws UnsupportedOperationException(Code)(Java Doc) public Object visit(NilExpression expression, Object extraData)(Code)(Java Doc) protected void visitBinaryComparisonOperator(BinaryComparisonOperator filter, Object extraData) throws RuntimeException(Code)(Java Doc) protected Object visitBinarySpatialOperator(BinarySpatialOperator filter, Object extraData)(Code)(Java Doc) protected void visitLiteralGeometry(Literal expression) throws IOException(Code)(Java Doc) public Object visitNullFilter(Object extraData)(Code)(Java Doc)
|
|
|