Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
up vote 2 down vote accepted

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.

share|improve this answer

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

share|improve this answer
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 posting your answer, you agree to the privacy policy and terms of service.

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