Top 5 Recent Articles
ARTICLES CATEGORIES
- Algorithms (15)
- All (401)
- 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)
- Recommendations (1)
- Services (1)
- Software Change Log (1)
- Source Code (35)
- Space Curves (9)
- Spatial Database Functions (104)
- 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)
- Topological Relationships (1)
- 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
Bing Maps Tile System Functions for TSQL
This blog presents functions for Bing Maps Tile System for TSQL. This support includes converting Latitude/Longitude pairs to Bing Maps QuadKeys. The source for the
19 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
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
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
Morton Key Function for PostgreSQL/PostGIS
In my article on the creation and use of a space keys for the spatial sorting of spatial data, I show how to implement a
10 July, 2020
No Comments
Spatial Sorting of Data via Morton Key For Oracle Spatial/Locator
I have often advocated the use of a spatial sort when loading static spatial data into Oracle (See 1. Spatially sort read-only data. in my
30 May, 2020
No Comments
Geomatics Degrees, Space Curves and Oracle Spatial
One of the things that should be taught to GIS students at Uni but isn’t in a lot of courses is the notion of space
26 March, 2020
No Comments
Geomatics Degrees, Space Curves and Oracle Spatial
One of the things that should be taught to GIS students at Uni but isn’t in a lot of courses is the notion of space
26 March, 2020
No Comments