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