annotate create_test_db.data.sql @ 28:2c963e07c9b7
Added tag v0.6 for changeset a7ba8335e541
| author |
jbe |
| date |
Thu Sep 22 23:37:45 2016 +0200 (2016-09-22) |
| parents |
684a78d2f9f0 |
| children |
3cbce515387f |
| rev |
line source |
|
jbe@0
|
1
|
|
jbe@10
|
2 CREATE OR REPLACE FUNCTION tmp_three_points()
|
|
jbe@10
|
3 RETURNS epoint[]
|
|
jbe@10
|
4 LANGUAGE plpgsql VOLATILE AS $$
|
|
jbe@10
|
5 DECLARE
|
|
jbe@10
|
6 p1 epoint;
|
|
jbe@10
|
7 p2 epoint;
|
|
jbe@10
|
8 p3 epoint;
|
|
jbe@10
|
9 BEGIN
|
|
jbe@10
|
10 p1 := epoint((asin(2*random()-1) / pi()) * 180, (2*random()-1) * 180);
|
|
jbe@10
|
11 p2 := epoint(latitude(p1) + (2*random()-1), longitude(p1) + cos(latitude(p1)/180*pi()) * (2*random()-1));
|
|
jbe@10
|
12 p3 := epoint(latitude(p1) + (2*random()-1), longitude(p1) + cos(latitude(p1)/180*pi()) * (2*random()-1));
|
|
jbe@10
|
13 RETURN ARRAY[p1, p2, p3];
|
|
jbe@10
|
14 END;
|
|
jbe@10
|
15 $$;
|
|
jbe@10
|
16
|
|
jbe@10
|
17 INSERT INTO "test" ("location", "surrounding", "multipoint", "triangle") SELECT
|
|
jbe@0
|
18 epoint((asin(2*random()-1) / pi()) * 180, (2*random()-1) * 180),
|
|
jbe@10
|
19 ecircle((asin(2*random()-1) / pi()) * 180, (2*random()-1) * 180, -ln(1-random()) * 1000),
|
|
jbe@10
|
20 ecluster_create_multipoint(tmp_three_points()),
|
|
jbe@10
|
21 ecluster_create_polygon(tmp_three_points())
|
|
jbe@0
|
22 FROM generate_series(1, 10000);
|
|
jbe@0
|
23
|
|
jbe@10
|
24 DROP FUNCTION tmp_three_points();
|