1. 1. Introduction
    1. 1.1 OGC Standards
      1. Introduction to OGC
      1. 1.1.1 Web Mapping Service
        1. Introduction to WMS
        2. WMS Examples
      1. 1.1.2 Web Feature Service
        1. Introduction to WFS
        2. WFS Examples
      1. 1.1.3 Web Coverage Service
        1. Introduction to WCS
        2. WCS Examples
      1. 1.1.4 Web Processing Service
        1. Introduction to WPS
        2. WPS Examples
    1. 1.2 CAAML
      1. Introduction to CAAML
    1. 1.3 INSPIRE
      1. Introduction to INSPIRE
  1. 2. Standards in action
    1. 2.1 Prepare data and toolkit
      1. Data and geospatial tools
      2. Start the environment
      1. 2.1.1 Manage the data
        1. Load Data
        2. Clean Data
      1. 2.1.2 Design the CAAML schema
        1. CAAML model design
        2. Populate Region
    1. 2.2 Build CAAML with GeoAvalanche
      1. Configure the application schema for CAAML
      2. Push the configuration to GeoAvalanche
      3. Query our Region features
  1. 3. Main Chapter
    1. Lesson Six

Load Data

Load the shapefile into PostGIS

The first thing to do is to add the dataset mnz_italy to our PostGIS database caaml_data. QGIS is the quick way to go. Let's go through the screenshot below after having extracted the shapefile from the archive in the folder data.

Add the shapefile to QGIS

add shape qgis

We should see something like this:

view shape qgis

Create a new PostGIS connection for caaml_data

open connection qgis

Click on new for create a new connection

add connection qgis

Fill the fields with the same connection parameters used for PGAdmin4

postgis connect qgis

Click ok and then connect.

Load the shapefile into the connected schema

open dbmanager qgis

then click the down arrow icon and fill the fields with the preferences on how the shapefile has to be imported into a PostGIS table.

load shapefile qgis

Important notes:

  • The name of the final table mzn
  • The name of the geometry column shape
  • The reprojection from the source SRID EPSG:32632 to EPSG:4326 with geographic coordinates
  • The setting to create a spatial index for the geometry column