annotate pgLatLon/create_test_db.data.sql @ 529:96ee2db56bec
New PostgreSQL extension "pgLatLon" for geospatial operations and indexing in LiquidFeedback
author |
jbe |
date |
Thu Aug 18 20:19:58 2016 +0200 (2016-08-18) |
parents |
|
children |
|
rev |
line source |
jbe@529
|
1
|
jbe@529
|
2 INSERT INTO "test" ("location", "area") SELECT
|
jbe@529
|
3 epoint((asin(2*random()-1) / pi()) * 180, (2*random()-1) * 180),
|
jbe@529
|
4 ecircle((asin(2*random()-1) / pi()) * 180, (2*random()-1) * 180, -ln(1-random()) * 1000)
|
jbe@529
|
5 FROM generate_series(1, 10000);
|
jbe@529
|
6
|