Thanks a lot!! looks like it was my mind more than something else that was broken!
Jean 2013/9/10 Brent Wood <[email protected]> > > As I understand it, ST_Overlaps() will return true for features of the > same type which partially overlap. Where one contains another entirely (ie: > ST_Contains() = true) ST_Overlaps() will return false. > > Should you be using ST_Intersects() instead of ST_Overlaps()? > > See the descriptions of the different spatial relationships here: > http://workshops.opengeo.org/postgis-intro/spatial_relationships.html > > Brent Wood > > ------------------------------ > *From:* Jean Marchal <[email protected]> > *To:* PostGIS Users Discussion <[email protected]> > *Sent:* Wednesday, September 11, 2013 10:56 AM > *Subject:* [postgis-users] ST_Overlaps broken ? > > Dear PostGIS users, > > SELECT ST_Overlaps(ST_GeomFromText('POLYGON (( > -308992.78000114113 515108.0599712543, > -308991.140001066 515102.94997100905, > -308984.80000076443 515093.52997056395, > -308976.3200003579 515071.97996953875, > -308965.42999984324 515056.24996879324, > -308955.59999937564 515039.59996800125, > -308945.3999988958 515013.9399667829, > -308940.1299986392 515003.59996629134, > -308938.5599985644 514997.499966003, > -308924.9999979213 514962.6199643463, > -308921.439997755 514956.3899640478, > -308910.2799972221 514944.63996349275, > -308901.2699967995 514945.0099635087, > -308891.5399963334 514941.33996333554, > -308873.2199954614 514932.08996289596, > -308858.2199947536 514918.0699622296, > -308844.9299941212 514908.16996175796, > -308839.5499938652 514913.7899620272, > -308834.6499936357 514912.4499619603, > -308829.0399933681 514907.06996170804, > -308827.3899932876 514901.95996146277, > -308828.86999335885 514895.079961136, > -308828.7699933499 514882.09996052086, > -308820.27999295294 514860.54995949566, > -308817.84999283403 514852.3899591081, > -308806.34999229014 514816.65995741263, > -308803.40999215096 514801.48995669186, > -308797.2499918565 514775.1099554375, > -308797.5999918729 514770.139955204, > -308795.6499917805 514755.0299544856, > -308796.6799918264 514740.12995377555, > -308796.6499918252 514726.15995311365, > -308791.9299916029 514707.8599522449, > -308790.5599915385 514698.7899518125, > -308791.0399915576 514691.82995148376, > -308789.53999149054 514684.7399511449, > -308790.7099915445 514667.84995034337, > -308788.3499914333 514658.7100499086, > -308791.01999156177 514648.9100494459, > -308791.43999157846 514642.9500491619, > -308795.169991754 514632.23004865274, > -308807.05999232084 514619.0800480284, > -308814.4999926761 514612.6100477204, > -308818.9499928877 514605.930047404, > -308827.3799932897 514599.53004710004, > -308836.2899937108 514586.1700464636, > -308845.5799941495 514581.8200462572, > -308857.39999471605 514569.6700456813, > -308877.12999565154 514573.0300458409, > -308896.719996579 514578.3800460957, > -308913.9799974039 514588.5600465797, > -308918.66999762505 514592.8800467849, > -308930.2199981734 514584.6900463961, > -308937.2399985045 514584.1800463684, > -308943.12999878824 514585.5900464356, > -308947.759999007 514590.9000466876, > -308950.3199991286 514597.060046982, > -308986.2200008333 514597.5600470044, > -308995.6100012809 514606.19004741684, > -309028.27000282705 514653.37004965544, > -309042.7600035146 514660.3600499891, > -309043.7500035614 514660.4300499931, > -309048.1700037718 514668.7199503854, > -309049.60000383854 514705.7499521449, > -309059.2800043002 514724.3899530284, > -309071.1000048667 514741.17995382845, > -309086.95000561327 514757.2499545887, > -309096.71000608057 514774.8899554275, > -309113.04000685364 514812.94995723665, > -309121.7300072685 514831.51995811984, > -309121.28000724316 514852.44995911047, > -309122.88000731915 514872.5299600661, > -309128.4600075856 514892.8799610324, > -309127.0200075209 514913.73996202275, > -309121.6700072661 514933.3299629539, > -309109.4300066829 514951.4499638155, > -309095.42000602186 514966.4399645254, > -309083.1800054386 514984.559965387, > -309081.1200053394 515014.35996680334, > -309068.7200047523 515020.4899670929, > -309068.30000472814 515026.4499673769, > -309067.0300046727 515030.3599675633, > -309054.87000409514 515047.47996837646, > -309043.9700035751 515060.69996900484, > -309041.57000345737 515066.5199692808, > -309032.730003044 515078.8799698688, > -309016.76000228524 515107.71997123584, > -309009.46000193805 515112.20997145027, > -309004.43000169843 515112.8599714823, > -309000.450001508 515112.5799714662, > -308992.78000114113 515108.0599712543 > ))'), ST_Geomfromtext('POLYGON (( > -308992.78000114113 515108.0599712543, > -308991.140001066 515102.94997100905, > -308984.80000076443 515093.52997056395, > -308976.3200003579 515071.97996953875, > -308965.42999984324 515056.24996879324, > -308955.59999937564 515039.59996800125, > -308945.3999988958 515013.9399667829, > -308940.1299986392 515003.59996629134, > -308938.5599985644 514997.499966003, > -308924.9999979213 514962.6199643463, > -308921.439997755 514956.3899640478, > -308910.2799972221 514944.63996349275, > -308901.2699967995 514945.0099635087, > -308891.5399963334 514941.33996333554, > -308873.2199954614 514932.08996289596, > -308858.2199947536 514918.0699622296, > -308844.9299941212 514908.16996175796, > -308839.5499938652 514913.7899620272, > -308834.6499936357 514912.4499619603, > -308829.0399933681 514907.06996170804, > -308827.3899932876 514901.95996146277, > -308828.86999335885 514895.079961136, > -308828.7699933499 514882.09996052086, > -308820.27999295294 514860.54995949566, > -308817.84999283403 514852.3899591081, > -308806.34999229014 514816.65995741263, > -308803.40999215096 514801.48995669186, > -308797.2499918565 514775.1099554375, > -308797.5999918729 514770.139955204, > -308795.6499917805 514755.0299544856, > -308796.6799918264 514740.12995377555, > -308796.6499918252 514726.15995311365, > -308791.9299916029 514707.8599522449, > -308790.5599915385 514698.7899518125, > -308791.0399915576 514691.82995148376, > -308789.53999149054 514684.7399511449, > -308790.7099915445 514667.84995034337, > -308788.3499914333 514658.7100499086, > -308791.01999156177 514648.9100494459, > -308791.43999157846 514642.9500491619, > -308795.169991754 514632.23004865274, > -308807.05999232084 514619.0800480284, > -308814.4999926761 514612.6100477204, > -308818.9499928877 514605.930047404, > -308827.3799932897 514599.53004710004, > -308836.2899937108 514586.1700464636, > -308845.5799941495 514581.8200462572, > -308857.39999471605 514569.6700456813, > -308877.12999565154 514573.0300458409, > -308896.719996579 514578.3800460957, > -308913.9799974039 514588.5600465797, > -308918.66999762505 514592.8800467849, > -308930.2199981734 514584.6900463961, > -308937.2399985045 514584.1800463684, > -308943.12999878824 514585.5900464356, > -308947.759999007 514590.9000466876, > -308950.3199991286 514597.060046982, > -308986.2200008333 514597.5600470044, > -308995.6100012809 514606.19004741684, > -309028.27000282705 514653.37004965544, > -309042.7600035146 514660.3600499891, > -309043.7500035614 514660.4300499931, > -309048.1700037718 514668.7199503854, > -309049.60000383854 514705.7499521449, > -309059.2800043002 514724.3899530284, > -309071.1000048667 514741.17995382845, > -309086.95000561327 514757.2499545887, > -309096.71000608057 514774.8899554275, > -309113.04000685364 514812.94995723665, > -309121.7200072706 514831.51995811984, > -309121.28000724316 514852.44995911047, > -309122.88000731915 514872.5299600661, > -309128.4600075856 514892.8799610324, > -309127.0200075209 514913.73996202275, > -309121.6700072661 514933.3299629539, > -309109.4300066829 514951.4499638155, > -309095.42000602186 514966.4399645254, > -309083.1800054386 514984.559965387, > -309081.1200053394 515014.35996680334, > -309068.7200047523 515020.4899670929, > -309068.30000472814 515026.4499673769, > -309067.0300046727 515030.3599675633, > -309054.87000409514 515047.47996837646, > -309043.9700035751 515060.69996900484, > -309041.57000345737 515066.5199692808, > -309032.730003044 515078.8799698688, > -309016.76000228524 515107.71997123584, > -309009.46000193805 515112.20997145027, > -309004.43000169843 515112.8599714823, > -309000.450001508 515112.5799714662, > -308992.78000114113 515108.0599712543 > ))')) > > Returns FALSE instead of TRUE, same thing for hundreds of polygons. Is it > just me or everyone get same result ? > > I tried with postgis 2.1 and 2.1.1dev > > My guess is it's not only ST_Overlaps() but some underlying function > called by ST_Overlaps() > > Thanks, > > Jean > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > > -- Jean Marchal Etudiant au doctorat / PHD student Université Laval - Pavillon Abitibi-Price Faculté de foresterie, de géographie et de géomatique 2405, rue de la Terrasse Québec (Québec) G1V 0A6 Tél: 418-656-2131 poste 2620
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
