Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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

asked 06 Dec '17, 21:28

gaeliclaic's gravatar image

accept rate: 0%

edited 06 Dec '17, 21:28

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.

(07 Dec '17, 07:24) Justin Willey

As you are relating to PostgreSQL: Is this question dealing with SAP/Sybase SQL Anywhere? If so, what Version do you use?

(07 Dec '17, 07:42) Volker Barth
Replies hidden

Ahhhh - someone who read the question title! 10/10 Volker :)

(07 Dec '17, 08:26) Justin Willey
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • 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,587 times

last updated: 07 Dec '17, 08:26