A collection of examples in PL/SQL and JAVA involving network constraints.

A SQL example using external tables to load data into SDO_GEOMETRY (Either 10gR1 or 10gR2)

These examples use the Oracle Spatial Java Class Library to read and write Geographic Markup Language (GML). The examples demonstrate how to open an Oracle database connection, read geometry information from a user-defined table (with at least one column of type SDO_GEOMETRY), print out well defined GML for the geometries returned in a SQL result set, and how to consume and transform a pre-defined GML document into an Oracle JGeometry type. The Oracle Spatial Java Class Library and associated GML examples can be used to read/write geometries from/to Oracle8i, Oracle9i and Oracle10g databases.

The NDM Network Editor is a standalone Java client application that facilitates editing network data, enables browsing and navigating the network, and more importantly visualizes the result of network analyses for users. The README.txt file within the zipfile has instructions for installing and using this application. The sample data for Hillsbourgh County, NH, USA can be used with the NDM Network Editor. 9-Jan-2006

Note: This version of the NDM Network Editor is for use with Oracle 10g Spatial 10.2.0.1.0, 10.1.0.2, and 10.1.0.1.

Note: The NDM Network Editor is only intended to demonstrate Oracle Spatial NDM capability and is not supported by Oracle.

A zip file containing both Oracle Spatial Network Data Model (NDM) sample data and sample code. 20-Jul-2005

• Data: Hillsborough County, NH, USA road network data converted from US Census Tiger Data
  
• Code: Java code demonstrating various NDM features, specifically:
  
  • NetworkStateDemo.java: Shows how to turn on/off of network nodes and
    links. This feature is particular useful for "what-if" analysis.
    
  • ProhibitedTurnDemo.java: Shows how to code NDM Network Constraints by
    constructing prohibited turns.