EPOS

h1. About WFS App Schema for BoreholeView

h2. ## Workspace gsmlp can be found here :

- https://forge.brgm.fr/svnrepository/epos/trunk/tools/geoserver/

h2. ## Trusted environment

App schema has been successfully set up with those versions of GeoServer:

- BRGM: GeoServer 2.8.0

h2. ## DB part

App schema is 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