Play with the FROST Geotech plugin

This page is about relevant queries you may do with the FROST Geotech plugin

Simple queries

Get a list of all the geotechTests in this STA (supposing the STA only contains Geotech tests) : 

https://[FrostGeotechServerAddress]/v1.1/Sensors

Get a list of all the geotechTests that are of type CPT

https://[FrostGeotechServerAddress]/v1.1/Sensors?$filter=sensortype eq ‘https://data.geoscience.fr/ncl/Proc/86’

Get the description of one test by ID: 

https://[FrostGeotechServerAddress]/v1.1/Sensors(xxx)

More complex queries

Get the list of the available DataStreams associated to my Geotechtest

https://[FrostGeotechServerAddress]/v1.1/Sensors(xxx)/Datastreams

Get the description of one DataStream associated to my Geotechtest

https://[FrostGeotechServerAddress]/v1.1/Datastreams(yyy)

Get the observations from this DataStream

https://[FrostGeotechServerAddress]/v1.1/Datastreams(yyy)/Observations

More more complex queries

Get the results of the available DataStreams associated to my Geotechtest organised this way : [Depth, Result for property 1, Result for property 2, ...]

https://ogc-demo.k8s.ilt-dmz.iosb.fraunhofer.de/FROST-GeoTech/v1.1/BhTrajectoryThings(9)?
  $select=name&
  $expand=BhSamplings(
    $orderBy=atPosition;
    $select=atPosition,time;
    $expand=BhSamples(
      $top=1;
      $select=name;
      $expand=Observations(
        $top=3;
        $select=result,phenomenonTime;
        $expand=Datastream(
          $select=unitOfMeasurement;
          $expand=ObservedProperty(
            $select=name
          )
        )
      )
    )
  )

Get this same result in csv

Hylke's Magic Request 2

Get the CPT tests in this perimeter that match this lithology

Hylke's Magic Request 3

Get the results of those same CPT tests

Hylke's Magic Request 4