[postgis-users] Dividing an area to closest line

[nicklas.aven at jordogskog.no]

Hi again
 
Here is a sample of 13 roadparts. What this is about is that I want to bind values like volum of forest and things like that to the roads. The data of the forest will change over time beacause of growing and cutting down. Other data have different shapes and changing pattern. Then I want this polygons I´m talking about to easy update the future needs of transportation on the roads with the functionST_Intersection(My polygon, Some data). It will just be an approximation because of topografic problems transporting the trees to the closest road but it will be a quite good approximation. 
 
 
Thank you
 
/Nicklas
 
"roadnumber"|"the_geom asewkt"
"042817-00"|"MULTILINESTRING((373328.2 6810997.4,373329.9 6811005.8,373330.7 6811013.6,373333.3 6811018.8,373334.5 6811019.8,373338.6 6811022.6,373347 6811027.2,373354.8 6811029.1,373362.9 6811028.4,373369.5 6811026.1,373373.8 6811023.8,373385.5 6811016.2,373392.6 6811010.8,373402.5 6811004,373417.6 6810995.3,373433 6810988,373450.6 6810982.6,373471 6810976.2,373492.2 6810971,373512.3 6810966.4,373529.7 6810963.1,373542.6 6810963.1,373555.1 6810967.1,373560.2 6810969.6,373571.6 6810977.4,373581.9 6810985.6,373589.1 6810991.4,373591.2 6810994,373595.8 6810998.6,373604 6811006.1,373608.4 6811009.5,373614.5 6811014,373623.6 6811021.1,373635 6811027.1,373646.5 6811033.2,373656.8 6811037.5,373676.6 6811043.1,373695.8 6811051,373705.5 6811056.4,373721.9 6811067.9,373737.3 6811078.5,373756.1 6811092.1,373771.7 6811103.1,373789.5 6811115.4,373808.6 6811126.4,373828.6 6811138.1,373848.76811151.4,373868.1 6811160.6,373891.7 6811169.6,373915.4 6811177.1,373936.8 6811182.3,373964.1 6811!
 188.2,373990.9 6811194.7,374018.1 6811199.2,374047 6811204.5,374078 6811209.5,374109.4 6811214.5,374137.1 6811221,374146.9 6811225,374161.3 6811232.8,374171.5 6811241.1,374182.5 6811255.9,374191.5 6811269.5,374201.6 6811281.4,374216.1 6811296.1,374233.3 6811312.3,374251.7 6811327.9,374269.5 6811344.2,374289.4 6811359.3,374308.1 6811376.9,374317.8 6811386.5,374336.4 6811398.7,374343.4 6811400.5,374364.6 6811402.2,374388 6811403.5,374413.3 6811405.8,374432 6811406.8,374447.8 6811405,374459.4 6811404.3,374471 6811404.4,374482.1 6811407.7,374490 6811412.6,374495.7 6811419.1,374502.7 6811431.6,374509.2 6811451.6,374517.3 6811472.6,374525.9 6811489.8,374536.9 6811501.9,374546 6811510.2,374557.1 6811520.2,374572 6811534.3,374582.6 6811548.6,374592.5 6811567.5,374599.2 6811581,374604.56811599,374612.3 6811624.8,374621.4 6811645.2,374630 6811658.8,374644.6 6811678,374660.4 6811697.7,374671.5 6811712,374686.2 6811730.9,374695.5 6811740.9,374712.9 6811754.6,374724.7 6811761.2,374742.5!
  6811766.3,374763.1 6811767.6,374787.9 6811767.2,374803.9 6811767.8,374815.2 6811772.2,374828.1 6811778,374846.9 6811788.4,374865.5 6811800.8,374886.1 6811813.4,374905.8 6811827,374920.9 6811838.1,374935.4 6811853.1,374939.2 6811860.3,374944.3 6811875.5,374948 6811894.8,374951.5 6811912.3,374952.5 6811914.3),(374952.5 6811914.3,374952.7 6811925.6,374952 6811936.5,374948 6811952.7,374944 6811969.1,374940.5 6811989.4,374939.2 6812004,374940.6 6812018.1,374946.3 6812034.1,374949.7 6812043.8,374952.5 6812052.4,374954.2 6812061.3,374954.6 6812071.8,374953.6 6812091.8,374952.7 6812119.3,374952 6812151.5,374953.1 6812184,374956.8 6812215.1,374961 6812242.3,374964.3 6812267,374967.86812289.7,374971.1 6812306.9,374976.3 6812326.3,374982.5 6812346.5,374982.5 6812350.3,374991.5 6812367,374999.2 6812388.8,375005.4 6812410.3,375011 6812433.1,375019.4 6812457.3,375028.8 6812484.9,375032.9 6812502,375033.5 6812508.2,375035.4 6812526.7,375038.3 6812533.9,375049 6812551.3,375064.6 6812567.9,375071.8 6812575,375088.5 6812592.3,375094.2 6812596.4,375115.9 681260!
 4.1,375143.3 6812610.5,375171.6 6812616.6,375179.7 6812620.6,375196.7 6812630.3,375211.3 6812636.5,375228.8 6812646.2,375243.6 6812657,375251.3 6812665,375265.9 6812682.8,375279.4 6812701.5,375292.6 6812720.4,375297.9 6812728.1,375309.2 6812747.1,375318.7 6812766.7,375326.9 6812788.4,375334.8 6812811,375339.8 6812833.4,375344.5 6812857,375350.7 6812880.2,375357.5 6812902.3,375363.7 6812919.5,375367.3 6812927.4,375376.8 6812945,375386.1 6812962.2,375389.6 6812972.2,375389.7 6812979.6,375388.4 6812986.6,375382.66813003.5,375381.4 6813005.7),(374952.5 6811914.3,374954.6 6811914.9,374962.4 6811920.9,374969.6 6811923.9,374983.3 6811929.1,374995.6 6811932.2,375008.6 6811933.6,375017.9 6811933.4,375032.4 6811932.5,375051.5 6811931.1,375070.2 6811930.2,375087.2 6811930.9,375108.1 6811932,375123.2 6811930.6,375143.6 6811925.6,375165 6811919.8,375186.5 6811915.1,375199.5 6811913.6,375215 6811913.2,375223.6 6811914,375239.7 6811918.3,375256.7 6811925.9,375264.6 6811931.2,375281.2 6811!
 942.6,375299.8 6811955.5,375317.6 6811969.4,375337.5 6811982.5,375346.2 6811986.6,375355.1 6811987.5,375375.1 6811987.3,375390.8 6811985.2,375406 6811982.4,375415.9 6811981.5,375422.8 6811981.9,375431.3 6811984.1,375442.4 6811989.3,375459.1 6811997.6,375478.2 6812006.5,375497.8 6812012.3,375513.5 6812012.6,375536.8 6812011.5,375547.8 6812012.3,375557.1 6812016.5,375572.1 6812029.2,375589.4 6812042.7,375605.56812057.6,375622.6 6812073,375636.5 6812085.8,375648.2 6812102.6,375663.5 6812122.5,375680 6812143.4,375691.3 6812160.5,375704.7 6812179.5,375722 6812199.1,375730.6 6812206.3,375737.2 6812210.4,375747.8 6812216.8,375756.5 6812221.1,375762.3 6812224.4,375773.7 6812233.9,375788 6812247.4,375803.7 6812267.2,375817.5 6812290.1,375830.9 6812314.8,375844.4 6812339,375857.7 6812363.7,375872.4 6812387.2,375887.6 6812410.3,375899.8 6812426.1,375908 6812434.7,375923.5 6812452.2,375939.1 6812466.5,375955.2 6812482.6,375967.2 6812495.6,375983.8 6812512.5,375999.2 6812528.9,376013.4 6812541.9,376019.2 6812545.3,376032.6 6812548.5,376046.6 6812549.4,3760!
 64.5 6812550.1,376080 6812550.8,376091.3 6812553.1,376100 6812557.8,376103.7 6812561.3,376113.9 6812574.5,376118.6 6812577.9,376128.1 6812581.4,376133.9 6812581.5,376147.7 6812579.4,376168.9 6812574.1,376183.9 6812568.7,376196.8 6812562.4,376201.96812558.9,376203.1 6812557.6))"
