ufvivotech / ufDataQualityImprovement

Project to improve UF vivo data quality and accuracy
2 stars 1 forks source link

Remove multiple labels from UF Orgs #236

Closed mconlon17 closed 10 years ago

mconlon17 commented 10 years ago

Please remove multiple labels from UF Orgs. Each UF Org should have one label.

The query below finds UF orgs with more than one label. Could be added to dchecker.

SELECT ?uri ?countlabel ?samplelabel WHERE { { SELECT ?uri (COUNT (?xlabel) AS ?countlabel) (SAMPLE(?xlabel) AS ?samplelabel) WHERE { ?uri a ufVivo:UFEntity . ?uri a foaf:Organization . ?uri rdfs:label ?xlabel . } GROUP BY ?uri } FILTER (?countlabel >1) }

The list below is the list of UF Orgs that have more than one label. The second field is the number of labels:

"http://vivo.ufl.edu/individual/n80254","2","School of Forest Resources and Conservation" "http://vivo.ufl.edu/individual/n205954","2","College of Medicine - Jacksonville" "http://vivo.ufl.edu/individual/n1191375285","2","Biostatistics" "http://vivo.ufl.edu/individual/n466116","2","General Internal Medicine" "http://vivo.ufl.edu/individual/n366314","2","Florida Museum of Natural History" "http://vivo.ufl.edu/individual/n238208","2","Emergency Medicine" "http://vivo.ufl.edu/individual/n56522","2","Geography" "http://vivo.ufl.edu/individual/n1842464339","2","Engineering School of Sustainable Infrastructure and Environment" "http://vivo.ufl.edu/individual/n243212","2","Whitney Laboratory for Marine Bioscience" "http://vivo.ufl.edu/individual/n486361","2","Radiation Oncology - Jacksonville" "http://vivo.ufl.edu/individual/n8858876","2","Food and Resource Economics" "http://vivo.ufl.edu/individual/n105150","2","Institute on Aging" "http://vivo.ufl.edu/individual/n272441","2","Infectious Diseases and Pathology" "http://vivo.ufl.edu/individual/n466137","2","Statistics (IFAS)" "http://vivo.ufl.edu/individual/n38172","2","Office of Research and Graduate Studies" "http://vivo.ufl.edu/individual/n466132","2","Orthodontics" "http://vivo.ufl.edu/individual/n466134","2","Endodontics" "http://vivo.ufl.edu/individual/n243217","2","College of Health and Human Performance" "http://vivo.ufl.edu/individual/n352347","2","Program in Stem Cell Biology and Regenerative Medicine" "http://vivo.ufl.edu/individual/n131576","2","Pharmaceutics" "http://vivo.ufl.edu/individual/n317949","2","Surgery - Jacksonville" "http://vivo.ufl.edu/individual/n8858824","2","Applied Physiology and Kinesiology" "http://vivo.ufl.edu/individual/n8858822","2","Plant Molecular and Cellular Biology" "http://vivo.ufl.edu/individual/n987233","2","Warrington College of Business Administration" "http://vivo.ufl.edu/individual/n52761","2","J. Crayton Pruitt Family Department of Biomedical Engineering" "http://vivo.ufl.edu/individual/n4777238","2","Institute of Food and Agricultural Sciences" "http://vivo.ufl.edu/individual/n232486","2","Orthopaedic Surgery and Rehabilitation - Jacksonville" "http://vivo.ufl.edu/individual/n134875178","2","Operative Dentistry" "http://vivo.ufl.edu/individual/n8858865","2","Health Science Center Library" "http://vivo.ufl.edu/individual/n8858867","2","Lastinger Center for Learning" "http://vivo.ufl.edu/individual/n1107886012","2","Mathematics" "http://vivo.ufl.edu/individual/n169914","2","Radiation Oncology" "http://vivo.ufl.edu/individual/n8858900","2","Oral and Maxillofacial Surgery" "http://vivo.ufl.edu/individual/n2141234302","2","Medicine" "http://vivo.ufl.edu/individual/n466125","2","Prosthodontics" "http://vivo.ufl.edu/individual/n120358","3","Center for Translational Research in Neurodegenerative Diseases" "http://vivo.ufl.edu/individual/n153305","2","Evelyn F. and William L. McKnight Brain Institute" "http://vivo.ufl.edu/individual/n159204","2","Medicinal Chemistry" "http://vivo.ufl.edu/individual/n126367","2","Shands Healthcare, Inc" "http://vivo.ufl.edu/individual/n1278110","2","Horticultural Sciences" "http://vivo.ufl.edu/individual/n1278130","2","University of Florida" "http://vivo.ufl.edu/individual/n272436","2","Center for Pediatric Psychology and Family Studies" "http://vivo.ufl.edu/individual/n160649","2","Water Resources Research Center" "http://vivo.ufl.edu/individual/n49110","2","School of Physician Assistant Studies"

nrejac commented 10 years ago

Adding query to dchecker.

avani2318 commented 10 years ago

Removed duplicate labels.