Skip to content

The Spatial Database Advisor

Spatial Solutions Architect and Database Expert

0 $0.00
Primary Menu
  • Home
  • Articles
    • MySQL SpatialArticles about MySQL Spatial Functions.
    • Oracle Spatial and Locator
    • PostGIS
    • SQL Server Spatial
    • Software Change LogDescribes changes to packaged software.
    • Spatial Database Functions
  • About
  • Contact
  • Shop
0 $0.00
x
  • Login/Register
Home / Spatial Database Functions / Page 4

Top 5 Recent Articles

Removing Duplicate Vertices in SQL Server Spatial

Split Oracle Sdo_Geometry Linestring at a Known Point using SDO_LRS and PL/SQL (2)

Split Oracle Sdo_Geometry Linestring at a Known Point using PL/SQL (1)

GeoRaptor 18+: Downloading and Installing beta

Oracle Spatial Vector Acceleration: Flick the Switch

ARTICLES CATEGORIES
  • Algorithms (19)
  • 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)
  • 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 (11)
  • SQL Server Spatial (91)
  • Standards (3)
  • 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

Read More »
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)

Read More »
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.

Read More »
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

Read More »
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.

Read More »
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

Read More »
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

Read More »
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.

Read More »
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

Read More »
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

Read More »
27 July, 2020 No Comments
Page1 Page2 Page3 Page4 Page5

Documentation

  • MySQL Spatial General Function Documentation
  • Oracle LRS Object Documentation
  • Oracle Spatial Exporter Package Documentation
  • Oracle Spatial Object Function Documentation
  • Oracle Spatial Object Function Documentation (Multi Page Version)
  • PostGIS pl/pgSQL Function Documentation
  • SC4O Oracle Java Topology Suite (Stored Procedures) Package Documentation
  • SQL Server Spatial General TSQL Function Documentation
  • SQL Server Spatial LRS TSQL Function Documentation
© The Spatial Database Advisor 2019