| TerraLib 4.1

- Main Page
- Related Pages
- Modules
- Namespaces
- Classes
- Files
- Examples

- Class List
- Class Index
- Class Hierarchy
- Class Members

Public Member Functions | Friends
TeOracleSpatial Class Reference

A concrete implementation of a interface driver to the ORACLE SPATIAL DBMS. More...

`#include <TeOracleSpatial.h>`

Inheritance diagram for TeOracleSpatial:

List of all members.

## Public Member Functions

| TeOracleSpatial ()
| Constructor.
| ~TeOracleSpatial ()
| Destructor.
bool | connect (const string &host, const string &user, const string &password, const string &database, int port=-1)
| Connects to Oracle Spatial DBMS.
bool | createTable (const string &table, TeAttributeList &attr)
| Creates a new table.
bool | createSpatialIndex (const string &table, const string &column, TeSpatialIndexType type=TeRTREE, short level=0, short tile=0)
| Creates a spatial index to a specific geometry table.
bool | insertMetadata (const string &table, const string &column, double tolx, double toly, TeBox &box, short srid=0)
| Inserts the metadata information associated to a specific geometric table in the the USER_SDO_GEOM_METADATA table.
string | getSpatialIdxColumn (TeGeomRep rep)
| Returns the name of the column that will be spatially indexed, for a given type of geometry table.
TeDatabasePortal * | getPortal ()
| Gets a cursor using the opened connection.
bool | generateLabelPositions (TeTheme *theme, const std::string &objectId="")
| Generates label positions to each object of a theme.
bool | getMBRSelectedObjects (string geomTable, string colGeom, string fromClause, string whereClause, string afterWhereClause, TeGeomRep repType, TeBox &bout, const double &tol=0.0)
| Return the box of a select objects set.
bool | getMBRGeom (string tableGeom, string object_id, TeBox &box, string colGeom)
| Return the box of a specific geometry (object_id)
Inserts, updates and deletes geometries from the tables
bool | insertPolygon (const string &table, TePolygon &p)
| Inserts a polygon in a geometry table.
bool | updatePolygon (const string &table, TePolygon &p)
| Updates a polygon in a geometry table.
bool | locatePolygon (const string &table, TeCoord2D &pt, TePolygon &polygon, const double &tol=0.0)
| Returns the first polygon that contais a given coordinate.
bool | selectPolygonSet (const string &table, const string &criteria, TePolygonSet &ps)
| Returns all polygons in a table given a criteria expressed as an SQL where statement.
bool | loadPolygonSet (const string &table, const string &geoid, TePolygonSet &ps)
| Returns all polygons that represents objects of a particular geoid.
bool | loadPolygonSet (const string &table, TeBox &box, TePolygonSet &ps)
| Returns all polygons inside a given box.
bool | loadPolygonSet (TeTheme *theme, TePolygonSet &ps)
| Returns all polygons that represents objects of a particular theme.
TeDatabasePortal * | loadPolygonSet (const string &table, TeBox &box)
| Returns a database portal to iterate over the polygons that are inside a given box.
bool | allocateOrdinatesObject (TePolygon &poly, string &elInfo, TeOCICursor *cursor=0)
bool | insertLine (const string &table, TeLine2D &l)
bool | updateLine (const string &table, TeLine2D &l)
bool | locateLine (const string &table, TeCoord2D &pt, TeLine2D &line, const double &tol=0.0)
bool | loadLineSet (const string &table, const string &geoid, TeLineSet &ls)
bool | loadLineSet (const string &table, TeBox &box, TeLineSet &linSet)
TeDatabasePortal * | loadLineSet (const string &table, TeBox &box)
bool | allocateOrdinatesObject (TeLine2D &line, TeOCICursor *cursor=0)
bool | insertPoint (const string &table, TePoint &p)
bool | updatePoint (const string &table, TePoint &p)
bool | locatePoint (const string &table, TeCoord2D &pt, TePoint &point, const double &tol=0.0)
bool | insertText (const string &table, TeText &t)
bool | insertArc (const string &table, TeArc &arc)
| Inserts an arc geometry in the database.
bool | insertNode (const string &table, TeNode &node)
bool | updateNode (const string &table, TeNode &node)
bool | insertCell (const string &table, TeCell &c)
bool | updateCell (const string &table, TeCell &c)
bool | locateCell (const string &table, TeCoord2D &pt, TeCell &cell, const double &tol=0.0)
virtual bool | removeGeometry (const string &tableName, const TeGeomRep &rep, const int &geomId)
| Removes a geometry from the given tableName.
bool | insertRasterBlock (const string &table, const string &blockId, const TeCoord2D &ll, const TeCoord2D &ur, unsigned char *buf, unsigned long size, int band=0, unsigned int res=1, unsigned int subband=0)
| Insert a raster block into the database.
Methods that return specific SQL statement according to each DBMS
virtual std::string | getSQLOrderBy (const TeGeomRep &rep) const
| < Returns a string SQL to be used in the ORDER BY clause when querying geometries.
string | getSQLBoxWhere (const TeBox &box, const TeGeomRep rep, const std::string &tableName)
| Return a string that describes a where clause in SQL to return the geometries inside the box.
virtual string | getSQLBoxWhere (const TeBox &box, const TeGeomRep rep, const std::string &tableName, const std::string &columnName)
| Return a string that describes a where clause in SQL to return the geometries inside the box.
string | getSQLBoxWhere (const string &table1, const string &table2, TeGeomRep rep2, TeGeomRep rep1)
string | getSQLBoxSelect (const string &tableName, TeGeomRep rep)
| Return a string SQL to be used in the clause SELECT to select the box (lower_x, lower_y, upper_x, upper_y)
Spatial query
bool | spatialRelation (const string &actGeomTable, TeGeomRep actRep, TeKeys &actIdsIn, TeDatabasePortal *portal, int relate, const string &actCollTable="")
| Returns the geometries of a geometric table (actGeomTable) that have a specific spatial relation (relate) with a subset of geometries of this table (actGeomTable)
bool | spatialRelation (const string &actGeomTable, TeGeomRep actRep, TeKeys &actIdsIn, const string &visGeomTable, TeGeomRep visRep, TeDatabasePortal *portal, int relate, const string &visCollTable="")
| Returns the geometries of a geometric table (visGeomTable) that have a specific spatial relation (relate) with a subset of geometries of other geometric table (actGeomTable)
bool | spatialRelation (const string &actGeomTable, TeGeomRep actRep, TeGeometry *geom, TeDatabasePortal *portal, int relate, const string &actCollTable="")
| Returns the geometries of a geometric table (actGeomTable) that have a specific spatial relation (relate) with a geometry in memory (geom)
bool | spatialRelation (const string &actGeomTable, TeGeomRep actRep, TeKeys &actIdsIn, TeKeys &actIdsOut, int relate, const string &actCollTable="")
| Returns the geometries of a geometric table (actGeomTable) that have a specific spatial relation (relate) with a subset of geometries of this table (actGeomTable)
bool | spatialRelation (const string &actGeomTable, TeGeomRep actRep, TeKeys &actIdsIn, const string &visGeomTable, TeGeomRep visRep, TeKeys &visIdsOut, int relate, const string &visCollTable="")
bool | spatialRelation (const string &actGeomTable, TeGeomRep actRep, TeGeometry *geom, TeKeys &actIdsOut, int relate, const string &actCollTable="")
| Returns the geometries of a geometric table (actGeomTable) that have a specific spatial relation (relate) with a geometry in memory (geom)
Metric functions
bool | calculateArea (const string &actGeomTable, TeGeomRep actRep, TeKeys &actIdsOut, double &area)
| Calculates the area of a geometry set of the geometric table (actGeomTable)
bool | calculateLength (const string &actGeomTable, TeGeomRep actRep, TeKeys &actIdsIn, double &length)
| Calculates the length of a geometry set of the actGeomTable table.
bool | calculateDistance (const string &actGeomTable, TeGeomRep actRep, TeKeys &Ids, double &distance)
| Calculates the distance between two geometries of the actGeomTable table.
bool | calculateDistance (const string &actGeomTable, TeGeomRep actRep, const string &objId1, const string &visGeomTable, TeGeomRep visRep, const string &objId2, double &distance)
| Calculates the distance between a geometry of a geometric table (actGeomTable) and a geometry of other geometric table (visGeomTable)
Functions that generate new geometry
bool | buffer (const string &actGeomTable, TeGeomRep actRep, TeKeys &actIds, TePolygonSet &bufferSet, double dist)
| Returns the buffers with a specific distance of a geometry set of a geometric table (actGeomTable)
bool | convexHull (const string &actGeomTable, TeGeomRep actRep, TeKeys &actIds, TePolygonSet &convexHullSet)
| Returns the convex geometries of a geometries set of a geometric table (actGeomTable)
bool | centroid (const string &actGeomTable, TeGeomRep actRep, TePointSet &centroidSet, TeKeys actIds=vector< string >(), const string &actCollTable="")
| Returns the centroids of a geometry set of a geometric table (actGeomTable)
Functions that return the nearest neighbors
bool | nearestNeighbors (const string &actGeomTable, const string &actCollTable, TeGeomRep actRep, const string &objId1, TeKeys &actIdsOut, int numRes=1)
| Returns the nearest neighbors of a specific geometry of a geometric table (actGeomTable)
bool | nearestNeighbors (const string &actGeomTable, TeGeomRep actRep, const string &objId1, const string &visGeomTable, const string &visCollTable, TeGeomRep visRep, TeKeys &visIdsOut, int numRes=1)
| Returns the nearest neighbors of a geometric table (visGeomTable) of a specific geometry of other geometric table (actGeomTable)
bool | nearestNeighbors (const string &actGeomTable, const string &actCollTable, TeGeomRep actRep, const string &objId1, TeDatabasePortal *portal, int numRes=1)
| Returns the nearest neighbors of a specific geometry of a geometric table (actGeomTable)
bool | nearestNeighbors (const string &actGeomTable, TeGeomRep actRep, const string &objId1, const string &visGeomTable, const string &visCollTable, TeGeomRep visRep, TeDatabasePortal *portal, int numRes=1)
| Returns the nearest neighbors of a geometric table (visGeomTable) of a specific geometry of other geometric table (actGeomTable)
Set functions
bool | geomIntersection (const string &actGeomTable, TeGeomRep actRep, TeKeys &actIds, TeGeometryVect &geomVect)
| Returns the intersection between two geometries of a geometric table (actGeomTable)
bool | geomIntersection (const string &actGeomTable, TeGeomRep actRep, const string &objId1, const string &visGeomTable, TeGeomRep visRep, const string &objId2, TeGeometryVect &geomVect)
| Returns the intersection between a geometry of a geometric table (actGeomTable) and a geometry of other geometric table (visGeomTable)
bool | geomDifference (const string &actGeomTable, TeGeomRep actRep, const string &objId1, const string &objId2, TeGeometryVect &geomVect)
| Returns the difference between two geometries of a geometric table (actGeomTable)
bool | geomDifference (const string &actGeomTable, TeGeomRep actRep, const string &objId1, const string &visGeomTable, TeGeomRep visRep, const string &objId2, TeGeometryVect &geomVect)
| Returns the difference between a geometry of a geometric table (actGeomTable) and a geometry of other geometric table (visGeomTable)
bool | geomUnion (const string &actGeomTable, TeGeomRep actRep, TeKeys &actIds, TeGeometryVect &geomVect)
| Returns the union between geometries of a geometric table (actGeomTable)
bool | geomUnion (const string &actGeomTable, TeGeomRep actRep, const string &objId1, const string &visGeomTable, TeGeomRep visRep, const string &objId2, TeGeometryVect &geomVect)
| Returns the union between a geometry of a geometric table (actGeomTable) and a geometry of other geometric table (visGeomTable)
bool | geomXOr (const string &actGeomTable, TeGeomRep actRep, const string &objId1, const string &objId2, TeGeometryVect &geomVect)
| Returns the symmetrical difference between two geometries of a geometric table (actGeomTable)
bool | geomXOr (const string &actGeomTable, TeGeomRep actRep, const string &objId1, const string &visGeomTable, TeGeomRep visRep, const string &objId2, TeGeometryVect &geomVect)
| Returns the symmetrical difference between a geometry of a geometric table (actGeomTable) and a geometry of other geometric table (visGeomTable)