"042878-00"|"MULTILINESTRING((370503.6 6812346.7,370506.1 6812346.5,370511.8 6812344.7,370520.4 6812342.8,370529.9 6812340.7,370540.3 6812338.5,370545.4 6812337,370549.2 6812335.7),(370503.6 6812346.7,370502 6812329.9,370499.5 6812315.5,370495.9 6812295.6,370492.1 6812277.4,370487 6812258,370480.8 6812236.8,370474.6 6812216,370468 6812197,370462.9 6812181,370457.7 6812165.5,370450.5 6812145,370443 6812127.1,370438 6812114.5,370433.5 6812106.5,370424.5 6812089.6,370415.1 6812073.2,370405.1 6812057.3,370395.1 6812041.2,370384.2 6812023.9,370372.9 6812007.8,370361.3 6811992.2,370350 6811975,370338.6 6811958,370327 6811940.2,370315.5 6811923.4,370306.7 6811910.9,370304.8 6811907.9,370301.5 6811901.5,370295.7 6811892.5,370290.1 6811885.2,370280 6811875.2,370271.9 6811866.8,370259.7 6811857.1,370246 6811846.7,370229.9 6811836.4,370213.8 6811825.7,370198.2 6811815,370188.2 6811807.9,370175.66811796.7,370162.8 6811785.6,370156.5 6811780.1,370145 6811768,370134.5 6811756,370123.1 681!
 1743.8,370111.2 6811729.7,370100 6811716.9,370092 6811708.4,370084.4 6811700.6,370074.5 6811689.8,370063.3 6811676.9,370059 6811670.9,370053.6 6811656.6,370053.2 6811645.2,370053.4 6811635.2,370055.2 6811627.8,370056.8 6811624.2,370057.6 6811622.4,370058.7 6811620.6,370061.5 6811614.9,370063.6 6811611.3,370068.7 6811604.2,370076.1 6811596.3,370086.4 6811587.8,370098.1 6811581.5,370109.3 6811575.5,370120.7 6811568.8,370132.9 6811561.3,370140 6811555.8,370147.5 6811548.5,370156.6 6811538.2,370162.4 6811528.1,370165.4 6811519.9,370167.8 6811508.7,370170.1 6811495.1,370170.2 6811489.4,370169.8 6811478.3,370167.9 6811468.7,370164.5 6811454.3,370160.5 6811439.4,370156.7 6811425.5,370154.1 6811414,370153.8 6811411.1),(370503.6 6812346.7,370503.2 6812357.8,370503.3 6812361.3,370503 6812363.3,370503.16812371.5,370502.9 6812387,370502 6812403.3,370500.7 6812416.2,370498 6812432.6,370495.2 6812449.1,370491.4 6812466.2,370487.3 6812482.6,370482.9 6812500.2,370478.3 6812516.4,370473.6 6!
 812531.3,370468.9 6812546.3,370464 6812560.8,370459 6812574.9,370454.2 6812590.8,370449.5 6812606.8,370444.5 6812622.3,370439.9 6812637.3,370435.1 6812651.2,370429.9 6812664.8,370425.1 6812679,370420.3 6812694.2,370416.1 6812707.8,370411.8 6812720.4,370407.8 6812734.7,370404.1 6812747.5,370400.2 6812759.2,370397.1 6812773.5,370394.4 6812784.9,370392.2 6812796.6,370390.4 6812808.6,370389.1 6812823.3,370388.6 6812839.1,370388.2 6812853.8,370388 6812868.9,370387.7 6812884.3,370387.3 6812899.6,370386.8 6812915.9,370386.2 6812932.6,370385.7 6812948.2,370385.3 6812962,370383.5 6812977.7,370382 6812993.9,370379.9 6813006.8,370377.5 6813023,370375.2 6813037.4,370372.8 6813051.2,370370.9 6813060.5,370368.56813069.5,370366.7 6813076.1,370364.8 6813086.6,370363.4 6813095.5,370363.1 6813100.9,370363.6 6813111.8,370364.1 6813118.4,370367.1 6813131.6,370374.1 6813145.7,370384.4 6813157.4,370394.6 6813168.1,370405 6813177.9,370415.2 6813186.2,370426.9 6813195.1,370439.4 6813204.3,370452.2 6813212.4,370465.7 6813219.4,370478.4 6813225.1,370489.2 6813230,37049!
 6.9 6813232.4,370508.7 6813234.1,370515.8 6813234.5,370526.6 6813233.9,370536.5 6813233.1,370545.9 6813231.3,370555.9 6813229.4,370567.4 6813227.3,370579.3 6813225.9,370586.5 6813224.6,370588 6813224.3,370590.6 6813223.9,370591.6 6813223.7,370600.6 6813222.4,370610.7 6813220.5,370621.2 6813218.4,370632.9 6813216.1,370644.2 6813213.8,370655.9 6813211.1,370668.1 6813208.2,370681.3 6813204.9,370694.6 6813201.5,370710.1 6813199.2,370724.2 6813196.1,370735.8 6813193.6,370751.6 6813191.7,370765.8 6813189.6,370779.9 6813187.8,370792.96813186.7,370803.9 6813186.1,370812.6 6813186.1,370822.8 6813186.3,370832.6 6813187.8,370843.7 6813188.8,370854.4 6813189.7,370865.8 6813190.5,370877.8 6813191.4,370890.7 6813192.3,370904.4 6813193.4,370917.7 6813194.2,370929.2 6813194.2,370939.8 6813193.4,370953.1 6813191.8,370967.7 6813189.1,370982.1 6813185.5,370995.2 6813181.5,371007.4 6813177.3,371018.1 6813172,371023.5 6813168.8,371034.8 6813162.8,371045.7 6813156.2,371056.8 6813150.2,371067.3 6!
 813143.4,371075.1 6813137,371083.8 6813128.2,371091.2 6813120.6,371100..7 6813112.6,371107.8 6813105.1,371115.9 6813096.7,371124.5 6813088.9,371133.2 6813079.7,371142.1 6813070.4,371151.4 6813060.2,371160.6 6813049.7,371170.7 6813039.2,371180.5 6813027.7,371189.9 6813015.8,371199.5 6813003.3,371203.2 6812998.7,371213.3 6812986.4,371222.1 6812974.3,371228.3 6812966.1,371234.9 6812958.3,371245.2 6812944.1,371255.8 6812929.8,371265.86812915.3,371275.2 6812900.6,371283.4 6812886,371290.5 6812872.4,371297.5 6812857.7,371304.6 6812843.3,371311 6812830,371317.8 6812816.8,371324.3 6812804.1,371329.8 6812792.5,371333.1 6812784.8,371333.8 6812782,371340.3 6812770,371345.2 6812761.3,371350.9 6812751.3,371356.7 6812741.9,371364 6812731.9,371371.5 6812723.5,371380.8 6812713.2,371390.1 6812703.1,371399.9 6812693.3,371410.1 6812682.9,371416.4 6812675.5,371421.5 6812669.5,371430.5 6812660.6,371440.8 6812651.2,371450.4 6812642,371458.7 6812634.3,371469.1 6812624.7,371480.5 6812615,371494 6812604.6,371508.3 6812593.7,371520.7 6812583.9,371534.5 6812574.4,371547.!
 8 6812565,371563.2 6812555.9,371572.5 6812551.2,371585 6812545.7,371585.8 6812544.8,371597.4 6812539.7,371619 6812533.6,371641.5 6812529.8,371662.7 6812528.9,371670.1 6812529.7,371683.5 6812533.7,371699.1 6812541.2,371713.1 6812550.4,371726.8 6812559.7,371733.46812564.6))"
"042810-00"|"LINESTRING(370896 6815238.4,370892.7 6815237.5,370888 6815236.3,370881.9 6815234.6,370873.2 6815232.9,370863.7 6815231.1,370854.6 6815229.2,370845.3 6815227.3,370835 6815225.8,370824.7 6815224.2,370814.1 6815222.3,370802 6815219.7,370792.3 6815216.5,370785.3 6815213.9,370775.7 6815209.6,370770.2 6815206.3,370761.9 6815199.1,370752.8 6815191.2,370743.5 6815182.6,370739.4 6815177.2,370734.7 6815171.2,370728 6815165.9,370718.1 6815159,370708.4 6815153.6,370698.8 6815148.2,370689 6815142.2,370680.3 6815135.8,370671.5 6815131.1,370662.5 6815127.2,370652 6815121.3,370644.9 6815116.6,370639.7 6815113.4,370627.4 6815106.2,370620 6815100.4,370609.5 6815091,370597.7 6815081.3,370591.3 6815074.9,370582 6815067.6,370569.5 6815058.6,370559.6 6815049.5,370552.7 6815042.9,370549 6815039.5,370543.9 6815033.2,370539.2 6815026.2,370537.1 6815024,370536.7 6815023.3,370533.76815018.6,370528.2 6815011.8,370522.2 6815004,370515.4 6814997.7,370505.1 6814989.9,370497.8 6814983.2,370487!
 .8 6814974,370477.3 6814965.8,370464.7 6814958.4,370452.8 6814951.2,370442 6814944.6,370429.4 6814936.9,370416.9 6814928.4,370405.3 6814919.8,370393.6 6814911.7,370383.2 6814903,370372.4 6814894.1,370363.4 6814884.3,370353.5 6814874.4,370343.9 6814866.2,370331 6814858.8,370319.4 6814854.8,370305.9 6814851.4,370296.2 6814848.9,370287.7 6814847,370274.8 6814844.2,370261 6814842.6,370248.9 6814841.9,370236.6 6814842.7,370225.1 6814844.7,370209.1 6814846.2,370193.5 6814847.1,370177.1 6814847.7,370162.5 6814848.2,370148.9 6814848,370137.5 6814846,370131.7 6814843.8,370121.9 6814838.6,370110.9 6814828.5,370096.9 6814817.3,370086.4 6814807.2,370075.7 6814794.4,370063.4 6814782.4,370052.1 6814771.1,370042.7 6814765,370028.5 6814758.6,370022.5 6814754.4,370011.1 6814745.4,370004.16814738.6,369999.9 6814730.3,369998.5 6814727.6,369997.8 6814725.4,369997.5 6814724.3,369993.8 6814718.3,369986.2 6814708.5,369978.3 6814700.3,369966.2 6814690.5,369954.4 6814679.3,369941.9 6814665.9,369928!
 .8 6814652.4,369915.2 6814638.8,369904.1 6814627.1,369891.9 6814614.6,369882.9 6814606.7,369868.6 6814594.7,369860.6 6814588.8,369849 6814579.4,369834.9 6814569,369821.2 6814557.8,369810 6814545.6,369799.6 6814532.2,369790.6 6814520.5,369782.9 6814509.7,369778.5 6814503.9,369777.3 6814501.5,369768.4 6814493.6,369764.6 6814489.7,369754.9 6814479.2,369743.8 6814468.1,369732.3 6814456.4,369722.1 6814448.9,369706.7 6814438.9,369691.6 6814430.6,369676.7 6814422.2,369663.6 6814414.5,369650.5 6814408,369638 6814404.3,369621.1 6814403.1,369607.2 6814403.5,369597.6 6814404.5,369584.1 6814407.5,369570.9 6814412.4,369556.8 6814416.7,369553.3 6814417.5,369550 6814418.7,369545.2 6814419,369536.86814419,369526.1 6814418.4,369512.6 6814416.4,369501.9 6814414.8,369491.5 6814415.3,369484.2 6814417.3,369473.1 6814421.1,369460.5 6814426,369452.8 6814429.6,369443.6 6814435.2,369436 6814441.4,369433.2 6814444.7,369430.1 6814449.1,369423.9 6814457.7,369418 6814465.9,369412.7 6814473.5,369405.1 6814481.6,369396 6814489.5,369387.4 6814495.8,369379 6814500.1,369367.1 !
 6814502.6,369356.3 6814505,369344.7 6814506.8,369333.7 6814507.1,369321.9 6814505.7,369313.6 6814502,369310.9 6814500.5,369308.9 6814500.4,369304.8 6814498.2,369296.7 6814493.8,369287.8 6814487,369278.6 6814476.5,369272.7 6814467.6,369266.7 6814456.7,369260.9 6814440.6,369254.9 6814422.5,369249.2 6814406,369245.3 6814395.4,369237.2 6814383.4,369232 6814376.1,369226.5 6814368.7,369219.2 6814358.3,369209.3 6814346.4,369201.7 6814334.3,369195.3 6814323.3,369190.2 6814313.9,369186.1 6814299.6,369183.7 6814288.3,369183.56814283.1,369183.7 6814277.6,369185.8 6814268.2,369188.7 6814257.1,369191.1 6814247.9,369193.3 6814238.1,369195.5 6814226.6,369196.8 6814215.6,369196.8 6814209,369196.8 6814206.1,369197.3 6814203.4,369197.2 6814201.6,369196.9 6814191.1,369196.4 6814179.7,369195.5 6814168.1,369193.7 6814155.2,369191.3 6814139.5,369190 6814123.3,369188.4 6814108.3,369186.4 6814101.7,369181.6 6814091.1,369176.4 6814078.2,369170.7 6814065,369164.8 6814051.9,369160.7 6814040,369157.6 !
 6814025.9,369156 6814012.5,369155.5 6814003.1,369155.4 6813994.4,369156 6813986.4,369157.3 6813977.9,369159.1 6813969.1,369161.5 6813955.7,369163.9 6813944.3,369166.6 6813931.3,369167.1 6813928.6)"
"042823-00"|"LINESTRING(376384.1 6808765.6,376385.3 6808766.8,376388.4 6808769.5,376392.1 6808775.5,376397 6808782.9,376407.2 6808796.7,376413.3 6808809.1,376419.2 6808821.5,376423.3 6808837.1,376424.7 6808850.6,376426.1 6808868.7,376427.5 6808888.9,376427.2 6808902.3,376425 6808921.9,376422.1 6808942.5,376420.1 6808965.5,376418.7 6808989,376418.7 6809013.8,376420 6809037.5,376420.8 6809059.3,376419.8 6809077.2,376417.7 6809098,376414.7 6809120,376411.2 6809142.1,376409.9 6809163.7,376410.3 6809181.4,376412.2 6809193.4,376416.6 6809209.6,376423 6809229.5,376430.1 6809248.6,376434.6 6809257.2,376444.6 6809271.6,376454.4 6809284.6,376461.6 6809290.7,376475.9 6809300.5,376489.1 6809307.7,376507.1 6809314.8,376527.7 6809323,376548.4 6809330.4,376570 6809336.4,376589.6 6809339.7,376611.2 6809341,376629 6809340.2,376650 6809337.9,376669.7 6809332.9,376689.3 6809327.3,376708.56809320.4,376726.4 6809312.1,376744.3 6809303.4,376762.1 6809293.5,376780.7 6809283.6,376792.5 6809277.1,37!
 6807.5 6809272.1,376823 6809269.8,376836.7 6809269.6,376853.8 6809270.6,376874.8 6809272.7,376898.6 6809275.7,376926 6809278.8,376950.2 6809280.5,376969.7 6809281.8,376975.6 6809282.4,376985.2 6809283.8,376994 6809285.8,377005.5 6809291.7,377011.2 6809295.4,377016.2 6809301,377025.8 6809311.2,377032.5 6809319.6,377041.5 6809336.6,377046 6809351,377046.4 6809363.2,377045.2 6809372.3,377043.7 6809386.4,377043.3 6809388.6,377043.2 6809391.5,377042 6809397.4,377039.9 6809407.7,377037.1 6809422.2,377033.9 6809436.5,377030.3 6809451.7,377026.9 6809469.5,377025 6809483.9,377024.8 6809497.7,377025.5 6809512.2,377027 6809520.4,377031.2 6809533.5,377036.1 6809545.8,377042.1 6809558.7,377046.8 6809572.5,377049.5 6809589.5,377050 6809607.6,377052 6809627.5,377053.6 6809647.2,377054.56809667.3,377055.1 6809685.8,377055.6 6809702.5,377056 6809720.6,377056.7 6809740.5,377057.5 6809760.8,377059.6 6809780.1,377062 6809799.3,377065.3 6809817.6,377068.6 6809835.8,377072.7 6809854.1,377077.4 6!
 809870.5,377081.5 6809885.4,377085.8 6809903.8,377089.9 6809924.5,377093.7 6809944.1,377096.5 6809963.4,377097.8 6809982.6,377098.9 6810001.8,377098.3 6810012.4,377095.7 6810028.2,377092.8 6810046.3,377090 6810057,377084.5 6810075.2,377079.2 6810094.3,377073.9 6810113.1,377069 6810131.6,377066.7 6810145.4,377067 6810151.5,377068.3 6810155.9,377070.6 6810160.4,377074.8 6810164.1,377078.9 6810166.5,377082.2 6810167.4,377090.6 6810167.2,377095.4 6810166.1,377106 6810162.1,377114.3 6810156.5,377120.7 6810150.8,377131.2 6810140.4,377143.4 6810129,377154.5 6810116.1,377164.6 6810103.1,377176.2 6810087.3,377183.1 6810079.5,377196.4 6810066.1,377206.7 6810054,377218.5 6810043.3,3772336810031.3,377243.6 6810023.9,377261.1 6810012.1,377278.2 6810000.6,377294.3 6809989.1,377307.9 6809982.4,377329 6809973.6,377351.4 6809966.9,377375.8 6809959,377399.5 6809951.8,377414 6809948.9,377428.9 6809947.7,377445 6809948.3,377460.2 6809951.5,377481.1 6809957.9,377502.8 6809963.8,377525.4 6809970.5,377543.1 6809975.9,377567.6 6809982.4,377591.1 6809990.7,377614.6 68!
 10000.6,377638.1 6810011.1,377661.2 6810022.3,377682.8 6810034.6,377704.1 6810046.1,377722.1 6810056.7,377736.8 6810067.6,377746.3 6810076.7,377747.3 6810077.8,377748 6810078.1,377751.8 6810084.4,377758.1 6810093.7,377765.5 6810106.3,377774.7 6810121.6,377781.8 6810135.6,377793.6 6810154.9,377805.1 6810178.1,377817.2 6810201.3,377830.6 6810225.7,377844.2 6810251.6,377857.8 6810274.6,377870.4 6810299.7,377882.3 6810327.1,377894.6 6810353.8,377905.1 6810380.5,377915.6 6810403.4,377923.5 6810425.8,377930.16810444.4,377933.3 6810457.6,377934.8 6810468.8,377935.4 6810480.1,377935.4 6810490.4,377934.1 6810496.1,377930.5 6810507.1,377925 6810518.4,377917.7 6810530.6,377910 6810545.1,377902.7 6810557.5,377894.4 6810573.3,377885.7 6810589.1,377877.7 6810606.1,377872.1 6810621,377867 6810643.1,377861.4 6810662.1,377856.2 6810681.2,377850.9 6810700.6,377844.9 6810720.7,377839.4 6810740.1,377834.5 6810757.4,377829.9 6810774.3,377826.3 6810791.4,377823.3 6810808.8,377820.9 6810824.2,377!
 819.7 6810835.1,377819.4 6810842.4,377819.3 6810854.4,377819.4 6810869..1,377819.4 6810884.6,377819.9 6810900.8,377820.3 6810918.6,377821.8 6810937.4,377823.7 6810958.3,377824.7 6810979.8,377825.2 6810999.2,377825.5 6811017.5,377824.1 6811038.5,377820.8 6811057.6,377815.6 6811079.8,377810.1 6811104.1,377804 6811125.7,377797.8 6811148,377791.2 6811169.1,377784.5 6811188.8,377779.9 6811200.6,377772.4 6811219.6,377764.86811238.8,377756.4 6811255.6,377747.6 6811271.6,377738.1 6811287,377733.1 6811295.1,377723.7 6811310.3,377712.5 6811325.6,377703.3 6811340.2,377698.4 6811350.3,377693.5 6811366.8,377690 6811386,377688.4 6811404.4,377688.3 6811416.3,377689.2 6811426.8,377690.9 6811434,377693.5 6811440.3,377697 6811445.4,377705.6 6811455.9,377715.2 6811465.3,377726.5 6811474.5,377739.4 6811482.1,377752.1 6811486.2,377759.8 6811487.8,377776.2 6811490.4,377794.6 6811492.8,377816.4 6811495.6,377840.1 6811498.4,377865.4 6811500.6,377891.2 6811502.9,377914.9 6811504.3,377938.8 6811505.3,377963.3 6811504.8,377983.9 6811504.3,378007.5 6811503.3,378037 681150!
 1.7,378064.8 6811500.9,378085.9 6811500.4,378107.2 6811500.8,378129 6811504.3,378150.6 6811509.6,378173.7 6811515.6,378197.2 6811522,378221.9 6811527.1,378245.2 6811533.1,378267 6811539.8,378283 6811546.7,378296.7 6811556.3,378304.7 6811565.8,378312.76811579.7,378321.4 6811599.3,378330.2 6811619.2,378335.1 6811631.2,378345.6 6811655.9,378357.4 6811686.7,378366.5 6811712.2,378371.3 6811736.7,378376.1 6811762,378381.4 6811785.8,378386.2 6811811.3,378391.3 6811833.5,378395.6 6811856,378400.4 6811881.8,378403.2 6811905,378404.2 6811926.4,378402.9 6811947,378401.3 6811970.1,378400 6811994.8,378398.9 6812023.2,378397.5 6812048.4,378396.2 6812077.5,378394.3 6812111.7,378392 6812144.6,378390 6812174.6,378388.6 6812198.9,378387.1 6812223.1,378385.1 6812247.2,378382.3 6812271.7,378379.7 6812301.5,378377 6812331.6,378375.2 6812355.3,378375.6 6812376.3,378377.5 6812391.6,378382.9 6812412,378389.4 6812431.7,378392 6812440.6,378396.8 6812458.3,378403 6812483.1,378410.1 6812514.6,378416.3!
  6812545.9,378420.9 6812576.3,378425.7 6812605.8,378430.7 6812635.8,378437.4 6812665.2,378443.4 6812693.3,378448.4 6812719.8,378451.1 6812742.4,378450.66812763.9,378448.7 6812787.3,378446.3 6812811.1,378443.8 6812836.9,378442.2 6812864.1,378441.7 6812895.9,378442.4 6812928.6,378444.7 6812956.9,378448.8 6812990.6,378453.1 6813022.5,378457.3 6813057.2,378461.6 6813092.3,378465 6813123.4,378468.3 6813152.3,378471.2 6813180.6,378473.6 6813210.7,378475.5 6813240.8,378477 6813269.3,378477.8 6813298.9,378478.7 6813330.3,378479.5 6813361.2,378480.8 6813393.6,378483.2 6813419.2,378484.8 6813432.1,378485.4 6813433.8,378486.6 6813438.8,378488.9 6813450.9,378493.4 6813467.5,378500.1 6813490.1,378507 6813510.6,378513.2 6813526.1,378522.4 6813547.2,378531 6813566.6,378540.4 6813586.4,378546.3 6813604.5,378549.8 6813624.7,378550.2 6813638.7,378548.5 6813655.3,378547.3 6813674.8,378546.4 6813696.5,378546.8 6813718.8,378548.7 6813740.9,378551.1 6813762.4,378553.1 6813781.2,378553.8 6813796.2,378554.1 6813812.4,378552.6 6813823.7,378550.16813839.9,378547.3 6813!
 857.2,378544 6813877.3,378538.9 6813900.3,378534 6813920.9,378531.9 6813927.4,378526.8 6813937,378522 6813942.5,378515.6 6813947.1,378507.3 6813952.1,378503.4 6813954.1,378492.8 6813957.8,378481.5 6813962.1,378468.6 6813966.1,378460.2 6813970.2,378452.7 6813976,378445.7 6813983.5,378442.7 6813988.3,378440.4 6813995,378439.2 6814002.3,378439.4 6814017.7,378439.5 6814034.7,378439.4 6814054.3,378438.7 6814076.4,378437.2 6814099,378435.7 6814110.5,378433.1 6814122.3,378426.2 6814139,378416.2 6814158.5,378406.7 6814179.9,378403.5 6814191.4,378400.8 6814208.4,378399.8 6814217.5,378400.1 6814224,378399.5 6814227.8,378399.7 6814236.3,378399.6 6814247,378400.1 6814259.1,378400.8 6814271.5,378402 6814289,378402.5 6814307.6,378401.3 6814326.7,378399.1 6814335.6,378394.2 6814350.9,378388.6 6814365.4,378382.7 6814380.7,378379.4 6814391.5,378378.4 6814402,378378.76814414.5,378379.9 6814424.2,378382.5 6814431.7,378388.2 6814445.3,378393.8 6814454.8,378404 6814470.7,378415 6814490.5,378422!
 .7 6814502.7,378429.9 6814515.2,378438 6814532.8,378442.7 6814541.3,378449.3 6814552.1,378459.3 6814567.4,378466.9 6814583,378474.3 6814600.4,378481.5 6814617.4,378485 6814630.3,378488.1 6814648.3,378492.9 6814667.8,378495.9 6814684.9,378496.9 6814691.1)"
"042816-00"|"LINESTRING(371999.5 6813893.6,372002.9 6813895.2,372005.8 6813895.6,372017.7 6813900.6,372033.4 6813906.3,372044.5 6813911.7,372060 6813920.5,372069.4 6813926.2,372076.7 6813931.5,372078.3 6813932.9,372082.4 6813936.2,372091.6 6813941.1,372099.8 6813945,372108.9 6813951.6,372122.2 6813960.6,372129.6 6813967.4,372137.9 6813972.2,372155.9 6813984.7,372175.5 6813998.3,372195.8 6814012,372213.7 6814025.1,372227.8 6814034.7,372235.2 6814037.4,372238.6 6814038.1,372250.6 6814037.7,372254.2 6814036.9,372258.1 6814034.8,372264.7 6814031.9,372270.8 6814028.8,372284.7 6814020.2,372301.9 6814013.4,372315.7 6813996.2,372327.6 6813977,372340.7 6813952.8,372354.5 6813928.5,372367.6 6813901.9,372378 6813880.6,372391.4 6813855.3,372404.8 6813829.4,372417.3 6813803.5,372423.8 6813787.1,372430 6813760,372433.9 6813733.5,372437.1 6813709.9,372441.6 6813687.7,372445.1 6813677.3,372451.76813656.9,372457.4 6813637.1,372461.2 6813623.4,372463.7 6813608,372461.6 6813594.5,372456.5 6813!
 582,372446.4 6813565.1,372436.2 6813547.4,372425.4 6813526.1,372417.7 6813503.8,372413.2 6813480.5,372410.4 6813456.3,372408.3 6813435,372406.1 6813413,372400 6813388.6,372393 6813364.1,372385.8 6813341.5,372377.4 6813318.4,372368.6 6813294,372359.6 6813268.7,372350.2 6813245.4,372341.8 6813221.7,372336.6 6813203.9,372334.6 6813189.1,372334.1 6813174.2,372335.1 6813155.4,372337.3 6813140.9,372345.1 6813118.5,372357.6 6813095.9,372373.1 6813070.9,372390.2 6813044.6,372408.3 6813019.4,372426.6 6812993.8,372442.8 6812970.7,372457.2 6812948.3,372467.3 6812927,372476.5 6812907.6,372484.2 6812891.4,372493.6 6812871.7,372505.7 6812850.7,372514.5 6812836.4,372527.5 6812814.1,372540.5 6812796.4,372553.5 6812782.3,372569.6 6812768.8,372581.7 6812760.4,372601.6 6812746.1,372615 6812735.7,372633.96812719.4,372652.6 6812704.4,372666.6 6812693.9,372680.2 6812685,372698.2 6812672.8,372719.3 6812661.7,372740 6812650.8,372753.6 6812640.9,372769.8 6812626.8,372776.2 6812618.7,372784.5 681260!
 1.5,372790.9 6812585,372796.3 6812567.7,372796 6812551,372794.8 6812533.8,372794.1 6812516.8,372794.1 6812507.5,372798.6 6812491.3,372805.5 6812476.8,372815.6 6812457.4,372821 6812445.1,372824.7 6812429.9,372824.8 6812415.8,372819.6 6812395.5,372815.4 6812377.5,372812.9 6812368.1,372811.5 6812362.9,372811.4 6812349.8,372813.6 6812336.5,372821.5 6812307.9,372829.4 6812278,372838.8 6812250.2,372849.3 6812225,372856.3 6812207.6,372865.6 6812183.4,372874.9 6812158.4,372883.6 6812134.5,372893.4 6812115.8,372905.5 6812097.7,372917 6812082.2,372923.1 6812073.2,372933.6 6812054.3,372941.6 6812036.9,372945.2 6812027.6,372948.3 6812012.2,372948.3 6811996.2,372942.7 6811973.9,372932.8 6811949.3,372922.26811930.2,372917.2 6811922.6,372908.7 6811914.5,372893.3 6811901.7,372879.4 6811889.2,372875 6811883.6,372866.5 6811869.2,372861.4 6811856.6,372860.2 6811847.7,372861.2 6811826.5,372865.3 6811801.8,372870.3 6811775.7,372872.4 6811750.5,372872.2 6811726.8,372870.8 6811693.4,372868.6 6811656,372865.9 6811621.1,372862.8 6811588,372860.3 6811559.9,372860.9 681!
 1542.8,372862.7 6811527.1,372870.3 6811507.8,372881.7 6811481.7,372894.3 6811453,372905.2 6811425.3,372916.7 6811403,372926.6 6811388.1,372943.6 6811367.3,372962.6 6811347.1,372981.8 6811327.3,373000.6 6811305.1,373017.7 6811284.9,373033.1 6811266.3,373044 6811251.9,373058.8 6811227.8,373073.9 6811205.4,373083.8 6811190.8,373099.6 6811174.2,373111.2 6811164.5,373129.9 6811152,373150 6811140.7,373168.4 6811129.8,373180.3 6811121.8,373199.3 6811108.7,373218.7 6811095.4,373238.2 6811082.5,373257.2 6811068.2,373275.7 6811055,3732916811042.6,373304.2 6811028.8,373314.3 6811016.7,373328.2 6810997.4,373333.9 6810983.8,373343.3 6810967.4,373351.2 6810953,373355.3 6810947.4,373359.6 6810940.4,373364.5 6810932.4,373372.3 6810920.9,373379.5 6810910.4,373390.2 6810896.7,373400.8 6810884.2,373413.3 6810869.3,373425.9 6810855.5,373437.5 6810840.9,373447.9 6810825.7,373457.8 6810809.9,373467.5 6810792.2,373477.7 6810775,373487.8 6810759.6,373497.2 6810744.5,373506 6810727.9,373514 6810709!
 .6,373520.5 6810693.7,373524.6 6810679,373528.4 6810660,373532.3 6810640,373537.9 6810618.8,373543.2 6810604.8,373551.4 6810587.8,373561.6 6810568.9,373575.2 6810549.5,373589.6 6810529.4,373607 6810509.3,373626 6810491.8,373643.8 6810476.6,373653.9 6810469.3,373674.2 6810459.4,373697.1 6810450.2,373716.3 6810440.6,373725.1 6810436.8,373739.4 6810425.7,373754 6810413.4,373765.2 6810400.2,373776.9 6810383.6,373787.5 6810372.4,373801.36810360.5,373818.7 6810348.2,373838 6810336.1,373854.3 6810324.9,373869.1 6810314.6,373887 6810301.7,373907.3 6810287.9,373926 6810273.5,373946.4 6810258,373965.4 6810242.9,373976.5 6810234.4)"
"042812-00"|"LINESTRING(372301.9 6814013.4,372310.1 6814013.1,372315.6 6814016.7,372326.8 6814024.5,372338.7 6814037.3,372352.8 6814051.3,372368.9 6814066.2,372377.9 6814076.2,372394 6814093.5,372407.4 6814110,372417.9 6814131,372425.5 6814157.5,372431.8 6814183,372438.1 6814205.4,372442.5 6814216.7,372451.4 6814230.9,372463.4 6814244.7,372474.6 6814254.9,372486.1 6814263.1,372494.2 6814266.6,372502.2 6814268.5,372504.4 6814268.3,372519.6 6814268.9,372538.9 6814267.3,372559.5 6814263.6,372576.9 6814260.4,372587 6814258.6,372599.2 6814257.6,372610.3 6814257.9,372625.3 6814261.1,372644.5 6814264.9,372665.4 6814271.3,372686.2 6814275.5,372707.6 6814278.8,372731.4 6814281.7,372756 6814284,372782 6814286.7,372809 6814287.8,372828.5 6814287.2,372844.9 6814283.8,372860.8 6814279.5,372879.1 6814276.5,372892.9 6814275.9,372903.3 6814278,372914.2 6814281.4,372929.3 6814286.9,372937.76814292.3,372943.7 6814297.8,372956.1 6814309.9,372966.9 6814322.8,372972.4 6814327.8,372980.4 6814332.!
 3,372990 6814335.8,372999.5 6814337.1,373013 6814335.6,373023.3 6814332.2,373028.7 6814328.9,373037.6 6814321,373044.9 6814311.5,373049.3 6814305.8,373054.2 6814300.6,373065.5 6814291.3,373075.1 6814285.4,373082.3 6814281.9,373095.6 6814279,373111.2 6814277.6,373121.2 6814278,373134.4 6814280.7,373150.3 6814283.7,373160.5 6814285.6,373178.3 6814287.4,373198.8 6814289.9,373218.9 6814293.1,373235.3 6814297.8,373249.6 6814302.6,373258.5 6814305.2,373274.3 6814310.2,373295.5 6814317,373315.9 6814323.9,373333.4 6814329.4,373345.3 6814333,373349.2 6814334.4,373361.4 6814336.9,373385.7 6814341.5,373408.3 6814344.4,373423 6814346.8,373456.4 6814351.6,373493.4 6814357.6,373530.2 6814360.8,373565.1 6814359.8,373592.5 6814358.5,373615.4 6814355.5,373629.1 6814351,373651.8 6814342.1,373675.86814330.5,373700.9 6814320.2,373719.4 6814312.7,373727.9 6814311.3,373744 6814310.5,373751.1 6814311.1,373762.2 6814314,373769.6 6814316.8,373777 6814321.4,373786.8 6814329,373789 6814333.6,373791.2!
  6814340.7,373791.4 6814344.9,373790.1 6814348.9,373787.2 6814354.8,373781.6 6814361.5,373773.3 6814370.4,373765.1 6814379.5,373760.2 6814385.1,373755.4 6814391.5,373754.1 6814396.2,373753.7 6814401.9,373754.8 6814410.3,373757.6 6814417.6,373764.4 6814428.6,373768.8 6814434.1,373776.6 6814440.6,373787.6 6814445.5,373803.7 6814449.2,373829 6814453.4,373849 6814457.3,373856.3 6814459.9,373869 6814466.5,373877.4 6814472.8,373881.3 6814476.5,373886.4 6814478.6,373896.3 6814481,373901.7 6814481,373905.9 6814480.2,373915.5 6814475.5,373929.2 6814468.8,373938.2 6814464.9,373952.9 6814460.6,373964.2 6814458.9,373974.4 6814459,373981.8 6814461,373996.1 6814468.9,374005.7 6814478.3,3740136814489.3,374024.3 6814511.3,374029.9 6814529.3,374036.1 6814554.1,374040.9 6814581.3,374045.4 6814607.6,374046.2 6814629,374044 6814647.6,374041.1 6814666.5,374038.5 6814679.4,374032.7 6814698.8,374027.8 6814710,374019.3 6814731.4,374011 6814756.2,374002.2 6814782.6,373992.8 6814810.4,373983.4 6814836.5,373973.7 6814864.6,373963 6814891.3,373951.8 6814920.4,373940.2 68!
 14948.2,373928.9 6814974.4,373918.1 6815002.4,373906.8 6815027.7,373896 6815048.7,373886.2 6815064.1,373874.6 6815078.2,373861.4 6815092.5,373847.8 6815107.3,373833.8 6815123.3,373819.7 6815139.4,373811.7 6815151.6,373805.5 6815164,373798.3 6815186.2,373794.2 6815210,373787.9 6815234.4,373781.6 6815256.8,373774.4 6815278.4,373765.9 6815297.8,373755.6 6815316.8,373744 6815339.5,373735.4 6815352.7,373724 6815368.5,373708 6815385.1,373699.1 6815393.7,373683.9 6815408.2,373676.2 6815415.7,373670.2 6815424.7,373661.96815440.6,373654.4 6815458.6,373646.8 6815476.6,373639.1 6815490.2,373626.1 6815506.3,373612.9 6815521.7,373597.6 6815537.3,373581.8 6815552.9,373565.3 6815569.6,373547.1 6815586.8,373529.7 6815604.5,373513.8 6815623.6,373505 6815633.7,373485.5 6815652.3,373472.9 6815666.4,373460.7 6815681.1,373442.9 6815700,373428.4 6815717.2,373412.7 6815734.6,373397.5 6815751.6,373393.7 6815755.3,373393 6815755.7)"
"042811-00"|"LINESTRING(372227.8 6814034.7,372235.2 6814037.4,372227.8 6814034.7,372225.8 6814053.5,372220.8 6814062.4,372216.5 6814070.1,372210.1 6814081.9,372202.5 6814096.6,372194.8 6814112.4,372185.8 6814129.6,372176.3 6814146.9,372166.1 6814163.7,372154.7 6814180.3,372143.3 6814196.5,372131.6 6814210.6,372121 6814225.1,372108.8 6814240.1,372095.8 6814255.3,372084.1 6814270.1,372072.6 6814285.3,372062.6 6814299.3,372055.7 6814311.6,372050.3 6814326.4,372050.5 6814329.3,372047.8 6814337.5,372045.1 6814353.7,372042.8 6814368.7,372039.5 6814384,372035.1 6814392.8,372025.4 6814408.2,372016.5 6814425.5,372008.2 6814445.1,371998.2 6814462.8,371987.7 6814479.1,371979.5 6814491.5,371970.9 6814507.2,371965.1 6814522.6,371957.4 6814544.8,371951 6814564.1,371945.2 6814583.6,371939.3 6814602.8,371931.6 6814622.4,371923.1 6814641.2,371914.1 6814661,371902.1 6814679.1,371892.76814695.8,371882.7 6814710.4,371879.4 6814714.6,371877.7 6814715.9,371873.2 6814722.8,371867.8 6814731.9,37185!
 7.4 6814746.1,371852.4 6814753.3,371842.4 6814771.7,371838 6814781.7,371832.8 6814796.6,371824.6 6814820.3,371816.2 6814843.1,371806.6 6814866.1,371796.2 6814887.8,371784.6 6814909.2,371771.9 6814930.2,371760.9 6814951.9,371750.9 6814972.6,371739.3 6814995.2,371726.6 6815016.6,371713.2 6815037.6,371699.6 6815058.6,371682.5 6815078,371679.3 6815082.7,371671.2 6815092.6,371663.9 6815100.9,371658.6 6815108.6,371650.7 6815120.8,371645.6 6815128.6,371640.3 6815139.3,371637.3 6815146.7,371636.1 6815149,371634.6 6815150.6,371629.5 6815167.4,371624.3 6815186.7,371619.3 6815206.2,371614.3 6815224.5,371609.7 6815238.2,371604.1 6815252.8,371599.9 6815262.1,371597.7 6815266.9,371595.8 6815274,371595.3 6815286.3,371597.1 6815299.6,371600.3 6815314.1,371601.9 6815327.6,371602.46815346.8,371600.7 6815364.6,371596.2 6815382.5,371590.5 6815401.3,371586.8 6815409.7,371576 6815425.7,371562.6 6815442,371548.1 6815457,371534.2 6815471.6,371526.8 6815482.6,371515.8 6815502.9,371502.1 6815521,371!
 490.5 6815534.8,371480.6 6815545.6,371474.4 6815552.1,371473.6 6815553,371470.9 6815554.4,371465 6815561.8,371454 6815574.9,371441.5 6815587.3,371430.9 6815598.2,371425.8 6815605.7,371418.5 6815620.9,371413.2 6815639.7,371406.6 6815658.8,371398.3 6815676.8,371392.4 6815688.6,371385.9 6815697.3,371372.8 6815710.2,371359.8 6815723.2,371343.2 6815735.3,371334.5 6815743.2,371320.3 6815754.8,371307.7 6815764,371296.6 6815772.4,371284.7 6815780.6,371275.2 6815789.3,371269.2 6815796.9,371265.9 6815803.6,371264.3 6815810.6,371264.2 6815817,371265 6815826,371268.8 6815844.4,371273.5 6815865.5,371278 6815887.2,371281.9 6815911.8,371287.2 6815934.4,371292.4 6815960.4,371296.56815983.7,371300.7 6816006.2,371304.5 6816026.6,371306.6 6816044.5,371309 6816055.8,371309.8 6816060.6,371310.5 6816062,371314.5 6816073.3,371320.5 6816081.8,371330.3 6816090.8,371340 6816100.2,371345.1 6816104.4,371354.6 6816112,371363.3 6816122.3,371367.2 6816130.4,371369 6816139.2,371370 6816154.8,371370 6816165.4,371368 6816178.4,371362.2 6816192.9,371355.3 6816208.4,371345.9 681!
 6223.3,371337 6816238.4,371328 6816253.1,371319.5 6816266.2,371311.6 6816281,371302.8 6816296.2,371299.3 6816302,371289.5 6816316.3,371280.4 6816328.9,371271.8 6816341.6,371264.9 6816352,371262.1 6816359.2,371259 6816370.5,371258.1 6816379.4,371258.8 6816391.4,371260.6 6816401.8,371264.5 6816418,371268.7 6816432.1,371273.3 6816445.1,371278.4 6816457,371283.6 6816470,371287 6816485.1,371287.9 6816496.8,371287.1 6816511.8,371283.9 6816528.7,371280.9 6816542.9,371278.7 6816551.6,371273.9 6816563.6,371271.76816569,371267.7 6816582.8,371263.8 6816596.2,371260.7 6816609.3,371258.9 6816620.5,371258.1 6816631,371258.7 6816637.2,371264.9 6816655.8,371271.9 6816677.6,371280 6816701.4,371288.4 6816723,371296.3 6816741.6,371304.7 6816754.5,371313.1 6816764.2,371323.9 6816776,371334.4 6816788,371343.7 6816798,371350.6 6816807.6,371356.9 6816815.1,371362 6816822,371362.8 6816822.9)"
"042820-00"|"LINESTRING(374173.9 6809429.6,374165.6 6809414.6,374159.5 6809395.9,374154.3 6809372.2,374148.9 6809350.4,374145.5 6809331.7,374140.6 6809321.6,374135 6809311.2,374130.6 6809298.8,374126.5 6809281.1,374120.2 6809264.6,374115.6 6809248.2,374114.1 6809234.8,374114.7 6809219.9,374116.8 6809207.4,374123.4 6809189.8,374127.2 6809177.1,374131.3 6809160.2,374133.6 6809140.1,374135.5 6809122.6,374136.9 6809106,374139.9 6809093.2,374143 6809080.9,374143.7 6809075.3,374143.4 6809062.5,374142.4 6809056.3,374140.9 6809051.6,374137.7 6809046.7,374128.3 6809038.3,374127 6809037.6,374123.8 6809035.5,374112.5 6809026.6,374105.4 6809023.1,374094.5 6809018.5,374081.1 6809016,374062.2 6809015,374038.9 6809014.2,374019.8 6809011.9,374004.4 6809009.2,373994.1 6809005.3,373984 6809000.1,373974.4 6808992.2,373967.4 6808981.4,373964.8 6808974.8,373963.3 6808963.4,373963 6808947.9,373964.26808928.6,373963.7 6808910.4,373962.5 6808902,373956 6808888.1,373949.5 6808873.2,373942.7 6808853.!
 9,373938 6808841.8,373934.4 6808830.9,373930.4 6808813.2,373926.8 6808796.5,373925 6808786.2,373924.3 6808763.5,373926.9 6808739.6,373930.8 6808716,373934.5 6808693.6,373939.7 6808668.7,373943.5 6808643.3,373947.5 6808621.8,373950.8 6808600.5,373952.9 6808583.1,373952.6 6808568.6,373951.4 6808562.2,373948.5 6808555.2,373944.4 6808550.2,373931.3 6808540.2,373917.4 6808530.6,373900.7 6808519.8,373892.5 6808511.3,373886 6808500.9,373879.4 6808488.8,373871.6 6808471.3,373864.2 6808456.3,373854.1 6808441,373849.8 6808436.7,373836.7 6808429.9,373822 6808426.7,373808.1 6808426.1,373789.7 6808427.3,373773.7 6808430.9,373760.5 6808432.9,373736.3 6808434.1,373713.8 6808434.9,373690.3 6808431.7,373670.3 6808427.1,373652 6808420.6,373636.2 6808414.9,373615 6808411.2,373587.4 6808409.1,373562.36808405.3,373537.6 6808399,373512.8 6808392.5,373491.4 6808385.3,373482.1 6808380.6,373469.1 6808367.2,373452.8 6808353.5,373439.2 6808344.3,373426 6808338.6,373411.5 6808335.2,373405 6808333.7,37!
 3395.6 6808330.7,373382.2 6808325.7,373362.8 6808319.5,373353.2 6808317,373344.8 6808314.3,373337.7 6808311.9,373327.5 6808308.3,373319.9 6808307.3,373319.4 6808306.9,373303.6 6808300.6,373283.6 6808292.8,373262.7 6808284.7,373240.9 6808276.2,373218.2 6808267.7,373204.2 6808262.2,373183.4 6808251.6,373165.4 6808242.6,373148.6 6808236.6,373135.8 6808234.1,373120 6808234.2,373103.1 6808236.2,373085 6808239.4,373065.4 6808240.3,373047.5 6808239.5,373029.9 6808237.1,373013.5 6808233.6,372994.5 6808233.8,372982.9 6808235.3,372966 6808239.9,372952.4 6808242.9,372936.6 6808243.6,372919.9 6808242.7,372900.1 6808241.8,372883.9 6808242.8,372871.8 6808243.8,372849.1 6808248.3,372833 6808250.3,372814.76808249.4,372789.7 6808246.2,372764.1 6808242.2,372743.1 6808239.3,372733.6 6808239,372722 6808241.1,372704 6808249.2,372687.5 6808256.3,372665.7 6808264.3,372655.4 6808267.7,372637.4 6808269.7,372614.9 6808270.7,372614.22 6808270.78)"
