Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Web-GIS with Open Source and ArcPy for ArcGIS Pro
Rating: 4.3 out of 5(12 ratings)
63 students

Web-GIS with Open Source and ArcPy for ArcGIS Pro

Learn to manage spatial data using GeoServer, PostGIS, OpenLayers, and automate analysis with ArcPy
Last updated 8/2024
English

What you'll learn

  • Download, install, and configure PostgreSQL with PostGIS to create spatially enabled geodatabases.
  • Import and manage GIS spatial data efficiently within PostgreSQL databases.
  • Install GeoServer, create workspaces, connect to spatial data stores, and apply styles to maps.
  • Integrate ESRI data into GeoServer and prepare map styles using QGIS for enhanced visualization.
  • Develop interactive web maps with OpenLayers, adding layers, map rotation, default extent, and scale controls.
  • Write and execute Python scripts using ArcPy to automate geospatial analysis in ArcGIS Pro.
  • Perform spatial analyses like buffer creation, field management, and geoprocessing with ArcPy.
  • Export map documents programmatically from ArcGIS Pro to PDF using Python scripting.

Course content

5 sections26 lectures3h 4m total length
  • Download and Install PostGIS7:20

    This lecture introduces the process of downloading and installing the PostgreSQL database and adding the PostGIS spatial extension. It begins with navigating to the official PostgreSQL website, where learners will select the appropriate installer for their Windows operating system and proceed with the download.

    The installation workflow covers choosing the installation directory, selecting essential components, setting up a username and password, and configuring the port and locale. After installing PostgreSQL, learners will use the Stack Builder tool to install the PostGIS 3.0 extension, enhancing PostgreSQL with spatial database capabilities.

    Finally, the lecture demonstrates verifying the installation by launching pgAdmin, a management tool for PostgreSQL. Learners will log in with their credentials and confirm the successful setup of the database and its spatial functions.

    Key topics covered in this lecture:

    • Accessing and downloading PostgreSQL from the official site

    • Step-by-step PostgreSQL installation on Windows

    • Configuration of installation parameters including user credentials and ports

    • Using Stack Builder to add the PostGIS extension

    • Features and options during the PostGIS installation

    • Verification of the installation through pgAdmin management interface

    • Basic login and connection procedures to the PostgreSQL database

    Practical value for web-GIS development:

    • Setting up an essential backend database for spatial data management

    • Enabling advanced geospatial functionality through PostGIS

    • Providing foundational skills for managing and deploying spatial databases

    • Understanding the initial setup required before working with web-GIS platforms

    After completing this lecture, learners will understand how to properly download, install, and configure PostgreSQL with the PostGIS extension. They will be able to verify their installation and prepare their environment for spatial data projects aligned with web-GIS development workflows.

  • Create Database in PostgreSQL with PostGIS6:15

    This lecture introduces how to create a new spatial database in PostgreSQL using the pgAdmin interface. You will learn the step-by-step process of establishing a fresh database and preparing it for geospatial data by enabling the PostGIS extension.

    The workflow includes accessing the PostgreSQL server via pgAdmin, creating a new database named GISDB, and enabling PostGIS to add spatial capabilities. You'll also explore the database's schema and understand the importance of PostGIS functions and tables within the database environment.

    By following this lesson, you gain practical skills to set up a geospatial database as the foundation for working with spatial data and services in a Web-GIS stack.

    Key topics covered in this lecture:

    • Accessing PostgreSQL server through pgAdmin

    • Creating a new database in PostgreSQL

    • Add and configure the PostGIS extension

    • Reviewing database schema and spatial functions

    • Understanding spatial reference system tables

    Practical value for Web-GIS development:

    • Set up a geospatially enabled database ready for spatial data storage

    • Prepare your database for integration with GIS servers and web components

    • Understand spatial functions that support geometry operations in PostgreSQL

    After completing this lesson, you will be able to create and configure a PostgreSQL database with PostGIS enabled, laying the groundwork for managing and deploying spatial data in your Web-GIS projects.

  • Add GIS Data to PostgreSQL Database7:19

    In this lecture, you will learn how to add geographic information system (GIS) data into a PostgreSQL spatial database using the PostGIS Shapefile and DBF Loader tool. This process is essential for managing spatial datasets within a robust database environment.

    The workflow starts by locating and opening the PostGIS shapefile importer tool from the Start menu or the installed PostGIS bundle. You will establish a connection to your PostgreSQL database by entering the necessary connection parameters, such as username, password, server host, port, and database name.

    Once connected, the lecture guides you step-by-step through loading various GIS data files (points, polygons, and lines) by selecting shapefiles, assigning the correct spatial reference identifier (SRID), and importing them into the database. You will also see how to handle potential errors, such as missing SRID, and verify your imported spatial tables within the PostgreSQL database schema.

    Key topics covered in this lecture:

    • Opening and using the PostGIS shapefile importer interface

    • Creating and managing database connections to PostgreSQL

    • Selecting and adding different GIS shapefiles (points, polygons, lines)

    • Setting the correct SRID for spatial data (WGS 1984 - EPSG 4326)

    • Handling import errors related to SRID values

    • Verifying imported tables in the PostgreSQL database

    • Deleting and re-importing shapefiles in case of conflicts

    Practical value for geospatial data deployment:

    • Enables reliable import of spatial data for web-GIS applications

    • Prepares GIS data for further spatial queries and analysis

    • Facilitates integration of spatial datasets into PostGIS-enabled databases

    • Supports data management for open-source web mapping workflows

    After completing this lecture, you will be able to confidently import various GIS shapefiles into your PostgreSQL/PostGIS database with correct spatial referencing, ensuring your spatial data is well-prepared for further web-based GIS development and analysis.

