Advertisement
Guest User

Untitled

a guest
May 17th, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. ACTUAL:
  2. SELECT MIN(SDE.ST_MINX("shape")) xmin
  3.     ,MIN(SDE.ST_MINY("shape")) ymin
  4.     ,MAX(SDE.ST_MAXX("shape")) xmax
  5.     ,MAX(SDE.ST_MAXY("shape")) ymax
  6. FROM (
  7.     SELECT DISTINCT ON ("objectid") "shape"
  8.     FROM (
  9.         SELECT *
  10.         FROM (
  11.             SELECT *
  12.             FROM "db_7aue7"."hsu_bf6bb"."californiaretailsales_california_regions"
  13.             ) f
  14.         WHERE EXISTS (
  15.                 SELECT 1
  16.                 FROM (
  17.                     SELECT *
  18.                     FROM "db_7aue7"."hsu_bf6bb"."californiaretailsales_california_regions"
  19.                     ) q
  20.                 WHERE SDE.ST_Intersects(q."shape", SDE.ST_Geometry('POINT (-13210416.43996015 4034102.9800277897)', 300004))
  21.                 ) s
  22.         WHERE "objectid" IS NOT NULL
  23.         ) t
  24.     )
  25.  
  26. AFTER THE FIX:
  27.  
  28. SELECT MIN(SDE.ST_MINX("shape")) xmin
  29.     ,MIN(SDE.ST_MINY("shape")) ymin
  30.     ,MAX(SDE.ST_MAXX("shape")) xmax
  31.     ,MAX(SDE.ST_MAXY("shape")) ymax
  32. FROM (
  33.     SELECT DISTINCT ON ("objectid") "shape"
  34.     FROM (
  35.         SELECT *
  36.         FROM (
  37.             SELECT *
  38.             FROM "db_7aue7"."hsu_bf6bb"."californiaretailsales_california_regions"
  39.             ) f
  40.         WHERE EXISTS (
  41.                 SELECT 1
  42.                 FROM (
  43.                     SELECT *
  44.                     FROM "db_7aue7"."hsu_bf6bb"."californiaretailsales_california_regions"
  45.                     ) q
  46.                 WHERE SDE.ST_Intersects(q."shape", SDE.ST_Geometry('POINT (-13210416.43996015 4034102.9800277897)', 300004))
  47.                 )
  48.         AND "objectid" IS NOT NULL
  49.         ) t
  50.     ) s
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement