Oracle Java Topology Suite + Exporter Java Stored Procedures

Description

The Spatial Companion For Oracle (SC4O) Java Topology Suite + Exporter, is a set of Java Stored Procedures which expose Java Topology Suite functions (and a few functions from the JASPA project, mainly 3D WKT/WKB functions).

This package includes all the Exporter functions.

Exporter (Java Stored Procedures):

Documentation of the Exporter functions can be seen at this link EXPORTER Function Documentation

A simple summary is as follows:

* 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 documentation for the SC4O JTS functions can be seen by clicking SC4O Function Documentation

A simple summary of the functions is as follows:

* 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_OffsetLine – Offsets a linestring by the required value with optional styling.
* ST_OneSidedBuffer – Creates a buffer polygon on one side of the supplied line with optional styling.
* 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.