Top 5 Recent Articles
ARTICLES CATEGORIES
- Algorithms (15)
- All (399)
- Biography (1)
- Blog (44)
- Business Requirements (1)
- Commentary (1)
- Customers (2)
- Data Models (1)
- Education (2)
- GeoRaptor (13)
- Image Processing (2)
- Import Export (8)
- Licensing (2)
- Linear Referencing (4)
- Manifold GIS (3)
- Mapping (1)
- MySQL Spatial (7)
- Networking and Routing (including Optimization) (3)
- Open Source (18)
- Oracle Spatial and Locator (192)
- PostGIS (34)
- Published Articles (1)
- qGIS (1)
- Recommendations (1)
- Services (1)
- Software Change Log (1)
- Source Code (35)
- Space Curves (9)
- Spatial Database Functions (107)
- Spatial DB comparison (1)
- Spatial XML Processing (10)
- SQL Server Spatial (85)
- Standards (2)
- Stored Procedure (15)
- Tessellation or Gridding (10)
- Tools (2)
- Topological Relationships (1)
- Training (2)
- Triangulation (2)
STVectorize: Break Linestring/Polygon elements into 2 point vectors (or 3 point circular curves)
I demonstrated in this article the usefulness of having a vectorising function in one’s spatial database kitbag (there are Vectorize functions in my CENTROID and
5 August, 2020
No Comments
Function That Returns a Compass Point From a Whole Circle Bearing
This article describes a function that can be used to returns a compass point From a whole circle bearing (0-360)
5 August, 2020
No Comments
Noding and building a polygon from single, overlapping linestrings
The Spatial Companion 4 Oracle (SC4O) package (built using Java Topology Suite components) contains a method called ST_PolygonBuilder that can then form polygons from linestrings.
5 August, 2020
No Comments
Sorting SDO_GEOMETRY data using the ORDER BY clause of a SELECT statement
It is often observed that you cannot use an sdo_geometry object in an ORDER BY clause of a SELECT statement. This is demonstrated below. Test
31 July, 2020
No Comments
R based Delaunay Triangulation Function for PostGIS using the deldir package
This article shows how to create and use an r-based Delaunay triangulation function for postgis using a XYZ supporting version of the deldir package.
31 July, 2020
No Comments
STScale: Function to Scale a geometry object
Here is a simple scaling function for use with SQL Server Spatial’s geometry data type. Now some tests. Results sType geomWKT Scaled2D LINESTRING (0.5 1.5
31 July, 2020
No Comments
STGeometry2MBR/STGeography2MBR: Compute and return MBR ordinates
SQL Server Spatial’s STEnvelope() function returns the minimum bounding rectangle of a geometry object but as a 5 vertex polygon. To access the lower left
31 July, 2020
No Comments
Application of Delaunay Triangulation and Inverse Distance Weighting (IDW) in Oracle for Soils Interpolation
This article shows how to apply Delaunay triangulation and inverse distance weighting (IDW) techniques for soils interpolation in Oracle.
31 July, 2020
No Comments
STExtractPolygon: Extract Polygons from result of STIntersection in SQL Server Spatial
Oracle customers have asked me for help in the past dealing with compound objects or collections that result from thinning or geoprocessing (intersection etc) of
27 July, 2020
No Comments
STRound: Function to round ordinates of a SQL Server Spatial geometry object
The result of many geoprocessing operations in any spatial type can be geometries with ordinates (X, Y etc) that have far more decimal digits of
27 July, 2020
No Comments