"042818-00"|"LINESTRING(373233.6 6810450,373231.7 6810448.9,373221.8 6810446.3,373196.1 6810441.3,373168.5 6810437.4,373137.8 6810431.8,373106 6810427.7,373075.1 6810423.1,373043.7 6810415.7,373013.2 6810409.9,372983.7 6810403.1,372959.5 6810397.7,372933.4 6810397.6,372905.1 6810399.6,372873 6810402.3,372839 6810405.9,372803.9 6810409,372768.4 6810412.5,372734.5 6810418,372705.3 6810425.3,372675.2 6810430.7,372646.1 6810437.9,372618.7 6810446.5,372597.6 6810454.4,372575.3 6810463.1,372555.7 6810470.3,372536.2 6810476.9,372518.4 6810483.2,372495.1 6810488.8,372469.7 6810493.6,372441 6810497,372411.3 6810500.3,372377.7 6810502.7,372337.7 6810505.4,372302.4 6810507.7,372269.2 6810510.2,372240.6 6810513.8,372211.4 6810517,372175.8 6810519.8,372136.6 6810521.4,372103.5 6810521.7,372065.2 6810521.3,372029.3 6810519.8,371999.6 6810516.6,371965.5 6810509.6,371934.6 6810500.8,371908.46810492.9,371894.5 6810488.3,371874.6 6810483.6,371861.8 6810480.2,371853.7 6810480,371846.9 6810481,!
 371842.2 6810482.9,371823.6 6810496.3,371797 6810511.9,371769.7 6810528,371742.5 6810544.1,371715.7 6810560.5,371687.7 6810578.9,371658 6810596.4,371629.7 6810612.6,371604.1 6810626.7,371580.7 6810639.6,371558.5 6810653.9,371528 6810670.4,371516.8 6810676.9,371514.7 6810678,371503.9 6810685,371493.4 6810692,371482.6 6810697.6,371473.5 6810702.3,371462.5 6810708.2,371450.7 6810713.5,371440.4 6810719.8,371429.8 6810726.4,371418.8 6810732.6,371407.7 6810739.2,371395 6810745.4,371383.3 6810751.6,371371.6 6810757.9,371361.3 6810764.6,371351.5 6810771,371343.7 6810774.9,371332.4 6810780.4,371325.3 6810784.4,371320.3 6810787.8,371316.4 6810790.1,371307.5 6810794.4,371298.7 6810799.2,371289.4 6810804.4,371279.8 6810809.9,371270.3 6810815.1,371259.3 6810819.4,371252.6 6810822.6,371243.96810828.1,371234.2 6810832.5,371223.6 6810836.2,371213.1 6810839.1,371202.1 6810841.1,371193 6810842.8,371185.4 6810844,371176.3 6810846.3,371167.2 6810849.1,371157.2 6810851.5,371146.3 6810853.3,3711!
 34.2 6810855,371121 6810856.2,371108.5 6810856.8,371098.2 6810856.4,371086.2 6810855.9,371072.1 6810855.1,371058.3 6810853.8,371046.5 6810852.3,371034.7 6810850.2,371026 6810847.1,371018.8 6810843.8,371008.9 6810838.3,370998.1 6810832,370986.9 6810827.2,370972.6 6810822.1,370959.8 6810816.6,370947.2 6810812.2,370939.5 6810809.7,370936.5 6810808.5,370931.1 6810807,370923.8 6810804.8,370912.6 6810803.3,370900.6 6810802,370889.4 6810800.1,370874.5 6810797.9,370859.8 6810795.4,370846.4 6810793.3,370833.8 6810792,370821.9 6810791.5,370819.2 6810791.5,370817.1 6810791.8,370812 6810792.1,370805 6810793.7,370798.9 6810795.4,370790.7 6810798.4,370780.5 6810801.8,370769.7 6810805,370760.86810808.1,370753.1 6810810.8,370744.9 6810812.6,370735.7 6810813.8,370733.4 6810814.2)"
"042822-00"|"MULTILINESTRING((376922.8 6807661.7,376924.5 6807664.2,376927.8 6807668.9,376939.3 6807681.3,376953.4 6807695.7,376964.6 6807707.2,376969.8 6807713.3,376970.8 6807714,376972.7 6807716.5,376981 6807725.9,376986.4 6807731.2,376998.2 6807743.8,377003.6 6807749),(377004.3 6807751.7,377010.5 6807758,377025.9 6807774.1,377035.2 6807783.8,377048.1 6807797.5,377059.8 6807810.7,377071.5 6807822.8,377075.7 6807827.9,377065.1 6807836.2,377046.8 6807851.4,377033.7 6807864,377017.2 6807881.8,376999.6 6807901.5,376981.7 6807921.2,376969.5 6807935.6,376957.3 6807951.4,376946.6 6807964.2,376936 6807977.2,376927.5 6807990.8,376923.6 6808000.9,376922.7 6808007.9,376921.9 6808010.5,376923.7 6808024,376925.3 6808040.1,376926.2 6808058.1,376927.1 6808076.7,376926.9 6808093,376924.2 6808114.7,376918.9 6808134.4,376912.4 6808156.8,376905.2 6808176.8,376897.7 6808196.9,376890 6808213.9,376881.66808231.9,376873 6808249,376865.5 6808266.3,376857.9 6808281.6,376854.2 6808300.3,376853 6808!
 313.1,376854.6 6808330.4,376858.5 6808347.7,376863.8 6808364.2,376865.6 6808373.7,376867.2 6808386.2,376867.8 6808399.7,376866.5 6808420.4,376863.2 6808431.2,376861.3 6808435.9,376856.2 6808444.4,376844.1 6808465.9,376830.5 6808486,376816.8 6808507.5,376803.9 6808529.7,376790.9 6808553.3,376775.9 6808572.7,376773.8 6808574.4),(376771.6 6808579.5,376761.7 6808590,376746.1 6808605.1,376729.5 6808618.2,376711.9 6808626.5,376692.1 6808634.4,376676.6 6808640.4,376654.4 6808646.2,376634.1 6808650.5,376613.9 6808655.6,376588.9 6808663.4,376562.2 6808672.2,376535.2 6808681.2,376510.9 6808688.7,376486.3 6808696.7,376464.3 6808703.9,376445.2 6808712.3,376431.3 6808718.9,376416.3 6808731.1,376409.3 6808737.4,376398.9 6808748.4,376384.1 6808765.6,376368.3 6808780.4,376354 6808798.2,376342.86808812.8,376330.2 6808829.5,376323.5 6808836.1,376319.2 6808842.1,376303.7 6808856.6,376291.6 6808867.6,376275.3 6808877.4,376254 6808887.3,376229.7 6808897.7,376203.6 6808907.6,376177 6808917.5,376!
 153.9 6808927.5,376130.1 6808937.6,376107.3 6808947.1,376085.9 6808955..7,376065.2 6808964.8,376046.3 6808974.1,376026.6 6808983,376014.1 6808989.6,376002.6 6808998.3,375987.9 6809010,375975.1 6809022,375967 6809032.2,375955.9 6809047.3,375944.9 6809061.5,375934.9 6809075,375928.2 6809084.1,375916.9 6809096,375906.1 6809105.5,375898.8 6809111,375890.4 6809116.8,375883.6 6809120.2,375874.7 6809124.6,375863.8 6809128.9,375851.8 6809132.4,375838.3 6809135.5,375824.2 6809137.7,375806.3 6809138.6,375789 6809136.9,375774.9 6809134.3,375758.4 6809129.2,375739.5 6809124.6,375721 6809121.9,375703.7 6809119.5,375690.1 6809118.6,375677.8 6809119.1,375661.2 6809119.9,375630.9 6809122.4,375605.16809126.2,375591.2 6809129.9,375569.4 6809138.1,375545 6809147,375521.1 6809156.6,375497.6 6809166.6,375472.2 6809176.2,375448 6809187,375424 6809199.7,375405.7 6809212.6,375390 6809227.2,375379.5 6809238.3,375365.5 6809256.9,375352 6809275.8,375337.9 6809295.7,375326.3 6809315.2,375315.6 6809334.7,375304.2 6809353.9,375294.1 6809372.7,375282.8 6809392.7,375271 68094!
 13.6,375258 6809435.5,375244.3 6809457,375229.8 6809477.6,375215.3 6809496.7,375200.1 6809515.9,375185.3 6809530.6,375164.1 6809550.7,375142.2 6809570,375127.5 6809583.8,375106.4 6809605,375094.8 6809619.5,375076.9 6809644.2,375058.5 6809669.2,375041.8 6809691.7,375025.1 6809713.8,375008.4 6809735.6,374996.5 6809752,374985.6 6809768.2,374972.1 6809785,374958.2 6809801.7,374945.5 6809814.6,374935.8 6809824.5,374916 6809838.9,374900.8 6809847.3,374877.5 6809857.1,374857.5 6809862.3,374846.1 6809864.6,374831.3 6809867.7,374804.96809873.2,374776.4 6809879.1,374747.2 6809885.1,374715.4 6809891.4,374684 6809898.1,374652.3 6809904.6,374621.9 6809910.8,374593.2 6809916.1,374567.6 6809920.8,374541.8 6809925.3,374517.5 6809930.4),(374508.1 6809931.5,374473.7 6809937.2,374438.5 6809944.5,374410.3 6809955.2,374385.1 6809968.2,374361.7 6809981.7,374359.5 6809982.5,374336.4 6809996.9,374312.1 6810012.1,374295 6810024.7,374287.6 6810027.8,374279.6 6810032.7,374263.2 6810043.8,374238.8 681!
 0059.7,374213.1 6810075.6,374186.4 6810090.8,374161.6 6810106.1,374137.2 6810121.3,374111 6810136.2,374087 6810152.2,374066.4 6810165.1,374043.9 6810181,374021 6810196.3,374003.4 6810209.7,373976.5 6810234.4))"
