[Gvsig_english] Oracle Spatial with LRS

[Antonio Pedro]

Hi all,
My routes (carreteras) table has Linear Referencing System because I want to
set the measure.So it has x,y and a m but the index is in 2D because Oracle
recomends that since m isn't z or height.

In gvSIG I can show points, polygons but with lines gives me the error:

Error while getting valid geometry fields:
no_index_on_declared_geo_fields: SCHEMA.LINE_TABLE

I think it is because of LRS, but that is essential for my project.
gvSIG doesn't work with LRS?

I created the index with this:

create index IS_LN_03 on BDR_LINE (
   GEOMETRY_LN
) INDEXTYPE IS MDSYS.SPATIAL_INDEX
PARAMETERS('TABLESPACE=BDRLNX WORK_TABLESPACE=BDRTMP LAYER_GTYPE=MULTILINE
sdo_indx_dims=2')
LOCAL (
 PARTITION pEVTLN01,
 PARTITION pEVTLN02,
 PARTITION pEVTLN03,
 PARTITION pEVTLN04,
 PARTITION pEVTLN05,
 PARTITION pEVTLN06,
 PARTITION pEVTLN07,
 PARTITION pEVTLN08,
 PARTITION pEVTLN09,
 PARTITION pEVTLN10,
 PARTITION pEVTLN11,
 PARTITION pEVTLN12,
 PARTITION pEVTLN13,
 PARTITION pEVTLN14,
 PARTITION pEVTLN15,
 PARTITION pEVTLN16,
 PARTITION pEVTLN17,
 PARTITION pEVTLN18,
 PARTITION pEVTLN19,
 PARTITION pEVTLN20,
 PARTITION pEVTLNM
)
/

Thanks
Antonio Pedro
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://runas.cap.gva.es/pipermail/gvsig_internacional/attachments/20090219/cc60bf26/attachment.htm