Object Implementation of Oracle SDO_LRS
This article describes how to repackage the functionality in the SDO_LRS package via an PL/SQL object to provide a cleaner neater API.
Articles
Split Oracle Sdo_Geometry Linestring at a Known Point using SDO_LRS and PL/SQL (2)
This article shows how to construct a function that allows any linestring to be split by any point using a collection of SDO_LRS procedures and functions.
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.
GeoRaptor: Direct Display of SDO_GEOMETRY / WKT text objects
This article shows how to use GeoRaptor’s Jump to Geometry functionality to conduct “one off” mapping of SDO_GEOMETRY and EWKT/WKT text objects. PostGIS is shown as a source for EWKT showing how to integrate development across multiple databases.
Snapping a Point to an Oracle Spatial SDO_GEOMETRY LineString
This article shows how to snap a point to an Oracle Spatial linear geometry using the SDO_CLOSEST_POINTS procedure and function
GeoRaptor: Layer Properties
This page describes all the elements of the layer properties dialog used to style spatial data in a GeoRaptor map view.
GeoRaptor: Exporting GeoJSON and viewing in Tatuk GIS Viewer
This article shows how to export SDO_GEOMETRY data from Oracle to GeoJSON using GeoRaptor and SQL Developer with visualisation in the free Tatuk GIS Viewer.
GeoRaptor: Exporting GML and visualising in qGIS
GML Export and qGIS Visualisation This article shows how to export GML from SQL Developer table and resultset (query) objects using GeoRaptor. It also shows how to use the “OGR” flavour for encoding attributes (columns). And, finally, it shows how to open the GML files in qGIS and to query features to show their attributes.
GeoRaptor: Area Rendering Options
This article shows how to use GeoRaptor to render area or polygon objects using area, linear, point and text styles.
GeoRaptor: Views and On The Fly Projection
This article demonstrates demonstrated “on the fly” projection via use of multiple views to map geographic data.