zdila
commented
5 years ago I see that problem now reguralry on the map. Is it a knwon problem?
Open zdila opened 5 years ago
zdila
commented
5 years ago I see that problem now reguralry on the map. Is it a knwon problem?
olt
commented
5 years ago You need to provide more details. Planet or extracts? How do you import diffs? Limitto? Which elements are duplicate (all columns including the OSM ID)?
zdila
commented
5 years ago @olt, full process is described at https://github.com/FreemapSlovakia/freemap-mapnik/blob/fe8686aef2072dd6ba6eb05c3444cd8c5909603e/doc/INSTALL.md#setting-up-minutely-diff-applying-working-notes
I'll check which elements are duplicated in the evening and will update it here.
zdila
commented
5 years ago Initial import was done cca 2 months ago and since then minutely diffs are being applied. Some stats on roads table:
martin=> select count(1) from osm_roads a join osm_roads b on (a.id <> b.id and a.osm_id = b.osm_id and a.type = b.type);
count
-------
164
(1 row)Duplicates differ only in id and geometry column. I've tried for every other column:
martin=> select a.osm_id from osm_roads a join osm_roads b on (a.id <> b.id and a.osm_id = b.osm_id and a.type = b.type) where a.COLUMN <> b.COLUMN
osm_id
--------
(0 rows)...and all returned 0.
Also there are no duplicates having equal geometry:
martin=> select a.osm_id from osm_roads a join osm_roads b on (a.id <> b.id and a.osm_id = b.osm_id and a.type = b.type) where st_equals(a.geometry, b.geometry);
osm_id
--------
(0 rows)We use Postgres 11.1. Also:
martin=> SELECT PostGIS_full_version();
NOTICE: Topology support cannot be inspected. Is current user granted USAGE on schema "topology" ?
postgis_full_version
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------
POSTGIS="2.5.1 r17027" [EXTENSION] PGSQL="100" (procs need upgrade for use with "110") GEOS="3.7.1-CAPI-1.11.1 27a5e771" PROJ="Rel. 5.2.0, September 15th, 2018" GDAL="GDAL 2.3.2, released 2018/09/21" LIBXML="2.9.8" LIBJSON="0.13.1"
LIBPROTOBUF="1.3.1" (core procs from "2.5.0 r16836" need upgrade) RASTER (raster procs from "2.5.0 r16836" need upgrade)
(1 row)@olt is it sufficient or do you need some more info?
ImreSamu
commented
5 years ago Hi @zdila ,
imho: it is at least "a weekend project" to analyze your issue. ( setup your system , loading europe-latest.osm.pbf, replay 2-month osm data. ) + cost of the cloud server price.
Can you create a minimal setup (minimal input data + minimal mapping) for reproducing a problem?
for example:
roads table with minimal columns ) so anybody with a simple laptop ( with minimal disk space ) - can replay and reproduce the problems.
- Version used: latest
this is the latest binary? ( v0.6.0-alpha.4 )
or the latest master ?
osm_roads table: .... count: 164
Can you export and share the 164 osm_ids and the geometry data ( gist? SELECT format ; PG Dump format )
Duplicates differ only in
idandgeometrycolumn.
Can you analyze the geometry differences? ( https://postgis.net/docs/ST_Difference.html ? )
zdila
commented
5 years ago I will try to prepare testcase once I'll be little less bussy. Till then maybe you can use my answers:
this is the latest binary?
It was the latest master
Can you export and share the 164 osm_ids and the geometry data Can you analyze the geometry differences?
Meanwhile I've reimported the data. Geometries and their differences since then:
martin=> select a.id, st_astext(a.geometry), st_astext(b.geometry), st_astext(ST_Difference(a.geometry, b.geometry)) from osm_roads a join osm_roads b on (a.id <> b.id and a.osm_id = b.osm_id and a.type = b.type);;
id | st_astext | st_astext | st_astext
---------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
102027 | LINESTRING(1917737.90118915 6248775.20188545,1917781.25158386 6248795.78917159,1917822.73584019 6248817.26976109,1917833.0182627 6248822.33153169) | LINESTRING(1917737.90118915 6248775.20188545,1917781.25158386 6248795.78917159,1917822.73584019 6248817.26976109,1917845.39399062 6248823.19952998) | LINESTRING(1917822.73584019 6248817.26976109,1917833.0182627 6248822.33153169)
152009 | LINESTRING(2364525.35726721 6225301.15077423,2364531.55284665 6225300.04790424) | LINESTRING(2364525.80463652 6225299.81256591,2364531.55284665 6225300.04790424) | LINESTRING(2364525.35726721 6225301.15077423,2364531.55284665 6225300.04790424)
297785 | LINESTRING(1907844.18597576 6211970.72254427,1907817.38822854 6211921.53840609,1907816.86570979 6211892.40075011,1907792.92315429 6211853.3671766,1907790.31989124 6211834.63394839,1907773.14208739 6211791.43615676,1907803.85872524 6211664.94976805,1907818.43326603 6211583.76513247,1907827.27876198 6211459.89335646,1907827.27876198 6211434.92158973) | LINESTRING(1907847.17826528 6211975.27913989,1907817.38822854 6211921.53840609,1907816.86570979 6211892.40075011,1907792.92315429 6211853.3671766,1907790.31989124 6211834.63394839,1907773.14208739 6211791.43615676,1907803.85872524 6211664.94976805,1907818.43326603 6211583.76513247,1907827.27876198 6211459.89335646,1907827.27876198 6211434.92158973) | LINESTRING(1907844.18597576 6211970.72254427,1907817.38822854 6211921.53840609)
192052 | LINESTRING(2376633.46028186 6323408.1744459,2376626.45293222 6323346.60832749,2376672.6118652 6323186.50133708,2376775.98660111 6322890.99872174,2376789.7680331 6322862.77782789,2376799.04274088 6322825.31699032,2376765.04169948 6322800.85811419,2376600.14971166 6322685.601981) | LINESTRING(2376633.46028186 6323408.1744459,2376626.45293222 6323346.60832749,2376663.65889856 6323233.67223666,2376775.98660111 6322890.99872174,2376789.7680331 6322862.77782789,2376799.04274088 6322825.31699032,2376765.04169948 6322800.85811419,2376600.14971166 6322685.601981) | LINESTRING(2376626.45293222 6323346.60832749,2376672.6118652 6323186.50133708,2376775.98660111 6322890.99872174)
479231 | LINESTRING(1851733.96740783 6125667.09284578,1851699.24790315 6125701.38787343) | LINESTRING(1851733.96740783 6125667.09284578,1851705.82022367 6125696.03095116) | LINESTRING(1851733.96740783 6125667.09284578,1851699.24790315 6125701.38787343)
342913 | LINESTRING(2372334.94113869 6221098.07891646,2372365.6857686 6221023.22012393,2372401.25436624 6220940.12297336,2372413.02036877 6220910.1205795,2372425.57948011 6220872.09131972,2372437.75603308 6220841.43909717,2372452.89041539 6220813.38725232,2372475.05080873 6220786.8052118,2372494.23471134 6220766.86520306,2372513.81050301 6220738.07875282,2372531.16559 6220698.19901097,2372554.6509416 6220639.69398796) | LINESTRING(2372334.94483932 6221098.08144496,2372365.6857686 6221023.22012393,2372401.25436624 6220940.12297336,2372413.02036877 6220910.1205795,2372425.57948011 6220872.09131972,2372437.75603308 6220841.43909717,2372452.89041539 6220813.38725232,2372475.05080873 6220786.8052118,2372494.23471134 6220766.86520306,2372513.81050301 6220738.07875282,2372531.16559 6220698.19901097,2372554.6509416 6220639.69398796) | LINESTRING(2372334.94113869 6221098.07891646,2372365.6857686 6221023.22012393)
564885 | LINESTRING(2135277.3571658 6093726.79345696,2135233.46559095 6093612.10882204) | LINESTRING(2135270.14836451 6093696.38446885,2135233.46559095 6093612.10882204) | LINESTRING(2135277.3571658 6093726.79345696,2135233.46559095 6093612.10882204)
538688 | LINESTRING(1906782.85709132 6131560.20810122,1906775.59781299 6131591.21233631,1906752.44836631 6131684.77112813,1906736.7354811 6131748.24904295) | LINESTRING(1906783.14204448 6131559.27447154,1906775.59781299 6131591.21233631,1906752.44836631 6131684.77112813,1906736.7354811 6131748.24904295) | LINESTRING(1906782.85709132 6131560.20810122,1906775.59781299 6131591.21233631)
721047 | LINESTRING(1899367.56959948 6148433.88898751,1899339.446894 6148433.72083928,1899302.17077974 6148429.27892494) | LINESTRING(1899367.56959948 6148433.88898751,1899339.446894 6148433.72083928,1899304.5205418 6148429.60354461) | LINESTRING(1899339.446894 6148433.72083928,1899302.17077974 6148429.27892494)
669996 | LINESTRING(2134206.74424288 6382783.33522648,2134176.52213171 6382800.37754412,2134137.53850082 6382816.46909651,2134047.89854344 6382847.98961284) | LINESTRING(2134206.74424288 6382783.33522648,2134176.52213171 6382800.37754412,2134137.53850082 6382816.46909651,2134055.24083784 6382846.24234776) | LINESTRING(2134137.53850082 6382816.46909651,2134047.89854344 6382847.98961284)
1286731 | LINESTRING(2132496.25589708 6302709.72466023,2132497.53876417 6302703.6456301,2132527.09839621 6302646.7682837,2132548.24174412 6302613.07869676,2132572.32426 6302566.16178348) | LINESTRING(2132512.97172862 6302727.63240327,2132497.53876417 6302703.6456301,2132527.09839621 6302646.7682837,2132548.24174412 6302613.07869676,2132572.32426 6302566.16178348) | LINESTRING(2132496.25589708 6302709.72466023,2132497.53876417 6302703.6456301)
819403 | LINESTRING(2323847.84189467 6208148.64764054,2323812.48790294 6208155.44906881,2323750.34549468 6208163.01248921,2323674.54295342 6208171.05568619,2323633.02137433 6208174.61162834,2323595.83856698 6208187.17032481,2323529.83325226 6208212.11844203,2323458.86400943 6208244.30557245,2323430.97457124 6208256.69503962) | LINESTRING(2323844.70898332 6208148.65572171,2323812.48790294 6208155.44906881,2323750.34549468 6208163.01248921,2323674.54295342 6208171.05568619,2323633.02137433 6208174.61162834,2323595.83856698 6208187.17032481,2323529.83325226 6208212.11844203,2323458.86400943 6208244.30557245,2323430.97457124 6208256.69503962) | LINESTRING(2323847.84189467 6208148.64764054,2323812.48790294 6208155.44906881)
929802 | LINESTRING(1909275.36482699 6129746.17331533,1909260.59434166 6129772.30530676,1909246.57031169 6129791.96377556,1909229.95234936 6129810.79735805,1909213.69828402 6129827.04432736,1909195.7833555 6129841.36181985,1909178.52157543 6129854.00150108,1909158.58188678 6129865.63449851,1909141.68400369 6129873.57626546,1909120.63396269 6129881.88157187,1909102.09387782 6129887.78197963,1909080.84789229 6129891.85074659,1909055.92561414 6129894.5213129,1909033.39199313 6129894.8009534,1909006.25834099 6129894.15778026,1908886.04170615 6129886.67740061,1908848.56964735 6129885.11141542,1908809.4273947 6129887.78197963) | LINESTRING(1909275.36482699 6129746.17331533,1909260.59434166 6129772.30530676,1909246.57031169 6129791.96377556,1909229.95234936 6129810.79735805,1909213.69828402 6129827.04432736,1909195.7833555 6129841.36181985,1909178.52157543 6129854.00150108,1909158.58188678 6129865.63449851,1909141.68400369 6129873.57626546,1909120.63396269 6129881.88157187,1909102.09387782 6129887.78197963,1909080.84789229 6129891.85074659,1909055.92561414 6129894.5213129,1909033.39875917 6129894.81213866,1909006.25834099 6129894.15778026,1908886.04170615 6129886.67740061,1908848.56964735 6129885.11141542,1908809.4273947 6129887.78197963) | LINESTRING(1909055.92561414 6129894.5213129,1909033.39199313 6129894.8009534,1909006.25834099 6129894.15778026)
947332 | LINESTRING(1852088.30976462 6169238.97161151,1852085.30528182 6169231.18983931) | LINESTRING(1852088.30976462 6169238.97161151,1852082.87047094 6169224.67862775) | LINESTRING(1852088.30976462 6169238.97161151,1852085.30528182 6169231.18983931)
951790 | LINESTRING(2132512.97172862 6302727.63240327,2132497.53876417 6302703.6456301,2132527.09839621 6302646.7682837,2132548.24174412 6302613.07869676,2132572.32426 6302566.16178348) | LINESTRING(2132496.25589708 6302709.72466023,2132497.53876417 6302703.6456301,2132527.09839621 6302646.7682837,2132548.24174412 6302613.07869676,2132572.32426 6302566.16178348) | LINESTRING(2132512.97172862 6302727.63240327,2132497.53876417 6302703.6456301)
957841 | LINESTRING(2163331.51938453 6401553.04977376,2163383.56598413 6401447.15947884) | LINESTRING(2163331.51938453 6401553.04977376,2163383.84123656 6401449.02799872) | LINESTRING(2163331.51938453 6401553.04977376,2163383.56598413 6401447.15947884)
1023666 | LINESTRING(2118848.89185816 6042035.08062692,2118836.71530519 6042068.53173885,2118756.77926741 6042241.89278365) | LINESTRING(2118848.89185816 6042035.08062692,2118836.71530519 6042068.53173885,2118756.48076668 6042242.63661914) | LINESTRING(2118836.71530519 6042068.53173885,2118756.77926741 6042241.89278365)
1269552 | LINESTRING(1903113.12394672 6272922.24167436,1903283.41840516 6272853.03772817,1903334.69988802 6272823.6471955,1903394.22970254 6272780.40760872) | LINESTRING(1903113.12394672 6272922.24167436,1903283.41840516 6272853.03772817,1903334.69988802 6272823.6471955,1903393.97561948 6272781.41841819) | LINESTRING(1903334.69988802 6272823.6471955,1903394.22970254 6272780.40760872)
1286690 | LINESTRING(2118848.89185816 6042035.08062692,2118836.71530519 6042068.53173885,2118756.48076668 6042242.63661914) | LINESTRING(2118848.89185816 6042035.08062692,2118836.71530519 6042068.53173885,2118756.77926741 6042241.89278365) | LINESTRING(2118836.71530519 6042068.53173885,2118756.48076668 6042242.63661914)
1086627 | LINESTRING(1930051.53135497 6167713.6130241,1930061.02999936 6167707.22299922,1930069.35297656 6167698.89490805) | LINESTRING(1930051.53135497 6167713.6130241,1930061.03831282 6167707.23073847,1930069.35297656 6167698.89490805) | LINESTRING(1930051.53135497 6167713.6130241,1930061.02999936 6167707.22299922,1930069.35297656 6167698.89490805)
1229112 | LINESTRING(2087738.07893888 6309649.47630942,2087739.22661398 6309652.97517781) | LINESTRING(2087738.42898399 6309652.23947293,2087739.22661398 6309652.97517781) | LINESTRING(2087738.07893888 6309649.47630942,2087739.22661398 6309652.97517781)
1292846 | LINESTRING(1852088.30976462 6169238.97161151,1852082.87047094 6169224.67862775) | LINESTRING(1852088.30976462 6169238.97161151,1852085.30528182 6169231.18983931) | LINESTRING(1852088.30976462 6169238.97161151,1852082.87047094 6169224.67862775)
1288800 | LINESTRING(2135270.14836451 6093696.38446885,2135233.46559095 6093612.10882204) | LINESTRING(2135277.3571658 6093726.79345696,2135233.46559095 6093612.10882204) | LINESTRING(2135270.14836451 6093696.38446885,2135233.46559095 6093612.10882204)
1290717 | LINESTRING(2364525.80463652 6225299.81256591,2364531.55284665 6225300.04790424) | LINESTRING(2364525.35726721 6225301.15077423,2364531.55284665 6225300.04790424) | LINESTRING(2364525.80463652 6225299.81256591,2364531.55284665 6225300.04790424)
1293421 | LINESTRING(2534992.94669856 6410684.25323086,2534993.89842913 6410680.56742247,2535000.88471946 6410667.94019167,2535003.34108937 6410665.86756757) | LINESTRING(2534991.9568963 6410685.40883111,2534993.89842913 6410680.56742247,2535000.8777867 6410667.93450725,2535003.34108937 6410665.86756757) | MULTILINESTRING((2534992.94669856 6410684.25323086,2534993.89842913 6410680.56742247),(2534993.89842913 6410680.56742247,2535000.88471946 6410667.94019167,2535003.34108937 6410665.86756757))
1296427 | LINESTRING(2372334.94483932 6221098.08144496,2372365.6857686 6221023.22012393,2372401.25436624 6220940.12297336,2372413.02036877 6220910.1205795,2372425.57948011 6220872.09131972,2372437.75603308 6220841.43909717,2372452.89041539 6220813.38725232,2372475.05080873 6220786.8052118,2372494.23471134 6220766.86520306,2372513.81050301 6220738.07875282,2372531.16559 6220698.19901097,2372554.6509416 6220639.69398796) | LINESTRING(2372334.94113869 6221098.07891646,2372365.6857686 6221023.22012393,2372401.25436624 6220940.12297336,2372413.02036877 6220910.1205795,2372425.57948011 6220872.09131972,2372437.75603308 6220841.43909717,2372452.89041539 6220813.38725232,2372475.05080873 6220786.8052118,2372494.23471134 6220766.86520306,2372513.81050301 6220738.07875282,2372531.16559 6220698.19901097,2372554.6509416 6220639.69398796) | LINESTRING(2372334.94483932 6221098.08144496,2372365.6857686 6221023.22012393)
1292883 | LINESTRING(1914445.93051272 6244057.30408068,1914445.99575293 6244099.73856966,1914445.88378463 6244138.7506862,1914446.93815281 6244163.09615179,1914449.70003763 6244208.72637463,1914452.20066306 6244278.95771945,1914453.60026685 6244336.12385637,1914454.88790234 6244395.78451461,1914456.68872588 6244432.65812909,1914458.76947018 6244465.50724131,1914458.94675333 6244481.03904879,1914458.8627771 6244496.25911404,1914458.81612364 6244503.86915691,1914459.36663447 6244535.68402841,1914461.6433233 6244594.49579799,1914464.45186157 6244666.4734565,1914467.82957205 6244760.21964017,1914470.85271623 6244848.29806529,1914474.23042671 6244928.88035158,1914476.4511314 6244987.38306134,1914477.76675896 6245033.66964842,1914479.00774098 6245085.22861229,1914479.39963004 6245108.88234858,1914479.58624388 6245122.91305618,1914479.30632313 6245141.13883833,1914479.28766174 6245157.53640678,1914480.30470716 6245163.55972208,1914481.94690894 6245167.49968123,1914483.94367701 6245171.25539939,1914486.10839754 6245174.7701862,1914492.39728391 6245187.19950447,1914495.59771124 6245195.17865454,1914499.48860977 6245205.82225718,1914505.96410997 6245225.45130643,1914509.65906398 6245236.95947776,1914512.11303596 6245242.38759847,1914517.21692444 6245252.16672812,1914521.90093179 6245259.74910452,1914527.91922809 6245268.26688499,1914534.07748476 6245276.0051755,1914543.68809745 6245285.67096221,1914551.91776774 6245293.77775957,1914560.93121614 6245300.07045378,1914575.58040247 6245312.38657375) | LINESTRING(1914446.07522806 6244060.73605171,1914445.99575293 6244099.73856966,1914445.88378463 6244138.7506862,1914446.93815281 6244163.09615179,1914449.70003763 6244208.72637463,1914452.20066306 6244278.95771945,1914453.60026685 6244336.12385637,1914454.88790234 6244395.78451461,1914456.68872588 6244432.65812909,1914458.76947018 6244465.50724131,1914458.94675333 6244481.03904879,1914458.8627771 6244496.25911404,1914458.81612364 6244503.86915691,1914459.36663447 6244535.68402841,1914461.6433233 6244594.49579799,1914464.45186157 6244666.4734565,1914467.82957205 6244760.21964017,1914470.85271623 6244848.29806529,1914474.23042671 6244928.88035158,1914476.4511314 6244987.38306134,1914477.76675896 6245033.66964842,1914479.00774098 6245085.22861229,1914479.39963004 6245108.88234858,1914479.58624388 6245122.91305618,1914479.30632313 6245141.13883833,1914479.28766174 6245157.53640678,1914480.30470716 6245163.55972208,1914481.94690894 6245167.49968123,1914483.94367701 6245171.25539939,1914486.10839754 6245174.7701862,1914492.39728391 6245187.19950447,1914495.59771124 6245195.17865454,1914499.48860977 6245205.82225718,1914505.96410997 6245225.45130643,1914509.65906398 6245236.95947776,1914512.11303596 6245242.38759847,1914517.21692444 6245252.16672812,1914521.90093179 6245259.74910452,1914527.91922809 6245268.26688499,1914534.07748476 6245276.0051755,1914543.68809745 6245285.67096221,1914551.91776774 6245293.77775957,1914560.93121614 6245300.07045378,1914575.58040247 6245312.38657375) | LINESTRING(1914445.93051272 6244057.30408068,1914445.99575293 6244099.73856966)
1294887 | LINESTRING(1975156.9091236 6183702.61204615,1975149.53667562 6183696.4555133,1975113.11898501 6183678.10778023,1975046.7404426 6183639.54108669,1975029.06811209 6183622.71306203,1975001.90646787 6183587.49532201,1974995.34699145 6183556.68167764,1975004.52839231 6183551.03955666,1975017.41407786 6183549.15416046) | LINESTRING(1975164.96030938 6183704.70074977,1975149.53667562 6183696.4555133,1975113.11898501 6183678.10778023,1975046.7404426 6183639.54108669,1975029.06811209 6183622.71306203,1975001.90786462 6183587.50704865,1974995.35114661 6183556.68730738,1975004.5350046 6183551.04710535,1975017.41466968 6183549.16703884) | MULTILINESTRING((1975156.9091236 6183702.61204615,1975149.53667562 6183696.4555133),(1975029.06811209 6183622.71306203,1975001.90646787 6183587.49532201,1975000.13048072 6183579.15248591),(1975000.13048072 6183579.15248591,1974995.34699145 6183556.68167764,1975004.52839231 6183551.03955666,1975017.41407786 6183549.15416046))
1297034 | LINESTRING(1903113.12394672 6272922.24167436,1903283.41840516 6272853.03772817,1903334.69988802 6272823.6471955,1903393.97561948 6272781.41841819) | LINESTRING(1903113.12394672 6272922.24167436,1903283.41840516 6272853.03772817,1903334.69988802 6272823.6471955,1903394.22970254 6272780.40760872) | LINESTRING(1903334.69988802 6272823.6471955,1903393.97561948 6272781.41841819)
1298691 | LINESTRING(1909275.36482699 6129746.17331533,1909260.59434166 6129772.30530676,1909246.57031169 6129791.96377556,1909229.95234936 6129810.79735805,1909213.69828402 6129827.04432736,1909195.7833555 6129841.36181985,1909178.52157543 6129854.00150108,1909158.58188678 6129865.63449851,1909141.68400369 6129873.57626546,1909120.63396269 6129881.88157187,1909102.09387782 6129887.78197963,1909080.84789229 6129891.85074659,1909055.92561414 6129894.5213129,1909033.39875917 6129894.81213866,1909006.25834099 6129894.15778026,1908886.04170615 6129886.67740061,1908848.56964735 6129885.11141542,1908809.4273947 6129887.78197963) | LINESTRING(1909275.36482699 6129746.17331533,1909260.59434166 6129772.30530676,1909246.57031169 6129791.96377556,1909229.95234936 6129810.79735805,1909213.69828402 6129827.04432736,1909195.7833555 6129841.36181985,1909178.52157543 6129854.00150108,1909158.58188678 6129865.63449851,1909141.68400369 6129873.57626546,1909120.63396269 6129881.88157187,1909102.09387782 6129887.78197963,1909080.84789229 6129891.85074659,1909055.92561414 6129894.5213129,1909033.39199313 6129894.8009534,1909006.25834099 6129894.15778026,1908886.04170615 6129886.67740061,1908848.56964735 6129885.11141542,1908809.4273947 6129887.78197963) | LINESTRING(1909055.92561414 6129894.5213129,1909033.39875917 6129894.81213866,1909006.25834099 6129894.15778026)
1300597 | LINESTRING(2134206.74424288 6382783.33522648,2134176.52213171 6382800.37754412,2134137.53850082 6382816.46909651,2134055.24083784 6382846.24234776) | LINESTRING(2134206.74424288 6382783.33522648,2134176.52213171 6382800.37754412,2134137.53850082 6382816.46909651,2134047.89854344 6382847.98961284) | LINESTRING(2134137.53850082 6382816.46909651,2134055.24083784 6382846.24234776)
1302472 | LINESTRING(1917737.90118915 6248775.20188545,1917781.25158386 6248795.78917159,1917822.73584019 6248817.26976109,1917845.39399062 6248823.19952998) | LINESTRING(1917737.90118915 6248775.20188545,1917781.25158386 6248795.78917159,1917822.73584019 6248817.26976109,1917833.0182627 6248822.33153169) | LINESTRING(1917822.73584019 6248817.26976109,1917845.39399062 6248823.19952998)
1303447 | LINESTRING(1852615.00866277 6386393.04742684,1852618.81558508 6386371.054414,1852599.16514787 6386345.17018197,1852569.55886237 6386268.55563028,1852504.66389999 6386204.33599714,1852454.20351802 6386160.42308017,1852418.82153422 6386116.51039361,1852336.23557993 6386065.39210845,1852235.30548531 6386039.82587715,1852153.39134084 6386045.07170404,1852053.11439465 6386101.42131558,1851905.70812352 6386175.49785273,1851835.78391819 6386186.26350521,1851699.94770504 6386172.12548252,1851646.14693537 6386171.4625381,1851610.57318011 6386161.11795647) | LINESTRING(1851610.57318011 6386980.72638245,1851673.4596477 6387060.0129662,1851656.91757137 6387105.9775032,1851658.3758567 6387162.91334969,1851683.54434863 6387246.81300813) | LINESTRING(1852615.00866277 6386393.04742684,1852618.81558508 6386371.054414,1852599.16514787 6386345.17018197,1852569.55886237 6386268.55563028,1852504.66389999 6386204.33599714,1852454.20351802 6386160.42308017,1852418.82153422 6386116.51039361,1852336.23557993 6386065.39210845,1852235.30548531 6386039.82587715,1852153.39134084 6386045.07170404,1852053.11439465 6386101.42131558,1851905.70812352 6386175.49785273,1851835.78391819 6386186.26350521,1851699.94770504 6386172.12548252,1851646.14693537 6386171.4625381,1851610.57318011 6386161.11795647)
1303448 | LINESTRING(1851610.57318011 6386980.72638245,1851673.4596477 6387060.0129662,1851656.91757137 6387105.9775032,1851658.3758567 6387162.91334969,1851683.54434863 6387246.81300813) | LINESTRING(1852615.00866277 6386393.04742684,1852618.81558508 6386371.054414,1852599.16514787 6386345.17018197,1852569.55886237 6386268.55563028,1852504.66389999 6386204.33599714,1852454.20351802 6386160.42308017,1852418.82153422 6386116.51039361,1852336.23557993 6386065.39210845,1852235.30548531 6386039.82587715,1852153.39134084 6386045.07170404,1852053.11439465 6386101.42131558,1851905.70812352 6386175.49785273,1851835.78391819 6386186.26350521,1851699.94770504 6386172.12548252,1851646.14693537 6386171.4625381,1851610.57318011 6386161.11795647) | LINESTRING(1851610.57318011 6386980.72638245,1851673.4596477 6387060.0129662,1851656.91757137 6387105.9775032,1851658.3758567 6387162.91334969,1851683.54434863 6387246.81300813)
1303672 | LINESTRING(2087738.42898399 6309652.23947293,2087739.22661398 6309652.97517781) | LINESTRING(2087738.07893888 6309649.47630942,2087739.22661398 6309652.97517781) | LINESTRING(2087738.42898399 6309652.23947293,2087739.22661398 6309652.97517781)
1292061 | LINESTRING(2376633.46028186 6323408.1744459,2376626.45293222 6323346.60832749,2376663.65889856 6323233.67223666,2376775.98660111 6322890.99872174,2376789.7680331 6322862.77782789,2376799.04274088 6322825.31699032,2376765.04169948 6322800.85811419,2376600.14971166 6322685.601981) | LINESTRING(2376633.46028186 6323408.1744459,2376626.45293222 6323346.60832749,2376672.6118652 6323186.50133708,2376775.98660111 6322890.99872174,2376789.7680331 6322862.77782789,2376799.04274088 6322825.31699032,2376765.04169948 6322800.85811419,2376600.14971166 6322685.601981) | LINESTRING(2376626.45293222 6323346.60832749,2376663.65889856 6323233.67223666,2376775.98660111 6322890.99872174)
1294865 | LINESTRING(1975164.96030938 6183704.70074977,1975149.53667562 6183696.4555133,1975113.11898501 6183678.10778023,1975046.7404426 6183639.54108669,1975029.06811209 6183622.71306203,1975001.90786462 6183587.50704865,1974995.35114661 6183556.68730738,1975004.5350046 6183551.04710535,1975017.41466968 6183549.16703884) | LINESTRING(1975156.9091236 6183702.61204615,1975149.53667562 6183696.4555133,1975113.11898501 6183678.10778023,1975046.7404426 6183639.54108669,1975029.06811209 6183622.71306203,1975001.90646787 6183587.49532201,1974995.34699145 6183556.68167764,1975004.52839231 6183551.03955666,1975017.41407786 6183549.15416046) | MULTILINESTRING((1975164.96030938 6183704.70074977,1975149.53667562 6183696.4555133),(1975029.06811209 6183622.71306203,1975001.90786462 6183587.50704865,1975000.13048072 6183579.15248591),(1975000.13048072 6183579.15248591,1974995.35114661 6183556.68730738,1975004.5350046 6183551.04710535,1975017.41466968 6183549.16703884))
1295860 | LINESTRING(1930051.53135497 6167713.6130241,1930061.03831282 6167707.23073847,1930069.35297656 6167698.89490805) | LINESTRING(1930051.53135497 6167713.6130241,1930061.02999936 6167707.22299922,1930069.35297656 6167698.89490805) | LINESTRING(1930051.53135497 6167713.6130241,1930061.03831282 6167707.23073847,1930069.35297656 6167698.89490805)
1297528 | LINESTRING(1906783.14204448 6131559.27447154,1906775.59781299 6131591.21233631,1906752.44836631 6131684.77112813,1906736.7354811 6131748.24904295) | LINESTRING(1906782.85709132 6131560.20810122,1906775.59781299 6131591.21233631,1906752.44836631 6131684.77112813,1906736.7354811 6131748.24904295) | LINESTRING(1906783.14204448 6131559.27447154,1906775.59781299 6131591.21233631)
1298367 | LINESTRING(2534991.9568963 6410685.40883111,2534993.89842913 6410680.56742247,2535000.8777867 6410667.93450725,2535003.34108937 6410665.86756757) | LINESTRING(2534992.94669856 6410684.25323086,2534993.89842913 6410680.56742247,2535000.88471946 6410667.94019167,2535003.34108937 6410665.86756757) | MULTILINESTRING((2534991.9568963 6410685.40883111,2534993.89842913 6410680.56742247),(2534993.89842913 6410680.56742247,2535000.8777867 6410667.93450725,2535003.34108937 6410665.86756757))
1299523 | LINESTRING(2323844.70898332 6208148.65572171,2323812.48790294 6208155.44906881,2323750.34549468 6208163.01248921,2323674.54295342 6208171.05568619,2323633.02137433 6208174.61162834,2323595.83856698 6208187.17032481,2323529.83325226 6208212.11844203,2323458.86400943 6208244.30557245,2323430.97457124 6208256.69503962) | LINESTRING(2323847.84189467 6208148.64764054,2323812.48790294 6208155.44906881,2323750.34549468 6208163.01248921,2323674.54295342 6208171.05568619,2323633.02137433 6208174.61162834,2323595.83856698 6208187.17032481,2323529.83325226 6208212.11844203,2323458.86400943 6208244.30557245,2323430.97457124 6208256.69503962) | LINESTRING(2323844.70898332 6208148.65572171,2323812.48790294 6208155.44906881)
1300723 | LINESTRING(1907847.17826528 6211975.27913989,1907817.38822854 6211921.53840609,1907816.86570979 6211892.40075011,1907792.92315429 6211853.3671766,1907790.31989124 6211834.63394839,1907773.14208739 6211791.43615676,1907803.85872524 6211664.94976805,1907818.43326603 6211583.76513247,1907827.27876198 6211459.89335646,1907827.27876198 6211434.92158973) | LINESTRING(1907844.18597576 6211970.72254427,1907817.38822854 6211921.53840609,1907816.86570979 6211892.40075011,1907792.92315429 6211853.3671766,1907790.31989124 6211834.63394839,1907773.14208739 6211791.43615676,1907803.85872524 6211664.94976805,1907818.43326603 6211583.76513247,1907827.27876198 6211459.89335646,1907827.27876198 6211434.92158973) | LINESTRING(1907847.17826528 6211975.27913989,1907817.38822854 6211921.53840609)
1301550 | LINESTRING(2163331.51938453 6401553.04977376,2163383.84123656 6401449.02799872) | LINESTRING(2163331.51938453 6401553.04977376,2163383.56598413 6401447.15947884) | LINESTRING(2163331.51938453 6401553.04977376,2163383.84123656 6401449.02799872)
1302651 | LINESTRING(1914446.07522806 6244060.73605171,1914445.99575293 6244099.73856966,1914445.88378463 6244138.7506862,1914446.93815281 6244163.09615179,1914449.70003763 6244208.72637463,1914452.20066306 6244278.95771945,1914453.60026685 6244336.12385637,1914454.88790234 6244395.78451461,1914456.68872588 6244432.65812909,1914458.76947018 6244465.50724131,1914458.94675333 6244481.03904879,1914458.8627771 6244496.25911404,1914458.81612364 6244503.86915691,1914459.36663447 6244535.68402841,1914461.6433233 6244594.49579799,1914464.45186157 6244666.4734565,1914467.82957205 6244760.21964017,1914470.85271623 6244848.29806529,1914474.23042671 6244928.88035158,1914476.4511314 6244987.38306134,1914477.76675896 6245033.66964842,1914479.00774098 6245085.22861229,1914479.39963004 6245108.88234858,1914479.58624388 6245122.91305618,1914479.30632313 6245141.13883833,1914479.28766174 6245157.53640678,1914480.30470716 6245163.55972208,1914481.94690894 6245167.49968123,1914483.94367701 6245171.25539939,1914486.10839754 6245174.7701862,1914492.39728391 6245187.19950447,1914495.59771124 6245195.17865454,1914499.48860977 6245205.82225718,1914505.96410997 6245225.45130643,1914509.65906398 6245236.95947776,1914512.11303596 6245242.38759847,1914517.21692444 6245252.16672812,1914521.90093179 6245259.74910452,1914527.91922809 6245268.26688499,1914534.07748476 6245276.0051755,1914543.68809745 6245285.67096221,1914551.91776774 6245293.77775957,1914560.93121614 6245300.07045378,1914575.58040247 6245312.38657375) | LINESTRING(1914445.93051272 6244057.30408068,1914445.99575293 6244099.73856966,1914445.88378463 6244138.7506862,1914446.93815281 6244163.09615179,1914449.70003763 6244208.72637463,1914452.20066306 6244278.95771945,1914453.60026685 6244336.12385637,1914454.88790234 6244395.78451461,1914456.68872588 6244432.65812909,1914458.76947018 6244465.50724131,1914458.94675333 6244481.03904879,1914458.8627771 6244496.25911404,1914458.81612364 6244503.86915691,1914459.36663447 6244535.68402841,1914461.6433233 6244594.49579799,1914464.45186157 6244666.4734565,1914467.82957205 6244760.21964017,1914470.85271623 6244848.29806529,1914474.23042671 6244928.88035158,1914476.4511314 6244987.38306134,1914477.76675896 6245033.66964842,1914479.00774098 6245085.22861229,1914479.39963004 6245108.88234858,1914479.58624388 6245122.91305618,1914479.30632313 6245141.13883833,1914479.28766174 6245157.53640678,1914480.30470716 6245163.55972208,1914481.94690894 6245167.49968123,1914483.94367701 6245171.25539939,1914486.10839754 6245174.7701862,1914492.39728391 6245187.19950447,1914495.59771124 6245195.17865454,1914499.48860977 6245205.82225718,1914505.96410997 6245225.45130643,1914509.65906398 6245236.95947776,1914512.11303596 6245242.38759847,1914517.21692444 6245252.16672812,1914521.90093179 6245259.74910452,1914527.91922809 6245268.26688499,1914534.07748476 6245276.0051755,1914543.68809745 6245285.67096221,1914551.91776774 6245293.77775957,1914560.93121614 6245300.07045378,1914575.58040247 6245312.38657375) | LINESTRING(1914446.07522806 6244060.73605171,1914445.99575293 6244099.73856966)
1303683 | LINESTRING(1899367.56959948 6148433.88898751,1899339.446894 6148433.72083928,1899304.5205418 6148429.60354461) | LINESTRING(1899367.56959948 6148433.88898751,1899339.446894 6148433.72083928,1899302.17077974 6148429.27892494) | LINESTRING(1899339.446894 6148433.72083928,1899304.5205418 6148429.60354461)
1304384 | LINESTRING(1851733.96740783 6125667.09284578,1851705.82022367 6125696.03095116) | LINESTRING(1851733.96740783 6125667.09284578,1851699.24790315 6125701.38787343) | LINESTRING(1851733.96740783 6125667.09284578,1851705.82022367 6125696.03095116)
(46 rows)Also, just for the illustration: This area was recently modified and it is rendered incorrectly. Each color strip represents a hiking relation and both strips should go along all the segments. Now only segment on the top is correct (https://www.openstreetmap.org/way/346949988) others are not (eg. https://www.openstreetmap.org/way/346950021).
EDIT: The problem with marked hiking trail relates to https://github.com/omniscale/imposm3/issues/185#issuecomment-487732954 and thus is offtopic for this issue.
ImreSamu
commented
5 years ago @zdila :
:smile:
Ouch, the osm_id is still missing from your select ....
martin=> select a.id, st_astext(a.geometry), st_astext(b.geometry), st_astext(ST_Difference(a.geometry, b.geometry)) from osm_roads a join osm_roads b on (a.id <> b.id and a.osm_id = b.osm_id and a.type = b.type);;Please add "a.osm_id" , "b.id" and the "order by" .... ( not tested )
select
a.osm_id --- <- please add this info
, a.id
, b.id -- <- maybe this is useful.
, st_astext(a.geometry)
, st_astext(b.geometry)
, st_astext(ST_Difference(a.geometry, b.geometry))
from osm_roads a join osm_roads b on (a.id <> b.id and a.osm_id = b.osm_id and a.type = b.type)
order by 1,2,3 -- <-- please add some ordering.
;If you can create some monitoring tool ; ( for example checking and reporting - the duplicated records - every hour - or every 10minutes ) - it would be helpful.
zdila
commented
5 years ago Oops, sorry. The result is:
osm_id | id | id | st_astext | st_astext | st_astext
-----------+---------+---------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
38422248 | 102027 | 1302472 | LINESTRING(1917737.90118915 6248775.20188545,1917781.25158386 6248795.78917159,1917822.73584019 6248817.26976109,1917833.0182627 6248822.33153169) | LINESTRING(1917737.90118915 6248775.20188545,1917781.25158386 6248795.78917159,1917822.73584019 6248817.26976109,1917845.39399062 6248823.19952998) | LINESTRING(1917822.73584019 6248817.26976109,1917833.0182627 6248822.33153169)
38422248 | 1302472 | 102027 | LINESTRING(1917737.90118915 6248775.20188545,1917781.25158386 6248795.78917159,1917822.73584019 6248817.26976109,1917845.39399062 6248823.19952998) | LINESTRING(1917737.90118915 6248775.20188545,1917781.25158386 6248795.78917159,1917822.73584019 6248817.26976109,1917833.0182627 6248822.33153169) | LINESTRING(1917822.73584019 6248817.26976109,1917845.39399062 6248823.19952998)
52797697 | 152009 | 1290717 | LINESTRING(2364525.35726721 6225301.15077423,2364531.55284665 6225300.04790424) | LINESTRING(2364525.80463652 6225299.81256591,2364531.55284665 6225300.04790424) | LINESTRING(2364525.35726721 6225301.15077423,2364531.55284665 6225300.04790424)
52797697 | 1290717 | 152009 | LINESTRING(2364525.80463652 6225299.81256591,2364531.55284665 6225300.04790424) | LINESTRING(2364525.35726721 6225301.15077423,2364531.55284665 6225300.04790424) | LINESTRING(2364525.80463652 6225299.81256591,2364531.55284665 6225300.04790424)
69876379 | 192052 | 1292061 | LINESTRING(2376633.46028186 6323408.1744459,2376626.45293222 6323346.60832749,2376672.6118652 6323186.50133708,2376775.98660111 6322890.99872174,2376789.7680331 6322862.77782789,2376799.04274088 6322825.31699032,2376765.04169948 6322800.85811419,2376600.14971166 6322685.601981) | LINESTRING(2376633.46028186 6323408.1744459,2376626.45293222 6323346.60832749,2376663.65889856 6323233.67223666,2376775.98660111 6322890.99872174,2376789.7680331 6322862.77782789,2376799.04274088 6322825.31699032,2376765.04169948 6322800.85811419,2376600.14971166 6322685.601981) | LINESTRING(2376626.45293222 6323346.60832749,2376672.6118652 6323186.50133708,2376775.98660111 6322890.99872174)
69876379 | 1292061 | 192052 | LINESTRING(2376633.46028186 6323408.1744459,2376626.45293222 6323346.60832749,2376663.65889856 6323233.67223666,2376775.98660111 6322890.99872174,2376789.7680331 6322862.77782789,2376799.04274088 6322825.31699032,2376765.04169948 6322800.85811419,2376600.14971166 6322685.601981) | LINESTRING(2376633.46028186 6323408.1744459,2376626.45293222 6323346.60832749,2376672.6118652 6323186.50133708,2376775.98660111 6322890.99872174,2376789.7680331 6322862.77782789,2376799.04274088 6322825.31699032,2376765.04169948 6322800.85811419,2376600.14971166 6322685.601981) | LINESTRING(2376626.45293222 6323346.60832749,2376663.65889856 6323233.67223666,2376775.98660111 6322890.99872174)
121410907 | 297785 | 1300723 | LINESTRING(1907844.18597576 6211970.72254427,1907817.38822854 6211921.53840609,1907816.86570979 6211892.40075011,1907792.92315429 6211853.3671766,1907790.31989124 6211834.63394839,1907773.14208739 6211791.43615676,1907803.85872524 6211664.94976805,1907818.43326603 6211583.76513247,1907827.27876198 6211459.89335646,1907827.27876198 6211434.92158973) | LINESTRING(1907847.17826528 6211975.27913989,1907817.38822854 6211921.53840609,1907816.86570979 6211892.40075011,1907792.92315429 6211853.3671766,1907790.31989124 6211834.63394839,1907773.14208739 6211791.43615676,1907803.85872524 6211664.94976805,1907818.43326603 6211583.76513247,1907827.27876198 6211459.89335646,1907827.27876198 6211434.92158973) | LINESTRING(1907844.18597576 6211970.72254427,1907817.38822854 6211921.53840609)
121410907 | 1300723 | 297785 | LINESTRING(1907847.17826528 6211975.27913989,1907817.38822854 6211921.53840609,1907816.86570979 6211892.40075011,1907792.92315429 6211853.3671766,1907790.31989124 6211834.63394839,1907773.14208739 6211791.43615676,1907803.85872524 6211664.94976805,1907818.43326603 6211583.76513247,1907827.27876198 6211459.89335646,1907827.27876198 6211434.92158973) | LINESTRING(1907844.18597576 6211970.72254427,1907817.38822854 6211921.53840609,1907816.86570979 6211892.40075011,1907792.92315429 6211853.3671766,1907790.31989124 6211834.63394839,1907773.14208739 6211791.43615676,1907803.85872524 6211664.94976805,1907818.43326603 6211583.76513247,1907827.27876198 6211459.89335646,1907827.27876198 6211434.92158973) | LINESTRING(1907847.17826528 6211975.27913989,1907817.38822854 6211921.53840609)
144397255 | 342913 | 1296427 | LINESTRING(2372334.94113869 6221098.07891646,2372365.6857686 6221023.22012393,2372401.25436624 6220940.12297336,2372413.02036877 6220910.1205795,2372425.57948011 6220872.09131972,2372437.75603308 6220841.43909717,2372452.89041539 6220813.38725232,2372475.05080873 6220786.8052118,2372494.23471134 6220766.86520306,2372513.81050301 6220738.07875282,2372531.16559 6220698.19901097,2372554.6509416 6220639.69398796) | LINESTRING(2372334.94483932 6221098.08144496,2372365.6857686 6221023.22012393,2372401.25436624 6220940.12297336,2372413.02036877 6220910.1205795,2372425.57948011 6220872.09131972,2372437.75603308 6220841.43909717,2372452.89041539 6220813.38725232,2372475.05080873 6220786.8052118,2372494.23471134 6220766.86520306,2372513.81050301 6220738.07875282,2372531.16559 6220698.19901097,2372554.6509416 6220639.69398796) | LINESTRING(2372334.94113869 6221098.07891646,2372365.6857686 6221023.22012393)
144397255 | 1296427 | 342913 | LINESTRING(2372334.94483932 6221098.08144496,2372365.6857686 6221023.22012393,2372401.25436624 6220940.12297336,2372413.02036877 6220910.1205795,2372425.57948011 6220872.09131972,2372437.75603308 6220841.43909717,2372452.89041539 6220813.38725232,2372475.05080873 6220786.8052118,2372494.23471134 6220766.86520306,2372513.81050301 6220738.07875282,2372531.16559 6220698.19901097,2372554.6509416 6220639.69398796) | LINESTRING(2372334.94113869 6221098.07891646,2372365.6857686 6221023.22012393,2372401.25436624 6220940.12297336,2372413.02036877 6220910.1205795,2372425.57948011 6220872.09131972,2372437.75603308 6220841.43909717,2372452.89041539 6220813.38725232,2372475.05080873 6220786.8052118,2372494.23471134 6220766.86520306,2372513.81050301 6220738.07875282,2372531.16559 6220698.19901097,2372554.6509416 6220639.69398796) | LINESTRING(2372334.94483932 6221098.08144496,2372365.6857686 6221023.22012393)
199022595 | 479231 | 1304384 | LINESTRING(1851733.96740783 6125667.09284578,1851699.24790315 6125701.38787343) | LINESTRING(1851733.96740783 6125667.09284578,1851705.82022367 6125696.03095116) | LINESTRING(1851733.96740783 6125667.09284578,1851699.24790315 6125701.38787343)
199022595 | 1304384 | 479231 | LINESTRING(1851733.96740783 6125667.09284578,1851705.82022367 6125696.03095116) | LINESTRING(1851733.96740783 6125667.09284578,1851699.24790315 6125701.38787343) | LINESTRING(1851733.96740783 6125667.09284578,1851705.82022367 6125696.03095116)
225172675 | 538688 | 1297528 | LINESTRING(1906782.85709132 6131560.20810122,1906775.59781299 6131591.21233631,1906752.44836631 6131684.77112813,1906736.7354811 6131748.24904295) | LINESTRING(1906783.14204448 6131559.27447154,1906775.59781299 6131591.21233631,1906752.44836631 6131684.77112813,1906736.7354811 6131748.24904295) | LINESTRING(1906782.85709132 6131560.20810122,1906775.59781299 6131591.21233631)
225172675 | 1297528 | 538688 | LINESTRING(1906783.14204448 6131559.27447154,1906775.59781299 6131591.21233631,1906752.44836631 6131684.77112813,1906736.7354811 6131748.24904295) | LINESTRING(1906782.85709132 6131560.20810122,1906775.59781299 6131591.21233631,1906752.44836631 6131684.77112813,1906736.7354811 6131748.24904295) | LINESTRING(1906783.14204448 6131559.27447154,1906775.59781299 6131591.21233631)
227317354 | 1292883 | 1302651 | LINESTRING(1914445.93051272 6244057.30408068,1914445.99575293 6244099.73856966,1914445.88378463 6244138.7506862,1914446.93815281 6244163.09615179,1914449.70003763 6244208.72637463,1914452.20066306 6244278.95771945,1914453.60026685 6244336.12385637,1914454.88790234 6244395.78451461,1914456.68872588 6244432.65812909,1914458.76947018 6244465.50724131,1914458.94675333 6244481.03904879,1914458.8627771 6244496.25911404,1914458.81612364 6244503.86915691,1914459.36663447 6244535.68402841,1914461.6433233 6244594.49579799,1914464.45186157 6244666.4734565,1914467.82957205 6244760.21964017,1914470.85271623 6244848.29806529,1914474.23042671 6244928.88035158,1914476.4511314 6244987.38306134,1914477.76675896 6245033.66964842,1914479.00774098 6245085.22861229,1914479.39963004 6245108.88234858,1914479.58624388 6245122.91305618,1914479.30632313 6245141.13883833,1914479.28766174 6245157.53640678,1914480.30470716 6245163.55972208,1914481.94690894 6245167.49968123,1914483.94367701 6245171.25539939,1914486.10839754 6245174.7701862,1914492.39728391 6245187.19950447,1914495.59771124 6245195.17865454,1914499.48860977 6245205.82225718,1914505.96410997 6245225.45130643,1914509.65906398 6245236.95947776,1914512.11303596 6245242.38759847,1914517.21692444 6245252.16672812,1914521.90093179 6245259.74910452,1914527.91922809 6245268.26688499,1914534.07748476 6245276.0051755,1914543.68809745 6245285.67096221,1914551.91776774 6245293.77775957,1914560.93121614 6245300.07045378,1914575.58040247 6245312.38657375) | LINESTRING(1914446.07522806 6244060.73605171,1914445.99575293 6244099.73856966,1914445.88378463 6244138.7506862,1914446.93815281 6244163.09615179,1914449.70003763 6244208.72637463,1914452.20066306 6244278.95771945,1914453.60026685 6244336.12385637,1914454.88790234 6244395.78451461,1914456.68872588 6244432.65812909,1914458.76947018 6244465.50724131,1914458.94675333 6244481.03904879,1914458.8627771 6244496.25911404,1914458.81612364 6244503.86915691,1914459.36663447 6244535.68402841,1914461.6433233 6244594.49579799,1914464.45186157 6244666.4734565,1914467.82957205 6244760.21964017,1914470.85271623 6244848.29806529,1914474.23042671 6244928.88035158,1914476.4511314 6244987.38306134,1914477.76675896 6245033.66964842,1914479.00774098 6245085.22861229,1914479.39963004 6245108.88234858,1914479.58624388 6245122.91305618,1914479.30632313 6245141.13883833,1914479.28766174 6245157.53640678,1914480.30470716 6245163.55972208,1914481.94690894 6245167.49968123,1914483.94367701 6245171.25539939,1914486.10839754 6245174.7701862,1914492.39728391 6245187.19950447,1914495.59771124 6245195.17865454,1914499.48860977 6245205.82225718,1914505.96410997 6245225.45130643,1914509.65906398 6245236.95947776,1914512.11303596 6245242.38759847,1914517.21692444 6245252.16672812,1914521.90093179 6245259.74910452,1914527.91922809 6245268.26688499,1914534.07748476 6245276.0051755,1914543.68809745 6245285.67096221,1914551.91776774 6245293.77775957,1914560.93121614 6245300.07045378,1914575.58040247 6245312.38657375) | LINESTRING(1914445.93051272 6244057.30408068,1914445.99575293 6244099.73856966)
227317354 | 1302651 | 1292883 | LINESTRING(1914446.07522806 6244060.73605171,1914445.99575293 6244099.73856966,1914445.88378463 6244138.7506862,1914446.93815281 6244163.09615179,1914449.70003763 6244208.72637463,1914452.20066306 6244278.95771945,1914453.60026685 6244336.12385637,1914454.88790234 6244395.78451461,1914456.68872588 6244432.65812909,1914458.76947018 6244465.50724131,1914458.94675333 6244481.03904879,1914458.8627771 6244496.25911404,1914458.81612364 6244503.86915691,1914459.36663447 6244535.68402841,1914461.6433233 6244594.49579799,1914464.45186157 6244666.4734565,1914467.82957205 6244760.21964017,1914470.85271623 6244848.29806529,1914474.23042671 6244928.88035158,1914476.4511314 6244987.38306134,1914477.76675896 6245033.66964842,1914479.00774098 6245085.22861229,1914479.39963004 6245108.88234858,1914479.58624388 6245122.91305618,1914479.30632313 6245141.13883833,1914479.28766174 6245157.53640678,1914480.30470716 6245163.55972208,1914481.94690894 6245167.49968123,1914483.94367701 6245171.25539939,1914486.10839754 6245174.7701862,1914492.39728391 6245187.19950447,1914495.59771124 6245195.17865454,1914499.48860977 6245205.82225718,1914505.96410997 6245225.45130643,1914509.65906398 6245236.95947776,1914512.11303596 6245242.38759847,1914517.21692444 6245252.16672812,1914521.90093179 6245259.74910452,1914527.91922809 6245268.26688499,1914534.07748476 6245276.0051755,1914543.68809745 6245285.67096221,1914551.91776774 6245293.77775957,1914560.93121614 6245300.07045378,1914575.58040247 6245312.38657375) | LINESTRING(1914445.93051272 6244057.30408068,1914445.99575293 6244099.73856966,1914445.88378463 6244138.7506862,1914446.93815281 6244163.09615179,1914449.70003763 6244208.72637463,1914452.20066306 6244278.95771945,1914453.60026685 6244336.12385637,1914454.88790234 6244395.78451461,1914456.68872588 6244432.65812909,1914458.76947018 6244465.50724131,1914458.94675333 6244481.03904879,1914458.8627771 6244496.25911404,1914458.81612364 6244503.86915691,1914459.36663447 6244535.68402841,1914461.6433233 6244594.49579799,1914464.45186157 6244666.4734565,1914467.82957205 6244760.21964017,1914470.85271623 6244848.29806529,1914474.23042671 6244928.88035158,1914476.4511314 6244987.38306134,1914477.76675896 6245033.66964842,1914479.00774098 6245085.22861229,1914479.39963004 6245108.88234858,1914479.58624388 6245122.91305618,1914479.30632313 6245141.13883833,1914479.28766174 6245157.53640678,1914480.30470716 6245163.55972208,1914481.94690894 6245167.49968123,1914483.94367701 6245171.25539939,1914486.10839754 6245174.7701862,1914492.39728391 6245187.19950447,1914495.59771124 6245195.17865454,1914499.48860977 6245205.82225718,1914505.96410997 6245225.45130643,1914509.65906398 6245236.95947776,1914512.11303596 6245242.38759847,1914517.21692444 6245252.16672812,1914521.90093179 6245259.74910452,1914527.91922809 6245268.26688499,1914534.07748476 6245276.0051755,1914543.68809745 6245285.67096221,1914551.91776774 6245293.77775957,1914560.93121614 6245300.07045378,1914575.58040247 6245312.38657375) | LINESTRING(1914446.07522806 6244060.73605171,1914445.99575293 6244099.73856966)
234331716 | 564885 | 1288800 | LINESTRING(2135277.3571658 6093726.79345696,2135233.46559095 6093612.10882204) | LINESTRING(2135270.14836451 6093696.38446885,2135233.46559095 6093612.10882204) | LINESTRING(2135277.3571658 6093726.79345696,2135233.46559095 6093612.10882204)
234331716 | 1288800 | 564885 | LINESTRING(2135270.14836451 6093696.38446885,2135233.46559095 6093612.10882204) | LINESTRING(2135277.3571658 6093726.79345696,2135233.46559095 6093612.10882204) | LINESTRING(2135270.14836451 6093696.38446885,2135233.46559095 6093612.10882204)
281000171 | 669996 | 1300597 | LINESTRING(2134206.74424288 6382783.33522648,2134176.52213171 6382800.37754412,2134137.53850082 6382816.46909651,2134047.89854344 6382847.98961284) | LINESTRING(2134206.74424288 6382783.33522648,2134176.52213171 6382800.37754412,2134137.53850082 6382816.46909651,2134055.24083784 6382846.24234776) | LINESTRING(2134137.53850082 6382816.46909651,2134047.89854344 6382847.98961284)
281000171 | 1300597 | 669996 | LINESTRING(2134206.74424288 6382783.33522648,2134176.52213171 6382800.37754412,2134137.53850082 6382816.46909651,2134055.24083784 6382846.24234776) | LINESTRING(2134206.74424288 6382783.33522648,2134176.52213171 6382800.37754412,2134137.53850082 6382816.46909651,2134047.89854344 6382847.98961284) | LINESTRING(2134137.53850082 6382816.46909651,2134055.24083784 6382846.24234776)
290932857 | 1294865 | 1294887 | LINESTRING(1975164.96030938 6183704.70074977,1975149.53667562 6183696.4555133,1975113.11898501 6183678.10778023,1975046.7404426 6183639.54108669,1975029.06811209 6183622.71306203,1975001.90786462 6183587.50704865,1974995.35114661 6183556.68730738,1975004.5350046 6183551.04710535,1975017.41466968 6183549.16703884) | LINESTRING(1975156.9091236 6183702.61204615,1975149.53667562 6183696.4555133,1975113.11898501 6183678.10778023,1975046.7404426 6183639.54108669,1975029.06811209 6183622.71306203,1975001.90646787 6183587.49532201,1974995.34699145 6183556.68167764,1975004.52839231 6183551.03955666,1975017.41407786 6183549.15416046) | MULTILINESTRING((1975164.96030938 6183704.70074977,1975149.53667562 6183696.4555133),(1975029.06811209 6183622.71306203,1975001.90786462 6183587.50704865,1975000.13048072 6183579.15248591),(1975000.13048072 6183579.15248591,1974995.35114661 6183556.68730738,1975004.5350046 6183551.04710535,1975017.41466968 6183549.16703884))
290932857 | 1294887 | 1294865 | LINESTRING(1975156.9091236 6183702.61204615,1975149.53667562 6183696.4555133,1975113.11898501 6183678.10778023,1975046.7404426 6183639.54108669,1975029.06811209 6183622.71306203,1975001.90646787 6183587.49532201,1974995.34699145 6183556.68167764,1975004.52839231 6183551.03955666,1975017.41407786 6183549.15416046) | LINESTRING(1975164.96030938 6183704.70074977,1975149.53667562 6183696.4555133,1975113.11898501 6183678.10778023,1975046.7404426 6183639.54108669,1975029.06811209 6183622.71306203,1975001.90786462 6183587.50704865,1974995.35114661 6183556.68730738,1975004.5350046 6183551.04710535,1975017.41466968 6183549.16703884) | MULTILINESTRING((1975156.9091236 6183702.61204615,1975149.53667562 6183696.4555133),(1975029.06811209 6183622.71306203,1975001.90646787 6183587.49532201,1975000.13048072 6183579.15248591),(1975000.13048072 6183579.15248591,1974995.34699145 6183556.68167764,1975004.52839231 6183551.03955666,1975017.41407786 6183549.15416046))
298390287 | 721047 | 1303683 | LINESTRING(1899367.56959948 6148433.88898751,1899339.446894 6148433.72083928,1899302.17077974 6148429.27892494) | LINESTRING(1899367.56959948 6148433.88898751,1899339.446894 6148433.72083928,1899304.5205418 6148429.60354461) | LINESTRING(1899339.446894 6148433.72083928,1899302.17077974 6148429.27892494)
298390287 | 1303683 | 721047 | LINESTRING(1899367.56959948 6148433.88898751,1899339.446894 6148433.72083928,1899304.5205418 6148429.60354461) | LINESTRING(1899367.56959948 6148433.88898751,1899339.446894 6148433.72083928,1899302.17077974 6148429.27892494) | LINESTRING(1899339.446894 6148433.72083928,1899304.5205418 6148429.60354461)
333585444 | 819403 | 1299523 | LINESTRING(2323847.84189467 6208148.64764054,2323812.48790294 6208155.44906881,2323750.34549468 6208163.01248921,2323674.54295342 6208171.05568619,2323633.02137433 6208174.61162834,2323595.83856698 6208187.17032481,2323529.83325226 6208212.11844203,2323458.86400943 6208244.30557245,2323430.97457124 6208256.69503962) | LINESTRING(2323844.70898332 6208148.65572171,2323812.48790294 6208155.44906881,2323750.34549468 6208163.01248921,2323674.54295342 6208171.05568619,2323633.02137433 6208174.61162834,2323595.83856698 6208187.17032481,2323529.83325226 6208212.11844203,2323458.86400943 6208244.30557245,2323430.97457124 6208256.69503962) | LINESTRING(2323847.84189467 6208148.64764054,2323812.48790294 6208155.44906881)
333585444 | 1299523 | 819403 | LINESTRING(2323844.70898332 6208148.65572171,2323812.48790294 6208155.44906881,2323750.34549468 6208163.01248921,2323674.54295342 6208171.05568619,2323633.02137433 6208174.61162834,2323595.83856698 6208187.17032481,2323529.83325226 6208212.11844203,2323458.86400943 6208244.30557245,2323430.97457124 6208256.69503962) | LINESTRING(2323847.84189467 6208148.64764054,2323812.48790294 6208155.44906881,2323750.34549468 6208163.01248921,2323674.54295342 6208171.05568619,2323633.02137433 6208174.61162834,2323595.83856698 6208187.17032481,2323529.83325226 6208212.11844203,2323458.86400943 6208244.30557245,2323430.97457124 6208256.69503962) | LINESTRING(2323844.70898332 6208148.65572171,2323812.48790294 6208155.44906881)
370495191 | 1303447 | 1303448 | LINESTRING(1852615.00866277 6386393.04742684,1852618.81558508 6386371.054414,1852599.16514787 6386345.17018197,1852569.55886237 6386268.55563028,1852504.66389999 6386204.33599714,1852454.20351802 6386160.42308017,1852418.82153422 6386116.51039361,1852336.23557993 6386065.39210845,1852235.30548531 6386039.82587715,1852153.39134084 6386045.07170404,1852053.11439465 6386101.42131558,1851905.70812352 6386175.49785273,1851835.78391819 6386186.26350521,1851699.94770504 6386172.12548252,1851646.14693537 6386171.4625381,1851610.57318011 6386161.11795647) | LINESTRING(1851610.57318011 6386980.72638245,1851673.4596477 6387060.0129662,1851656.91757137 6387105.9775032,1851658.3758567 6387162.91334969,1851683.54434863 6387246.81300813) | LINESTRING(1852615.00866277 6386393.04742684,1852618.81558508 6386371.054414,1852599.16514787 6386345.17018197,1852569.55886237 6386268.55563028,1852504.66389999 6386204.33599714,1852454.20351802 6386160.42308017,1852418.82153422 6386116.51039361,1852336.23557993 6386065.39210845,1852235.30548531 6386039.82587715,1852153.39134084 6386045.07170404,1852053.11439465 6386101.42131558,1851905.70812352 6386175.49785273,1851835.78391819 6386186.26350521,1851699.94770504 6386172.12548252,1851646.14693537 6386171.4625381,1851610.57318011 6386161.11795647)
370495191 | 1303448 | 1303447 | LINESTRING(1851610.57318011 6386980.72638245,1851673.4596477 6387060.0129662,1851656.91757137 6387105.9775032,1851658.3758567 6387162.91334969,1851683.54434863 6387246.81300813) | LINESTRING(1852615.00866277 6386393.04742684,1852618.81558508 6386371.054414,1852599.16514787 6386345.17018197,1852569.55886237 6386268.55563028,1852504.66389999 6386204.33599714,1852454.20351802 6386160.42308017,1852418.82153422 6386116.51039361,1852336.23557993 6386065.39210845,1852235.30548531 6386039.82587715,1852153.39134084 6386045.07170404,1852053.11439465 6386101.42131558,1851905.70812352 6386175.49785273,1851835.78391819 6386186.26350521,1851699.94770504 6386172.12548252,1851646.14693537 6386171.4625381,1851610.57318011 6386161.11795647) | LINESTRING(1851610.57318011 6386980.72638245,1851673.4596477 6387060.0129662,1851656.91757137 6387105.9775032,1851658.3758567 6387162.91334969,1851683.54434863 6387246.81300813)
384471473 | 929802 | 1298691 | LINESTRING(1909275.36482699 6129746.17331533,1909260.59434166 6129772.30530676,1909246.57031169 6129791.96377556,1909229.95234936 6129810.79735805,1909213.69828402 6129827.04432736,1909195.7833555 6129841.36181985,1909178.52157543 6129854.00150108,1909158.58188678 6129865.63449851,1909141.68400369 6129873.57626546,1909120.63396269 6129881.88157187,1909102.09387782 6129887.78197963,1909080.84789229 6129891.85074659,1909055.92561414 6129894.5213129,1909033.39199313 6129894.8009534,1909006.25834099 6129894.15778026,1908886.04170615 6129886.67740061,1908848.56964735 6129885.11141542,1908809.4273947 6129887.78197963) | LINESTRING(1909275.36482699 6129746.17331533,1909260.59434166 6129772.30530676,1909246.57031169 6129791.96377556,1909229.95234936 6129810.79735805,1909213.69828402 6129827.04432736,1909195.7833555 6129841.36181985,1909178.52157543 6129854.00150108,1909158.58188678 6129865.63449851,1909141.68400369 6129873.57626546,1909120.63396269 6129881.88157187,1909102.09387782 6129887.78197963,1909080.84789229 6129891.85074659,1909055.92561414 6129894.5213129,1909033.39875917 6129894.81213866,1909006.25834099 6129894.15778026,1908886.04170615 6129886.67740061,1908848.56964735 6129885.11141542,1908809.4273947 6129887.78197963) | LINESTRING(1909055.92561414 6129894.5213129,1909033.39199313 6129894.8009534,1909006.25834099 6129894.15778026)
384471473 | 1298691 | 929802 | LINESTRING(1909275.36482699 6129746.17331533,1909260.59434166 6129772.30530676,1909246.57031169 6129791.96377556,1909229.95234936 6129810.79735805,1909213.69828402 6129827.04432736,1909195.7833555 6129841.36181985,1909178.52157543 6129854.00150108,1909158.58188678 6129865.63449851,1909141.68400369 6129873.57626546,1909120.63396269 6129881.88157187,1909102.09387782 6129887.78197963,1909080.84789229 6129891.85074659,1909055.92561414 6129894.5213129,1909033.39875917 6129894.81213866,1909006.25834099 6129894.15778026,1908886.04170615 6129886.67740061,1908848.56964735 6129885.11141542,1908809.4273947 6129887.78197963) | LINESTRING(1909275.36482699 6129746.17331533,1909260.59434166 6129772.30530676,1909246.57031169 6129791.96377556,1909229.95234936 6129810.79735805,1909213.69828402 6129827.04432736,1909195.7833555 6129841.36181985,1909178.52157543 6129854.00150108,1909158.58188678 6129865.63449851,1909141.68400369 6129873.57626546,1909120.63396269 6129881.88157187,1909102.09387782 6129887.78197963,1909080.84789229 6129891.85074659,1909055.92561414 6129894.5213129,1909033.39199313 6129894.8009534,1909006.25834099 6129894.15778026,1908886.04170615 6129886.67740061,1908848.56964735 6129885.11141542,1908809.4273947 6129887.78197963) | LINESTRING(1909055.92561414 6129894.5213129,1909033.39875917 6129894.81213866,1909006.25834099 6129894.15778026)
392152867 | 947332 | 1292846 | LINESTRING(1852088.30976462 6169238.97161151,1852085.30528182 6169231.18983931) | LINESTRING(1852088.30976462 6169238.97161151,1852082.87047094 6169224.67862775) | LINESTRING(1852088.30976462 6169238.97161151,1852085.30528182 6169231.18983931)
392152867 | 1292846 | 947332 | LINESTRING(1852088.30976462 6169238.97161151,1852082.87047094 6169224.67862775) | LINESTRING(1852088.30976462 6169238.97161151,1852085.30528182 6169231.18983931) | LINESTRING(1852088.30976462 6169238.97161151,1852082.87047094 6169224.67862775)
394999591 | 951790 | 1286731 | LINESTRING(2132512.97172862 6302727.63240327,2132497.53876417 6302703.6456301,2132527.09839621 6302646.7682837,2132548.24174412 6302613.07869676,2132572.32426 6302566.16178348) | LINESTRING(2132496.25589708 6302709.72466023,2132497.53876417 6302703.6456301,2132527.09839621 6302646.7682837,2132548.24174412 6302613.07869676,2132572.32426 6302566.16178348) | LINESTRING(2132512.97172862 6302727.63240327,2132497.53876417 6302703.6456301)
394999591 | 1286731 | 951790 | LINESTRING(2132496.25589708 6302709.72466023,2132497.53876417 6302703.6456301,2132527.09839621 6302646.7682837,2132548.24174412 6302613.07869676,2132572.32426 6302566.16178348) | LINESTRING(2132512.97172862 6302727.63240327,2132497.53876417 6302703.6456301,2132527.09839621 6302646.7682837,2132548.24174412 6302613.07869676,2132572.32426 6302566.16178348) | LINESTRING(2132496.25589708 6302709.72466023,2132497.53876417 6302703.6456301)
398051367 | 957841 | 1301550 | LINESTRING(2163331.51938453 6401553.04977376,2163383.56598413 6401447.15947884) | LINESTRING(2163331.51938453 6401553.04977376,2163383.84123656 6401449.02799872) | LINESTRING(2163331.51938453 6401553.04977376,2163383.56598413 6401447.15947884)
398051367 | 1301550 | 957841 | LINESTRING(2163331.51938453 6401553.04977376,2163383.84123656 6401449.02799872) | LINESTRING(2163331.51938453 6401553.04977376,2163383.56598413 6401447.15947884) | LINESTRING(2163331.51938453 6401553.04977376,2163383.84123656 6401449.02799872)
442029256 | 1023666 | 1286690 | LINESTRING(2118848.89185816 6042035.08062692,2118836.71530519 6042068.53173885,2118756.77926741 6042241.89278365) | LINESTRING(2118848.89185816 6042035.08062692,2118836.71530519 6042068.53173885,2118756.48076668 6042242.63661914) | LINESTRING(2118836.71530519 6042068.53173885,2118756.77926741 6042241.89278365)
442029256 | 1286690 | 1023666 | LINESTRING(2118848.89185816 6042035.08062692,2118836.71530519 6042068.53173885,2118756.48076668 6042242.63661914) | LINESTRING(2118848.89185816 6042035.08062692,2118836.71530519 6042068.53173885,2118756.77926741 6042241.89278365) | LINESTRING(2118836.71530519 6042068.53173885,2118756.48076668 6042242.63661914)
442914625 | 1293421 | 1298367 | LINESTRING(2534992.94669856 6410684.25323086,2534993.89842913 6410680.56742247,2535000.88471946 6410667.94019167,2535003.34108937 6410665.86756757) | LINESTRING(2534991.9568963 6410685.40883111,2534993.89842913 6410680.56742247,2535000.8777867 6410667.93450725,2535003.34108937 6410665.86756757) | MULTILINESTRING((2534992.94669856 6410684.25323086,2534993.89842913 6410680.56742247),(2534993.89842913 6410680.56742247,2535000.88471946 6410667.94019167,2535003.34108937 6410665.86756757))
442914625 | 1298367 | 1293421 | LINESTRING(2534991.9568963 6410685.40883111,2534993.89842913 6410680.56742247,2535000.8777867 6410667.93450725,2535003.34108937 6410665.86756757) | LINESTRING(2534992.94669856 6410684.25323086,2534993.89842913 6410680.56742247,2535000.88471946 6410667.94019167,2535003.34108937 6410665.86756757) | MULTILINESTRING((2534991.9568963 6410685.40883111,2534993.89842913 6410680.56742247),(2534993.89842913 6410680.56742247,2535000.8777867 6410667.93450725,2535003.34108937 6410665.86756757))
494286167 | 1086627 | 1295860 | LINESTRING(1930051.53135497 6167713.6130241,1930061.02999936 6167707.22299922,1930069.35297656 6167698.89490805) | LINESTRING(1930051.53135497 6167713.6130241,1930061.03831282 6167707.23073847,1930069.35297656 6167698.89490805) | LINESTRING(1930051.53135497 6167713.6130241,1930061.02999936 6167707.22299922,1930069.35297656 6167698.89490805)
494286167 | 1295860 | 1086627 | LINESTRING(1930051.53135497 6167713.6130241,1930061.03831282 6167707.23073847,1930069.35297656 6167698.89490805) | LINESTRING(1930051.53135497 6167713.6130241,1930061.02999936 6167707.22299922,1930069.35297656 6167698.89490805) | LINESTRING(1930051.53135497 6167713.6130241,1930061.03831282 6167707.23073847,1930069.35297656 6167698.89490805)
608946287 | 1229112 | 1303672 | LINESTRING(2087738.07893888 6309649.47630942,2087739.22661398 6309652.97517781) | LINESTRING(2087738.42898399 6309652.23947293,2087739.22661398 6309652.97517781) | LINESTRING(2087738.07893888 6309649.47630942,2087739.22661398 6309652.97517781)
608946287 | 1303672 | 1229112 | LINESTRING(2087738.42898399 6309652.23947293,2087739.22661398 6309652.97517781) | LINESTRING(2087738.07893888 6309649.47630942,2087739.22661398 6309652.97517781) | LINESTRING(2087738.42898399 6309652.23947293,2087739.22661398 6309652.97517781)
649189429 | 1269552 | 1297034 | LINESTRING(1903113.12394672 6272922.24167436,1903283.41840516 6272853.03772817,1903334.69988802 6272823.6471955,1903394.22970254 6272780.40760872) | LINESTRING(1903113.12394672 6272922.24167436,1903283.41840516 6272853.03772817,1903334.69988802 6272823.6471955,1903393.97561948 6272781.41841819) | LINESTRING(1903334.69988802 6272823.6471955,1903394.22970254 6272780.40760872)
649189429 | 1297034 | 1269552 | LINESTRING(1903113.12394672 6272922.24167436,1903283.41840516 6272853.03772817,1903334.69988802 6272823.6471955,1903393.97561948 6272781.41841819) | LINESTRING(1903113.12394672 6272922.24167436,1903283.41840516 6272853.03772817,1903334.69988802 6272823.6471955,1903394.22970254 6272780.40760872) | LINESTRING(1903334.69988802 6272823.6471955,1903393.97561948 6272781.41841819)
(46 rows)I'll also create that script you ask...
ImreSamu
commented
5 years ago @zdila :
As I see - some nodes ( and some related realations/ways ) is changed in this cases ..
from your example:
398051367 | 957841 | 1301550 | LINESTRING(2163331.51938453 6401553.04977376,2163383.56598413 6401447.15947884) | LINESTRING(2163331.51938453 6401553.04977376,2163383.84123656 6401449.02799872) | LINESTRING(2163331.51938453 6401553.04977376,2163383.56598413 6401447.15947884)
398051367 | 1301550 | 957841 | LINESTRING(2163331.51938453 6401553.04977376,2163383.84123656 6401449.02799872)so maybe from the 3ways history ( w398051367, w313940866, w398030547) - you can create a minimal example.
zdila
commented
5 years ago If you can create some monitoring tool
I've already set it up but so far (since sunday) no new duplicate appeared. Let us wait some more time.
zdila
commented
5 years ago Unfortunately I found no time to create a testcase and I can't tell when I will be able to do it. At least I have the logs from that monitoring tool if you are interested.
zdila
commented
5 years ago I've created a script which can find osmc causing the problem:
#!/bin/bash
while echo 'select count(1) from osm_roads a join osm_roads b on (a.id <> b.id and a.osm_id = b.osm_id and a.type = b.type);' | psql -qtAX | grep -q '^0$'; do
IMPOSM3_SINGLE_DIFF=1 ~/go/bin/imposm run -connection postgis://martin:***@localhost/martin -mapping mapping.yaml -limitto limit.geojson -cachedir ./cache -diffdir ./diff -expiretiles-zoom 15 -expiretiles-dir ./expires
done
echo 'select a.osm_id, b.osm_id, a.id, st_astext(ST_Difference(a.geometry, b.geometry)) from osm_roads a join osm_roads b on (a.id <> b.id and a.osm_id = b.osm_id and a.type = b.type);' | psqlI've imported http://download.geofabrik.de/europe/slovakia-140101.osm.pbf, set last state to https://planet.openstreetmap.org/replication/minute/002/959/939.state.txt and ran the script. It terminated after applying https://planet.openstreetmap.org/replication/minute/002/963/959.osc.gz which duplicates way 244548972.
Log from last imposm3 run:
[2019-04-13T19:19:59+02:00] 0:00:00 [step] Starting: Reading limitto geometries
[2019-04-13T19:19:59+02:00] 0:00:00 [step] Finished: Reading limitto geometries in 12.626875ms
[2019-04-13T19:19:59+02:00] 0:00:00 [info] Starting replication from https://planet.openstreetmap.org/replication/minute/ with 1m0s interval
[2019-04-13T19:19:59+02:00] 0:00:00 [info] Importing #2963959 including changes till 2018-05-10 05:57:02 +0000 UTC (8123h22m57s behind)
[2019-04-13T19:19:59+02:00] 0:00:00 [step] Starting: Importing #2963959
[2019-04-13T19:19:59+02:00] 0:00:00 [step] Starting: Processing diff/002/963/959.osc.gz
[2019-04-13T19:19:59+02:00] 0:00:00 [step] Starting: Parsing changes, updating cache and removing elements
[2019-04-13T19:19:59+02:00] 0:00:00 [step] Finished: Parsing changes, updating cache and removing elements in 71.205142ms
[2019-04-13T19:19:59+02:00] 0:00:00 [step] Starting: Importing added/modified elements
[2019-04-13T19:19:59+02:00] 0:00:00 [progress] 0s C: 0/s (1326) N: 0/s (2) W: 0/s (303) R: 0/s (12)
[2019-04-13T19:19:59+02:00] 0:00:00 [step] Starting: Updating generalized tables
[2019-04-13T19:19:59+02:00] 0:00:00 [step] Finished: Updating generalized tables in 4.447396ms
[2019-04-13T19:19:59+02:00] 0:00:00 [step] Finished: Importing added/modified elements in 86.213831ms
[2019-04-13T19:19:59+02:00] 0:00:00 [progress] 0s C: 0/s (0) N: 0/s (4) W: 0/s (246) R: 0/s (8)
[2019-04-13T19:19:59+02:00] 0:00:00 [step] Finished: Processing diff/002/963/959.osc.gz in 176.989569ms
[2019-04-13T19:19:59+02:00] 0:00:00 [step] Finished: Importing #2963959 in 178.078869msMapping file: https://github.com/FreemapSlovakia/freemap-mapnik/blob/58fce54be0778264f63ee10ae9b9e0c7a65516d6/mapping.yaml
Is it sufficient for you to replicate it?
zdila
commented
5 years ago Could be related or not, after modifying relation in OSM it's member has now slightly different geometry in comparison to the same member of other relation:
martin=> select osm_id, member, role, type, st_astext(geometry) from osm_route_members where member = 686673945;
osm_id | member | role | type | st_astext
----------+-----------+------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-192031 | 686673945 | | 1 | LINESTRING(2028148.93054565 6260759.39576692,2028103.1914938 6260752.14026574,2027988.87185626 6260744.51560681,2027954.80550002 6260735.35750602,2027931.5316176 6260735.93001159)
-541000 | 686673945 | | 1 | LINESTRING(2028148.93054565 6260759.39576692,2028103.1914938 6260752.14026574,2027988.87185626 6260744.51560681,2027954.80550002 6260735.35750602,2027931.5316176 6260735.93001159)
-9526458 | 686673945 | | 1 | LINESTRING(2028148.93054565 6260759.39576692,2028103.1914938 6260752.14026574,2027988.87185626 6260744.51560681,2027954.80550002 6260735.35750602,2027931.52542365 6260735.92544996)
(3 rows)This happened in changeset 69702171 (after applying minutely diff):
timestamp=2019-04-29T15\:57\:02Z
sequenceNumber=3473014I tried to reproduce this with the Slovakia extract and your mapping, but I was unable to reproduce this with an import beginning with 2/963/930.osc.gz. Importing all 6000 changesets might reproduce this error, but this won't help much in fixing the issue.
I can acknowledge the issue, as I also found duplicates in another database. However, I don't really understand how this happens and why it only happens "randomly".
The duplicate ways all seem to have in common, that they are old and a new changeset only changes a single node. This should trigger a delete of all depending ways and these ways are thenre-imported with the updated node. This is a common case and there are tests for this. But somehow, some ways are not deleted but they are re-imported.
I just merged a larger refactoring of the parser and also found that errors were not returned immediately in Delete (however the transaction aborts and the Commit should fail later). Time will have to tell if this fixes the issue.
Could be related or not, after modifying relation in OSM it's member has now slightly different geometry in comparison to the same member of other relation
No, not related. Nodes lose precision when they are serialized in the internal cache (same precision as in the PBF). While building the member geometries, one node of the way was still in the in-memory cache with the full precision.
zdila
commented
5 years ago Merge did not fix it. After fresh import (on fresh server) and 2 days of minutely diffs I see one road to be duplicated. But still thanks for the effort.
olt
commented
5 years ago Did you use the release binaries or did build from master? I just realized that I only pushed the tag v0.7.2, but that didn't update master. Master is now up to date and there is also v0.7.3 with a fix for imposm run.
zdila
commented
5 years ago So far I was always building from master.
Sometimes when minutely diff is applied the way is duplicated. I saw it twice so far - only end node of the way was moved and 2nd row for this way was created even that version of the way in OSM didn't change. I observed it in
osm_roadstable: https://github.com/FreemapSlovakia/freemap-mapnik/blob/b8ccd031dcb43091102747fc9742be948a69d8a0/mapping.yamlRows in that case were equal except for
idandgeometrycolumn.Unfortunately I can't reliably reproduce it.
Your Environment