Stefan sfkeller

Oberseerundweg - Demo

Original site and copyrights: http://artsafiental.ch/

Base URLs for

Beschreibung (umap):

	/*
	---------------------------------
	ballparks2.geojson from James Fee
	---------------------------------

	Note that there's attribute "Teams", which has a value of a JSON array of JSON objects.
	QGIS 3 interprets this as string.
	Turning this string into an array still is an array of JSON Objects.
	So, this has to be treated first as a JSON object.

	--
	-- FUNCTION split_text_to_array(...)
	-- Accepts a delimited text (string). Returns a sorted array of text.
	--
	--drop function if exists split_text_to_array(text, char(1));
	create or replace function split_text_to_array(text_delimited text, delimiter text default ';')
	returns text[]
	as $$
	select array(select regexp_split_to_table(lower(regexp_replace(text_delimited, '( )\|'\|\|delimiter\|\|'$', '', 'g')), delimiter) order by 1);
	$$ language sql immutable strict parallel safe;

	/*==================================================
	* Stored Function link_pg_server(...)
	* ==================================================
	*
	* Linking to a remote PostgreSQL db read-only.
	* Uses postgres_fdw the SQL/MED implementation
	* (Foreign Data Wrapper).
	* Goal is to achieve aka "SQL Endpoints" for linked data
	* similar to SPARQL.
	*

	SELECT
	CASE WHEN GROUPING(movie.genre) = 1 then 'All Genres' else movie.genre end as Genre,
	CASE WHEN GROUPING(customer.gender) = 1 then 'All Genders' else customer.gender end as Gender,
	sum(sales.quantity) AS Quantity
	FROM factsales sales, dimmovie movie, dimcustomer customer
	WHERE sales.movieId = movie.movieId
	AND sales.custID = customer.custID
	GROUP BY CUBE(movie.genre, customer.gender);

	/*

	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="utf-8">
	<title>Embedded uMap Example</title>
	<link rel="stylesheet" href="style.css">
	<script src="script.js"></script>
	</head>
	<body>
	<!-- page content -->