pgLatLon

view create_test_db.data.sql @ 0:3b70e93cc07d

Version 0.1 (initial commit)
author jbe
date Sun Aug 21 17:43:48 2016 +0200 (2016-08-21)
parents
children 684a78d2f9f0
line source
2 INSERT INTO "test" ("location", "area") SELECT
3 epoint((asin(2*random()-1) / pi()) * 180, (2*random()-1) * 180),
4 ecircle((asin(2*random()-1) / pi()) * 180, (2*random()-1) * 180, -ln(1-random()) * 1000)
5 FROM generate_series(1, 10000);

Impressum / About Us