Faz a requisição do link, processa o json e o retorna como Dataframe
Type
Details
link
str
Link para a requisição das estações VOR do GEOAISWEB
cols
List
Subconjunto de Colunas relevantes do DataFrame
Returns
DataFrame
get_geodf(LINK_VOR, COLS_VOR)
Frequency
Latitude
Longitude
Description
0
116.8
-16.245367
-48.979089
[AISG] VOR - ANÁPOLIS CH 101X
1
117.0
-19.689048
-47.060575
[AISG] VOR - ARAXÁ
2
113.4
-9.868361
-56.104951
[AISG] VOR - ALTA FLORESTA CH 81X
OPR INFRAERO
3
116.2
-22.951451
-46.569805
[AISG] VOR - BRAGANÇA CH 109X
4
114.3
-12.079940
-45.007135
[AISG] VOR - BARREIRAS CH 90X
...
...
...
...
...
74
112.1
-25.583203
-54.503514
[AISG] VOR - FOZ CH 58X
75
115.3
-31.390714
-54.109717
[AISG] VOR - BAGÉ U/S BTN RDL 275/305
76
116.9
-23.627464
-46.654635
[AISG] VOR - CONGONHAS CH 116X \nVOR/DME NO AV...
77
115.9
-14.799000
-64.938333
[AISG] VOR - TRINIDAD-BL See Bolivia AIP
78
115.9
-25.244167
-57.522000
[AISG] VOR - ASUNCION VDVAS See Paraguay AIP
79 rows × 4 columns
get_geodf(LINK_NDB, COLS_NDB)
Frequency
Latitude
Longitude
Description
0
0.2650
-21.139333
-50.426667
[AISG] NDB - ARAÇATUBA OPR TAM
1
0.3000
-25.402667
-49.229000
[AISG] NDB - BACACHERI FM ARP, COVERAGE 50NM
2
0.3800
-22.314000
-49.107167
[AISG] NDB - BAURU COVERAGE 50NM
OPR INFRAERO
3
0.2300
-7.266000
-35.892667
[AISG] NDB - CAMPINA GRANDE COVERAGE 60NM
OPR ...
4
0.4200
-20.813167
-49.406167
[AISG] NDB - RIO PRETO OPR DAESP
5
0.4070
-4.194997
-69.939733
[AISG] NDB - LETÍCIA OPR COLÔMBIA
6
0.2500
-29.694722
-57.148056
[AISG] NDB - PASO DE LOS LIBRES OPR ARGENTINA
7
0.2950
-19.658900
-43.896933
[AISG] NDB - LAGOA SANTA COVERAGE 50NM
8
0.3750
-19.016219
-57.664456
[AISG] NDB - CORUMBÁ
9
0.2050
-5.386167
-35.531000
[AISG] NDB - MAXARANGUAPE
10
0.4100
-3.142825
-59.993747
[AISG] NDB - PELADA COVERAGE 70NM
11
0.3000
-17.217111
-46.933821
[AISG] NDB - PARACATU COVERAGE 65NM
12
0.2050
-1.486333
-56.397833
[AISG] NDB - TROMBETAS COVERAGE 100NM; OPR MIN...
13
0.4300
-23.045636
-45.516708
[AISG] NDB - TAUBATÉ COVERAGE 25NM; OPR COMAND...
14
0.3550
-4.886500
-65.349833
[AISG] NDB - URUCU OPR PETROBRAS
15
0.2850
-22.197333
-54.928333
[AISG] NDB - DOURA COVERAGE 70NM
16
0.2750
-22.787975
-45.215286
[AISG] NDB - GUARATINGUETÁ COVERAGE 50NM
17
0.3400
-22.168889
-49.069722
[AISG] NDB - AREALVA
18
0.1143
-32.340056
-54.223889
[AISG] NDB - MELO
19
0.2800
-28.678850
-49.066714
[AISG] NDB - JAGUARUNA COVERAGE 30NM. Other HR...
20
0.2850
-21.267053
-43.764111
[AISG] NDB - BARBACENA COVERAGE 60NM
21
0.3400
3.860144
-51.800131
[AISG] NDB - OIAPOQUE COVERAGE 70NM
22
0.2900
-17.724656
-48.610410
[AISG] NDB - CALDAS NOVAS OPR CALDAS NOVAS CIT...
23
0.4000
-10.784333
-65.281167
[AISG] NDB - GUAJARÁ-MIRIM
24
0.2000
-22.923333
-42.071500
[AISG] NDB - CABO FRIO OPR COSTA DO SOL OPERAD...
25
0.2400
2.219028
-55.941800
[AISG] NDB - TIRIÓS COVERANGE 50NM
26
0.4150
-22.194833
-49.929333
[AISG] NDB - MARÍLIA OPR PANTANAL LINHAS AÉREAS.
27
0.3200
-7.140500
-34.952500
[AISG] NDB - JOAO PESSOA Coverage 40NM
OPR INF...
28
0.3850
-16.441667
-39.082500
[AISG] NDB - PORTO SEGURO COVERAGE 27 NM
29
0.2300
-4.249333
-69.936167
[AISG] NDB - TABATINGA COVERAGE 50NM
30
0.2750
-29.786014
-57.036586
[AISG] NDB - URUGUAIANA COVERAGE 100NM
31
0.2800
-28.279311
-54.171944
[AISG] NDB - SANTO ÂNGELO OPR RIO SUL.
32
0.2250
-25.408667
-54.621667
[AISG] NDB - ITAIPU
33
0.3400
-22.550075
-55.707161
[AISG] NDB - PONTA PORÃ OPR INFRAERO
34
0.2950
-3.256500
-52.250833
[AISG] NDB - ALTAMIRA OPR NAV Brasil
35
0.4100
-23.462189
-46.573404
[AISG] NDB - TUCA OPR NAV Brasil
36
0.3100
-16.703383
-43.819108
[AISG] NDB - MONTES CLAROS COVERAGE 50NM
OPR N...
37
0.4150
-22.870108
-43.165119
[AISG] NDB - PAIOL OPR NAV Brasil
38
0.3300
-21.142667
-47.776000
[AISG] NDB - RIBEIRÃO COVERAGE 50NM
OPR NAV Br...
39
0.2350
-19.765500
-47.959167
[AISG] NDB - UBERABA COVERAGE 50NM
OPR NAV Brasil
40
0.2500
-4.240500
-56.004667
[AISG] NDB - ITAITUBA OPR NAV Brasil
41
1.6180
-19.463000
-42.479500
[AISG] NDB - IPATINGA OPR INFRAERO
42
0.3000
-29.996308
-50.145006
[AISG] NDB - TRAMANDAÍ OPR MAR
43
0.3300
-16.335333
-58.387167
[AISG] NDB - SAN MATIAS OPR BOLÍVIA
get_geodf(LINK_DME, COLS_DME)
C:\Users\rsilva\AppData\Local\Temp\2\ipykernel_7420\3107854738.py:9: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
df["Channel"] = df[cols[0]].astype("int").astype("string") + df[cols[1]]
C:\Users\rsilva\AppData\Local\Temp\2\ipykernel_7420\3107854738.py:10: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
df["Frequency"] = -1.0