SQL> EXEC SDO_NET.CREATE_SDO_NETWORK('hennepin',1,TRUE,FALSE); PL/SQL procedure successfully completed. SQL> describe hennepin_node$; Name Null? Type ----------------------------------------- -------- ---------------------------- NODE_ID NOT NULL NUMBER NODE_NAME VARCHAR2(200) NODE_TYPE VARCHAR2(200) ACTIVE VARCHAR2(1) PARTITION_ID NUMBER GEOMETRY MDSYS.SDO_GEOMETRY SQL> insert into hennepin_node$ select * from F10C5980G30.hennepin_node$; 839 rows created. SQL> alter table hennepin_link$ add transit_id number; Table altered. SQL> describe hennepin_link$; Name Null? Type ----------------------------------------- -------- ---------------------------- LINK_ID NOT NULL NUMBER LINK_NAME VARCHAR2(200) START_NODE_ID NOT NULL NUMBER END_NODE_ID NOT NULL NUMBER LINK_TYPE VARCHAR2(200) ACTIVE VARCHAR2(1) LINK_LEVEL NUMBER GEOMETRY MDSYS.SDO_GEOMETRY COST NUMBER BIDIRECTED VARCHAR2(1) TRANSIT_ID NUMBER SQL> insert into hennepin_link$ select * from F10C5980G30.hennepin_link$; 1722 rows created. SQL> describe F10C5980G30.hennepin_transit_time; Name Null? Type ----------------------------------------- -------- ---------------------------- TRANSIT_ID NUMBER START_TIME NUMBER END_TIME NUMBER TRANSIT_TIME NUMBER SQL> select SDO_NET.GET_NO_OF_LINKS('hennepin') from DUAL; SDO_NET.GET_NO_OF_LINKS('HENNEPIN') ----------------------------------- 1722 SQL> select SDO_NET.GET_NO_OF_NODES('hennepin') from dual; SDO_NET.GET_NO_OF_NODES('HENNEPIN') ----------------------------------- 839 SQL> select SDO_NET.GET_NODE_DEGREE('hennepin',40358) from DUAL; SDO_NET.GET_NODE_DEGREE('HENNEPIN',40358) ----------------------------------------- 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. 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 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. 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 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 SQL> spool off;