1

Re: Drop down list or free text for Measurement Data

I am looking into ways of managing our data more efficiently. One thing I am working on is a way to control what data is entered in the Obs Measurement Data field. I fgured this must be possible, in the same way as Provenance has four items to choose from but allows free text entry too.

What I want to be able to do is create some new Obs Measurement Types like Breeding Status, with qualifiers of Confirmed, Possible, Not Breeding etc, with Unit of None and Accuracy as None (or left blank, so becomes Unknown). This will then allow us to have Obs Measurement Abundances of e.g. 1 Female and the fact that it is also Confirmed Breeding.

The problem is a measurement must have data, so my answer is to have a drop down in the Data (like in Provenance, but that can be added to - unlike Provenance) which would prevent lots of spelling differences and correspond to the qualifier. Alternatively the Obs Measurement Type could be something else and the qualifier could be Breeding Status or Behaviour etc and the Data drop down the terms needed or free text.

I know this probably can not be done at this moment in time, but in case there is a way...?

In regards to the Provenance, where are the four standard terms listed and how could someone add to them, they are not in the Term Lists?

Brian

Brian Miller
(Conservation Officer (Buckinghamshire), BBOWT)

2

Re: Drop down list or free text for Measurement Data

Hi Brian

The idea of being able to attach a controlled list to a given measurement type has been discussed before but is not included in the current Recorder application. Its a good idea though and I think it would be a useful addition.

The Provenance list is not controlled by a term list, its simply 'hard coded' into the application. You can, however, type your own entries in to the box.

John van Breda
Biodiverse IT

3

Re: Drop down list or free text for Measurement Data

Hi Brian and John

I have added this idea to the list of suggested improvements.

Best wishes,

Sarah

Sarah Shaw
Biodiversity Information Assistant
JNCC

Sarah Shaw
Biodiversity Information Assistant
JNCC

4

Re: Drop down list or free text for Measurement Data

Hi John (and Sarah),

Thanks for your responses at this busy time checking v.6.9.3.

johnvanbreda wrote:

The idea of being able to attach a controlled list to a given measurement type has been discussed before but is not included in the current Recorder application. Its a good idea though and I think it would be a useful addition.

This has arisen from discussions I have been having with Ken Thompson regarding formalising and standardising how we both enter data (he enters data for one of our sites in Bucks) to ease data exchange. Through discussions with him about this area he has pointed out that there seems to be a mis-use of the Abundance Qualifier in that it contains lots of items that should be in other Measurement Types instead, such as status of Breeding. In furthering these discussions it was apparant that there was a need to have this drop down list for the Data (as well as free text) as some items do not need a qualifier, just the Data. (This would enable a tidy up of the Abundance qualifiers, moving them to their correct places under other Measurement Types and in Data). Examples:

Meas. Type              Qualifier                 Data                 Unit
Length                    [of] Wing                 5                      Inches     
Breeding                 None                      Confirmed         None
Abundance              [of] Female              5                     Count

The only way of working this at the moment will be to run update queries every so often to correct mis-spelt Data items.

Would this change be a difficult and expensive one or something we may see in future releases?

Cheers

Brian

Brian Miller
(Conservation Officer (Buckinghamshire), BBOWT)

5

Re: Drop down list or free text for Measurement Data

Just been having a look at the lengths of columns and raised an issue with the Measurement_Qualifier Short_Name elsewhere. But in relation to this discussion, the Data field in the Taxon_Occurrence_Data table is only 20 characters. If the new drop down term list is to be implemented sometime in the future this would need to be extended to 40 characters to be in line with the Short_Name length.

Cheers

Brian

Brian Miller
(Conservation Officer (Buckinghamshire), BBOWT)

6

Re: Drop down list or free text for Measurement Data

In response to Brian's initial posting:

Provenance is vital in establishing the context in which biological records are created and used; provenance may be defined as "A statement of any changes in the ownership and custody of theresource that are significant for its authenticity, integrity or interpretation." (Dublin Core).

ISO 15489 describes this as ‘the context in which the record was created, received and used should be apparent in the record, including the business process of which the transaction is part, the date and time of the transaction and the participants in the transaction."

