Skip to content

Instantly share code, notes, and snippets.

@MarkyC

MarkyC/closed-poly.sql

Last active January 30, 2019 20:35
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save MarkyC/d8a16498b6c98e69c867d2d473823042 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save MarkyC/d8a16498b6c98e69c867d2d473823042 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
closed-poly.sql
SELECT ST_CONTAINS(foo.area, st_makepoint(0.5, 0.5))
FROM (
SELECT st_makepolygon(ST_GeomFromText('LINESTRING(0 0,0 1,1 1,1 0,0 0)')) as area) As foo;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment