## Description

The **Spatial Companion For Oracle (SC4O) 12.1 Complete Edition**, is a set of Java Stored Procedures based on the well known Java Topology Suite with extensions from the JASPA project (mainly 3D WKT/WKB functions) with all **Exporter** functions.

**Exporter** (Java Stored Procedures):

* LoadShapefile – Procedure that load an ESRI shapefile from an existing directory

* WriteShapefile – Procedure that writes an ESRI shapefile from an existing refcursor or SQL SELECT statement (string)

* WriteTabfile – Procedure that writes a MapInfo TAB from an existing refCursor or SQL SELECT statement (string)

* ExportTables – Procedure that writes a collection of tables with geometry columns to disk

* WriteDelimitedTextfile – Procedure that writes a result set (including one or more sdo_geometry objects), or SQL SELECT statement (string) – as a delimited text file eg csv.

* WriteExcelSpreadsheet – Creates and writes an Excel (XLS) spreadsheet from the passed in resultSet or SQL SELECT statement (string)

* WriteKMLFile – Writes a KML file from resultset or SQL SELECT statement (string)

* WriteGeoJson – Writes a GeoJSON file from resultset or SQL SELECT statement (string)

* WriteGMLFile – Writes a GML file from resultset or SQL SELECT statement (string)

**SC4O** (Java Stored Procedures):

The latest test log for SC4O Functions can be seen at my main blog site.

* 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 precision model

* ST_Difference – Computes difference between two geometries using supplied 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 supplied 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 supplied 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 supplied 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.