## Friends

class | TeOracleSpatialPortal

## Detailed Description

A concrete implementation of a interface driver to the ORACLE SPATIAL DBMS.

This class contains attributes and methods to implement a driver of interface between TerraLib and ORACLE SPATIAL DBMS using OCI (Oracle Call Interface) library.

See also:
  TeOCIOracle TeOCIConnect

## Constructor & Destructor Documentation

TeOracleSpatial::TeOracleSpatial | ( |  | ) |

Constructor.

TeOracleSpatial::~TeOracleSpatial | ( |  | ) | `[inline]`

Destructor.

## Member Function Documentation

bool TeOracleSpatial::allocateOrdinatesObject | ( | TePolygon & | poly,
|  | string & | elInfo,
|  | TeOCICursor * | cursor = `0`
| ) |  |

bool TeOracleSpatial::allocateOrdinatesObject | ( | TeLine2D & | line,
|  | TeOCICursor * | cursor = `0`
| ) |  |

bool TeOracleSpatial::buffer | ( | const string & | actGeomTable,
|  | TeGeomRep | actRep,
|  | TeKeys & | actIds,
|  | TePolygonSet & | bufferSet,
|  | double | dist
| ) |  | `[virtual]`

Returns the buffers with a specific distance of a geometry set of a geometric table (actGeomTable)

