kali ini kita mendapat task bagaimana mendapatkan dalam bentuk table operator dan city yang sudah 5G rollout based on data dari Ookla, dari website ookla kita temukan pages yang membuat data tersebut, tetapi data tersebut disajikan dalam bentuk Map.
jika kita liat lagi di dalam data website tersebut masih berbentuk GeoJSON
processGeoJSON({“type”:”FeatureCollection”,”features”:[{“type”:”Feature”,”properties”:{“operator”:”Ooredoo”,”city_name”:”Abdullah al-Salem”,”deployment_type”
Task kita mengkonversikan map tersebut kedalam table
kita dapat mengunakan unix command untuk mendapatkan data tersebut
1step wget https://www.speedtest.net/ookla-5g-map
2step
cat ookla-5g-map | egrep -i ‘processGeoJSON’ | sed -e ‘s/},/\n/g’ -e ‘s/{//g’ -e ‘s/}//g’ -e ‘s/\n”geometry”//g’ -e ‘
s/:/|/g’ -e ‘s/”,”/”|”/g’ -e ‘s/”FeatureCollection|features”|/\n/g’ -e ‘s/\[//g’ -e ‘s/\]//g’ -e ‘s/);//g’| awk -F “|” ‘{print $5 “|”, $7, “|” $11 “|”$16 “|”$16}’ | tail -n+2 | sed -e ‘s/,/ /g’ | sed -e ‘s/|/,/g’ > 5G_ookla.txt
result yang kita dapat
“Optus”, “Canberra” ,”Commercial Availability”,”-35.282″,”-35.282″
“Optus”, “Sydney” ,”Commercial Availability”,”-33.86748″,”-33.86748″
“AT&T Mobility”, “Jacksonville FL” ,”Commercial Availability”,”30.33218″,”30.33218″
“AT&T Mobility”, “Atlanta GA” ,”Commercial Availability”,”33.749″,”33.749″
“AT&T Mobility”, “Indianapolis IN” ,”Commercial Availability”,”39.7684″,”39.7684″
“AT&T Mobility”, “Louisville KY” ,”Commercial Availability”,”38.25266″,”38.25266″
“AT&T Mobility”, “Charlotte NC” ,”Commercial Availability”,”35.22709″,”35.22709″
“AT&T Mobility”, “Raleigh NC” ,”Commercial Availability”,”35.77959″,”35.77959″
“AT&T Mobility”, “Oklahoma City OK” ,”Commercial Availability”,”35.46756″,”35.46756″
“AT&T Mobility”, “Dallas TX” ,”Commercial Availability”,”32.77666″,”32.77666″
“AT&T Mobility”, “Houston TX” ,”Commercial Availability”,”29.76043″,”29.76043″
“AT&T Mobility”, “San Antonio TX” ,”Commercial Availability”,”29.42412″,”29.42412″
“SK Telecom”, “Ullengdo” ,”Commercial Availability”,”37.48442″,”37.48442″
“SK Telecom”, “Dokdo Islands” ,”Commercial Availability”,”37.2401087″,”37.2401087″
“Elisa”, “Tallinn” ,”Limited Availability”,”59.43696″,”59.43696″
“Elisa”, “Tampere” ,”Commercial Availability”,”61.49775″,”61.49775″
“Vodafone”, “A Coruña” ,”Commercial Availability”,”43.36188″,”43.36188″
“Vodafone”, “Al Rayyan” ,”Commercial Availability”,”25.20282″,”25.20282″
“Vodafone”, “Barcelona” ,”Commercial Availability”,”41.388803″,”41.388803″
“Telstra”, “Sydney” ,”Commercial Availability”,”-33.86748″,”-33.86748″
“Telstra”, “Melbourne” ,”Commercial Availability”,”-37.81411″,”-37.81411″
“Telstra”, “Canberra” ,”Commercial Availability”,”-35.282″,”-35.282″
“Telstra”, “Brisbane” ,”Commercial Availability”,”-27.47101″,”-27.47101″
“Telstra”, “Adelaide” ,”Commercial Availability”,”-34.92862″,”-34.92862″
“Telstra”, “Perth” ,”Commercial Availability”,”-31.9536″,”-31.9536″
“Telstra”, “Hobart” ,”Commercial Availability”,”-42.8819″,”-42.8819″
“Telstra”, “Launceston” ,”Commercial Availability”,”-41.43709″,”-41.43709″
“Telstra”, “Toowoomba” ,”Commercial Availability”,”-27.564418″,”-27.564418″
“Telstra”, “Gold Coast” ,”Commercial Availability”,”-28.01726″,”-28.01726″
“Vodacom”, “Lesotho” ,”Limited Availability”,”-29.581352″,”-29.581352″
“Vodafone”, “Bilbao” ,”Commercial Availability”,”43.26301″,”43.26301″
“Vodafone”, “Birgland” ,”Commercial Availability”,”49.43735″,”49.43735″
“Rain”, “Johannesburg” ,”Commercial Availability”,”-26.2041″,”-26.2041″
“Rain”, “Cape Town” ,”Commercial Availability”,”-33.92487″,”-33.92487″
“Vodafone”, “Birkenhead” ,”Commercial Availability”,”53.38999″,”53.38999″
“TIM”, “Bari” ,”Pre-Release”,”41.11714″,”41.11714″
“TIM”, “Matera” ,”Pre-Release”,”40.669227″,”40.669227″
“TIM”, “Turin” ,”Commercial Availability”,”45.07031″,”45.07031″
“TIM”, “Republic of San Marino” ,”Pre-Release”,”43.934521″,”43.934521″
“Verizon Wireless”, “Chicago IL” ,”Commercial Availability”,”41.87811″,”41.87811″
“Verizon Wireless”, “Minneapolis MN” ,”Commercial Availability”,”44.97775″,”44.97775″
“Swisscom”, “Lutzelfluh” ,”Commercial Availability”,”47.00818″,”47.00818″
“Swisscom”, “Bern” ,”Commercial Availability”,”46.94797″,”46.94797″
“Swisscom”, “Davos” ,”Commercial Availability”,”46.80275″,”46.80275″
“Swisscom”, “Geneva” ,”Commercial Availability”,”46.20439″,”46.20439″
“Swisscom”, “Zurich” ,”Commercial Availability”,”47.388023″,”47.388023″
“Swisscom”, “Burgdorf” ,”Commercial Availability”,”47.05594″,”47.05594″
“Swisscom”, “Basel” ,”Commercial Availability”,”47.5596″,”47.5596″
“Swisscom”, “St. Moritz” ,”Commercial Availability”,”46.4908″,”46.4908″
“Swisscom”, “Estavayer-le-lac” ,”Commercial Availability”,”46.84964″,”46.84964″
“Swisscom”, “Adliswil” ,”Commercial Availability”,”47.31243″,”47.31243″
“Swisscom”, “Affoltern” ,”Commercial Availability”,”47.27951″,”47.27951″
“Swisscom”, “Bachenbülach” ,”Commercial Availability”,”47.5033″,”47.5033″
“Swisscom”, “Balsthal” ,”Commercial Availability”,”47.30959″,”47.30959″
“Swisscom”, “Belp” ,”Commercial Availability”,”46.89142″,”46.89142″
“Swisscom”, “Binningen” ,”Commercial Availability”,”47.53787″,”47.53787″
“Swisscom”, “Braunwald” ,”Commercial Availability”,”46.940213″,”46.940213″
“Swisscom”, “Brunnen” ,”Commercial Availability”,”46.999031″,”46.999031″
“Swisscom”, “Buchillon” ,”Commercial Availability”,”46.46938″,”46.46938″
“Swisscom”, “Champéry” ,”Commercial Availability”,”46.18165″,”46.18165″
“Swisscom”, “Chur” ,”Commercial Availability”,”46.85078″,”46.85078″
“Swisscom”, “Cossonay” ,”Commercial Availability”,”46.61409″,”46.61409″
“Swisscom”, “Courtepin” ,”Commercial Availability”,”46.86531″,”46.86531″
“Swisscom”, “Dietikon” ,”Commercial Availability”,”47.40539″,”47.40539″
“Swisscom”, “Domat/Ems” ,”Commercial Availability”,”46.83364″,”46.83364″
“Swisscom”, “Ecublens (VD)” ,”Commercial Availability”,”46.52964″,”46.52964″
“Swisscom”, “Freienbach” ,”Commercial Availability”,”47.20212″,”47.20212″
“Swisscom”, “Glarus” ,”Commercial Availability”,”47.04112″,”47.04112″
“Swisscom”, “Glattbrugg” ,”Commercial Availability”,”47.434048″,”47.434048″
“Swisscom”, “Horgen” ,”Commercial Availability”,”47.26074″,”47.26074″
“Swisscom”, “Ittigen” ,”Commercial Availability”,”46.97614″,”46.97614″
“Swisscom”, “Langenthal” ,”Commercial Availability”,”47.21208″,”47.21208″
“Swisscom”, “Lyssach” ,”Commercial Availability”,”47.06552″,”47.06552″