Top 5 Recent Articles
ARTICLES CATEGORIES
- Algorithms (13)
- All (401)
- Biography (1)
- Blog (44)
- Business Requirements (1)
- Commentary (1)
- Customers (2)
- Data Models (1)
- Education (2)
- GeoRaptor (12)
- Image Processing (2)
- Import Export (8)
- Licensing (2)
- Linear Referencing (3)
- Manifold GIS (3)
- Mapping (1)
- MySQL Spatial (7)
- Networking and Routing (including Optimization) (3)
- Open Source (18)
- Oracle Spatial and Locator (187)
- PostGIS (33)
- Published Articles (1)
- Recommendations (1)
- Services (1)
- Software Change Log (1)
- Source Code (35)
- Space Curves (9)
- Spatial Database Functions (102)
- Spatial DB comparison (1)
- Spatial XML Processing (10)
- SQL Server Spatial (General) (83)
- SQL Server Spatial (LRS) (38)
- Standards (1)
- Stored Procedure (15)
- Tessellation or Gridding (9)
- Tools (2)
- Training (2)
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
Introduction All database spatial types that I have worked with have constructors based on Well Known Text (WKT). When constructing a geometry all those types
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
PGAdmin Finally Has A Spatial Viewer
A great day has arrived for PostgreSQL developers (not just Spatial geeks) in that finally an integrated spatial viewer has been added to PgAdmin 4.3
7 August, 2020
No Comments
Generating a Grid (fishnet) of points or polygons for PostGIS
I wrote an article on Gridding a PostGIS Geometry object a while back. I had cause, recently, to use a variation on this for the
5 August, 2020
1 Comment
R based Delaunay Triangulation Function for PostGIS using the deldir package
Recently I had need of a function in PostgreSQL/PostGIS that generated a set of delaunay triangles from a set of XYZ points. I happened upon
31 July, 2020
No Comments
COGO: Converting Decimal Degrees to Degrees Minutes and Seconds – and back again (PostGIS)
It is useful to have functions for converting from individual degrees, minutes and seconds to a single decimal degree value and back again. Here are
27 July, 2020
No Comments
COGO: Finding centre and radius of a curve defined by three points (PostGIS)
Recently I had need to convert a PL/SQL Oracle Spatial function I created years ago called FindCircle to SQL Server 2008 for use in another
27 July, 2020
No Comments