search

orbisgis / geoclimate

Geospatial processing toolbox for environmental and climate studies
GNU Lesser General Public License v3.0
59 stars 16 forks source link

Coastline related bug ? #867

Closed j3r3m1 closed 10 months ago

j3r3m1 commented 10 months ago

I think this bug was solved in previous versions of GeoClimate but the problem is either still here either back for Nantes (LCZ with random color except for water - LCZ107): image

The zone calculated is the following bounding box: [47.2, -1.6, 47.4, -1.4].

ebocher commented 10 months ago

This bug is due to https://www.openstreetmap.org/way/510734818#map=16/47.3622/-1.4947 We must improve the sea/land algorithm to identify islet in a river vs islet in the sea

ebocher commented 10 months ago

Fixed geoms

j3r3m1 commented 10 months ago

Awesome ! Where is this fix (which PR) ?

j3r3m1 commented 10 months ago

@wurtzj Once this one is solved, I can remove the results from the bounding box [47.2, -1.6, 47.4, -1.4] and we can rerun it using the newest GeoClimate version.

wurtzj commented 10 months ago

Great ! Problem was only on Nantes ? Maybe we will have to check the results of what has been computed.

j3r3m1 commented 10 months ago

The problem may happen on any area having the "place=islet" tag. I have to double check some other examples but if it is the case for every occurence of this tag we better have to re-run the whole domain with the new version.

wurtzj commented 10 months ago

Yes, but this may take some times !

j3r3m1 commented 9 months ago

OK I have checked all tiles between Roanne and the Loire estuary and there was two others tiles having the problem with the last version:

I will test these tiles with the new version to be sure it solves the issue also for them.

I expected errors nearby the coast in a wetland area used for salt production but the algorithm worked really well there. image image

ebocher commented 9 months ago

maybe it's been coded by a genius jajajajajaaj

j3r3m1 commented 9 months ago

Don't make the malinois I have not said that it works with the two other grids along the Loire river...

j3r3m1 commented 9 months ago

  • [47.2, 0.0, 47.4, 0.2]

  • [47.2, 0.6, 47.4, 0.8]

OK it works with the new version... Good news

j3r3m1 commented 9 months ago
  • [47.2, 0.2, 47.4, 0.4]

For this one I suppose the problem again comes from many islets near this one: https://www.openstreetmap.org/way/262864650

j3r3m1 commented 9 months ago
  • [47.2, 0.6, 47.4, 0.8]

Same for this one: https://www.openstreetmap.org/way/118058999#map=17/47.39882/0.72860

ebocher commented 9 months ago

Good catch for this one: https://www.openstreetmap.org/way/27656728. It returns 

