## Description

The **Spatial Companion For Oracle – Java Classic Edition (SC4OJCE)**, provides a basic port of the *Java Topology Suite* (JTS) for use in the Oracle database. A set of example Java Stored Procedures (SC4O Package) are supplied which show how to expose certain JTS functions to PL/SQL and SQL users.

**Functions**

Documentation of the SC4O functions can be seen at this link SC4O Function Documentation

A simple summary of the SC4O functions is as follows:

* ST_AggrUnionMixed – Unions a set of sdo_geometry objects (can be mix of polygons, lines etc).

* ST_AggrUnionPolygons – Unions a set of sdo_geometry polygons.

* ST_Area – Computes area of supplied geometry.

* ST_AreaSimilarityMeasure – Measures the degree of similarity between two geometries using the area of intersection between the geometries.

* ST_AsBinary – Creates Well Known Binary (WKB) from SDO_GEOMETRY Object

* ST_AsEWKB – Creates Extended Well Known Binary (WKB) from SDO_GEOMETRY Object

* ST_AsEWKT – Creates Extended Well Known Text (EWKT) from SDO_GEOMETRY Object

* ST_AsGML – Creates GML from SDO_GEOMETRY Object

* ST_AsText – Creates Well Known Text (WKT) from SDO_GEOMETRY Object

* ST_Buffer – Buffer a geodetic geometry using variety of parameters including single siding.

* ST_Centroid – Calculates centroid of polygon

* ST_Collect – Takes input geometries and returns a single geometry collection

* ST_ConvexHull – Creates a convex hull for collection of input points.

* ST_CoordDim – Number of ordinates (xyzm) that describe a vertex of a geometry

* ST_CoordinateRounder – Method for rounding the coordinates of a geometry to a particular precision

* ST_DelaunayTriangles – Method for creating a delaunay triangulation from a geometry input (eg multipoints)

* ST_DeleteVertex – Removes point/vertex from input geometry.

* ST_Densify – Densifies a geometry using a given distance tolerance, and respecting the input geometry’s PrecisionModel

* ST_Difference – Computes difference between two geometries using suppied p_precision to compare coordinates.

* ST_Dimension – Returns geometry dimensionality ie 0 for point, 1 for line, 2 for polygon

* ST_DouglasPeuckerSimplify – Douglas Peucker based simplification

* ST_Envelope – Method for getting MBR or envelope of a geometry object

* ST_GeomFromEWKB – Create SDO_GEOMETRY object from Extended Well Known Binary formatted string.

* ST_GeomFromEWKT – Create SDO_GEOMETRY object from Extended Well Known Text formatted string.

* ST_GeomFromEWKT – Create SDO_GEOMETRY object from Extended Well Known Text formatted string.

* ST_GeomFromGML – Create SDO_GEOMETRY object from Geography Markup Language formatted string.

* ST_GeomFromText – Create SDO_GEOMETRY object from Well Known Text (WKT) formatted string.

* ST_HausdorffSimilarityMeasure – Measures the degree of similarity between two sdo_geometrys using JTS’s Hausdorff distance metric.

* ST_InsertVertex – Adds supplied point geometry at the end of the input geometry

* ST_InterpolateZ – Computes Z ordinate value of a point against a 3 point TNI facet

* ST_Intersection – Computes intersection between two geometries using suppied p_precision to compare coordinates.

* ST_IsSimple – Tests if a linestring self-crosses or not.

* ST_IsValid – Tests if geometry object passes OGC validation rules

* ST_Length – Computes Length of supplied geometry.

* ST_LineMerger – Takes set of linestring geometries and constructs a collection of linear components that form maximal-length linestrings. The linear components are returned as a MultiLineString.

* ST_MakeEnvelope – Method for turning an MBR or envelope into a geometry object (polygon mainly)

* ST_MinimumBoundingCircle – Computes the Minimum Bounding Circle (MBC) for the points in a Geometry.

* ST_NodeLinestrings – Takes a GeometryCollection of linestring geometries and ensures nodes are created at all topological intersections common vertex is inserted into each linestring).

* ST_PolygonBuilder – Method for building a polygon from a set of linestrings

* ST_Relate – Implements a license free version of sdo_geom.RELATE.

* ST_Snap – Snaps both geometries to each other with both being able to move.

* ST_SnapTo – Snaps the vertices in the component LineStrings of the source geometry to the vertices of the given snap geometry.

* ST_SnapToSelf – Snaps the vertices in the component LineStrings of the source geometry to itself.

* ST_SymDifference (wrapper over Xor) – Computes symbolic difference between two geometries using suppied p_precision to compare coordinates.

* ST_TopologyPreservingSimplify – Simplification uses a maximum distance difference algorithm similar to the one used in the Douglas-Peucker algorithm.

* ST_Union – Unions two geodetic geometries together using suppied p_precision to compare coordinates.

* ST_Union – Unions two geometries together using suppied p_precision to compare coordinates.

* ST_UpdateVertex – Changes point/vertex values in input geometry to those of the supplied point geometry

* ST_VisvalingamWhyattSimplify – The Visvalingam-Whyatt algorithm simplifies geometry by removing vertices while trying to minimize the area changed.

* ST_Voronoi – Method for creating a Voronoi diagram from a geometry input (eg multipoints)

* ST_Xor – Computes xor between two geometries using suppied p_precision to compare coordinates.

* ST_isValidReason – Tests if geometry object passes OGC validation rules and returns a textual description of the reason if it fails.

## Reviews

There are no reviews yet.