Implementing a simple CRUD application that demonstrates vector editing via web interfaces

Our final example in this chapter demonstrates some simple spatial CRUD functionality. CRUD stands for Create, Read, Update, Destroy, so to put it simply we'll edit some features on the map. We will do it using ol3.

WebGIS CRUD server in Node.js

In order to expose our crud API, we will need some storage for our features, so let's start with creating a table of the geometries first:

create table webgis.crud (id serial NOT NULL, geom geometry); 

Once this is ready, we will need a simple web server to handle our CRUD operations. Let's take care of that.

First, we need to put some packages in place:

npm install express --save
npm install body-parser --save
npm install pg --save

Once the appropriate packages are installed, let's create our server:

const pg = require("pg"); 
const express = require('express'); 
const app = express(); 

const bodyParser = require('body-parser'); 

// configure app to use bodyParser...