Top 5 Recent Articles
ARTICLES CATEGORIES
- Algorithms (20)
- 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)
- Projections (1)
- Published Articles (1)
- qGIS (1)
- Recommendations (1)
- Services (1)
- Software Change Log (1)
- Source Code (35)
- Space Curves (9)
- Spatial Database Functions (108)
- Spatial DB comparison (1)
- Spatial XML Processing (11)
- SQL Server Spatial (92)
- Standards (3)
- Stored Procedure (15)
- Tessellation or Gridding (10)
- Tools (2)
- Topological Relationships (1)
- Training (2)
- Triangulation (2)
Fixing Geography Ring Orientation
This article demonstrates the effect wrong ring orientation has on the processing of a geography object and shows how to fix such orientation.
Delaunay Triangulation Function for TSQL and SQL Server Spatial
This article shows how to create a delaunay triangulation (mesh) from various inputs in SQL Server Spatial, and compute the 3D (slope) area.
Removing Spikes in SQL Server Spatial Linestrings
This article presents a method for identifying and removing spikes in SQL Server Spatial linestrings and polygon rings. Spikes are common when processing GPS observations.
How to calculate cumulative length of a linestring, or the truck tonnage that accumulates across a set of roads
This articles describes how to compute the cumulative length of a single linestring, or the total tonnage that crosses a set road segments.
Snapping a Point to an Oracle Spatial SDO_GEOMETRY LineString
This article shows how to snap a point to an Oracle Spatial linear geometry using the SDO_CLOSEST_POINTS procedure and function
Oracle Spatial Vector Acceleration: Flick the Switch
Introduction A lot has been written, positive and negative, about the speed of Oracle Spatial over the years, a lot of ill informed (I mean
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
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
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
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.
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