The NBN data model describes Provenance as "Text field allowing the provenance of the taxon occurrence to be recorded.  For example, an occurrence may be recorded as Alien, Native or Vagrant.", in the Recorder Help file we are told we can "Select a value for the provenance for the species from the drop-down box." and "Free text, but with a list of frequently used values from which an entry may be picked. Used, for example, in BSBI plant recording schemes to note whether a specimen was planted or native".

These definitions conflict; rejection of the definition within the NBN data model seems most prudent since even a dictionary defines it as “source”.

7

Re: Drop down list or free text for Measurement Data

Dictionary.com lists several definitions for Provenance, one of which is "where something originated or was nurtured in its early existence" which I think quite closely matches Recorder's interpretation.

There are a number of standards that have evolved around projects such as BioCASE and GBIF in the last few years, since the original NBN modelling was done. I think its part of a much wider discussion whether Recorder should attempt to merge with any of these standards. What's more important, at least initially, is that the field provided is proving useful and is being used consistently.

John van Breda
Biodiverse IT

8

Re: Drop down list or free text for Measurement Data

I'm all in favour of creating a much more comprehensive list of terms for inclusion in Recorder by default. It would be a relatively cheap way of enhancing Recorder, making it both easier to get into for beginners (lots default examples are always useful in helping to prevent misuse). I've observed quite bad misuse of the measurements, with people trying to cram everything into the Abundance node. I've uploaded a screenshot showing some good and bad use of measurements. The key to my understanding how to use measurements well was in substituting the phrase "Measurement Qualifier" with the word "of". For example:

Presence of Active Burrows
Length of Hedgerow
Rate of Flow
Coverage of Taxon

You'll see what I mean if you look at the screenshot.

The DAFOR/DOMIN measurement is one I often see implemented in a variety of ways. What are others doing with this measurement? If you look at my screenshot, you'll see I've implemented it as Coverage of Taxon with a unit of DAFOR.

Charles

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

9

Re: Drop down list or free text for Measurement Data

Good Morning to all! :D

Anyhow, a couple of points from above;

Firstly, Charles, how did you add parent  headings in the measurement table? Specifically Coverage & Presence? Because that's the best solution to expanding on the somewhat limited options available in the default edition.

Secondly, whilst referring to DAFOR etc, I think your solution is probably the most elegant. What I've done is when doing NVC imports in particular is to simply state in the survey details "All measurements refer the DAFOR scale" where the abundance term used was Plants. That evolved as a workaround as I couldn't figure out how do to point 1...

The third thing to note here is that this discussion has been rumbling on for a few years, and even though this forum has been active since May, there are at least three other threads I know of (ie , I started a couple of them!) which ask similar questions:

http://forums.nbn.org.uk/viewtopic.php?id=77
http://forums.nbn.org.uk/viewtopic.php?id=49
http://forums.nbn.org.uk/viewtopic.php?id=80

Could we consolidate some of these points into a main heading eg "Measurement Abundances". I ask this especially in light of the frantic work of the past week trying to save as many relevant Smartgroup messages before it folded. I believe that a strong value of these discussion boards is as robust archive to delve through when either understanding "Why have they done it like this?" questions together for beginners looking for common solutions which are faced by the recording community.

I also agree that it would be good to get some consensus on what's actually used and then supply it with the program.
Perhaps a wee poll to ask how many of us have extensively customised these lists?
What are the most needed/added terms?


I could go on, but ye get the drift, cheers now, Rob.

10

Re: Drop down list or free text for Measurement Data

I found this thread when trying to work out the best way to record breeding statuses (e.g. 'Confirmed Breeding' and 'Probable Breeding') for bird atlas data. From Charles' post it seems that perhaps I need to establish the terms 'Confirmed Breeding' etc as measurement qualifiers under a measurement type of 'Status'. Is this the right way to go? I notice that this thread is from 2006. Has R6 moved on in any way that I should be aware of.

Charles, I'd love to see a picture like the one you posted that shows how you deal with bird breeding statuses.

Rich

Richard Burkmar
Biodiversity Project Officer
Field Studies Council

11

Re: Drop down list or free text for Measurement Data

Hi Richard

Below is a link to a post which describes how we dealt with this situation. As you will see it hasn't been entirely problem free, but I think it is working now and should give you some ideas

http://forums.nbn.org.uk/viewtopic.php?id=1454

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre