17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
TORRENT DETAILS
Udemy - Learning Open Source GIS - Spatial SQL W - Postgres - PosGIS
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
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.
If You Need More Stuff, kindly Visit and Support Us -->> https://CourseWikia.com
Get More Tutorials and Support Us -->> https://FreeCourseWeb.com
We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
~Get Your Files Here !/01 - Section 1 Loading our Software and Data/001 Introduction.mp4
34.6 MB
~Get Your Files Here !/01 - Section 1 Loading our Software and Data/001 Introduction_en.vtt
5.3 KB
~Get Your Files Here !/01 - Section 1 Loading our Software and Data/002 Installing Postgres 11.mp4
25.6 MB
~Get Your Files Here !/01 - Section 1 Loading our Software and Data/002 Installing Postgres 11_en.vtt
7.2 KB
~Get Your Files Here !/01 - Section 1 Loading our Software and Data/003 Installing QGIS 3.8.mp4
10.1 MB
~Get Your Files Here !/01 - Section 1 Loading our Software and Data/003 Installing QGIS 3.8_en.vtt
2.8 KB
~Get Your Files Here !/01 - Section 1 Loading our Software and Data/004 Our Data.mp4
67.3 MB
~Get Your Files Here !/01 - Section 1 Loading our Software and Data/004 Our Data_en.vtt
6.4 KB
~Get Your Files Here !/01 - Section 1 Loading our Software and Data/005 Loading our data.mp4
104.7 MB
~Get Your Files Here !/01 - Section 1 Loading our Software and Data/005 Loading our data_en.vtt
12.5 KB
~Get Your Files Here !/01 - Section 1 Loading our Software and Data/006 Important!!! - Fixing the .qgs file if you cannot connect to Postgres.mp4
21.6 MB
~Get Your Files Here !/01 - Section 1 Loading our Software and Data/006 Important!!! - Fixing the .qgs file if you cannot connect to Postgres_en.vtt
2.9 KB
~Get Your Files Here !/01 - Section 1 Loading our Software and Data/007 Setting up our system.mp4
61.2 MB
~Get Your Files Here !/01 - Section 1 Loading our Software and Data/007 Setting up our system_en.vtt
6.8 KB
~Get Your Files Here !/01 - Section 1 Loading our Software and Data/19867271-spatialsql.pdf
2.3 MB
~Get Your Files Here !/01 - Section 1 Loading our Software and Data/pg_qgs.qgs
162.6 KB
~Get Your Files Here !/01 - Section 1 Loading our Software and Data/pg_qgs.qgz
17.4 KB
~Get Your Files Here !/01 - Section 1 Loading our Software and Data/tompkins.backup
69.2 MB
~Get Your Files Here !/02 - Section 2 Overview of SQL/001 The case for SQL.mp4
185.9 MB
~Get Your Files Here !/02 - Section 2 Overview of SQL/001 The case for SQL_en.vtt
20.4 KB
~Get Your Files Here !/03 - Section 3 SQL Data Types/001 Numeric data types.mp4
155.9 MB
~Get Your Files Here !/03 - Section 3 SQL Data Types/001 Numeric data types_en.vtt
19 KB
~Get Your Files Here !/03 - Section 3 SQL Data Types/002 Boolean and Character data types.mp4
175 MB
~Get Your Files Here !/03 - Section 3 SQL Data Types/002 Boolean and Character data types_en.vtt
16.5 KB
~Get Your Files Here !/03 - Section 3 SQL Data Types/003 Date and Time data types.mp4
57.4 MB
~Get Your Files Here !/03 - Section 3 SQL Data Types/003 Date and Time data types_en.vtt
8 KB
~Get Your Files Here !/03 - Section 3 SQL Data Types/004 Spatial data types.mp4
91.4 MB
~Get Your Files Here !/03 - Section 3 SQL Data Types/004 Spatial data types_en.vtt
9 KB
~Get Your Files Here !/04 - Section 4 Traditional SQL/001 SELECT Statements (and their variants).mp4
163.1 MB
~Get Your Files Here !/04 - Section 4 Traditional SQL/001 SELECT Statements (and their variants)_en.vtt
20.8 KB
~Get Your Files Here !/04 - Section 4 Traditional SQL/002 Aggregate and GROUP BY functions.mp4
170.2 MB
~Get Your Files Here !/04 - Section 4 Traditional SQL/002 Aggregate and GROUP BY functions_en.vtt
18.4 KB
~Get Your Files Here !/04 - Section 4 Traditional SQL/003 Creating new data (UPDATE, INSERT, and DELETE functions).mp4
116.1 MB
~Get Your Files Here !/04 - Section 4 Traditional SQL/003 Creating new data (UPDATE, INSERT, and DELETE functions)_en.vtt
13.2 KB
~Get Your Files Here !/04 - Section 4 Traditional SQL/004 Conditional statements with SQL CASE.mp4
120.7 MB
~Get Your Files Here !/04 - Section 4 Traditional SQL/004 Conditional statements with SQL CASE_en.vtt
15.9 KB
~Get Your Files Here !/05 - Section 5 Spatial SQL/001 Coordinate Systems and SQL.mp4
110 MB
~Get Your Files Here !/05 - Section 5 Spatial SQL/001 Coordinate Systems and SQL_en.vtt
12.1 KB
~Get Your Files Here !/05 - Section 5 Spatial SQL/002 Spatial (and non-spatial) indexes and SQL.mp4
76.1 MB
~Get Your Files Here !/05 - Section 5 Spatial SQL/002 Spatial (and non-spatial) indexes and SQL_en.vtt
11.6 KB
~Get Your Files Here !/05 - Section 5 Spatial SQL/003 Spatial Commands - part 1 (A-C).mp4
155.2 MB
~Get Your Files Here !/05 - Section 5 Spatial SQL/003 Spatial Commands - part 1 (A-C)_en.vtt
16.9 KB
~Get Your Files Here !/05 - Section 5 Spatial SQL/004 Spatial Commands - part 2 (D-U).mp4
161.1 MB
~Get Your Files Here !/05 - Section 5 Spatial SQL/004 Spatial Commands - part 2 (D-U)_en.vtt
19.6 KB
~Get Your Files Here !/06 - Section 6 Geographic Models with Spatial SQL/001 Basic Problems in Geography.mp4
114.8 MB
~Get Your Files Here !/06 - Section 6 Geographic Models with Spatial SQL/001 Basic Problems in Geography_en.vtt
15.1 KB
~Get Your Files Here !/06 - Section 6 Geographic Models with Spatial SQL/002 Variogram modeling with SQL.mp4
66.9 MB
~Get Your Files Here !/06 - Section 6 Geographic Models with Spatial SQL/002 Variogram modeling with SQL_en.vtt
10.6 KB
~Get Your Files Here !/06 - Section 6 Geographic Models with Spatial SQL/003 The tools of spatial analysis Distance, adjacency, and Interaction.mp4
94.1 MB
~Get Your Files Here !/06 - Section 6 Geographic Models with Spatial SQL/003 The tools of spatial analysis Distance, adjacency, and Interaction_en.vtt
13.8 KB
~Get Your Files Here !/07 - Real World Applications with Spatial SQL/001 Creating functions with Postgres and PostGIS.mp4
91 MB
~Get Your Files Here !/07 - Real World Applications with Spatial SQL/001 Creating functions with Postgres and PostGIS_en.vtt
7.5 KB
~Get Your Files Here !/07 - Real World Applications with Spatial SQL/002 Summarizing parcel data with a watershed and floodzone.mp4
44.2 MB
~Get Your Files Here !/07 - Real World Applications with Spatial SQL/002 Summarizing parcel data with a watershed and floodzone_en.vtt
