Guest User

Untitled

a guest
Apr 17th, 2018
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. db = CITY
  2. Table 1 : parkingzones PK
  3. id_parking
  4. SHAPE
  5.  
  6. Table 2 : dangerareas DA
  7. id_area
  8. SHAPE
  9.  
  10. SELECT
  11. (area_parkings/area_zones*100) as pct_overlap
  12.  
  13. FROM
  14. (SELECT(SDO_GEOM.SDO_AREA
  15. (SDO_GEOM.SDO_INTERSECTION(PK.SHAPE,DA.SHAPE,0,05)0,05)) area_parkings
  16. FROM CITY.parkingzones PK
  17. CITY.dangerareas DA),
  18. (SELECT (SDO_GEOM.SDO_AREA(PK.SHAPES,0.05)) area_zones )
  19. FROM CITY.parkingzones PK);
Add Comment
Please, Sign In to add comment