| 001 Basic Problems in Geography.mp4 | 114.8 MB | ||
| 001 Basic Problems in Geography_en.vtt | 15.1 KB | ||
| 001 Coordinate Systems and SQL.mp4 | 110 MB | ||
| 001 Coordinate Systems and SQL_en.vtt | 12.1 KB | ||
| 001 Creating functions with Postgres and PostGIS.mp4 | 91 MB | ||
| 001 Creating functions with Postgres and PostGIS_en.vtt | 7.5 KB | ||
| 001 Introduction.mp4 | 34.6 MB | ||
| 001 Introduction_en.vtt | 5.3 KB | ||
| 001 Numeric data types.mp4 | 155.9 MB | ||
| 001 Numeric data types_en.vtt | 19 KB | ||
| 001 SELECT Statements (and their variants).mp4 | 163.1 MB | ||
| 001 SELECT Statements (and their variants)_en.vtt | 20.8 KB | ||
| 001 The case for SQL.mp4 | 185.9 MB | ||
| 001 The case for SQL_en.vtt | 20.4 KB | ||
| 002 Aggregate and GROUP BY functions.mp4 | 170.2 MB | ||
| 002 Aggregate and GROUP BY functions_en.vtt | 18.4 KB | ||
| 002 Boolean and Character data types.mp4 | 175 MB | ||
| 002 Boolean and Character data types_en.vtt | 16.5 KB | ||
| 002 Installing Postgres 11.mp4 | 25.6 MB | ||
| 002 Installing Postgres 11_en.vtt | 7.2 KB | ||
| 002 Spatial (and non-spatial) indexes and SQL.mp4 | 76.1 MB | ||
| 002 Spatial (and non-spatial) indexes and SQL_en.vtt | 11.6 KB | ||
| 002 Summarizing parcel data with a watershed and floodzone.mp4 | 44.2 MB | ||
| 002 Summarizing parcel data with a watershed and floodzone_en.vtt | 5.8 KB | ||
| 002 Variogram modeling with SQL.mp4 | 66.9 MB | ||
| 002 Variogram modeling with SQL_en.vtt | 10.6 KB | ||
| 003 Creating new data (UPDATE, INSERT, and DELETE functions).mp4 | 116.1 MB | ||
| 003 Creating new data (UPDATE, INSERT, and DELETE functions)_en.vtt | 13.2 KB | ||
| 003 Date and Time data types.mp4 | 57.4 MB | ||
| 003 Date and Time data types_en.vtt | 8 KB | ||
| 003 Installing QGIS 3.8.mp4 | 10.1 MB | ||
| 003 Installing QGIS 3.8_en.vtt | 2.8 KB | ||
| 003 Spatial Commands - part 1 (A-C).mp4 | 155.2 MB | ||
| 003 Spatial Commands - part 1 (A-C)_en.vtt | 16.9 KB | ||
| 003 The tools of spatial analysis Distance, adjacency, and Interaction.mp4 | 94.1 MB | ||
| 003 The tools of spatial analysis Distance, adjacency, and Interaction_en.vtt | 13.8 KB | ||
| 004 Conditional statements with SQL CASE.mp4 | 120.7 MB | ||
| 004 Conditional statements with SQL CASE_en.vtt | 15.9 KB | ||
| 004 Our Data.mp4 | 67.3 MB | ||
| 004 Our Data_en.vtt | 6.4 KB | ||
| 004 Spatial Commands - part 2 (D-U).mp4 | 161.1 MB | ||
| 004 Spatial Commands - part 2 (D-U)_en.vtt | 19.6 KB | ||
| 004 Spatial data types.mp4 | 91.4 MB | ||
| 004 Spatial data types_en.vtt | 9 KB | ||
| 005 Loading our data.mp4 | 104.7 MB | ||
| 005 Loading our data_en.vtt | 12.5 KB | ||
| 006 Important!!! - Fixing the .qgs file if you cannot connect to Postgres.mp4 | 21.6 MB | ||
| 006 Important!!! - Fixing the .qgs file if you cannot connect to Postgres_en.vtt | 2.9 KB | ||
| 007 Setting up our system.mp4 | 61.2 MB | ||
| 007 Setting up our system_en.vtt | 6.8 KB | ||
| 19867271-spatialsql.pdf | 2.3 MB | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| pg_qgs.qgs | 162.6 KB | ||
| pg_qgs.qgz | 17.4 KB | ||
| tompkins.backup | 69.2 MB | ||
| ▲ 56 total files | |||
Learning Open Source GIS: Spatial SQL w/ Postgres/PosGIS
https://DevCourseWeb.com
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.48 GB | Duration: 4h 46m
Spatial SQL: a language for geographers
What you'll learn
How to conduct spatial analysis with Postgres 11 and PostGIS
Traditional SQL statements
Spatial SQL statements
Creating spatial functions with SQL
How to create geographic models with SQL
PGAdmin IV to manage Postgres databases
QGIS Database module to manage Postgres databases
Join multiple tables together
Requirements
Understanding of what a database is
Some exposure to GIS operations
Comfortable with using GIS software
Description
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.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 3.4 GB | freecoursewb | 4 days | 2 | 22 | |
| 3.8 GB | freecoursewb | 1 week | 47 | 23 | |
| 3.7 GB | freecoursewb | 2 weeks | 26 | 5 | |
| 1.2 GB | freecoursewb | 2 weeks | 10 | 10 | |
| 1.9 GB | freecoursewb | 1 month | 5 | 0 |
All Comments