|
Last change
on this file since 26899 was 26899, checked in by davidb, 11 years ago |
|
Tipple reborn after Chris's Summer of Code 2013
|
|
File size:
337 bytes
|
| Line | |
|---|
| 1 | -- Add a postgis GEOMETRY column to the way table for the purpose of indexing the location of the way.
|
|---|
| 2 | -- This will contain a bounding box surrounding the extremities of the way.
|
|---|
| 3 | SELECT AddGeometryColumn('ways', 'bbox', 4326, 'GEOMETRY', 2);
|
|---|
| 4 |
|
|---|
| 5 | -- Add an index to the bbox column.
|
|---|
| 6 | CREATE INDEX idx_ways_bbox ON ways USING gist (bbox); |
|---|
Note:
See
TracBrowser
for help on using the repository browser.
