excel datos topografia123

5
AI PTO DESCRIPCION HS HM HI ANG. HORIZ ANG. VERTI DI DH DV ANGULO AZIMUT ° ' " ° ' " 1.34 E1 ESTACION A 0 0 0 1 Inicio de cuneta 1.500 1.360 1.220 181 56 53 90 35 4 28 27.9970867 -0.28559362 181.948056 181.94 2 esquina de cuneta 1.500 1.355 1.210 169 4 43 90 36 20 29 28.9967607 -0.30647639 169.078611 169.07 3 esquina de pabellón 2.100 1.965 1.830 172 26 56 88 34 18 27 26.983224 0.6728074 172.448889 172.448 4 esquina de pabellón frontal 1.700 1.622 1.543 164 5 23 88 48 39 15.7 15.693238 0.32575795 164.089722 164.089 5 límite de cuneta 1.600 1.535 1.470 189 27 41 90 55 20 13 12.9966323 -0.20920945 189.461389 189.46 6 árbol 2.100 2.065 2.029 205 9 53 87 38 4 7.1 7.08790426 0.2928028 205.164722 205.164 7 esquina puente 0.800 0.685 0.570 346 54 0 92 24 38 23 22.9593125 -0.96651754 346.9 346.9 8 esquina puente 1.700 1.570 1.440 329 27 48 89 40 27 26 25.9991592 0.14785529 329.463333 329.463 9 esquina puente 2.200 2.055 1.910 332 34 40 88 52 40 29 28.9888762 0.56786245 332.577778 332.577 10 esquina puente 1.200 1.070 0.940 347 53 32 91 7 40 26 25.9899279 -0.51163715 347.892222 347.89 11poste 2.500 2.352 2.203 353 15 17 88 23 6 29.7 29.6764093 0.83671255 353.254722 353.254 E2E2 2.000 1.582 1.163 95 6 32 89 50 46 83.7 83.6993962 0.22480605 95.1088889 95.1088 1.39 12 p oste 2.900 2.733 2.565 230 16 40 86 58 40 33.5 33.4068786 1.76377306 230.277778 145.386 13 poste adera 1.100 0.968 0.835 257 27 30 90 26 49 26.5 26.4983875 -0.2067089 257.458333 172.567 14 esquina pabellón 0.800 0.675 0.550 280 3 31 90 38 15 25 24.9969052 -0.27813889 280.058611 195.16 15 esquina pabellón 1.100 1.033 0.965 89 56 17 89 48 10 13.5 13.49984 0.04646902 89.9380556 5.04694 16 cuneta 1.300 1.240 1.180 292 46 14 90 1 37 12 11.9999973 -0.00564323 292.770556 207.87 17 borde de calle 1.800 1.675 1.550 219 45 25 89 15 2 25 24.9957229 0.32696953 219.756944 134.865 18 filo de r!o " calle 1.400 1.373 1.345 212 29 33 90 3 34 5.5 5.49999408 -0.00570625 212.4925 127.601 19 poste doble 1.100 1.073 1.045 346 34 16 89 46 37 5.5 5.49991664 0.02141158 346.571111 261.6 20 poste 2.000 1.780 1.560 37 37 2 90 4 17 44 43.9999317 -0.05482267 37.6172222 312.72 21 borde de r!o 1.100 0.948 0.795 44 15 18 91 40 56 30.5 30.4737157 -0.89497512 44.255 319.363 E3E3 1.900 1.493 1.085 34 14 18 89 54 38 81.5 81.4998014 0.12722945 34.2383333 309.347 1.38 E2 E2 1.450 1.040 0.630 0 0 0 90 14 34 82 81.9985277 -0.34745211 0 129.347 22 borde de r!o 1.100 0.990 0.880 323 23 11 93 20 11 22 21.9254857 -1.27818736 323.386389 452.73 23 borde de calle 1.000 0.918 0.835 333 22 41 93 27 34 16.5 16.4399209 -0.99382897 333.378056 462.72 24 poste 1.100 1.052 1.003 252 16 50 93 27 36 9.7 9.66466943 -0.58434434 252.280556 381.62 25 borde de r!o 1.200 1.073 0.945 227 49 26 93 40 36 25.5 25.3951406 -1.6318451 227.823889 357.171 26 poste 1.300 1.113 0.925 208 11 58 92 10 20 37.5 37.4461251 -1.42035417 208.199444 337.54 27 intersección de calle 2.000 1.780 1.560 204 4 22 90 38 53 44 43.9943712 -0.4976285 204.072778 333.4

