I have problem with one spatial (Oracle) query. Simplified overview of the problem is:
I have two tables:
CREATE TABLE thin_lines ( id NUMBER PRIMARY KEY, geom SDO_GEOMETRY), color VARCHAR2(32);CREATE TABLE thick_lines ( id NUMBER PRIMARY KEY, geom SDO_GEOMETRY), color VARCHAR2(32);Both tables contain 2D lines. The example picture:
The problem:
I want to create SQL query or PL/SQL procedure to find ids of all blue thin lines (whole blue branch comprising of blue lines) connected to the thick green lines.
أكثر...
I have two tables:
CREATE TABLE thin_lines ( id NUMBER PRIMARY KEY, geom SDO_GEOMETRY), color VARCHAR2(32);CREATE TABLE thick_lines ( id NUMBER PRIMARY KEY, geom SDO_GEOMETRY), color VARCHAR2(32);Both tables contain 2D lines. The example picture:
The problem:
I want to create SQL query or PL/SQL procedure to find ids of all blue thin lines (whole blue branch comprising of blue lines) connected to the thick green lines.
أكثر...