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)
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
PLS-00306: wrong number or types of arguments in call to ‘SDO_GEOMETRY’
At the business I am currently contracted to to provide database modeling, data quality analysis, PLSQL development and spatial expertise, an application was having problems
5 August, 2020
No Comments
Oracle Business Intelligence Warehousing and Analytics – Spatial Summit
I gave a presentation on analyzing Oracle Spatial and Graph 12c’s performance by comparing it with two other spatial types known for their performance or
5 August, 2020
No Comments
How far inside, is inside? Measuring actual distance.
One issue that confuses a lot of spatial database practitioners is that the result of measuring the distance between a geometry object inside a polygon
5 August, 2020
No Comments
Noding and building a polygon from single, overlapping linestrings
The Spatial Companion 4 Oracle (SC4O) package (built using Java Topology Suite components) contains a method called ST_PolygonBuilder that can then form polygons from linestrings.
5 August, 2020
No Comments
ST_VertexN / ST_PointN – Extracting a specific point from any geometry
I have published a number of times and implementation of functions what would extract a specific point from any geometry object. These appear in my
5 August, 2020
No Comments
Convert Single Point stored in SDO_ORDINATES to SDO_POINT_TYPE
Oracle Spatial offers two ways of storing a single point: In SDO_POINT_TYPE structure In SDO_ORDINATE_ARRAY Examples include: SDO_GEOMETRY(2001,NULL,SDO_POINT_TYPE(12, 14, NULL),NULL,NULL)) SDO_GEOMETRY(2001,NULL,NULL,SDO_ELEM_INFO_ARRAY(1,1,1),SDO_ORDINATE_ARRAY(12,14)) Oracle recommends the storage
5 August, 2020
No Comments
Analyzing Spatial Query Performance Improvements in Oracle Spatial and Graph 12c Through Cross-Vendor Comparison
I have written an analysis of Oracle 12c’s new spatial performance improvements. The analysis was conducted by comparing what Oracle is offering in Oracle Spatial
5 August, 2020
No Comments
Aggregate APPEND Islands and XOR polygons
For those not on 12cR1, or even perhaps if you are, the following two requirements came about at a customer site recently. Aggregate Append At
5 August, 2020
No Comments