Kuwona kwa geodata pamapu

Ngati kampani yanu ili ndi nthambi kuzungulira dziko kapena kugulitsa osati mu Moscow Ring Road, posakhalitsa mudzayang'anizana ndi ntchito yowonetsa ziwerengero zochokera ku Microsoft Excel (zogulitsa, ntchito, voliyumu, makasitomala) pamapu akumalo. ponena za mizinda ndi madera enaake. Tiyeni tiwone mwachangu njira zazikulu zowonera geodata yomwe ilipo mu Excel.

Njira 1: Mwachangu komanso Mwaulere - Gawo la Mamapu a Bing

Kuyambira mu mtundu wa 2013, Excel ili ndi malo ogulitsira mapulogalamu, mwachitsanzo, zidatheka kugula, kutsitsa ndikuyika ma module owonjezera ndi zowonjezera zomwe zikusowa. Chimodzi mwazinthu izi chimakupatsani mwayi wowonetsa manambala pamapu - amatchedwa Bing Maps ndipo, chomwe chili chabwino kwambiri, ndichaulere. Kuti muyike, tsegulani tabu Lowetsani - Sungani (Ikani - Mapulogalamu a Office):

Mukayika chinthucho, chidebe chosinthika chokhala ndi mapu chiyenera kuwonekera papepala. Kuti muwonetsetse zambiri zanu pamapu, muyenera kusankha mtundu wokhala ndi geodata ndikudina batani Onetsani Malo:

Ngati ndi kotheka, pazokonda (chithunzi cha giya pakona yakumanja kwa gawo), mutha kusintha mitundu ndi mtundu wa ma chart owonetsedwa:

Ndikothekanso kusefa mwachangu mizinda, kuwonetsa zomwe mukufuna (chithunzi cha faniyo pakona yakumanja kwa gawolo).

Mutha kumangirira osati kumizinda kokha, komanso kuzinthu zina: zigawo (mwachitsanzo, Chigawo cha Tula), zigawo zodziyimira pawokha (mwachitsanzo, Yamalo-Nenets) ndi maiko (Tatarstan) - ndiye bwalo lachithunzichi lidzawonetsedwa pakati pa malowo. Chachikulu ndichakuti dzina lomwe lili patebulo limagwirizana ndi mawu ofotokozera pamapu.

Total mu kuphatikiza Njira iyi: kukhazikitsa kosavuta kwaulere, kumangika pamapu, mitundu iwiri ya ma chart, kusefa kosavuta.

В kuipa: mufunika Excel 2013 yokhala ndi intaneti, simungasankhe zigawo ndi zigawo.

Njira 2: Zosinthika komanso Zokongola - Mawonedwe a Mapu mu Malipoti a Power View

Mabaibulo ena a Microsoft Excel 2013 amabwera ndi zowonjezera zowonetsera lipoti zotchedwa Power View zomwe zimalola (pakati pa zinthu zina, ndipo zimatha kuchita zambiri!) Onetsani deta pamapu. Kuti mutsegule zowonjezera, tsegulani tabu Woyambitsa (Wolemba Mapulogalamu) ndipo dinani batani Zowonjezera za COM (Zowonjezera za COM). Pazenera lomwe limatsegulidwa, chongani bokosi pafupi ndi Power View ndikudina Chabwino. Pambuyo manipulations onsewa pa tabu Ikani (Ikani) muyenera kukhala ndi batani mawonekedwe amphamvu. 

Tsopano mutha kusankha mitundu ndi magwero a data, dinani batani ili - pepala latsopano lidzapangidwa m'buku lanu (monga slide yochokera ku Power Point), pomwe deta yosankhidwa idzawonetsedwa ngati tebulo:

Mutha kusintha tebulo kukhala mapu a malo mosavuta pogwiritsa ntchito batani Kadi (mapu) tsamba Constructor (Kapangidwe):

Perekani chidwi chapadera kumanja gulu Power View minda - pamenepo, mosiyana ndi mamapu akale a Bing, pokoka mayina amizere (minda) kuchokera pagome loyambira ndi mbewa ndikuwagwetsera m'malo osiyanasiyana, mutha kusintha mawonekedwe omwe akubwera:

