The ST_PolygonBuilder function in the Spatial Companion for Oracle (SC4O) package provides a mechanism via which linestring can be compiled into polygons. I have given some simple examples in a post I made a few years ago. I will now give a much more complex example that I wrote in response to a request onRead More
Over the past 6 months or so I have been developing a set of functions, based on the Java Topology Suite (JTS) and JAvaSPAtial (Jaspa), which complement or extend the Oracle’s proprietary functions that process its SDO_Geometry objects. These functions were initially released using a PL/SQL package and related Java class called JTS. As theRead More
One of the geoprocessing functions that seems to be poorly implemented is the ability to clip a polygon using one or more linestrings such that the result is a number of polygons. Here is an example of someone asking for help on the Oracle Technology Network’s Spatial forum: I have a task where i haveRead More
I have just added to my Java Spatial For Oracle (JS4O) project exposure of the JTS/Jaspa functions for: ST_IsValid ST_IsSimple ST_Dimension ST_CoordDim Here are the type signatures in the JTS PL/SQL package. Here is a test of these functions. I hope this is helpful to someone.
One activity that is very common when working with linear data is to be able to take a bunch of linestrings and collect them together into a minimal set of maximum length linestrings. The Java Topology Suite (JTS) has a LineMerger class that does this very nicely. I have integrated this into my Spatial CompanionRead More
Oracle Spatial does not read or write 3D Well-known text (WKT); nor does it read/write measures. Oracle’s SDO_Geometry implementation only supports the OGC Simple Features 1.1 specification which is 2D only. What I have done is expose the Jaspa/JTS implementation of methods more 3D+ aware to PL/SQL and therefore SQL via my Spatial Companion forRead More
The following package requires the appropriate JAR files to be loaded into the Oracle database JVM. All the required files and installation instructions are available from the package download page. Fill in and submit the form to get access the actual download links. This package provides access to a bunch of JTS and JASPA functions:Read More