akirahrkw/polygon.rb

Created January 18, 2017 04:02

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/akirahrkw/ce6964b0328ebf8f3ea19a0f6b5349e8.js"></script>
Save akirahrkw/ce6964b0328ebf8f3ea19a0f6b5349e8 to your computer and use it in GitHub Desktop.

Download ZIP

to find places using ST_Contains( a point within a polygon)

Raw

Place.where("ST_Contains(polygon::geometry, ST_PointFromText('POINT(#{lon} #{lat})' , 4326 ) )")

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment