SQL> SELECT SDO_GEOM.SDO_AREA(n.geom, 0.0000005) as forest_area FROM F10C5980G30.natural n where type ='forest'; FOREST_AREA ----------- 4.7889E-06 2.5546E-06 .000027014 .00006348 .000092697 .00010956 .000001141 .000004401 1.5754E-06 3.6884E-06 .000012989 FOREST_AREA ----------- .000017019 .000168682 .000061232 4.5266E-06 2.1804E-06 .001118054 .000010289 2.4910E-07 6.9554E-06 3.3619E-07 3.2191E-06 FOREST_AREA ----------- 1.0997E-06 8.5101E-07 2.9514E-06 5.2694E-06 .000004814 .000013318 .000017266 1.5325E-06 .000020967 1.6214E-08 5.6221E-08 FOREST_AREA ----------- 1.9182E-06 5.5006E-07 6.7517E-07 .000008804 5.5179E-06 1.5072E-06 3.2411E-06 1.2032E-06 .000008809 3.6203E-06 1.7017E-06 FOREST_AREA ----------- .000023028 .000010184 .000023139 .000016547 2.4553E-06 2.3174E-06 2.7817E-07 4.1273E-07 .000028519 4.5654E-06 4.8911E-07 FOREST_AREA ----------- .000502461 3.9672E-06 .000054104 .000016452 4.7928E-06 7.4826E-06 1.0831E-06 1.3985E-06 2.6041E-06 .001942732 .00005308 FOREST_AREA ----------- .000010918 4.6122E-07 3.3309E-06 1.0416E-06 1.8244E-06 1.8168E-07 2.0882E-07 7.7481E-07 4.1933E-07 1.9023E-06 2.4966E-06 FOREST_AREA ----------- 7.1798E-07 5.0005E-07 .000011988 8.5587E-06 2.9764E-07 5.7821E-07 2.1233E-06 5.3752E-07 1.8502E-06 1.0705E-06 3.2913E-06 FOREST_AREA ----------- 1.7221E-06 3.5232E-07 1.8035E-07 8.2019E-07 9.9417E-07 .00000881 .000010306 1.7074E-06 2.0461E-06 2.8056E-08 1.7309E-06 FOREST_AREA ----------- 3.3673E-06 1.4063E-06 .000021231 9.1762E-07 .000010806 8.7081E-07 6.1249E-06 9.5609E-06 7.9695E-06 2.3279E-06 2.7023E-06 FOREST_AREA ----------- 1.0201E-06 1.2215E-06 3.9284E-06 .000001673 .000003233 1.8113E-07 7.0848E-07 1.6928E-07 3.3463E-07 3.0223E-07 2.0367E-07 FOREST_AREA ----------- 2.5007E-07 2.0961E-06 9.0442E-07 3.2607E-06 4.2740E-07 5.4449E-06 7.6549E-07 5.2046E-07 5.2235E-07 4.0457E-06 4.1191E-07 FOREST_AREA ----------- 7.3717E-06 4.1837E-06 2.0346E-06 .000012464 2.8519E-06 .000061272 4.0853E-06 7.6986E-07 2.4062E-06 2.7850E-07 .00000378 FOREST_AREA ----------- 3.7807E-07 1.0202E-06 1.3444E-06 6.5012E-07 4.7548E-07 7.8851E-07 1.5623E-07 7.0925E-06 3.5856E-07 1.3737E-06 1.6949E-06 FOREST_AREA ----------- 1.9551E-06 4.7153E-06 1.5971E-06 7.8627E-07 5.3760E-07 4.2790E-07 1.0561E-06 1.3097E-06 1.8787E-06 4.2224E-07 4.7801E-07 FOREST_AREA ----------- 3.4291E-07 3.5516E-07 2.4276E-06 2.3461E-06 .000000865 2.6937E-06 5.4838E-06 1.4661E-06 .000014294 6.5051E-06 .000001959 FOREST_AREA ----------- 1.0594E-06 5.8148E-06 .000015733 5.3700E-08 3.4846E-07 1.4003E-07 1.1468E-06 .000109439 2.2891E-07 8.8057E-08 3.5372E-07 FOREST_AREA ----------- 4.8329E-07 9.2275E-07 2.3927E-06 4.1075E-07 1.2961E-06 7.0248E-07 1.2941E-07 4.2495E-07 4.6832E-07 6.0722E-07 4.6711E-07 FOREST_AREA ----------- 3.1219E-06 5.5382E-07 4.0397E-06 .000031512 9.3267E-06 .000030084 5.7957E-07 1.7312E-06 2.2814E-07 1.1281E-06 2.2543E-06 FOREST_AREA ----------- 1.5048E-06 1.5165E-06 2.9511E-07 5.5109E-07 1.5392E-06 1.0693E-07 1.3045E-07 3.1740E-07 .000010444 4.9221E-07 9.7467E-07 FOREST_AREA ----------- 8.9911E-07 .00006258 2.8133E-06 3.4379E-06 1.3566E-06 .000001236 2.9742E-06 1.1768E-06 1.4356E-06 1.3377E-06 1.7058E-06 FOREST_AREA ----------- .000016487 3.4208E-06 1.7939E-07 .000020351 8.7266E-07 .000000355 7.0856E-08 4.9150E-07 3.7997E-06 1.7618E-06 8.3707E-07 FOREST_AREA ----------- 9.6312E-07 3.3022E-06 4.1375E-07 4.6830E-07 6.2622E-07 8.2589E-06 4.1646E-07 .000005137 1.0918E-06 6.7234E-07 1.4624E-07 FOREST_AREA ----------- .000002239 6.4588E-06 .000012433 .000015181 4.7247E-07 2.1867E-06 1.3651E-06 1.2379E-06 1.2321E-06 5.2209E-07 6.0012E-07 FOREST_AREA ----------- 2.9385E-06 4.5315E-07 2.7026E-07 7.2278E-07 1.0964E-06 2.3486E-06 3.6607E-07 7.1212E-07 1.1253E-06 4.2567E-07 3.7414E-07 FOREST_AREA ----------- .000019427 8.8486E-08 7.6627E-08 1.0476E-06 .000003118 1.8669E-06 4.2667E-06 7.3003E-07 6.7464E-07 5.0785E-07 1.3152E-07 FOREST_AREA ----------- 3.2516E-06 .000006249 3.6808E-06 3.4891E-07 1.6221E-06 .000001811 2.4371E-06 1.5768E-07 1.5433E-06 .000005777 3.7247E-06 FOREST_AREA ----------- 3.1538E-07 3.1925E-07 4.8655E-06 7.4048E-07 2.8903E-07 1.5218E-06 4.0346E-06 5.3101E-07 1.3772E-06 5.0549E-07 .000005638 FOREST_AREA ----------- 3.7945E-07 1.3935E-06 4.1040E-07 .000008147 2.0125E-06 .000034808 5.9528E-07 5.0429E-07 9.2143E-08 4.8007E-08 3.6864E-07 FOREST_AREA ----------- 5.9019E-07 7.2886E-07 2.0779E-07 8.1685E-07 1.3666E-07 6.4157E-07 1.3665E-07 4.3098E-07 6.1908E-07 1.2105E-07 6.9901E-07 FOREST_AREA ----------- 1.5736E-06 2.0562E-07 5.4310E-08 7.5557E-07 2.4818E-07 4.2473E-07 1.6559E-06 1.8439E-06 4.0526E-07 1.5271E-06 1.4427E-06 FOREST_AREA ----------- 1.8917E-06 2.6730E-07 1.1561E-06 3.5876E-07 3.8395E-07 1.3908E-07 4.2413E-07 2.1104E-07 2.8659E-07 3.8362E-07 2.4467E-06 FOREST_AREA ----------- 7.8270E-07 5.1912E-07 1.1111E-07 2.2596E-07 1.4995E-06 5.1925E-07 1.2340E-07 8.2411E-07 9.4787E-07 4.9793E-07 2.1474E-06 FOREST_AREA ----------- 7.8275E-07 6.5054E-07 3.3645E-07 4.9772E-07 5.2150E-07 .000001005 4.4918E-07 4.2110E-08 2.4309E-07 9.3974E-08 6.2619E-08 FOREST_AREA ----------- 5.9904E-08 4.3749E-07 1.2351E-07 3.2868E-07 4.2467E-07 7.5231E-08 6.2923E-07 2.8563E-07 1.8304E-07 4.7358E-07 1.0146E-06 FOREST_AREA ----------- 1.5830E-07 7.4568E-07 1.5066E-06 4.0134E-06 9.0762E-07 1.6801E-06 3.2256E-07 1.0731E-07 1.3637E-07 5.8637E-08 1.8429E-07 FOREST_AREA ----------- 1.0066E-07 1.8486E-06 5.2909E-07 8.6933E-07 2.7195E-07 1.0591E-07 6.6816E-08 4.2375E-07 2.0738E-07 5.0023E-07 8.5683E-07 FOREST_AREA ----------- 1.2543E-07 2.1697E-07 1.8309E-06 2.5988E-08 4.9257E-08 5.8928E-07 5.0355E-07 2.2930E-07 6.9179E-08 1.1667E-07 7.5875E-08 FOREST_AREA ----------- 1.2299E-06 1.6156E-07 1.3343E-07 2.7565E-07 5.4828E-07 1.1865E-07 2.2659E-07 3.7244E-07 1.3596E-07 2.1631E-06 6.6492E-06 FOREST_AREA ----------- 1.2689E-06 6.9444E-07 2.2372E-07 1.4363E-06 7.4421E-06 3.8955E-06 2.6458E-06 2.4908E-06 5.1040E-07 4.3826E-06 9.2390E-07 FOREST_AREA ----------- .000018222 4.9762E-07 1.3402E-06 4.5136E-07 8.8236E-07 3.4594E-06 8.9469E-07 9.5893E-07 1.5505E-06 2.2175E-06 3.5519E-07 FOREST_AREA ----------- 2.6908E-07 9.6161E-08 1.4770E-07 3.3172E-07 3.9263E-07 5.9177E-07 2.5943E-06 .000017527 2.0211E-06 3.5345E-07 7.0023E-07 FOREST_AREA ----------- 1.3642E-07 3.6612E-07 1.4452E-07 4.1863E-06 1.1742E-06 8.4310E-07 4.9044E-07 3.5653E-06 3.0374E-06 1.1067E-06 9.9761E-07 FOREST_AREA ----------- 1.6236E-07 1.9297E-06 1.3893E-06 .00000058 3.0501E-07 1.7179E-06 1.0629E-06 7.2768E-07 .000053917 .000001743 .000061574 FOREST_AREA ----------- 1.5404E-06 1.8717E-07 8.2225E-07 6.9690E-07 2.5142E-07 .000006941 6.9077E-06 2.8777E-06 1.1402E-08 5.7297E-07 2.3421E-07 FOREST_AREA ----------- 1.8290E-08 1.1976E-08 1.6597E-07 6.5694E-08 4.4185E-08 5.0638E-07 3.0046E-08 1.3968E-07 3.0132E-08 8.3718E-08 3.2167E-08 FOREST_AREA ----------- 7.4019E-08 7.6846E-07 8.3090E-08 1.3356E-07 4.6865E-08 3.9072E-07 1.5718E-07 7.1085E-07 2.3846E-07 9.4329E-08 3.3593E-06 FOREST_AREA ----------- 1.5712E-07 .000016467 6.2803E-06 9.0294E-07 4.2565E-06 2.2466E-06 1.4753E-06 1.3884E-07 5.0883E-07 4.0457E-07 3.9224E-07 FOREST_AREA ----------- .000039412 5.9606E-07 3.2219E-06 3.4813E-06 1.9077E-07 8.2768E-08 5.1023E-08 1.3727E-07 2.0959E-07 .000046424 7.1456E-08 FOREST_AREA ----------- 3.8193E-07 2.9043E-07 1.7199E-07 1.2865E-07 8.6907E-07 3.3015E-07 5.1216E-07 1.7595E-07 .000019667 .000001448 6.0793E-07 FOREST_AREA ----------- .000048594 4.5179E-07 1.0607E-07 1.5803E-07 6.5496E-06 .000020359 4.2911E-06 3.1127E-06 .000011251 1.1746E-06 1.5989E-06 FOREST_AREA ----------- 1.3666E-06 1.9013E-06 7.8762E-08 2.0439E-07 2.3469E-08 3.1147E-08 1.5674E-08 2.3735E-08 4.1696E-09 4.1462E-09 8.3539E-09 FOREST_AREA ----------- 1.2858E-08 5.8785E-08 6.5248E-07 6.0430E-07 3.2650E-07 1.3812E-06 3.9331E-07 2.2191E-07 3.8014E-06 1.8837E-06 1.3524E-07 FOREST_AREA ----------- 5.1107E-07 3.8564E-07 7.5911E-07 5.8746E-06 5.4207E-09 5.3885E-09 5.4124E-09 5.4179E-09 5.3884E-09 5.4180E-09 5.3982E-09 FOREST_AREA ----------- 2.5419E-08 5.3928E-09 1.9803E-08 5.3141E-09 5.3888E-09 5.3980E-09 5.3980E-09 5.4123E-09 5.4308E-09 5.4125E-09 5.4310E-09 FOREST_AREA ----------- 2.6631E-07 5.4126E-09 5.3559E-09 5.4309E-09 1.6627E-08 5.3852E-09 4.2831E-08 2.4190E-08 5.3140E-09 5.4126E-09 5.3969E-09 FOREST_AREA ----------- 5.4126E-09 2.1042E-08 1.2404E-08 2.5345E-07 1.0172E-06 1.7319E-07 6.1479E-06 2.8139E-06 .000061164 1.1383E-06 1.2897E-06 FOREST_AREA ----------- 8.5724E-07 1.7005E-06 1.0047E-06 5.4208E-09 5.4182E-09 5.4180E-09 9.2781E-09 5.4362E-09 3.8365E-06 2.0211E-06 5.2849E-07 FOREST_AREA ----------- 1.4722E-07 1.6521E-06 5.0495E-06 1.1759E-06 2.4057E-07 7.2375E-07 9.4155E-07 9.1370E-07 1.1015E-06 4.1905E-07 4.0295E-06 FOREST_AREA ----------- 1.2018E-06 1.2302E-07 1.2423E-08 5.4125E-09 1.9875E-08 1.6190E-08 1.8575E-09 5.3503E-09 5.4360E-09 5.3925E-09 5.4124E-09 FOREST_AREA ----------- 5.3559E-09 5.4212E-09 5.3980E-09 1.2436E-08 5.3609E-09 1.2452E-08 7.7859E-06 2.6293E-07 .000901248 .000044543 2.4808E-06 FOREST_AREA ----------- 2.6169E-06 1.2514E-06 8.7286E-07 5.8578E-07 1.2624E-06 4.6226E-06 1.4616E-06 3.9218E-06 1.3927E-06 4.3807E-06 1.8428E-06 FOREST_AREA ----------- 1.2324E-06 1.3948E-07 2.6077E-07 6.9996E-06 .000010061 3.8972E-06 2.1587E-06 1.6063E-06 4.0602E-07 3.2449E-07 3.3720E-07 FOREST_AREA ----------- 3.7981E-07 5.7389E-08 4.7805E-08 2.0074E-08 5.4310E-09 5.4123E-09 5.4123E-09 5.4310E-09 5.3561E-09 8.8860E-07 .000004783 FOREST_AREA ----------- 3.5146E-07 1.3737E-06 4.0831E-06 5.0778E-06 7.9543E-06 9.6860E-07 3.5206E-07 5.7454E-06 3.9736E-06 3.3047E-08 4.7164E-08 FOREST_AREA ----------- 2.5864E-07 2.9472E-06 .000012029 8.5338E-06 8.8751E-06 4.7166E-06 3.6259E-07 8.6043E-07 2.2674E-06 .000015224 .000182514 FOREST_AREA ----------- .000001069 3.9208E-06 1.1693E-06 7.7852E-06 9.2899E-07 .000077971 .000063686 .000087747 .000173556 2.2759E-06 .000203772 FOREST_AREA ----------- .000002267 .000012429 2.1463E-06 .000002005 .000001368 3.8134E-06 8.1473E-06 5.4209E-09 .000218935 4.6867E-09 4.6316E-09 FOREST_AREA ----------- 3.8129E-09 3.8489E-09 3.8699E-09 3.8450E-09 3.8455E-09 1.3283E-08 3.3501E-09 3.8181E-09 3.8425E-09 9.7515E-09 9.5317E-09 FOREST_AREA ----------- 8.2604E-09 9.7190E-09 3.7514E-09 2.1939E-09 8.2237E-09 4.8168E-09 2.1482E-09 2.2045E-09 2.1865E-09 1.6782E-08 2.0078E-09 FOREST_AREA ----------- 2.0163E-09 8.7584E-09 4.7440E-09 8.3069E-09 4.6774E-09 3.8360E-09 3.8489E-09 3.8448E-09 3.8179E-09 3.8596E-09 7.4959E-09 FOREST_AREA ----------- 2.0453E-09 2.2194E-09 1.3459E-09 1.3372E-09 1.1955E-08 1.9730E-09 3.8452E-09 1.3398E-09 1.3370E-09 1.3199E-09 1.3619E-09 FOREST_AREA ----------- 1.3581E-09 1.3459E-09 1.3580E-09 1.3432E-09 6.6840E-09 3.8722E-09 5.8279E-09 3.8701E-09 3.8700E-09 3.8378E-09 2.0069E-09 FOREST_AREA ----------- 6.5140E-09 5.2445E-09 4.3306E-09 4.6315E-09 3.7838E-09 5.8603E-07 1.7164E-07 3.8172E-07 2.8099E-07 .000020796 .00001624 FOREST_AREA ----------- 9.9895E-07 3.0254E-06 6.9015E-06 5.0354E-07 2.1489E-07 2.8058E-07 1.8001E-06 2.2344E-06 1.8731E-06 1.1483E-06 9.9228E-07 FOREST_AREA ----------- 3.5727E-06 8.3438E-07 .000032694 7.5017E-07 2.3684E-07 3.6739E-07 6.3425E-07 3.6739E-06 1.6187E-06 8.2312E-06 .000001548 FOREST_AREA ----------- 3.4592E-07 2.0236E-06 1.1926E-06 2.2148E-06 9.8227E-07 8.9669E-07 7.0084E-07 .000003906 1.4469E-06 5.9527E-07 4.4784E-07 FOREST_AREA ----------- .000080632 1.4659E-07 1.6258E-08 7.8704E-09 7.8971E-09 7.8915E-09 1.6220E-08 1.6282E-08 1.6224E-08 1.6334E-08 7.8992E-09 FOREST_AREA ----------- 3.5559E-06 6.0007E-07 4.6679E-07 5.7482E-07 1.9420E-07 6.0112E-07 1.1799E-06 2.5986E-07 4.0408E-09 4.1448E-09 4.7000E-09 FOREST_AREA ----------- 7.4431E-09 1.2926E-08 2.1939E-09 3.8699E-09 3.8416E-09 4.7002E-09 4.7025E-09 4.7105E-09 2.6084E-07 1.8258E-06 1.3072E-06 FOREST_AREA ----------- 9.5172E-07 9.9905E-07 2.5146E-07 4.0721E-07 3.7594E-06 1.0174E-06 8.7944E-06 2.2776E-06 .00000499 6.4176E-06 .000010971 FOREST_AREA ----------- 1.3366E-06 .000015781 2.7243E-06 2.4648E-06 2.0976E-06 4.1739E-06 .000019055 1.7278E-06 5.5974E-07 3.2603E-06 2.0229E-06 FOREST_AREA ----------- 3.1925E-06 .000024022 1.5718E-06 7.0864E-07 4.2925E-07 3.7742E-06 7.7472E-07 .000001201 1.2653E-07 2.7186E-07 .000024965 FOREST_AREA ----------- .000014225 2.8878E-07 2.9719E-07 .000019524 1.5276E-07 1.7969E-06 1.3533E-06 2.8522E-07 4.7108E-07 3.3512E-06 1.5929E-06 FOREST_AREA ----------- 5.4351E-06 2.9207E-06 .000018791 5.2982E-06 5.0686E-07 4.8235E-07 6.8119E-07 3.6494E-06 4.8849E-06 2.3878E-06 3.0453E-06 FOREST_AREA ----------- .000010493 1.1221E-06 6.8638E-06 1.1097E-07 8.7593E-06 8.5345E-06 .000003862 9.3423E-06 5.1539E-06 2.7876E-06 9.8378E-06 FOREST_AREA ----------- 1.0127E-06 4.4995E-06 1.6884E-06 1.5405E-06 2.3369E-07 2.2653E-06 2.4369E-06 3.0125E-07 1.5233E-06 2.8824E-06 8.3031E-07 FOREST_AREA ----------- 9.8056E-08 1.4204E-07 2.2833E-07 4.3824E-08 2.5630E-07 3.5135E-07 5.6190E-07 4.5067E-07 7.3963E-07 7.5443E-07 .000053198 FOREST_AREA ----------- 4.7099E-07 1.7818E-06 3.8229E-07 1.0049E-06 2.4244E-07 .000030008 .000070519 7.3777E-06 5.4653E-06 8.3281E-07 1.4665E-06 FOREST_AREA ----------- .00008799 .000038581 .000030707 3.0296E-06 .000014224 .000063181 .000277646 .000017057 .000081664 .000139277 3.7882E-06 FOREST_AREA ----------- .000005929 2.3495E-06 2.1681E-06 .0000021 7.6401E-07 2.8349E-07 .000019212 9.6507E-06 .000014936 4.3657E-07 2.7609E-06 FOREST_AREA ----------- .000010954 7.5404E-06 1.2263E-06 1.7871E-06 1.4149E-06 4.1544E-06 3.3185E-06 9.1707E-07 4.5572E-06 3.0921E-06 3.1838E-06 FOREST_AREA ----------- 4.8101E-07 1.1667E-07 2.6866E-07 8.1712E-07 9.3984E-08 4.5732E-07 3.2202E-07 3.8050E-08 1.1686E-06 7.1459E-06 .000004646 FOREST_AREA ----------- 7.8817E-07 3.3552E-07 7.2306E-07 9.1533E-07 7.1773E-07 3.7875E-07 .000001081 9.3175E-07 1.1046E-07 2.7461E-07 9.1467E-08 FOREST_AREA ----------- 5.6851E-07 3.6756E-07 5.7510E-08 4.0628E-07 1.2934E-07 8.7466E-07 2.4693E-07 4.2673E-07 6.7612E-07 7.7289E-08 1.0592E-06 FOREST_AREA ----------- 2.2378E-07 .000002184 1.7312E-07 4.6757E-08 9.6118E-08 7.4056E-07 1.8058E-07 1.4283E-07 1.9528E-08 3.3147E-08 6.7306E-08 FOREST_AREA ----------- 3.0076E-07 1.0002E-06 4.7422E-07 .002029319 .000084587 .000010595 .000609159 4.3985E-07 1.2821E-07 1.5736E-06 3.0771E-06 FOREST_AREA ----------- 2.0656E-07 3.4878E-06 4.8738E-07 3.8774E-07 8.9778E-07 3.7283E-07 9.7564E-07 1.3488E-06 5.5826E-07 1.4462E-06 4.7176E-07 FOREST_AREA ----------- 3.6747E-07 3.6842E-07 1.0966E-07 1.9490E-07 2.2695E-07 .000001722 2.0188E-06 5.7314E-06 1.7393E-06 9.9735E-07 5.5210E-07 FOREST_AREA ----------- 1.0301E-06 .000001834 1.7767E-07 6.7096E-08 3.1397E-06 1.7158E-06 7.8407E-06 1.4671E-06 .000011289 1.3266E-06 7.1055E-06 FOREST_AREA ----------- 5.3176E-07 .000001063 1.6641E-06 2.5246E-07 4.4719E-07 5.4255E-07 1.6099E-07 1.7919E-07 .000001512 2.4771E-06 .000019914 FOREST_AREA ----------- .000000191 5.6549E-06 1.0725E-06 4.5734E-06 .000061836 3.6438E-06 3.7198E-07 1.4006E-06 8.9793E-06 7.8211E-07 5.7145E-06 FOREST_AREA ----------- 3.6941E-06 .000012182 2.5913E-06 1.6196E-07 1.3346E-06 2.0163E-07 3.4519E-07 2.1194E-06 1.3265E-06 2.2569E-07 8.9335E-07 FOREST_AREA ----------- 6.7432E-07 5.8260E-08 8.2231E-07 8.6601E-09 2.8213E-08 1.2496E-06 1.2781E-06 4.0017E-06 4.9707E-06 7.2128E-06 9.3011E-06 FOREST_AREA ----------- .000021967 .000147756 1.4775E-06 1.7040E-07 1.5371E-07 7.8390E-07 .000003334 8.1543E-06 4.4133E-08 2.5716E-08 3.0653E-09 FOREST_AREA ----------- 9.0450E-08 2.8757E-08 3.0748E-09 2.1406E-09 2.1025E-09 2.1581E-09 8.1492E-08 1.4497E-08 2.3999E-09 2.4017E-09 2.4180E-09 FOREST_AREA ----------- 2.4021E-09 2.4204E-09 3.4213E-08 5.6780E-09 1.2717E-08 3.1138E-09 2.1470E-09 2.1289E-09 1.4722E-06 3.2286E-06 6.5206E-07 FOREST_AREA ----------- 3.0031E-06 2.3952E-07 2.4751E-06 6.7698E-06 3.6186E-07 2.6867E-07 1.0888E-06 5.5169E-06 .000011283 5.9308E-07 3.4326E-08 FOREST_AREA ----------- 4.1962E-08 6.0740E-07 3.1948E-06 1.4471E-08 2.1579E-09 8.3487E-09 5.4627E-10 2.1471E-09 1.5941E-09 1.2238E-08 8.4209E-09 FOREST_AREA ----------- 8.4211E-09 9.1015E-09 9.1402E-09 9.1488E-09 9.1396E-09 9.1291E-09 9.1325E-09 2.4970E-08 9.1291E-09 4.1050E-09 4.1250E-09 FOREST_AREA ----------- 4.0785E-09 4.1250E-09 4.1251E-09 2.5392E-08 1.7361E-07 4.3867E-07 8.4649E-08 8.4144E-08 1.3142E-07 4.1247E-07 7.6822E-08 FOREST_AREA ----------- 5.7413E-07 1.0217E-07 2.1238E-08 1.8693E-06 3.0184E-07 7.3330E-07 .000012331 1.9302E-07 1.0231E-08 1.6160E-08 5.7527E-06 FOREST_AREA ----------- 1.5334E-08 1.9081E-08 3.1184E-08 1.4108E-06 4.4892E-06 1.7696E-06 1.7889E-08 4.1250E-09 4.0636E-09 2.8198E-09 3.1803E-09 FOREST_AREA ----------- 3.1981E-09 3.5500E-09 1.8269E-07 2.9694E-07 .000001364 5.3242E-09 1.8169E-08 1.0122E-06 4.2929E-07 3.6867E-07 1.7952E-07 FOREST_AREA ----------- 2.8847E-07 9.6281E-07 1.6487E-06 8.0661E-07 3.4905E-06 3.9876E-06 .000018035 3.7302E-06 5.4021E-06 6.3491E-07 5.6872E-06 FOREST_AREA ----------- 5.7199E-07 2.7719E-07 2.3413E-07 5.3244E-09 1.4505E-07 5.3310E-09 5.3244E-09 5.3244E-09 5.3529E-09 5.3200E-09 5.3365E-09 FOREST_AREA ----------- 5.3199E-09 5.3485E-09 2.5946E-07 9.9028E-07 .000012965 .000001989 1.7219E-08 2.8227E-07 1.1275E-07 1.1137E-07 8.0715E-07 FOREST_AREA ----------- 4.7768E-08 1.4043E-07 1.2965E-07 4.2410E-08 1.0918E-06 1.5463E-06 3.8971E-07 .000002313 3.4867E-07 1.9830E-07 5.7721E-07 FOREST_AREA ----------- 3.0866E-07 1.2448E-07 4.4173E-06 3.1576E-06 1.1246E-07 1.6323E-06 1.2739E-06 8.7983E-07 7.9395E-07 6.4770E-08 2.2307E-07 FOREST_AREA ----------- 2.6541E-06 2.2960E-07 1.2253E-07 6.1867E-07 .000015702 1.6394E-06 8.7318E-07 7.4114E-07 2.2343E-06 8.0898E-09 1.4947E-08 FOREST_AREA ----------- 5.0740E-09 2.9484E-06 4.6524E-06 3.7908E-06 2.4448E-06 4.0231E-07 2.7427E-07 6.1970E-07 5.7229E-08 3.4803E-07 .000001065 FOREST_AREA ----------- 9.1610E-07 1.8140E-07 6.2379E-07 5.2679E-07 1.1915E-07 4.8929E-08 .000002881 1.1397E-06 9.7182E-07 4.7180E-07 3.5226E-07 FOREST_AREA ----------- 2.6436E-06 2.2267E-07 5.9208E-07 5.2904E-07 6.2537E-07 1.4334E-07 1.1670E-07 2.9094E-08 9.5955E-08 1.5662E-06 1.4667E-07 FOREST_AREA ----------- .000005061 1.7353E-07 8.1683E-09 8.1591E-09 8.1360E-09 8.1610E-09 8.1940E-09 8.1989E-09 .000010695 2.2201E-06 8.1667E-06 FOREST_AREA ----------- 3.4754E-06 .000017844 6.3773E-06 1.2707E-06 7.3666E-06 7.4579E-06 6.9138E-07 3.2191E-06 2.1698E-06 1.9971E-07 2.3229E-07 FOREST_AREA ----------- 5.1830E-07 2.1612E-06 3.6564E-07 4.8145E-07 2.3929E-08 1.2861E-06 2.5385E-06 5.7699E-07 5.7712E-07 3.9632E-07 8.2225E-09 FOREST_AREA ----------- 1.8352E-08 8.1612E-09 2.1052E-07 8.1941E-09 8.1968E-09 6.5197E-07 3.7506E-07 7.6639E-08 1.1466E-07 4.4077E-07 .000021293 FOREST_AREA ----------- .000011297 7.0693E-06 4.5097E-06 2.9826E-08 3.2782E-07 1.1788E-06 1.8992E-07 3.8921E-07 9.7545E-07 .000001416 1.1981E-07 FOREST_AREA ----------- 6.7108E-08 1.6009E-07 3.3339E-07 4.7689E-07 7.0331E-07 8.9095E-07 2.8935E-07 4.2214E-07 1.0578E-06 3.4580E-07 .000002564 FOREST_AREA ----------- 1.3075E-06 4.4676E-08 .000012826 3.6710E-07 .000018099 5.0639E-07 3.4528E-07 2.4726E-06 1.7731E-06 2.5019E-06 9.3605E-08 FOREST_AREA ----------- 1.1892E-06 1.4378E-06 3.2074E-07 4.0704E-06 5.3212E-07 2.6934E-07 6.2630E-07 1.2205E-06 1.8836E-07 2.3218E-07 7.3180E-08 FOREST_AREA ----------- 3.0620E-07 3.5031E-07 1.5132E-06 6.3422E-07 1.8977E-07 2.2712E-07 2.7731E-07 6.2639E-08 8.4555E-07 2.3599E-08 1.7677E-08 FOREST_AREA ----------- 1.4356E-06 3.6335E-07 1.7117E-07 2.8199E-06 1.6451E-07 3.4368E-07 8.4710E-08 7.1995E-08 1.1184E-07 5.9643E-07 4.9854E-07 FOREST_AREA ----------- 1.8452E-07 5.2283E-08 3.3681E-08 1.1283E-07 8.5924E-07 2.9975E-07 7.0136E-07 2.0646E-07 2.6952E-07 7.0295E-07 6.6994E-07 FOREST_AREA ----------- 6.0549E-08 9.5594E-08 2.0136E-07 1.3185E-08 1.3032E-07 1.3319E-07 1.3128E-07 2.1194E-07 6.4699E-08 2.8849E-06 1.4395E-06 FOREST_AREA ----------- 7.0169E-07 4.9486E-08 1.2285E-07 4.0252E-07 8.5111E-08 2.7378E-07 1.7258E-07 4.3094E-07 6.9491E-08 4.2835E-08 2.4613E-07 FOREST_AREA ----------- 4.5765E-08 6.2605E-08 4.2076E-08 2.2090E-07 2.6687E-08 1.5299E-07 .000010336 2.5681E-06 7.4237E-07 8.9469E-07 6.6085E-07 FOREST_AREA ----------- .00000019 5.4099E-08 6.0686E-06 .000000291 7.6132E-08 4.9833E-09 4.7233E-07 5.2638E-07 2.7675E-07 3.4408E-07 5.1670E-08 FOREST_AREA ----------- 1.1778E-07 1.0664E-07 7.6877E-09 1.8081E-08 1.3876E-07 7.4668E-07 2.1387E-08 1.4870E-07 1.1269E-08 6.4427E-09 2.9966E-06 FOREST_AREA ----------- 1.0314E-06 2.4349E-06 4.1659E-06 1.2421E-07 1.5579E-07 1.3408E-06 7.5739E-07 2.4312E-06 2.8209E-07 .00007161 3.2079E-07 FOREST_AREA ----------- 3.0336E-07 2.5138E-08 4.5132E-08 .000001016 1.2559E-06 .000009667 1.7247E-08 .000011133 2.3621E-06 2.6333E-08 1.2134E-07 FOREST_AREA ----------- 4.8596E-06 .000001529 6.6172E-07 1554 rows selected. SQL> SELECT max(SDO_GEOM.SDO_AREA(n.geom, 0.0000005)) as largest_park_area FROM F10C5980G30.natural n where type ='park'; LARGEST_PARK_AREA ----------------- .000336765 SQL> select SDO_GEOM.SDO_MBR(r.geom) from F10C5980G30.roads_major r where name='Rue Saint Vincent'; SDO_GEOM.SDO_MBR(R.GEOM)(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, -------------------------------------------------------------------------------- SDO_GEOMETRY(2003, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 3), SDO_ORDINATE_ARR AY(-72.835569, 19.938612, -72.830725, 19.939746)) SQL> SELECT SDO_GEOM.SDO_CENTROID(n.geom, 0.0000005) FROM F10C5980G30.natural n WHERE name = 'Parque Central'; SDO_GEOM.SDO_CENTROID(N.GEOM,0.0000005)(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), -------------------------------------------------------------------------------- SDO_GEOMETRY(2001, NULL, SDO_POINT_TYPE(-70.693255, 19.7976301, NULL), NULL, NUL L) SDO_GEOMETRY(2001, NULL, SDO_POINT_TYPE(-68.966362, 18.4227424, NULL), NULL, NUL L) SQL> select r.type, sum(SDO_GEOM.SDO_LENGTH(r.geom,0.0000005)) from F10C5980G30.roads_major r group by type; TYPE SUM(SDO_GEOM.SDO_LENGTH(R.GEOM,0.0000005)) ---------------- ------------------------------------------ primary 31.051421 secondary 27.5417142 tertiary 11.6324396 SQL> select p.osm_id as park_OSM_id, w.osm_id as water_OSM_id from F10C5980G30.natural p, F10C5980G30.natural w where (p.name is not null) and (w.name is not null) and (p.type = 'park') and (w.type = 'water') and (SDO_GEOM.SDO_DISTANCE(p.geom, w.geom, 0.00005) <= 1); PARK_OSM_ID WATER_OSM_ID ----------- ------------ 48233521 23862190 48233545 23862190 48237535 23862190 48278092 23862190 48279483 23862190 48330034 23862190 48371950 23862190 48546409 23862190 48587502 23862190 30927839 25339712 31337337 25339712 PARK_OSM_ID WATER_OSM_ID ----------- ------------ 31361163 25339712 31667245 25339712 31796351 25339712 31796897 25339712 31800156 25339712 32863365 25339712 32871526 25339712 33148232 25339712 48587502 25339712 48233521 48272029 48233545 48272029 PARK_OSM_ID WATER_OSM_ID ----------- ------------ 48237535 48272029 48278092 48272029 48279483 48272029 48330034 48272029 48546409 48272029 48587502 48272029 48233521 48386796 48233545 48386796 48237535 48386796 48278092 48386796 48279483 48386796 PARK_OSM_ID WATER_OSM_ID ----------- ------------ 48330034 48386796 48371950 48386796 48546409 48386796 48377621 48390937 48371950 48390937 48411458 48390937 48423555 48390937 48587502 48390937 48233521 48408722 48233545 48408722 48237535 48408722 PARK_OSM_ID WATER_OSM_ID ----------- ------------ 48278092 48408722 48279483 48408722 48330034 48408722 48546409 48408722 48233521 48490937 48233545 48490937 48237535 48490937 48278092 48490937 48279483 48490937 48330034 48490937 48587502 48490937 PARK_OSM_ID WATER_OSM_ID ----------- ------------ 48377621 48523638 48371950 48523638 48411458 48523638 48423555 48523638 48233521 48584753 48233545 48584753 48237535 48584753 48278092 48584753 48279483 48584753 48330034 48584753 48546409 48584753 PARK_OSM_ID WATER_OSM_ID ----------- ------------ 48233521 48616024 48233545 48616024 48237535 48616024 48278092 48616024 48279483 48616024 48330034 48616024 48546409 48616024 30927839 48770270 31337337 48770270 33148232 48770270 48377621 48770270 PARK_OSM_ID WATER_OSM_ID ----------- ------------ 48371950 48770270 48411458 48770270 48423555 48770270 48587502 48770270 48377621 48665695 48371950 48665695 48411458 48665695 48423555 48665695 48587502 48665695 48233521 48718928 48233545 48718928 PARK_OSM_ID WATER_OSM_ID ----------- ------------ 48237535 48718928 48278092 48718928 48279483 48718928 48330034 48718928 48546409 48718928 48233521 50160769 48233545 50160769 48237535 50160769 48278092 50160769 48279483 50160769 48330034 50160769 PARK_OSM_ID WATER_OSM_ID ----------- ------------ 48377621 50160769 48371950 50160769 48411458 50160769 48423555 50160769 48546409 50160769 48587502 50160769 105 rows selected. SQL> select SDO_GEOM.SDO_UNION(p1.geom, p2.geom, 0.00005) as GeoUnion from F10C5980G30.natural p1, F10C5980G30.natural p2 where (p1.name = 'Parque Central') and (p2.name = 'Parque Central') and (p1.osm_id < p2.osm_id); GEOUNION(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_ORDINATES) -------------------------------------------------------------------------------- SDO_GEOMETRY(2007, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 1, 13, 1003, 1), SDO _ORDINATE_ARRAY(-70.692865, 19.797784, -70.692985, 19.797848, -70.693371, 19.797 969, -70.693629, 19.797517, -70.6932, 19.797243, -70.692865, 19.797784, -68.9666 24, 18.423275, -68.966865, 18.423006, -68.966873, 18.422469, -68.966599, 18.4222 08, -68.966135, 18.4222, -68.965861, 18.422445, -68.965869, 18.423039, -68.96609 2, 18.423275, -68.966624, 18.423275)) SQL> select n.osm_id,a.id from F10C5980G30.natural n,F10C5980G30.activities a where a.verified='YES' and SDO_GEOM.WITHIN_DISTANCE(n.geom,1,a.geom,0.00005)='TRUE' and n.osm_id in (select n.osm_id from F10C5980G30.natural n,F10C5980G30.activities a where n.type='park' and n.name is not null and a.verified='YES' and SDO_GEOM.WITHIN_DISTANCE(n.geom,1,a.geom,0.00005)='TRUE' group by osm_id having count(*)>=10); OSM_ID ID ---------- ---------- 48233521 130 48233521 140 48233521 1 48233521 4 48233521 9 48233521 12 48233521 23 48233521 25 48233521 320 48233521 334 48233521 339 OSM_ID ID ---------- ---------- 48233521 363 48233521 291 48233521 292 48233521 294 48233521 302 48233521 303 48233521 305 48233521 306 48233521 315 48233521 316 48233521 317 OSM_ID ID ---------- ---------- 48233521 319 48233521 188 48233521 385 48233521 445 48233521 471 48233521 474 48233521 508 48233521 525 48233521 670 48233521 827 48233521 719 OSM_ID ID ---------- ---------- 48233521 731 48233521 757 48233521 589 48233521 618 48233521 1005 48233521 1011 48233521 1025 48233521 1030 48233521 1043 48233521 1061 48233521 906 OSM_ID ID ---------- ---------- 48233521 919 48233521 958 48233521 966 48233521 968 48233521 989 48233521 993 48233521 1148 48233521 1152 48233521 1155 48233521 1193 48233521 1277 OSM_ID ID ---------- ---------- 48233521 1280 48233521 1282 48233521 1289 48233521 1292 48233521 1300 48233521 1304 48233521 1310 48233521 1311 48233521 1312 48233521 1314 48233521 1315 OSM_ID ID ---------- ---------- 48233521 1320 48233521 1322 48233521 1328 48233521 1331 48233521 1332 48233521 1335 48233521 1337 48233521 1209 48233521 1213 48233521 1216 48233521 1219 OSM_ID ID ---------- ---------- 48233521 1222 48233521 1223 48233521 1225 48233521 1228 48233521 1232 48233521 1237 48233521 1257 48233521 1267 48233521 1274 48233521 1066 48233521 1073 OSM_ID ID ---------- ---------- 48233521 1089 48233521 1090 48233521 1092 48233521 1113 48233521 1115 48233521 1116 48233521 1122 48233521 1123 48233521 1124 48233521 1575 48233521 1412 OSM_ID ID ---------- ---------- 48233521 1413 48233521 1417 48233521 1430 48233521 1433 48233521 1435 48233521 1492 48233521 1621 48233521 1662 48233521 1664 48233521 1669 48233521 1677 OSM_ID ID ---------- ---------- 48233545 130 48233545 140 48233545 1 48233545 4 48233545 9 48233545 12 48233545 23 48233545 25 48233545 320 48233545 334 48233545 339 OSM_ID ID ---------- ---------- 48233545 363 48233545 291 48233545 292 48233545 294 48233545 302 48233545 303 48233545 305 48233545 306 48233545 315 48233545 316 48233545 317 OSM_ID ID ---------- ---------- 48233545 319 48233545 188 48233545 385 48233545 445 48233545 471 48233545 474 48233545 508 48233545 525 48233545 670 48233545 827 48233545 719 OSM_ID ID ---------- ---------- 48233545 731 48233545 757 48233545 589 48233545 618 48233545 1005 48233545 1011 48233545 1025 48233545 1030 48233545 1043 48233545 1061 48233545 906 OSM_ID ID ---------- ---------- 48233545 919 48233545 958 48233545 966 48233545 968 48233545 989 48233545 993 48233545 1148 48233545 1152 48233545 1155 48233545 1193 48233545 1277 OSM_ID ID ---------- ---------- 48233545 1280 48233545 1282 48233545 1289 48233545 1292 48233545 1300 48233545 1304 48233545 1310 48233545 1311 48233545 1312 48233545 1314 48233545 1315 OSM_ID ID ---------- ---------- 48233545 1320 48233545 1322 48233545 1328 48233545 1331 48233545 1332 48233545 1335 48233545 1337 48233545 1209 48233545 1213 48233545 1216 48233545 1219 OSM_ID ID ---------- ---------- 48233545 1222 48233545 1223 48233545 1225 48233545 1228 48233545 1232 48233545 1237 48233545 1257 48233545 1267 48233545 1274 48233545 1066 48233545 1073 OSM_ID ID ---------- ---------- 48233545 1089 48233545 1090 48233545 1092 48233545 1113 48233545 1115 48233545 1116 48233545 1122 48233545 1123 48233545 1124 48233545 1575 48233545 1412 OSM_ID ID ---------- ---------- 48233545 1413 48233545 1417 48233545 1430 48233545 1433 48233545 1435 48233545 1492 48233545 1621 48233545 1662 48233545 1664 48233545 1669 48233545 1677 OSM_ID ID ---------- ---------- 48237535 130 48237535 140 48237535 1 48237535 4 48237535 9 48237535 12 48237535 23 48237535 25 48237535 320 48237535 334 48237535 339 OSM_ID ID ---------- ---------- 48237535 363 48237535 291 48237535 292 48237535 294 48237535 302 48237535 303 48237535 305 48237535 306 48237535 315 48237535 316 48237535 317 OSM_ID ID ---------- ---------- 48237535 319 48237535 188 48237535 385 48237535 445 48237535 471 48237535 474 48237535 508 48237535 525 48237535 670 48237535 827 48237535 719 OSM_ID ID ---------- ---------- 48237535 731 48237535 757 48237535 589 48237535 618 48237535 1005 48237535 1011 48237535 1025 48237535 1030 48237535 1043 48237535 1061 48237535 906 OSM_ID ID ---------- ---------- 48237535 919 48237535 958 48237535 966 48237535 968 48237535 989 48237535 993 48237535 1148 48237535 1152 48237535 1155 48237535 1193 48237535 1277 OSM_ID ID ---------- ---------- 48237535 1280 48237535 1282 48237535 1289 48237535 1292 48237535 1300 48237535 1304 48237535 1310 48237535 1311 48237535 1312 48237535 1314 48237535 1315 OSM_ID ID ---------- ---------- 48237535 1320 48237535 1322 48237535 1328 48237535 1331 48237535 1332 48237535 1335 48237535 1337 48237535 1209 48237535 1213 48237535 1216 48237535 1219 OSM_ID ID ---------- ---------- 48237535 1222 48237535 1223 48237535 1225 48237535 1228 48237535 1232 48237535 1237 48237535 1257 48237535 1267 48237535 1274 48237535 1066 48237535 1073 OSM_ID ID ---------- ---------- 48237535 1089 48237535 1090 48237535 1092 48237535 1113 48237535 1115 48237535 1116 48237535 1122 48237535 1123 48237535 1124 48237535 1575 48237535 1412 OSM_ID ID ---------- ---------- 48237535 1413 48237535 1417 48237535 1430 48237535 1433 48237535 1435 48237535 1492 48237535 1621 48237535 1662 48237535 1664 48237535 1669 48237535 1677 OSM_ID ID ---------- ---------- 48278092 130 48278092 140 48278092 1 48278092 4 48278092 9 48278092 12 48278092 23 48278092 25 48278092 320 48278092 334 48278092 339 OSM_ID ID ---------- ---------- 48278092 363 48278092 291 48278092 292 48278092 294 48278092 302 48278092 303 48278092 305 48278092 306 48278092 315 48278092 316 48278092 317 OSM_ID ID ---------- ---------- 48278092 319 48278092 188 48278092 385 48278092 445 48278092 471 48278092 474 48278092 508 48278092 525 48278092 670 48278092 827 48278092 719 OSM_ID ID ---------- ---------- 48278092 731 48278092 757 48278092 589 48278092 618 48278092 1005 48278092 1011 48278092 1025 48278092 1030 48278092 1043 48278092 1061 48278092 906 OSM_ID ID ---------- ---------- 48278092 919 48278092 958 48278092 966 48278092 968 48278092 989 48278092 993 48278092 1148 48278092 1152 48278092 1155 48278092 1193 48278092 1277 OSM_ID ID ---------- ---------- 48278092 1280 48278092 1282 48278092 1289 48278092 1292 48278092 1300 48278092 1304 48278092 1310 48278092 1311 48278092 1312 48278092 1314 48278092 1315 OSM_ID ID ---------- ---------- 48278092 1320 48278092 1322 48278092 1328 48278092 1331 48278092 1332 48278092 1335 48278092 1337 48278092 1209 48278092 1213 48278092 1216 48278092 1219 OSM_ID ID ---------- ---------- 48278092 1222 48278092 1223 48278092 1225 48278092 1228 48278092 1232 48278092 1237 48278092 1257 48278092 1267 48278092 1274 48278092 1066 48278092 1073 OSM_ID ID ---------- ---------- 48278092 1089 48278092 1090 48278092 1092 48278092 1113 48278092 1115 48278092 1116 48278092 1122 48278092 1123 48278092 1124 48278092 1575 48278092 1412 OSM_ID ID ---------- ---------- 48278092 1413 48278092 1417 48278092 1430 48278092 1433 48278092 1435 48278092 1492 48278092 1621 48278092 1662 48278092 1664 48278092 1669 48278092 1677 OSM_ID ID ---------- ---------- 48279483 130 48279483 140 48279483 1 48279483 4 48279483 9 48279483 12 48279483 23 48279483 25 48279483 320 48279483 334 48279483 339 OSM_ID ID ---------- ---------- 48279483 363 48279483 291 48279483 292 48279483 294 48279483 302 48279483 303 48279483 305 48279483 306 48279483 315 48279483 316 48279483 317 OSM_ID ID ---------- ---------- 48279483 319 48279483 188 48279483 385 48279483 445 48279483 471 48279483 474 48279483 508 48279483 525 48279483 670 48279483 827 48279483 719 OSM_ID ID ---------- ---------- 48279483 731 48279483 757 48279483 589 48279483 618 48279483 1005 48279483 1011 48279483 1025 48279483 1030 48279483 1043 48279483 1061 48279483 906 OSM_ID ID ---------- ---------- 48279483 919 48279483 958 48279483 966 48279483 968 48279483 989 48279483 993 48279483 1148 48279483 1152 48279483 1155 48279483 1193 48279483 1277 OSM_ID ID ---------- ---------- 48279483 1280 48279483 1282 48279483 1289 48279483 1292 48279483 1300 48279483 1304 48279483 1310 48279483 1311 48279483 1312 48279483 1314 48279483 1315 OSM_ID ID ---------- ---------- 48279483 1320 48279483 1322 48279483 1328 48279483 1331 48279483 1332 48279483 1335 48279483 1337 48279483 1209 48279483 1213 48279483 1216 48279483 1219 OSM_ID ID ---------- ---------- 48279483 1222 48279483 1223 48279483 1225 48279483 1228 48279483 1232 48279483 1237 48279483 1257 48279483 1267 48279483 1274 48279483 1066 48279483 1073 OSM_ID ID ---------- ---------- 48279483 1089 48279483 1090 48279483 1092 48279483 1113 48279483 1115 48279483 1116 48279483 1122 48279483 1123 48279483 1124 48279483 1575 48279483 1412 OSM_ID ID ---------- ---------- 48279483 1413 48279483 1417 48279483 1430 48279483 1433 48279483 1435 48279483 1492 48279483 1621 48279483 1662 48279483 1664 48279483 1669 48279483 1677 OSM_ID ID ---------- ---------- 48330034 130 48330034 140 48330034 1 48330034 4 48330034 9 48330034 12 48330034 23 48330034 25 48330034 320 48330034 334 48330034 339 OSM_ID ID ---------- ---------- 48330034 363 48330034 291 48330034 292 48330034 294 48330034 302 48330034 303 48330034 305 48330034 306 48330034 315 48330034 316 48330034 317 OSM_ID ID ---------- ---------- 48330034 319 48330034 188 48330034 385 48330034 445 48330034 471 48330034 474 48330034 508 48330034 525 48330034 670 48330034 827 48330034 719 OSM_ID ID ---------- ---------- 48330034 731 48330034 757 48330034 589 48330034 618 48330034 1005 48330034 1011 48330034 1025 48330034 1030 48330034 1043 48330034 1061 48330034 906 OSM_ID ID ---------- ---------- 48330034 919 48330034 958 48330034 966 48330034 968 48330034 989 48330034 993 48330034 1148 48330034 1152 48330034 1155 48330034 1193 48330034 1277 OSM_ID ID ---------- ---------- 48330034 1280 48330034 1282 48330034 1289 48330034 1292 48330034 1300 48330034 1304 48330034 1310 48330034 1311 48330034 1312 48330034 1314 48330034 1315 OSM_ID ID ---------- ---------- 48330034 1320 48330034 1322 48330034 1328 48330034 1331 48330034 1332 48330034 1335 48330034 1337 48330034 1209 48330034 1213 48330034 1216 48330034 1219 OSM_ID ID ---------- ---------- 48330034 1222 48330034 1223 48330034 1225 48330034 1228 48330034 1232 48330034 1237 48330034 1257 48330034 1267 48330034 1274 48330034 1066 48330034 1073 OSM_ID ID ---------- ---------- 48330034 1089 48330034 1090 48330034 1092 48330034 1113 48330034 1115 48330034 1116 48330034 1122 48330034 1123 48330034 1124 48330034 1575 48330034 1412 OSM_ID ID ---------- ---------- 48330034 1413 48330034 1417 48330034 1430 48330034 1433 48330034 1435 48330034 1492 48330034 1621 48330034 1662 48330034 1664 48330034 1669 48330034 1677 OSM_ID ID ---------- ---------- 48377621 303 48377621 719 48377621 1021 48377621 1292 48377621 1293 48377621 1294 48377621 1298 48377621 1310 48377621 1316 48377621 1099 48377621 1417 OSM_ID ID ---------- ---------- 48377621 1621 48371950 140 48371950 4 48371950 12 48371950 23 48371950 25 48371950 320 48371950 334 48371950 339 48371950 363 48371950 291 OSM_ID ID ---------- ---------- 48371950 292 48371950 294 48371950 302 48371950 303 48371950 305 48371950 306 48371950 315 48371950 317 48371950 319 48371950 188 48371950 445 OSM_ID ID ---------- ---------- 48371950 471 48371950 474 48371950 670 48371950 827 48371950 719 48371950 731 48371950 757 48371950 618 48371950 1005 48371950 1011 48371950 1021 OSM_ID ID ---------- ---------- 48371950 1025 48371950 1030 48371950 1061 48371950 906 48371950 919 48371950 993 48371950 1148 48371950 1152 48371950 1155 48371950 1193 48371950 1277 OSM_ID ID ---------- ---------- 48371950 1280 48371950 1292 48371950 1293 48371950 1294 48371950 1298 48371950 1300 48371950 1304 48371950 1310 48371950 1311 48371950 1312 48371950 1316 OSM_ID ID ---------- ---------- 48371950 1320 48371950 1322 48371950 1328 48371950 1332 48371950 1335 48371950 1209 48371950 1213 48371950 1216 48371950 1219 48371950 1222 48371950 1223 OSM_ID ID ---------- ---------- 48371950 1225 48371950 1228 48371950 1232 48371950 1267 48371950 1274 48371950 1066 48371950 1073 48371950 1089 48371950 1090 48371950 1099 48371950 1113 OSM_ID ID ---------- ---------- 48371950 1115 48371950 1116 48371950 1123 48371950 1124 48371950 1575 48371950 1412 48371950 1413 48371950 1417 48371950 1430 48371950 1435 48371950 1492 OSM_ID ID ---------- ---------- 48371950 1621 48371950 1662 48371950 1664 48371950 1669 48371950 1677 48411458 303 48411458 719 48411458 1021 48411458 1292 48411458 1293 48411458 1294 OSM_ID ID ---------- ---------- 48411458 1298 48411458 1310 48411458 1316 48411458 1099 48411458 1417 48411458 1621 48423555 303 48423555 719 48423555 1021 48423555 1292 48423555 1293 OSM_ID ID ---------- ---------- 48423555 1294 48423555 1298 48423555 1310 48423555 1316 48423555 1099 48423555 1417 48423555 1621 48546409 130 48546409 140 48546409 1 48546409 4 OSM_ID ID ---------- ---------- 48546409 9 48546409 12 48546409 23 48546409 25 48546409 320 48546409 334 48546409 339 48546409 363 48546409 291 48546409 292 48546409 294 OSM_ID ID ---------- ---------- 48546409 302 48546409 303 48546409 305 48546409 306 48546409 315 48546409 316 48546409 317 48546409 319 48546409 188 48546409 385 48546409 445 OSM_ID ID ---------- ---------- 48546409 471 48546409 474 48546409 508 48546409 525 48546409 670 48546409 827 48546409 719 48546409 731 48546409 757 48546409 589 48546409 618 OSM_ID ID ---------- ---------- 48546409 1005 48546409 1011 48546409 1022 48546409 1025 48546409 1030 48546409 1043 48546409 1061 48546409 906 48546409 919 48546409 958 48546409 966 OSM_ID ID ---------- ---------- 48546409 968 48546409 989 48546409 993 48546409 1148 48546409 1152 48546409 1155 48546409 1193 48546409 1277 48546409 1280 48546409 1282 48546409 1292 OSM_ID ID ---------- ---------- 48546409 1297 48546409 1300 48546409 1304 48546409 1308 48546409 1310 48546409 1311 48546409 1312 48546409 1314 48546409 1315 48546409 1320 48546409 1322 OSM_ID ID ---------- ---------- 48546409 1328 48546409 1331 48546409 1332 48546409 1335 48546409 1209 48546409 1213 48546409 1216 48546409 1219 48546409 1222 48546409 1223 48546409 1225 OSM_ID ID ---------- ---------- 48546409 1228 48546409 1232 48546409 1257 48546409 1267 48546409 1273 48546409 1274 48546409 1066 48546409 1073 48546409 1089 48546409 1090 48546409 1092 OSM_ID ID ---------- ---------- 48546409 1113 48546409 1115 48546409 1116 48546409 1122 48546409 1123 48546409 1124 48546409 1575 48546409 1412 48546409 1413 48546409 1417 48546409 1430 OSM_ID ID ---------- ---------- 48546409 1433 48546409 1435 48546409 1492 48546409 1621 48546409 1648 48546409 1662 48546409 1664 48546409 1669 48546409 1677 48587502 4 48587502 303 OSM_ID ID ---------- ---------- 48587502 719 48587502 1021 48587502 1292 48587502 1293 48587502 1298 48587502 1310 48587502 1316 48587502 1099 48587502 1417 48587502 1621 912 rows selected. SQL> select r.name as longest_road from F10C5980G30.roads_major r where SDO_GEOM.SDO_LENGTH(r.geom,0.0000005) = (select max(SDO_GEOM.SDO_LENGTH(r.geom,0.0000005)) from F10C5980G30.roads_major r); LONGEST_ROAD ------------------------------------------------ cruce de rincon SQL> select * from (SELECT r.name, SDO_GEOM.SDO_DISTANCE(r.geom, a.geom, 0.00005) as Distance_from_Road from F10C5980G30.roads_major r, F10C5980G30.activities a where r.oneway=1 and a.id=(SELECT id FROM F10C5980G30.activities WHERE latitude=18.543376 AND longitude=-72.338883) AND r.name IS NOT NULL order by Distance_from_Road) WHERE ROWNUM=1; NAME DISTANCE_FROM_ROAD ------------------------------------------------ ------------------ Rue Saint-Honor?? .003385267 SQL> spool off;