Packt Learning the FOSS4G Stack Spatial SQL with Postgres PostGIS-XQZT

Another exquisit release
Packt.Learning.the.FOSS4G.Stack.Spatial.SQL.with.Postgres.PostGIS-XQZT
     Title: ^title^
 Publisher: Packt
      Size: 1.2G (1215855612 B)
     Files: 5F
      Date: 03/31/2020
  Course #: 9781800203877
      Type: N/A
 Published: 31 Mar 2020
  Modified: N/A
       URL: www.packtpub.com/programming/learning-the-foss4g-stack-spatial-sql-with-postgres-postgis-video
    Author: N/A
  Duration: 4 hours 40 minutes
     Skill: N/A
 Exer/Code: [X]
Installation:
Unpack that shit, run that shit
Description:
This course is part of an entire curriculum based on free and open
source GIS (FOSS4g) software. The curriculum is grouped into
different categories of the FOSS4g stack - Desktop, Server, and
Developer. As part of this course, you will learn the most
popular open source database - Postgres 11.
Youll start with the
basics of Postgres, explore PostGIS as a spatial plugin, and then go
on to solve spatial problems using SQL. The 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 also explore the
capabilities of SQL, working with raster, vector, and
attribute data. After youve learned SQL and spatial SQL, youll
understand how to simulate real-world examples of GIS projects and
spatial analysis.
By the end of this course, you will be
well-versed with the FOSS4g stack and be equipped with the
skills you need for everything from conducting spatial
analysis to solving spatial problems using SQL.
All the codes and
supporting files for this course are available at:

1.2G	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]
167M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/1.Loading our Software and Data
4.7M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/1.Loading our Software and Data/01.Introduction.mp4
53M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/1.Loading our Software and Data/02.Installing Postgres 11.mp4
2.2M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/1.Loading our Software and Data/03.Installing QGIS 3.8.mp4
11M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/1.Loading our Software and Data/04.Our Data.mp4
20M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/1.Loading our Software and Data/05.Loading our data.mp4
52M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/1.Loading our Software and Data/06.Important!!! - Fixing the .qgs file if you cannot connect to Postgres.mp4
25M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/1.Loading our Software and Data/07.Setting up our system.mp4
64M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/2.Overview of SQL
64M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/2.Overview of SQL/08.The case for SQL.mp4
200M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/3.SQL Data Types
68M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/3.SQL Data Types/09.Numeric data types.mp4
70M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/3.SQL Data Types/10.Boolean and Character data types.mp4
29M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/3.SQL Data Types/11.Date and Time data types.mp4
34M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/3.SQL Data Types/12.Spatial data types.mp4
249M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/4.Traditional SQL
73M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/4.Traditional SQL/13.SELECT Statements (and their variants).mp4
72M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/4.Traditional SQL/14.Aggregate and GROUP BY functions.mp4
49M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/4.Traditional SQL/15.Creating new data (UPDATE, INSERT, and DELETE functions).mp4
57M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/4.Traditional SQL/16.Conditional statements with SQL - CASE.mp4
196M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/5.Spatial SQL
44M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/5.Spatial SQL/17.Coordinate Systems and SQL.mp4
13M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/5.Spatial SQL/18.Spatial (and non-spatial) indexes and SQL.mp4
69M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/5.Spatial SQL/19.Spatial Commands - part 1 (A-C).mp4
71M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/5.Spatial SQL/20.Spatial Commands - part 2 (D-U).mp4
124M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/6.Geographic Models with Spatial SQL
46M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/6.Geographic Models with Spatial SQL/21.Basic Problems in Geography.mp4
33M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/6.Geographic Models with Spatial SQL/22.Variogram modeling with SQL.mp4
47M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/6.Geographic Models with Spatial SQL/23.The tools of spatial analysis - Distance, adjacency, and Interaction.mp4
120M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/7.Real World Applications with Spatial SQL
26M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/7.Real World Applications with Spatial SQL/24.Creating functions with Postgres and PostGIS.mp4
94M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/7.Real World Applications with Spatial SQL/25.Summarizing parcel data with a watershed and floodzone.mp4
44M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/Exercise Files
44M	Learning the FOSS4G Stack - Spatial SQL with Postgres_PostGIS [Video]/Exercise Files/code_9781800203877.zip
1.2G	total