zakarov de 570932058.

xlsx

A B C D E F G H I J K
1
2
3 parametros del elipsoide PROVISIONAL SOUTH AMERICAN 1956 BOLIVIA
4
5 semieje mayor a: 6,378,388.000 a2 = 40683833478544
6 semieje menor b: 6,356,911.946 b2 = 40410329489197.5
7 achatamiento polar α 0.003367003 f= 296.999998230594
8 primera excentricidad e2: 0.00672267006 e= 0.08199189022285
9 segunda excentricidad e'2: 0.00676817024 e' = 0.08226888985364
10 1-e2 = 0.99327732993768
11
12
13 1. sistemas de coordenadas espaciales rectangulares X, Y, Z
14 D M S posicion grados rad tan cos
15 longitud geodesica λ = 10 5 8W 10.0856 0.1760266 0.177867
16 h (altura sobre elipsoide) = 400 m.s.n.m.
17 latitud geodesica Ф = 16.0 0.0 0.00 N 16.0000 0.2792533 0.2867461 0.9613
18 latitud geografica φ' = 16.0 6.0 9.70 W 16.1027 0.2810457 0.288687 16.10270
19
20 N = a/(1-e2*sin(Ф)2)1/2 seno Ф = 0.2756379835 sen λ = 0.1751189
21 normal mayor N = 6,380,017.55 seno2 Ф = 0.075976298 cos λ = 0.9845473
22 normal menor n = 6,337,126.80 (1-e2*sen2 Ф) = 0.9994892364 r = 0.9997446
23 (1-e2) = 0.9932773299
24 radio curvatura elipse meridiana = ρ = a*(1-e2) /(1-e2*sin(f)2)3/2 6,340,365.22
25 radio medio = Rm = (N * ρ)1/2 6,360,160.48
26 radio del paralelo punto : x = N cos φ 6,132,865.34
27
28 X=(N+h)*cos(Ф)*cos(λ) 6,038,474.50 cos Ф = 0.9612615159
29 Y=(N+h)*cos(Ф)*sin(λ) 1,074,048.15 cos2 Ф = 0.924023702
30 Z=((1- e2 )*N+h)*sin(λ) 1,109,820.91
31
32
33
34 2. Conversion de coordenadas cartesianas a geodesicas
35
36
37
38
39
40
41
42
43
44
45
46 2. sistema de coordenadas cartesianas x,y relacionadas con el plano del meridiano del punto dado
47
48
49
50
51
52
53 3. sistema de coordenadas geodesicas

file:///conversion/tmp/activity_task_scratch/570932058.xlsx 1 de 8
 A B C D E F G H I J K L M N
1
2
3
4 PSAD56

5 CALCULO DE UNA POLIGONAL DE COORDENADAS UTM OBTENIDAS DEL PLANO Y PROYECTADAS EN EL TERRENO
6

7 1 2 3 4 5 6 7 8 1-8
8
9 X 387,400.00 387,750.81 388,212.90 388,697.58 388,523.39 388,829.84 388,370.97 388,266.94 866.94
10 Y 7,899,200.00 7,900,023.39 7,901,626.61 7,902,100.81 7,903,309.68 7,904,491.13 7,905,315.32 7,906,801.61 7,601.61
11 longitud -64.0698 -64.06638 -64.0619 -64.0573 -64.0589 -64.0559 -64.0602 -64.0611
12 yk latitud -18.9967 -18.9892 -18.9748 -18.9705 -18.9596 -18.9489 -18.9415 -18.928
13 huso 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00

14 longitud Mc -63.00 -63.00 -63.00 -63.00 -63.00 -63.00 -63.00 -63.00

15
16 ΔX = 350.81 462.09 484.68 -174.19 306.45 -458.87 -104.03 866.94
17 ΔY = 823.39 1,603.22 474.20 1,208.87 1,181.45 824.19 1,486.29 7,601.61
18 ΔX2 1.23E+05 2.14E+05 2.35E+05 3.03E+04 9.39E+04 2.11E+05 1.08E+04
19 ΔY2 = 6.78E+05 2.57E+06 2.25E+05 1.46E+06 1.40E+06 6.79E+05 2.21E+06
20 ΔX2 + Δ Y2 = 8.01E+05 2.78E+06 4.60E+05 1.49E+06 1.49E+06 8.90E+05 2.22E+06
21 distancia cuadricula = 895.01 1,668.48 678.07 1,221.36 1,220.55 943.32 1,489.93 8,116.7114 99.969% 2.49

