Top 5 Recent Articles
ARTICLES CATEGORIES
- Algorithms (22)
- All (399)
- Biography (1)
- Blog (44)
- Business Requirements (1)
- Commentary (1)
- Conversion (2)
- 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) (5)
- Open Source (18)
- Oracle Spatial and Locator (194)
- Partitioning (1)
- PostGIS (36)
- Projections (1)
- Published Articles (1)
- qGIS (1)
- Recommendations (1)
- Services (1)
- Software Change Log (1)
- Source Code (37)
- Space Curves (9)
- Spatial Database Functions (109)
- Spatial DB comparison (1)
- Spatial XML Processing (11)
- SQL Server Spatial (92)
- Standards (3)
- Stored Procedure (17)
- 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
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
Using a GeometryCollection as an Array for TSQL (Stored Procedure) Development.
The lack of an array datatype in TSQL can be overcome for geometry processing by use of a GeometryCollection as a data type and a set of methods to manipulate it.
6 November, 2020
No Comments
Spatial Representation of a Communications Pit
This article describes the elements of a telecommunications pit and shows how they can be spatially represented. In particular the concept of a butterfly as a method for displaying the walls of a pit is introduced.
7 August, 2020
No Comments
Using Range Querying to Filter LineString Segments
This article shows how to use range querying against cumulative length to filter/select LineString segments
5 August, 2020
No Comments
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
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
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
A simple spike finder for Spatial
This is an old article that uses older custom code e.g. Vector2Geom(). Because the principles in the code are correct, I will bring the code
24 July, 2020
No Comments