I have a problem with the Oracle Spatial Network package. I'm creating NODE, LINK and PATH based on LRS. When I try the call:


then I receive the message:

LRS schema error: column:[GEOM_ID/SDO_GEOMETRY] in table:LINIE_LRS does not exist.

But in my table LINIE_LRS I have type SDO_GEOMETRY, but it is named LRS. What is the problem? How can I fix it? (I can't rename column names.)


I found it. To create VALID network based on SDO_NET the target table should have SDO_GEOMETRY column and GEOM_ID as identifier. My table have ID as identifier, so I must create view based on this table, because this table is using in another application.

Thx a lot.


Sounds like LRS is missing in the Metadata


enter image description here

INSERT INTO user_sdo_geom_metadata VALUES(
    MDSYS.SDO_DIM_ELEMENT('X', 0, 100, 0.005),
    MDSYS.SDO_DIM_ELEMENT('Y', 0, 100, 0.005),
    MDSYS.SDO_DIM_ELEMENT('M', 0, 100, 0.005)),

Will create LRS for your Routes

Important note: LRS data has four dimensions (three plus the M dimension) and if you need to index all three non-measure dimensions, you must use a spatial R-tree index to index the data, and you must specify PARAMETERS('sdo_indx_dims=3').

Much more information http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96630/sdo_lrs_concepts.htm

  • I had registry this table in user_sdo_geom_metadata and spatial index. So this is not the problem. We use this table from two years for spatial analysis. But this is our first step with network in sdo_net. – Raknel Nov 10 '11 at 6:59
  • This post is useful in creating table with geometry based on LRS. – Raknel Nov 14 '11 at 11:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.