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 / Tessellation or Gridding

Top 5 Recent Articles

Space Filling Curve Functions For TSQL

Geocoding Points Against a Grid of Cells/Tiles With/out Spatial Operators

TESSELATE and CENTROID package updates

Generating a Grid (fishnet) of points or polygons for PostGIS

Application of Delaunay Triangulation and Inverse Distance Weighting (IDW) in Oracle for Soils Interpolation

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)

Space Filling Curve Functions For TSQL

Introduction Warning: This article is long mainly because it includes the source code of the Hilbert, Morton and Peano key/curves. I would assert that space

Read More »
22 November, 2020 No Comments

Geocoding Points Against a Grid of Cells/Tiles With/out Spatial Operators

This article shows how to geocode points objects against grid cells without using spatial operators. The article also shows how to use space curve values such as generated by a Morton key algorithm as grid cell ids and thus geocodes.

Read More »
19 November, 2020 No Comments

TESSELATE and CENTROID package updates

Today (25th February 2015) I uploaded the following changes to the following packages: 1. TESSELATE Reduce complexity of package interface. Removed all Quad_Tree Initialise procedures

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

Read More »
5 August, 2020 1 Comment

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

STMorton: Creating a Morton Number Space Key Value for Grid Cells

Introduction NOTE: This article is a copy of the original first written in 2010 from my old website. Space curves are imaginary lines that systematically

Read More »
27 July, 2020 No Comments

Gridding a sdo_geometry line/polygon object (Oracle)

A common question that comes up in the various database forums (PostGIS, SQL Server, Oracle) is how to “grid” a linear or polygonal object. By

Read More »
27 July, 2020 No Comments

Gridding a geometry object (PostGIS)

A common question that comes up in the various database forums (PostGIS, SQL Server, Oracle) is how to “grid” a linear or polygonal object. By

Read More »
24 July, 2020 No Comments

Gridding a geometry or geography object (SQL Server Denali)

A common question that comes up in the various database forums (PostGIS, SQL Server, Oracle) is how to “grid” a linear or polygonal object. By

Read More »
24 July, 2020 No Comments

Creating a Grid of Geographic Tiles

Over the years I have made available functions that generate the tiles of a grid given user input. These have been made available in Oracle,

Read More »
18 November, 2019 No Comments

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