Requirements

  • Basic understanding of GIS concepts and terminology.
  • Access to a Windows computer with internet to install required software.
  • No prior programming experience required; Python scripting is introduced from scratch.

Description

This course offers an in-depth journey into the development, management, and deployment of spatial data for web-based Geographic Information Systems (Web-GIS) using a combination of free open source tools and ArcPy scripting within ArcGIS Pro. You will learn practical workflows that empower you to integrate databases, map servers, web mapping libraries, and Python automation to create professional-grade GIS web applications.

We begin with PostgreSQL and PostGIS, where you will download, install, and configure a powerful spatial database environment. This foundational knowledge sets you up to store, manage, and query spatial data efficiently, a critical skill in any spatial data science or GIS professional's toolkit.

The course then guides you through GeoServer for publishing and styling spatial data. You will discover how to set up GeoServer workspaces, connect to spatial data stores, apply map styles, and extend functionality by integrating ESRI data with custom styles prepared in QGIS. This section equips you with the ability to manage and serve spatial data via open web standards, an essential part of modern Web-GIS solutions.

Building on this, OpenLayers is introduced as the front-end technology for interactive web map development. You will learn to publish layers from GeoServer, embed map controls like rotation, default extent reset, and scale lines, crafting fully interactive and user-friendly web maps accessible on the Internet.

Complementing open source tools, the course explores Python programming with ArcPy inside ArcGIS Pro. You will automate key GIS processes, run spatial analyses such as buffering, manage attribute fields, utilize geoprocessing tools, and export map documents. These skills provide the foundation for automating GIS workflows and extending ArcGIS Pro functionalities programmatically.

Following the AulaGEO methodology, the course is structured from the ground up with step-by-step demonstrations using real data and example cases. This approach ensures clarity and hands-on experience, enabling you to build practical skills from installation through advanced geospatial web applications and automation.

Learning Objectives

