Gadzira mapeji ane meza ye Excel

Ini ndoda kusanganisa tafura yeExcel kune mepu mune shp fomati. Tafura yacho ichave ichishandurwa, saka ini handidi kuishandura kuita dbf fomati, kana kuiisa mukati meiyo geodatabase. Chiitwa chakanaka che inouraya nguva yezororo uye yechitsika kuti uchengete maziso kuAcGIS 9.3 kubva kuAcer Aspire One.

Semuenzaniso ndichashandisa data yakapiwa xyzmap, kushandisa zvakashambadzirwa pamashambadziro nokuti vane chigadzirwa chakanakisisa chaunokwanisa kubatanidza ArcGIS neGoogle Maps kutarisa maonero secheriri.

The data

• 1. xyzmap inopa mundi map in shape file format, ine dbf ine mibiru mbiri: imwe ine kode yenyika uye imwe ine zita.
• 2. Zvakare zvinosanganisira iyo Excel faira ine nyika yenhamba yedata, uye imwe column ine code yenyika.

Kurota

Chinangwa ndechekubatanidza tafura ye Excel nemepu, kunze kuitira kuti iwe urambe uchitarisana nawo apo iwe unogona kuita mabasa emepu nekugadzirisa.

Iyo mhinduro mu 3 matanho

Ndichashandisa Manifold GIS, uye ini ndichaiedza neArgGIS 9.3

1. Ita mapeji

Faira> kupinza> kudhirowa

2. Dana tafura

Faira> chinongedzo> tafura

3. Tafura dzekubatana

Iye zvino nokuda kweizvi, ndinoratidza tafura yakabatana nemepu, uye:

Tafura> hukama

Ipapo hukama hutsva hunosarudzwa uye minda inosanganiswa inosarudzwa

Sarudza Ok

Mushure meizvi, iyo sisitimu inokutendera iwe kusarudza makoramu iwe aunoda kuti uoneke. Uye voila, izvozvi matafura akabatanidzwa uye iwo anobva patafura yekunze anogona kuonekwa mune grey. Ita shanduko muExcel uye unoda kuona izvo zvatsva pane zvinoda kurudyi patafura uye sarudza Zororazve data.

Ndiine ArcGIS.

Hazvifaniri kunge zvakaoma kunzwisisa, asi ikozvino kushandisa shanduro Wedzera Join, hazviite padanho rekutanga. Meseji inotumirwa neconsole ndeyekuti iyo tafura yeExcel inoda ID yechinhu.

Friends of xyzmap kukurudzira kupfuudza xls ku dbf, asi ichi hachisi icho chinangwa chekurovedza muviri. Kana mumwe munhu akatibatsira, tichaita zvakanaka kunharaunda.