Identifying Quadrilateral Polygon Geometries in SQL Server Spatial

In some situations Quadrilateral polygon geometries in SQL Server Spatial can affect processing results. The best example of this is the identification of CircularStrings in polygon geometries. If quadrilateral objects are not identified, they end up being incorrectly converted. This function helps identify such polygon objects.

STLineToCurve. A Function that Converts a LineString to a CircularString, CompoundCurve or CurvePolygon.

The STLineToCurve function analyses a LineString looking for CircularString elements among its vertices (often LineStrings are created from curve elements by “stroking” especially where the processing software does not support CircularStrings). Any constructed CircularStrings are combined with other LineStrings to create CompoundCurves or CurvePolygons.

Implementing Point-based Costs in pgRouting

Implementing Point-based Costs in pgRouting pgRouting is a great tool but it does have certain limitations. One limitation is that one cannot have costs at specific nodes. All costs have to be edge based. Discussion on Node/Edge Costs in pgModeler For example, suppose a network has a stop valve between two pipes. Normally the stopRead More

Using SQL Server XML and Spatial to import VicMap seed/Incremental Update Format (IUF) data (Part 3)

This is the 3rd and last blog post about processing VicMap IUF XML data. (The 6 month delay is because I lost a draft of this article, and have been doing other things.) While much in this and the previous articles are about an Australian XML data format, the principles outlined remain the same. ThisRead More

Spatially Extending Database Management and Development Tools: GeoRaptor, DBeaver, pgAdmin and SSMS

“Imitation is the Greatest Form of Flattery” Before I talk about SSMS, pgAdmin and DBeaver spatial visualisation solutions, some history about the first spatial tool that extended a (non-GIS) database management and development tool: GeoRaptor. GeoRaptor History Many years ago a visionary programmer added spatial capabilities to SQL Developer 0.9, calling his extension GeoRaptor (theRead More

There’s Network Analysis, and then there IS Network Analysis

Solutions are built by layering technology, from the simple to the complex. Nothing more illustrates this than considering network analysis. Firstly, most Geographic Information Systems (insert your favorite here), and database vendors like Oracle and PostgreSQL/PostGIS provide a basic routing engine. And what they offer is generally basic: a network or graph model, functions forRead More