Need a unique gift idea?
A Pastebin account makes a great Christmas gift
SHARE
TWEET

Untitled

a guest Apr 17th, 2018 55 Never
Upgrade to PRO!
ENDING IN00days00hours00mins00secs
 
  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);
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top