************************************************************************ PART B: Using a Spatial Network - 1 ************************************************************************ SQL> select SDO_NET.GET_NO_OF_LINKS('hennepin') from DUAL; SDO_NET.GET_NO_OF_LINKS('HENNEPIN') ----------------------------------- 1722 ************************************************************************ PART B: Using a Spatial Network - 2 ************************************************************************ SQL> select SDO_NET.GET_NO_OF_NODES('hennepin') from dual; SDO_NET.GET_NO_OF_NODES('HENNEPIN') ----------------------------------- 839 ************************************************************************ PART B: Using a Spatial Network - 3 ************************************************************************ SQL> select SDO_NET.GET_NODE_DEGREE('hennepin',40358) from DUAL; SDO_NET.GET_NODE_DEGREE('HENNEPIN',40358) ----------------------------------------- 4 ************************************************************************ PART B: Using a Spatial Network - 4 ************************************************************************ SQL> select node_ID, SDO_NET.GET_NODE_IN_DEGREE('hennepin', node_ID) from hennepin_node$, DUAL having SDO_NET.GET_NODE_IN_DEGREE('hennepin', node_ID) >=4 group by node_ID,SDO_NET.GET_NODE_IN_DEGREE('hennepin', node_ID); NODE_ID SDO_NET.GET_NODE_IN_DEGREE('HENNEPIN',NODE_ID) ---------- ---------------------------------------------- 8661 4 25615 4 103221 4 103443 4 7119 4 103446 4 136503 4 45470 4 43013 4 41295 4 10313 4 NODE_ID SDO_NET.GET_NODE_IN_DEGREE('HENNEPIN',NODE_ID) ---------- ---------------------------------------------- 98145 4 103717 4 104067 4 136909 4 104074 4 103447 4 136500 4 104039 5 41296 4 104018 4 21 rows selected. ************************************************************************ PART B: Using a Spatial Network - 5 ************************************************************************ SQL> select avg(sdo_net.get_node_out_degree('hennepin',node_id)) from hennepin_node$; AVG(SDO_NET.GET_NODE_OUT_DEGREE('HENNEPIN',NODE_ID)) ---------------------------------------------------- 2.05244338 ************************************************************************ PART B: Using a Spatial Network - 6 ************************************************************************ SQL> select htt.transit_time from F10C5980G30.hennepin_transit_time htt,hennepin_link$ hl where hl.link_id = 300 and hl.transit_id = htt.transit_id and htt.start_time > 630 and htt.end_time < 1020; TRANSIT_TIME ------------ .453704514 .453704514 .453704514 .453704514 .453704514 .473430797 .473430797 .473430797 .473430797 .473430797 .473430797 TRANSIT_TIME ------------ .473430797 .453704514 .453704514 .453704514 .453704514 .453704514 .453704514 .435556334 .435556334 .435556334 .418804167 TRANSIT_TIME ------------ .418804167 .403292902 24 rows selected. SQL> select htt.transit_time from F10C5980G30.hennepin_transit_time htt,hennepin_link$ hl where hl.link_id = 300 and hl.transit_id = htt.transit_id and htt.start_time > 1230 and htt.end_time < 1440; TRANSIT_TIME ------------ .362963611 .362963611 .362963611 .362963611 .362963611 .362963611 .362963611 .362963611 .362963611 .362963611 .362963611 TRANSIT_TIME ------------ .362963611 12 rows selected. ************************************************************************ PART B: Using a Spatial Network - 7 ************************************************************************ SQL> select min(htt.transit_time), max(htt.transit_time) from F10C5980G30.hennepin_transit_time htt, hennepin_link$ hl where hl.link_id = 1000 and hl.transit_id = htt.transit_id; MIN(HTT.TRANSIT_TIME) MAX(HTT.TRANSIT_TIME) --------------------- --------------------- 1.24864864 1.47866286 ************************************************************************ PART B: Using a Spatial Network - 8 ************************************************************************ SQL> select sum(htt.transit_time) from F10C5980G30.hennepin_transit_time htt,hennepin_link$ hl where hl.link_id in (130,1476,1478,738) and hl.transit_id = htt.transit_id and htt.start_time > 705 and htt.end_time < 930; SUM(HTT.TRANSIT_TIME) --------------------- 6.34485424 SQL> select sum(htt.transit_time) from F10C5980G30.hennepin_transit_time htt,hennepin_link$ hl where hl.link_id in (130,1476,1478,738) and hl.transit_id = htt.transit_id and htt.start_time > 0 and htt.end_time < 330; SUM(HTT.TRANSIT_TIME) --------------------- 8.10379147