Introduction to Spatial SQL with PostGIS

提供方
Coursera Project Network
在此免费的指导 项目中,您将:

Learn the basics of Spatial SQL with PostGIS

Perform spatial analysis with PostGIS

Carry out spatial join with geospatial data.

在面试中展现此实践经验

Clock1.20 hours
Intermediate中级
Cloud无需下载
Video分屏视频
Comment Dots英语(English)
Laptop仅限桌面

In this one hour project, you will learn how to analyze spatial data with SQL using PostgreSQL, PgAdmin 4, and PostGIS extension. By the end of this project, you will: Learn the basics of Spatial SQL with PostGIS. Perform spatial analysis with PostGIS. Carry out spatial join with geospatial data. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

必备条件

Basic SQL Knowledge

Familiarity with GIS but not required

您要培养的技能

Geographic Information System (GIS)Spatial AnalysisPostgisGeospatialSQL

分步进行学习

在与您的工作区一起在分屏中播放的视频中,您的授课教师将指导您完成每个步骤:

  1. Introduction to PgAdmin 4.

  2. Basic SQL Statements

  3. Point Geometries

  4. Line/Polygon Geometries

  5. Set Geometry for table

  6. Spatial Relationships

  7. Spatial Join

  8. Spatial Join Aggregate

指导项目工作原理

您的工作空间就是浏览器中的云桌面,无需下载

在分屏视频中,您的授课教师会为您提供分步指导

常见问题

常见问题

还有其他问题吗?请访问 学生帮助中心