22
23 K UTM = 0.999755 0.999754 0.999754 0.999751 0.999752 0.999751 0.999752 0.999750
24 K_UTM por tramo = 0.999754 0.999754 0.999752 0.999752 0.999751 0.999752 0.999751
25
26 distancia tramo elipsoide = 894.79 1,668.07 677.90 1,221.05 1,220.24 943.08 1,489.56 8,114.7009 99.945% 4.50

27
28 latitud geografica = -18.996700 -18.989200 -18.974800 -18.970500 -18.959600 -18.948900 -18.941500 -18.928000
29 radio de curvatura 6,343,031.36 6,343,036.62 6,343,046.73 6,343,049.75 6,343,057.41 6,343,064.93 6,343,070.12 6,343,079.61
30 altitud = 3,340.00 3,270.00 3,740.00 3,770.00 3,431.43 3,400.00 3,460.00 3,520.00
31 ondulacion geoide = 24.50 24.50 24.50 24.50 24.50 24.50 24.50 24.50
32 altura elipsoidal = 3,364.50 3,294.50 3,764.50 3,794.50 3,455.93 3,424.50 3,484.50 3,544.50
33 factor de elevacion = 1.000530 1.000519 1.000593 1.000598 1.000545 1.000540 1.000549 1.000559
34 factor de elevacion medio = 1.000525 1.000556 1.000596 1.000572 1.000542 1.000545 1.000554

35 distancia terreno = 895.26 1,669.00 678.31 1,221.75 1,220.91 943.60 1,490.38 8,119.2013 100.000%

36
37
38 distancia cuadricula = 8,116.711
39 distancia tramo elipsoide = 8,114.701
40 longitud terreno = 8,119.201
41
42 factor UTM poligonal : 1.0002478 Dc/De
43 factur de escala poligonal : 1.0005546 Dt/De
44 factor combinado : 1.0003068 Dt/Dc
45
46
47
48
49 PERFIL X-Y
50
7,908,000.00
51
52
53 7,906,000.00
54
55 7,904,000.00
56
57 7,902,000.00 PERFIL X-Y
58
59
7,900,000.00
60
61
62 7,898,000.00
63
64 7,896,000.00
65
66 7,894,000.00
67 387,000.00 388,000.00 389,000.00
68
69
70
71
72
Perfil Z-X
73 3,900.00
74
75 3,800.00
76
77 3,700.00
78
79 3,600.00
80
3,500.00 Perfil Z-X
81
82
3,400.00
83
84 3,300.00
85
86 3,200.00
87
88 3,100.00
89
90 3,000.00
91 387,000.00 387,500.00 388,000.00 388,500.00 389,000.00
92
93
94
95
Perfil Z-Y
96 3,900.00
97
98 3,800.00
99
100 3,700.00
101
102 3,600.00
103
3,500.00 Perfil Z-Y
104
105 3,400.00
106
107 3,300.00
108
109 3,200.00
110
111 3,100.00
112
3,000.00
113
7,898,000.00 7,899,000.00 7,900,000.00 7,901,000.00 7,902,000.00 7,903,000.00 7,904,000.00 7,905,000.00 7,906,000.00 7,907,000.00 7,908,000.00
114
115

file:///conversion/tmp/activity_task_scratch/570932058.xlsx 01/17/2022 de 15:12:03

 7,906,801.61
7,905,315.32
7,903,309.68

7,904,491.13
7,902,100.81
7,901,626.61
7,900,023.39
7,899,200.00
8,395,000.00

7,895,000.00

7,395,000.00

6,895,000.00
Y UTM

6,395,000.00

y UTM

5,895,000.00

5,395,000.00

4,895,000.00

4,395,000.00
387,400.00 387,750.81 388,212.90 388,697.58 388,523.39 388,829.84 388,370.97 388,266.94

X UTM
 A B C D E F G H
1
2
3 parametros elipsoidales
4
5 a = semieje mayor 6371000 m.
6 b = semieje menor 6351000 m.
7 f = achatamiento polar 0.00313922461152
8 e2 = primera excentricidad 0.00626859449188
9 e´2 = segunda excentricidad 0.0063081376488
10 e´4 = 3.9792600596E-05
11 e´6 = 2.5101720196E-07
12 n = termino auxiliar 0.00157207986166
13
14 datos del punto geografico
15
16 φ = latitud 30.20278 gra sur
17 λ = longitud 16.25972 gra oeste
18 huso = 28
19 φ´ = latitud del punto de union perpendicular
20 hasta el meridiano central
21 λo = longitud de origen del meridiano central 15.00000 gra 15 0 0
22 de proyeccion
23 Δλ = λ - λo 0.021986 rad
24 k = factor de escala del punto de proyeccion
25 ko = factor de escala del meridiano central 0.9996000
26 FN = falso norte hemisferio 10,000,000.00 m.
27 FE = falso este en el meridiano central 500,000.00 m.
28 N = coordenada norte
29 E = coordenada este
30
31 elevacion sobre el nivel del mar
32 altura geodica
33 hA = altura del elipsoide 150
34 ρ = radio de curvatura del meridiano (M) 6,346,158.18 m.
35 υ = radio de curvatura de la primera vertical (N) 6,376,059.52 m.
36 Rm = radio medio de la tierra 6,361,091.28 m.
37 S = longitud del arco del meridiano desde el ecuador 3,353,180.24 m.
38
39 ecuaciones generales de calculo
40
41 E = -379,455.59 m -18,984.45 5.00%
42 S = -6,647,490.91 m 4,648.36 -0.07%
43 ΔE = 120,544.41 m.
44
45
46 aproximado
47 E = -360,471.13 m.
48 S = -6,652,139.27 m.
49
50 factor de escala de la cuadricula kh = 0.99977963374
51 factor de correccion elipsoidal ke = 0.99997642
52 factor de escala combinado k = kh * ke = 0.99975605863

file:///conversion/tmp/activity_task_scratch/570932058.xlsx 4 de 8
 A B C D E F G H I J K L
1
2
3
4 eje huso grado
5 dato φ= λ= T1 = 3,351,838.97 3,351,838.97 3 1 177
6 D 30 16 T2 = 1,386,066.13 670.02 9 2 171
7 M 12 15 T3 = 405,643.93 0.09 15 3 165
8 S 10 35 T4 = 91,131.26 0.00 21 4 159
9 rumbo sur oeste T5 = 11,261.78 0.00 3,352,509.09 27 5 153
10 radianes 0.5271391481 0.2837863519 T6 = 5,482,472.04 120,539.56 33 6 147
11 T7 = 456,615.19 4.85 39 7 141
12 seno 0.503062912606 0.2799925529 T8 = -25,856.94 0.00 45 8 135
13 coseno 0.864249793729 0.960002172 T9 = -36,791.49 0.00 120,544.41 51 9 129
14 tangente 0.58208045435 0.2916582494 57 10 123
15 T29 = 0.00 0.0001797 63 11 117
16 seno2 0.253072294039 0.0783958297 T30 = 0.000 0.0000000 69 12 111
17 coseno2 0.746927705961 0.9216041703 75 13 105
18 tangente2 0.338817655336 0.0850645345 81 14 99
19 87 15 93
20 seno3 0.127311285339 0.0219502485 93 16 87
21 coseno3 0.645532115807 0.8847420052 99 17 81
22 tangente3 0.19721913476 0.0248097732 105 18 75
23 111 19 69
24 seno4 0.06404558601 0.0061459061 117 20 63
25 coseno4 0.557900997932 0.8493542467 123 21 57
26 tangente4 0.114797403568 0.007235975 129 22 51
27 135 23 45
28 seno5 0.032218959038 0.0017208079 141 24 39
29 coseno5 0.482165822384 0.8153819217 147 25 33
30 tangente5 0.066821324827 0.0021104318 153 26 27
31 159 27 21
32 seno6 0.016208163375 0.0004818134 165 28 15
33 coseno6 0.416711712538 0.7827684158 171 29 9
34 tangente6 0.038895387116 0.0006155248 177 30 3
35
36 seno7 0.008153725875 0.0001349042
37 coseno7 0.360143011606 0.7514593794
38 tangente7 0.022640244604 0.0001795229

file:///conversion/tmp/activity_task_scratch/570932058.xlsx 5 de 8
 coticchia de 570932058.xlsx

