liquid_feedback_core
diff 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 |
line diff
1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 1.2 +++ b/pgLatLon/create_test_db.data.sql Thu Aug 18 20:19:58 2016 +0200 1.3 @@ -0,0 +1,6 @@ 1.4 + 1.5 +INSERT INTO "test" ("location", "area") SELECT 1.6 + epoint((asin(2*random()-1) / pi()) * 180, (2*random()-1) * 180), 1.7 + ecircle((asin(2*random()-1) / pi()) * 180, (2*random()-1) * 180, -ln(1-random()) * 1000) 1.8 + FROM generate_series(1, 10000); 1.9 +