pb with position of some points outside from their watershed
build_limit.sql line 742
lm_id | lm_annee_debut | lm_annee_fin | lm_presence | lm_cours_eau_entier | lm_nom_expert | lm_date_expert | lm_cd_id | lm_bv_id | lm_tl_id | lm_id_roe | lm_ic_id | lm_ta_id | lm_co_id | lm_commentaire | lm_datelastupdate | lm_xl93_2154 | lm_yl93_2154 | geom | lm_oldid |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 327 | 2 007 | 2 020 | false | true | valeur manquante | 2023-04-04 | 120 525 | 118 | 4 | 2 220 | 2019-01-01 | 636 047,600370319 | 7 083 658,60078836 | POINT (636047.6003703191 7083658.600788359) | 51(2220) | ||||
1 335 | 2 007 | 2 020 | false | true | valeur manquante | 2023-04-04 | 115 312 | 12 | 4 | 2 220 | 2019-01-01 | 421 941,291199497 | 6 274 449,514774 | POINT (421941.2911994966 6274449.514773996) | 80(2220) | ||||
64 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C. | 2016-07-05 | 117 136 | 70 | 1 | 1 | 2 056 | 1 | 2019-01-01 | 170 513,653627177 | 6 838 472,262188 | POINT (170513.65362717726 6838472.262187995) | 64(2056) | ||
65 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C. | 2016-07-05 | 117 136 | 70 | 1 | 1 | 2 057 | 1 | 2019-01-01 | 833 889,089102334 | 6 372 474,7559246 | POINT (833889.0891023341 6372474.755924596) | 65(2057) | ||
73 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C. | 2016-07-05 | 91 431 | 131 | 3 | ROE21656 | 2 | 2 014 | 1 | 2019-01-01 | 772 364,374399162 | 6 274 117,95952709 | POINT (772364.3743991622 6274117.95952709) | 73(2014) | |
79 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C., Diouach O. | 2016-07-21 | 119 453 | 18 | 2 | 3 | 2 014 | 8 | 2019-01-01 | 383 967,20784155 | 6 879 210,87314655 | POINT (383967.2078415504 6879210.873146549) | 79(2014) | ||
80 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C., Diouach O. | 2016-07-21 | 95 185 | 18 | 2 | 2 | 2 014 | 8 | 2019-01-01 | 421 941,291199497 | 6 274 449,514774 | POINT (421941.2911994966 6274449.514773996) | 80(2014) | ||
81 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C., Diouach O. | 2016-07-21 | 120 344 | 18 | 2 | 2 | 2 014 | 8 | 2019-01-01 | 795 344,290175075 | 6 286 078,06056524 | POINT (795344.290175075 6286078.060565243) | 81(2014) | ||
84 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C., Diouach O. | 2016-07-21 | 114 186 | 18 | 3 | ROE60603 | 3 | 2 014 | 8 | 2019-01-01 | 341 614,9 | 6 744 122,5 | POINT (341614.9 6744122.5) | 84(2014) | |
85 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C., Diouach O. | 2016-07-21 | 119 225 | 18 | 3 | ROE25767 | 3 | 2 014 | 8 | 2019-01-01 | 460 917,248850766 | 6 449 414,087973 | POINT (460917.2488507656 6449414.087973003) | 85(2014) | |
87 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C., Diouach O. | 2016-07-21 | 94 939 | 14 | 3 | ROE25514 | 1 | 2 014 | 8 | 2019-01-01 | 404 681,852448133 | 6 889 886,64902891 | POINT (404681.85244813334 6889886.6490289075) | 87(2014) | |
141 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C., Diouach O. | 2016-07-22 | 122 933 | 156 | 4 | 2 | 2 014 | 6 | 2019-01-01 | 365 364,592053568 | 6 272 294,25010389 | POINT (365364.5920535681 6272294.250103886) | 141(2014) | ||
144 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C., Diouach O. | 2016-07-22 | 28 221 | 156 | 4 | 2 | 2 014 | 6 | 2019-01-01 | 292 836,012319852 | 6 757 185,03998144 | POINT (292836.01231985155 6757185.039981442) | 144(2014) | ||
146 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C., Diouach O. | 2016-07-22 | 124 270 | 156 | 4 | 2 | 2 014 | 6 | 2019-01-01 | 355 167,21043867 | 6 238 539,41030958 | POINT (355167.21043867036 6238539.410309576) | 146(2014) | ||
149 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C., Diouach O. | 2016-07-22 | 117 047 | 156 | 4 | 2 | 2 014 | 6 | 2019-01-01 | 633 874,031745339 | 6 882 169,38206238 | POINT (633874.0317453388 6882169.382062384) | 149(2014) | ||
150 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C., Diouach O. | 2016-07-22 | 106 583 | 156 | 4 | 2 | 2 014 | 6 | 2019-01-01 | 232 770,817753826 | 6 789 105,71049553 | POINT (232770.8177538261 6789105.710495525) | 150(2014) | ||
155 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C., Diouach O. | 2016-07-22 | 37 484 | 8 | 4 | 2 | 2 014 | 5 | 2019-01-01 | 238 200,5 | 6 753 542 | POINT (238200.5 6753542) | 155(2014) | ||
180 | 2 006 | 2 015 | true | false | Chapon P.M., Sauvadet C. | 2016-08-04 | 124 355 | 158 | 4 | 3 | 2 014 | 8 | 2019-01-01 | 636 047,600370319 | 7 083 658,60078836 | POINT (636047.6003703191 7083658.600788359) | 180(2014) | ||
200 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C., Diouach O. | 2016-07-21 | 93 217 | 14 | 3 | 3 | 2 014 | 8 | 2019-01-01 | 449 370,59369135 | 6 219 176,49049238 | POINT (449370.59369134984 6219176.490492382) | 200(2014) | ||
230 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C., Diouach O. | 2016-07-21 | 17 206 | 4 | 4 | 1 | 2 056 | 5 | 2019-01-01 | 383 957,816180687 | 6 946 033,35161708 | POINT (383957.8161806872 6946033.351617085) | 230(2056) | ||
243 | 2 006 | 2 015 | true | false | Chapon P.M.,Guillerme N. | 2016-10-25 | 124 002 | 3 | 4 | 2 | 2 014 | 7 | 2019-01-01 | 432 095,3 | 6 883 552 | POINT (432095.3 6883552) | 243(2014) | ||
245 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C., Diouach O. | 2016-07-21 | 124 081 | 19 | 3 | ROE13215 | 3 | 2 014 | 2 | 2019-01-01 | 450 374,173569414 | 6 856 033,87480358 | POINT (450374.17356941395 6856033.874803584) | 245(2014) | |
246 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C., Diouach O. | 2016-07-21 | 125 253 | 20 | 2 | 3 | 2 014 | 2 | 2019-01-01 | 475 947,31339157 | 6 892 710,90882629 | POINT (475947.3133915696 6892710.908826289) | 246(2014) | ||
249 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C. | 2016-07-07 | 91 897 | 21 | 4 | 2 | 2 014 | 2 | 2019-01-01 | 571 748,615908201 | 6 913 719,17629637 | POINT (571748.6159082011 6913719.176296374) | 249(2014) | ||
253 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C. | 2016-07-07 | 116 732 | 6 | 4 | 2 | 2 014 | 2 | 2019-01-01 | 528 683,313738648 | 6 964 657,07610665 | POINT (528683.3137386482 6964657.076106649) | 253(2014) | ||
256 | 2 006 | 2 015 | true | true | Beaulaton L., Chapon P.M., Sauvadet C. | 2016-07-07 | 94 498 | 68 | 3 | 2 | 2 014 | 2 | 2019-01-01 | 568 663,615277252 | 6 966 071,13611541 | POINT (568663.6152772516 6966071.136115412) | 256(2014) | ||
270 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C. | 2016-07-07 | 98 388 | 32 | 3 | 1 | 2 014 | 2 | 2019-01-01 | 647 826,6 | 7 075 556,5 | POINT (647826.6 7075556.5) | 270(2014) | ||
293 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C. | 2016-07-07 | 17 766 | 130 | 4 | 1 | 2 014 | 2 | 2019-01-01 | 226 739,842974489 | 6 801 111,94442519 | POINT (226739.842974489 6801111.944425185) | 293(2014) | ||
1 498 | 2 007 | 2 020 | false | false | valeur manquante | 2023-04-04 | 119 028 | 62 | 4 | ROE11896 | 2 220 | Valeur récupérée depuis le ROE | 2019-01-01 | 144 600,397245295 | 6 798 861,84125651 | POINT (144600.3972452952 6798861.841256514) | 85(2220) | ||
1 499 | 2 007 | 2 020 | false | false | valeur manquante | 2023-04-04 | 54 561 | 64 | 3 | ROE11825 | 2 220 | Valeur récupérée depuis le ROE | 2019-01-01 | 144 854,244906592 | 6 796 050,55710967 | POINT (144854.24490659247 6796050.55710967) | 87(2220) | ||
623 | 2 006 | 2 015 | true | true | Beaulaton L., Chapon P.M., Sauvadet C., Diouach O. | 2016-07-22 | 115 683 | 4 | 4 | 2 | 2 057 | 5 | 2019-01-01 | 636 047,600370319 | 7 083 658,60078836 | POINT (636047.6003703191 7083658.600788359) | 623(2057) | ||
634 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C., Diouach O. | 2016-07-22 | 124 106 | 156 | 4 | 1 | 2 011 | 6 | 2019-01-01 | 636 047,600370319 | 7 083 658,60078836 | POINT (636047.6003703191 7083658.600788359) | 634(2011) | ||
1 272 | 2 006 | 2 015 | true | false | Guillerme N. | 2016-11-16 | 17 348 | 3 | 4 | 2 | 2 057 | 7 | 2019-01-01 | 636 047,600370319 | 7 083 658,60078836 | POINT (636047.6003703191 7083658.600788359) | 1272(2057) | ||
1 280 | 2 006 | 2 015 | true | false | Chapon P.M., Guillerme N. | 2016-11-28 | 30 024 | 130 | 4 | 2 | 2 011 | 2 | 2019-01-01 | 636 047,600370319 | 7 083 658,60078836 | POINT (636047.6003703191 7083658.600788359) | 1280(2011) | ||
1 281 | 2 006 | 2 015 | true | false | Guillerme N. | 2016-12-05 | 43 595 | 123 | 4 | 2 | 2 014 | 8 | 2019-01-01 | 636 047,600370319 | 7 083 658,60078836 | POINT (636047.6003703191 7083658.600788359) | 1281(2014) | ||
1 462 | 2 007 | 2 020 | false | false | valeur manquante | 2023-04-04 | 116 966 | 160 | 3 | 2 220 | 2019-01-01 | 215 997,89917391 | 6 858 609,68726001 | POINT (215997.89917390994 6858609.687260006) | 36(2220) | ||||
147 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C., Diouach O. | 2016-07-22 | 124 124 | 156 | 4 | 2 | 2 014 | 6 | 2019-01-01 | 636 047,600370319 | 7 083 658,60078836 | POINT (636047.6003703191 7083658.600788359) | 147(2014) | ||
148 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C., Diouach O. | 2016-07-22 | 122 213 | 156 | 4 | 2 | 2 014 | 6 | 2019-01-01 | 636 047,600370319 | 7 083 658,60078836 | POINT (636047.6003703191 7083658.600788359) | 148(2014) | ||
283 | 2 006 | 2 015 | true | true | Chapon P.M., Guillerme N. | 2016-10-26 | 121 070 | 5 | 4 | 2 | 2 014 | 3 | 2019-01-01 | 636 047,600370319 | 7 083 658,60078836 | POINT (636047.6003703191 7083658.600788359) | 283(2014) | ||
1 380 | 2 007 | 2 017 | false | true | valeur manquante | 2023-04-04 | 110 852 | 1 | 3 | 2 220 | 2019-01-01 | 636 047,600370319 | 7 083 658,60078836 | POINT (636047.6003703191 7083658.600788359) | 283(2220) | ||||
170 | 2 006 | 2 015 | true | false | Chapon P.M., Sauvadet C. | 2016-08-04 | 119 937 | 158 | 4 | 2 | 2 014 | 8 | 2019-01-01 | 433 340,9 | 6 716 239,5 | POINT (433340.9 6716239.5) | 170(2014) | ||
172 | 2 006 | 2 015 | true | false | Chapon P.M., Sauvadet C. | 2016-08-04 | 112 687 | 158 | 4 | 2 | 2 014 | 8 | 2019-01-01 | 418 581,587228252 | 6 412 781,13933952 | POINT (418581.58722825185 6412781.139339517) | 172(2014) | ||
1 497 | 2 007 | 2 020 | false | false | valeur manquante | 2023-04-04 | 55 690 | 66 | 4 | 2 220 | 2019-01-01 | 150 846,434730469 | 6 796 213,09182951 | POINT (150846.43473046916 6796213.091829512) | 89(2220) | ||||
83 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C., Diouach O. | 2016-07-21 | 15 742 | 18 | 2 | 3 | 2 014 | 8 | 2019-01-01 | 385 423,537568162 | 6 302 437,28994064 | POINT (385423.5375681619 6302437.289940642) | 83(2014) | ||
143 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C., Diouach O. | 2016-07-22 | 56 963 | 156 | 4 | 2 | 2 014 | 6 | 2019-01-01 | 367 278,846832859 | 6 271 655,61994306 | POINT (367278.84683285886 6271655.61994306) | 143(2014) | ||
479 | 2 006 | 2 015 | true | true | Chapon P.M., Guillerme N. | 2016-10-26 | 121 070 | 5 | 4 | 2 | 2 057 | 3 | 2019-01-01 | 636 047,600370319 | 7 083 658,60078836 | POINT (636047.6003703191 7083658.600788359) | 479(2057) | ||
522 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C. | 2016-07-07 | 112 795 | 130 | 3 | 2 | 2 011 | 2 | 2019-01-01 | 636 047,600370319 | 7 083 658,60078836 | POINT (636047.6003703191 7083658.600788359) | 522(2011) | ||
44 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C. | 2016-07-05 | 118 359 | 76 | 3 | 3 | 2 014 | 1 | 2019-01-01 | 448 891,253408499 | 6 870 696,09796636 | POINT (448891.25340849883 6870696.097966357) | 44(2014) | ||
587 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C., Diouach O. | 2016-07-21 | 93 217 | 14 | 4 | 1 | 2 011 | 8 | Expertise | 2019-01-01 | 636 047,600370319 | 7 083 658,60078836 | POINT (636047.6003703191 7083658.600788359) | 587(2011) | |
135 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C., Diouach O. | 2016-07-22 | 27 956 | 156 | 4 | 2 | 2 014 | 6 | 2019-01-01 | 568 600,758527797 | 6 969 762,44222379 | POINT (568600.7585277971 6969762.442223787) | 135(2014) | ||
139 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C., Diouach O. | 2016-07-22 | 120 298 | 45 | 4 | 1 | 2 014 | 6 | 2019-01-01 | 302 180,147813277 | 6 726 019,13992732 | POINT (302180.1478132774 6726019.139927318) | 139(2014) | ||
140 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C., Diouach O. | 2016-07-22 | 73 573 | 156 | 4 | 2 | 2 014 | 6 | 2019-01-01 | 299 331,893634917 | 6 739 568,27851695 | POINT (299331.89363491716 6739568.278516954) | 140(2014) | ||
609 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C., Diouach O. | 2016-07-21 | 113 131 | 55 | 4 | 2 | 2 014 | 8 | Expertise | 2019-01-01 | 636 047,600370319 | 7 083 658,60078836 | POINT (636047.6003703191 7083658.600788359) | 609(2014) | |
145 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C., Diouach O. | 2016-07-22 | 124 106 | 156 | 4 | 2 | 2 014 | 6 | 2019-01-01 | 386 213,829764119 | 6 842 431,21115037 | POINT (386213.8297641194 6842431.2111503715) | 145(2014) | ||
648 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C., Diouach O. | 2016-07-22 | 125 634 | 156 | 4 | 1 | 2 014 | 6 | 2019-01-01 | 636 047,600370319 | 7 083 658,60078836 | POINT (636047.6003703191 7083658.600788359) | 648(2014) | ||
1 271 | 2 006 | 2 015 | true | false | Guillerme N. | 2016-11-16 | 105 771 | 3 | 4 | 2 | 2 057 | 7 | 2019-01-01 | 636 047,600370319 | 7 083 658,60078836 | POINT (636047.6003703191 7083658.600788359) | 1271(2057) | ||
1 409 | 2 007 | 2 017 | false | false | valeur manquante | 2023-04-04 | 116 732 | 6 | 3 | ROE17969 | 2 220 | 2019-01-01 | 380 183,693147058 | 6 906 202,17704991 | POINT (217908.49410364492 6790816.484850498) | 232(2220) | |||
55 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C. | 2016-07-05 | 113 309 | 73 | 3 | ROE16019 | 3 | 2 011 | 1 | 2019-01-01 | 337 726,536357781 | 6 755 348,77366507 | POINT (337726.5363577812 6755348.773665073) | 55(2011) | |
1 444 | 2 007 | 2 020 | false | false | valeur manquante | 2023-04-04 | 94 089 | 159 | 3 | ROE36748 | 2 220 | 2019-01-01 | 280 416,430089461 | 6 835 653,61799789 | POINT (280423.83536160993 6835643.66156495) | 13(2220) | |||
157 | 2 006 | 2 015 | true | true | Beaulaton L., Chapon P.M., Sauvadet C., Diouach O. | 2016-07-22 | 115 683 | 4 | 4 | 2 | 2 014 | 5 | 2019-01-01 | 530 465,672288773 | 6 339 008,53329378 | POINT (530465.6722887732 6339008.533293777) | 157(2014) | ||
191 | 2 006 | 2 015 | true | false | Beaulaton L., Chapon P.M., Sauvadet C., Diouach O. | 2016-07-21 | 112 937 | 105 | 3 | ROE22397 | 2 | 2 014 | 8 | 2019-01-01 | 637 904,1 | 7 088 222 | POINT (637904.1 7088222) | 191(2014) | |
1 494 | 2 018 | 2 018 | false | false | valeur manquante | 2023-04-04 | 124 055 | 76 | 4 | ROE8929 | 2 220 | 2019-01-01 | 647 185,248053622 | 7 041 212,79034852 | POINT (647196.285635712 7041216.87408632) | 303(2220) | |||
1 283 | 2 006 | 2 015 | true | false | Chapon P.M., Guillerme N. | 2016-12-14 | 118 910 | 162 | 3 | ROE48097 | 1 | 2 057 | 3 | 2019-01-01 | 636 047,600370319 | 7 083 658,60078836 | POINT (702576.902755868 6161175.28507446) | 1283(2057) |