qGIS, GEOMETRY_COLUMNS and SQL Server Spatial
This article recommends using the GEOMETRY_COLUMNS metadata table to control access to feature tables and their geometry properties for qGIS.
Year: 2021
Removing Duplicate Vertices in SQL Server Spatial
This article shows how to remove duplicate vertices/point in SQL Server Spatial geometry objects.
Visualising the Topological Relations of LineStrings
This post generates and visualizes all the topological relationships possible between two linestrings.
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.
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.