Oracle Spatial Map Viewer SELECT SDOGEOM SDOINTERSECTIONb geometry
Oracle Spatial Map. Viewer SELECT SDO_GEOM. SDO_INTERSECTION(b. geometry, a. geometry, 0. 00005) as geometry FROM state_hwy_all_ahtd a, counties_tig 2000 b WHERE b. ID = 72 and (MDSYS. SDO_RELATE(a. GEOMETRY, b. GEOMETRY, 'mask=ANYINTERACT querytype = WINDOW') = 'TRUE'); SELECT geometry FROM counties_tig 2000 WHERE id = 72; Oracle Map. Viewer Spatial Database
What you get without a visualization Tool like Map. Viewer SQL> SELECT geometry 2 FROM counties_tig 2000 3 WHERE id = 72; GEOMETRY(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_ORDINATES) ----------------------------------------SDO_GEOMETRY(2003, 8265, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 1), SDO_ORDINATE_ARR AY(-94. 296909, 35. 755186, -94. 291015, 35. 755018, -94. 287202, 35. 754909, -94. 285765, 35. 754868, -94. 283985, 35. 754817, -94. 283496, 35. 754793, -94. 28268, 35. 754754, -94. 280998, 35. 754707, -94. 269182, 35. 754382, -94. 26536, 35. 754277, -94. 256629, 35. 754037, -94. 255321, 35. 754001, -94. 250222, 35. 754121, 94. 250207, 35. 75413, -94. 248333, 35. 754143, -94. 243821, 35. 754008, -94. 22434, 35. 753396, -94. 220672, 35. 753211, -94. 217445, 35. 75305, -94. 215343, 35. 752945, -94. 212507, 35. 75292, -94. 211812, 35. 752915, -94. 206826, 35. 752874, -94. 205941, 35. 752849, -94. 201397, 35. 752721, -94. 193122, 35. 752488, -94. 187717, 5. 752337, -94. 178993, 35. 752039, -94. 177756, 35. 751997, -94. 167248, 35. 751638, -94. 162675, 35. 751501, -94. 157451, 35. 751311, -94. 153921, 35. 751184, 94. 146535, 35. 750989, -94. 144239, 35. 750928, -94. 137726, 35. 750756, -94. 133652, 35. 750648, -94. 133326, 35. 75064, -94. 133147, 35. 750635, -94. 132304, 35. 750608, -94. 128826, 35. 750497, -94. 125203, 35. 750426, -94. 124754, 35. 753143, -94. 124258, 35. 764636, -94. 122848, 35. 764605, -94. 116482, 35. 76447, 94. 106411, 35. 764255, -94. 103594, 35. 764195, -94. 095234, 35. 764017, -94. 08872, 35. 763879, -94. 083817, 35. 763764, -94. 083136, 35. 763749, -94. 067246, 35. 763381, -94. 053159, 35. 763055, -94. 052729, 35. 763043, -94. 048399, 35. 762927, -94. 04556, 35. 762805, -94. 044549, 35. 762772, -94. 040078, 35. 762651, 94. 039807, 35. 762692, -94. 038166, 35. 762648, -94. 035413, 35. 762574, -94. 020856, 35. 762193, -94. 017736, 35. 762098, -94. 01776, 35. 761895, -94. 014095 , 35. 761727, -94. 000199, 35. 761414, -93. 984948, 35. 76134, -93. 975313, 35. 76119, -93. 972647, 35. 761112, -93. 966092, 35. 760999, -93. 964544, 35. 760966, 93. 963041, 35. 760934, -93. 962892, 35. 76093, -93. 962861, 35. 763688, -93. 962814, 35. 765283, -93. 962323, 35. 78321, -93. 962118, 35. 789181, -93. 961596, 35. 804326, -93. 961298, 35. 812973, -93. 961236, 35. 814721, -93. 960923, 35. 823684, -93. 960619, 35. 833283, -93. 952587, 35. 833261, -93. 951846, 35. 833259, -93. 951713, 35. 836126, -93. 951611, 35. 837561, -93. 951453, 35. 839807, -93. 95131, 35. 844078, -93. 951278, 35. 844621, -93. 951149, 35. 846863, -93. 951078, 35. 849422, 93. 951045, 35. 852433, -93. 950952, 35. 857002, -93. 950731, 35. 860336, -93. 950704, 35. 862215, -93. 950604, 35. 869402, -93. 950454, 35. 875079, -93. 949975, 35. 889285, -93. 949917, 35. 890992, -93. 949884, 35. 89201, -93. 949612, 35. 903932, -93. 949577, 35. 904125, -93. 949436, 35. 909307, -93. 949434, 35. 909367, 93. 949324, 35. 9134, -93. 949243, 35. 91608, -93. 949142, 35. 919446, -93. 949016, 35. 923653, -93. 948959, 35. 92556, -93. 948836, 35. 930237, -93. 948661, 35. 936954, 93. 948584, 35. 938963, -93. 948206, 35. 948864, -93. 947881, 35. 957437, -93. 947761, 35. 960612, -93. 947487, 35. 969706, -93. 947323, 35. 975783, -93. 947259, 35. 978132, -93. 947179, 35. 981147, -93. 946796, 35. 990257, -93. 946829, 35. 992671, -93. 946847, 35. 993917, -93. 946912, 35. 994292, -93. 946743, 35. 99601, 93. 946533, 36. 000078, -93. 946494, 36. 003816, -93. 946457, 36. 007363, -93. 946439, 36. 00799, -93. 946398, 36. 009446, -93. 946368, 36. 010956, -93. 946103, 36. 020622, -93. 945754, 36. 033359, -93. 945732, 36. 034163, -93. 945539, 36. 041221, -93. 945274, 36. 050885, -93. 945008, 36. 060601, -93. 944816, 36. 067608, 93. 944761, 36. 069649, -93. 944705, 36. 071698, -93. 944625, 36. 074621, -93. 944473, 36. 080186, -93. 944441, 36. 081341, -93. 944434, 36. 081633, -93. 944427, 36. 081919, -93. 944399, 36. 082949, -93. 944272, 36. 087627, -93. 944177, 36. 091103, -93. 937496, 36. 108274, -93. 93325, 36. 119191, -93. 932634, 36. 120778, 93. 931913, 36. 122633, -93. 930891, 36. 125076, -93. 928374, 36. 131487, -93. 927257, 36. 134336, -93. 925555, 36. 138675, -93. 921977, 36. 147794, -93. 92175, 36. 148373, -93. 921559, 36. 14886, -93. 919174, 36. 154938, -93. 91876, 36. 155973, -93. 915907, 36. 163242, -93. 915807, 36. 163497, -93. 913119, 36. 170346, -93. 912068, 36. 173026, -93. 90814, 36. 183034, -93. 905141, 36. 190677, -93. 90328, 36. 195419, -93. 901299, 36. 200467, -93. 898999, 36. 20633, -93. 897477, 36. 210209, -93. 895878, 36. 214285, -93. 894763, 36. 217091, -93. 892067, 36. 22396, -93. 889555, 36. 23036, -93. 888437, 36. 233207, -93. 888346, 36. 23346, -93. 887775, 36. 235046, -93. 887915, 36. 235023, -93. 889423, 36. 235233, -93. 90436, 36. 235501, -93. 91586, 36. 235707, -93. 920146, 36. 235768, -93. 923711, 36. 23583, -93. 932045, 36. 235975, -93. 937313, 36. 236064, -93. 940224, 36. 236113, -93. 940649, 36. 23612, -93. 943584, 36. 236171, -93. 944114, 36. 23618, -93. 946686, 36. 236203, 93. 966748, 36. 236587, -93. 967295, 36. 236597, -93. 976428, 36. 236771, -93. 977081, 36. 236783, -93. 989911, 36. 237029, -93. 990587, 36. 237042, -93. 991081, 36. 237051, -93. 99208, 36. 237107, -93. 994369, 36. 23714, -94. 000199, 36. 237232, -94. 001942, 36. 237368, -94. 003514, 36. 237444, -94. 007298, 36. 237498, 94. 011906, 36. 237635, -94. 011967, 36. 236437, -94. 012028, 36. 230517, -94. 012135, 36. 227473, -94. 012242, 36. 222636, -94. 012303, 36. 221598, -94. 012315, 36. 221168, -94. 01241, 36. 217623, -94. 012517, 36. 216654, -94. 012517, 36. 216044, -94. 012684, 36. 211787, -94. 012745, 36. 208704, -94. 012791, 36. 208361, 94. 014247, 36. 208312, -94. 015294, 36. 208277, -94. 017547, 36. 208277, -94. 01952, 36. 208277, -94. 031271, 36. 208141, -94. 033376, 36. 208233, -94. 037 38, 36. 208407, -94. 041601, 36. 208591, -94. 043707, 36. 208683, -94. 048635, 36. 208759, -94. 05747, 36. 20898, -94. 066352, 36. 209247, -94. 067816, 36. 20924, 94. 075293, 36. 209369, -94. 084342, 36. 209507, -94. 087042, 36. 209514, -94. 088019, 36. 209552, -94. 088767, 36. 209591, -94. 093329, 36. 209766, -94. 102424, 36. 209812, -94. 10691, 36. 20998, -94. 109611, 36. 210033, -94. 110923, 36. 210025, -94. 113471, 36. 210063, -94. 113533, 36. 210064, -94. 11515, 36. 210109, -94. 119784, 36. 210185, -94. 119911, 36. 210187, -94. 122002, 36. 210177, -94. 124302, 36. 210277, -94. 126684, 36. 210192, -94. 127102, 36. 210177, -94. 128876, 36. 210177, 94. 129694, 36. 210177, -94. 130303, 36. 210177, -94. 131662, 36. 210222, -94. 133303, 36. 210277, -94. 134103, 36. 210177, -94. 137703, 36. 210277, -94. 142203, 36. 210377, -94. 145403, 36. 210477, -94. 149003, 36. 210677, -94. 151081, 36. 210677, -94. 151203, 36. 210677, -94. 153403, 36. 210777, -94. 154103, 36. 210777, 94. 155503, 36. 210877, -94. 160303, 36. 210977, -94. 169372, 36. 21118, -94. 173704, 36. 211277, -94. 173715, 36. 211282, -94. 177706, 36. 211392, -94. 178537, 36. 211415, -94. 179406, 36. 211461, -94. 18091, 36. 21154, -94. 181742, 36. 211583, -94. 182138, 36. 211513, -94. 182215, 36. 211499, -94. 182871, 36. 211499 , -94. 183359, 36. 211499…………………
http: //tpol. cast. uark. edu: 8888/mapviewer/demo/jview. jsp Display the counties and state highways SELECT geometry FROM counties_tig 2000 SELECT geometry FROM state_hwy_all_ahtd
Primary and Secondary Spatial Filters Display Washington and Benton Counties as background SELECT a. geometry FROM counties_tig 2000 a WHERE a. abname = 'Washington County‘ OR a. abname = ‘Benton County’ Display Washington County schools using only the primary filter SELECT a. geometry FROM public_schools_k 12_src a, counties_tig 2000 b WHERE b. abname = 'Washington County' AND SDO_FILTER(a. geometry, b. geometry) = 'TRUE' Display Washington County schools using the primary filter and secondary filters SELECT a. geometry FROM public_schools_k 12_src a, counties_tig 2000 b WHERE b. abname = 'Washington County' AND SDO_RELATE(a. geometry, b. geometry, 'mask=ANYINTERACT') = 'TRUE'
Buffers Show the railroad that passes though Greenland plus the area covered by a 300 foot buffer around the railroad. SELECT a. geometry FROM city_limits 2003_ahtd a WHERE a. city_name = 'Greenland' SELECT a. geometry FROM railroads_tig 99 a, city_limits 2003_ahtd b WHERE b. city_name = 'Greenland' and SDO_RELATE(a. geometry, b. geometry, 'mask=ANYINTERACT') = 'TRUE' SELECT SDO_GEOM. SDO_BUFFER(a. geometry, 300. 0, 0. 0005, 'UNIT=FOOT' ) FROM railroads_tig 99 a, city_limits 2003_ahtd b WHERE b. city_name = 'Greenland' and SDO_RELATE(a. geometry, b. geometry, 'mask=ANYINTERACT') = 'TRUE'
Within Distance Locate all of the schools within 10 miles of Bob’s house Select a. geometry from counties_tig 2000 a where a. abname = 'Washington County' SELECT a. geometry FROM bobs_house a Where id = 1 SELECT a. geometry FROM public_schools_k 12_src a, bobs_house b WHERE b. id = 1 and SDO_GEOM. SDO_DISTANCE(b. geometry, a. geometry, 0. 005, 'UNIT=MILE') < 10. 0
Oracle Spatial Geo. Raster http: //tpol. cast. uark. edu: 8888/mapviewer/demo/georaster. jsp
- Slides: 7