Dala imephu yokhetho ngama-Fusiontables - ngemizuzu eyi-10
Ake sithi sifuna ukucabanga ebalazweni, ngemiphumela yokhetho lomasipala, ukuze bahlungwe yiqembu lezepolitiki futhi kwabelwane ngalo nomphakathi. Ngenkathi kunezindlela ezimbalwa zokukwenza, ngifuna ukukhombisa isibonelo ukuze ngichaze ukuthi singenziwa kanjani nge-FusionTables ngumsebenzisi ojwayelekile.
Lokho esinakho:
Umphumela oshicilelwe we-Supreme Electoral Tribunal, lapho ungabona khona uhlu lomasipala.
http://siede.tse.hn/escrutinio/alcadias_municipales.php
Iminithi 1. Yakha itafula
Lokhu kwenziwa ngokukopisha nokunamathisela etafuleni elitholwa yiSupreme Electoral Tribunal liye ku-Excel. Ukukopisha okukhethekile kusetshenzisiwe, umbhalo kuphela futhi njengoba kungekho mbukiso wezwe, kuyadingeka ukuhlunga komunye weminyango eyi-18. Inzuzo nge-Chrome ukuthi ukukhetha kuyenziwa, noma ngabe siguqula isihlungi ukuze kube kufanele ukuthi senze iCtrl + C.
Sishiya isihloko esizodwa emgqeni wokuqala.
Njengoba itafula lingenakho ukuxhumanisa, kuzodingeka ukulikhetha ngokusebenzisa i-geocode. Ukuze senze lokhu, sizohlanganisa amakholomu ukuze iGoogle ingadideki lapho ifuna izindawo; sidinga ukuthi useshe umasipala, umnyango, izwe.
Kwikholamu F, sizosebenzisa ifomula ye-concatenate enjengale: = CONCATENATE (Ikholomu kamasipala, ","Umnyango wekholomu, ",","Izwe"), siphinde sihlanganise okhefana phakathi kwezingcaphuno ukuze siqinisekise ukuthi uchungechunge lubukeka ngendlela elindelekile. Ngakho ikholomu kumugqa wesi-2 izobukeka kanje:
=CONCATENATE(B2,”,,A2,”,”,”honduras”) futhi ngenxa yalokho lowo mugqa uzoba: Central District, Francisco Morazán, Honduras
Sizobiza unhlokweni wale kholomu E “Concatenate”
Iminithi 5. Ungayilayisha kanjani ku-FusionTables
Ama-FusionTables afakwe kwisiphequluli se-Google Chrome, futhi uma ebiza ukudala ishidi elisha kusuka kulesi sixhumanisi, le phaneli kufanele ivele.
Ungakhetha ishidi elitholakalayo kuma-Google Spreadsheets, udale kungenalutho noma ulayishe lokho esinakho kukhompyutha.
Uma usukhethiwe, khetha inkinobho ethi "Okulandelayo". Izosibuza ukuthi ingabe igama lamakholomu likumugqa wokuqala, bese senza okuthi “Okulandelayo” bese izosibuza ukuthi yiliphi igama esilinika ithebula nezincazelo ezithile ezingahle zihlelwe kamuva.
Iminithi 7. Ungayibheka kanjani ithebula ngokufanele
Kuthebhu ethi Ifayela, inketho ethi “Geocode…” ikhethiwe futhi iyasibuza ukuthi iyiphi ikholomu equkethe i-geocode. Sikhombisa ikholomu esiyichazile ngaphambilini.
Ukube asizange sidale ikholomu ehlanganisiwe, besingakwazi ukuchaza umasipala, kodwa ngenxa yokuthi kunamagama amaningi aphindaphindiwe emazweni amaningi, ngabe sithole amaphuzu ahlakazekile ngaphandle kweHonduras. Nakuleli zwe kukhona omasipala abanegama elifanayo, isibonelo “iSan Marcos”, ukube asihlanganisanga umnyango ngabe nathi sinalobo bunzima.
Kukhona inketho ebizwa ngokuthi "ukusikisela kwendawo yesikhangiso", okungadingeki kulesi simo ngoba lonke uchungechunge vele luqukethe ulwazi kuze kufike ezingeni lezwe.
Uhlelo luqala ukuthola indawo ngayinye ngokuya ngemibandela esiyichazile. Ngezansi kukhombisa ku-orange iphesenti lemininingwane engaqondakali, evame ukwenzeka ngezindawo i-Google engakazikhombi ku-database yayo; Endabeni yami engu-298, bangu-6 kuphela ababedidanisa; imvamisa i-Google ibabeka kwelinye izwe ngoba akhona kwenye indawo.
I-Minute 10, khona-ke unayo
Uma iphoyinti belingekho endaweni, lihlelwa kunketho ethi "Umugqa", ngokuchofoza kabili enkundleni nakusixhumanisi "sokuhlela i-geocode", ukuthuthukisa ukusesha nokubonisa indawo exazulula ukungaqondakali. Uma ingekho, ungabonisa indawo eseduze esiyibona kumathegi e-Google.
Ngokukhethwa kokuhlunga, kungenzeka ukwengeza amaphaneli wokuvula, ukuvala nokubala ngokulinganisa, ngomnyango, ngomasipala ... njll.
Lapha ungabona isibonelo. Ayinayo imininingwane yokugcina ngoba ngiyenze ngolwazi ebisacutshungulwa, futhi ngidlala ngamatafula athile ahlangana nekhodi lendawo nomasipala kusuka kwelinye ithebula ... kepha njengesibonelo kukhona isixhumanisi. Angizange futhi ngilungise ukulungiswa kwangaphakathi kwephutha lokuqala futhi ngethemba ukuthi imizuzu eyi-10 yanele.
Ezinye izici:
Ungahlanganisa amatafula, uhlele ngqo, ushicilele nezinye izinto eziyisisekelo. Ukwenza okuningi, kune-API.
Yiqiniso, lokhu kwenziwa ngamaphuzu.
Uma besifuna ukusebenzisa amajamo wekholomu ungasebenzisa insizakalo yeShapescape (ngethemba lokuthi alikho phansi) ... yize ufuna imizuzu engu-10.