|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/spatialsqlpostgis/
课程评论：没有评论
**课程名称：** 学习开源GIS：Postgres/PosGIS空间SQL **课程概览：** 本课程是免费开源GIS（FOSS4G）软件全系列课程的一部分，是FOSS4G领域最全面的课程之一。整个课程体系涵盖桌面、服务器和开发者等FOSS4G栈的各个部分。 在这门专注于空间SQL的课程中，您将学习最流行的开源数据库Postgres 11。课程将从Postgres的基础知识入手，介绍PostGIS空间插件，并通过SQL开始解决空间问题。 课程将使用来自纽约汤普金斯县的真实数据，并与其他gisadvisor系列课程无缝对接，这些课程将教授您QGIS、GDAL、Geoserver和Python。您将与讲师一同探索SQL的能力，处理栅格、矢量和属性数据。更重要的是，在学习SQL和空间SQL之后，您将模拟一些真实的GIS项目和空间分析。 无论您是为了工作需要学习Postgres和PostGIS中的SQL，还是希望通过FOSS4G知识在面试中脱颖而出，本课程都能让您熟练掌握SQL和空间SQL的细节，并增强您与其他GIS专家的交流信心。 该课程体系设计灵活，您可以从本课程或任何其他课程开始学习。课程之间会相互引用，并且由于均使用同一地理区域（汤普金斯县）的数据，所有课程将以统一的数据集进行教学。随着您学习更多课程，您将全面掌握FOSS4G栈的各个组成部分。
This course is part of an entire curriculum based on Free and Open Source GIS (FOSS4g) software, and represents one of the most comprehensive curriculum on FOSS4g. The curriculum are grouped into the categories of Desktop, Server, and Developer parts of the FOSS4g stack. For this course, you will learn the most popular open source database: Postgres 11. We'll start with a basic understanding of Postgres, introduce PostGIS as a spatial plug in, and begin to solve spatial problems using SQL. This course uses real data from Tompkins County, New York, and seamlessly integrates with other gisadvisor courses that will teach you QGIS, GDAL, Geoserver, and Python. You'll be working alongside me as we explore the capabilities of SQL, working with raster, vector, and attribute data. And most importantly, after you learn SQL and spatial SQL you willl simulate some real-world examples of GIS projects and spatial analysis.Whether you need to learn SQL within Postgres and PostGIS for your job, or want to get spun up on FOSS4g to nail that big interview, this course will prepare you to work with the ins-and-outs of SQL and spatial SQL, and give you confidence as you interact with other GIS experts.The curriculum is designed so that you can start with either this course, or any of the other courses. They will refer back and forth with one another, and because we are camping out in the same geographic area, all the courses will use the same data. As you move through each course, you are going to have experience with all the different parts of the FOSS4g stack.
