Go to content Go to navigation and search

Home

Software Download

Download Code, Packages and Installers

MySQL

SQL Server

Oracle Objects/Package (New)

Minimum Bounding Rectangle (MBR)
Objects/Packages (T_GEOMETRY etc)

Oracle Packages (Original)

CENTROID
COGO
EXPORTER
GEOM
KML
LINEAR (LRS)
NETWORK
SDO_ERROR
Spatial Companion For Oracle (SC4O)
TOOLS

Articles

    PL/SQL Objects from "Applying and Extending Oracle Spatial"
    TESSELATE and CENTROID package updates
    Applying and Extending Oracle Spatial: Source Code Problem
    CENTROID package use with ESRI's sde.st_geometry
    Changes to CENTROID and TESSELATE packages
    CENTROID Package now returns centroid of multi-linestring
    New versions of PL/SQL packages uploaded
    VB6 Oracle Spatial or Locator OO4O code
    Spatial PL/SQL Packages by Example
    Catalog Registry Tool
    Image Catalog Tool
    Oracle Spatial PL/SQL and VB6 Source Code


Search

Browse

RSS / Atom

Email me

textpattern

Creative Commons License
All Blog Articles, Data Models and Free Source Code by Simon Greener, The SpatialDB Advisor is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License.

LINEAR (LRS)

Monday August 15 2011 at 04:09

KeywordsLRS,LINEAR,Locator,replacement
Summary

A small collection of Linear Referencing System functions for Oracle Locator users.

UPDATED: This package of functions underwent a revamp in early July 2012. In that revamp:

  • ST_Locate_Point was overhauled to correctly handle both distance based segmentation of 2D lines as well as Measured geometries (p_value_Type parameter now fully handled).
  • ST prefixes added to public functions._
  • T_Vector Type enhanced
  • ST_GetVector renamed to ST_Vectorize
  • Bugs fixed in ST_Split
  • Added:
    ST_Offset_Geom_Segment
    ST_Reset_Measure
    ST_Start_Measure
    ST_End_Measure
    ST_Measure_Range
    ST_Measure_To_Percentage
    ST_Percentage_To_Measure
    ST_Scale_Geom_Segment
    ST_getMeasureDimension
    ST_Reverse_Measure

I have written a PL/SQL package called LINEAR that could be used, in many situations, to provide Enterprise SDO_LRS functionality for Oracle Locator based deployments.

It does not implement everything that SDO_LRS does.
If you want something in particular, please look at my re-write of the source code as Oracle Objects on this site.

Additionally it focuses mainly on projected (not long/lat) data, so if you use with geodetic data do so at your own risk.

Required Data Types

The LINEAR package requires other Oracle PL/SQL types to exist. See other documentation for a full description of what they do.

Creative Commons License

post this at del.icio.uspost this at Diggpost this at Technoratipost this at Redditpost this at Farkpost this at Yahoo! my webpost this at Windows Livepost this at Google Bookmarkspost this to Twitter

Comment

META HTTP-EQUIV=