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)
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
Tip: Drop that Spatial Index!
We all make mistakes. I made a good one this month. I had to modify (DDL) a very, very large table to change the size
5 August, 2020
No Comments
Convert Single Geometry to Multi-part Geometry in Oracle Spatial
Oracle allows single part and multipart geometry objects to existing in a single SDO_GEOMETRY column. For example, a polygon and a multipolygon. This is because
5 August, 2020
No Comments
Optimized Rectangle to 5 Point Polygon
Here is a function that takes a any polygon whose elements are defined by an optimized rectangle and converts all elements to 5 vertex polygons.
5 August, 2020
No Comments
Centroid Package now supports Y ordinate seeding
The populate CENTROID package has been modified. It now allows the caller of the CENTROID_A function to invoke Y ordinate seeding. This is what it
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
Spatial Database Training Courses
The following training courses have been developed and are available for on-site training using customer data: SQL Server Spatial Basic SQL Server Spatial Intermediate Oracle
5 August, 2020
No Comments
Convert GeoJSON document to Sdo_Geometry objects
Andy Versal is a reader of this website. He recently modified my SDO2GEOJSON function. Andy supplied me with the fixes which now appear in the
5 August, 2020
No Comments
Simple Implementation Of Travelling Salesman Problem
UPDATE: This function is now a part of the Oracle Object implementation. The Travelling Salesman is a well known problem in graph theory: The Travelling
5 August, 2020
No Comments
Create Polygons and Linestrings From Bearings And Distances (COGO)
UPDATE The original functions have been modified and deployed via my Oracle Object code. They original code is no longer available. My COordinate GeOmetry (COGO)
5 August, 2020
No Comments