• Ku dera malo (Malo) m'pofunika kuponya mzati kuchokera pa gwero tebulo lomwe lili ndi mayina a malo.
• Ngati mulibe ndime yokhala ndi dzina, koma pali mizati yokhala ndi zolumikizira, ndiye kuti iyenera kuyikidwa m'derali. Longitude (Longitude) и Latitude (Latitude), motero.
  
• Ngati m'deralo mtundu (Mtundu) kuponya katundu, ndiye aliyense kuwira adzakhala, kuwonjezera pa kukula (kusonyeza phindu okwana mu mzinda), mwatsatanetsatane mu magawo ndi katundu.
• Kuwonjezera munda kudera zowonekera or Zopingasa zochulukitsa (Ogawikana) adzagawa khadi limodzi kukhala angapo ndi gawo ili (mu chitsanzo chathu, ndi kotala).

Komanso pa tabu yokhazikika yomwe ikuwoneka pamwamba Kuyika (Mawonekedwe) mutha kusintha maziko a mapu (mtundu, b/w, autilaini, mawonekedwe a satellite), zilembo, mitu, nthano, ndi zina.

Ngati pali deta yambiri, ndiye pa tabu mawonekedwe amphamvu mutha kuloleza zapadera Malo osefera (Zosefera), komwe mungagwiritse ntchito mabokosi anthawi zonse mutha kusankha mizinda kapena katundu omwe mukufuna kuwonetsa pamapu:

Total mu pluses: Kusavuta kugwiritsa ntchito komanso kusinthasintha kwakusintha, kutha kugawa khadi imodzi m'magulu angapo.

Mu downsides: Power View sapezeka pamasinthidwe onse a Excel 2013, palibe mitundu ina yamatchati kupatula ma chart a bubble ndi pie.

Njira 3: Zokwera mtengo komanso akatswiri - Zowonjezera Mapu a Mphamvu

Ichi ndi chowonjezera chapadera cha COM pamilandu yowopsa kwambiri mukafuna mawonekedwe ovuta, owoneka bwino, owoneka bwino a kuchuluka kwa data pamtundu uliwonse (ngakhale mapu okhazikika), komanso ndi kanema wazomwe zimachitika pakapita nthawi. . Pachitukuko, inali ndi dzina logwira ntchito GeoFlow, ndipo pambuyo pake idatchedwanso Power Map. Tsoka ilo, mtundu wathunthu wazowonjezerazi umapezeka kwa ogula a mtundu wonse wa Microsoft Office 2013 Pro kapena Office 365 olembetsa mabizinesi omwe ali ndi dongosolo la Business Intelligence (BI). Komabe, ma comrades ochokera ku Microsoft amapereka chithunzithunzi cha zowonjezera izi kuti mutsitse "kusewera" kwaulere, zomwe timawathokoza.

Ulalo wotsitsa Power Map Preview kuchokera ku Microsoft Download Center (12 Mb)

Pambuyo otsitsira ndi khazikitsa kuwonjezera-pa, muyenera kugwirizana pa tabu Wopanga - COM Zowonjezera (Wopanga - Zowonjezera za COM) zofanana ndi Power View kuchokera m'ndime yapitayi. Pambuyo pake, pa tabu Ikani batani ayenera kuwonekera Kadi (mapu). Ngati tsopano tisankha tebulo lomwe lili ndi deta yochokera:

... ndikudina batani la Mapu, kenako tidzatengedwera kuwindo lina la Microsoft Power Map add-in:

Popanda kulowa mwatsatanetsatane (zomwe ndi zokwanira pa maphunziro apadera kwa theka la tsiku), ndiye kuti mfundo zonse zogwirira ntchito ndi mapu ndizofanana ndi Power View zomwe zafotokozedwa pamwambapa:

• Kukula kwa mizati kumatsimikiziridwa ndi mzere wa tebulo (Malipiro), zomwe tidzaponya m'munda msinkhu mu gulu lamanja. Mfundo yowerengera, monga mu pivot tables, ingasinthidwe pamndandanda wotsikira pansi wa magawo:

