Advertisement
Guest User

Untitled

a guest
Dec 21st, 2014
164
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. some_place.point && SetSRID('BOX3D(-158.721365889063 66.09275164148659,
  2. 154.608712235937 52.56807548751039)'::box3d,4326)
  3.  
  4. ST_Contains( SetSRID( ST_MakeBox2D(
  5. ST_Point(143.930001298437,66.82980906973742),
  6. ST_Point(-145.757498701563,51.37699768868392) ), 4326 ), some_place.point)
  7.  
  8. SELECT ST_Contains(
  9. ST_Shift_Longitude(
  10. GeomFromText('POLYGON((143 51, 143 66, -145 66, -145 51, 143 51))', 4326)),
  11. ST_Shift_Longitude(GeomFromText('POINT(144 52)', 4326))
  12. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement