Skip to content

The Spatial Database Advisor

Spatial Solutions Architect and Database Expert

0 $0.00
Primary Menu
  • Home
  • Articles
    • MySQL SpatialArticles about MySQL Spatial Functions.
    • Oracle Spatial and Locator
    • PostGIS
    • SQL Server Spatial
    • Software Change LogDescribes changes to packaged software.
    • Spatial Database Functions
  • About
  • Contact
  • Shop
0 $0.00
x
  • Login/Register
Home / Oracle Spatial and Locator / Page 4

Top 5 Recent Articles

Creating linestring geometries from a table of ordinates (Oracle)

How to calculate cumulative length of a linestring, or the truck tonnage that accumulates across a set of roads

Visualising the Topological Relations of LineStrings

Object Implementation of Oracle SDO_LRS

Split Oracle Sdo_Geometry Linestring at a Known Point using SDO_LRS and PL/SQL (2)

ARTICLES CATEGORIES
  • Algorithms (19)
  • All (400)
  • Biography (1)
  • Blog (45)
  • Business Requirements (1)
  • Commentary (1)
  • 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) (4)
  • Open Source (18)
  • Oracle Spatial and Locator (193)
  • Partitioning (1)
  • PostGIS (34)
  • Published Articles (1)
  • qGIS (1)
  • Recommendations (1)
  • Services (1)
  • Software Change Log (1)
  • Source Code (35)
  • Space Curves (9)
  • Spatial Database Functions (107)
  • Spatial DB comparison (1)
  • Spatial XML Processing (11)
  • SQL Server Spatial (91)
  • Standards (3)
  • Stored Procedure (15)
  • 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

Read More »
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

Read More »
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.

Read More »
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

Read More »
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

Read More »
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

Read More »
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)

Read More »
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)

Read More »
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

Read More »
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

Read More »
5 August, 2020 No Comments
Page1 Page2 Page3 Page4 Page5

Documentation

  • MySQL Spatial General Function Documentation
  • Oracle LRS Object Documentation
  • Oracle Spatial Exporter Package Documentation
  • Oracle Spatial Object Function Documentation
  • Oracle Spatial Object Function Documentation (Multi Page Version)
  • PostGIS pl/pgSQL Function Documentation
  • SC4O Oracle Java Topology Suite (Stored Procedures) Package Documentation
  • SQL Server Spatial General TSQL Function Documentation
  • SQL Server Spatial LRS TSQL Function Documentation
© The Spatial Database Advisor 2019