annotate create_test_db.schema.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 CREATE EXTENSION latlon;
|
|
jbe@0
|
3
|
|
jbe@0
|
4 CREATE TABLE "test" (
|
|
jbe@0
|
5 "id" SERIAL4 PRIMARY KEY,
|
|
jbe@0
|
6 "location" EPOINT NOT NULL,
|
|
jbe@0
|
7 "area" ECIRCLE NOT NULL );
|
|
jbe@0
|
8
|
|
jbe@0
|
9 CREATE INDEX "test_location_key" ON "test" USING gist ("location");
|
|
jbe@0
|
10 CREATE INDEX "test_area_key" ON "test" USING gist ("area");
|
|
jbe@0
|
11
|