Parameters:

  actGeomTable | geometric table name
  actRep | geometric representation of the geometric table
  actIds | identifiers of the geometry set of the actGeomTable table
  bufferSet | the returned buffers
  dist | the distance of the buffers

Reimplemented from TeDatabase.

bool TeOracleSpatial::calculateArea | ( | const string & | actGeomTable,
|  | TeGeomRep | actRep,
|  | TeKeys & | actIdsIn,
|  | double & | area
| ) |  | `[virtual]`

Calculates the area of a geometry set of the geometric table (actGeomTable)

Parameters:

  actGeomTable | geometric table name
  actRep | geometric representation of the geometric table
  actIdsIn | identifiers of the geometry set of the actGeomTable table
  area | the returned area value

Reimplemented from TeDatabase.

bool TeOracleSpatial::calculateDistance | ( | const string & | actGeomTable,
|  | TeGeomRep | actRep,
|  | TeKeys & | Ids,
|  | double & | distance
| ) |  | `[virtual]`

Calculates the distance between two geometries of the actGeomTable table.

Parameters:

  actGeomTable | geometric table name
  actRep | geometric representation of the geometric table
  Ids | identifiers of the two geometries of the actGeomTable table
  distance | the returned distance value

Reimplemented from TeDatabase.

bool TeOracleSpatial::calculateDistance | ( | const string & | actGeomTable,
|  | TeGeomRep | actRep,
|  | const string & | objId1,
|  | const string & | visGeomTable,
|  | TeGeomRep | visRep,
|  | const string & | objId2,
|  | double & | distance
| ) |  | `[virtual]`

Calculates the distance between a geometry of a geometric table (actGeomTable) and a geometry of other geometric table (visGeomTable)

Parameters:

  actGeomTable | geometric table name
  actRep | geometric representation of the actGeomTable table
  objId1 | identifier of the geometry of the actGeomTable table
  visGeomTable | geometric table name
  visRep | geometric representation of the visGeomTable table
  objId2 | identifier of the geometry of the visGeomTable table
  distance | the returned distance value

