No description, website, or topics provided.
Branch: master
Clone or download
Sven Geggus
Sven Geggus Change re-creation of MATERIALIZED VIEW to use a temporary name.
This way prevent downtime of production databases.
Latest commit b089393 Feb 19, 2019
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.gitignore imposm setup for poi database with incremental updates Jan 9, 2019
INSTALL.md
LICENSE
README.md Update README.md Jan 9, 2019
config.json imposm setup for poi database with incremental updates Jan 9, 2019
doimport.sh imposm setup for poi database with incremental updates Jan 9, 2019
gen_indexes.sql imposm setup for poi database with incremental updates Jan 9, 2019
gen_mview_poi_campsites.sql Change re-creation of MATERIALIZED VIEW to use a temporary name. Feb 19, 2019
get-campsites.cgi
imposm-update.service
poi-only.yml imposm setup for poi database with incremental updates Jan 9, 2019
update.sh Need to add CONCURRENTLY keyword to REFRESH MATERIALIZED VIEW to Jan 23, 2019

README.md

A POI database made from Openstreetmap data

This uses a setup based on PostGIS and imposm. The database is updated hourly.

Special tables or views based on spatial operations can be created by sql scripts which are executed right after the hourly updates. Currently only a materialized view containing campsites is updated at this place.