Last change
on this file since 33002 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.