Top 5 Recent Articles
ARTICLES CATEGORIES
- Algorithms (20)
- All (400)
- Biography (1)
- Blog (45)
- Business Requirements (1)
- Commentary (1)
- 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) (4)
- Open Source (18)
- Oracle Spatial and Locator (193)
- Partitioning (1)
- PostGIS (34)
- Projections (1)
- Published Articles (1)
- qGIS (1)
- Recommendations (1)
- Services (1)
- Software Change Log (1)
- Source Code (35)
- Space Curves (9)
- Spatial Database Functions (108)
- Spatial DB comparison (1)
- Spatial XML Processing (11)
- SQL Server Spatial (92)
- Standards (3)
- Stored Procedure (15)
- Tessellation or Gridding (10)
- Tools (2)
- Topological Relationships (1)
- Training (2)
- Triangulation (2)
Fixing Geography Ring Orientation
This article demonstrates the effect wrong ring orientation has on the processing of a geography object and shows how to fix such orientation.
30 December, 2022
No Comments
Removing Duplicate Vertices in SQL Server Spatial
This article shows how to remove duplicate vertices/point in SQL Server Spatial geometry objects.
23 October, 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 18+: Downloading and Installing beta
Installing GeoRaptor for SQL Developer 18+ GeoRaptor is available as a full installable download from this site. Otherwise it can also be compiled from the
7 April, 2021
No Comments
Oracle Spatial Vector Acceleration: Flick the Switch
Introduction A lot has been written, positive and negative, about the speed of Oracle Spatial over the years, a lot of ill informed (I mean
18 January, 2021
No Comments
Linear Referencing System (LRS) Functions for TSQL
This articles logically steps through all the functions in a complete package of Linear Referencing functions that I have written for TSQL. The article both demonstrates the power of SQL Server Spatial but what can be done with TSQL.
6 December, 2020
No Comments
CheckRadii: Identifying Tight Radius Curves sections within LineString geometry data
Sometimes it is a data quality requirement for linear data (roads, pipelines, transmission lines) that curves within the lines must have a radius greater than
30 November, 2020
No Comments
Overlaying Polygons in SQL Server Spatial
Introduction The OGC operators for geometry processing only support two polygon inputs. Additionally the Microsoft aggregate operators only include geometry union processing geometry::UnionAggregate and not
25 November, 2020
No Comments
Space Filling Curve Functions For TSQL
Introduction Warning: This article is long mainly because it includes the source code of the Hilbert, Morton and Peano key/curves. I would assert that space
22 November, 2020
No Comments