org.h2.jdbc.JdbcSQLNonTransientException: Exception lors de l'appel de la fonction définie par l'utilisateur: "isIntersects(POINT (323265.4455225839 5251024.915907195), POLYGON ((323196.60483309434 5250996.221196244, 323199.1643707509 5251000.448619803, 323224.3823794174 5251032.201069178, 323228.9226803783 5251037.992789977, 323241.1093434146 5251053.142112185, 323244.67602675117 5251057.706285682, 323250.7056371289 5251061.784787404, 323262.15252189524 5251076.200071756, 323265.69746036653 5251077.784027908, 323269.35160907067 5251076.973319236, 323272.037327345 5251073.600170378, 323280.7291168473 5251066.99865062, 323323.29526504455 5251034.685484891, 323328.2846918069 5251030.553446683, 323332.5622544732 5251024.3517640885, 323333.23052733485 5251021.206183051, 323332.724997864 5251018.462964974, 323317.50468024204 5251009.177414818, 323306.9859933844 5251002.764679516, 323300.3499126317 5251000.873293511, 323288.5684607539 5250997.17915607, 323263.248411888 5250980.600873145, 323251.21250031405 5250972.721208579, 323238.82880985446 5250974.117243279, 323234.33953267906 5250971.52731477, 323229.6379899115 5250972.425184141, 323226.5815007144 5250973.017714089, 323220.4927579003 5250975.258705828, 323198.60104687547 5250991.522926805, 323196.60483309434 5250996.221196244), (323203.95138867875 5251002.139740913, 323206.3928218731 5251000.186500318, 323215.6053227844 5251011.6324779745, 323213.1563450851 5251013.585942013, 323203.95138867875 5251002.139740913), (323208.857763406 5250993.494281918, 323210.38076770736 5250990.38968728, 323215.24890580616 5250992.767983129, 323213.7183529708 5250995.872803659, 323208.857763406 5250993.494281918), (323211.7061034797 5250988.7481180085, 323212.437252513 5250987.191173532, 323217.37097132445 5250989.489637974, 323216.64736812166 5250991.046354621, 323211.7061034797 5250988.7481180085), (323214.75129411265 5250995.307817036, 323226.9018780731 5250974.376161893, 323231.86154587514 5250977.285606041, 323232.7144386476 5250978.016275826, 323237.3547942436 5250980.85747733, 323234.2612129259 5250985.989181359, 323241.2109366399 5250990.0177349085, 323247.49204106536 5250993.666004146, 323247.87261924916 5250993.00943243, 323258.82356458006 5250999.475792679, 323260.446030846 5251000.428003146, 323262.55330662086 5251001.677058176, 323273.28889700276 5251008.01645288, 323267.8889994421 5251017.332946107, 323242.50947506726 5251002.291475794, 323238.3692710316 5251009.289927652, 323214.75129411265 5250995.307817036), (323219.2645607381 5251021.276926489, 323221.82439606637 5251019.242268709, 323225.19140572555 5251023.445393958, 323222.631571268 5251025.4800503, 323219.2645607381 5251021.276926489), (323226.02777135 5251027.391020658, 323238.32214732247 5251017.5110211065, 323252.8559331569 5251035.603967935, 323257.16430387844 5251040.96890453, 323244.8624041701 5251050.84909258, 323226.02777135 5251027.391020658), (323245.2755850955 5250978.249922943, 323246.91816968285 5250975.353071059, 323249.9073851642 5250977.042729583, 323248.26479969616 5250979.939580615, 323245.2755850955 5250978.249922943), (323249.56016710465 5250991.857491245, 323250.9038470201 5250989.570262775, 323253.940341791 5250991.325236055, 323252.59699566965 5250993.623576452, 323249.56016710465 5250991.857491245), (323249.78096729994 5251057.163331415, 323256.0488092659 5251052.091809482, 323257.7112527505 5251054.121716987, 323259.5183812563 5251052.676988333, 323257.85593805695 5251050.64708032, 323265.62199247617 5251044.407083545, 323267.2621288311 5251046.448787735, 323271.3184955827 5251043.19010542, 323283.1843723596 5251033.879232523, 323289.3565257856 5251041.6907093, 323287.3863693037 5251043.240438469, 323295.0202070252 5251047.415303454, 323289.49570270814 5251056.857876959, 323286.7491356366 5251055.950610186, 323283.55936437997 5251054.622897288, 323280.30740081146 5251052.985622204, 323277.4831100633 5251051.001797105, 323275.8980297239 5251052.29524231, 323276.13341636246 5251053.08899243, 323276.06913135614 5251053.7137981, 323275.8460316269 5251054.332260658, 323275.54044193216 5251054.719629163, 323275.0778987606 5251054.911512733, 323274.407916403 5251054.987289672, 323273.80637757876 5251054.827430201, 323273.3319834611 5251054.374554165, 323274.9868734584 5251056.4046935225, 323259.42074231606 5251069.008048215, 323249.78096729994 5251057.163331415), (323254.32237053546 5250983.438867884, 323255.9728390111 5250980.552904067, 323258.96204912575 5250982.242567082, 323257.31191424176 5250985.139642666, 323254.32237053546 5250983.438867884), (323263.0493110786 5250988.793169964, 323264.69944751787 5250985.896096021, 323267.68898674473 5250987.5968759805, 323266.0385149808 5250990.482836439, 323263.0493110786 5250988.793169964), (323267.708464192 5251002.801015354, 323269.2450191331 5251000.396759514, 323271.3316592756 5251001.713174807, 323269.79543834785 5251004.128542726, 323267.708464192 5251002.801015354), (323272.4477516487 5250993.8714531185, 323274.09067860054 5250990.985721624, 323277.0798779625 5250992.675393611, 323275.4369501339 5250995.561124254, 323272.4477516487 5250993.8714531185), (323276.0653847575 5251008.411170193, 323277.71552106855 5251005.514099848, 323280.70504669147 5251007.214886131, 323279.054575076 5251010.100842989, 323276.0653847575 5251008.411170193), (323281.43005638075 5250999.429426719, 323283.07265139295 5250996.532585155, 323286.0618452403 5250998.222261588, 323284.4192493475 5251001.1191023, 323281.43005638075 5250999.429426719), (323286.2354847223 5251025.57886473, 323291.00406122755 5251017.37141132, 323291.95036660344 5251017.943560291, 323292.0421203914 5251017.72946803, 323293.3415942637 5251018.491198097, 323292.9950682714 5251019.024392382, 323293.8147508546 5251019.655965443, 323294.0978934717 5251019.024574288, 323297.57288276823 5251021.04444085, 323297.19497645425 5251021.78991033, 323298.0477103045 5251022.264771667, 323298.39476101263 5251021.497985343, 323301.92591820087 5251023.627391097, 323301.4859658632 5251024.319113818, 323302.4631247079 5251024.912581354, 323302.93847001635 5251024.141934872, 323306.2876899931 5251025.998750327, 323304.3611374096 5251029.248933212, 323303.41039573716 5251029.533363254, 323303.66708185175 5251030.281982605, 323304.8363436648 5251029.979854598, 323308.8437487562 5251032.37300108, 323309.06270053703 5251033.122756032, 323309.7593382186 5251033.1796534695, 323309.6012850932 5251032.194489556, 323310.2015809878 5251031.308857062, 323313.2314923038 5251033.097425066, 323313.0439714173 5251033.392257334, 323313.8665154356 5251033.868029189, 323315.98479559715 5251030.21166394, 323318.1059940265 5251029.413743535, 323318.5719800172 5251030.0893298965, 323319.2780748374 5251029.456337065, 323318.7691490904 5251028.859901451, 323319.4983136925 5251027.23629501, 323320.48005529295 5251027.229002207, 323320.45798813994 5251026.495568531, 323319.49721480184 5251026.44661699, 323319.1921928323 5251024.342483028, 323321.5053575379 5251020.635765836, 323320.6818093904 5251020.126654996, 323320.3946518538 5251020.624693219, 323317.4923624471 5251018.810036074, 323318.41086508625 5251017.202978187, 323319.0696274714 5251017.005194512, 323318.8491481828 5251016.455693646, 323317.96665872977 5251016.749190321, 323313.6416161611 5251014.343349156, 323313.47902598727 5251013.458425917, 323312.65743523533 5251013.5165145, 323297.33863563876 5251005.980240134, 323299.6987476936 5251002.327714895, 323327.00119010743 5251017.267079261, 323330.23777354637 5251021.907969452, 323327.25929715036 5251027.60341589, 323323.3551616672 5251030.901967823, 323310.7547053016 5251039.901177937, 323286.2354847223 5251025.57886473), (323291.00406122755 5251017.37141132, 323291.5087793155 5251016.321812625, 323291.73030970583 5251016.404127827, 323292.60940029734 5251014.742638075, 323291.78904812725 5251014.088839905, 323293.81303845695 5251010.813475417, 323294.72547921294 5251011.264294291, 323295.67750809906 5251009.767450673, 323295.4838237089 5251009.606438529, 323296.117841114 5251008.586317592, 323297.22430075984 5251009.209261658, 323297.0299018313 5251009.526546777, 323298.2981865952 5251010.255848434, 323298.63902900036 5251009.533739767, 323299.58920322283 5251009.983423948, 323299.08367008984 5251010.754979025, 323302.3975056724 5251012.690716309, 323302.87285209715 5251011.920069857, 323303.8174851384 5251012.436657573, 323303.31395800004 5251013.274888069, 323306.7876095541 5251015.250309547, 323307.262956298 5251014.479663458, 323308.26929986075 5251015.03888577, 323307.60795979074 5251015.904109765, 323311.02056573564 5251017.859125039, 323312.9134048552 5251014.743431506, 323312.65743523533 5251013.5165145, 323313.47902598727 5251013.458425917, 323313.6416161611 5251014.343349156, 323317.96665872977 5251016.749190321, 323318.8491481828 5251016.455693646, 323319.0696274714 5251017.005194512, 323318.41086508625 5251017.202978187, 323317.4923624471 5251018.810036074, 323320.3946518538 5251020.624693219, 323320.6818093904 5251020.126654996, 323321.5053575379 5251020.635765836, 323319.1921928323 5251024.342483028, 323319.49721480184 5251026.44661699, 323320.45798813994 5251026.495568531, 323320.48005529295 5251027.229002207, 323319.4983136925 5251027.23629501, 323318.7691490904 5251028.859901451, 323319.2780748374 5251029.456337065, 323318.5719800172 5251030.0893298965, 323318.1059940265 5251029.413743535, 323315.98479559715 5251030.21166394, 323313.8665154356 5251033.868029189, 323313.0439714173 5251033.392257334, 323313.2314923038 5251033.097425066, 323310.2015809878 5251031.308857062, 323309.6012850932 5251032.194489556, 323309.7593382186 5251033.1796534695, 323309.06270053703 5251033.122756032, 323308.8437487562 5251032.37300108, 323304.8363436648 5251029.979854598, 323303.66708185175 5251030.281982605, 323303.41039573716 5251029.533363254, 323304.3611374096 5251029.248933212, 323306.2876899931 5251025.998750327, 323302.93847001635 5251024.141934872, 323302.4631247079 5251024.912581354, 323301.4859658632 5251024.319113818, 323301.92591820087 5251023.627391097, 323298.39476101263 5251021.497985343, 323298.0477103045 5251022.264771667, 323297.19497645425 5251021.78991033, 323297.57288276823 5251021.04444085, 323294.0978934717 5251019.024574288, 323293.8147508546 5251019.655965443, 323292.9950682714 5251019.024392382, 323293.3415942637 5251018.491198097, 323292.0421203914 5251017.72946803, 323291.95036660344 5251017.943560291, 323291.00406122755 5251017.37141132))): side location conflict [ (323291.00406122755, 5251017.37141132, NaN) ]"
Exception calling user-defined function: "isIntersects(POINT (323265.4455225839 5251024.915907195), POLYGON ((323196.60483309434 5250996.221196244, 323199.1643707509 5251000.448619803, 323224.3823794174 5251032.201069178, 323228.9226803783 5251037.992789977, 323241.1093434146 5251053.142112185, 323244.67602675117 5251057.706285682, 323250.7056371289 5251061.784787404, 323262.15252189524 5251076.200071756, 323265.69746036653 5251077.784027908, 323269.35160907067 5251076.973319236, 323272.037327345 5251073.600170378, 323280.7291168473 5251066.99865062, 323323.29526504455 5251034.685484891, 323328.2846918069 5251030.553446683, 323332.5622544732 5251024.3517640885, 323333.23052733485 5251021.206183051, 323332.724997864 5251018.462964974, 323317.50468024204 5251009.177414818, 323306.9859933844 5251002.764679516, 323300.3499126317 5251000.873293511, 323288.5684607539 5250997.17915607, 323263.248411888 5250980.600873145, 323251.21250031405 5250972.721208579, 323238.82880985446 5250974.117243279, 323234.33953267906 5250971.52731477, 323229.6379899115 5250972.425184141, 323226.5815007144 5250973.017714089, 323220.4927579003 5250975.258705828, 323198.60104687547 5250991.522926805, 323196.60483309434 5250996.221196244), (323203.95138867875 5251002.139740913, 323206.3928218731 5251000.186500318, 323215.6053227844 5251011.6324779745, 323213.1563450851 5251013.585942013, 323203.95138867875 5251002.139740913), (323208.857763406 5250993.494281918, 323210.38076770736 5250990.38968728, 323215.24890580616 5250992.767983129, 323213.7183529708 5250995.872803659, 323208.857763406 5250993.494281918), (323211.7061034797 5250988.7481180085, 323212.437252513 5250987.191173532, 323217.37097132445 5250989.489637974, 323216.64736812166 5250991.046354621, 323211.7061034797 5250988.7481180085), (323214.75129411265 5250995.307817036, 323226.9018780731 5250974.376161893, 323231.86154587514 5250977.285606041, 323232.7144386476 5250978.016275826, 323237.3547942436 5250980.85747733, 323234.2612129259 5250985.989181359, 323241.2109366399 5250990.0177349085, 323247.49204106536 5250993.666004146, 323247.87261924916 5250993.00943243, 323258.82356458006 5250999.475792679, 323260.446030846 5251000.428003146, 323262.55330662086 5251001.677058176, 323273.28889700276 5251008.01645288, 323267.8889994421 5251017.332946107, 323242.50947506726 5251002.291475794, 323238.3692710316 5251009.289927652, 323214.75129411265 5250995.307817036), (323219.2645607381 5251021.276926489, 323221.82439606637 5251019.242268709, 323225.19140572555 5251023.445393958, 323222.631571268 5251025.4800503, 323219.2645607381 5251021.276926489), (323226.02777135 5251027.391020658, 323238.32214732247 5251017.5110211065, 323252.8559331569 5251035.603967935, 323257.16430387844 5251040.96890453, 323244.8624041701 5251050.84909258, 323226.02777135 5251027.391020658), (323245.2755850955 5250978.249922943, 323246.91816968285 5250975.353071059, 323249.9073851642 5250977.042729583, 323248.26479969616 5250979.939580615, 323245.2755850955 5250978.249922943), (323249.56016710465 5250991.857491245, 323250.9038470201 5250989.570262775, 323253.940341791 5250991.325236055, 323252.59699566965 5250993.623576452, 323249.56016710465 5250991.857491245), (323249.78096729994 5251057.163331415, 323256.0488092659 5251052.091809482, 323257.7112527505 5251054.121716987, 323259.5183812563 5251052.676988333, 323257.85593805695 5251050.64708032, 323265.62199247617 5251044.407083545, 323267.2621288311 5251046.448787735, 323271.3184955827 5251043.19010542, 323283.1843723596 5251033.879232523, 323289.3565257856 5251041.6907093, 323287.3863693037 5251043.240438469, 323295.0202070252 5251047.415303454, 323289.49570270814 5251056.857876959, 323286.7491356366 5251055.950610186, 323283.55936437997 5251054.622897288, 323280.30740081146 5251052.985622204, 323277.4831100633 5251051.001797105, 323275.8980297239 5251052.29524231, 323276.13341636246 5251053.08899243, 323276.06913135614 5251053.7137981, 323275.8460316269 5251054.332260658, 323275.54044193216 5251054.719629163, 323275.0778987606 5251054.911512733, 323274.407916403 5251054.987289672, 323273.80637757876 5251054.827430201, 323273.3319834611 5251054.374554165, 323274.9868734584 5251056.4046935225, 323259.42074231606 5251069.008048215, 323249.78096729994 5251057.163331415), (323254.32237053546 5250983.438867884, 323255.9728390111 5250980.552904067, 323258.96204912575 5250982.242567082, 323257.31191424176 5250985.139642666, 323254.32237053546 5250983.438867884), (323263.0493110786 5250988.793169964, 323264.69944751787 5250985.896096021, 323267.68898674473 5250987.5968759805, 323266.0385149808 5250990.482836439, 323263.0493110786 5250988.793169964), (323267.708464192 5251002.801015354, 323269.2450191331 5251000.396759514, 323271.3316592756 5251001.713174807, 323269.79543834785 5251004.128542726, 323267.708464192 5251002.801015354), (323272.4477516487 5250993.8714531185, 323274.09067860054 5250990.985721624, 323277.0798779625 5250992.675393611, 323275.4369501339 5250995.561124254, 323272.4477516487 5250993.8714531185), (323276.0653847575 5251008.411170193, 323277.71552106855 5251005.514099848, 323280.70504669147 5251007.214886131, 323279.054575076 5251010.100842989, 323276.0653847575 5251008.411170193), (323281.43005638075 5250999.429426719, 323283.07265139295 5250996.532585155, 323286.0618452403 5250998.222261588, 323284.4192493475 5251001.1191023, 323281.43005638075 5250999.429426719), (323286.2354847223 5251025.57886473, 323291.00406122755 5251017.37141132, 323291.95036660344 5251017.943560291, 323292.0421203914 5251017.72946803, 323293.3415942637 5251018.491198097, 323292.9950682714 5251019.024392382, 323293.8147508546 5251019.655965443, 323294.0978934717 5251019.024574288, 323297.57288276823 5251021.04444085, 323297.19497645425 5251021.78991033, 323298.0477103045 5251022.264771667, 323298.39476101263 5251021.497985343, 323301.92591820087 5251023.627391097, 323301.4859658632 5251024.319113818, 323302.4631247079 5251024.912581354, 323302.93847001635 5251024.141934872, 323306.2876899931 5251025.998750327, 323304.3611374096 5251029.248933212, 323303.41039573716 5251029.533363254, 323303.66708185175 5251030.281982605, 323304.8363436648 5251029.979854598, 323308.8437487562 5251032.37300108, 323309.06270053703 5251033.122756032, 323309.7593382186 5251033.1796534695, 323309.6012850932 5251032.194489556, 323310.2015809878 5251031.308857062, 323313.2314923038 5251033.097425066, 323313.0439714173 5251033.392257334, 323313.8665154356 5251033.868029189, 323315.98479559715 5251030.21166394, 323318.1059940265 5251029.413743535, 323318.5719800172 5251030.0893298965, 323319.2780748374 5251029.456337065, 323318.7691490904 5251028.859901451, 323319.4983136925 5251027.23629501, 323320.48005529295 5251027.229002207, 323320.45798813994 5251026.495568531, 323319.49721480184 5251026.44661699, 323319.1921928323 5251024.342483028, 323321.5053575379 5251020.635765836, 323320.6818093904 5251020.126654996, 323320.3946518538 5251020.624693219, 323317.4923624471 5251018.810036074, 323318.41086508625 5251017.202978187, 323319.0696274714 5251017.005194512, 323318.8491481828 5251016.455693646, 323317.96665872977 5251016.749190321, 323313.6416161611 5251014.343349156, 323313.47902598727 5251013.458425917, 323312.65743523533 5251013.5165145, 323297.33863563876 5251005.980240134, 323299.6987476936 5251002.327714895, 323327.00119010743 5251017.267079261, 323330.23777354637 5251021.907969452, 323327.25929715036 5251027.60341589, 323323.3551616672 5251030.901967823, 323310.7547053016 5251039.901177937, 323286.2354847223 5251025.57886473), (323291.00406122755 5251017.37141132, 323291.5087793155 5251016.321812625, 323291.73030970583 5251016.404127827, 323292.60940029734 5251014.742638075, 323291.78904812725 5251014.088839905, 323293.81303845695 5251010.813475417, 323294.72547921294 5251011.264294291, 323295.67750809906 5251009.767450673, 323295.4838237089 5251009.606438529, 323296.117841114 5251008.586317592, 323297.22430075984 5251009.209261658, 323297.0299018313 5251009.526546777, 323298.2981865952 5251010.255848434, 323298.63902900036 5251009.533739767, 323299.58920322283 5251009.983423948, 323299.08367008984 5251010.754979025, 323302.3975056724 5251012.690716309, 323302.87285209715 5251011.920069857, 323303.8174851384 5251012.436657573, 323303.31395800004 5251013.274888069, 323306.7876095541 5251015.250309547, 323307.262956298 5251014.479663458, 323308.26929986075 5251015.03888577, 323307.60795979074 5251015.904109765, 323311.02056573564 5251017.859125039, 323312.9134048552 5251014.743431506, 323312.65743523533 5251013.5165145, 323313.47902598727 5251013.458425917, 323313.6416161611 5251014.343349156, 323317.96665872977 5251016.749190321, 323318.8491481828 5251016.455693646, 323319.0696274714 5251017.005194512, 323318.41086508625 5251017.202978187, 323317.4923624471 5251018.810036074, 323320.3946518538 5251020.624693219, 323320.6818093904 5251020.126654996, 323321.5053575379 5251020.635765836, 323319.1921928323 5251024.342483028, 323319.49721480184 5251026.44661699, 323320.45798813994 5251026.495568531, 323320.48005529295 5251027.229002207, 323319.4983136925 5251027.23629501, 323318.7691490904 5251028.859901451, 323319.2780748374 5251029.456337065, 323318.5719800172 5251030.0893298965, 323318.1059940265 5251029.413743535, 323315.98479559715 5251030.21166394, 323313.8665154356 5251033.868029189, 323313.0439714173 5251033.392257334, 323313.2314923038 5251033.097425066, 323310.2015809878 5251031.308857062, 323309.6012850932 5251032.194489556, 323309.7593382186 5251033.1796534695, 323309.06270053703 5251033.122756032, 323308.8437487562 5251032.37300108, 323304.8363436648 5251029.979854598, 323303.66708185175 5251030.281982605, 323303.41039573716 5251029.533363254, 323304.3611374096 5251029.248933212, 323306.2876899931 5251025.998750327, 323302.93847001635 5251024.141934872, 323302.4631247079 5251024.912581354, 323301.4859658632 5251024.319113818, 323301.92591820087 5251023.627391097, 323298.39476101263 5251021.497985343, 323298.0477103045 5251022.264771667, 323297.19497645425 5251021.78991033, 323297.57288276823 5251021.04444085, 323294.0978934717 5251019.024574288, 323293.8147508546 5251019.655965443, 323292.9950682714 5251019.024392382, 323293.3415942637 5251018.491198097, 323292.0421203914 5251017.72946803, 323291.95036660344 5251017.943560291, 323291.00406122755 5251017.37141132))): side location conflict [ (323291.00406122755, 5251017.37141132, NaN) ]"; SQL statement:
CREATE TABLE  filtered_area_81ddb7de_ed3b_42aa_88fe_7288d7b7f19d AS 
                    SELECT a.EXPLOD_ID , a.the_geom, st_area(b.the_geom) as area_imp, b.* EXCEPT(the_geom) from polygonized_exploded_4de272c0_d33c_437f_bda9_570db49ff99c as a , OSM_IMPERVIOUS_a71f1c09_58a0_40c1_821f_afe5e7832381 as b where
                    a.the_geom && b.the_geom AND st_intersects(st_pointonsurface(a.the_geom), b.the_geom)  [90105-214]

geoms

j3r3m1 commented 9 months ago

To @wurtzj, it is hard to know whether or not the whole domain has to be recalculated. The bug happens when a surface :

  1. has the tag "place=islet" AND
  2. does have any other tag related to land
  3. is not a real island but a peninsula

Checking areas respecting the first constraint is easy, we can get the zones using this simple script in overpass:

way
  [place=islet]
  ({{bbox}});
(._;>;);
out;

But the result contains a lot of results (almost 400 for a zone being less than 1 tenth of France - cf. below) and filter these surfaces using the two others constraints is not simple to implement automatically. image

We can discuss it but I think the easiest way will be to re-run the whole domain.

wurtzj commented 9 months ago

@j3r3m1 I think we can rerun the whole domains, but when more bugs are identified and solved.