The goal of this chapter is to use the functions created in the previous chapters to build new functions that can be used to solve business problems relating to managing linear assets. The main business problems that need this functionality are road, cycle way or track management, geocoding street addresses, survey, inventory, condition assessment, and water management applications.
Oracle Spatial has a robust linear referencing package (SDO_LRS
) that can be applied to all these problems. The SDO_LRS
package can only be licensed for use by purchasing the Spatial package and deploying it within an Oracle Enterprise database. In addition, SDO_LRS
cannot be purchased separately from the whole Spatial package. Finally SDO_LRS
cannot be used with Locator.
The functions created in this chapter will provide SDO_LRS
functionality where licensing of the SDO_LRS
package is beyond the user's resources. These functions will support simple linear...