About WFS App Schema for BoreholeView¶

# Trusted environment¶

This app schema has been successfully set up with those versions of GeoServer:
- BRGM ressource-rec: GeoServer 2.8.0
- BRGM epos-rec: GeoServer 2.9.2

# Link to resources¶

Several content are offered in https://forge.brgm.fr/svnrepository/epos/trunk/tools/geoserver/

# Tips for configuration of App-schema¶

## workspace¶

The content of workspaces (the gsmlp folder) should be put in your geoserver/data/workspaces.

## DB part¶

App schema provided in SVN is actually set up for one table called "borehole" with those columns:

boreholeid bigserial NOT NULL,
  boreholeviewid character varying(50),
  identifier character varying(255),
  name character varying(50),
  description character varying(255),
  purpose character varying(50),
  status character varying(30),
  drillmethod character varying(50),
  operator character varying(50),
  driller character varying(50),
  drillstartdate date,
  drillenddate date,
  startpoint character varying(30),
  inclinationtype character varying(30),
  boreholematerialcustodian character varying(50),
  boreholelength_m numeric(4,0),
  elevation_m numeric(5,0),
  elevation_srs character varying(2000),
  positionalaccuracy numeric(3,0),
  source character varying(50),
  parentborehole_uri character varying(2000),
  metadata_uri character varying(2000),
  genericsymbolizer character varying(50),
  cored boolean DEFAULT false,
  accesstophysicaldrillcore boolean DEFAULT false,
  drilldepth_m numeric(5,0),
  existsdetaileddescription boolean DEFAULT false,
  existsgeophysicallogs boolean DEFAULT false,
  existsgeologicaldescription boolean DEFAULT false,
  existsgroundwaterlevel boolean DEFAULT false,
  existsrockgeochemistry boolean DEFAULT false,
  existsporegaschemistry boolean DEFAULT false,
  existsgeotechnicalinfo boolean DEFAULT false,
  existsgroundwaterchemistry boolean DEFAULT false,
  purpose_href character varying(255),
  status_href character varying(255),
  drillingmethod_href character varying(255),
  inclinationtype_href character varying(255),
  startpoint_href character varying(255)

app-schema.properties¶

This file should be put in geoserver/WEB-INF/classes.
Information from it are used by the datastore part of the gsmlp_BoreholeView.xml file.
It actually indicate how app-schema should connect to your database.