Hfrhyu

Detention in 1997

One verb to replace 'be a member of' a club

Im going to France and my passport expires June 19th

Why was the shrinking from 8″ made only to 5.25″ and not smaller (4″ or less)?

How would I stat a creature to be immune to everything but the Magic Missile spell? (just for fun)

Why do bosons tend to occupy the same state?

Why didn't Miles's spider sense work before?

How to compactly explain secondary and tertiary characters without resorting to stereotypes?

Intersection Puzzle

Is there a hemisphere-neutral way of specifying a season?

How could indestructible materials be used in power generation?

Venezuelan girlfriend wants to travel the USA to be with me. What is the process?

Mathematica command that allows it to read my intentions

Can we compute the area of a quadrilateral with one right angle when we only know the lengths of any three sides?

A category-like structure without composition?

Is it logically or scientifically possible to artificially send energy to the body?

Can I run a new neutral wire to repair a broken circuit?

Can my sorcerer use a spellbook only to collect spells and scribe scrolls, not cast?

Short story with a alien planet, government officials must wear exploding medallions

What is the most common color to indicate the input-field is disabled?

How seriously should I take size and weight limits of hand luggage?

Can a virus destroy the BIOS of a modern computer?

What's the in-universe reasoning behind sorcerers needing material components?

How to Recreate this in LaTeX? (Unsure What the Notation is Called)

Remove tolerance in PostGIS requests

Is it possible to setup fiddler to capture requests from QGISHow to update attribute values of points outside an area?OpenLayers BBOX sending double requestsOpenLayers doesn't proxy WMS requests to GeoserverIssues with pgRouting workshop code in PostGIS 2.11/pgRouting 2.0Remove inner polygons postgisUpdating Secure service on Portal for ArcGIS with PortalPy and requests?No module named requestsChange ST_Intersects default toleranceadd a shapefile layer to a specific postgis table

0

I just read the problems similar to mine on this forum, but no solution helped me.

To put it simply, I use ST_Touches in an algo in PHP that allows me to test if two points touch.
Here is the query:

SELECT * 
FROM t_node1, t_node2 
WHERE st_touches (t_node1.geom, t_node2.geom)

The problem is that there is a tolerance and therefore my results are not accurate.

Is there a way to remove this tolerance?

sql php request tolerance

share|improve this question

edited 2 days ago

Vince

14.8k32849

asked 2 days ago

AllMightAllMight

1

New contributor

AllMight is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Show us a concrete example with two geometries which do not touch even PostGIS claims that they do.
  
  – user30184
  2 days ago
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Most folks have issues with objects which should touch, but don't quite due to floating-point representation issues. I've never heard of such a tolerance in PostGIS, though Esri geometry does.
  
  – Vince
  2 days ago
  

  
  
  
  

add a comment | 

0

I just read the problems similar to mine on this forum, but no solution helped me.

To put it simply, I use ST_Touches in an algo in PHP that allows me to test if two points touch.
Here is the query:

SELECT * 
FROM t_node1, t_node2 
WHERE st_touches (t_node1.geom, t_node2.geom)

The problem is that there is a tolerance and therefore my results are not accurate.

Is there a way to remove this tolerance?

sql php request tolerance

share|improve this question

edited 2 days ago

Vince

14.8k32849

asked 2 days ago

AllMightAllMight

1

New contributor

AllMight is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Show us a concrete example with two geometries which do not touch even PostGIS claims that they do.
  
  – user30184
  2 days ago
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Most folks have issues with objects which should touch, but don't quite due to floating-point representation issues. I've never heard of such a tolerance in PostGIS, though Esri geometry does.
  
  – Vince
  2 days ago
  

  
  
  
  

add a comment | 

I just read the problems similar to mine on this forum, but no solution helped me.

To put it simply, I use ST_Touches in an algo in PHP that allows me to test if two points touch.
Here is the query:

SELECT * 
FROM t_node1, t_node2 
WHERE st_touches (t_node1.geom, t_node2.geom)

The problem is that there is a tolerance and therefore my results are not accurate.

Is there a way to remove this tolerance?

sql php request tolerance

share|improve this question

edited 2 days ago

Vince

14.8k32849

asked 2 days ago

AllMightAllMight

1

New contributor

AllMight is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

SELECT * 
FROM t_node1, t_node2 
WHERE st_touches (t_node1.geom, t_node2.geom)

share|improve this question

edited 2 days ago

Vince

14.8k32849

asked 2 days ago

AllMightAllMight

1

New contributor

AllMight is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

edited 2 days ago

Vince

14.8k32849

asked 2 days ago

AllMightAllMight

1

New contributor

AllMight is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

edited 2 days ago

Vince

14.8k32849

edited 2 days ago

Vince

14.8k32849

asked 2 days ago

AllMightAllMight

1

New contributor

AllMight is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 2 days ago

AllMightAllMight

1