Spatial Companion For Oracle – Java Classic Edition (SC4OJCE)

$9.50 (inc. GST Australia)

The Spatial Companion For Oracle (SC4O) 12.1 Edition, is a a set of Java Stored Procedures from the well known Java Topology Suite with extensions from the JASPA project (mainly 3D WKT/WKB functions). Some functions (ST_Union etc) provide Locator users of Oracle before 12c access to otherwise Spatial functionality. Some of these functions provide an implementation that is more in line with the results provided on other database platforms (such as PostgreSQL/PostGIS). SC4O also provides for some advanced functionality such as ST_PolygonBuilder.

Description

The Spatial Companion For Oracle – Java Classic Edition (SC4OJCE), provides a version of SC4O with all Java Stored Procedures including the aggregation functions.

This edition should not be used on Oracle 12.2. If an incorrect selection occurs, please contact me for a replacement installation script.

Functions

SC4O
* For versions of Oracle before 12.2
* 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.

Be the first to review “Spatial Companion For Oracle – Java Classic Edition (SC4OJCE)”

Your email address will not be published. Required fields are marked *