GitHub - earthcubearchitecture-project418/assay-data

Meta

Triple Count

SELECT (COUNT(*) AS ?triple_count) 
WHERE { 
  GRAPH ?graph { ?s ?p ?o } 
  FILTER (?graph != <http://www.w3.org/2002/07/owl#>)
  FILTER (?graph != <http://www.openlinksw.com/schemas/virtrdf#>)
  FILTER (?graph != <http://localhost:8890/sparql>)
  FILTER (?graph != <http://geolink>)
  FILTER (?graph != <http://www.w3.org/ns/ldp#>)
  FILTER (?graph != <http://localhost:8890/DAV/>)
}

Triple Count by Provider

SELECT DISTINCT ?graph COUNT(?s) as ?num_triples 
WHERE { 
  GRAPH ?graph { ?s ?p ?o } 
  FILTER (?graph != <http://www.w3.org/2002/07/owl#>)
  FILTER (?graph != <http://www.openlinksw.com/schemas/virtrdf#>)
  FILTER (?graph != <http://localhost:8890/sparql>)
  FILTER (?graph != <http://geolink>)
  FILTER (?graph != <http://www.w3.org/ns/ldp#>)
  FILTER (?graph != <http://localhost:8890/DAV/>)
} 
ORDER BY DESC(?num_triples)

Entity Count

SELECT (COUNT(*) AS ?entity_count) 
WHERE { 
  GRAPH ?graph { ?s a [] } 
  FILTER (?graph != <http://www.w3.org/2002/07/owl#>)
  FILTER (?graph != <http://www.openlinksw.com/schemas/virtrdf#>)
  FILTER (?graph != <http://localhost:8890/sparql>)
  FILTER (?graph != <http://geolink>)
  FILTER (?graph != <http://www.w3.org/ns/ldp#>)
  FILTER (?graph != <http://localhost:8890/DAV/>)
}

Entity Count by Provider

SELECT DISTINCT ?graph (COUNT(*) AS ?entity_count)
WHERE { 
  GRAPH ?graph { ?s a [] } 
  FILTER (?graph != <http://www.w3.org/2002/07/owl#>)
  FILTER (?graph != <http://www.openlinksw.com/schemas/virtrdf#>)
  FILTER (?graph != <http://localhost:8890/sparql>)
  FILTER (?graph != <http://geolink>)
  FILTER (?graph != <http://www.w3.org/ns/ldp#>)
  FILTER (?graph != <http://localhost:8890/DAV/>)
} ORDER BY DESC(?entity_count)

Distinct Resource URI Count

SELECT (COUNT(DISTINCT ?s ) AS ?resource_count)
WHERE { 
  GRAPH ?graph { { ?s ?p ?o  } UNION { ?o ?p ?s } FILTER(!isBlank(?s) && !isLiteral(?s)) } 
  FILTER (?graph != <http://www.w3.org/2002/07/owl#>)
  FILTER (?graph != <http://www.openlinksw.com/schemas/virtrdf#>)
  FILTER (?graph != <http://localhost:8890/sparql>)
  FILTER (?graph != <http://geolink>)
  FILTER (?graph != <http://www.w3.org/ns/ldp#>)
  FILTER (?graph != <http://localhost:8890/DAV/>)
} ORDER BY DESC(?resource_count)

Distinct Resource URI Count by Provider###

SELECT DISTINCT ?graph (COUNT(DISTINCT ?s ) AS ?resource_count)
WHERE { 
  GRAPH ?graph { { ?s ?p ?o  } UNION { ?o ?p ?s } FILTER(!isBlank(?s) && !isLiteral(?s)) } 
  FILTER (?graph != <http://www.w3.org/2002/07/owl#>)
  FILTER (?graph != <http://www.openlinksw.com/schemas/virtrdf#>)
  FILTER (?graph != <http://localhost:8890/sparql>)
  FILTER (?graph != <http://geolink>)
  FILTER (?graph != <http://www.w3.org/ns/ldp#>)
  FILTER (?graph != <http://localhost:8890/DAV/>)
} ORDER BY DESC(?resource_count)

Class Instance Count

SELECT ?class (COUNT(?s) AS ?count )
WHERE { 
  GRAPH ?graph { ?s a ?class } 
  FILTER (?graph != <http://www.w3.org/2002/07/owl#>)
  FILTER (?graph != <http://www.openlinksw.com/schemas/virtrdf#>)
  FILTER (?graph != <http://localhost:8890/sparql>)
  FILTER (?graph != <http://geolink>)
  FILTER (?graph != <http://www.w3.org/ns/ldp#>)
  FILTER (?graph != <http://localhost:8890/DAV/>)
} GROUP BY ?class ORDER BY DESC(?count)

Class Instance Count by Provider

Classes by Provider

SELECT DISTINCT ?graph ?class
WHERE {
  GRAPH ?graph {
    ?s a ?class
  }
  FILTER (?graph != <http://www.w3.org/2002/07/owl#>)
  FILTER (?graph != <http://www.openlinksw.com/schemas/virtrdf#>)
  FILTER (?graph != <http://localhost:8890/sparql>)
  FILTER (?graph != <http://geolink>)
}
ORDER BY ?graph ?class

w. COUNT

SELECT DISTINCT ?graph ?class COUNT(?class) as ?instances
WHERE {
  GRAPH ?graph {
    ?s a ?class
  }
  FILTER (?graph != <http://www.w3.org/2002/07/owl#>)
  FILTER (?graph != <http://www.openlinksw.com/schemas/virtrdf#>)
  FILTER (?graph != <http://localhost:8890/sparql>)
  FILTER (?graph != <http://geolink>)
}
ORDER BY ?graph ?class

Other Classes by Provider

PREFIX schema: <http://schema.org/>
SELECT DISTINCT ?graph ?class
WHERE {
  GRAPH ?graph {
    ?s schema:additionalType ?class
  }
  FILTER (?graph != <http://www.w3.org/2002/07/owl#>)
  FILTER (?graph != <http://www.openlinksw.com/schemas/virtrdf#>)
  FILTER (?graph != <http://localhost:8890/sparql>)
  FILTER (?graph != <http://geolink>)
}
ORDER BY ?graph ?class

w. COUNT

PREFIX schema: <http://schema.org/>
SELECT DISTINCT ?graph ?class COUNT(?class) AS ?instances
WHERE {
  GRAPH ?graph {
    ?s schema:additionalType ?class
  }
  FILTER (?graph != <http://www.w3.org/2002/07/owl#>)
  FILTER (?graph != <http://www.openlinksw.com/schemas/virtrdf#>)
  FILTER (?graph != <http://localhost:8890/sparql>)
  FILTER (?graph != <http://geolink>)
}
ORDER BY ?graph ?class

Properties by Provider

PREFIX schema: <http://schema.org/>
SELECT DISTINCT ?graph ?class ?property
WHERE {
  GRAPH ?graph {
    ?s a ?class .
    ?s ?property ?o
  }
  FILTER (?graph != <http://www.w3.org/2002/07/owl#>)
  FILTER (?graph != <http://www.openlinksw.com/schemas/virtrdf#>)
  FILTER (?graph != <http://localhost:8890/sparql>)
  FILTER (?graph != <http://geolink>)
  FILTER (?property != <http://www.w3.org/2000/01/rdf-schema#seeAlso>)
  FILTER (?property != <http://www.w3.org/1999/02/22-rdf-syntax-ns#type>)
  FILTER (REGEX(?property, "http://schema.org", "i"))
}
ORDER BY ?graph ?class ?property

Other Properties by Provider

PREFIX schema: <http://schema.org/>
SELECT DISTINCT ?graph ?class ?property
WHERE {
  GRAPH ?graph {
    ?s a ?class .
    ?s ?property ?o
  }
  FILTER (?graph != <http://www.w3.org/2002/07/owl#>)
  FILTER (?graph != <http://www.openlinksw.com/schemas/virtrdf#>)
  FILTER (?graph != <http://localhost:8890/sparql>)
  FILTER (?graph != <http://geolink>)
  FILTER (?property != <http://www.w3.org/2000/01/rdf-schema#seeAlso>)
  FILTER (?property != <http://www.w3.org/1999/02/22-rdf-syntax-ns#type>)
  FILTER (!REGEX(?property, "http://schema.org", "i"))
}
ORDER BY ?graph ?class ?property

Properties by Count

SELECT ?property (COUNT(*) AS ?used) 
WHERE {
  GRAPH ?graph {
    ?s ?property ?o .
    FILTER (?graph != <http://www.w3.org/2002/07/owl#>)
    FILTER (?graph != <http://www.openlinksw.com/schemas/virtrdf#>)
    FILTER (?graph != <http://localhost:8890/sparql>)
    FILTER (?graph != <http://geolink>)
  }
} GROUP BY ?property ORDER BY DESC(?used)

Vocabulary

Schema.org Identifier Count

PREFIX schema: <http://schema.org/>
SELECT DISTINCT ?graph ?class ?id_scheme COUNT(?identifier) as ?identifier_count
WHERE { 
  GRAPH ?graph { 
   ?s a ?class .
   ?s schema:identifier ?identifier .
   ?identifier schema:propertyID ?id_scheme .
  }
} 
GROUP BY ?graph ?class ?id_scheme
ORDER BY ?identifier_count

Identifiers found through schema:url

PREFIX schema: <http://schema.org/>
SELECT ?graph ?propertyID COUNT (?propertyID) as ?property_id_by_url_count
WHERE { 
  GRAPH ?graph { 
    ?s a schema:PropertyValue . 
    ?o schema:url ?s .
    OPTIONAL { ?s schema:propertyID ?propertyID . }
  } 
  FILTER (?graph != <http://www.w3.org/2002/07/owl#>)
  FILTER (?graph != <http://www.openlinksw.com/schemas/virtrdf#>)
  FILTER (?graph != <http://localhost:8890/sparql>)
  FILTER (?graph != <http://geolink>)
  FILTER (?graph != <http://www.w3.org/ns/ldp#>)
  FILTER (?graph != <http://localhost:8890/DAV/>)
} 
ORDER BY ?graph ?propertyID

ORCID Count by Provider

PREFIX schema: <http://schema.org/>
SELECT DISTINCT ?g COUNT(DISTINCT ?s) as ?orcids

WHERE { 
  GRAPH ?g {
   ?s ?p ?o
   FILTER REGEX(str(?s), "orcid.org", "i")
  }
}

PropertyValue by Predicate

PREFIX schema: <http://schema.org/>
SELECT DISTINCT ?p
#(COUNT(?class) AS ?class_count) 
WHERE { 
  GRAPH ?graph { 
    ?s a schema:PropertyValue . ?o ?p ?s . 
    OPTIONAL { ?o a ?class . }
    OPTIONAL { ?o schema:additionalType ?type }
  } 
  FILTER (?graph != <http://www.w3.org/2002/07/owl#>)
  FILTER (?graph != <http://www.openlinksw.com/schemas/virtrdf#>)
  FILTER (?graph != <http://localhost:8890/sparql>)
  FILTER (?graph != <http://geolink>)
  FILTER (?graph != <http://www.w3.org/ns/ldp#>)
  FILTER (?graph != <http://localhost:8890/DAV/>)
} 
ORDER BY ?graph ?class ?type ?p
#ORDER BY DESC(?class_count)

PropertyValue by Predicate Count

PREFIX schema: <http://schema.org/>
SELECT DISTINCT ?p (COUNT(?s) AS ?count) 
WHERE { 
  GRAPH ?graph { 
    ?s a schema:PropertyValue . ?o ?p ?s . 
    OPTIONAL { ?o a ?class . }
    OPTIONAL { ?o schema:additionalType ?type }
  } 
  FILTER (?graph != <http://www.w3.org/2002/07/owl#>)
  FILTER (?graph != <http://www.openlinksw.com/schemas/virtrdf#>)
  FILTER (?graph != <http://localhost:8890/sparql>)
  FILTER (?graph != <http://geolink>)
  FILTER (?graph != <http://www.w3.org/ns/ldp#>)
  FILTER (?graph != <http://localhost:8890/DAV/>)
} 
ORDER BY DESC(?count)

Organization

Logo

PREFIX schema: <http://schema.org/>
SELECT DISTINCT ?graph ?logo_url
WHERE {
  GRAPH ?graph {
    ?resource rdf:type schema:Organization .
    ?resource schema:logo [ schema:url ?logo_url ] .
  }
}
ORDER BY ?graph

Organization Potential Action Endpoints

PREFIX schema: <http://schema.org/>
SELECT DISTINCT ?g ?class IF(?url_template, ?url_template, ?target) as ?action_url ?p ?o
WHERE { 
  GRAPH ?g {
    ?s schema:potentialAction ?action .
    ?s a ?class . 
    OPTIONAL { 
      FILTER NOT EXISTS { ?action rdf:type ?o }
      FILTER NOT EXISTS { ?action rdfs:seeAlso ?o }
      OPTIONAL { 
        ?action schema:target ?target . 
        OPTIONAL { 
          ?target a schema:EntryPoint . 
          ?target schema:urlTemplate ?url_template .
          ?target ?p ?o
        }
      }
      OPTIONAL { 
        ?action schema:query-input ?query_input . 
      }
    }
  }
}
ORDER BY ?g ?class ?action_url ?query_input

Dataset

License

SELECT DISTINCT ?graph ?license ?class
WHERE { 
  GRAPH ?graph { 
    ?s <http://schema.org/license> ?license .
    OPTIONAL { ?s a ?class }
  }
}

License Count by Provider

SELECT DISTINCT ?graph COUNT(DISTINCT ?s) as ?number_of_licenses
WHERE { 
  GRAPH ?graph { 
    ?s <http://schema.org/license> ?license .
  }
} 
ORDER BY DESC(?number_of_licenses)

Authors

PREFIX schema: <http://schema.org/>
SELECT DISTINCT ?g ?role IF(BOUND(?role_type), ?role_type, ?person_type) as ?type
WHERE { 
  VALUES ?role { schema:creator schema:contributor schema:author }
  GRAPH ?g {
    ?s a schema:Dataset .
    ?s ?role ?author .
    ?author a ?person_type .
    OPTIONAL {
      ?author a schema:Role .
      ?author ?role [ rdf:type ?role_type ] .
    }
  }
}
ORDER BY ?g

Identifier Usage

PREFIX schema: <http://schema.org/>
SELECT DISTINCT ?graph ?class IF(isLiteral(?identifier), "literal", "resource") as ?id_type
WHERE { 
  GRAPH ?graph { 
   ?s a schema:Dataset .
   ?s schema:identifier ?identifier .
  }
}

Identifier Scheme

PREFIX schema: <http://schema.org/>
SELECT DISTINCT ?graph ?id_scheme
WHERE { 
  GRAPH ?graph { 
   ?s a schema:Dataset .
   ?s schema:identifier ?identifier .
   ?identifier schema:propertyID ?id_scheme .
  }
}

Funder

PREFIX schema: <http://schema.org/>
PREFIX gdx: <https://geodex.org/voc/>
SELECT DISTINCT ?g
WHERE { 
  GRAPH ?g {
    ?s a schema:Dataset .
    ?s schema:funder ?funder
  }
}
ORDER BY ?g

VariableMeasured Usage

PREFIX schema: <http://schema.org/>
SELECT DISTINCT ?g
WHERE { 
  GRAPH ?g {
   ?s a schema:Dataset .
   ?s schema:variableMeasured ?var .
  }
} 
ORDER BY ?g

Distribution Usage

PREFIX schema: <http://schema.org/>
SELECT DISTINCT ?g
WHERE { 
  GRAPH ?g {
   ?s a schema:Dataset .
   ?s schema:distribution ?distro .
  }
} 
ORDER BY ?g

Distribution Properties by Provider

PREFIX schema: <http://schema.org/>
SELECT DISTINCT ?g ?p
WHERE { 
  GRAPH ?g {
   ?s a schema:Dataset .
   ?s schema:distribution ?distro .
   OPTIONAL { 
     ?distro ?p ?o 
     FILTER NOT EXISTS { ?distro rdfs:seeAlso ?o }
   }
  }
} 
ORDER BY ?g ?p

Distribution properties by popularity

PREFIX schema: <http://schema.org/>
SELECT DISTINCT ?p COUNT(DISTINCT ?g) as ?num_providers
WHERE { 
  GRAPH ?g {
   ?s a schema:Dataset .
   ?s schema:distribution ?distro .
   OPTIONAL { 
     ?distro ?p ?o 
     FILTER NOT EXISTS { ?distro rdfs:seeAlso ?o }
   }
  }
} 
GROUP BY ?p
ORDER BY DESC(?num_providers)

Spatial Coverage

PREFIX schema: <http://schema.org/>
SELECT DISTINCT ?g COUNT(?spatial_coverage) as ?num_coverages
WHERE { 
  GRAPH ?g {
    ?s a schema:Dataset .
    ?s schema:spatialCoverage ?spatial_coverage .
  }
}
ORDER BY ?g

Temporal Coverage

PREFIX schema: <http://schema.org/>
SELECT DISTINCT ?g COUNT(?temporal_coverage) as ?num_coverages
WHERE { 
  GRAPH ?g {
    ?s a schema:Dataset .
    ?s schema:temporalCoverage ?temporal_coverage .
  }
}
ORDER BY ?g

Back to Top

Name		Name	Last commit message	Last commit date
Latest commit History 52 Commits
images		images
README.md		README.md
dataset-authors-count.csv		dataset-authors-count.csv
dataset-authors-usage.csv		dataset-authors-usage.csv
dataset-distribution-count-by-provider.csv		dataset-distribution-count-by-provider.csv
dataset-distribution-properties-by-provider.csv		dataset-distribution-properties-by-provider.csv
dataset-distribution-usage.csv		dataset-distribution-usage.csv
dataset-extent-cvg-by-provider.csv		dataset-extent-cvg-by-provider.csv
dataset-funder-usage.csv		dataset-funder-usage.csv
dataset-spatial_cvg-usage.csv		dataset-spatial_cvg-usage.csv
dataset-temporal_cvg-usage.csv		dataset-temporal_cvg-usage.csv
dataset-variable-count-by-provider.csv		dataset-variable-count-by-provider.csv
dataset-variable-propertyvalue-count-by-provider.csv		dataset-variable-propertyvalue-count-by-provider.csv
dataset-variableMeasured-usage.csv		dataset-variableMeasured-usage.csv
dataset_identifier-schemes.csv		dataset_identifier-schemes.csv
dataset_identifier-usage.csv		dataset_identifier-usage.csv
dataset_license-count-by-provider.csv		dataset_license-count-by-provider.csv
dataset_license.csv		dataset_license.csv
meta-class-count.csv		meta-class-count.csv
meta_classes-by-provider.csv		meta_classes-by-provider.csv
meta_classes-instance-count-by-provider.csv		meta_classes-instance-count-by-provider.csv
meta_classes-instance-count.csv		meta_classes-instance-count.csv
meta_count-triples-by-provider.csv		meta_count-triples-by-provider.csv
meta_entity-count-by-provider.csv		meta_entity-count-by-provider.csv
meta_entity-count.csv		meta_entity-count.csv
meta_other-classes-by-provider.csv		meta_other-classes-by-provider.csv
meta_other-classes-instance-count-by-provider.csv		meta_other-classes-instance-count-by-provider.csv
meta_other-properties-by-provider.csv		meta_other-properties-by-provider.csv
meta_other-vocabs.csv		meta_other-vocabs.csv
meta_properties-by-count.csv		meta_properties-by-count.csv
meta_properties-by-provider.csv		meta_properties-by-provider.csv
meta_resource-count-by-provider.csv		meta_resource-count-by-provider.csv
meta_resource-count.csv		meta_resource-count.csv
org_logo.csv		org_logo.csv
org_potential-actions.csv		org_potential-actions.csv
vocab-identifier-found-through-schema_url.csv		vocab-identifier-found-through-schema_url.csv
vocab-identifier-type-count.csv		vocab-identifier-type-count.csv
vocab-propertyvalue-by-predicate-count.csv		vocab-propertyvalue-by-predicate-count.csv
vocab-propertyvalue-by-predicate.csv		vocab-propertyvalue-by-predicate.csv
vocab_orcid-count-by-provider.csv		vocab_orcid-count-by-provider.csv
vocabulary_identifier-count.csv		vocabulary_identifier-count.csv

earthcubearchitecture-project418/assay-data

Folders and files

Latest commit

History

Repository files navigation

Table of Contents

Meta

Triple Count

Triple Count by Provider

Entity Count

Entity Count by Provider

Distinct Resource URI Count

Distinct Resource URI Count by Provider###

Class Instance Count

Class Instance Count by Provider

Classes by Provider

Other Classes by Provider

Properties by Provider

Other Properties by Provider

Properties by Count

Vocabulary

Schema.org Identifier Count

Identifiers found through schema:url

ORCID Count by Provider

PropertyValue by Predicate

PropertyValue by Predicate Count

Organization

Logo

Organization Potential Action Endpoints

Dataset

License

License Count by Provider

Authors

Identifier Usage

Identifier Scheme

Funder

VariableMeasured Usage

Distribution Usage

Distribution Properties by Provider

Distribution properties by popularity

Spatial Coverage

Temporal Coverage

About

Resources

Stars

Watchers

Forks

Releases

Packages 0

Packages