catalogue: datasets: 2 rows where harvest_id = 11 and licence = "https://creativecommons.org/licenses/by-nc/2.0/"

The datasets each portal's latest successful harvest found. landing_page is the publisher's page for the dataset; where a catalogue gives none, uri often is.

Data license: CC BY 4.0 (portal directory, derived from Dateno); dataset metadata as each portal publishes it · Data source: Dateno, DataPortals.org, data.europa.eu, opendatArchives, and each portal's DCAT catalogue

key: What identifies the dataset in its portal
landing_page: The publisher's page for the dataset
keywords: JSON list
themes: JSON list of theme IRIs

2 rows where harvest_id = 11 and licence = "https://creativecommons.org/licenses/by-nc/2.0/"

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	portal_id	key	harvest_id	title	description	landing_page	publisher	licence	issued	modified	keywords	themes	uri	identifier
data.london.gov.uk,20619	London Datastore – Greater London Authority data.london.gov.uk	20619	11 11	Domestic Migration	The Covid-19 pandemic impacted both domestic and international migration patterns. This briefing is intended to provide a summary of pre-pandemic domestic migration relating to London, to provide a baseline against which new data can be compared. The Office for National Statistics provide annual data on internal migration moves into and out of each local authority in England and Wales, and for this report we used the data for the year ending mid 2020 that were released in June 2021.	https://data.london.gov.uk/dataset/domestic-migration-20619	GLA Demography	https://creativecommons.org/licenses/by-nc/2.0/	2023-05-17T13:27:25.000Z	2023-05-25T10:35:11.000Z	["Boroughs", "Demography", "Employment", "Migration", "Population"]	["Business and Economy", "Demographics", "Employment and Skills", "Planning"]		20619
data.london.gov.uk,epoqw	London Datastore – Greater London Authority data.london.gov.uk	epoqw	11 11	Major Summer Heat Spots using Landsat-8 Thermal Satellite data	Fine resolution satellite thermal data can be used as a basis for mapping the spatial distribution of urban surface temperatures and identifying urban hotspots. This dataset has been produced from satellite-derived land surface temperature (LST) data for the Greater London Area by ARTi Analytics BV as part of EXTREMA Global portfolio of services and reveals the city’s major daytime summertime hotspots. Outline methodology For spatial resolutions coarser than 30 m it can be reasonably assumed that the urban LST hotspots coincide with the urban air temperature hotspots1. Hence, thermal satellite data can be used so as to identify intra-urban areas with elevated temperatures. To generate a dataset that presents the LST spatial distribution and the corresponding hotspots for GLA, a five-year (2016-2020) time series of satellite-derived 100 m daytime LST images (in °C) is employed. The utilized data correspond only to summer months (i.e. June, July and August) so as to capture the hotspots with the most important impact on thermal discomfort, human health and energy demand, and are derived from Landsat-8 thermal infrared images. The next step after estimating the 2016-2020, average, summertime, daytime LST is to aggregate them to city block level. In addition to the average LST (avgLST), the avgLST standard deviation, minimum and maximum for each city block are also estimated. The aforementioned statistics are stored as new attributes in the Urban Atlas polygons and the updated vectors are then exported as a new shapefile. The spatial extent of this output shapefile corresponds to the boundaries of GLA.	https://data.london.gov.uk/dataset/major-summer-heat-spots-using-landsat-8-thermal-satellite-data-epoqw	Greater London Authority	https://creativecommons.org/licenses/by-nc/2.0/	2021-03-17T17:25:32.000Z	2021-03-17T18:10:26.000Z	["urban heat island"]	["Environment"]		epoqw

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE datasets (
    portal_id TEXT NOT NULL REFERENCES portals(id),
    key TEXT NOT NULL,
    harvest_id INTEGER NOT NULL REFERENCES harvests(id),
    title TEXT,
    description TEXT,
    landing_page TEXT,
    publisher TEXT,
    licence TEXT,
    issued TEXT,
    modified TEXT,
    keywords TEXT NOT NULL,
    themes TEXT NOT NULL,
    uri TEXT,
    identifier TEXT,
    PRIMARY KEY (portal_id, key)
);