|
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:
373 bytes
|
| Line | |
|---|
| 1 | -- Add a postgis GEOMETRY column to the way table for the purpose of storing the full linestring of the way.
|
|---|
| 2 | SELECT AddGeometryColumn('ways', 'linestring', 4326, 'GEOMETRY', 2);
|
|---|
| 3 |
|
|---|
| 4 | -- Add an index to the bbox column.
|
|---|
| 5 | CREATE INDEX idx_ways_linestring ON ways USING gist (linestring);
|
|---|
| 6 |
|
|---|
| 7 | -- Cluster table by geographical location.
|
|---|
| 8 | CLUSTER ways USING idx_ways_linestring;
|
|---|
Note:
See
TracBrowser
for help on using the repository browser.
