E hana i kahi palapala koho me Fusiontables - i 10 mau minuke
Inā makemake mākou e noʻonoʻo i kahi palapala ʻāina, nā hopena koho o nā kaona, i hiki ai iā lākou ke kānana ʻia e ka ʻaoʻao politika a kaʻana like ʻia me ka lehulehu. ʻOiai ʻoi aku ka liʻiliʻi o nā ala moe e hana ai, makemake wau e hōʻike i ka laʻana e wehewehe pehea e hiki ai ke hana me FusionTables e kahi mea hoʻohana maʻamau.
ʻO kā mākou i loaʻa:
ʻO ka hopena i hoʻopukaʻia e ka Koho Kaapuni Kiekie, kahi e hiki ai iāʻoe keʻike i ka papa inoa ma kaʻaha aupuni.
http://siede.tse.hn/escrutinio/alcadias_municipales.php
Minute 1. Kūkulu i ka papaʻaina
Hana ʻia kēia ma ke kope ʻana a me ka paʻi ʻana mai ka papa i loaʻa e ka Supreme Eliberal Tribunal a i Excel. Hoʻohana ʻia ke kope kūikawā, ka huaʻōlelo wale nō, a no ka mea ʻaʻohe hōʻike ʻāina, pono e kānana no kēlā me kēia o nā 18 ʻoihana. ʻO ka pōmaikaʻi me Chrome ke koho ʻia, ʻoiai inā mākou e hoʻololi i ka kānana i hiki iā mākou ke hana Ctrl + C.
Haʻalele mākou i ke poʻo wale nō ma ka lālani mua.
No ka ʻaʻohe o ka papaʻaina i ka papaʻaina, pono ia e georeferensi iā ia me ka hoʻohana ʻana i ka geocode. E hana ai i kēia, e hoʻopili mākou i nā kolamu i ʻole huikau ai ʻo Google ke ʻimi nei i nā wahi; koi mākou iā ʻoe e ʻimi no ke kulanakauhale, ka ʻāpana, ka ʻāina.
I ka kolamu F, e hoʻohana mākou i ka haʻihaʻi concatenate e like me kēia: = CONCATENATE (Kālā Kālā, ",",Paena o ke Keʻena, ",","aupuni"), ke hoʻohui pū nei mākou i nā koma ma waena o nā huaʻōlelo e hōʻoia i ke ʻano o ke kaula e like me ka mea i manaʻo ʻia. No laila e like ke kolamu ma ka lālani 2 penei:
=CONCATENATE(B2,”,”,A2,”,”,”honduras”) a ʻo ia ka lālani: ʻApana Waena, Francisco Morazán, Honduras
E kapa mākou i ke poʻo o kēia kolamu E "Concatenate"
Minuke 5. Pehea e hoʻoiho ai iā ia i FusionTables
Hoʻokomoʻia FusionTables i ka polokalamu kele pūnaewele Google Chrome, ai ka wā e hea ai iā ia e hana i kahi pepa hou Mai kēia loulouE hōʻike i kēia pūʻulu.
Hiki iāʻoe ke koho i kahi palapala i loaʻa ma nā Pūlewele Google, e hana i kahi blank a iʻole e hoʻouna i ka mea i loaʻa iā mākou ma ka kamepiula.
Ke koho ʻia, koho i ka pihi "Next". E nīnau mai iā mākou inā aia ka inoa o nā kolamu i ka lālani mua, a laila hana mākou i ka "Next" a laila e nīnau mai iā mākou i ka inoa a mākou e hāʻawi ai i ka papaʻaina a me kekahi mau wehewehe e hiki ke hoʻoponopono ʻia ma hope.
Minuke 7. Pehea e ʻike ai i ka papaʻaina
Mai ka ʻaoʻao File, koho ʻia ke koho "Geocode ..." a nīnau iā mākou i ke kolamu i loaʻa ka geocode. Hōʻike mākou i ke kolamu a mākou i wehewehe ai ma mua.
Inā ʻaʻole mākou i hana i kahi kolamu hoʻohui ʻia, hiki iā mākou ke wehewehe i ke kaona, akā no ka nui o nā inoa i ʻōlelo hou ʻia ma nā ʻāina he nui, inā ua loaʻa iā mākou nā wahi i hoʻopuehu ʻia ma waho o Honduras. Aia ma loko o ka ʻāina hoʻokahi he mau kūlanakauhale me ka inoa hoʻokahi, no ka laʻana "San Marcos", inā ʻaʻole mākou e hoʻohui i ka ʻoihana e loaʻa iā mākou kēlā pilikia.
Aia kahi koho i kapa ʻia ʻo "ad location hint", i kēia hihia ʻaʻole pono no ka mea ua loaʻa i ke kaulahao holoʻokoʻa ka ʻike a hiki i ka pae ʻāina.
Hoʻomaka ka ʻōnaehana e huli i kēlā me kēia wahi e pili ana i nā pae hoʻohālikelike a mākou i wehewehe ai. Ma lalo e hōʻike ana i ka ʻalani i ka pākēneka o ka ʻikepili kānalua, e hana ʻia me nā wahi a Google i hōʻike ʻole ai i kāna waihona. i kaʻu hihia o 298, he 6 wale nō i pohihihi; hoʻonoho mau ʻo Google iā lākou i kekahi ʻāina ʻē aʻe no ka mea aia lākou i kahi.
Minute 10, aia i lailaʻoe
Inā ʻaʻohe wahi kikoʻī, hoʻoponopono ʻia ia ma ke koho "Row", ma ke kaomi pālua ʻana i ke kahua a ma ka loulou "edit geocode", e hoʻomaikaʻi i ka ʻimi a hōʻike i kahi e hoʻonā ai i ka ambiguity. Inā ʻaʻole i loaʻa, a laila hiki iā ʻoe ke kuhikuhi i kahi wahi kokoke a mākou e ʻike ai ma nā hōʻailona Google.
I ke koho filters, hiki iā ia ke hoʻohui i nā pā i huli ai, hoʻopau a helu helu ma ka match, e ke keʻena, e ke kaiāulu ... etc.
Maʻaneʻi hiki iā ʻoe ke ʻike i kahi laʻana. ʻAʻohe ona ʻikepili hope loa no ka mea ua hana wau ia me ka ʻikepili e hana ʻia nei, a me ka papa pū ʻana me kekahi mau papa e hui pū me ka ʻāpana a me ke kaona kaiāulu mai kahi papa ʻē aʻe ... akā ma ke ʻano he laʻana aia ka loulou. ʻAʻole wau i hana i ka hoʻoponopono kūloko no ka hemahema o ke kula haʻahaʻa a ke lana nei ka manaʻo ua lawa nā minuke 10.
Nā mea hana'ē aʻe:
Hiki iā ʻoe ke hoʻohui i nā pākaukau, hoʻoponopono pololei, paʻi a me kekahi mau mea maʻamau. E hana hou ai, aia ka API.
ʻOiaʻiʻo, ua hanaʻia kēia ma nā helu.
Inā makemake mākou e hoʻohana i nā puka no nā kolamu hiki iā ʻoe ke hoʻohana i ka lawelawe Shapescape (no ka mea ʻaʻole ia i lalo) ... ʻoiai e makemake ana ʻoe ma mua o 10 mau minuke.