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.

Combine NAVTEQ, the world-leader in premium quality digital map data, with Oracle Database 10g, the first relational database designed for Grid Computing, and your information is securely consolidated and always available!

NAVTEQ data is available for sale to users of Oracle10g Spatial and/or Locator by the County, State, US or European Country. Data is in the Oracle10g Spatial mapping, geocoding and routing schema and delivered in transportable tablespaces.

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.