search

Swirrl / ons-data-export

Temporary repo to keep track of the extraction of data between the PMD3 backed alpha for the COGS project, and the PMD4 staging server.
0 stars 0 forks source link

ONS Trade Areas Cord Code List - too many sort priorities #59

Closed jennet closed 4 years ago

jennet commented 4 years ago

There's still problems coming through on the source data with multiple sort priorities as flagged in #47

Opening this issue for a specific code list - http://gss-data.org.uk/def/concept-scheme/ons-trade-areas-cord "ONS Trade Areas CORD"

You can see the issues when running this query:

PREFIX rdf:     <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs:    <http://www.w3.org/2000/01/rdf-schema#>
PREFIX skos:    <http://www.w3.org/2004/02/skos/core#>
PREFIX ui:      <http://www.w3.org/ns/ui#>

SELECT ?concept  (COUNT(?sp) AS ?num_sort_priorities)
{
    BIND(<http://gss-data.org.uk/graph/ons-trade-areas-cord> AS ?graph)  
   GRAPH ?graph {
        ?concept a skos:Concept ;
             ui:sortPriority ?sp .
   }
}

GROUP BY ?concept 
# HAVING (?count > 1)
jennet commented 4 years ago

Covered by cogs-issues https://github.com/Swirrl/cogs-issues/issues/13