Writing Excel Spreadsheets files from within the Oracle database using Java and PL/SQL

My EXPORTER package + Java code has functions called WriteExcelSpreadsheet that can be used to create and export any SQL SELECT statement to disk as an Excel Spreadsheet using Oracle database’s DBMS_JOB or DBMS_SCHEDULER. Because Excel Spreadsheets have limited number of rows (65535) and columns (255) per sheet (the maximum size of data in aRead More

Geometry Snapping using JTS in Oracle

In my exploration of the possibilities of using Java Topology Suite’s (JTS) robust algorithms with Oracle SDO_GEOMETRY I have moved to expose three methods within JTS’s GeometrySnapper (com.vividsolutions.jts.operation.overlay.snap) class: snap – Snaps two geometries to each other with both being able to move. snapTo – Snaps the vertices of the source geometry to the verticesRead More

Exposing JTS’s MinimumBoundingCircle functionality

Today I decided to expose the Java Topology Suite’s (JTS) MinimumBoundingCircle functionality via the Spatial Companion For Oracle (SC4O) installer and package. The MinimumBoundingCircle PL/SQL wrappers I have created are: Here are some examples. Now let’s test and visualise some lines and circles. Which look like: 1. Line !http://www.spatialdbadvisor.com/images/134.png! 2. Rectangle !http://www.spatialdbadvisor.com/images/135.png! I hope thisRead More

Using JTS’s Comparison Functions – HausdorffSimilarityMeasure & AreaSimilarityMeasure with SDO_GEOMETRY

There is often a need to compare SDO_GEOMETRYs to see if a geometry has changed or not. The SDO_GEOM.RELATE function is useful in this regards where two geometries are EQUAL but it is not fine-grained enough to help understand how different two things are. The Java Topology Suite (JTS) has two very useful match algorithmsRead More

Standalone CENTROID package now available for download

My CENTROID package is very popular but people have to download the spatialdbadvisor_oracle_spatial_types_and_packages.zip package to get it. I have now created a standalone download for the CENTROID package. This is available from the Download Code, Packages and Installers link on the Source Code Documentation / Download on the main page. This package contains: CENTROID_package.sql CENTROID_package_test.sqlRead More