Top 5 Recent Articles
ARTICLES CATEGORIES
- Algorithms (22)
- All (399)
- Biography (1)
- Blog (44)
- Business Requirements (1)
- Commentary (1)
- Conversion (2)
- Customers (2)
- Data Models (1)
- Education (2)
- GeoRaptor (13)
- GPS (1)
- Image Processing (2)
- Import Export (8)
- Licensing (2)
- LiDAR (1)
- Linear Referencing (4)
- Manifold GIS (3)
- Mapping (1)
- MySQL Spatial (7)
- Networking and Routing (including Optimization) (5)
- Open Source (18)
- Oracle Spatial and Locator (194)
- Partitioning (1)
- PostGIS (36)
- Projections (1)
- Published Articles (1)
- qGIS (1)
- Recommendations (1)
- Services (1)
- Software Change Log (1)
- Source Code (37)
- Space Curves (9)
- Spatial Database Functions (109)
- Spatial DB comparison (1)
- Spatial XML Processing (11)
- SQL Server Spatial (92)
- Standards (3)
- Stored Procedure (17)
- Tessellation or Gridding (10)
- Tools (2)
- Topological Relationships (1)
- Training (2)
- Triangulation (2)
Creating linestring geometries from a table of ordinates (Oracle)
Introduction (This article is about Oracle Spatial.) It is quite a common thing to have ordinates held as separate columns within a table as in
18 April, 2022
No Comments
How to calculate cumulative length of a linestring, or the truck tonnage that accumulates across a set of roads
This articles describes how to compute the cumulative length of a single linestring, or the total tonnage that crosses a set road segments.
22 March, 2022
No Comments
Visualising the Topological Relations of LineStrings
This post generates and visualizes all the topological relationships possible between two linestrings.
17 September, 2021
No Comments
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.
5 July, 2021
No Comments
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.
30 June, 2021
No Comments
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.
30 June, 2021
No Comments
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.
28 June, 2021
No Comments
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
26 June, 2021
No Comments
GeoRaptor
GeoRaptor: Layer Properties
This page describes all the elements of the layer properties dialog used to style spatial data in a GeoRaptor map view.
31 May, 2021
No Comments
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.
26 May, 2021
No Comments