Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- some_place.point && SetSRID('BOX3D(-158.721365889063 66.09275164148659,
- 154.608712235937 52.56807548751039)'::box3d,4326)
- ST_Contains( SetSRID( ST_MakeBox2D(
- ST_Point(143.930001298437,66.82980906973742),
- ST_Point(-145.757498701563,51.37699768868392) ), 4326 ), some_place.point)
- SELECT ST_Contains(
- ST_Shift_Longitude(
- GeomFromText('POLYGON((143 51, 143 66, -145 66, -145 51, 143 51))', 4326)),
- ST_Shift_Longitude(GeomFromText('POINT(144 52)', 4326))
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement