"Seegrid will be due for a migration to confluence on the 1st of August. Any update on or after the 1st of August will NOT be migrated"

Work on (and behind) the WFS Server

Current status

A new build of geotools and geoserver to put the learnings of the SEEGrid community into the mainstream capabilities of geotools and geoserver is underway. An initial release of the the code is available:

GeoserverBuild

see Docs for New Geoserver (branch)

History

How to set up Geoserver - "complex_SCO" branch as developed in the SEEGrid Roadmap - AusIndustry/MCA project

-- JonathanDoig - 14 Apr 2005

Responses have been received from WFS software suppliers regarding their support for our requirements :

(NB responses include descriptions of the requirements)

-- JonathanDoig - 20 Apr 2005

Documents used to obtain approval for installation of Geoserver WFS in DIPNR:

-- JonathanDoig - 28 Apr 2005

A specification describing table structure and details for the Oracle Stored Procedure to release results from the DIPNR enterprise data base to Internet applications such as the Web Feature Server software is attached.

-- GrantRobinson - 12 May 2005

One deliverable of WQDP is to have the option produce maps showing WQ results categorised as GOOD / FAIR / POOR for a dataset.

This categorisation depends on the individual data set, and the end use of the water analysed. For the Key Sites dataset ANZNS0359100023 the categorisation is as follows:

First calculate the median of observations occurring in a 12 month period. If more than 50% of observations are missing (e.g. there are 6 or less results when monthly samples should have occurred) we do not have enough data to report, we must report the result as missing. If there are enough results, calculate the median. Compare the median to the categorisations for the analyte (e.g. Electrical conductivity)...

Electrical conductivity (Units are microsiemens per centimetre ÁS/cm - sometimes this does not appear correctly it should appear as greek lower case mu followed by S/cm)
  • 0-<280 = good
  • 280-800 fair
  • > 800 poor
These categories are based on water being abstracted for irrigation.

Note that we rarely measure salinity, but rather we normally measure electrical conductivity. There are various desktop methods of converting EC to salinity, but these all have various sources of error. Hence we are reporting on EC.

Turbidity (units are nephelometric turbidity units or NTU)
  • 0-<5 = good
  • 5 - 50 = fair
  • >50 = poor
These categories are based on: <5 NTU is the guideline for drinking water, <50 NTU is the guideline for protection of aquatic plants and animals.

Total phosphorus (units are milligrams per litre or mg/L)
  • 0-<0.02 = good
  • 0.02 - 0.05 = fair
  • >0.05 = poor
These categories are based on levels at which excessive algal growth is known to occur, set out by Bek & Robinson (1991).

Conventionally DWR/DLWC/DSNR/DIPNR has used colours for reporting water quality as follows: red=poor, yellow=fair, green=good

-- GrantRobinson - 20 June 2005

  • 32013.doc: Description of sample attributes in DIPNR WQ data system

-- GrantRobinson - 06 Jul 2005

Notes

  • the SAMPLE_ATTRIBUTES table is shown in WQIRRESULTS_structure_2005_07_06.gif as an extensible table of NAME,VALUE pairs. This is how it should be implemented, and thus how we think it should be shown in the schema. In Triton (and the export table), the sample attribute names are hard-coded as Oracle column names.
  • the different styles of relationship lines (normal undirected line vs bold arrow) in the structure diagrams are not significant.

-- JonathanDoig - 06 Jul 2005

Update:
  • Further investigation has shown that we should drop two fields.
  • To ensure that we extract the minimum number of fields to the WFS, we have identified three Oracle views in the attached spreadsheet...

  • developing_views_2005_08_12.doc: Notes on developing views to DIPNR WQDP Internet Released data. Contains important comments on how we identify anaytes to the WFS

-- GrantRobinson - 12 Aug 2005

-- GrantRobinson - 29 Aug 2005

-- GrantRobinson - 14 Jun 2006

-- Anonymous post - date unknown

-- GrantRobinson - 23 Oct 2006 (posted a bit late!)

-- GrantRobinson - 02 Nov 2006
Topic attachments
I Attachment Action Size Date Who Comment
32013.docdoc 32013.doc manage 86.5 K 06 Jul 2005 - 15:04 GrantRobinson Description of sample attributes in DIPNR WQ data system
CIO_re_WFS_Risks_and_Resourcing.docdoc CIO_re_WFS_Risks_and_Resourcing.doc manage 63.0 K 24 Jul 2006 - 17:27 JonathanDoig Brief #2 to DIPNR CIO re WFS - Risks and Resourcing
CIO_re_WFS_Strategy.docdoc CIO_re_WFS_Strategy.doc manage 38.5 K 24 Jul 2006 - 17:24 JonathanDoig Briefing to DIPNR CIO re Web Feature Service Strategy
CIO_re_WFS_Strategy_Attachments.docdoc CIO_re_WFS_Strategy_Attachments.doc manage 54.5 K 24 Jul 2006 - 17:25 JonathanDoig Attachments to CIO Briefing re WFS Strategy
TRITON_IR_2005_04_18v1_1.pdfpdf TRITON_IR_2005_04_18v1_1.pdf manage 59.2 K 18 Apr 2005 - 06:16 GrantRobinson This version is now superseded (13May2005)
TRITON_IR_2005_05_12v1_2.pdfpdf TRITON_IR_2005_05_12v1_2.pdf manage 46.2 K 13 May 2005 - 11:47 GrantRobinson Updated 12May2005 -- superseded 14 June 2006
TRITON_IR_2006_06_14v1_5.pdfpdf TRITON_IR_2006_06_14v1_5.pdf manage 132.8 K 14 Jun 2006 - 13:38 GrantRobinson Specification of DNR data version 1.5
WFS_Answers.docdoc WFS_Answers.doc manage 53.0 K 24 Jul 2006 - 17:26 JonathanDoig Answers to CIO's Web Feature Service Questions
WFS_requirements_Geoserver.xlsxls WFS_requirements_Geoserver.xls manage 19.5 K 20 Apr 2005 - 11:58 JonathanDoig Our requirements and Geoserver response from SCO
WQIRRESULTS_structure_2005_07_06.gifgif WQIRRESULTS_structure_2005_07_06.gif manage 42.8 K 06 Jul 2005 - 14:52 GrantRobinson Notional table structure -- superseded 12Aug2005
WQIRRESULTS_structure_2005_07_06.vsdvsd WQIRRESULTS_structure_2005_07_06.vsd manage 107.0 K 06 Jul 2005 - 14:50 GrantRobinson Notional table structure VISIO -- superseded 12Aug2005
WQIRRESULTS_structure_2005_08_12.gifgif WQIRRESULTS_structure_2005_08_12.gif manage 46.3 K 14 Aug 2005 - 17:25 GrantRobinson Notional table structure -- 12Aug2005 version
WQIRRESULTS_structure_2005_08_12.vsdvsd WQIRRESULTS_structure_2005_08_12.vsd manage 146.5 K 14 Aug 2005 - 17:23 GrantRobinson Notional table structure VISIO -- 12Aug2005 version
WQIRRESULTS_structure_plain_english.xlsxls WQIRRESULTS_structure_plain_english.xls manage 24.5 K 06 Jul 2005 - 14:50 GrantRobinson List of DIPNR fields -- superseded 12AUg2005
WQIRRESULTS_structure_plain_english_2005_08_12.xlsxls WQIRRESULTS_structure_plain_english_2005_08_12.xls manage 51.0 K 14 Aug 2005 - 17:34 GrantRobinson List of DIPNR fields and identifying three Oracle views -- 12Aug2005 -- superseded 29Aug2005
WQIRRESULTS_structure_plain_english_2005_08_22.xlsxls WQIRRESULTS_structure_plain_english_2005_08_22.xls manage 37.0 K 29 Aug 2005 - 08:32 GrantRobinson List of DIPNR fields and identifying three Oracle views -- updated during 22Aug2005 meeting -- superseded 14Jun2006
WQIRRESULTS_structure_plain_english_2006_06_14.xlsxls WQIRRESULTS_structure_plain_english_2006_06_14.xls manage 37.5 K 14 Jun 2006 - 13:37 GrantRobinson List of DNR fields and identifying three Oracle views -- updated 14Jun2006
WQIRRESULTS_structure_plain_english_2006_07_24.xlsxls WQIRRESULTS_structure_plain_english_2006_07_24.xls manage 37.5 K 23 Oct 2006 - 14:45 GrantRobinson This version is now superseded
WQIRRESULTS_structure_plain_english_2006_11_02.xlsxls WQIRRESULTS_structure_plain_english_2006_11_02.xls manage 43.0 K 02 Nov 2006 - 09:07 GrantRobinson List of DNR fields and identifying three Oracle views -- updated 2Nov2006
WebFeatureServer_Administration_Guide-v0.1.docdoc WebFeatureServer_Administration_Guide-v0.1.doc manage 154.5 K 11 Jul 2005 - 11:52 JonathanDoig DIPNR Geoserver Administration Guide v0.1
developing_views_2005_08_12.docdoc developing_views_2005_08_12.doc manage 25.0 K 14 Aug 2005 - 17:21 GrantRobinson Notes on developing views to DIPNR WQDP Internet Released data
main-2.2.x-complex_branch.jarjar main-2.2.x-complex_branch.jar manage 1645.9 K 20 Jan 2006 - 15:04 RobAtkinson SLD filter sequence fix - replace gt2-main.jar in geoserver release
Topic revision: r23 - 15 Oct 2010, UnknownUser
 

Current license: All material on this collaboration platform is licensed under a Creative Commons Attribution 3.0 Australia Licence (CC BY 3.0).