Gadzira mepu yesarudzo neFusiontables - mumaminitsi gumi
Ngatitii isu tinoda kufungisisa pamepu, mhedzisiro yesarudzo yemanisiparati, kuitira kuti vagogona kusefetwa nebato rezvematongerwo enyika uye kugovaniswa neruzhinji. Kunyange paine dzimwe nzira shoma dzekuzviita, ini ndoda kuratidza iwo muenzaniso kutsanangura maitirwo azvo neFusionTables nemunhuwo zvake mushandisi.
Zvatinazvo:
Nyaya yakabudiswa ye Supreme Electoral Tribunal, uko iwe unogona kuona urongwa nemasisita.
http://siede.tse.hn/escrutinio/alcadias_municipales.php
Minute 1. Vaka tafura
Izvi zvinoitwa nekukopa uye kunamatira kubva patafura inowanikwa neSupreme Electoral Tribunal kuExcel. Kukopa kwakakosha kunoshandiswa, zvinyorwa chete uye sezvo pasina nyika inoratidzira, zvinodikanwa kusefa kune yega yega madhipatimendi gumi nemasere. Kubatsira neChannel ndechekuti sarudzo inoitwa, kunyangwe tikachinja firita kuti isu tingove tichiita Ctrl + C.
Tinosiya musoro uri woga mumutsara wokutanga.
Sezvo tafura isina kurongeka, zvichave zvakafanira kuitisa iyo geocode. Kuti tiite izvi, tichabatanidza makoramu kuitira kuti Google irege kuvhiringidzika kana ichitsvaga nzvimbo; isu tinoda kuti iwe utsvage maseru, dhipatimendi, nyika.
Muchikamu F, isu tinoshandisa iyo concatenate fomula seiyi: = CONCATENATE (Column of municipality, ","Dhipatimendi Column, ",","Nyika"), isu tiri kubatanidza makoma pakati pemakotesheni kuti tive nechokwadi chekuti tambo inotaridzika sezvaitarisirwa. Saka iyo column mumutsara 2 yaizotaridzika seizvi:
=CONCATENATE(B2,”,,A2,”,”,”honduras”) uye somugumisiro mutsara uyu waizova: Central District, Francisco Morazán, Honduras
Tichadaidza musoro wekoramu iyi E "Concatenate"
Mineti 5. Maitiro ekuisa iyo kuFusionTables
FusionTables inowanikwa muGoogle Chrome browser, uye kana ichiidza iyo kuti ugadzire pepa itsva kubva pano, iyo mapuranga inofanira kuonekwa.
Iwe unogona kusarudza pepa iripo paGoogle Spreadsheets, ita chisina chinhu kana kuisa icho chatinacho pane kombiyuta.
Kana yangosarudzwa, sarudza bhatani re "Next". Ichatibvunza kana zita remakoramu riri mumutsara wekutanga, tobva taita "Inotevera" uye yobva yatibvunza kuti nderipi zita ratinopa patafura uye dzimwe tsananguro dzinogona kugadziridzwa gare gare.
Minute 7. Maitiro ekugadzirisa tafura
Kubva paFaira tebhu, iyo "Geocode ..." sarudzo inosarudzwa uye inotibvunza kuti ndeipi koramu ine geocode. Tinoratidza mbiru yatakatsanangura kare.
Dai tisina kugadzira koramu yakabatana, tingadai takatsanangura kanzuru, asi nekuti kune mazita akawanda anodzokororwa munyika dzakawanda, tingadai takawana mapoinzi akapararira kunze kweHonduras. Zvakare mukati menyika imwe chete mune makanzuru ane zita rimwe chete, semuenzaniso "San Marcos", dai tisina kusanganisa dhipatimendi tingadai takaomerwawo nazvo.
Pane imwe sarudzo inonzi "ad location hint", iyo munyaya iyi haidiwi nekuti cheni yese yatove neruzivo kusvika padanho renyika.
Iyo sisitimu inotanga kutsvaga yega yega nzvimbo zvichienderana nemaitiro atatsanangura. Pazasi payo inoratidza muorenji iyo data yemashoko asinganzwisisike, ayo anowanzoitika nenzvimbo idzo Google isati yaziva mudura rayo. Muchiitiko changu che298, vatanhatu chete ndivo vaisanzwisisika; kazhinji Google inovaisa kune imwe nyika nekuti variko kumwe kunhu.
Minute 10, ikoko iwe unayo
Kana imwe pfungwa yakanga isiri panzvimbo, inogadziriswa mu "Row" sarudzo, nekudzvanya kaviri pamunda uye mu "edit geocode" link, kuvandudza kutsvaga uye kuratidza nzvimbo inogadzirisa kusanzwisisika. Kana isipo, saka unogona kuratidza nzvimbo iri padyo yatinoona muma tag eGoogle.
Mune mafirita sarudzo, zvinokwanisika kuwedzera mapaneru kuti uvhure, kudzima uye kuverenga nebato, nedhipatimendi, nemaspala ... nezvimwe.
Pano iwe unogona kuona iyo muenzaniso. Iyo haina dhata yekupedzisira nekuti ini ndakazviita neruzivo rwanga ruchiri kugadziriswa, ndichitambawo nemamwe matafura achigadzira kusangana nenzvimbo nekanzuru kodhi kubva kune imwe tafura ... asi semuenzaniso pane iyi link. Iniwo handina kuita gadziriso yemukati yekanganiso yekutanga uye ndichivimba kuti maminetsi gumi akwana.
Zvimwe zvikamu:
Iwe unogona kusanganisa matafura, kurongedza zvakananga, kutsikisa uye zvimwe zvinhu zvakakosha. Kuti uite zvakawanda, pane iyo API.
Zvechokwadi, izvi zvinoshandiswa kuburikidza nemapfungwa.
Kana isu tichida kushandisa maumbirwo emakoramu, tinogona kushandisa iyo Shapescape sevhisi (ndinovimba haina pasi)… kunyangwe ichida chimwe chinhu inopfuura maminetsi gumi.