BSBI Distribution Database > message board

Notes field query

Any queries about using the BSBI database

Notes field query

by AndyAmphlett » Fri May 03, 2019 9:03 am

Tom,

It is possible to run a query looking for text within the Comments Field (= Notes in the DDb), eg. https://database.bsbi.org/search.php#re ... 64e5319678. That query was looking for records from vc96 where the road number 'A9' was in the Notes field. But this also finds any word that contains 'A9' eg. Quadrat A97, or (roads) A96, A938 etc. I thought using a space after 'A9 ie %A9 % would work but that omits records where there is a character after the '9' eg a full stop. Is there a way to restrict the query to only find exactly matching text / whole words? Not urgent, but would be quite useful.

Thanks,

Andy.
AndyAmphlett
 
Posts: 335
Joined: Fri Nov 23, 2012 9:32 am
name: Andy Amphlett

Re: Notes field query

by admin » Fri May 03, 2019 9:59 am

Hi Andy,

Good question. A working, but bodged solution would be to search for various alternative punctuation characters after A9 (including absence, to match at the end of a string). e.g.

Screenshot 2019-05-03 09.33.00.png
Screenshot 2019-05-03 09.33.00.png (18.85 KiB) Viewed 246 times


https://database.bsbi.org/search.php#re ... e39cfc1cdb


It would be far better if proper matching using regular expressions was allow, rather than just simplistic wildcards. That wouldn't be difficult to add, but probably needs an explicit user-interface option to enable/disable - because many users wouldn't want to use a formal expressions for searching.
Tom Humphrey
Database Officer, Botanical Society of Britain and Ireland (BSBI)
c/o Centre for Ecology and Hydrology,Maclean Building, Crowmarsh Gifford, Wallingford, Oxon, OX10 8BB, UK.
tom.humphrey@bsbi.org
User avatar
admin
 
Posts: 390
Joined: Tue Nov 20, 2012 4:16 pm
name: Tom Humphrey

Re: Notes field query

by AndyAmphlett » Fri May 03, 2019 10:35 am

Tom,

Thanks. That is better. Still finds records with 'Quadrat A9.' and 'Quadrat NA9.' in the Notes field, but can investigate via a spreadsheet.

A better example that VCRs may find useful is to look for records where a var. name is included in the Notes field, eg. https://database.bsbi.org/search.php#re ... b0e66d39ea. This works pretty well, and detects a lot of examples where a var. name is not available in MapMate but is added to the Comments.

Andy.
AndyAmphlett
 
Posts: 335
Joined: Fri Nov 23, 2012 9:32 am
name: Andy Amphlett


Return to Help and support

cron