on 2017 Dec 06 9:28 PM
I have two lon/lats that i've turned into geometry. I have a fence_geom and a user_geom. I am looking to test to see if the user is inside the fence_geom. I have tried using several different postGIS methods to check for this but I am only getting false. The location with the users is definitely within the geofence but I keep getting false even when the results should return true. For tests sake, every user has the same geometry which is the one within the geofence. I've tried switching the order of the parameters and the results are the same.
SELECT ST_Covers(fences.fence_geom, users.user_geom) FROM fences, users
Request clarification before answering.
User | Count |
---|---|
68 | |
16 | |
12 | |
7 | |
7 | |
4 | |
4 | |
4 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.