Hello, I have a set of data with XYZ coordinates. I want to make a line from start to the end, but some points are missing Z data. The Question is. is there a tool or a script where Point to Line will stop at a point with now data and continue from the next one with full XYZ?
I don't want this interpolation to cover the point without full XYZ data.
Any help is welcomed!
Sounds like you will need to investigate some python / arcpy magic.
If you can post an example of your data here maybe someone can get you started.
Other info required : what version are you using and what is the coordinate system of the data?
A quick search revealed thing like this :
So we use CRS - EPSG 3334: Pulkovo 1942(58) GaussKruger Zone 4 and ArcGIS 10.2.
Want I'm looking for is a line that will break each time there is a gap.
Example of data:
4675861.031307 5618099.962198 3 1910.000000
4675853.056280 5618066.666666 3 1910.000000
4675847.638880 5618033.333332 3 1910.000000
4675843.301398 5618000.000000 3 1910.000000
4675843.283591 5617966.666666 3 1910.000000
4675844.345703 5617933.333332 3 1910.000000
4675846.066287 5617898.412698 3 1910.000000
4675850.420755 5617857.142855 3 1910.000000
4675855.433695 5617814.285711 3 1910.000000
4675860.446635 5617771.428569 3 1910.000000
4675865.459575 5617728.571422 3 1910.000000
4675870.472515 5617685.714281 3
4675875.485454 5617642.857140 3
4675879.855671 5617601.587301 3
4675881.654998 5617566.666666 3
4675882.811602 5617533.333332 3
4675879.110538 5617500.560425 3
4675855.978803 5617470.029219 3
4675827.989401 5617440.058438 3
4675797.998233 5617413.826022 3
4675759.999999 5617402.547054 3
4675719.999998 5617395.006448 3 1910.000000
4675679.999996 5617387.465843 3 1910.000000
4675639.999998 5617379.925237 3 1910.000000
4675601.111111 5617370.819957 3 1910.000000
4675566.666666 5617355.455974 3 1910.000000
4675533.333332 5617338.527315 3 1910.000000
4675501.676855 5617320.820324 3 1910.000000
4675476.343842 5617297.791666 3 1910.000000
4675451.151864 5617265.151339 3 1910.000000
4675425.575931 5617230.302678 3 1910.000000
4675401.374914 5617194.227510 3 1910.000000
4675382.673555 5617153.246301 3 1910.000000
4675365.347110 5617111.038583 3 1910.000000
4675348.020665 5617068.830866 3 1910.000000
4675330.694219 5617026.623145 3 1910.000000
4675313.367775 5616984.415429 3 1910.000000
4675296.041332 5616942.207715 3 1910.000000
4675279.548798 5616901.479063 3 1910.000000
4675266.391902 5616866.666666 3 1910.000000
4675254.068916 5616833.333332 3 1910.000000
4675242.543566 5616800.000000 3 1910.000000
4675234.208755 5616766.666666 3 1910.000000
4675226.671580 5616733.333332 3 1910.000000
4675220.169602 5616700.000000 3 1910.000000
4675217.808417 5616666.666666 3 1910.000000
4675216.482430 5616633.333332 3 1910.000000
4675216.112474 5616600.000000 3 1910.000000
4675219.566643 5616566.666666 3 1910.000000
4675223.976845 5616533.333332 3 1910.000000
4675229.122009 5616500.000000 3 1910.000000
4675237.207029 5616466.666666 3 1910.000000
4675246.027012 5616433.333332 3 1910.000000
4675255.935049 5616398.888888 3 1910.000000
4675270.195303 5616359.999999 3 1910.000000
4675285.543612 5616319.999998 3 1910.000000
4675300.891921 5616279.999996 3 1910.000000
4675316.240229 5616239.999998 3 1910.000000
4675332.369078 5616200.000000 3 1910.000000
4675351.620092 5616159.999999 3 1910.000000
4675371.651648 5616119.999998 3 1910.000000
4675391.683204 5616079.999996 3 1910.000000
4675411.714759 5616039.999998 3 1910.000000
4675431.683900 5616001.111111 3 1910.000000
4675451.403393 5615966.666666 3 1910.000000
4675471.060473 5615933.333332 3 1910.000000
4675489.489442 5615900.000000 3 1910.000000
4675503.005975 5615866.666666 3 1910.000000
4675515.294398 5615833.333332 3 1910.000000
4675526.229056 5615800.000000 3 1910.000000
4675531.748657 5615766.666666 3 1910.000000
4675535.914493 5615733.333332 3 1910.000000
4675536.045996 5615702.858389 3 1910.000000
4675520.040165 5615683.817002 3 1910.000000
4675497.784472 5615672.589763 3 1910.000000
4675466.666666 5615681.185554 3 1910.000000
4675433.333332 5615694.737103 3 1910.000000
4675400.000000 5615708.909266 3 1910.000000
4675366.666666 5615725.563890 3 1910.000000
4675333.333332 5615742.839129 3 1910.000000
4675300.000000 5615759.120167 3 1910.000000
4675266.666666 5615771.424402 3 1910.000000
4675233.333332 5615782.734436 3 1910.000000
4675198.888888 5615793.009371 3 1910.000000
4675159.999999 5615799.143914 3 1910.000000
4675119.999998 5615804.243359 3 1910.000000
4675079.999996 5615809.342804 3 1910.000000
4675039.999998 5615814.442249 3 1910.000000
4675001.111111 5615819.949444 3 1910.000000
4674966.666666 5615827.087641 3 1910.000000
4674933.333332 5615834.633588 3 1910.000000
4674900.000000 5615843.137671 3 1910.000000
4674866.666666 5615855.474298 3 1910.000000
4674833.333332 5615868.769062 3 1910.000000
4674800.000000 5615882.796145 3 1910.000000
4674766.666666 5615899.752507 3 1910.000000
4674733.333332 5615917.441188 3 1910.000000
4674698.888888 5615936.089238 3 1910.000000
4674659.999999 5615958.574765 3 1910.000000
4674619.999998 5615982.019662 3 1910.000000
4674579.999996 5616005.464559 3 1910.000000
4674539.999998 5616028.909454 3 1910.000000
4674501.111111 5616051.908847 3 1910.000000
4674466.666666 5616073.126235 3 1910.000000
4674433.333332 5616093.898121 3 1910.000000
4674399.310697 5616115.620644 3 1910.000000
4674362.530850 5616141.145720 3 1910.000000
4674325.061700 5616167.621434 3 1910.000000
4674287.592551 5616194.097148 3 1910.000000
4674250.123400 5616220.572863 3 1910.000000
4674212.654252 5616247.048576 3 1910.000000
4674175.185105 5616273.524288 3 1910.000000
4674137.357595 5616299.724439 3 1910.000000
4674098.096631 5616324.822345 3 1910.000000
4674058.477304 5616349.644689 3 1910.000000
4674018.857978 5616374.467033 3 1910.000000
4673979.238651 5616399.289378 3 1910.000000
4673939.619329 5616424.111719 3 1910.000000
4673901.047666 5616448.874553 3 1910.000000
4673866.666666 5616473.399345 3 1910.000000
4673833.333332 5616497.864626 3 1910.000000
4673799.572039 5616523.187639 3 1910.000000
4673764.098905 5616551.941588 3 1910.000000
4673728.197811 5616581.553271 3 1910.000000
4673692.296718 5616611.164953 3 1910.000000
4673656.395623 5616640.776637 3 1910.000000
4673620.494534 5616670.388316 3 1910.000000
4673585.877319 5616699.755266 3 1910.000000
4673556.395624 5616728.143285 3 1910.000000
4673528.197811 5616756.286570 3 1910.000000
4673501.260988 5616782.334330 3 1910.000000
4673479.590593 5616802.960531 3 1910.000000
4673460.071083 5616833.333334 3 1910.000000
4673424.693184 5616894.444445 3 1910.000000
4673421.477012 5616900.000000 3 1910.000000
4672078.516609 5617421.483391 4 1910.000000
4672071.973558 5617420.993796 4 1910.000000
4672039.258305 5617418.545821 4 1910.000000
4672000.987495 5617415.309105 4 1910.000000
4671966.666666 5617410.875804 4 1910.000000
4671933.333332 5617406.143356 4 1910.000000
4671898.888888 5617401.851812 4 1910.000000
4671859.999999 5617399.323883 4 1910.000000
4671819.999998 5617397.236858 4 1910.000000
4671779.999996 5617395.149832 4 1910.000000
4671739.999998 5617393.062807 4 1910.000000
4671701.111111 5617390.247574 4 1910.000000
4671666.666666 5617384.519513 4 1910.000000
4671633.333332 5617378.063244 4 1910.000000
4671600.000000 5617370.548590 4 1910.000000
4671566.666666 5617358.800393 4 1910.000000
4671533.333332 5617345.993811 4 1910.000000
4671501.100989 5617332.556057 4 1910.000000
4671473.272603 5617316.593615 4 1910.000000
4671447.121005 5617300.110669 4 1910.000000
4671423.272603 5617284.070396 4 1910.000000
4671398.323211 5617265.955561 4 1910.000000
4671366.666666 5617239.099799 4 1910.000000
4671333.333332 5617210.058805 4 1910.000000
4671300.000000 5617181.672452 4 1910.000000
4671266.666666 5617155.904659 4 1910.000000
4671233.333332 5617130.791507 4 1910.000000
4671200.000000 5617108.094212 4 1910.000000
4671166.666666 5617095.060346 4 1910.000000
4671133.333332 5617084.442336 4 1910.000000
4671100.000000 5617076.368332 4 1910.000000
4671066.666666 5617078.470347 4 1910.000000
4671033.333332 5617083.116367 4 1910.000000
4670999.584003 5617090.369633 4 1910.000000
4670934.312930 5617124.959795 4 1910.000000
4670928.341378 5617128.341378 4 1910.000000
4673433.333332 5616662.328534 6 1900.000000
4673400.000000 5616679.755018 6 1900.000000
4673366.666666 5616695.804349 6 1900.000000
4673333.333332 5616711.509391 6 1900.000000
4673300.000000 5616726.985075 6 1900.000000
4673266.666666 5616741.543334 6 1900.000000
4673233.333332 5616755.872236 6 1900.000000
4673198.584687 5616770.296225 6 1900.000000
4673158.174788 5616785.100568 6 1900.000000
4673116.856580 5616800.884234 6 1900.000000
4673077.566383 5616820.204836 6 1900.000000
4673038.783190 5616840.409672 6 1900.000000
4672999.797198 5616857.866748 6 1900.000000
4672959.999999 5616864.332789 6 1900.000000
4672919.999998 5616868.051071 6
4672879.999996 5616871.769354 6
4672839.999998 5616875.487636 6
4672800.444579 5616879.741432 6
4672762.667476 5616886.137279 6
4672725.334952 5616893.068640 6
4672687.583426 5616903.011440 6
4672648.155883 5616925.000000 6
4672608.309336 5616950.000000 6 1900.000000
4672568.462788 5616975.000000 6 1900.000000
4672530.487959 5616999.730591 6 1900.000000
4672499.302296 5617022.678638 6 1900.000000
4672467.197536 5617042.537657 6 1900.000000
4672434.395073 5617061.691772 6 1900.000000
4672401.592609 5617080.845886 6 1900.000000
4672368.524711 5617100.804293 6 1900.000000
4672334.395073 5617123.979874 6 1900.000000
4672300.176956 5617146.730372 6 1900.000000
4672266.666666 5617164.563363 6 1900.000000
4672233.333332 5617181.166977 6 1900.000000
4672200.000000 5617196.990103 6 1900.000000
4672166.666666 5617209.691279 6 1900.000000
4672133.333332 5617221.611968 6 1900.000000
4672100.000000 5617233.124893 6 1900.000000
4672066.666666 5617243.006772 6 1900.000000
4672033.333332 5617252.480888 6 1900.000000
4672000.000000 5617261.557468 6 1900.000000
4671966.666666 5617269.043905 6 1900.000000
4671933.333332 5617276.132805 6 1900.000000
4671900.000000 5617282.659168 6 1900.000000
4671866.666666 5617286.935379 6 1900.000000
4671833.333332 5617290.649051 6 1900.000000
4671800.000000 5617293.619651 6 1900.000000
4671766.666666 5617293.617962 6 1900.000000
4671733.333332 5617292.873201 6 1900.000000
4671700.000000 5617291.053893 6 1900.000000
4671666.666666 5617284.936396 6 1900.000000
4671633.333332 5617277.744352 6 1900.000000
4671600.000000 5617269.068481 6 1900.000000
4671566.666666 5617254.457303 6 1900.000000
4671533.333332 5617238.362297 6 1900.000000
4671500.000000 5617220.525378 6 1900.000000
4671466.666666 5617195.720803 6 1900.000000
4671433.333332 5617169.174313 6 1900.000000
4671400.000000 5617142.067362 6 1900.000000
4671366.666666 5617112.718557 6 1900.000000
4671333.333332 5617082.809289 6 1900.000000
4671300.000000 5617054.474169 6 1900.000000
4671266.666666 5617032.435629 6 1900.000000
4671233.333332 5617011.971235 6 1900.000000
4671200.000000 5616993.680466 6 1900.000000
4671166.666666 5616984.084188 6 1900.000000
4671133.333332 5616976.661533 6 1900.000000
4671100.000000 5616970.837478 6 1900.000000
4671066.666666 5616971.407822 6 1900.000000
4671033.333332 5616973.576766 6 1900.000000
4671000.107933 5616977.405410 6 1900.000000
4670967.314269 5616987.872855 6 1900.000000
4670934.304737 5617000.857477 6 1900.000000
4670901.602712 5617017.118626 6 1900.000000
4670854.144180 5617047.250180 6 1900.000000
4670849.975469 5617049.975469 6 1900.000000
4673565.057103 5616441.307141 8 1890.000000
4673530.114206 5616460.871428 8 1890.000000
4673495.171308 5616480.435714 8 1890.000000
4673458.547469 5616500.085993 8 1890.000000
4673415.199860 5616520.080246 8 1890.000000
4673370.171308 5616540.160492 8 1890.000000
4673325.142757 5616560.240737 8 1890.000000
4673280.114206 5616580.320983 8 1890.000000
4673235.085654 5616600.401229 8 1890.000000
4673190.057103 5616620.481475 8 1890.000000
4673145.028551 5616640.561721 8 1890.000000
4673100.838092 5616659.836233 8 1890.000000
4673059.999999 5616675.887814 8 1890.000000
4673019.999998 5616691.133661 8 1890.000000
4672979.999996 5616706.379508 8 1890.000000
4672939.999998 5616721.625354 8 1890.000000
4672900.000000 5616736.288158 8 1890.000000
4672859.999999 5616748.618794 8 1890.000000
4672819.999998 5616760.366388 8 1890.000000
4672779.999996 5616772.113982 8 1890.000000
4672739.999998 5616783.861576 8 1890.000000
4672701.111111 5616795.994504 8 1890.000000
4672666.666666 5616809.668772 8 1890.000000
4672633.333332 5616823.728375 8 1890.000000
4672598.726504 5616838.900934 8 1890.000000
4672559.025694 5616858.525319 8 1890.000000
4672518.051388 5616879.262660 8 1890.000000
4672477.483045 5616900.778073 8 1890.000000
4672438.538542 5616925.405779 8 1890.000000
4672399.756424 5616950.576591 8 1890.000000
4672359.999999 5616974.807535 8 1890.000000
4672319.999998 5616998.803513 8 1890.000000
4672279.999996 5617022.799490 8 1890.000000
4672239.999998 5617046.795466 8 1890.000000
4672201.111111 5617069.512824 8 1890.000000
4672166.666666 5617087.115715 8
4672133.333332 5617103.439988 8
4672100.000000 5617119.277480 8
4672066.666666 5617133.167852 8
4672033.333332 5617146.571445 8
4672000.000000 5617159.302551 8
4671966.666666 5617169.343717 8
4671933.333332 5617178.712398 8 1890.000000
4671900.000000 5617187.367826 8 1890.000000
4671866.666666 5617193.170249 8 1890.000000
4671833.333332 5617198.259420 8 1890.000000
4671800.000000 5617202.326518 8 1890.000000
4671766.666666 5617202.305320 8 1890.000000
4671733.333332 5617201.262050 8 1890.000000
4671700.000000 5617198.776049 8 1890.000000
4671666.666666 5617190.519129 8 1890.000000
Why not creating two lines? One line with the full data, one erase line with the data without z information? Then erase the no data line area?
Is that 3rd column (3, 4, 6, 8 etc) a line identifier?
So line 3 would become 2 pieces but the same line ie multipart.