1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
SELECT 'intersection', ST_AsText(ST_Intersection(
'LINESTRING(0 0, 9 0)'::geometry,
'LINESTRING(7 0, 13.2 0)'::geometry,
2));
SELECT 'difference', ST_AsText(ST_Difference(
'LINESTRING(0 0, 9 0)'::geometry,
'LINESTRING(7 0, 13.2 0)'::geometry,
2));
SELECT 'symdifference', ST_AsText(ST_SymDifference(
'LINESTRING(0 0, 9 0)'::geometry,
'LINESTRING(7 0, 13.2 0)'::geometry,
2));
SELECT 'union', ST_AsText(ST_Union(
'LINESTRING(0.5 0, 9 0)'::geometry,
'LINESTRING(7 0, 13.2 0)'::geometry,
2));
SELECT 'unaryunion', ST_AsText(ST_UnaryUnion(
'GEOMETRYCOLLECTION(LINESTRING(0.5 0, 9 0), LINESTRING(7 0, 13.2 0))'::geometry,
2));
WITH n AS (SELECT geom
FROM ST_Subdivide(
'POLYGON((0 0,0 10,10 10,10 6,100 5.1, 100 10, 110 10, 110 0, 100 0,100 4.9,10 5,10 0,0 0))'::geometry,
6, 1) AS geom)
SELECT 'subdivide', count(geom), ST_AsText(ST_Normalize(ST_Union(geom)))
FROM n;
|
