Shigar da saitunan Excel a cikin QGIS kuma haifar da Polygons

Ɗaya daga cikin hanyoyin da aka saba amfani dashi a cikin amfani da Geographic Information Systems shine gina shimfidar sararin samaniya daga bayanin da ke fitowa daga filin. Ko wannan yana wakiltar haɓakawa, wurare na makirci ko lattices na ƙwanƙwasa, bayanin yawanci yakan zo a cikin fayilolin da ke rabu da ƙwaƙwalwa ko Rajistar Excel.

1 Tsarin haɗin gwargwadon yanayin ƙasa a Excel.

A wannan yanayin, Ina ƙoƙarin shigar da ƙauyukan maza na Jamhuriyar Cuba, wanda na sauke daga diva-GIS, wadda ta hanyar hanya daya daga cikin shafuka mafi kyau don sauke bayanan ƙasa na kowace ƙasa. Kamar yadda kake gani, ginshiƙan B da C suna da bayanai game da latitude da longitude a cikin hanyar Ƙididdigar geographical.

lat tsawo qgis excel

2 Shigo da fayil a QGIS

Don shigo da daidaitattun fayilolin Excel, an yi shi:

Vector> Aikace-aikace na XY> Fayil na OpenExcele a matsayin tebur ko alamar Layer Layer

lat tsawo qgis excel

Idan an ajiye fayil din tare da tsawo na .xlsx, mai bincike bazai nuna shi ba, tun da yake yana tace fayiloli kawai tare da tsawo .xls. Ba wani matsala ba, zamu iya amfani da fasaha na DOS ta farko kuma rubuta a cikin canjin sunan, tace: *. * (alama alama alama) kuma muna shigar; wannan zai ba da izinin duk fayiloli a cikin wannan wuri. Za mu iya rubuta * .xls kuma zai iya sarrafawa kawai fayiloli .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 Layer tare da bayanan da ke ƙunshe da fayil na ƙauyukan maza na Cuba, wanda ya haɗa da sunan, latitude, tsawon lokaci, rarrabewa da kuma gundumar gwamnati, an ajiye shi.

lat tsawo qgis excel

3 Ƙirƙiri polygons daga haɗin kai

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 plugin yana bamu damar gano abin da za'a kira filin saƙo, idan abin da muke shigowa za a gina kamar layi ko a matsayin polygon.

lat tsawo qgis excel

4 Yadda za a shigo da haɗin gwiwar daga Excel zuwa wasu shirye-shiryen CAD / GIS.

Kamar yadda za ka tuna, mun yi wannan tsari tare da wasu shirye-shirye. Kamar yadda sauki kamar QGIS, 'yan kaɗan. Amma ga yadda za a yi shi da AutoCAD, Microstation, da yawa GIS, AutoCAD Civil 3D, Google Earth.

Deja un comentario

Your email address ba za a buga.

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