Opened 5 years ago
Last modified 5 years ago
#4558 new defect
ST_Intersects returns FALSE while ST_Intersection returns a geometry.
Reported by: | olehz | Owned by: | pramsey |
---|---|---|---|
Priority: | medium | Milestone: | PostGIS GEOS |
Component: | postgis | Version: | 2.5.x -- EOL |
Keywords: | Cc: |
Description
For example:
SELECT ST_Disjoint(a, b), ST_Intersects(a, b), ST_AsText(ST_Intersection(a, b)) FROM ST_GeomFromText('LINESTRING(-57.2696825964778 7.15879416404005,-57 6.93901666666667)', 4326) a, ST_GeomFromEWKT('0105000020E6100000010000000102000000070200009085E02A51094DC008D3BEE2D3AB10407C45F1CE58044DC07BC51116A5E11040F635946CF9004DC055D3FD5124EA1040FA028D9105FF4CC0F69568A88B0D1140AD74EA9FD3FB4CC04CB165C50A16114033D27D90FCF84CC008177390F2301140413F6EE384F94CC0DC4313EA566511403E7275BE78FB4CC023F94C96FE7B1140929A09FAC2FA4CC0376819ACCEA011402A32866280F64CC0DBDB3A2973C81140EBC73A17B8F24CC02FA7E9CED5111240093C0D07E1EF4CC00F41EAE85D54124077BFBF51F9EB4CC013D3B7B0138312409566991C16EB4CC01BBDF312B5AA124075F2C62CEDED4CC0BC50A00017CE1240C64D62432BEF4CC0A7F1701C26E61240A5D98F5302F24CC0065A828E821A134000D52298BCF54CC01DC1E29D2B2013407D4488CC9FF64CC01D2C1E45FB331340C85368278FF54CC0BCCD75A4C5581340093C0D07E1EF4CC0416ED241E1881340F0E269CA8DEA4CC0D450AC3566BA13407DDAEE04CFE34CC04FAAF74453B3134015726B6D8CDF4CC0B8988C1B79C113403CB93C6625E14CC0F2067A3DF0DA134070B52E5CACD64CC0E605FAEB470F14401887943CFED04CC0044C507A22011440789D56348ECC4CC0AD0BB44BD1F51340A3325EBBF0C74CC0F908ED0CCB06144090F26E5FF8C24CC074BDD84F861314401A1DFB742DBE4CC0AD0BB44BD1F5134049CBB6DCEAB94CC0705792E479FB13408D3A9F095EB64CC0626F7E2067F41340EE506101EEB14CC0FAB0C3A38C021440F9B74B7012AC4CC01DF449C4DD0D144073A8EE0DB3A84CC03A0005446D1D1440A456AA7570A44CC074BDD84F86131440E12BA158CBA44CC05920A56A282A1440AB29A97EE0A84CC07BDA459D4D381440499424F00DA94CC0DAACF065EF4E144016E062A4ECA64CC0DCE48893776F144040F42CC291A64CC090BFD54D958E14405C9B068DAEA54CC080CC61D85AB314403CEE26DE2DA04CC080CC61D85AB314408CCAFF5D299D4CC01D4117913D9414404109569103984CC0F1B9ED59A0A614400B889B20D6974CC02DEAB037ABBE144057163E12089B4CC01B192331C0EE1440DE259B74679E4CC004834051460F154001A07348F4A14CC04A44B84C58161540468E1E0CAAA24CC018EC4C52CA061540F7FF7B1A789F4CC0F27CCA2118E9144001A07348F4A14CC082E02B0970E31440B1C39AC8F8A44CC01B192331C0EE14404F2E163A26A54CC02FBF0C508C021540E12BA158CBA44CC09120EE11622E1540B1C39AC8F8A44CC030B2BBC6EF3D1540A85CB059D4AA4CC0528C86E5473815409508BF8968AA4CC03EF821173B60154015F4641860A24CC0423FAD9F369C154015F4641860A24CC0C7A650462FE4154090ED4D2FD89A4CC02B2E2E18281C16401DBDFC6152954CC075AF6C911F54164011D9F3BDCF924CC0497522780FAC1640C7A9017D54974CC099475F26F61B174000032EA2CD904CC024839CF5E263174080EED330C5884CC07EC6D5F4CFA317409F9B53CDAA7F4CC0C2DD4DF23F0718400000000000804CC044B151252C4618400000000000804CC0A089B0E1E99519400000000000804CC0D7EDC6958DC11B40C90A6B5021804CC053BC06CCA5BD1F400000000000804CC01156555555D52140A2B2C3D4E5FE4BC0B6600BB6602B22407EB1E4174B5E4BC0F9C5925F2C7922400000000000004BC0EA5A7B9FAAAA22400000000000004BC0FD62C92F963C21400000000000004BC00000000000001B400000000000004BC00000000000001940511E2028A5FF4AC0ADBF7AF6C80517404E2A309ABD004BC0D3F74B9A2EC316409F85CBB0FB014BC04ACC660ACA9816404E2A309ABD004BC0DBCCC6265E5616409CDFED52D4004BC054292209764016407571019356024BC01CDE2CCBE2181640A7FEA71793074BC0E36FC9CE03F21540ADD1A620030C4BC00CBF6CCC5DC31540A03D9B06960E4BC0F35BC93593AF15407302B6210C124BC0778FA661067715401C97658B83154BC0F9E6123D88631540F610C2F5B7194BC051FA247F8A3A1540E9AF3DB84B1D4BC0EB270D270B2C15404B2A37F35E204BC0A6CEF3A00B1F154062720161A2234BC0ABB6614C8C091540E895494765264BC059CF21E00CEF14409302963C292A4BC0A035643A8DBF14405B86BE01CC2C4BC07E3F35C80C9514408C3384DA8D2E4BC072CAC4950C8C1440FF60981BBF2F4BC08C2F13800C881440C2922A18B0304BC03AF3D03F0C7E1440304E3A07A0304BC05E34F7B60B6E14404E287750B4344BC01B2B86770A4F144042E7609CD7374BC096A35B9E082C1440B4F4065479394BC02F8FEF2507151440C60AA9829A3A4BC08F89C0BB8501144004D91686A9394BC07C99870D03E11340FDA1818D93394BC01711CD0D02C01340ACC0AEE7B73D4BC0E88193F3FEA213403EE5306F383E4BC0024E8C1FFD921340C425AA52363C4BC005A57E9EF86E13405DFC0C3F173D4BC0083EB80CF23F134038732C1DF73C4BC0684F051CEC19134063AEEDA3773D4BC04C54056DE7FD1240F0606BD9B63C4BC01DD63F82E5F212404A662336343A4BC034999A2DE3E51240A66BDB92B1374BC073F3C654E1DB1240A1B9FA2D51374BC00ACF089FDBBD124082A21E5E72384BC0217290C6D5A012400F9578A6D0364BC0D84A71E7CD7B1240710C35558F354BC0D712838CC5561240BFD0D6FD2F364BC0C7A1966FBD34124045B442D1D3394BC05B1B1C73B61812406A3D23F3F3394BC0E481B724AEF8114063CB1EA1B2384BC06E571F569BB41140D9073CD4C2374BC05B697C1B7289114089ACA0BD84364BC0EFD0165F406F1140DC2E579BA7344BC093B1A41B035A1140719FB83C80334BC0749DAA2F30461140F72F53089D324BC0227614DFD22E11402CB10D79CA324BC0F9D46FABB60A1140D08E5F6D2B324BC065E36B2D0EF41040E5F5699008344BC0B1A9BCAC45DB1040B58D630036344BC0C66DFDD59CC41040157D0A31E1324BC05E20E3F0BDB51040A1CEB10DFB2A4BC033748A826A9910407D2DBE72892A4BC0127130638B8A10404DA61DD2B02B4BC0BDE3BF934C75104042DF0ADD4F2C4BC01AEFCED2F769104042DF0ADD4F2C4BC0AADAF16F035410409F01B9E8EE2C4BC0ED42C90324451040A0A79646162E4BC07A35E3E8D93410404BB415B5552E4BC070347C5B19211040E919AEF0B22B4BC08432765014151040F0A8E33F2F284BC0244F9F0215FC0F40092E4D343D264BC09BA3E9C0FCC30F407157EA475C254BC03CA601FDDA770F4041AA246F9A234BC0A9BFF89ED0600F409DAFDCCB17214BC03FB5070CC74B0F409DAFDCCB17214BC0D71D9C96B6270F40B63446C0251F4BC0A37D6031A8080F409DCC0DC9521C4BC050A8E70B94DD0E40232DF535E0194BC068B63D108AC80E405A4982D48E184BC058FBD10681B50E40A90D247D2F194BC0930F37B36E8F0E405A4982D48E184BC039D9C78A63780E40910536220B154BC0684968485A650E40BD1D4C93A7114BC080933354565D0E40C93EF4BDF40E4BC09A76751B42340E4074084EC3120D4BC0F3C2A48929030E4000FBA70B710B4BC0C479C42710D10D40D00D0620900A4BC09267CB9FFCAA0D405DA015CC3F0A4BC02E014D40E57D0D405CE0F1DE5E094BC045E4C915D8640D4025814BA13C074BC0FEAB0FF3C23C0D407F20DE54A8064BC09196F6006B0F0D401E66080776044BC0D6CB6CC9680B0D40CEC1D4E764034BC044192B5370190D4098829C33D2004BC0187299DD701A0D4068D5D65A10FF4AC0A3DEB9505BF20C4087ECB22AEFFD4AC015B960BC42C50C408D5EB77C30FF4AC01BE84AA331A60C4099622EAA42014BC01FF2C7C2197B0C401182FF62F3014BC019599972004E0C4098829C33D2004BC051091533E1160C4049BEFA8A31004BC07EBAF4B8CAEF0B40B7599CF091004BC0847526E5B5CB0B40B8790A7A21004BC01C23EB8F98990B40813D0F52E3014BC0E1B0EFF07D6C0B40868FA51A95034BC0500C6E005D350B4098656B3697054BC0B3BA50204C190B40A91BC3C809084BC0E443AE1E33F00A401E694593CA084BC0CE611E7A0FB60A40F8BFF6E71A094BC01738A177E9780A40D4F9763F300E4BC03B4B932CCD4B0A408B277B1EFF104BC002D4F112A3130A40BA6866E7EC134BC06015DA0568C10940D41B2CC618184BC0C7AD6A6A5D8E09402F3EDAD1B7184BC00A6CF4A98F4E0940143DDE64C21A4BC0704B3759C51F0940B9ED1E08B71A4BC0DF52BFE0F7FB084031E4B72FDF194BC014EC9367ADFC084032B4AB192F194BC080216245460C0940D5EB1FB068174BC0E730681749010940D7BB139AB8164BC014EC9367ADFC0840AE773D6663164BC031A0E5396FED0840BB113F0A58164BC0BF1470CE09D608405FEF90FEB8154BC045CA15C9ADB908405FEF90FEB8154BC0D930F20338A10840B96E5C7174164BC0272584226E8E084066ECA59351184BC0DC31C481F5800840BCCF6F604A184BC0776315630376084042E0C3F5F0164BC05D527558F6620840A9E9F27F80164BC06529904C6E5708405B159A1218164BC05C71E789D12D08401103D9CED7154BC073C4C75F401508403B4E511A20164BC01C4EC499B0FE07406669A41711174BC0E3ABDB2F22EA07401D472C0F09174BC08C8450E611D30740A9E9F27F80164BC08DB35B7A85C10740C810861427154BC0F558B53700BA0740E607F45A76144BC0D757315072A607400B91D47C96144BC0F7CF996C6A9B0740EC79F8ACB7154BC0CA2CA863C86B074090A4659E91174BC04813800F2E470740B51D8FFBE9174BC015A16CD2A2370740477236D1C1174BC045FAD31E92200740727DD209EB184BC03C6751F5F8FD06404D1460715A184BC0EC6C018AE9E80640CE828A6668164BC0A8B4339E5FDB06408570C92228164BC0AFF3571EDAD306408560125E60164BC088E5C76C4FC50640296B11C6AA184BC0E72AD8333CAB06400A74A37F5B194BC0349153162E98064004D279DFC2184BC0F59BCB930C6B0640A37A2BBA93194BC0FCE458B16C400640346F88F3BC1A4BC08C64CAD256230640652C0591461C4BC08A1A8262C70E0640C144B13EE01D4BC06D219D9DB6F80540A8BF474AD21F4BC02C84E4349BD405402F6844C44A224BC0FBC483B7819E0540621C06106C244BC00051406A6B5A05409403CF3681284BC07ABDCAEC3C0F0540893CBC4120294BC03C65EF6449B70440073365C3242C4BC0E10E6E63497A04406A6EC7AF1E2D4BC0F7FC16A6D72A044080D5D1D2FB2E4BC02F34B25318F203407F5494693E334BC063DB025E6AAF0340A4CE6C3DCB364BC03CBF0EC33864034015D7E7028A3D4BC0673DE335276E03401ED101D3DE3E4BC0E6FB7D361A4C0340FAD5EB95943F4BC07AFC84CE940603402E8AADE1B5414BC0BAF165ACA3BF024001A9EA9E04444BC0F10087B231AD024044707A9BD5474BC045E32895DADE024084912C3A7F4A4BC063260E61AAD002402D9C9FD9284D4BC06004D0CF84A702403292068D20514BC03F0B377CE48D02409AFA892463554BC0A45A50EFBA900240B00772A567584BC00C902A44EB9E02402C77D7D94A594BC09EE77C82C8B20240BE7462F8EF584BC0EF6916F19AE1024090939FB53E5B4BC07AFB684BC00A03406BF2AB1ACD5A4BC0BFCD7BCF8B2803408B667E0AF6574BC0E3046E7EE5330340CDAE4B7084574BC08D69D23E57460340B00772A567584BC098E09DC2755E03408B667E0AF6574BC027F0DD43AC7D0340BCCE849AC8574BC0EC4C86400C9A03405018CB74BC594BC021F76D6ABFB003409E009008C75B4BC021F76D6ABFB00340AD135EB9765D4BC085834A895AC0034024B6CAC84D604BC08AD6F68772C70340157CE150B9614BC012ABB75207C6034038F6B92446654BC07FE1CB75478D03407BBD492117694BC007AABA0C29750340D2EBE340C56E4BC0D8983C6D2F860340611C763A5E704BC0DB0D44D47DAC0340FB11A056DD794BC04CB8AACF323D04408CE80FAE9D7C4BC047A8B9661B730440CF30DD132C7C4BC07F70158B0F8E04404CC75D0FF4794BC0974E96D66EAA04404E94563400784BC0F3F646EDC1E10440C903BC68E3784BC0E07647A25CF10440087F90A9657A4BC0E07647A25CF10440C369CA1ECB7C4BC088FF305AA4C90440CFAF9FAA6E804BC04522E33BB6BF04400E2B74EBF0814BC0C89E719509BA0440079182A1D8854BC0F39A1018CE8904404B58129EA9894BC082218AA8685C0440B3C09535EC8D4BC04B450C48F1380440FFA85AC9F68F4BC00623D763F74904401089219FB28F4BC03F03C0D8D96E04400C164B1C7F904BC0F71692E7E59004403503FA723F934BC0D49BD0B5FD9704407357B3ECDC974BC0C0A45EB56E6D044087BEBD0FBA994BC01C7878376E3004403988C2EDE59D4BC0786AEFD5DE050440139E5E35BFA04BC024F19F6959F90340FA3863CA40A24BC0F45897076C10044079CA38D532A44BC00FEC6DB1863104400BF2F7E807A94BC0A28F27D57D2604408A2383574BAC4BC086ABE0F756F6034029ACC6A88CAD4BC09571DC6048E4034072DEF5755CAD4BC00D2E36E919AB0340C1A2971EFDAD4BC018645620028E034084944D08CFAF4BC0ADD6DBDEEB720340BAD385BC61B24BC0DE42919BE86E0340DF5FA36AD6B64BC07BD3CEA6FF8A034002CC528FBBBB4BC04F02102DFD8703401AD440EADFBF4BC0D57CC7EBF9830340D1A44EA964C44BC0DB2211F7F47D0340E25AA63BD7C64BC0C1616286ED7403409299411F8BCA4BC0D57CC7EBF983034012CBCC8DCECD4BC0E01C26D5F078034080C9B59CB8D04BC0647EF8780969034065C8B92FC3D24BC0FB375A285652034010790A2D94D64BC05DE3A288144E0340E53D25480ADA4BC0BCB2F34CB4310340B902406380DD4BC0EED032871F330340805A6A2B6EE04BC0324CA4C797560340D2B50542ACE14BC0C9AB3280818C034007CAEF130AE94BC03B91631523AD03403A57969846EE4BC095221BCAFFC003400E1CB1B3BCF14BC062AA4D60BFF90340B278C53E60F54BC053A3ED44A82F0440B84BC447D0F94BC0A53D144DC6470440B824A980EBFC4BC0E3D29D3F433F0440C01EC35040FE4BC089F379A8E32204409B7DCFB5CEFD4BC0D412142AA1E10340ECD86ACC0CFF4BC0761BE534D6C30340DC9E815478004CC0DC72AD502E92034047553B7A84FE4BC03353F0041B5F03402D2138329BFE4BC0F0AE561A26440340014075EFE9004CC0D65E1534842303401CC033F321034CC07FE6A90CB2F40240450705ECBA044CC02D09094ACECF024066DBFF6120074CC0D8685EF04AC702409C359F0B690A4CC0CC806B7EFEDD02409868A6E65C0C4CC002DD689D8CCB02409A0E8444840D4CC09FF33074CB92024078F4D3F6330F4CC08EF8A3E663650240F19640060B124CC03EA7B4F13D3C0240947492FA6B114CC07F339315290902406C87E3A3AB0E4CC0EA8A5C9DF8FA01403D46F8DABD0B4CC0D9FEC7DDBD07024033CD1B7426064CC08485F4919EEF0140450705ECBA044CC062E6433125CC014001BF37862C054CC048A2C84F8C90014032273E16FF044CC07AD86ED8D0680140529B100628024CC0BA12CCC087530140DAF8A3F650FF4BC0F47E5A9B91380140FA6C76E679FC4BC04328BD4485EA0040E6ADC4F33EF34BC08CE679249C5C0040E4E0CBCE32F54BC0D55BE92A230D0040E4E0CBCE32F54BC079366F53537BFF3F725713A0B6F24BC0306F9913ED9DFE3F55B039D599F34BC097BA77AC6A3DFE3F17958D1A54F74BC0C72B39F4FF0FFE3F4B494F6675F94BC089733CE1749EFD3F60080159B0024CC09BD8BDFEA654FD3F59EDD1A5DA0A4CC089733CE1749EFD3FB42172A9EC164CC097BA77AC6A3DFE3F952C6250061E4CC02200A7A9724EFE3FFD94E5E748224CC0F01C835FBD37FE3FD705E4444A2D4CC0D2EC7DC0C909FF3FC091ACD66C304CC0B869F58ADBDCFE3FB350962290334CC05452BEBEBAB8FE3FA70F806EB3364CC03D18699BEDF0FE3FEDF264B5B63B4CC037AEE7EECA20FF3FC7D0E47B7D3C4CC034C5AF19123FFF3F5FC7B5F1ED3C4CC0E4928F2F2453FF3F89C29A654F3E4CC0BDA3018A588DFF3F715D9FFAD03F4CC00E5CD4906AA1FF3F5E8A166B23424CC020A7452579B1FF3FD2B72AAC54434CC08C2510A6A0DDFF3F70406EFD95444CC02D41475BF3150040380473D557464CC034298335FD2000406F233D005B494CC0AFE91B230F3500403A7861DDA24D4CC0267FB9581A37004094A00573C9504CC00237489E8538004087B2D7B683544CC0AFA8E1A964360040437000DB7C574CC0AFA8E1A96436004068E4E22482584CC08BC00B413B3900409BF2C6127C594CC0F948BEADE7540040F7E763CDAE5A4CC0C9581443FF7100403CA9FD3FF85B4CC07DDA8D462F960040A6389C9E1F5D4CC0C01C58EF04AF0040CD7F6D97B85E4CC0995CA02B5ED0004062C9B371AC604CC0EC2ADE104CF00040F0F9456B45624CC0B404ECE9180E0140D4526CA028634CC027F7C5D5F62101406EBB1BC239664CC0E9A7DFF669680140CCB0B87C6C674CC0C4F13EBEC2890140CD83A72B00684CC07B9653864DA301401B66763583674CC047F54CBEB5D001407B280C15C2664CC08895D7D9BCE1014020D94CB8B6664CC028245201FDFB014028D366880B684CC0772E869CB90D02409208E3445A6A4CC0E202B5F90A1E0240F9CA887E756D4CC003EE67C8C5450240DE9C7BC013704CC03C694D1117560240B488B1A26E704CC043934870F4690240F6FD8F59696F4CC0C1D568B162A8024007DE562F256F4CC03E9D3D3270CA02403AEC3A1D1F704CC0E5DFF10056D902400271763679724CC0AB1DB52433ED02404E2C2A7917754CC0CEC0D7429C040340BED47CB899764CC06E6E3948051C0340ACF4B5E2DD764CC0420C897B4D310340F382487A33764CC01D072CD75C3D03406F1FBFFF82764CC0DFFA051E84500340C8C8A0FE66754CC00EE61F45E46C0340443806334A764CC0D4A85118C18003406B7FD72BE3774CC0220DDCE6858D034013560952F5784CC0523F7F0C64A80340FA4E175B78784CC002998B5526CB03401FF00AF6E9784CC049459F64D9E10340EAC001CB927D4CC0AF85BCB8FD0A04407C917B98CB7D4CC06C8EB768C2170440CB463951E27D4CC0DC4618DBC53E04402DAFAC8E487E4CC06280AF76905C0440C7522565F1824CC08B97DBBF879E04409FE438A573844CC0FE8061DA66D90440F239DE312A834CC024DCFE727BF6044023A2E4C1FC824CC01ED20B4A780C0540E22C060B02844CC042DBE854661605404ABCA46929854CC0360A802BFB140540B51E3277E4864CC0BA6D879B3C1905408BDD5608D3874CC0F3444C2ED72805409EBD1DDE8E874CC020AAD88AD0540540670F521CF5874CC088F8E61FC46F0540A68A265D77894CC0B9E73580A594054060A27123498B4CC0B4C425E898AF0540B02A1E8BF38B4CC0B301BD9A74C3054054DB5E2EE88B4CC055854B56B2DD05407607FB9EFF8B4CC0959E894560F205403A29D6D6288D4CC0F8CE0D7C720A064021C4DA6BAA8E4CC0F7E55863F40C0640E4D5FEDE0B904CC0E0BB794979130640A155B0769C904CC0F704F95B821F06400EF151DCFC904CC0DDD89EEE8C2D0640A155B0769C904CC06B342B059C410640760A382B54904CC0685292682E5A0640EA4703314D914CC021F05CA1336106408F72702227934CC06872C5A72D590640071289B599954CC0296D90AF366506400EC4691AFA954CC06C41616FC77B064057B6BCD4AA964CC0266913EECB8106401AE84ED19B974CC0051CEC4D4C820640687CCB2BE5984CC05E9A6B6DCD8306402BAE5D28D6994CC060A05717DA940640E27B2E5B069A4CC0C1BDD05E63A1064093A7D5ED9D994CC0F1EADC88F2B506405157ACD385994CC0A852E06482CB0640BAE71D07EB994CC019BB6B25D0E10640099C08EBC39A4CC07B97DF88DFF606400F3E328B5C9B4CC0FEE638ACEC0807402E25E90CE49A4CC0EA19D8097818074028A32DF6DA994CC053A1F8ACFF2207405FFF96A7A8974CC005ABE5D18D360740F173AC0610974CC060875C03143F074077346DC4CF964CC08ADD2BE01E4E0740EA91A65358974CC09F920A642A5E074015ADF95049984CC0E27CF64E32690740C099FE6B4B9A4CC0D15B77902C6107402E25E90CE49A4CC034A32608336A0740088C5126FC9A4CC04D0D69363A7407404CFCE8C9A39A4CC018A8E4574E900740AE8C7332969B4CC04133F8AACFAE07405FD7B5797F9B4CC0418AC0C63EE80740881891E8909A4CC0F15EE63143F9074063779D4D1F9A4CC0D09ACA373E0F0840EB800426F79A4CC0DBAD0BE71C340840EB800426F79A4CC02E7AA94BA34D08407E246DA2C39B4CC0814D0D52E378084054E39133B29C4CC0EB732AFF48900840356FBF43899F4CC079F7C4163AAB084041AF9E45A5A04CC02AB1741C96C70840C81228C055A04CC085FADF15F2E308405E8389612E9F4CC0D758D1E777FD0840E4E612DCDE9E4CC06CE02E2DF41B094044557CA3CCA14CC07D30EBC6E60F0940658399BB0AA34CC0EA58514D9C1009406729771932A44CC06CE02E2DF41B0940ED5FEF4276A44CC0B5708008222A09409DD742DBCBA34CC07EE4DB37874109409DD742DBCBA34CC08D255769AB540940315395D057A54CC08A80B035F66609402BE1907E16A44CC0A3D937CB52F509407A65561498A54CC0075CB5AE7B350A40997C32E476A44CC014A3B988A1710A402BE1907E16A44CC009A9C47CBFA10A40CA29F8BC38A64CC08B3FD184D4C30A40EDB2D8DE58A64CC05007B082FA010B40AB121CED59A74CC0D7B297E807180B40E823A38FDCA94CC0870FAEE9EBE90A4066552EFE1FAD4CC04B915ECFE0D70A40BBAE7F0EE6B24CC0593922A7F5F90A40366E062BE8B44CC0443C10CE010E0B408AA4AC25CAB64CC0664EFEFFD6C70A400FC8F40B8DB94CC0F3011260C9B10A403434A43072BE4CC0F4CA58BCBB9B0A4084B869C6F3BF4CC01FA8BBE8DBCF0A4045AD5C3C1AC64CC0F26A623DD8C90A40EE598544FDC84CC0F26A623DD8C90A40309D3426A2CD4CC0870FAEE9EBE90A405449C05DA6D14CC0B7369925DDD10A40612DC90129D44CC0870FAEE9EBE90A40BC552C748AD54CC0D18EEBD518340B404E97DFF845D14CC0F638B62D67B80B401269275988D34CC0D3D1EA2492020C40A93F8A4569D44CC0710CDDD3AF360C403063D22B2CD74CC08619B502C2560C4071E65D20F0DA4CC0E357ECF5D3760C40C71C041BD2DC4CC06AB645C305D10C40765089A87DE04CC0BE96476D14ED0C40538E802A8BE94CC041E30539452E0D4095AF32C934EC4CC075CA5A054B720D4095AF32C934EC4CC03899A1CB7BC40D40E70ACEDF72ED4CC0118FE3112D300E40A8EF21252DF14CC0F4309602DC8A0E401EC5950FF8F54CC0278D9CD3DF010F40BE7BCC3C74F84CC091F798CB8B4B0F40FA028D9105FF4CC09FEB1D9661920F4088B2E121E1044DC0022999C50BED0F40DB0D7D381F064DC0B49429B56F2210404F642E8CA7064DC058EA14C498521040CBD393C08A074DC08484AED4D76710409085E02A51094DC008D3BEE2D3AB1040') b
Change History (4)
comment:1 by , 5 years ago
comment:2 by , 5 years ago
This is a classic case caused by numeric precision issues. The JTS FAQ has an [explanation](https://locationtech.github.io/jts/jts-faq.html#D8) of why this happens. JTS produces the same result.
This case is particularly interesting/egregious, because it can be reduced to the following:
A: LINESTRING (-57 6.939016666666666, -57.001016666666665 7.935202777777778) B: LINESTRING (-57.2696825964778 7.15879416404005, -57 6.93901666666667)
By inspection these two lines DO intersect. So the line segment intersection computation is computing an incorrect answer. Much work has been done to try and make this computation robust, but clearly there is more work to do.
comment:3 by , 5 years ago
Milestone: | PostGIS 2.5.4 → PostGIS 2.5.5 |
---|
comment:4 by , 5 years ago
Milestone: | PostGIS 2.5.5 → PostGIS GEOS |
---|
I can confirm this is happening in the current development version:
It's most likely an issue to be minimized and reported to GEOS.