[postgis-users] ST_Overlaps broken ?
Jean Marchal
jean.d.marchal at gmail.com
Tue Sep 10 16:51:07 PDT 2013
Thanks a lot!! looks like it was my mind more than something else that was
broken!
Jean
2013/9/10 Brent Wood <pcreso at pcreso.com>
>
> 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 <jean.d.marchal at gmail.com>
> *To:* PostGIS Users Discussion <postgis-users at lists.osgeo.org>
> *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
> postgis-users at lists.osgeo.org
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130910/6c00287f/attachment.html>
More information about the postgis-users
mailing list