Skip to content

Knowledge Graph with CSR Data

Jump to bottom
Michael DeBellis edited this page Dec 14, 2023 · 3 revisions

Keeping page to preserve history, but deleted the file to free up some space on MD's Google drive which is getting full. Here is a link to the latest knowledge graph with CSR data loaded: NGO CFBLL CSR 8-4-23 C: Contacts File F: Finance File B: Background File L: Locations File CSR: CSR File

Also made the following changes to the graph so the CSR data could be loaded. Note: the renames have been done to V3 of the ontology but not for the existing graph. Renaming can sometimes result in bad triples and changing the names of some of the super properties (to reflect that they apply to CSRs as well as NGOs) is something we definitely want to do for future graphs but for the existing one, not such a big deal so it's not included in the SPARQL code that updated the current graph:

Add new data property: companyName

Rename ngoContactProperty to orgContactProperty (Note: for SPARQL use ngoContactProperty as super property)

Rename ngoFinanceProperty to orgFinanceProperty (Note: for SPARQL use ngoFinanceProperty as super property)

Add new data property dateOfIncorporation sub property of orgContactProperty Range is string not xsd:dateTime

Add new data property class sub property of orgContactProperty Values: Private or Public

Add new data property roc sub property of orgContactProperty

Add new data property category sub property of orgContactProperty

Add new data property subCategory sub property of orgContactProperty

Add new data property listingStatus sub property of orgContactProperty

Add new data property paidUpCapital sub property of orgFinanceProperty

Add new data property authorizedCapital sub property of orgFinanceProperty

Add new data property turnOverFY2014-15 sub property of orgFinanceProperty

Add new data property netWorthFY2014-15 sub property of orgFinanceProperty

Add new data property netProfitFY2014-15 sub property of orgFinanceProperty

Add new data property turnOverFY2015-16 sub property of orgFinanceProperty

Add new data property netWorthFY2015-16 sub property of orgFinanceProperty

Add new data property netProfitFY2015-16 sub property of orgFinanceProperty

Add new data property turnOverFY2016-17 sub property of orgFinanceProperty

Add new data property netWorthFY2016-17 sub property of orgFinanceProperty

Add new data property netProfitFY2016-17 sub property of orgFinanceProperty

#Here is the SPARQL code to update the existing graph:

PREFIX ngo: <http://www.semanticweb.org/mdebe/ontologies/NGO#>

PREFIX sdg: <http://www.semanticweb.org/mdebe/ontologies/2022/10/UNSDG#>

PREFIX dc: <http://purl.org/dc/elements/1.1/>

INSERT DATA {ngo:companyName rdf:type owl:DatatypeProperty ;

         `rdfs:subPropertyOf ngo:ngoContactProperty.`

     `ngo:dateOfIncorporation rdf:type owl:DatatypeProperty ;`

         `rdfs:subPropertyOf ngo:ngoContactProperty.`

     `ngo:class rdf:type owl:DatatypeProperty ;`

         `rdfs:subPropertyOf ngo:ngoContactProperty.`

     `ngo:roc rdf:type owl:DatatypeProperty ;`

         `rdfs:subPropertyOf ngo:ngoContactProperty.`

     `ngo:category rdf:type owl:DatatypeProperty ;`

         `rdfs:subPropertyOf ngo:ngoContactProperty.`

     `ngo:subCategory rdf:type owl:DatatypeProperty ;`

         `rdfs:subPropertyOf ngo:ngoContactProperty.
		  `
     `ngo:listingStatus rdf:type owl:DatatypeProperty ;`

         `rdfs:subPropertyOf ngo:ngoContactProperty.`

     `ngo:paidUpCapital rdf:type owl:DatatypeProperty ;`
         `rdfs:subPropertyOf ngo:ngoFinanceProperty.`
     `ngo:authorizedCapital rdf:type owl:DatatypeProperty ;`
         `rdfs:subPropertyOf ngo:ngoFinanceProperty.	`
		 
     `ngo:turnOverFY2014-15 rdf:type owl:DatatypeProperty ;`
         `rdfs:subPropertyOf ngo:ngoFinanceProperty.`
     `ngo:netWorthFY2014-15 rdf:type owl:DatatypeProperty ;`
         `rdfs:subPropertyOf ngo:ngoFinanceProperty.`
     `ngo:netProfitFY2014-15 rdf:type owl:DatatypeProperty ;`
         `rdfs:subPropertyOf ngo:ngoFinanceProperty.	`
		 
     `ngo:turnOverFY2015-16 rdf:type owl:DatatypeProperty ;`
         `rdfs:subPropertyOf ngo:ngoFinanceProperty.`
     `ngo:netWorthFY2015-16 rdf:type owl:DatatypeProperty ;`
         `rdfs:subPropertyOf ngo:ngoFinanceProperty. `
     `ngo:netProfitFY2015-16 rdf:type owl:DatatypeProperty ;`
         `rdfs:subPropertyOf ngo:ngoFinanceProperty.	 `
     `ngo:turnOverFY2016-17 rdf:type owl:DatatypeProperty ;`
     `rdfs:subPropertyOf ngo:ngoFinanceProperty.`
     `ngo:netWorthFY2016-17 rdf:type owl:DatatypeProperty ;`
         `rdfs:subPropertyOf ngo:ngoFinanceProperty. `
     `ngo:netProfitFY2016-17 rdf:type owl:DatatypeProperty ;`
         `rdfs:subPropertyOf ngo:ngoFinanceProperty.}`
Clone this wiki locally