ContextQMD
Back to Clickhouse

Functions for Generating SVG images from Geo data

docs/en/sql-reference/functions/geo/svg.md

26.4.1.1-new981 B
Original Source

Svg {#svg}

Returns a string of select SVG element tags from Geo data.

Syntax

sql
Svg(geometry,[style])

Aliases: SVG, svg

Parameters

  • geometry — Geo data. Geo.
  • style — Optional style name. String.

Returned value

  • The SVG representation of the geometry. String.
    • SVG circle
    • SVG polygon
    • SVG path

Examples

Circle

Query:

sql
SELECT SVG((0., 0.))

Result:

response
<circle cx="0" cy="0" r="5" style=""/>

Polygon

Query:

sql
SELECT SVG([(0., 0.), (10, 0), (10, 10), (0, 10)])

Result:

response
<polygon points="0,0 0,10 10,10 10,0 0,0" style=""/>

Path

Query:

sql
SELECT SVG([[(0., 0.), (10, 0), (10, 10), (0, 10)], [(4., 4.), (5, 4), (5, 5), (4, 5)]])

Result:

response
<g fill-rule="evenodd"><path d="M 0,0 L 0,10 L 10,10 L 10,0 L 0,0M 4,4 L 5,4 L 5,5 L 4,5 L 4,4 z " style=""/></g>