Top 5 Recent Articles
ARTICLES CATEGORIES
- Algorithms (23)
- All (399)
- Biography (1)
- Blog (45)
- Business Requirements (1)
- Commentary (1)
- Conversion (3)
- Customers (2)
- Data Models (1)
- Education (2)
- GeoRaptor (13)
- GPS (1)
- Image Processing (2)
- Import Export (9)
- Licensing (2)
- LiDAR (1)
- Linear Referencing (4)
- Manifold GIS (3)
- Mapping (2)
- MySQL Spatial (7)
- Networking and Routing (including Optimization) (6)
- Open Source (18)
- Oracle Spatial and Locator (194)
- Partitioning (1)
- PostGIS (38)
- 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 (93)
- Standards (3)
- Stored Procedure (17)
- Tessellation or Gridding (11)
- Tools (2)
- Topological Relationships (1)
- Training (2)
- Triangulation (2)
Generating Road LineStrings with Z (Elevation) through processing involving a Tasmanian statewide Digital Elevation Model (DEM)
This article shows how to create a 3D road centreline dataset from 2D LineStrings for the whole of Tasmania. The elevation data is sourced from a rectangular grid of XYZ points which are converted into three vertex PolygonZ triangles (a form of a TIN). The 2D road centreline LineStrings are converted to 3D by processing each vertex against the triangle it falls in, interpolating the Z value from that triangle, and recompiling a final LineStringZ object from the individual PointZ vertices. The final result is visualized by use of pgAdmin’s Graph Visualizer.
4 September, 2026
No Comments
Best Practice when Loading geographic Polygons into SQL Server Spatial geometry column
This article describes a best practice to loading geographic polygons into SQL Server Spatial geometry column through guaranteeing correct coordinate winding order. It mentions FME’s Orientor transformer as a specific tool for when loading data.
2 September, 2026
No Comments
Functions to Convert Native PostgreSQL geometric types to PostGIS
A set of functions that enable the conversion of the native PostgreSQL geometric types to PostGIS geometry objects.
18 May, 2024
No Comments
Converting PostgreSQL Native Geometric Types to PostGIS
Introduction I comes as a surprise to some that PostgreSQL has it own native geometric type system. The geometric types are documented here but the
17 May, 2024
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
Geometry object size when exchanging of WKT/WKB encoded geometries.
Introduction The ordinates stored in an geometry objects, across all spatial data types do not have any rounding applied to their values. This is one
12 December, 2020
No Comments
Geometry Validity and Method Access
This article demonstrates how an invalid polygon (and linestring) are handled by the different database spatial APIs with correction in TSQL.
6 December, 2020
No Comments
Processing GML data using PostgreSQL’s XMLTABLE
This article shows how to use PostgreSQL’s XMLTABLE XML operator to process GML data and create PostGIS geometries.
1 October, 2020
No Comments
PostGIS: Creating a line inside a polygon
I love working with the PostGIS API. It is a deep and wide river to swim in. But sometime having read, researched, experimented, and not
7 August, 2020
No Comments
Spatial Representation of a Communications Pit
This article describes the elements of a telecommunications pit and shows how they can be spatially represented. In particular the concept of a butterfly as a method for displaying the walls of a pit is introduced.
7 August, 2020
No Comments