|
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:
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.
