Shigo da komputa daga Excel zuwa QGIS kuma ƙirƙira Polygons

Daya daga cikin abubuwan yau da kullun da ake amfani dasu a cikin amfani da Tsarin Bayanai na Geographic shine gina matakan sararin samaniya daga bayanai daga filin. Ko wannan yana wakiltar tsarawa, bangarori masu shinge, ko grid mai ɗaukakawa, bayanin yakan zo ne a cikin waƙoƙin rabuwar wakafi ko maƙunsar bayanai na Excel.

1. Fayil ɗin tsara tsarawa a cikin Excel.

A wannan yanayin, Ina ƙoƙarin shigar da ƙauyukan maza na Jamhuriyar Cuba, wanda na sauke daga diva-GIS, wanda a halin yanzu shine ɗayan mafi kyawun rukunin yanar gizo don saukar da bayanan ƙasa daga kowace ƙasa. Kamar yadda kake gani, ginshikan B da C sun ƙunshi bayanin game da latitud da longitude a cikin hanyar Ƙididdigar geographical.

  lat tsawo qgis excel

2. Shigo da fayil ɗin cikin QGIS

Don shigo da daidaitattun fayilolin Excel, an yi shi:

Vector> Kayan aikin XY> Fayil OpenExcele azaman teburin sifa ko Launin Point

lat tsawo qgis excel

Idan har aka ajiye fayil din tare da fadada .xlsx, mai binciken ba zai nuna shi ba, saboda yana tace fayiloli ne kawai tare da fadada .xls. Ba matsala bane, zamu iya amfani da tsofaffin dabarun DOS kuma muyi rubutu cikin canjin suna, tace: *. * (alama alama dot) kuma muna yin Shigar; wannan zai ba da damar ganin duk fayilolin da ke wannan wurin. Da mun iya rubuta * .xls kuma da mun tace fayiloli ne kawai tare da fadada .xls.

lat tsawo qgis excel

Sa'an nan kuma wani rukuni ya bayyana wanda dole ne mu nuna abin da shafi ya dace da haɗin X, a cikin wannan yanayin mun zaɓi ɗigon tsawo, layin haɗin kan y haɗin Y.

lat tsawo qgis excel

Kuma a can muna da shi. Tambayar ta nuna cewa an adana layin tare da bayanan da ke cikin fayil ɗin ƙauyukan 'yan Adam, wanda ya haɗa da suna, latitude, longitude, rarrabuwa da lardin gudanarwa.

lat tsawo qgis excel

3. polyirƙira polygons daga tsarawa

Idan har ma, muna so mu ba kawai shigo da kayan aiki ba amma kuma mu ƙirƙiri polygon a cikin tsari na waɗannan haɗin kai, za mu iya amfani da plugin Points2One. Wannan kayan aikin yana ba ka damar gano yadda za a kira lakabin makoma, idan za a gina abin da za mu shigo da shi azaman layi ko matsayin polygon.

 

lat tsawo qgis excel

 

 

4. Yadda ake shigo da tsarawa daga Excel zuwa wasu shirye-shiryen CAD / GIS.

Kamar yadda zaku iya tunawa, munyi wannan aikin tare da wasu shirye-shiryen da yawa. Kamar sauki kamar QGIS, kaɗan. Amma ga yadda ake yi da shi AutoCAD, Microstation, da yawa GIS, AutoCAD Civil 3D, Google Earth.

Barin amsa

Your email address ba za a buga.

Wannan shafin yana amfani da Akismet don rage spam. Koyi yadda aka sarrafa bayanan bayaninka.