Opened 14 years ago

Closed 14 years ago

#72 closed defect (fixed)

bmap_repo has incorrect FMA Terms

Reported by: joshuadf Owned by: joshuadf
Priority: minor Milestone:
Component: systems Version:
Keywords: Cc:


The FMA terms in the bmap_repo do not have the first letter capitalized, which causes distributed XQueries to fail (or requires some crazy query). The FMA terms can be listed by running this with mysql bmap_repo on sphenoid:

SELECT fullname FROM Term WHERE authority = 'FMA';

Change History (1)

comment:1 Changed 14 years ago by joshuadf

Resolution: fixed
Status: newclosed

Todd gave me this info:

The convention in the FMA is that the first word is capitalized as well as proper names and certain abbreviations (i.e. rDNA). Hopefully there aren't any eponyms or abbreviations in bmap_repo.

I ran the list of terms from bmap_repo through the following perl code:

if (/^[a-z].*/) {
        $orig = $_;
#opercular part of inferior frontal gyrus
#Opercular part of inferior frontal gyrus
        $outstmt = "UPDATE Term set fullname = \'";
        $outstmt .= $_;
        $outstmt .= "\' WHERE authority = 'FMA' AND fullname = \'";
        $outstmt .= $orig;
        $outstmt .= "\';\n";
        print $outstmt;
# UPDATE Term set fullname = 'Opercular part of inferior frontal gyrus' 
# WHERE authority = 'FMA' 
# AND fullname = 'opercular part of inferior frontal gyrus';

Distributed queries should work as soon as the updates trickle into the SaxonWebService XML.

Note: See TracTickets for help on using tickets.