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 (for xsd version 0.5.0)¶

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

boreholeid character varying NOT NULL,
  gmlidentifier character varying,
  name character varying,
  gsmlpidentifier character varying,
  description character varying(255),
  purpose_href character varying(255),
  purpose character varying(50),
  boreholeuse character varying(50),
  boreholeuse_href character varying(255),
  status_href character varying(255),
  status character varying(30),
  drillingmethod_href character varying(255),
  drillingmethod character varying(50),
  operator character varying(50),
  driller character varying(50),
  drillstartdate date,
  drillenddate date,
  startpoint_href character varying(255),
  startpoint character varying(30),
  inclinationtype_href character varying(255),
  inclinationtype character varying(30),
  boreholematerialcustodian character varying(50),
  boreholelength_m real,
  elevation_m real,
  elevation_srs character varying,
  positionalaccuracy real,
  source character varying,
  parentborehole_uri character varying,
  metadata_uri character varying,
  genericsymbolizer character varying(50),
  cored boolean,
  accesstophysicaldrillcore boolean,
  detaileddescription character varying(255),
  detaileddescription_href character varying(255),
  geophysicallogs character varying(255),
  geophysicallogs_href character varying(255),
  geologicaldescription character varying(255),
  geologicaldescription_href character varying(255),
  groundwaterlevel character varying(255),
  groundwaterlevel_href character varying(255),
  groundwaterchemistry character varying(255),
  groundwaterchemistry_href character varying(255),
  rockgeochemistry character varying(255),
  rockgeochemistry_href character varying(255),
  poregaschemistry character varying(255),
  poregaschemistry_href character varying(255),
  geotechnicalinfo character varying(255),
  geotechnicalinfo_href character varying(255),
  location_wgs84 geometry,

## app-schema.properties¶

The datastore part from gsmlp_BoreholeView.xml is linked to a app-schema.properties file.

This file actually indicate how app-schema should connect to your database.
It should be put in geoserver/WEB-INF/classes.