Pangani mapu osankhidwa ndi ma Fusiontables - mu mphindi 10
Tiyerekeze kuti tikufuna kulingalira pamapu, zotsatira za zisankho zamatauni, kuti athe kusefedwa ndi chipani chandale ndikugawana ndi anthu. Ngakhale pali njira zochepa zochitira zinthu, ndikufuna kuwonetsa chitsanzo kuti ndifotokozere momwe zingachitikire ndi FusionTables ndi wogwiritsa ntchito wamba.
Zimene tili nazo:
Chotsatira cha Supreme Electoral Tribunal, komwe mungathe kuona mndandanda wa ma municipalities.
http://siede.tse.hn/escrutinio/alcadias_municipales.php
Minute 1. Mangani tebulo
Izi zimachitika pakukopera ndikulemba patebulo lomwe likupezeka ndi Supreme Electoral Tribunal kupita ku Excel. Kukopera kwapadera kumagwiritsidwa ntchito, zolemba zokha ndipo popeza palibe chiwonetsero cha dziko, ndikofunikira kusefa ku lililonse la madipatimenti 18. Ubwino ndi Chrome ndikuti kusankha kumapangidwa, ngakhale titasintha fyuluta kuti tizichita Ctrl + C.
Timachoka mutu pamzere woyamba.
Popeza tebulo lilibe mgwirizano, ndikofunikira kuyiyika pogwiritsa ntchito geocode. Kuti tichite izi, tithandizanso pazolowera kuti Google isasokonezedwe posaka malowa; tikufuna kuti mufufuze boma, dipatimenti, dziko.
Mu gawo F, tidzagwiritsa ntchito fomu ya concatenate monga iyi: = CONCATENATE (Chigawo cha Township",",Dipatimenti Yachigawo",","Pais"), tikuphatikizanso ma comma pakati pa mawu kuti tiwonetsetse kuti chingwecho chikuwoneka momwe timayembekezera. Chifukwa chake gawo la mzere 2 likuwoneka motere:
=CONCATENATE(B2,",A2,","honduras") ndipo chifukwa chake mzerewu udzakhala: Central District, Francisco Morazán, Honduras
Tidzatcha mutu wa gawoli E "Concatenate"
Minute 5. Momwe mungayikitsire ku FusionTables
Maofesi a Fusion aikidwa musakatuli wa Google Chrome, ndipo mukaitcha kuti mupange pepala latsopano kuchokera kulumikizana uku, gululi liyenera kuoneka.
Mukhoza kusankha pepala likupezeka mu Google Spreadsheets, pangani chopanda kanthu kapena muyike zomwe tili nazo pa kompyuta.
Mukasankha, sankhani batani "Kenako". Idzatifunsa ngati dzina la mizati liri pamzere woyamba, ndiyeno timachita "Kenako" ndiyeno idzatifunsa dzina lomwe timapereka patebulo ndi mafotokozedwe ena omwe angasinthidwenso pambuyo pake.
Minute 7. Momwe mungapangire tebulo
Kuchokera pa tabu ya Fayilo, njira ya "Geocode ..." yasankhidwa ndipo imatifunsa kuti ndi gawo liti lomwe lili ndi geocode. Tikuwonetsa gawo lomwe tafotokoza kale.
Ngati sitinapange gawo lophatikizana, tikadatanthauzira mizinda, koma chifukwa pali mayina ambiri omwe abwerezedwa m'maiko ambiri, tikadapeza malo amwazikana kunja kwa Honduras. Komanso m'dziko lomwelo muli ma municipalities omwe ali ndi dzina lomwelo, mwachitsanzo "San Marcos", ngati sitinagwirizane ndi dipatimentiyi tikanakhalanso ndi vuto.
Pali njira yotchedwa "ad location hint", yomwe pakadali pano sikofunikira chifukwa unyolo wonse uli kale ndi chidziwitso mpaka dziko.
Dongosololi limayamba kupeza malo aliwonse kutengera momwe tafotokozera. Pansipa zikuwonetsa mu lalanje kuchuluka kwa zidziwitso zosamveka, zomwe zimachitika ndi malo omwe Google sanadziwebe mumndandanda wake; Kwa ine 298, ndi 6 okha omwe anali osokoneza; Nthawi zambiri Google imaziyika kudziko lina chifukwa zimakhalako kwina.
Minute 10, kumeneko iwo ali nayo
Ngati mfundo sinali bwino, imasinthidwa mu "Row" njira, podina kawiri pamunda ndi "edit geocode" ulalo, kukonza kusaka ndikuwonetsa malo omwe amathetsa kusamveka bwino. Ngati kulibe, mutha kuwonetsa malo apafupi omwe timawawona mu ma tag a Google.
Mukusankha zosefera, ndizotheka kuwonjezera mapanelo kuti atatsegulidwe, kuwerengera komanso kuwerengera machesi, ndi dipatimenti, ndi maboma ... etc.
Apa mutha kuwona chitsanzo. Ilibe chidziwitso chomaliza chifukwa ndidazichita ndi zidziwitso zomwe zimakonzedwa, komanso kumenya nawo matebulo ena ophatikizika ndi nambala yamatauni ndi tawuni kuchokera pagome lina ... koma monga chitsanzo pali ulalo. Sindinakonzenso mkati mwa zolakwika zoyambira ndikuyembekeza kuti mphindi 10 zakwanira.
Zochita zina:
Mutha kuphatikiza matebulo, kusintha mwachindunji, kusindikiza ndi zinthu zina zofunika. Kuti muchite zambiri, pali API.
Inde, izi zimachitika mwa mfundo.
Ngati tikufuna kugwiritsa ntchito mawonekedwe azizolowera, mutha kugwiritsa ntchito ntchito ya Shapescape (mwachiyembekezo sikuli pansi) ... ngakhale mukufuna zoposa 10 mphindi.
