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 (2)
- Image Processing (2)
- Import Export (5)
- Licensing (2)
- Linear Referencing (3)
- Manifold GIS (3)
- Mapping (1)
- MySQL Spatial (7)
- Networking and Routing (including Optimization) (3)
- Open Source (16)
- Oracle Spatial and Locator (177)
- 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)
Geometry object size when exchanging of WKT/WKB encoded geometries.
Introduction The ordinates stored in an geometry objects, across all spatial data types do not have any rounding applied to their values. This is one
Geometry Validity and Method Access
Introduction All database spatial types that I have worked with have constructors based on Well Known Text (WKT). When constructing a geometry all those types
Linear Referencing System (LRS) Functions for TSQL
Introduction I have written a complete package of Linear Referencing functions in TSQL. They have been available for over two years. They have not been
My Services
1. Solutions Architecture. I discovered over the years that I am a pretty good systems and solutions architect. How does this apply to you? Well,
CheckRadii: Identifying Tight Radius Curves sections within LineString geometry data
Sometimes it is a data quality requirement for linear data (roads, pipelines, transmission lines) that curves within the lines must have a radius greater than
The Sad State of GIS SQL Standards
The background to this blog comes from two separate sources: the first is my testing of SQL Server 2008 “Katmai”, and secondly, a blog article
Overlaying Polygons in SQL Server Spatial
Introduction The OGC operators for geometry processing only support two polygon inputs. Additionally the Microsoft aggregate operators only include geometry union processing geometry::UnionAggregate and not
Oracle Spatial Mapping and Map Rendering Performance Tips
Comment: This article was written about 10 years ago. Most of what is written is still relevant though the comments about disk usage and access
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
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
Documentation
- MySQL Spatial General Function 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