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)
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
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.
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
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
5 August, 2020
1 Comment
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
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
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
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
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,
18 November, 2019
No Comments