Point Observations - Move measurement to point data

[jomey]

Fresh off expanding the test suite for the GPR point importer, I see a need to remove the MeasurementType from the PointObservation and move that to the Points table.

To illustrate why, here a screenshot after importing a dataset that belongs to one GPR:

• PointObservations

• PointData

The original data looked like this:

I think we will make our lives a lot harder to answer a user question that would say: "Give me all the data that this GPR retrieved". Right now we would have to come up with some dicey logic to match on the first part of the name and date (or something), which feels very fragile.

One solution could be to simply move the measurement_type from the observation to the point, like we had initially some columns for. Then we could create two observation records per date (which this truly is) and easily fetch the associated points via relationship.

This seems a fairly easy change in the importer logic and makes searching a lot more straight forward.

Thoughts?

Related #192

[aaarendt]

Wouldn't all the data from that GPR be associated with a unique DOI, so one could select on that basis?

[jomey]

That would be one way and I don't know if there is a guarantee that a dataset has a unique DOI per instrument.

My other point with this is more general, that we should allow to have an point observation with multiple measurements per instrument, which the GPR for instance can derive. This would reduce our PointObservation table entries to one record, while still carrying the fine level at the point data level to distinguish between them.

[aaarendt]

Oh I see, so in your example above there would only need to be two rows instead of six in PointObservations (since there are observations on two different dates). Then we would also simplify the name to remove the measurement type that is embedded in the name?

[jomey]

Oh I see, so in your example above there would only need to be two rows instead of six in PointObservations (since there are observations on two different dates). Then we would also simplify the name to remove the measurement type that is embedded in the name?

That is correct

[aaarendt]

Let's do it!