S-K'
Reputation: 3209
SQLite point check if a point is within a polygon
In a SQLite database I have rows of latitude and longitude values that represent a polygon on a world map, using a SQL query is it possible to determine whether a provided latitude/longitude value falls within the polygon?
Upvotes: 0
Views: 2043
Answers (1)
CL.
Reputation: 180270
SQLite itself has no such function.
You have to implement this in your code, or extend SQLite with a spatial library like SpatiaLite.
Upvotes: 3
Related Questions
- See if lat / long falls within a polygon using mysql
- Query to know if point is inside a polygon in Postgis 2.5
- PostGIS and coordinates, determinate if a point is inside a polygon/multipolygon (kml)
- Determine if points in table B are inside a polygon at table A using Oracle Spatial (Geometry fields are different)
- Find if a POINT is inside a POLYGON in MySQL 5.7
- check for point in a polygon
- Checking if a Point is inside a Polygon not working
- determine if a given point is inside the polygon
- How to check if a point intersects a polygon
- Finding row with coordinates inside a defined polygon in MySQL