Reimplemented from TeDatabase.

bool TeOracleSpatial::calculateLength | ( | const string & | actGeomTable,
|  | TeGeomRep | actRep,
|  | TeKeys & | actIdsIn,
|  | double & | length
| ) |  | `[virtual]`

Calculates the length of a geometry set of the actGeomTable table.

Parameters:

  actGeomTable | geometric table name
  actRep | geometric representation of the geometric table
  actIdsIn | identifiers of the geometry set of the actGeomTable table
  length | the returned length value

Reimplemented from TeDatabase.

bool TeOracleSpatial::centroid | ( | const string & | actGeomTable,
|  | TeGeomRep | actRep,
|  | TePointSet & | centroidSet,
|  | TeKeys | actIds = `vector<string>()`,
|  | const string & | actCollTable = `""`
| ) |  | `[virtual]`

Returns the centroids of a geometry set of a geometric table (actGeomTable)

Parameters:

  actGeomTable | geometric table name
  actRep | geometric representation of the geometric table
  centroidSet | the returned centroids
  actIds | identifiers of the geometry set of the actGeomTable table
  actCollTable | collection table name associated with the actGeomTable table

Reimplemented from TeDatabase.

bool TeOracleSpatial::connect | ( | const string & | host,
|  | const string & | user,
|  | const string & | password,
|  | const string & | database,
|  | int | port = `-1`
| ) |  | `[virtual]`

Connects to Oracle Spatial DBMS.

Reimplemented from TeOCIOracle.

bool TeOracleSpatial::convexHull | ( | const string & | actGeomTable,
|  | TeGeomRep | actRep,
|  | TeKeys & | actIds,
|  | TePolygonSet & | convexHullSet
| ) |  | `[virtual]`

Returns the convex geometries of a geometries set of a geometric table (actGeomTable)

Parameters:

  actGeomTable | geometric table name
  actRep | geometric representation of the geometric table
  actIds | identifiers of the geometry set of the actGeomTable table
  convexHullSet | the returned convex geometries

Reimplemented from TeDatabase.

bool TeOracleSpatial::createSpatialIndex | ( | const string & | table,
|  | const string & | column,
|  | TeSpatialIndexType | type = `TeRTREE`,
|  | short | level = `0`,
|  | short | tile = `0`
| ) |  | `[virtual]`

Creates a spatial index to a specific geometry table.

Reimplemented from TeDatabase.

bool TeOracleSpatial::createTable | ( | const string & | table,
|  | TeAttributeList & | attr
| ) |  | `[virtual]`

Creates a new table.

Reimplemented from TeOCIOracle.

bool TeOracleSpatial::generateLabelPositions | ( | TeTheme * | theme,
|  | const std::string & | objectId = `""`
| ) |  | `[virtual]`

Generates label positions to each object of a theme.

Reimplemented from TeOCIOracle.

bool TeOracleSpatial::geomDifference | ( | const string & | actGeomTable,
|  | TeGeomRep | actRep,
|  | const string & | objId1,
|  | const string & | objId2,
|  | TeGeometryVect & | geomVect
| ) |  | `[virtual]`

Returns the difference between two geometries of a geometric table (actGeomTable)

Parameters:

  actGeomTable | geometric table name
  actRep | geometric representation of the actGeomTable table
  objId1 | identifier of a geometry of the actGeomTable table
  objId2 | identifier of other geometry of the actGeomTable table
  geomVect | the returned difference

Reimplemented from TeDatabase.

bool TeOracleSpatial::geomDifference | ( | const string & | actGeomTable,
|  | TeGeomRep | actRep,
|  | const string & | objId1,
|  | const string & | visGeomTable,
|  | TeGeomRep | visRep,
|  | const string & | objId2,
|  | TeGeometryVect & | geomVect
| ) |  | `[virtual]`

Returns the difference between a geometry of a geometric table (actGeomTable) and a geometry of other geometric table (visGeomTable)

Parameters:

  actGeomTable | geometric table name
  actRep | geometric representation of the actGeomTable table
  objId1 | identifier of a geometry of the actGeomTable table
  visGeomTable | geometric table name
  visRep | geometric representation of the visGeomTable table
  objId2 | identifier of other geometry of the visGeomTable table
  geomVect | the returned difference

Reimplemented from TeDatabase.

bool TeOracleSpatial::geomIntersection | ( | const string & | actGeomTable,
|  | TeGeomRep | actRep,
|  | TeKeys & | actIds,
|  | TeGeometryVect & | geomVect
| ) |  | `[virtual]`

Returns the intersection between two geometries of a geometric table (actGeomTable)

Parameters:

  actGeomTable | geometric table name
  actRep | geometric representation of the actGeomTable table
  actIds | identifiers of the geometry set of the actGeomTable table
  geomVect | the returned intersection

Reimplemented from TeDatabase.

bool TeOracleSpatial::geomIntersection | ( | const string & | actGeomTable,
|  | TeGeomRep | actRep,
|  | const string & | objId1,
|  | const string & | visGeomTable,
|  | TeGeomRep | visRep,
|  | const string & | objId2,
|  | TeGeometryVect & | geomVect
| ) |  | `[virtual]`

Returns the intersection between a geometry of a geometric table (actGeomTable) and a geometry of other geometric table (visGeomTable)

Parameters:

  actGeomTable | geometric table name
  actRep | geometric representation of the actGeomTable table
  objId1 | identifier of a geometry of the actGeomTable table
  visGeomTable | geometric table name
  visRep | geometric representation of the visGeomTable table
  objId2 | identifier of other geometry of the visGeomTable table
  geomVect | the returned intersection

Reimplemented from TeDatabase.

bool TeOracleSpatial::geomUnion | ( | const string & | actGeomTable,
|  | TeGeomRep | actRep,
|  | TeKeys & | actIds,
|  | TeGeometryVect & | geomVect
| ) |  | `[virtual]`

Returns the union between geometries of a geometric table (actGeomTable)

Parameters:

  actGeomTable | geometric table name
  actRep | geometric representation of the actGeomTable table
  actIds | identifiers of the geometry set of the actGeomTable table
  geomVect | the returned union

Reimplemented from TeDatabase.

bool TeOracleSpatial::geomUnion | ( | const string & | actGeomTable,
|  | TeGeomRep | actRep,
|  | const string & | objId1,
|  | const string & | visGeomTable,
|  | TeGeomRep | visRep,
|  | const string & | objId2,
|  | TeGeometryVect & | geomVect
| ) |  | `[virtual]`

Returns the union between a geometry of a geometric table (actGeomTable) and a geometry of other geometric table (visGeomTable)

Parameters:

  actGeomTable | geometric table name
  actRep | geometric representation of the actGeomTable table
  objId1 | identifier of a geometry of the actGeomTable table
  visGeomTable | geometric table name
  visRep | geometric representation of the visGeomTable table
  objId2 | identifier of other geometry of the visGeomTable table
  geomVect | the returned union

Reimplemented from TeDatabase.

bool TeOracleSpatial::geomXOr | ( | const string & | actGeomTable,
|  | TeGeomRep | actRep,
|  | const string & | objId1,
|  | const string & | objId2,
|  | TeGeometryVect & | geomVect
| ) |  | `[virtual]`

Returns the symmetrical difference between two geometries of a geometric table (actGeomTable)

Parameters:

  actGeomTable | geometric table name
  actRep | geometric representation of the actGeomTable table
  objId1 | identifier of a geometry of the actGeomTable table
  objId2 | identifier of other geometry of the actGeomTable table
  geomVect | the returned symmetrical difference

Reimplemented from TeDatabase.

bool TeOracleSpatial::geomXOr | ( | const string & | actGeomTable,
|  | TeGeomRep | actRep,
|  | const string & | objId1,
|  | const string & | visGeomTable,
|  | TeGeomRep | visRep,
|  | const string & | objId2,
|  | TeGeometryVect & | geomVect
| ) |  | `[virtual]`

Returns the symmetrical difference between a geometry of a geometric table (actGeomTable) and a geometry of other geometric table (visGeomTable)

Parameters:

  actGeomTable | geometric table name
  actRep | geometric representation of the actGeomTable table
  objId1 | identifier of a geometry of the actGeomTable table
  visGeomTable | geometric table name
  visRep | geometric representation of the visGeomTable table
  objId2 | identifier of other geometry of the visGeomTable table
  geomVect | the returned symmetrical difference

Reimplemented from TeDatabase.

bool TeOracleSpatial::getMBRGeom | ( | string | tableGeom,
|  | string | object_id,
|  | TeBox & | box,
|  | string | colGeom
| ) |  | `[virtual]`

Return the box of a specific geometry (object_id)

Reimplemented from TeDatabase.

bool TeOracleSpatial::getMBRSelectedObjects | ( | string | geomTable,
|  | string | colGeom,
|  | string | fromClause,
|  | string | whereClause,
|  | string | afterWhereClause,
|  | TeGeomRep | repType,
|  | TeBox & | bout,
|  | const double & | tol = `0.0`
| ) |  | `[virtual]`

Return the box of a select objects set.

Reimplemented from TeDatabase.

TeDatabasePortal * TeOracleSpatial::getPortal | ( |  | ) | `[virtual]`

Gets a cursor using the opened connection.

Reimplemented from TeOCIOracle.

string TeOracleSpatial::getSpatialIdxColumn | ( | TeGeomRep | rep | ) | `[virtual]`

Returns the name of the column that will be spatially indexed, for a given type of geometry table.

Reimplemented from TeDatabase.

string TeOracleSpatial::getSQLBoxSelect | ( | const string & | tableName,
|  | TeGeomRep | rep
| ) |  | `[virtual]`

Return a string SQL to be used in the clause SELECT to select the box (lower_x, lower_y, upper_x, upper_y)

Returns a string SQL to be used in the ORDER BY clause when querying geometries.

Reimplemented from TeDatabase.

string TeOracleSpatial::getSQLBoxWhere | ( | const TeBox & | box,
|  | const TeGeomRep | rep,
|  | const std::string & | tableName
| ) |  | `[virtual]`

Return a string that describes a where clause in SQL to return the geometries inside the box.

Reimplemented from TeDatabase.

string TeOracleSpatial::getSQLBoxWhere | ( | const TeBox & | box,
|  | const TeGeomRep | rep,
|  | const std::string & | tableName,
|  | const std::string & | columnName
| ) |  | `[virtual]`

Return a string that describes a where clause in SQL to return the geometries inside the box.

Reimplemented from TeDatabase.

string TeOracleSpatial::getSQLBoxWhere | ( | const string & | table1,
|  | const string & | table2,
|  | TeGeomRep | rep2,
|  | TeGeomRep | rep1
| ) |  | `[virtual]`

Return a string that describes a where clause in SQL to return the geometries of the table2 that are inside the geometries box of the table1 (table1 must have lower_x, lower_y...)

Reimplemented from TeDatabase.

std::string TeOracleSpatial::getSQLOrderBy | ( | const TeGeomRep & | rep | ) | const`[virtual]`

< Returns a string SQL to be used in the ORDER BY clause when querying geometries.

Reimplemented from TeDatabase.

bool TeOracleSpatial::insertArc | ( | const string & | table,
|  | TeArc & | arc
| ) |  | `[virtual]`

Inserts an arc geometry in the database.

Reimplemented from TeOCIOracle.

bool TeOracleSpatial::insertCell | ( | const string & | table,
|  | TeCell & | c
| ) |  | `[virtual]`

Reimplemented from TeOCIOracle.

bool TeOracleSpatial::insertLine | ( | const string & | table,
|  | TeLine2D & | l
| ) |  | `[virtual]`

Reimplemented from TeOCIOracle.

bool TeOracleSpatial::insertMetadata | ( | const string & | table,
|  | const string & | column,
|  | double | tolx,
|  | double | toly,
|  | TeBox & | box,
|  | short | srid = `0`
| ) |  | `[virtual]`

Inserts the metadata information associated to a specific geometric table in the the USER_SDO_GEOM_METADATA table.

Reimplemented from TeDatabase.

bool TeOracleSpatial::insertNode | ( | const string & | table,
|  | TeNode & | node
| ) |  | `[virtual]`

Reimplemented from TeOCIOracle.

bool TeOracleSpatial::insertPoint | ( | const string & | table,
|  | TePoint & | p
| ) |  | `[virtual]`

Reimplemented from TeOCIOracle.

bool TeOracleSpatial::insertPolygon | ( | const string & | table,
|  | TePolygon & | p
| ) |  | `[virtual]`

Inserts a polygon in a geometry table.

Reimplemented from TeOCIOracle.

bool TeOracleSpatial::insertRasterBlock | ( | const string & | table,
|  | const string & | blockId,
|  | const TeCoord2D & | ll,
|  | const TeCoord2D & | ur,
|  | unsigned char * | buf,
|  | unsigned long | size,
|  | int | band = `0`,
|  | unsigned int | res = `1`,
|  | unsigned int | subband = `0`
| ) |  | `[virtual]`

Insert a raster block into the database.

Parameters:

  table | table name
  blockId | block unique identifier
  ll | block lower left coordinate
  ur | block upper right coordinate
  buf | block binary data
  size | block size
  band | block band
  res | block resolution factor
  subband | sub band definitiion

Reimplemented from TeOCIOracle.

bool TeOracleSpatial::insertText | ( | const string & | table,
|  | TeText & | t
| ) |  | `[virtual]`

Reimplemented from TeOCIOracle.

bool TeOracleSpatial::loadLineSet | ( | const string & | table,
|  | const string & | geoid,
|  | TeLineSet & | ls
| ) |  | `[virtual]`

Reimplemented from TeDatabase.

bool TeOracleSpatial::loadLineSet | ( | const string & | table,
|  | TeBox & | box,
|  | TeLineSet & | linSet
| ) |  | `[virtual]`

Reimplemented from TeDatabase.

TeDatabasePortal * TeOracleSpatial::loadLineSet | ( | const string & | table,
|  | TeBox & | box
| ) |  | `[virtual]`

Reimplemented from TeDatabase.

bool TeOracleSpatial::loadPolygonSet | ( | const string & | table,
|  | const string & | geoid,
|  | TePolygonSet & | ps
| ) |  | `[virtual]`

Returns all polygons that represents objects of a particular geoid.

Reimplemented from TeDatabase.

bool TeOracleSpatial::loadPolygonSet | ( | const string & | table,
|  | TeBox & | box,
|  | TePolygonSet & | ps
| ) |  | `[virtual]`

Returns all polygons inside a given box.

Reimplemented from TeDatabase.

bool TeOracleSpatial::loadPolygonSet | ( | TeTheme * | theme,
|  | TePolygonSet & | ps
| ) |  | `[virtual]`

Returns all polygons that represents objects of a particular theme.

Reimplemented from TeDatabase.

TeDatabasePortal * TeOracleSpatial::loadPolygonSet | ( | const string & | table,
|  | TeBox & | box
| ) |  | `[virtual]`

Returns a database portal to iterate over the polygons that are inside a given box.

Reimplemented from TeDatabase.

bool TeOracleSpatial::locateCell | ( | const string & | table,
|  | TeCoord2D & | pt,
|  | TeCell & | cell,
|  | const double & | tol = `0.0`
| ) |  | `[virtual]`

Reimplemented from TeDatabase.

bool TeOracleSpatial::locateLine | ( | const string & | table,
|  | TeCoord2D & | pt,
|  | TeLine2D & | line,
|  | const double & | tol = `0.0`
| ) |  | `[virtual]`

Reimplemented from TeDatabase.

bool TeOracleSpatial::locatePoint | ( | const string & | table,
|  | TeCoord2D & | pt,
|  | TePoint & | point,
|  | const double & | tol = `0.0`
| ) |  | `[virtual]`

Reimplemented from TeDatabase.

bool TeOracleSpatial::locatePolygon | ( | const string & | table,
|  | TeCoord2D & | pt,
|  | TePolygon & | polygon,
|  | const double & | tol = `0.0`
| ) |  | `[virtual]`

Returns the first polygon that contais a given coordinate.

Reimplemented from TeDatabase.

bool TeOracleSpatial::nearestNeighbors | ( | const string & | actGeomTable,
|  | TeGeomRep | actRep,
|  | const string & | objId1,
|  | const string & | visGeomTable,
|  | const string & | visCollTable,
|  | TeGeomRep | visRep,
|  | TeKeys & | visIdsOut,
|  | int | numRes = `1`
| ) |  | `[virtual]`

Returns the nearest neighbors of a geometric table (visGeomTable) of a specific geometry of other geometric table (actGeomTable)

Parameters:

  actGeomTable | geometric table name
  actRep | geometric representation of the actGeomTable table
  objId1 | identifier of the geometry of the actGeomTable table
  visGeomTable | geometric table name
  visCollTable | collection table name associated with the visGeomTable table
  visRep | geometric representation of the visGeomTable table
  visIdsOut | structure that will contain the identifiers of the nearest neighbors
  numRes | the number of nearest neighbors that will be returned

Reimplemented from TeDatabase.

bool TeOracleSpatial::nearestNeighbors | ( | const string & | actGeomTable,
|  | const string & | actCollTable,
|  | TeGeomRep | actRep,
|  | const string & | objId1,
|  | TeDatabasePortal * | portal,
|  | int | numRes = `1`
| ) |  | `[virtual]`

Returns the nearest neighbors of a specific geometry of a geometric table (actGeomTable)

Parameters:

  actGeomTable | geometric table name
  actCollTable | collection table name associated with the actGeomTable table
  actRep | geometric representation of the geometric table
  objId1 | identifier of the geometry of the actGeomTable table
  portal | a pointer to a database portal that will contain the identifiers of the nearest neighbors
  numRes | the number of nearest neighbors that will be returned

Reimplemented from TeDatabase.

bool TeOracleSpatial::nearestNeighbors | ( | const string & | actGeomTable,
|  | TeGeomRep | actRep,
|  | const string & | objId1,
|  | const string & | visGeomTable,
|  | const string & | visCollTable,
|  | TeGeomRep | visRep,
|  | TeDatabasePortal * | portal,
|  | int | numRes = `1`
| ) |  | `[virtual]`

Returns the nearest neighbors of a geometric table (visGeomTable) of a specific geometry of other geometric table (actGeomTable)

Parameters:

  actGeomTable | geometric table name
  actRep | geometric representation of the actGeomTable table
  objId1 | identifier of the geometry of the actGeomTable table
  visGeomTable | geometric table name
  visCollTable | collection table name associated with the visGeomTable table
  visRep | geometric representation of the visGeomTable table
  portal | a pointer to a database portal that will contain the identifiers of the nearest neighbors
  numRes | the number of nearest neighbors that will be returned

Reimplemented from TeDatabase.

bool TeOracleSpatial::nearestNeighbors | ( | const string & | actGeomTable,
|  | const string & | actCollTable,
|  | TeGeomRep | actRep,
|  | const string & | objId1,
|  | TeKeys & | actIdsOut,
|  | int | numRes = `1`
| ) |  | `[virtual]`

Returns the nearest neighbors of a specific geometry of a geometric table (actGeomTable)

Parameters:

  actGeomTable | geometric table name
  actCollTable | collection table name associated with the actGeomTable table
  actRep | geometric representation of the geometric table
  objId1 | identifier of the geometry of the actGeomTable table
  actIdsOut | structure that will contain the identifiers of the nearest neighbors
  numRes | the number of nearest neighbors that will be returned

Reimplemented from TeDatabase.

bool TeOracleSpatial::removeGeometry | ( | const string & | tableName,
|  | const TeGeomRep & | rep,
|  | const int & | geomId
| ) |  | `[virtual]`

Removes a geometry from the given tableName.

Reimplemented from TeDatabase.

bool TeOracleSpatial::selectPolygonSet | ( | const string & | table,
|  | const string & | criteria,
|  | TePolygonSet & | ps
| ) |  | `[virtual]`

Returns all polygons in a table given a criteria expressed as an SQL where statement.

Reimplemented from TeDatabase.

bool TeOracleSpatial::spatialRelation | ( | const string & | actGeomTable,
|  | TeGeomRep | actRep,
|  | TeKeys & | actIdsIn,
|  | TeDatabasePortal * | portal,
|  | int | relate,
|  | const string & | actCollTable = `""`
| ) |  | `[virtual]`

Returns the geometries of a geometric table (actGeomTable) that have a specific spatial relation (relate) with a subset of geometries of this table (actGeomTable)

