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)
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
26 June, 2021
No Comments
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
18 January, 2021
No Comments
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
30 November, 2020
No Comments
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
25 November, 2020
No Comments
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