"042813-00"|"LINESTRING(369778.5 6814503.9,369777.3 6814501.5,369777.3 6814484.3,369776 6814468.3,369773.5 6814454.5,369768.5 6814438.2,369764.3 6814427.9,369756.4 6814414.6,369746.7 6814401,369740.6 6814392.5,369732.1 6814378.6,369726 6814363.5,369724.8 6814357.6,369724.7 6814350.6,369726.1 6814342.9,369728.2 6814333.1,369731.9 6814323,369735.3 6814310.8,369736.7 6814305.7,369736.9 6814301.3,369736.8 6814300.4,369737.3 6814298.3,369737.4 6814296.4,369737.3 6814286.4,369736.1 6814279.5,369733.1 6814268,369729.3 6814252.3,369726.1 6814237.7,369724.4 6814226.2,369724.6 6814218.3,369726.1 6814208.3,369728.2 6814199.7,369730.2 6814194.7,369733 6814188.9,369737.7 6814178.6,369743.1 6814168.1,369748.6 6814156.2,369753.6 6814142,369757.7 6814126.4,369761.1 6814109.7,369764.7 6814093.9,369768.2 6814079.1,369772.1 6814065,369775.4 6814052.9,369777.7 6814045,369778.3 6814043.6)"
"042815-00"|"LINESTRING(372815.6 6812457.4,372826.3 6812461.8,372833.4 6812464.2,372844.9 6812471.1,372853.7 6812477.3,372865.3 6812486.9,372877.1 6812500.9,372889.4 6812516.3,372896.1 6812529,372903.5 6812548.5,372909.7 6812568.6,372915.3 6812583.5,372919.1 6812591.9,372923.8 6812601,372933.5 6812607,372946.1 6812610.2,372962.7 6812610.3,372982.8 6812609.6,372997 6812607.8,373015.3 6812603.9,373033.7 6812600.5,373042.8 6812598.7,373057.8 6812598,373070.7 6812598.7,373080.8 6812600.6,373099.9 6812605.4,373123.4 6812612.1,373145.8 6812619.6,373164.9 6812627.6,373173 6812632.1,373174.9 6812633.8,373176.4 6812636.3,373178.2 6812638.8,373179.6 6812640.8,373182.4 6812649.9,373185.6 6812664.8,373190.2 6812682.5,373192.2 6812687.2,373200.8 6812702.3,373207.2 6812706.5,373217.1 6812713.3,373223.1 6812716.4,373240.4 6812725.1,373264.1 6812738.1,373283.8 6812748.9,373301.3 6812761.2,373322.96812773.1,373335.5 6812782,373348.1 6812791.2,373353 6812794.4,373354.6 6812795.3,373358.2 6812!
 797.6,373362.4 6812800.6,373373.5 6812812.7,373380.1 6812824.3,373382.7 6812834.7,373389.2 6812854.5,373397 6812876.5,373403.5 6812889.8,373415.1 6812906.5,373427.3 6812920.7,373435.5 6812930.9,373439.8 6812939.7,373444.5 6812952.7,373450.4 6812972.6,373452.8 6812988.3,373457 6813004.3,373460.6 6813011.7,373462.9 6813014.6,373467.1 6813018.1,373468.1 6813018.4,373469.9 6813018.7,373474.8 6813020.2,373483.6 6813020.7,373498.4 6813021.6,373521 6813022.8,373546 6813024.5,373571.1 6813026.2,373588.9 6813029.5,373602.6 6813034,373614.6 6813041.5,373624.4 6813050.1,373631.4 6813058.9,373645.6 6813077.9,373659 6813096.5,373666.9 6813103,373677.8 6813108.5,373694.9 6813113.6,373720 6813116.2,373738.8 6813119.6,373751.2 6813125.3,373767.8 6813134.8,373789 6813148.1,373805.8 6813155.1,373820.36813157.3,373842.1 6813157.9,373858.2 6813156.1,373875.5 6813153.3,373896.2 6813150,373904.7 6813149.8,373909.6 6813150.7,373921.7 6813157.4,373930.6 6813165,373941.3 6813176.4,373954.6 6813191.!
 8,373969.7 6813205.4,373984.2 6813218.1,373990.8 6813221,374004.8 6813225.8,374014.2 6813227.8,374030.9 6813229.6,374051.6 6813230,374080.6 6813228,374103.8 6813223.8,374115.4 6813221.7,374132.1 6813216.2,374151.6 6813209.6,374160.6 6813207.2,374171.3 6813206.9,374179.7 6813208.5,374190.4 6813212.8,374203.7 6813220.4,374219.5 6813227,374233.1 6813231.8,374251.1 6813238.1,374261.8 6813241.2,374278.9 6813247,374294.3 6813251.7,374307.1 6813257.4,374327.4 6813268.1,374335.9 6813271.7,374344.8 6813273.4,374356.5 6813273.4,374374.3 6813270.7,374393.9 6813267.7,374405.2 6813271,374409.6 6813273.1)"
"042819-00"|"LINESTRING(372614.9 6808270.7,372601.1 6808274.7,372595.5 6808276.6,372590.4 6808276.7,372587.9 6808275.5,372586.8 6808274.1,372585.8 6808267.3,372583.9 6808261.9,372582.5 6808260,372577.7 6808255.2,372574.5 6808249.8,372570.6 6808238.6,372569.3 6808231.3,372568.7 6808217.1,372570.7 6808202.3,372571 6808188.8,372570.4 6808171.9,372567.2 6808154.9,372564.1 6808138.7,372560 6808124.3,372555.1 6808110.2,372553.5 6808105.7,372549.5 6808100.3,372542.6 6808094.7,372537.2 6808091.6,372529.1 6808087.2,372519.9 6808083,372509.9 6808079.7,372500.1 6808076.5,372489.5 6808073.2,372465.6 6808066.1,372448.3 6808062.3,372436.9 6808059.2,372416.1 6808054.4,372393.9 6808051.3,372375.9 6808048.5,372369.9 6808046.5,372368.9 6808046.2,372353.8 6808041.9,372331 6808034.4,372314.6 6808028.2,372295.8 6808020.1,372279.7 6808012.7,372262.4 6808001.5,372253.9 6807996.7,372235.5 6807987.3,372213.26807978.6,372197.3 6807970.2,372177.7 6807959,372159.5 6807948.7,372146 6807941.6,372131.2 68!
 07931.5,372113.5 6807921.3,372097.7 6807912.9,372085.9 6807905,372082.8 6807902.4,372076.8 6807896.1,372066.1 6807888.1,372050.7 6807876.2,372035.7 6807866.3,372015.9 6807855,371995.4 6807845.1,371978.6 6807835.6,371962.9 6807825.6,371938.4 6807813,371913.5 6807802,371887.1 6807790.5,371861.9 6807779,371849.3 6807773.1,371825.3 6807763.7,371801 6807754.7,371780.8 6807745.7,371766.8 6807737.7,371749.3 6807724.8,371732.4 6807709.9,371718.4 6807698.4,371700 6807683.4,371679.4 6807669.7,371660.9 6807658.2,371645.4 6807646.4,371633.5 6807638.1,371622.3 6807631.6,371606.9 6807625.7,371588.6 6807618.6,371571.1 6807612.7,371550.4 6807607.2,371532.6 6807603.5,371517.2 6807600.6,371498.5 6807601,371471.2 6807604.7,371442.2 6807607.4,371415.7 6807610.2,371403.8 6807612.3)"


2008-12-29 Obe Regina wrote:

>Nicklas,> >Hmm still don't quite understand.  What do these road parts look like?  Do you have geometries at all for them?  Are they line strings or points?> >Perhaps if you provide a sample like  The ST_AsText representation of one that would help us a bit to provide more useful suggestions.> >
If you are trying to make polygons of X width out of road line strings, then I have a function lying around somewhere that will given a linestring -- fatten it up to x thickness (which is pretty much what ST_Buffer(linestring, x/2) would do for you except my function won't create a hot dog - rounded edges), it will create a polygon where the centerline is the original line and edges are perpendicular to the center line.>
 >
Then you can use ST_Intersects to figure out which points fall in the road poly.>
 >
Hope that helps,>
Regina>
 >
 >

>>From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of nicklas.aven at jordogskog.no
>Sent: Monday, December 29, 2008 7:28 AM
>To: PostGIS Users Discussion
>Subject: RE: [postgis-users] Dividing an area to closest line
>
>>
 >
 >
Thanks for the answer.>
My problem is that I just have the roadparts and nothing to relate them to. I would like to create polygons with their borders between the roads so every possible point inside the polygon share the same closest road. But if it isnt possible I will have to build a raster of rectangels or just points and use the method you suggested on them.>
 >
/Nicklas
>
>2008-12-29 Obe Regina wrote:
>
>>>Why wouldn't you use a nearest neighbor calculation as demonstrated here (using DISTINCT ON)?> > > >http://postgis.refractions.net/documentation/manual-svn/ST_DWithin.html> > > >Keep in mind ST_DWithin and  ST_Distance don't care about whether a geometry is a line or polygon or point or collection or whatever.  They will always consider the minimum distance between 2 geometries.> > > >ST_DWithin will use a spatial index where as ST_Distance will not.  So for ST_DWithin to work, you have to make the assumption,> >the closest road to any point is no more than X units away.  The bigger you make the X, the less efficient the index search, but the less likely you will leave a point out.> > > >Hope that helps,> >Regina
>>> >From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of nicklas.aven at jordogskog.no
>>Sent: Monday, December 29, 2008 3:18 AM
>>To: postgis-users at postgis.refractions.net
>>Subject: [postgis-users] Dividing an area to closest line
>>
>>> >
 > >
Hallo> >
 > >
My first time writing here.> >
 > >
The case is that I need to find the closest road from every point in the terrain. The roads are defined in "roadparts". The very best thing would be to get polygons around every roadpart which I could use on other data to bind it to the right road.> >
 > >
The only solution I can see is making a raster of small rektangels that I bind to my roadparts using nearest neighbour-calculations.> >
 > >
My question is if someone has a more efficient and better solution.> >
 > >
Sorry for my bad english> >
 > >
Thanks> >
/Nicklas Avén
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081229/0bd76dca/attachment.html>