|
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 |
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 06 Dec '17, 21:28
question was seen: 2,417 times
last updated: 07 Dec '17, 08:26
Can you reproduce the problem in a simple script that you could post here? You're much more likely to get people looking at it then.
As you are relating to PostgreSQL: Is this question dealing with SAP/Sybase SQL Anywhere? If so, what Version do you use?
Ahhhh - someone who read the question title! 10/10 Volker :)