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