Upon completing this course, you will be able to:

  • Download, install, and configure PostgreSQL with PostGIS to create spatially enabled databases.

  • Import and manage GIS data within PostgreSQL databases.

  • Install and configure GeoServer, create workspaces, connect to data stores, and apply styling to spatial data.

  • Integrate ESRI data into GeoServer and craft styles using QGIS for advanced map visualization.

  • Develop interactive web maps using OpenLayers, adding layers, map rotation, default extent, and scale controls.

  • Write and run Python scripts with ArcPy to automate spatial analyses and GIS workflows in ArcGIS Pro.

  • Execute buffer analyses, field management, and geoprocessing tasks using ArcPy.

  • Export ArcGIS Pro map documents to PDF programmatically.

  • Employ best practices in Python programming for geospatial tasks using ArcPy modules.

Who Should Take This Course

  • GIS professionals seeking to extend skills in spatial databases and web GIS deployment.

  • Developers interested in open source spatial data management and web mapping technologies.

  • Students and practitioners wanting to learn Python scripting within ArcGIS Pro for spatial automation.

  • Professionals aiming to integrate enterprise GIS technology stacks using PostgreSQL, GeoServer, and OpenLayers.

  • Individuals with basic GIS knowledge eager to expand into web GIS and Python programming in ArcGIS.

  • Analysts who want to automate geoprocessing tasks with ArcPy workflows.

Course Structure

Section 1: PostgreSQL - PostGIS
Learn to download, install, configure PostgreSQL with PostGIS, create spatial databases, and import GIS data for geospatial use.

Section 2: GeoServer
Understand GeoServer installation, workspace setup, connecting data stores, and styling spatial data for web map services.

Section 3: Advanced GeoServer Styling and Data Integration
Explore adding ESRI data to GeoServer and preparing styles with QGIS for professional-grade map visualizations.

Section 4: OpenLayers Web Map Development
Master OpenLayers to publish GeoServer layers, add map rotation, default extent controls, and scale bars for interactive web maps.

Section 5: Python Programming with ArcPy in ArcGIS Pro
Use Python and ArcPy in ArcGIS Pro to automate GIS tasks, perform spatial analysis, field management, and export maps.

Why Take This Course

This course bridges vital competencies in open source spatial database management, web GIS server configuration, interactive web mapping, and desktop GIS automation with Python. By combining these skills, you can build efficient, scalable, and customizable GIS web applications that meet modern spatial data deployment needs.

You will gain hands-on experience setting up robust backend data services with PostgreSQL/PostGIS and GeoServer, enabling you to serve spatial data securely and flexibly over the web. Learning OpenLayers empowers you to deliver rich, user-centric interactive maps accessible by any web browser without proprietary software.

Additionally, the ArcPy scripting section allows you to automate repetitive GIS workflows inside ArcGIS Pro, enhancing productivity and enabling integration with broader Python ecosystems for data science and geospatial analysis.

Taken together, this knowledge equips you for careers in GIS development, spatial data analysis, and geospatial web application design across industry, research, and government sectors.

Professional Context

Spatial data and web GIS technologies are increasingly critical for decision-making in urban planning, environmental management, utilities, transportation, and many other domains. Mastery of open source GIS tools combined with Python automation underpins the ability to deliver scalable, extensible geospatial solutions that are cost-effective and adaptable.

This course prepares GIS professionals, analysts, and developers to confidently implement full-stack geospatial workflows from database creation through web deployment and automation, ensuring readiness to meet growing market demands for spatial data expertise.

Who this course is for:

  • GIS professionals wanting to extend skills in spatial databases and web GIS deployment.
  • Developers interested in open source GIS data management and web mapping technologies.
  • Students and practitioners eager to learn Python scripting within ArcGIS Pro for automation.
  • Those aiming to integrate PostgreSQL, GeoServer, and OpenLayers for enterprise GIS solutions.
  • Analysts seeking to automate geoprocessing workflows using ArcPy scripting.
  • GIS users with basic experience looking to build end-to-end web GIS applications.
  • Professionals involved in spatial data publishing, styling, and interactive map deployment.
  • Anyone interested in combining open source spatial tools with ArcPy for GIS automation.