JorgeDeJesus

Untitled

Jun 25th, 2020
1,216
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select "profile_id"::text,ST_AsBinary(("geom"),'NDR') as geom,"profile_id"::text from web_services.wosis_latest_profiles
  2. where "geom" &&
  3. ST_GeomFromText('POLYGON((-184.209 -54.8891,-184.209 111.536,186.555 111.536,186.555 -54.8891,-184.209 -54.8891))',
  4. find_srid('','web_services.wosis_latest_profiles','geom')) and
  5. ((st_intersects(geom,ST_GeomFromText(
  6. 'POLYGON ((-184.2090000000000032 -54.8890999999999991, -184.2090000000000032 111.5360000000000014, 186.5550000000000068 111.5360000000000014, 186.5550000000000068 -54.8890999999999991,
  7. -184.2090000000000032 -54.8890999999999991))')) = TRUE
  8. and (("profile_id" = 69728) or (("profile_id" = 69916) or (("profile_id" = 69525) or
  9. (("profile_id" = 69903) or (("profile_id" = 69486) or ("profile_id" = 69607))))))))
  10. limit 1001 offset 0;
Advertisement
Add Comment
Please, Sign In to add comment