A B C D E F G H I J K
1
2
3 ECUACIONES DE COTICCHIA - SURACE
4
5 CONVERSION DE COORDENADAS GEOGRAFICAS A UTM (PROBLEMA DIRECTO)
6
7 1.- CALCULOS PREVIOS
8
9 1.a.- sobre la geometria del elipsoide
10
11 datos elipsoide: Hayford
12 semieje mayor a: 6,378,388.000 a2 = 40683833478544
13 semieje menor b: 6,356,911.946 b2 = 40410329489198
14 achatamiento polar α 0.003367003 f= 296.99999823059
15 primera excentricidad e2: 0.0067226700623 e= 0.0819918902229
16 segunda excentricidad e'2: 0.0067681702378 e' = 0.0822688898536
17 radio polar de curvatura c : 6,399,936.61 metros
18
19 1.b.- sobre la longitud y latitud
20
21 D M S posicion grados rad tan cos
22 longitud geodesica λ = 0 0 0 W 0.0000 0.0000000 0.000000
23 h (altura sobre elipsoide) = 400 m.s.n.m.
24 latitud geodesica Ф = 16.0 0.0 0.00 N 16.0000 0.2792533 0.28674609247 0.9613
25 latitud geografica φ' =
26
27 calculo del signo de la longitud:
28 al oeste del meridiano de Greenwich se toma negativa
29 al este del meridiano de Greenwich se toma positiva
30
31 1.c.- sobre el huso
32 huso = 31 longitud = 0.00
33
34 calculo del meridiano central del huso : λo = 3 grados
35
36 desplazamiento del punto a calcular con respecto al merdiano central del huso :
37 Δλ = λ - λo igual a -3.0000 grados = -0.05236 radianes
38
39 2.- ECUACIONES DE COTICCHIA - SURACE PARA EL PASO DE GEOGRAFICAS A UTM (PROBLEMA DIRECTO)
40
41 2.a.- Calculo de parametros
42
43 seno Δλ = -0.052336078515 A = -0.050308658172 J2 = 0.54421351924
44 coseno Δλ = 0.9986295283465 ξ = -0.050351165827

file:///conversion/tmp/activity_task_scratch/570932058.xlsx
 coticchia de 570932058.xlsx

A B C D E F G H I J K
45 η = 0.0003636 J4 = 0.54064023238
46 ν = 6,377,465.54
47 J6 = 1.0518858896
48 ζ = 7.927631431E-06
49 α = 0.00507612768
50
51 A1 = 0.52992037181 β = 4.294512E-05
52 A2 = 0.48965898374
53 γ = 1.695516E-07
54
55 Bo = 1,768,963.41
56
57
58 2.b.- calculo final de coordenadas UTM :
59
60 X = 178,886.33 metros
61
62 ΔY = 1,771,282.15 metros
63 Y = 8,228,717.85 metros
64
65
66 CONVERSION DE UTM A COORDENADAS GEOGRAFICAS (PROBLEMA INVERSO)
67
68 1.- CALCULOS PREVIOS
69 1.a.- sobre la geometria del elipsoide
70 escentricidad e = 0.0819918902229 e2 = 0.0067226700623
71 radio polar de curvatura = 6,399,936.61
72 segunda excentridicdad e' = 0.0822688898536 e'2 = 0.0067681702378
73
74 1.b.- tratamiento previo de X e Y y calculo del merdiano central:
75 X = -321,113.67 metros
76 Y = 1,771,282.15 metros por estar al sur se resta de 10,000,000 metros
77
78 calculo del meridiano central del huso en el que caen las coordenadas UTM: λo = 3.00 grados
79
80
81 2.- ecuaciones de coticchia - surace para el paso de UTM a geograficas:
82
83 2.a.- calculo de parametros:
84 φ = 0.2783437 seno φ = 0.27476346138
85 X = -321,113.67 metros coseno φ = 0.96151185135
86 Y = 1,771,282.15
87 ν = 6,167,257.33
88
89 a = -0.0520675004

file:///conversion/tmp/activity_task_scratch/570932058.xlsx
 coticchia de 570932058.xlsx

A B C D E F G H I J K
90
91 A1 = 0.52837664887 α = 0.00507612768
92 A2 = 0.48848687505
93 β = 4.294512E-05
94 J2 = 0.5425320112
95 J4 = 0.52902072716 γ = 1.695516E-07
96 J6 = 1.03223740464
97 Bφ = 1,756,845.44
98
99 b = 0.0023408629 eξ = 0.94926491017
100
101 ζ = 8.48172172E-06 e-ξ = 1.05344671365
102
103 ξ = -0.05206735319
104
105 η = 0.28068452982 coseno η = 0.96086603948
106
107 seno hξ = -0.05209090174
108
109
110 Δλ = -0.05415943312 igual a= -3.10320 grados
111
112 τ = 0.28029420639
113
114 2.b.- calculo final de coordenadas geograficas
115
116 longitud: λ = -0.10 grados
117 latitud: φ = 0.28030637406 radianes 16.060 grados

file:///conversion/tmp/activity_task_scratch/570932058.xlsx