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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
|
DROP TABLE IF EXISTS g;
CREATE TABLE g (
g geometry,
i integer,
f real,
t text,
d date
);
INSERT INTO g (g, i, f, t, d)
VALUES ('POINT(42 42)', 1, 1.1, 'one', '2001-01-01');
INSERT INTO g (g, i, f, t, d)
VALUES ('LINESTRING(42 42, 45 45)', 2, 2.2, 'two', '2002-02-02');
INSERT INTO g (g, i, f, t, d)
VALUES ('POLYGON((42 42, 45 45, 45 42, 42 42))', 3, 3.3, 'three', '2003-03-03');
INSERT INTO g (g, i, f, t, d)
VALUES ('GEOMETRYCOLLECTION(POINT(42 42))', 4, 4.4, 'four', '2004-04-04');
INSERT INTO g VALUES ('POINT EMPTY', 5, 5.5, 'five', '2005-05-05');
INSERT INTO g VALUES (NULL, 6, 6.6, 'six', '2006-06-06');
INSERT INTO g VALUES ('GEOMETRYCOLLECTION(POINT EMPTY, POINT(1 2))', 7, 7.7, 'seven', '2007-07-07');
SELECT 'gj01', i, ST_AsGeoJSON(g) AS g1
FROM g ORDER BY i;
SELECT 'gj02', i, ST_AsGeoJSON(g.*) AS gj2
FROM g ORDER BY i;
SELECT 'gj03', i, to_json(g.*) AS rj3
FROM g ORDER BY i;
SELECT 'gj04', i, to_jsonb(g.*) AS rj4
FROM g ORDER BY i;
SELECT 'gj05', i, ST_AsGeoJSON(g.*, id_column => 'i') AS gj5
FROM g ORDER BY i;
SELECT '4695', ST_ASGeoJSON(a.*) FROM
(
SELECT 1 as v, ST_SetSRID(ST_Point(0,1),2227) as g
) a;
DROP TABLE g;
|
