Remove tolerance in PostGIS requestsIs 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

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?










share|improve this question









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















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?










share|improve this question









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













0












0








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?










share|improve this question









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.












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









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









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




share|improve this question








edited 2 days ago









Vince

14.8k32849




14.8k32849






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




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.





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.






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

















  • 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
















Show us a concrete example with two geometries which do not touch even PostGIS claims that they do.

– user30184
2 days ago





Show us a concrete example with two geometries which do not touch even PostGIS claims that they do.

– user30184
2 days ago




1




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





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










0






active

oldest

votes












Your Answer








StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "79"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);






AllMight is a new contributor. Be nice, and check out our Code of Conduct.









draft saved

draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f317326%2fremove-tolerance-in-postgis-requests%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown

























0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes








AllMight is a new contributor. Be nice, and check out our Code of Conduct.









draft saved

draft discarded


















AllMight is a new contributor. Be nice, and check out our Code of Conduct.












AllMight is a new contributor. Be nice, and check out our Code of Conduct.











AllMight is a new contributor. Be nice, and check out our Code of Conduct.














Thanks for contributing an answer to Geographic Information Systems Stack Exchange!


  • Please be sure to answer the question. Provide details and share your research!

But avoid


  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f317326%2fremove-tolerance-in-postgis-requests%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

រឿង រ៉ូមេអូ និង ហ្ស៊ុយលីយេ សង្ខេបរឿង តួអង្គ បញ្ជីណែនាំ

Crop image to path created in TikZ? Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)Crop an inserted image?TikZ pictures does not appear in posterImage behind and beyond crop marks?Tikz picture as large as possible on A4 PageTransparency vs image compression dilemmaHow to crop background from image automatically?Image does not cropTikzexternal capturing crop marks when externalizing pgfplots?How to include image path that contains a dollar signCrop image with left size given

Romeo and Juliet ContentsCharactersSynopsisSourcesDate and textThemes and motifsCriticism and interpretationLegacyScene by sceneSee alsoNotes and referencesSourcesExternal linksNavigation menu"Consumer Price Index (estimate) 1800–"10.2307/28710160037-3222287101610.1093/res/II.5.31910.2307/45967845967810.2307/2869925286992510.1525/jams.1982.35.3.03a00050"Dada Masilo: South African dancer who breaks the rules"10.1093/res/os-XV.57.1610.2307/28680942868094"Sweet Sorrow: Mann-Korman's Romeo and Juliet Closes Sept. 5 at MN's Ordway"the original10.2307/45957745957710.1017/CCOL0521570476.009"Ram Leela box office collections hit massive Rs 100 crore, pulverises prediction"Archived"Broadway Revival of Romeo and Juliet, Starring Orlando Bloom and Condola Rashad, Will Close Dec. 8"Archived10.1075/jhp.7.1.04hon"Wherefore art thou, Romeo? To make us laugh at Navy Pier"the original10.1093/gmo/9781561592630.article.O006772"Ram-leela Review Roundup: Critics Hail Film as Best Adaptation of Romeo and Juliet"Archived10.2307/31946310047-77293194631"Romeo and Juliet get Twitter treatment""Juliet's Nurse by Lois Leveen""Romeo and Juliet: Orlando Bloom's Broadway Debut Released in Theaters for Valentine's Day"Archived"Romeo and Juliet Has No Balcony"10.1093/gmo/9781561592630.article.O00778110.2307/2867423286742310.1076/enst.82.2.115.959510.1080/00138380601042675"A plague o' both your houses: error in GCSE exam paper forces apology""Juliet of the Five O'Clock Shadow, and Other Wonders"10.2307/33912430027-4321339124310.2307/28487440038-7134284874410.2307/29123140149-661129123144728341M"Weekender Guide: Shakespeare on The Drive""balcony"UK public library membership"romeo"UK public library membership10.1017/CCOL9780521844291"Post-Zionist Critique on Israel and the Palestinians Part III: Popular Culture"10.2307/25379071533-86140377-919X2537907"Capulets and Montagues: UK exam board admit mixing names up in Romeo and Juliet paper"Istoria Novellamente Ritrovata di Due Nobili Amanti2027/mdp.390150822329610820-750X"GCSE exam error: Board accidentally rewrites Shakespeare"10.2307/29176390149-66112917639"Exam board apologises after error in English GCSE paper which confused characters in Shakespeare's Romeo and Juliet""From Mariotto and Ganozza to Romeo and Guilietta: Metamorphoses of a Renaissance Tale"10.2307/37323537323510.2307/2867455286745510.2307/28678912867891"10 Questions for Taylor Swift"10.2307/28680922868092"Haymarket Theatre""The Zeffirelli Way: Revealing Talk by Florentine Director""Michael Smuin: 1938-2007 / Prolific dance director had showy career"The Life and Art of Edwin BoothRomeo and JulietRomeo and JulietRomeo and JulietRomeo and JulietEasy Read Romeo and JulietRomeo and Julieteeecb12003684p(data)4099369-3n8211610759dbe00d-a9e2-41a3-b2c1-977dd692899302814385X313670221313670221