Course Description

Welcome to the Building Web GIS Apps with C# ASP.NET CORE MVC and Leaflet course. We'll be building a Full-stack MVC-style Web Application using the .NET Core Framework. The purpose of this course and many more to follow is to learn to create geospatial analytics and convert it into a functional application.

In our use case, we will be working with suburban water consumption data and we will be applying data processing techniques to extract, transform and load the data into our spatial database. Once we have processed and cleaned the data, we will use it as a data source for building our .NET Core Web Map Application.

We will be powering our application with a PostgreSQL and PostGIS database. In the Front-End we'll use Bootstrap, JavaScript, Leaflet, and Ajax. On the server-side we'll be using C#, ASP.NET CORE MVC, combined with the use of libraries like Entity Framework Core, Newtonsoft.Json, and Npgsql for our data transformation and conversion operations. The operating system that we will be working on is Windows 10 and Server 2016.

Course curriculum

  1. 01
  2. 02
    • Installing PostgreSQL and PostGIS

    • Creating a spatial database using pgAdmin

    • Installing OSGeo4W

  3. 03
  4. 04
    • Creating the model

    • Creating the data context interface

    • Creating the implementation class

    • Configuring connection with PostgreSQL database

    • Creating database migrations

    • Creating the data repository

    • Creating the repository implementation class

  5. 05
    • Downloading dataset

    • Extracting, transforming and loading dataset in database

    • Creating the REST controller class

  6. 06
    • Downloading static files

    • Modifying layout of the application

    • Modifying index.html

    • Creating our first leaflet map

    • Creating multiple basemaps

    • Displaying data on map

    • Styling the data

    • Adding interactive objects on map

    • Creating the map legend

    • Creating bar charts (1/2)

    • Creating bar charts (2/2)

  7. 07
    • WaterWatch

Pricing - Life time Access

What will you learn?

  • Ηow to build a Spatial Database using Postgresql and PostGIS.

  • Ηow to create charts with Chart.js.

  • Ηow to build Web Maps with Leaflet.js.

  • How to build REST API Endpoints with C# and LINQ.

  • Some C# programming.

  • Some JavaScript programming.

  • How to build Web Applications using the C# and ASP.NET Core MVC Framework.

GEO Premium

Access our ENTIRE content instantly with a subscription

Student profile?

  • Undergraduate students

  • Master students and PhD candidates

  • Researchers and Academics

  • Professionals and Companies

Some more information

  • Certificates of Completion

    After you successfully finish the course, you can claim your Certificate of Completion with NO extra cost! You can add it to your CV, LinkedIn profile etc

  • Available at any time! Study at your best time

    We know hard it is to acquire new skills. All our courses are self paced.

  • Online and always accessible

    Even when you finish the course and you get your certificate, you will still have access to course contents! Every time an Instructor makes an update you will be notified and be able to watch it for FREE

About your Instructors

Data Engineer and business intelligence consultant with an academic background in Bsc computer science and around 5 years of experience in IT. Involved in multiple projects ranging from Business Intelligence, Software Engineering, IoT and Big data analytics. Expertise are in building data processing pipelines in the Hadoop and Cloud ecosystems and software development. My career started as an embedded software engineer writing firmware for integrated microchips, then moved on as an ERDAS APOLLO developer at geo data design a hexagon geospatial partner. Am now a consultant at one of the top business intelligence consultancies helping clients build data warehouses, data lakes, cloud data processing pipelines and machine learning pipelines. The technologies I use to accomplish client requirements range from Hadoop, Amazon S3, Python, Django, Apache Spark, MSBI, Microsoft Azure, SQL Server Data Tools, Talend and Elastic MapReduce.

Edwin Bomela

Data Engineer and business intelligence consultant