Navigation Service

The Navigation service is a subset component of the Upstream/Downstream service designed to provide standard stream network traversal.  The traversal request may include a description of where, on the stream network, to begin the traversal, and a description of where or how to end the traversal.  All Upstream/Downstream executions require a navigation type and at least one start point.  All other input parameters are optional. 

Drinking Water Designated Use Evaluation

Parameters

HTTP Service Notes

Additional parameters specific to HTTP services are listed in the WATERS HTTP Services documentation.

SOAP Service Notes

The parameter listing for SOAP services is slightly different.  Array parameters are not followed by a "mod" parameter as the array format is specified by the WSDL documentation.  For SOAP services, the input geometry parameter is always OGC Well-Known Text (WKT) and thus the secondary "mod" parameter is simply a numeric value of the Oracle Spatial Reference ID.

UML Diagram

Return Object

navigation_service_output

Supporting Objects

updn_recnavresultsstandard object

HTTP Service Notes

The output format for this service is JSON with GEOJSON formatted geometries.

SOAP Service Notes

The SOAP service does not return any geometries with results.

Database Service Example

Users with schema accounts on the EPA waters10 database instance may directly access the upstream/downstream service via a stored procedure interface.  Input and output is managed via the objects described below. Callers need to create, submit, receive and interpret these objects for their own needs. Note that the upstream/downstream service code utilizes internal DDL statements such that the indexing service must be called as a PL/SQL procedure rather than embedded as a function within SQL.

-- Create a table to hold your results
CREATE TABLE up_downstream_nav_results (input CLOB, output CLOB);

-- Run the upstream/downstream service
DECLARE
   obj_output   ow_service.updn_objNavigationOutput;
   clb_output   CLOB;
   
BEGIN

   -----------------------------------------------
   -- Step 1
   -- Run the database service
   -----------------------------------------------
   obj_output := ow_service.updn_main.main_navigation_srv(
      'PP',
      12169311,
      NULL,
      97,
      12169213,
      NULL,
      50,
      NULL,
      NULL,
      'FALSE',
      0.001  
   );
   
   -----------------------------------------------
   -- Step 3
   -- Serialize the output into a CLOB
   -----------------------------------------------
   clb_output := XMLTYPE(obj_output).getClobVal();
   
   -----------------------------------------------
   -- Step 4
   -- Pop values into the table
   -----------------------------------------------
   EXECUTE IMMEDIATE
   'INSERT INTO up_downstream_nav_results VALUES(NULL,:p01)'
   USING clb_output;
   COMMIT;
                    
END;
                    
-- Then inspect the results in the up_downstream_nav_results table.
-- Note that empty attributes and child objects will not be represented in the serialized XML.

Version: 2.0 - Released: August 31, 2009