|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/bluff-next-processing-survey-data-in-gcs-with-qgis-34x/
课程评论：没有评论
课程名称：《Bluff Next: 使用 QGIS 3.xx 处理 GCS 里的调查数据》 课程概述： 这门视频教程基于 QGIS 3.34 LTR 制作，但 QGIS 3.xx 的所有版本均可参与学习。主要内容包括： 1. **地理数据包（Geopackage, GPKG）简介**：GPKG 是 QGIS 的一种专有格式，因其集成了比传统 Shapefile（.SHP）格式更广泛的数据支持而迅速流行。GPKG 不仅可以存储矢量数据，还支持栅格数据、电子表格、图块数据，甚至可以存储 QGIS 项目文档（QGS/QGZ），真正创建了一个项目的独立环境，基于 SQLite 数据库。 2. **GPKG 与 SHP 格式比较**：SHP 格式在地理信息系统（GIS）行业已经使用了 40 年。该格式的缺点在于其 DBF 数据库支持已不再使用。GPKG 则利用轻量级、易用的 SQLite 数据库来提升数据存储的质量，我们将比较这两种格式的优缺点。 3. **将 SHP 导出至 GPKG**：我们将学习如何将现有的 SHP 数据导出到 GPKG，以节省时间并进行实践。QGIS 支持多种格式的导入和导出。 4. **处理 XLS 格式的字段调查数据**：在 QGIS 处理之前，需先清理 XLS 格式的字段数据。 5. **将 XLS 导出为 CSV**：在数据清理后，将 XLS 数据导出为 CSV 格式。 6. **在 QGIS 中绘制调查点分布**：将 CSV 数据添加到 QGIS，利用经纬度信息绘制调查点分布，使用地理坐标系统（GCS）和十进制度格式。 7. **将绘图数据导出至 GPKG**：将添加到 QGIS 画布的调查点分布数据导出为 GPKG，使其永久存储。 8. **创建空间模型**：使用 GPKG 中存储的调查点分布数据，创建不同类型的空间模型（主题图、分类图、聚类图、热力图等），以便更清晰地展示数据的属性分布。 9. **在单一 QGIS 项目文档中设计多布局**：QGIS 的多布局功能允许用户在一个 QGS 文档中创建多个布局，便于针对不同空间模型设计布局。 本课程让学习者系统地掌握 QGIS 处理地理数据的技能，特别是在调查数据处理中应用 GPKG 格式的优势。
This Video tutorial is created using QGIS 3.34 LTR, however all QGIS 3.xx may use and follow this course.1. Introduction to Geopackage (.gpkg),GPKG is a proprietary format from QGIS. Although this format is relatively new, its popularity is rapidly increasing because many things offered by this format far surpass the Shapefile/SHP format. GPKG not only accommodates vector data but also raster data, spreadsheets, tile data and can even store QGIS Project Document (QGS/QGZ) so that GPKG is truly able to create an isolated environment for a project. GPKG can do this because GPKG is supported by the SQLite database so GPKG is not just a format but also a database.2. Geopackage VS Shapefile.SHP has been the de facto standard vector data format in the GIS industry for 40 years. When SHP was first launched, this format was supported by the most advanced technology at that time, for example DBF database support. Currently, DBF is no longer used because there are many weaknesses here and there. The vector data storage format was then developed again by still using database technology as the backbone of data storage but with much better adjustments. One of the data storage formats developed by QGIS is Geopackage/GPKG. GPKG is supported by a sophisticated, lightweight and easy-to-use SQLite database. We will go head to head to compare the advantages and disadvantages of the SHP and GPKG formats.3. Export SHP to GPKGGPKG is able to create new features but on this occasion we will export existing SHP data to GPKG, besides saving time, we can also practice. There are many formats that can be read by QGIS and all of them can be exported to GPKG. besides SHP, other popular data formats are KML and geoJSON.4. Processing field survey data in XLS format, editing and cleaning dataBefore being processed in QGIS, field data in XLS format is first cleaned/cleaned such as column names that must not have spaces.5. Export XLS to CSVAfter being cleaned, the XLS data is exported to CSV.6. Plotting survey point distribution data CSV to QGIS, XY data in Geographic Coordinate System (GCS) in decimal degree (DD) formatThe CSV data is then added and plotted to QGIS. Plotting or displaying the distribution of survey points on the QGIS canvas is done using 2 (two) columns/fields, a combination of X/Longitude/Longitude and Y/Latitude/Latitude as the coordinate points of the earth where the survey respondents are located. The coordinate system used in this course is the Geographic Coordinate System (GCS) with degrees (Degree) and in Decimal Degree/DD format7. Export plotting data to GPKGThe distribution of survey points that have been added to the QGIS canvas is temporarily stored in memory (temporary layer), to make it permanent we will export this point distribution data to GPKG8. Creating a spatial modelWe will create a spatial model from the distribution of survey points that have been stored in GPKG. This spatial model can be in the form of thematic, choropleth, clustering and heatmap. The spatial model will provide a clearer picture of how this data is distributed based on the attribute data obtained such as the age spatial model, the monthly turnover spatial model, the annual turnover spatial model and others.9. Designing multi-Layout in one QGIS project document (QGS/QGZ).The advantage of creating a layout in QGIS is multi-Layout. We can create many layouts/multi-layouts from just one QGS. We are able to create layouts for each of the spatial models above from just one QGS/QGZ.
