Top 5 Recent Articles
ARTICLES CATEGORIES
- Algorithms (15)
- All (399)
- 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 (106)
- 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 (10)
- Tools (2)
- Topological Relationships (1)
- Training (2)
- Triangulation (2)
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
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
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
Playing around with Centroids by using different seed values
The CENTROID package that I make available for free exposes a function for generating centroids of polygon (or area) objects. Here is the function: If
5 August, 2020
No Comments
Simple Oracle C Sprintf or Java String.format
It is amazing what one finds inside an Oracle database! When writing pl/sql code I often have need to print out formatted strings. I have
5 August, 2020
No Comments
Some Oriented Point Functions
A reader asked me for some help constructing and querying oriented points a few months back. The functions I created for him were one to
5 August, 2020
No Comments
Extracting Inner Rings Changed Ordinate Ordering: A Trap For Players Who Don’t Read Documentation!
In Developing Some Ideas For The Compression/Decompression Of Sdo_Geometry Objects, I Had Cause To Create Two PL/SQL Functions called Geocompress and Geodecompress. I Have Not
5 August, 2020
No Comments