Этот материал находится в платной подписке. Оформи премиум подписку и смотри или слушай Learning Open Source GIS: Spatial SQL w/ Postgres/PosGIS, а также все другие курсы, прямо сейчас!
Премиум
  • Урок 1. 00:04:31
    Introduction
  • Урок 2. 00:05:56
    Installing Postgres 11
  • Урок 3. 00:02:32
    Installing QGIS 3.8
  • Урок 4. 00:05:33
    Our Data
  • Урок 5. 00:11:51
    Loading our data
  • Урок 6. 00:02:34
    Important!!! - Fixing the .qgs file if you cannot connect to Postgres
  • Урок 7. 00:06:24
    Setting up our system
  • Урок 8. 00:18:24
    The case for SQL
  • Урок 9. 00:17:25
    Numeric data types
  • Урок 10. 00:16:56
    Boolean and Character data types
  • Урок 11. 00:07:23
    Date and Time data types
  • Урок 12. 00:09:15
    Spatial data types
  • Урок 13. 00:19:39
    SELECT Statements (and their variants)
  • Урок 14. 00:18:10
    Aggregate and GROUP BY functions
  • Урок 15. 00:13:11
    Creating new data (UPDATE, INSERT, and DELETE functions)
  • Урок 16. 00:15:48
    Conditional statements with SQL: CASE
  • Урок 17. 00:12:00
    Coordinate Systems and SQL
  • Урок 18. 00:11:00
    Spatial (and non-spatial) indexes and SQL
  • Урок 19. 00:16:25
    Spatial Commands - part 1 (A-C)
  • Урок 20. 00:18:03
    Spatial Commands - part 2 (D-U)
  • Урок 21. 00:13:48
    Basic Problems in Geography
  • Урок 22. 00:09:33
    Variogram modeling with SQL
  • Урок 23. 00:12:38
    The tools of spatial analysis: Distance, adjacency, and Interaction
  • Урок 24. 00:10:01
    Creating functions with Postgres and PostGIS
  • Урок 25. 00:05:18
    Summarizing parcel data with a watershed and floodzone