Tsim cov ntawv qhia kev xaiv tsa nrog Fusiontables - hauv 10 feeb
Cia li xav tias peb xav rov xav txog daim duab qhia chaw, cov kev xaiv nom tswv ntawm cov neeg hauv nroog, kom lawv tau xaiv los ntawm pawg kasmoos thiab koom nrog cov pej xeem. Thaum muaj ntau dua qhov kev tso ua nws, Kuv xav qhia tus piv txwv los piav qhia li cas nws tuaj yeem ua nrog FusionTables los ntawm cov neeg siv ib txwm siv.
Peb muaj dab tsi:
Qhov kev tshwm sim luam tawm ntawm lub Supreme Electoral Tribunal, uas koj tuaj yeem pom daim ntawv teev npe los ntawm lub nroog.
http://siede.tse.hn/escrutinio/alcadias_municipales.php
Feeb 1. tsim lub rooj
Qhov no yog ua los ntawm kev luam thiab pasting los ntawm lub rooj muaj los ntawm Tsev Hais Plaub Supreme Mus rau Excel. Kev luam tshwj xeeb yog siv, tsuas yog ntawv nyeem, thiab raws li tsis muaj lub teb chaws tso tawm, nws yog qhov tsim nyog los lim rau txhua ntawm 18 lub chaw haujlwm. Qhov zoo nrog Chrome yog qhov kev xaiv tau tsim, txawm tias peb hloov lub lim dej kom peb tsuas yog yuav tsum ua Ctrl + C.
Peb tawm hauv nqe lus nyob ib leeg hauv thawj kab.
Raws li lub rooj tsis muaj kev koom tes, nws yuav tsim nyog rau georeference nws siv geocode. Txhawm rau ua qhov no, peb yuav concatenate rau txhua kab kom Google tsis yuam kev thaum saib rau cov chaw; peb xav kom koj tshawb hauv nroog, chav fai, teb chaws.
Hauv kem F, peb yuav siv cov mis uas qhia zoo li no: = sib tham (Kem ntawm lub nroog, ",",Chav Kawm Sab, ",“,”Lub teb chaws"), peb kuj tseem sib txuas cov commas ntawm cov lus hais kom ntseeg tau tias txoj hlua zoo li xav tau. Yog li kab hauv kab 2 yuav zoo li no:
=CONCATENATE(B2,”,”,”,A2,”,”,”honduras”) thiab vim li ntawd cov kab yuav yog: Central District, Francisco Morazán, Honduras
Peb yuav hu lub header ntawm kab E "Concatenate"
Feeb 5. Yuav ua li cas upload nws rau FusionTables
FusionTables muab tso rau hauv Google Chrome browser, thiab thaum twg hu nws los tsim ib daim ntawv tshiab Ntawm qhov txuas no, lub vaj huam sib luag no yuav tsum tshwm sim.
Koj tuaj yeem xaiv ib daim ntawv muaj nyob rau hauv Google Spreadsheets, tsim ib qho dawb los sis xa ib qho peb muaj nyob rau hauv lub computer.
Thaum xaiv, xaiv "Tom ntej" khawm. Nws yuav nug peb seb lub npe ntawm kab nyob rau hauv thawj kab, ces peb ua "Tom ntej" thiab tom qab ntawd nws yuav nug peb seb peb muab lub npe dab tsi rau lub rooj thiab qee cov lus piav qhia uas tuaj yeem hloov kho tom qab.
Feeb 7. Yuav ua li cas georeference lub rooj
Los ntawm cov ntaub ntawv tab, xaiv "Geocode ..." thiab nws nug peb seb kab twg muaj cov geocode. Peb qhia txog kab uas peb tau txhais ua ntej.
Yog tias peb tsis tau tsim kab ke sib txuas, peb tuaj yeem txhais lub nroog, tab sis vim tias muaj ntau lub npe rov ua dua nyob hauv ntau lub tebchaws, peb yuav tau txais cov ntsiab lus tawg tawm sab nraud Honduras. Tsis tas li ntawd nyob rau hauv tib lub teb chaws muaj cov municipalities nrog tib lub npe, piv txwv li "San Marcos", yog hais tias peb tsis concatenate lub department peb kuj yuav muaj qhov nyuaj.
Muaj ib qho kev xaiv hu ua "ad chaw qhia ntawv", uas nyob rau hauv cov ntaub ntawv no tsis tsim nyog vim hais tias tag nrho cov saw twb muaj cov ntaub ntawv mus txog rau lub teb chaws.
Cov kab ke pib pib saib txhua qhov chaw raws li cov qauv uas peb tau txhais. Hauv qab no nws qhia hauv txiv kab ntxwv feem pua ntawm cov ntaub ntawv tsis meej, uas feem ntau yuav tshwm sim nrog cov chaw uas Google tseem tsis tau txheeb xyuas hauv nws cov chaw khaws ntaub ntawv; hauv kuv li 298, tsuas yog 6 qhov tsis meej xwm; feem ntau Google tso lawv nyob rau lwm lub teb chaws vim tias lawv muaj nyob rau lwm qhov.
Minute 10, koj muaj nws
Yog tias ib qho taw tes tawm ntawm qhov chaw, nws raug kho nyob rau hauv "Law" kev xaiv, los ntawm ob npaug nias rau ntawm daim teb thiab hauv "kho kom raug geocode" txuas, txhim kho kev tshawb nrhiav thiab qhia qhov chaw uas daws qhov tsis meej pem. Yog tias tsis muaj, koj tuaj yeem qhia qhov chaw nyob ze uas peb pom hauv Google cim npe.
Hauv qhov kev xaiv lim, nws yog qhov tsim nyog kom ntxiv cov lauj kaub ua haujlwm kom qhib, tawm thiab suav los ntawm kev sib tw, los ntawm chav haujlwm, los ntawm nroog ...
Ntawm no koj tuaj yeem pom cov piv txwv. Nws tsis muaj cov ntaub ntawv kawg vim tias kuv tau ua nws nrog cov ntaub ntawv uas tseem tab tom ua, tseem fiddling nrog qee cov ntxhuav ua kev sib koom ua ke nrog thaj tsam thiab nroog txoj cai los ntawm lwm lub rooj ... tab sis ua piv txwv muaj qhov txuas. Kuv kuj tsis ua qhov kev kho mob sab hauv rau ib qho kev ua yuam kev thiab cia siab tias 10 feeb tau txaus.
Lwm cov nta:
Koj tuaj yeem sib tshuam ua ke cov rooj, hloov ncaj qha, tshaj tawm thiab qee qhov khoom theem pib. Txhawm rau ua ntxiv, muaj qib API.
Ntawm chav kawm, qhov no yog ua los ntawm cov ntsiab lus.
Yog tias peb xav siv cov duab ua haujlwm rau cov kem, koj tuaj yeem siv cov kev pabcuam Shapescape (cia siab tias nws tsis tau nqis) ... txawm hais tias koj xav tau ntau dua 10 feeb.
