::ORIGIN + ::DEST
Dashboards: browser · CLI · servers
Community extension: anofox_render


A flow map’s start: a region code (‘DE-BY’), a WKT POINT or {‘lon’: …, ‘lat’: …, ‘name’: …} — with ::DEST, width by ::SIZE. With ::DEST: a flow map’s end (see ::ORIGIN).
Also spelled: ::FROM_PLACE · ::DEST (::DESTINATION, ::TO_PLACE)
The data it needs
Section titled “The data it needs”One row per flow: ::ORIGIN → ::DEST as region codes, WKT points or {'lon', 'lat', 'name'} structs; ::SIZE sets the width. In a ::SANKEY, the same pair names the links.
SELECT a ::ORIGIN, b ::DEST, n ::SIZE, 'de-states' ::BASEMAPFROM (VALUES ('DE-HH','DE-BY',40),('DE-HH','DE-BE',25),('DE-NW','DE-BY',30)) t(a, b, n);In an example
Section titled “In an example”From Which chart fits which question? — open it in the builder ↗:
SELECT 12::COL; SELECT src::ORIGIN, dst::DEST, n::SANKEY, 'Where visits go (::SANKEY)'::TITLEFROM (VALUES ('Search','Product',520), ('Ads','Product',310), ('Email','Product',120), ('Product','Cart',540), ('Product','Left',410), ('Cart','Order',380), ('Cart','Left',160)) v(src, dst, n)Also in: Where do our deliveries and customers cluster, and which regions are underserved? · Where does our supply chain amplify demand, and what would stabilise it?
Related
Section titled “Related”::MAP · ::REGION · ::LAT + ::LON · ::BASEMAP