• Kuti mufotokoze mwatsatanetsatane gawo lililonse lazogulitsa zazinthu zilizonse, muyenera kudzaza gawolo mankhwala ku dera Category (Gawo).
• Mutha kugwiritsa ntchito mitundu yosiyanasiyana ya ma chart (ma tchati, thovu, mapu otentha, malo odzaza) pogwiritsa ntchito mabatani omwe ali kumanja:

• Ngati magwero a data ali ndi mzere wokhala ndi masiku ogulitsa, ndiye kuti akhoza kuponyedwa m'deralo Time (Nthawi) - ndiye mzere wa nthawi udzawonekera pansipa, momwe mungasunthire m'mbuyomu-m'tsogolo ndikuwona ndondomekoyi muzochitika.

"Wow moment" ya Power Map add-on mwina ingatchulidwe kuti ndikosavuta kwambiri popanga ndemanga zamakanema motengera mamapu opangidwa. Ndikokwanira kupanga makope angapo a zochitika zamakono kuchokera kumakona osiyanasiyana owonera ndi masikelo osiyanasiyana - ndipo chowonjezeracho chidzangopanga makanema ojambula a 3D akuwuluka mozungulira mapu anu, kuyang'ana malo osankhidwa. Kanema wotsatirayo amasungidwa mosavuta mumtundu wa mp4 ngati fayilo yosiyana kuti ayike, mwachitsanzo, pa Power Point slide.

Njira 4. Tchati cha Bubble chokhala ndi "Kukonza Fayilo"

Njira ya "famu yophatikizana" kwambiri pa onse omwe atchulidwa, koma amagwira ntchito m'mitundu yonse ya Excel. Pangani tchati chothawira (Bubble Tchati), zimitsani nkhwangwa zake, gululi, nthano ... mwachitsanzo chilichonse kupatula thovu. Kenako sinthani pamanja malo a thovulo poyika chithunzi chomwe chidatsitsidwa kale cha mapu omwe mukufuna pansi pajambula:

kuipa njira imeneyi ndi zoonekeratu: yaitali, dreary, ntchito zambiri zamanja. Komanso, linanena bungwe siginecha kwa thovu ndi vuto osiyana pamene pali zambiri.

ubwino kuti njirayi idzagwira ntchito mumtundu uliwonse wa Excel, mosiyana ndi njira zotsatirazi, kumene Excel 2013 ikufunika. Ndipo palibe intaneti yomwe imafunikira.

Njira 5: Mapulogalamu a chipani chachitatu ndi zowonjezera 

M'mbuyomu, panali zowonjezera zingapo ndi mapulagi a Excel omwe amalola, mosiyanasiyana komanso kukongola, kukhazikitsa mawonetsedwe a data pamapu. Tsopano ambiri aiwo amasiyidwa ndi opanga, kapena ali mukufa mwakachetechete - ndizovuta kupikisana ndi Power Map 🙂

Mwa omwe adapulumuka oyenera kutchulidwa:

• MapCite - mwina wamphamvu kuposa onse. Kutha kuphatikizidwa ndi mapu ndi mayina a midzi, zigawo, zigawo ndi ma coordinates. Imawonetsa deta ngati mfundo kapena mapu otentha. Amagwiritsa ntchito Mamapu a Bing ngati maziko. Amadziwa kuponya mapu opangidwa mu Power Point. Mtundu woyeserera waulere ulipo kuti utsitsidwe, mtundu wonsewo umawononga $99/chaka.
• Mapu a Esri - chowonjezera cha Esri chomwe chimakupatsaninso mwayi wotsitsa ndikusanthula geodata kuchokera ku Excel kupita pamapu. Zokonda zambiri, mitundu yosiyanasiyana ya ma chart, zothandizira . Pali chiwonetsero chaulere chaulere. Mtundu wathunthu umafunikira kulembetsa ku ntchito ya mapu ya ArcGis.
  
• MapLand- imodzi mwazowonjezera zoyamba pamutuwu, zopangidwira Excel 97-2003. Zimabwera ndi mapu amtundu wa zojambulajambula, zomwe deta yapapepala imamangiriridwa. Makhadi owonjezera ayenera kugulidwa. Chiwonetsero chamitundu yosiyanasiyana ya Excel chikupezeka kuti chitsitsidwe, mtundu wa Pro umawononga $299.