Split Oracle Sdo_Geometry Linestring at a Known Point using PL/SQL (1)
This article describes how to split a linestring or a multilinestring using PL/SQL at a known point.
PL/SQL
Create GeoJSON Document from Selection of SDO_Geometry objects.
This article shows how to create a GeoJSON Document from Selection of SDO_Geometry objects.
Using Oracle’s ST_GEOMETRY type hierarchy with SDO_GEOMETRY: ST_PointN and ST_NumPoints
Oracle Spatial has, for many versions, made available an implementation of the OpenGIS SFS type hierarchy. Today I will show how to use this type hierarchy do extract points from an SDO_GEOMETRY. The first example extracts the first and last point from a linestring constructed from Well Known Text. The second example finds the firstRead More
PLSQL ST_AsEWKT and ST_FromWKT Functions For Oracle (any version)
Previously I created the following Java stored procedures to enable the import/export of ZM aware WKT. ST_GeomFromText ST_GeomFromEWKT ST_AsText ST_AsEWKT These functions are necessary if one wishes to exchange geometry data with users of other databases that support WKT functions for 2D, 3D or 4D (ZM). For example, PostGIS supports the EWKT format and providesRead More
Simple Oracle C Sprintf or Java String.format
It is amazing what one finds inside an Oracle database! When writing pl/sql code I often have need to print out formatted strings. I have often wanted Oracle to have an equivalent to the C sprintf or Java format functions. Well, just the other day I discovered: See Format Message You will note from theRead More
Some Oriented Point Functions
A reader asked me for some help constructing and querying oriented points a few months back. The functions I created for him were one to create an oriented point from an normal point and a supplied whole circle bearing (0-360 degrees); the other was one that, given an oriented point, computed what they orientation angleRead More
Extracting Inner Rings Changed Ordinate Ordering: A Trap For Players Who Don’t Read Documentation!
In Developing Some Ideas For The Compression/Decompression Of Sdo_Geometry Objects, I Had Cause To Create Two PL/SQL Functions called Geocompress and Geodecompress. I Have Not Done This For A While And Slapped Myself When I Ran Into something I Should Have Known Would Arise, as I have seen it before, and because it is documentedRead More
Changing all DIMINFO sdo_tolerance values for all metadata records in one go.
Someone contacted me about having to change all the tolerances in their user_sdo_geom_metadata due to a need to change each sdo_tolerance value from 0.005 (1cm) to 0.0005 (1mm) meters. I hope this helps someone out there…
Selecting all SDO_GTYPE values for all tables/sdo_geometry columns in a schema
A question was asked on the Oracle Technology Network Spatial forum: I am trying to select sdo_gtype from all tables in schema, i mean to execute same sql statement given below for entire schema. Any help on the usage of dynamic sql in PLSQL to execute select statement for all tables in the schema. HereRead More
Finding centre and radius of a circular geometry
Here is a method for finding the centre of a circle and its radius from a polygon (x003) sdo_geometry. Some examples: The SDO_UTIL.CIRCLE_POLYGON function is trickier because it generates 8307 longitude/latitude data. So the above function, based as it is on projected data, can only give us a basic approximation. The returned radius is goingRead More