SQL Snippets – SKIPPERKONGENPart_III_Analysis_on_maps Data generation Generate 500 points, roughly on circle of radius 1. Jitter x and y by +/-0.25: SELECT ST_MakePoint( Cos(2 * Pi() * d / 500.0) -- x * (1 + Random() * 0.5 - 0.25), -- jitter-x Sin(2 * Pi() * d / 500.0) -- y * (1 + Random() * 0.5 - 0.25) -- jitter-y ) as wkb_geometry FROM generate_series(0, 500) d; Create a synthetic star ratings table: CREATE TABLE ratings A
