Indicates whether download includes source code.
Folks, I have ported some of my spatial functions to MySQL. The best way to see what is available is to peruse the Documentation I will release short articles on how to use each one as I get time. Please let me know if you are interested in accessing these functions, or you have ideasRead More
The populate CENTROID package has been modified. It now allows the caller of the CENTROID_A function to invoke Y ordinate seeding. This is what it looks like. I hope this enhancement is of use to someone.
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
Java classes loaded into the Oracle JVM are interpreted when executed up to and including Oracle 10gR2. For Oracle 11g and upwards, these loaded Java classes can be compiled to native code. I have added the optional compilation of my JTS Java wrappers and the source JTS classes to the JTS installer. The installation isRead More
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
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
I created a densify function within my GEOM package in pure PL/SQL many years ago. Today I decided to expose the Java Topology Suite’s (JTS) Densifier functionality via the Spatial Companion For oracle (SC4O) installer and package. The Densify PL/SQL wrappers I have created are: Here is an example using a 3 point line. WhichRead More
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
One way of providing an area and length capability for Oracle 10g that is free from licensing issues is to use Java Topology Suite’s (JTS) GetArea() and GetLength() functions. Being as I have already created the framework with the Spatial Companion For Oracle (SC4O) package and installer I have added access to JTS Area andRead More
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