Импорт таблиц или CSV-файлов

Зачастую данные ГИС поставляются в виде таблицы или электронных таблиц Excel. Кроме того, если у вас есть список координат в формате долгота/широта, вы можете легко импортировать эти данные в ваш ГИС-проект.

Обзор задачи

Мы импортируем в QGIS текстовый файл с данными о землетрясениях.

Получение данных

NOAA’s National Geophysical Data Center produces a great dataset of all significant earthquakes since 2150 BC. Learn more.

Download Significant Earthquake Database text file.

For convenience, you may directly download a copy of both the datasets from the links below:

signif.txt

Источник данных: [NGDC]

Методика

  1. Examine your tabular data source. To import this data to QGIS, you will have to save it as a text file and need at least 2 columns which contain the X and Y coordinates. If you have a spreadsheet, use Save As function in your program to save it as a Tab Delimited File or a Comma Separated Values (CSV) file. Once you have the data exported this way, you can open it in a text editor such as Notepad to view the contents. In case of the Significant Earthquake Database, the data already comes as a text file which contains latitude and longitude of the earthquake centers along with other related attributes. You will see that each field is separated by a TAB.
../_images/170.png
  1. Откройте QGIS. Нажмите на Layers ‣ Add Delimited Text Layer.

../_images/229.png
  1. In the Create a Layer from a Delimited Text File dialog, click on Browse and specify the path to the text file you downloaded. In the File format section, select Custom delimiters and check Tab. The Geometry definition secction will be auto-populated if it finds a suitable X and Y coordinate fields. In our case they are LONGITUDE and LATITUDE. You may change it if the import selects the wrong fields. Click OK.

Примечание

It is easy to confuse X and Y coordinates. Latitude specifies the north-south position of a point and hence it is a Y coordinate. Similarly Longitude specifies the east-west position of a point and it is a X coordinate.

../_images/320.png
  1. You may see some errors displayed in the next dialog. The erros in this file are mainly due to missing X or Y fields. You may examine these errors and fix the problems in your source file. For this tutorial, you may ignore these errors.
../_images/415.png
  1. Next, a Coordinate Reference System Selector will ask you to select a coordinate reference system. Since the earthquake coordinates are in latitudes and longitudes, you should select WGS 84. Click OK.
../_images/515.png
  1. You will now see that the data will be imported and displayed in the QGIS canvas.
../_images/614.png
comments powered by Disqus

This work is licensed under a Creative Commons Attribution 4.0 International License