Parameters:

  actGeomTable | geometric table name
  actRep | geometric representation of the geometric table
  actIdsIn | identifiers of a geometry subset of the actGeomTable table
  portal | a pointer to a database portal that will contain the resulted geometries
  relate | spatial relation
  actCollTable | collection table name

Reimplemented from TeDatabase.

bool TeOracleSpatial::spatialRelation | ( | const string & | actGeomTable,
|  | TeGeomRep | actRep,
|  | TeGeometry * | geom,
|  | TeKeys & | actIdsOut,
|  | int | relate,
|  | const string & | actCollTable = `""`
| ) |  | `[virtual]`

Returns the geometries of a geometric table (actGeomTable) that have a specific spatial relation (relate) with a geometry in memory (geom)

Parameters:

  actGeomTable | geometric table name
  actRep | geometric representation of the actGeomTable table
  geom | a pointer to a geometry in memory
  actIdsOut | structure that will contain the identifiers of the resulted geometries
  relate | spatial relation
  actCollTable | collection table name associated with the actGeomTable table

Reimplemented from TeDatabase.

bool TeOracleSpatial::spatialRelation | ( | const string & | actGeomTable,
|  | TeGeomRep | actRep,
|  | TeKeys & | actIdsIn,
|  | TeKeys & | actIdsOut,
|  | int | relate,
|  | const string & | actCollTable = `""`
| ) |  | `[virtual]`

Returns the geometries of a geometric table (actGeomTable) that have a specific spatial relation (relate) with a subset of geometries of this table (actGeomTable)

Parameters:

  actGeomTable | geometric table name
  actRep | geometric representation of the geometric table
  actIdsIn | identifiers of a geometry subset of the actGeomTable table
  actIdsOut | structure that will contain the identifiers of the resulted geometries
  relate | spatial relation
  actCollTable | collection table name

Reimplemented from TeDatabase.

bool TeOracleSpatial::spatialRelation | ( | const string & | actGeomTable,
|  | TeGeomRep | actRep,
|  | TeGeometry * | geom,
|  | TeDatabasePortal * | portal,
|  | int | relate,
|  | const string & | actCollTable = `""`
| ) |  | `[virtual]`

Returns the geometries of a geometric table (actGeomTable) that have a specific spatial relation (relate) with a geometry in memory (geom)

Parameters:

  actGeomTable | geometric table name
  actRep | geometric representation of the actGeomTable table
  geom | a pointer to a geometry in memory
  portal | a pointer to a database portal that will contain the resulted geometries
  relate | spatial relation
  actCollTable | collection table name associated with the actGeomTable table

Reimplemented from TeDatabase.

bool TeOracleSpatial::spatialRelation | ( | const string & | actGeomTable,
|  | TeGeomRep | actRep,
|  | TeKeys & | actIdsIn,
|  | const string & | visGeomTable,
|  | TeGeomRep | visRep,
|  | TeDatabasePortal * | portal,
|  | int | relate,
|  | const string & | visCollTable = `""`
| ) |  | `[virtual]`

Returns the geometries of a geometric table (visGeomTable) that have a specific spatial relation (relate) with a subset of geometries of other geometric table (actGeomTable)

Parameters:

  actGeomTable | geometric table name
  actRep | geometric representation of the actGeomTable table
  actIdsIn | identifiers of a geometry subset of the actGeomTable table
  visGeomTable | geometric table name
  visRep | geometric representation of the visGeomTable table
  portal | a pointer to a database portal that will contain the resulted geometries
  relate | spatial relation
  visCollTable | collection table name associated with the visGeomTable table

Reimplemented from TeDatabase.

bool TeOracleSpatial::spatialRelation | ( | const string & | actGeomTable,
|  | TeGeomRep | actRep,
|  | TeKeys & | actIdsIn,
|  | const string & | visGeomTable,
|  | TeGeomRep | visRep,
|  | TeKeys & | visIdsOut,
|  | int | relate,
|  | const string & | visCollTable = `""`
| ) |  |

bool TeOracleSpatial::updateCell | ( | const string & | table,
|  | TeCell & | c
| ) |  | `[virtual]`

Reimplemented from TeDatabase.

bool TeOracleSpatial::updateLine | ( | const string & | table,
|  | TeLine2D & | l
| ) |  | `[virtual]`

Reimplemented from TeOCIOracle.

bool TeOracleSpatial::updateNode | ( | const string & | table,
|  | TeNode & | node
| ) |  | `[virtual]`

Reimplemented from TeDatabase.

bool TeOracleSpatial::updatePoint | ( | const string & | table,
|  | TePoint & | p
| ) |  | `[virtual]`

Reimplemented from TeDatabase.

bool TeOracleSpatial::updatePolygon | ( | const string & | table,
|  | TePolygon & | p
| ) |  | `[virtual]`

Updates a polygon in a geometry table.

Reimplemented from TeOCIOracle.

## Friends And Related Function Documentation

friend class TeOracleSpatialPortal`[friend]`

The documentation for this class was generated from the following files:

- E:/Projetos_Primeiro_Semestre_2012/TerraView/terralib/src/terralib/drivers/Oracle/TeOracleSpatial.h
- E:/Projetos_Primeiro_Semestre_2012/TerraView/terralib/src/terralib/drivers/Oracle/TeOracleSpatial.cpp

All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Friends Defines