Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ACTUAL:
- SELECT MIN(SDE.ST_MINX("shape")) xmin
- ,MIN(SDE.ST_MINY("shape")) ymin
- ,MAX(SDE.ST_MAXX("shape")) xmax
- ,MAX(SDE.ST_MAXY("shape")) ymax
- FROM (
- SELECT DISTINCT ON ("objectid") "shape"
- FROM (
- SELECT *
- FROM (
- SELECT *
- FROM "db_7aue7"."hsu_bf6bb"."californiaretailsales_california_regions"
- ) f
- WHERE EXISTS (
- SELECT 1
- FROM (
- SELECT *
- FROM "db_7aue7"."hsu_bf6bb"."californiaretailsales_california_regions"
- ) q
- WHERE SDE.ST_Intersects(q."shape", SDE.ST_Geometry('POINT (-13210416.43996015 4034102.9800277897)', 300004))
- ) s
- WHERE "objectid" IS NOT NULL
- ) t
- )
- AFTER THE FIX:
- SELECT MIN(SDE.ST_MINX("shape")) xmin
- ,MIN(SDE.ST_MINY("shape")) ymin
- ,MAX(SDE.ST_MAXX("shape")) xmax
- ,MAX(SDE.ST_MAXY("shape")) ymax
- FROM (
- SELECT DISTINCT ON ("objectid") "shape"
- FROM (
- SELECT *
- FROM (
- SELECT *
- FROM "db_7aue7"."hsu_bf6bb"."californiaretailsales_california_regions"
- ) f
- WHERE EXISTS (
- SELECT 1
- FROM (
- SELECT *
- FROM "db_7aue7"."hsu_bf6bb"."californiaretailsales_california_regions"
- ) q
- WHERE SDE.ST_Intersects(q."shape", SDE.ST_Geometry('POINT (-13210416.43996015 4034102.9800277897)', 300004))
- )
- AND "objectid" IS NOT NULL
- ) t
- ) s
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement