К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Query Spatial with PostGIS · LearnSpace
Назад в каталог
courseraАнализ данных

Query Spatial with PostGIS

Курс от Coursera
Начальный≈ 2.6 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

Querying spatial data effectively starts with understanding how geography is modeled, indexed, and analyzed inside a relational database. In this hands-on course, you’ll move beyond basic SQL by learning how to query geospatial data using PostGIS, PostgreSQL’s spatial extension. You’ll begin by working with core geometry types and spatial reference systems, building a foundation for how location data is stored and interpreted. From there, you’ll write spatial queries that perform distance calculations, proximity searches, and spatial joins to answer real-world questions. As you progress, you’ll explore spatial indexing and query patterns that improve performance and reliability as datasets grow. By the end of the course, you’ll produce reusable spatial SQL queries and analysis patterns that support practical use cases in areas such as logistics, urban planning, and geospatial data engineering—equipping you to work confidently with location-based data in production environments.

Навыки, которые вы освоите

SQLPerformance TuningSpatial AnalysisGeographic Information SystemsQuery LanguagesSpatial Data AnalysisPostgreSQLDatabase DevelopmentGIS SoftwareGeospatial Information and Technology

Программа курса

3 модулей · 16 учебных материалов

01Index First: Creating Spatial Indexes in PostGIS5 материалов
Why Spatial Indexes Are the First Step to Reliable Spatial QueriesDIALOGUEIntroduction to the SME and the Course ВидеоSpatial Indexing in PostGIS: How Geometry Indexes Enable Fast Spatial QueriesЧтениеThinking in Distances, Not Just TablesВидео

Учитесь у экспертов

Professionals in the Industry

ansrsource instructors

Query Spatial with PostGIS
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 2.6 ч

3 модулей

Язык: Английский

Субтитры: Арабский, Французский, Итальянский, Бразильский португальский, Корейский, Немецкий, Испанский, Японский

Часть программы вашего университета
Hands-On Learning: Creating a Spatial Index on a Geometry ColumnЗадание
02Finding Nearby Features with Spatial SQL5 материалов
Shifting from SQL Logic to Spatial ReasoningDIALOGUEUsing Spatial SQL to Find Nearby FeaturesВидеоUnderstanding Distance-Based Queries in PostGISЧтениеHands-On Learning: Finding Parcels Within 100 Meters of Schools Using PostGISЗаданиеPractice Quiz: Applying Spatial SQL for Proximity AnalysisЗадание
03Understanding Query Performance with EXPLAIN ANALYZE6 материалов
Reading the Story Behind a QueryDIALOGUEInterpreting EXPLAIN ANALYZE Output in PostGISЧтениеUsing EXPLAIN ANALYZE to Improve Spatial Query PerformanceВидеоHands-On Learning: Optimizing a Proximity Query for a Compliance AuditЗаданиеCongratulations and Your Continuous Learning JourneyВидеоGraded Assessment: Evaluating Spatial Queries and Performance in PostGISЗадание