Last change
on this file since 29032 was 26899, checked in by davidb, 11 years ago |
Tipple reborn after Chris's Summer of Code 2013
|
File size:
1.4 KB
|
Line | |
---|
1 | Both the pgsimple and pgsnapshot schemas are PostgreSQL schemas utilising postgis extensions that are capable of storing snapshots of OSM data.
|
---|
2 | No history is maintained.
|
---|
3 | They can be populated by osmosis and kept up to date with osmosis daily, hourly and minute changesets.
|
---|
4 |
|
---|
5 | The pgsimple and pgsnapshot schemas are forked versions of the same schema.
|
---|
6 | Up to version 5 of the schema they were known as the "simple" schema.
|
---|
7 | The pgsimple schema is the "simple" schema and is unchanged.
|
---|
8 | Since version 6, the pgsnapshot schema has deviated to include all tag information in hstore "tags" columns inside the parent entity tables.
|
---|
9 |
|
---|
10 | The purpose of the pgsimple schema is to provide a simplistic and generic schema for storing OSM data in a PostGIS format.
|
---|
11 | The purpose of the pgsnapshot schema is similar but maximises performance through CLUSTERed indexes and embedded tag data. It imposes additional programming complexity.
|
---|
12 |
|
---|
13 | The following scripts are available for both schemas:
|
---|
14 | pgxxx_schema_0.x.sql - The schema creation script.
|
---|
15 | pgxxx_schema_0.x_bbox.sql - A script for adding way bbox column support.
|
---|
16 | pgxxx_schema_0.x_linestring.sql - A script for adding way linestring column support.
|
---|
17 | pgxxx_schema_0.x_action.sql - A script for adding an action table which is populated during changeset processing to allow derivative tables to be kept up to date.
|
---|
18 | pgxxx_load_0.x.sql - A script for importing PostgreSQL "COPY" files as produced by the osmosis --write-pgxxx-dump tasks.
|
---|
Note:
See
TracBrowser
for help on using the repository browser.