Hello,

this time I do not come up with a problem but with a request for ideas/opinions etc.

The scenario:

static geographic locations, where samples are taken on a regular and irregular basis are hold in different database environments such as Oracle Spatial and Smallworld Data Stores.

 

The measuring values are hold in an Oracle non-geographic environment. There is an ID that connects both "worlds" (yeeepie!). Probably there will also be non-static sample places (ad hoc samples) in the future whose positions are not yet stored anywhere. Here, the question how the data will be georeferenced, has to be answered first. For this scenario I exclude these sample positions.

The idea now is to join both worlds (geographic and non-geographic data) and visualize it in a map environment.

 

Visualize in this context means:

- overlay the sample positions with any WMS (own and third party)

 

- delimit the sample positions by location and / or attribute(s)

 

- select which type of, e.g. biological parameter, is to be displayed

 

- delimit the measurement values which are connented to the sample positions by time period (from date- to date, e.g. slide bar) and calculating various statistical values (displayed as diagrams)

 

- automatically highlight positions where certain measurements exceed a threshold

 

- whenever there is a change in a measurement value it should be available in the visualization environment (live or, say, every hour)

I am aware of the need for any FME-Smallworld connector. There will definately be the need for an authentification process. We are currently using FME Desktop Professional 2017.

Any ideas/suggestions/opinions/similar project descriptions etc. are highly appreciated.