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)
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
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