diff --git a/family-scope/dataset-structure-geo.sparql b/family-scope/dataset-structure-geo.sparql index d293cd1..742f646 100644 --- a/family-scope/dataset-structure-geo.sparql +++ b/family-scope/dataset-structure-geo.sparql @@ -3,7 +3,7 @@ PREFIX skos: PREFIX pmdqb: -SELECT ?dataset ?dataset_uri ?component_spec_uri ?dimension_uri ?dimension ?codelist ?codelist_uri +SELECT ?dataset ?dataset_uri ?component_spec_uri ?dimension_uri ?dimension ?codelist ?codelist_view_uri WHERE { ?dataset_uri a qb:DataSet; @@ -20,6 +20,7 @@ ?codelist_uri rdfs:label ?codelist . FILTER (?dimension_uri in (, , , , , , , )) + BIND (CONCAT('http://gss-data.org.uk/concept-scheme?uri=', ENCODE_FOR_URI(STR(?codelist_uri))) AS ?codelist_view_uri) } -GROUP BY ?dataset ?dataset_uri ?component_spec_uri ?dimension ?dimension_uri ?codelist ?codelist_uri -ORDER BY ?dataset_uri ?component_spec_uri ?dimension_uri ?codelist_uri +GROUP BY ?dataset ?dataset_uri ?component_spec_uri ?dimension ?dimension_uri ?codelist ?codelist_view_uri +ORDER BY ?dataset_uri ?component_spec_uri ?dimension_uri ?codelist_view_uri diff --git a/family-scope/geo-scope.ipynb b/family-scope/geo-scope.ipynb index f28a713..ba402f7 100644 --- a/family-scope/geo-scope.ipynb +++ b/family-scope/geo-scope.ipynb @@ -64,7 +64,7 @@ "\n", "labeller = {**uri_to_label('dataset_uri','dataset'),\n", " **uri_to_label('dimension_uri','dimension'),\n", - " **uri_to_label('codelist_uri','codelist')}\n", + " **uri_to_label('codelist_view_uri','codelist')}\n", "\n", "def presenter(uri):\n", " return(f'{labeller[uri]} ')\n", @@ -93,8 +93,8 @@ "metadata": {}, "outputs": [], "source": [ - "codelists = results[['dataset_uri','dimension_uri','codelist_uri']].applymap(lambda x: presenter(x.value))\n", - "codelists_pivot = codelists.pivot_table(index='dataset_uri',columns='dimension_uri',values='codelist_uri',aggfunc=lister)" + "codelists = results[['dataset_uri','dimension_uri','codelist_view_uri']].applymap(lambda x: presenter(x.value))\n", + "codelists_pivot = codelists.pivot_table(index='dataset_uri',columns='dimension_uri',values='codelist_view_uri',aggfunc=lister)" ] }, { @@ -145,14 +145,14 @@ " \n", " \n", " \n", - " <a href=\"http://gss-data.org.uk/def/concept-scheme/nationality\">Nationality</a>\n", + " <a href=\"http://gss-data.org.uk/concept-scheme?uri=http://gss-data.org.uk/def/concept-scheme/nationality\">Nationality</a>\n", " \n", " \n", " \n", " \n", " <a href=\"http://gss-data.org.uk/data/gss_data/migration/ho-entry-visas\">Immigration statistics, October to December 2017: data tables second edition</a>\n", " \n", - " <a href=\"http://gss-data.org.uk/def/concept-scheme/ho-citizenship\">HO Citizenship</a>\n", + " <a href=\"http://gss-data.org.uk/concept-scheme?uri=http://gss-data.org.uk/def/concept-scheme/ho-citizenship\">HO Citizenship</a>\n", " \n", " \n", " \n", @@ -163,7 +163,7 @@ " \n", " <a href=\"http://gss-data.org.uk/data/gss_data/migration/ons-ltim-citizenship\">Long-term international migration 2.01a, citizenship, UK and England and Wales</a>\n", " \n", - " <a href=\"http://gss-data.org.uk/def/concept-scheme/ltim-citizenship\">LTIM Citizenship</a>\n", + " <a href=\"http://gss-data.org.uk/concept-scheme?uri=http://gss-data.org.uk/def/concept-scheme/ltim-citizenship\">LTIM Citizenship</a>\n", " \n", " \n", " \n", @@ -175,7 +175,7 @@ " <a href=\"http://gss-data.org.uk/data/gss_data/migration/ons-ltim-country-of-residence\">Long-term international migration 2.02, country of last or next residence, UK and England and Wales</a>\n", " \n", " \n", - " <a href=\"http://gss-data.org.uk/def/concept-scheme/country-of-residence\">Country of Residence</a>\n", + " <a href=\"http://gss-data.org.uk/concept-scheme?uri=http://gss-data.org.uk/def/concept-scheme/country-of-residence\">Country of Residence</a>\n", " \n", " \n", " \n", @@ -185,8 +185,8 @@ " \n", " <a href=\"http://gss-data.org.uk/data/gss_data/migration/ons-ltim-passenger-survey-4-01\">International Passenger Survey 4.01, citizenship group by sex by age by country of last or next residence</a>\n", " \n", - " <a href=\"http://gss-data.org.uk/def/concept-scheme/ips-citizenship\">IPS Citizenship</a>\n", - " <a href=\"http://gss-data.org.uk/def/concept-scheme/country-of-residence\">Country of Residence</a>\n", + " <a href=\"http://gss-data.org.uk/concept-scheme?uri=http://gss-data.org.uk/def/concept-scheme/ips-citizenship\">IPS Citizenship</a>\n", + " <a href=\"http://gss-data.org.uk/concept-scheme?uri=http://gss-data.org.uk/def/concept-scheme/country-of-residence\">Country of Residence</a>\n", " \n", " \n", " \n", @@ -196,7 +196,7 @@ " \n", " <a href=\"http://gss-data.org.uk/data/gss_data/migration/ons-ltim-passenger-survey-4-02\">International Passenger Survey 4.02, main reason for migration by citizenship</a>\n", " \n", - " <a href=\"http://gss-data.org.uk/def/concept-scheme/ips-citizenship\">IPS Citizenship</a>\n", + " <a href=\"http://gss-data.org.uk/concept-scheme?uri=http://gss-data.org.uk/def/concept-scheme/ips-citizenship\">IPS Citizenship</a>\n", " \n", " \n", " \n", @@ -207,7 +207,7 @@ " \n", " <a href=\"http://gss-data.org.uk/data/gss_data/migration/ons-ltim-passenger-survey-4-04\">International Passenger Survey 4.04, area of destination or origin within the UK by citizenship</a>\n", " \n", - " <a href=\"http://gss-data.org.uk/def/concept-scheme/ips-citizenship\">IPS Citizenship</a>\n", + " <a href=\"http://gss-data.org.uk/concept-scheme?uri=http://gss-data.org.uk/def/concept-scheme/ips-citizenship\">IPS Citizenship</a>\n", " \n", " \n", " \n", @@ -223,15 +223,15 @@ " \n", " \n", " \n", - " <a href=\"http://gss-data.org.uk/def/concept-scheme/foreign-geography\">Foreign geography</a>\n", + " <a href=\"http://gss-data.org.uk/concept-scheme?uri=http://gss-data.org.uk/def/concept-scheme/foreign-geography\">Foreign geography</a>\n", " \n", " \n", " \n", " <a href=\"http://gss-data.org.uk/data/gss_data/trade/hmrc_rts\">UK Regional Trade Statistics (RTS</a>\n", - " <a href=\"http://gss-data.org.uk/def/concept-scheme/hmrc-geographies\">HMRC Geographies</a>\n", + " <a href=\"http://gss-data.org.uk/concept-scheme?uri=http://gss-data.org.uk/def/concept-scheme/hmrc-geographies\">HMRC Geographies</a>\n", " \n", " \n", - " <a href=\"http://gss-data.org.uk/def/concept-scheme/hmrc-regions\">HMRC Regions</a>\n", + " <a href=\"http://gss-data.org.uk/concept-scheme?uri=http://gss-data.org.uk/def/concept-scheme/hmrc-regions\">HMRC Regions</a>\n", " \n", " \n", " \n", @@ -243,14 +243,14 @@ " \n", " \n", " \n", - " <a href=\"http://gss-data.org.uk/def/concept-scheme/ons-fdi-area\">ONS FDI Area</a>\n", + " <a href=\"http://gss-data.org.uk/concept-scheme?uri=http://gss-data.org.uk/def/concept-scheme/ons-fdi-area\">ONS FDI Area</a>\n", " \n", " \n", " \n", " \n", " \n", " <a href=\"http://gss-data.org.uk/data/gss_data/trade/ons-international-trade-in-services\">International trade in services</a>\n", - " <a href=\"http://gss-data.org.uk/def/concept-scheme/ons-trade-areas-itis\">ONS Trade Areas ITIS</a>\n", + " <a href=\"http://gss-data.org.uk/concept-scheme?uri=http://gss-data.org.uk/def/concept-scheme/ons-trade-areas-itis\">ONS Trade Areas ITIS</a>\n", " \n", " \n", " \n", @@ -261,7 +261,7 @@ " \n", " \n", " <a href=\"http://gss-data.org.uk/data/gss_data/trade/ons-trade-in-goods\">Trade in goods: country-by-commodity imports and exports</a>\n", - " <a href=\"http://gss-data.org.uk/def/concept-scheme/ons-trade-areas-cord\">ONS Trade Areas CORD</a>\n", + " <a href=\"http://gss-data.org.uk/concept-scheme?uri=http://gss-data.org.uk/def/concept-scheme/ons-trade-areas-cord\">ONS Trade Areas CORD</a>\n", " \n", " \n", " \n", @@ -272,7 +272,7 @@ " \n", " \n", " <a href=\"http://gss-data.org.uk/data/gss_data/trade/ons-uk-trade-in-services\">UK trade in services: service type by partner country, non-seasonally adjusted</a>\n", - " <a href=\"http://gss-data.org.uk/def/concept-scheme/ons-trade-areas-cord\">ONS Trade Areas CORD</a>\n", + " <a href=\"http://gss-data.org.uk/concept-scheme?uri=http://gss-data.org.uk/def/concept-scheme/ons-trade-areas-cord\">ONS Trade Areas CORD</a>\n", " \n", " \n", " \n", @@ -290,11 +290,11 @@ " \n", " \n", " \n", - " <a href=\"http://gss-data.org.uk/def/concept-scheme/countries-of-ownership\">Countries of Ownership</a>\n", + " <a href=\"http://gss-data.org.uk/concept-scheme?uri=http://gss-data.org.uk/def/concept-scheme/countries-of-ownership\">Countries of Ownership</a>\n", " \n", " \n", " <a href=\"http://gss-data.org.uk/data/gss_data/trade/ons_cpa\">UK trade in goods by classification of product by activity time series</a>\n", - " <a href=\"http://gss-data.org.uk/def/concept-scheme/ons-trade-areas-cord\">ONS Trade Areas CORD</a>\n", + " <a href=\"http://gss-data.org.uk/concept-scheme?uri=http://gss-data.org.uk/def/concept-scheme/ons-trade-areas-cord\">ONS Trade Areas CORD</a>\n", " \n", " \n", " \n", @@ -305,7 +305,7 @@ " \n", " \n", " <a href=\"http://gss-data.org.uk/data/gss_data/trade/ons_mrets\">UK trade time series</a>\n", - " <a href=\"http://gss-data.org.uk/def/concept-scheme/ons-trade-areas-cord\">ONS Trade Areas CORD</a>\n", + " <a href=\"http://gss-data.org.uk/concept-scheme?uri=http://gss-data.org.uk/def/concept-scheme/ons-trade-areas-cord\">ONS Trade Areas CORD</a>\n", " \n", " \n", " \n", @@ -316,7 +316,7 @@ " \n", " \n", " <a href=\"http://gss-data.org.uk/data/hmrc-overseas-trade-statistics\">HMRC Overseas Trade Statistics</a>\n", - " <a href=\"http://gss-data.org.uk/def/concept-scheme/hmrc-geographies\">HMRC Geographies</a>\n", + " <a href=\"http://gss-data.org.uk/concept-scheme?uri=http://gss-data.org.uk/def/concept-scheme/hmrc-geographies\">HMRC Geographies</a>\n", " \n", " \n", " \n", @@ -327,7 +327,7 @@ " \n", " \n", " <a href=\"http://gss-data.org.uk/data/ons-bop-individual-country-data\">ONS BoP Individual Country Data</a>\n", - " <a href=\"http://gss-data.org.uk/def/concept-scheme/ons-trade-areas-cord\">ONS Trade Areas CORD</a>\n", + " <a href=\"http://gss-data.org.uk/concept-scheme?uri=http://gss-data.org.uk/def/concept-scheme/ons-trade-areas-cord\">ONS Trade Areas CORD</a>\n", " \n", " \n", " \n",