annotate create_test_db.data.sql @ 3:bccc1e155ad8
Simplified approximated distance calculation on WGS-84 ellipsoid
| author |
jbe |
| date |
Mon Aug 22 21:35:25 2016 +0200 (2016-08-22) |
| parents |
3b70e93cc07d |
| children |
684a78d2f9f0 |
| rev |
line source |
|
jbe@0
|
1
|
|
jbe@0
|
2 INSERT INTO "test" ("location", "area") SELECT
|
|
jbe@0
|
3 epoint((asin(2*random()-1) / pi()) * 180, (2*random()-1) * 180),
|
|
jbe@0
|
4 ecircle((asin(2*random()-1) / pi()) * 180, (2*random()-1) * 180, -ln(1-random()) * 1000)
|
|
jbe@0
|
5 FROM generate_series(1, 10000);
|
|
jbe@0
|
6
|