Upload: darlin-chavez

Post on 06-Oct-2015

212 views

Category:

Documents


0 download

DESCRIPTION

topogrfia

TRANSCRIPT

GAVINETEAIPTODESCRIPCIONHSHMHIANG. HORIZANG. VERTIDIDHDVANGULOAZIMUTXYX(ESTE)Y(NORTE)COTA '" '"1.34E1ESTACION A000815831.009241180.002613.001Inicio de cuneta 1.5001.3601.2201815653903542827.9970867069-0.2855936242181.9480555556181.9480555556-0.9517170961-27.9809059654815830.059241152.022,612.6942esquina de cuneta1.5001.3551.2101694439036202928.9967607494-0.3064763852169.0786111111169.07861111115.493784326-28.4715729762815836.499241151.532,612.6793esquina de pabelln2.1001.9651.83017226568834182726.98322402870.6728073961172.4488888889172.44888888893.5458807332-26.7492263217815834.559241153.252,613.0484esquina de pabelln frontal1.7001.6221.54316452388483915.715.6932379640.3257579481164.0897222222164.08972222224.302014511-15.0920637734815835.309241164.912,613.0445lmite de cuneta1.6001.5351.47018927419055201312.9966323128-0.2092094464189.4613888889189.4613888889-2.1364243623-12.8198339466815828.869241167.182,612.5966rbol2.1002.0652.029205953873847.17.08790425540.2928028205.1647222222205.1647222222-3.0139335092-6.4151844506815827.999241173.582,612.5687esquina puente0.8000.6850.5703465409224382322.9593125377-0.9665175438346.9346.9-5.203758204522.361818637815825.809241202.362,612.6888esquina puente1.7001.5701.44032927488940272625.99915915790.1478552886329.4633333333329.4633333333-13.209903990722.3931845318815817.799241202.392,612.9189esquina puente2.2002.0551.91033234408852402928.98887615510.5678624501332.5777777778332.5777777778-13.350655594725.7315941194815817.659241205.732,612.85310esquina puente1.2001.0700.9403475332917402625.9899279225-0.5116371462347.8922222222347.8922222222-5.451420984825.4117760627815825.559241205.412,612.75811poste2.5002.3522.20335315178823629.729.67640927880.8367125532353.2547222222353.2547222222-3.485658974429.4709933528815827.519241209.472,612.825E2E22.0001.5821.1639563289504683.783.69939619920.224806053195.108888888995.108888888983.3668804549-7.4533326323815914.379241172.552,612.9831.3912poste2.9002.7332.565230164086584033.533.40687859681.7637730613230.2777777778145.386666666718.9762857114-27.4940014945815933.349241145.052,613.40513poste madera1.1000.9680.835257273090264926.526.4983875031-0.2067088957257.4583333333172.56722222223.4279080103-26.2757299982815917.799241146.272,613.19914esquina pabelln0.8000.6750.5502803319038152524.9969051671-0.2781388928280.0586111111195.1675-6.5402339687-24.1261395082815907.839241148.422,613.42015esquina pabelln1.1001.0330.96589561789481013.513.49984004480.046469024389.93805555565.04694444441.18760699313.4475005434815915.559241185.992,613.38716cuneta1.3001.2401.1802924614901371211.9999973462-0.0056432304292.7705555556207.8794444444-5.6113514293-10.6071990386815908.769241161.942,613.12817borde de calle1.8001.6751.5502194525891522524.99572290530.32696953219.7569444444134.865833333317.7159845056-17.6332089127815932.089241154.912,613.02518filo de ro y calle1.4001.3731.3452122933903345.55.4999940798-0.0057062529212.4925127.60138888894.3575069999-3.3559004192815918.729241169.192,612.99519poste doble1.1001.0731.04534634168946375.55.49991664310.0214115799346.5711111111261.68-5.4420318848-0.7958467484815908.929241171.752,613.32220poste2.0001.7801.56037372904174443.9999316925-0.054822674337.6172222222312.7261111111-32.322590264429.8537124583815882.049241202.402,612.53821borde de ro1.1000.9480.79544151891405630.530.4737156942-0.894975117944.255319.3638888889-19.846087328223.1253143973815894.529241195.672,612.531E3E31.9001.4931.08534141889543881.581.49980138190.127229447634.2383333333309.3472222222-63.025257296551.6723772242815851.349241224.222,613.0081.38E2E21.4501.0400.6300009014348281.9985277422-0.34745211010129.347222222263.4109313306-51.988578935815914.759241172.232,613.0022borde de ro1.1000.9900.88032323119320112221.9254856671-1.2781873641323.3863888889452.733611111121.9005359836-1.0456793812815873.249241223.172,612.1223borde de calle1.0000.9180.835333224193273416.516.4399208771-0.9938289726333.3780555556462.725277777816.0361146163-3.6213293772815867.389241220.602,612.4824poste1.1001.0521.00325216509327369.79.664669427-0.5843443406252.2805555556381.62777777783.56215821868.98425645815854.909241233.202,612.7525borde de ro1.2001.0730.945227492693403625.525.3951406312-1.6318450963227.8238888889357.1711111111-1.253335716925.3641936055815850.099241249.582,611.6826poste1.3001.1130.925208115892102037.537.4461251071-1.4203541734208.1994444444337.5466666667-14.301829180434.6073686899815837.049241258.832,611.8627interseccin de calle2.0001.7801.5602044229038534443.9943712318-0.4976284957204.0727777778333.42-19.685146866639.3446272434815831.669241263.562,612.1128esquina de puente2.4002.1451.890202256910275150.9842322306-0.896608953202.0488888889331.3961111111-24.408775055644.7616312977815826.939241268.982,611.3529esquina de puente2.8002.5052.21019922299029445958.9955865256-0.5102700396199.3747222222328.7219444444-30.630025565750.4210349293815820.719241274.642,611.3730esquina de puente2.3001.9981.6952023259133460.560.4793168354-1.1184380477202.0569444444331.4041666667-28.947094939253.1019157795815822.399241277.322,611.2731esquina de puente1.9501.6781.405204403891202754.554.470158438-1.2749410218204.6772222222334.0244444444-23.857256633448.9676369267815827.489241273.192,611.4432filo de dos ros2.1001.8231.545206381990595055.555.483189224-0.9657719521206.6386111111335.9858333333-22.579577910750.6808341274815828.769241274.902,611.6033filo de ro1.8001.6501.5001785429121253029.9831764003-0.7102288059178.095307.4422222222-23.805647202618.2286046729815827.549241242.452,612.0334filo de ro1.9501.8281.705143342191141524.524.4885726981-0.528997461143.5725272.9197222222-24.45678366631.247367423815826.889241225.472,612.03E1E12.5002.2552.010752019885774948.98360652640.896109067175.3386111111204.6858333333-20.4576323551-44.5070667058815830.889241179.712,613.03

EXPORTAR LANDPUNTONORTEESTE COTA DESCRIPCIONE19241180.00815831.002613.0019241152.02815830.052612.69Inicio de cuneta 29241151.53815836.492612.68esquina de cuneta39241153.25815834.552613.05esquina de pabelln49241164.91815835.302613.04esquina de pabelln frontal59241167.18815828.862612.60lmite de cuneta69241173.58815827.992612.57rbol79241202.36815825.802612.69esquina puente89241202.39815817.792612.92esquina puente99241205.73815817.652612.85esquina puente109241205.41815825.552612.76esquina puente119241209.47815827.512612.83posteE2ERROR:#REF!E29241172.55815914.372612.98E2129241145.05815933.342613.40poste139241146.27815917.792613.20poste madera149241148.42815907.832613.42esquina pabelln159241185.99815915.552613.39esquina pabelln169241161.94815908.762613.13cuneta179241154.91815932.082613.03borde de calle189241169.19815918.722613.00filo de ro y calle199241171.75815908.922613.32poste doble209241202.40815882.042612.54poste219241195.67815894.522612.53borde de roE39241224.22815851.342613.01E3E29241172.23815914.752613.00E2229241223.17815873.242612.12borde de ro239241220.60815867.382612.48borde de calle249241233.20815854.902612.75poste259241249.58815850.092611.68borde de ro269241258.83815837.042611.86poste279241263.56815831.662612.11interseccin de calle289241268.98815826.932611.35esquina de puente299241274.64815820.712611.37esquina de puente309241277.32815822.392611.27esquina de puente319241273.19815827.482611.44esquina de puente329241274.90815828.762611.60filo de dos ros339241242.45815827.542612.03filo de ro349241225.47815826.882612.03filo de roE19241179.71815830.882613.03E1