Spatial SQL with Postgres : A language for geographers

Spatial SQL with Postgres : A language for geographers, available at $39.99, has an average rating of 3.95, with 20 lectures, based on 637 reviews, and has 2919 subscribers.

You will learn about use SQL to manage spatial data create advanced spatial analysis tools in SQL replicate many traditional GIS tasks (overlay, buffer, etc.) using SQL understand and manage traditional and spatial indexes This course is ideal for individuals who are students who want to learn SQL or students who want to apply spatial techniques with SQL or students who are ordinarily intimidated by programming or students who want to perform GIS task in a fraction of the time it takes to use the GUI or students who want to understand the ins-and-outs of how spatial operations work It is particularly useful for students who want to learn SQL or students who want to apply spatial techniques with SQL or students who are ordinarily intimidated by programming or students who want to perform GIS task in a fraction of the time it takes to use the GUI or students who want to understand the ins-and-outs of how spatial operations work.

Enroll now: Spatial SQL with Postgres : A language for geographers

Summary

Title: Spatial SQL with Postgres : A language for geographers

Price: $39.99

Average Rating: 3.95

Number of Lectures: 20

Number of Published Lectures: 19

Number of Curriculum Items: 20

Number of Published Curriculum Objects: 19

Original Price: $34.99

Quality Status: approved

Status: Live

What You Will Learn

use SQL to manage spatial data
create advanced spatial analysis tools in SQL
replicate many traditional GIS tasks (overlay, buffer, etc.) using SQL
understand and manage traditional and spatial indexes

Who Should Attend

students who want to learn SQL
students who want to apply spatial techniques with SQL
students who are ordinarily intimidated by programming
students who want to perform GIS task in a fraction of the time it takes to use the GUI
students who want to understand the ins-and-outs of how spatial operations work

Target Audiences

students who want to learn SQL
students who want to apply spatial techniques with SQL
students who are ordinarily intimidated by programming
students who want to perform GIS task in a fraction of the time it takes to use the GUI
students who want to understand the ins-and-outs of how spatial operations work

Are you stuck in a rut of only knowing how to use a GIS GUI? Do you want to learn how to automate tasks, but are afraid of computer programming. If so, SQL is the most powerful tool you can learn to help you perform complex GIS tasks. This course is designed to teach you how to write SQL to replicate many database and GIS tasks. We will start at a very basic overview, and then proceed to more advanced topics related to GIS.

Through a series of lectures, I will work side-by-side with you to develop SQL queries that perform advanced GIS tasks, some of which might be impossible to perform in the GUI. Once my students learn GIS, they very rarely want to return back to using the GUI.

By writing SQL code alongside me, you will see how solving GIS tasks in SQL is like a second nature. This is a very comprehensive course that should take multiple days to complete – but don’t worry about that – you will be having a lot of fun learning how powerful SQL can be, and continually ask yourself “why didn’t I start using SQL sooner!”

Course Curriculum

Chapter 1: Welcome Message – What you need to get started

Lecture 1: Course Infomercial

Chapter 2: Loading Software and Data

Lecture 1: Installation of software

Lecture 2: Loading our Data

Chapter 3: Overview of SQL

Lecture 1: Overview of SQL

Lecture 2: A basic introduction to some SQL with GIS data

Chapter 4: SQL Data Types

Lecture 1: SQL Data Types, Part I: Numeric, Boolean, Text

Lecture 2: SQL Data Types, Part II: Date and Time, Spatial

Chapter 5: Traditional SQL

Lecture 1: Traditional SQL: SELECT, WHERE, conditional expressions, and GROUP BY

Lecture 2: More fun with GROUP BY

Lecture 3: CASE Statements

Lecture 4: Aggregate Functions (average, standard deviation, count, min, max….)

Lecture 5: Other SQL Commands (ORDER, LIMIT, OFFSET, BETWEEN)

Lecture 6: Changing data: DROP, CREATE, INSERT, ALTER, UPDATE

Lecture 7: Writing SQL Functions

Chapter 6: Spatial SQL for Vector Geometry

Lecture 1: Spatial Operations: coordinate system manipulation

Lecture 2: Spatial operations: Adjacent, Buffer, Contains, Distance, Intersect, more..

Lecture 3: Spatial Operations: Topological Overlay (ERASE, INTERSECT, IDENTITY)

Chapter 7: Spatial SQL for geographic analysis

Lecture 1: Spatial Interaction: Distance, Adjacency, and Interaction matrices

Lecture 2: Geographic Analysis: Nearest Neighbor Index

Instructors

Arthur Lembo
Professor

Rating Distribution

1 stars: 8 votes
2 stars: 21 votes
3 stars: 78 votes
4 stars: 246 votes
5 stars: 284 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu