Skip to content

Instantly share code, notes, and snippets.

@ImreSamu

ImreSamu/o2tilelist_test01.sh

Created September 2, 2016 15:38
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ImreSamu/770b6a15d8a882a2ab72bd12e9e405e4 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ImreSamu/770b6a15d8a882a2ab72bd12e9e405e4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
o2tilelist_test01.sh
#!/bin/bash
set -o errexit
set -o pipefail
set -o nounset
readonly IMPOSM_CACHE_DIR=${IMPOSM_CACHE_DIR:-/data/cache}
readonly OSM_DB=${OSM_DB:-osm}
readonly OSM_USER=${OSM_USER:-osm}
readonly OSM_PASSWORD=${OSM_PASSWORD:-osm}
readonly DB_SCHEMA=${OSM_SCHEMA:-public}
readonly DB_HOST=$DB_PORT_5432_TCP_ADDR
readonly PG_CONNECT="postgis://$OSM_USER:$OSM_PASSWORD@$DB_HOST/$OSM_DB"
TILELIST=${TILELIST:-/data/export/tiles.txt}
function exec_sql_code() {
local sql_code=$1
PG_PASSWORD=$OSM_PASSWORD psql \
--host="$DB_HOST" \
--port=5432 \
--dbname="$OSM_DB" \
--username="$OSM_USER" \
-v ON_ERROR_STOP=1 \
-a -c "$sql_code"
}
function make_test {
rm -f base.o*
rm -f zero.o*
country=malta
wget http://download.geofabrik.de/europe/${country}-160101.osm.pbf -O base.osm.pbf
cat <<OSMEOF > zero.osm
<?xml version='1.0' encoding='UTF-8'?>
<osm version="0.6" generator="osm-tiny-zero-generator">
</osm>
OSMEOF
osmconvert zero.osm -o=zero.osm.pbf
osmconvert base.osm.pbf -o=base.o5m
osmconvert zero.osm.pbf -o=zero.o5m
osmconvert base.o5m zero.o5m --diff --timestamp=2016-09-01T00:00:00Z --out-osc | gzip > ./osmdiff_all_del.osc.gz
osmconvert zero.o5m base.o5m --diff --timestamp=2016-09-01T00:00:00Z --out-osc | gzip > ./osmdiff_all_add.osc.gz
}
make_test
function i3_import {
echo ' ---- import ----'
imposm3 import \
-mapping "$MAPPING_YAML" \
-read $import_osm_pbf \
-diff \
-write \
-overwritecache \
-cachedir "$IMPOSM_CACHE_DIR" \
-deployproduction \
-connection $PG_CONNECT
}
function i3_diff {
echo ' ---- diff ----'
imposm3 diff \
-mapping "$MAPPING_YAML" \
-cachedir "$IMPOSM_CACHE_DIR" \
-connection $PG_CONNECT \
-tilelist $TILELIST \
-maxzoom 14 \
$import_osc_gz
}
import_osm_pbf=base.osm.pbf
import_osc_gz=osmdiff_all_del.osc.gz
TILELIST=_tiles_all_del.txt
i3_import
exec_sql_code "SELECT count(*) as count FROM osm_place_point";
i3_diff
exec_sql_code "SELECT count(*) as count FROM osm_place_point";
import_osm_pbf=zero.osm.pbf
import_osc_gz=osmdiff_all_add.osc.gz
TILELIST=_tiles_all_add.txt
i3_import
exec_sql_code "SELECT count(*) as count FROM osm_place_point";
i3_diff
exec_sql_code "SELECT count(*) as count FROM osm_place_point";
ls _tiles*.txt -la
@ImreSamu
Copy link
Copy Markdown
Author

ImreSamu commented Sep 2, 2016

my log

$:~/o2v_chtiles/osm2vectortiles/import$ chmod +x o2tilelist_test01.sh
$:~/o2v_chtiles/osm2vectortiles/import$ docker-compose run import-osm /data/import/o2tilelist_test01.sh
WARNING: The AWS_S3_HOST variable is not set. Defaulting to a blank string.
WARNING: The AWS_SECRET_ACCESS_KEY variable is not set. Defaulting to a blank string.
WARNING: The AWS_ACCESS_KEY_ID variable is not set. Defaulting to a blank string.
Starting osm2vectortiles_cache_1
Starting osm2vectortiles_pgdata_1
converted 'http://download.geofabrik.de/europe/malta-160101.osm.pbf' (ANSI_X3.4-1968) -> 'http://download.geofabrik.de/europe/malta-160101.osm.pbf' (UTF-8)
--2016-09-02 15:52:26--  http://download.geofabrik.de/europe/malta-160101.osm.pbf
Resolving download.geofabrik.de (download.geofabrik.de)... 5.9.155.152, 148.251.245.236
Connecting to download.geofabrik.de (download.geofabrik.de)|5.9.155.152|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 2867498 (2.7M) [application/octet-stream]
Saving to: 'base.osm.pbf'

base.osm.pbf                          100%[=========================================================================>]   2.73M  3.37MB/s   in 0.8s   

2016-09-02 15:52:27 (3.37 MB/s) - 'base.osm.pbf' saved [2867498/2867498]

 ----  import ----
[Sep  2 15:52:30] [INFO] removing existing cache /data/cache
[Sep  2 15:52:30] [INFO] [reader] reading base.osm.pbf with data till 2016-01-01 20:14:02 +0000 UTC
[Sep  2 15:52:31] [INFO] [     0] C:  485000/s (217471) N:    8300/s (3752) W:  746800/s (33974) R:      0/s (76)
[Sep  2 15:52:31] [INFO] Reading OSM data took: 743.519145ms
[Sep  2 15:52:34] [INFO] [    3s] C:       0/s ( 0.0%) N:       0/s (100.0%) W:   17700/s (100.0%) R:    170/s (100.0%)
[Sep  2 15:52:34] [INFO] Writing OSM data took: 3.513823312s
[Sep  2 15:52:34] [INFO] [PostGIS] Generalizing osm_water_polygon into osm_water_polygon_gen0 took: 33.183022ms
[Sep  2 15:52:34] [INFO] [PostGIS] Generalizing osm_building_polygon into osm_building_polygon_gen0 took: 131.880155ms
[Sep  2 15:52:34] [INFO] [PostGIS] Generalizing osm_landuse_polygon into osm_landuse_polygon_gen1 took: 197.22716ms
[Sep  2 15:52:35] [INFO] [PostGIS] Generalizing osm_landuse_polygon into osm_landuse_polygon_gen0 took: 43.593345ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating generalized tables took: 241.358734ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating OSM id index on osm_aero_polygon took: 28.831737ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating OSM id index on osm_water_linestring took: 31.18297ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating geometry index on osm_aero_polygon took: 4.291047ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating OSM id index on osm_landuse_polygon took: 33.230325ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating OSM id index on osm_poi_point took: 34.874756ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating OSM id index on osm_barrier_polygon took: 14.304619ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating geometry index on osm_water_linestring took: 19.153622ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating geometry index on osm_barrier_polygon took: 10.107169ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating OSM id index on osm_building_polygon took: 22.307214ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating OSM id index on osm_poi_polygon took: 22.427804ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating geometry index on osm_landuse_polygon took: 47.952757ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating geometry index on osm_poi_point took: 51.616443ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating OSM id index on osm_rail_station_point took: 15.952332ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating OSM id index on osm_housenumber_polygon took: 18.233675ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating geometry index on osm_poi_polygon took: 27.734449ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating geometry index on osm_rail_station_point took: 11.806099ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating geometry index on osm_housenumber_polygon took: 10.935689ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating geometry index on osm_building_polygon took: 56.623837ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating OSM id index on osm_housenumber_point took: 22.328249ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating OSM id index on osm_airport_point took: 22.495916ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating OSM id index on osm_aero_linestring took: 17.624187ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating geometry index on osm_airport_point took: 9.799558ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating geometry index on osm_housenumber_point took: 9.896569ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating geometry index on osm_aero_linestring took: 9.784173ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating OSM id index on osm_motorway_junction_point took: 16.688403ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating geometry index on osm_motorway_junction_point took: 3.656584ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating OSM id index on osm_water_polygon took: 10.075117ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating OSM id index on osm_mountain_peak_point took: 10.521419ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating geometry index on osm_mountain_peak_point took: 3.352858ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating geometry index on osm_water_polygon took: 5.784296ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating OSM id index on osm_admin_linestring took: 21.494053ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating OSM id index on osm_place_point took: 33.380518ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating OSM id index on osm_barrier_linestring took: 22.824344ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating geometry index on osm_admin_linestring took: 5.327637ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating geometry index on osm_place_point took: 5.36189ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating OSM id index on osm_road_geometry took: 34.954883ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating geometry index on osm_barrier_linestring took: 11.147819ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating OSM id index on osm_water_polygon_gen0 took: 12.065907ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating OSM id index on osm_airport_polygon took: 12.154666ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating geometry index on osm_water_polygon_gen0 took: 14.578887ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating geometry index on osm_airport_polygon took: 18.546575ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating OSM id index on osm_building_polygon_gen0 took: 36.960213ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating OSM id index on osm_landuse_polygon_gen0 took: 44.233043ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating OSM id index on osm_landuse_polygon_gen1 took: 56.226231ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating geometry index on osm_building_polygon_gen0 took: 41.047796ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating geometry index on osm_landuse_polygon_gen0 took: 19.845455ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating geometry index on osm_landuse_polygon_gen1 took: 11.455926ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating geometry index on osm_road_geometry took: 158.090455ms
[Sep  2 15:52:35] [INFO] [PostGIS] Creating geometry indices took: 343.468157ms
[Sep  2 15:52:35] [INFO] Importing OSM data took: 4.098825582s
[Sep  2 15:52:35] [INFO] [PostGIS] Rotating osm_housenumber_polygon from import -> public -> backup
[Sep  2 15:52:35] [INFO] [PostGIS] backup of osm_housenumber_polygon, to backup
[Sep  2 15:52:35] [INFO] [PostGIS] Rotating osm_airport_point from import -> public -> backup
[Sep  2 15:52:35] [INFO] [PostGIS] backup of osm_airport_point, to backup
[Sep  2 15:52:35] [INFO] [PostGIS] Rotating osm_housenumber_point from import -> public -> backup
[Sep  2 15:52:35] [INFO] [PostGIS] backup of osm_housenumber_point, to backup
[Sep  2 15:52:35] [INFO] [PostGIS] Rotating osm_rail_station_point from import -> public -> backup
[Sep  2 15:52:35] [INFO] [PostGIS] backup of osm_rail_station_point, to backup
[Sep  2 15:52:35] [INFO] [PostGIS] Rotating osm_motorway_junction_point from import -> public -> backup
[Sep  2 15:52:35] [INFO] [PostGIS] backup of osm_motorway_junction_point, to backup
[Sep  2 15:52:35] [INFO] [PostGIS] Rotating osm_mountain_peak_point from import -> public -> backup
[Sep  2 15:52:35] [INFO] [PostGIS] backup of osm_mountain_peak_point, to backup
[Sep  2 15:52:35] [INFO] [PostGIS] Rotating osm_aero_linestring from import -> public -> backup
[Sep  2 15:52:35] [INFO] [PostGIS] backup of osm_aero_linestring, to backup
[Sep  2 15:52:35] [INFO] [PostGIS] Rotating osm_road_geometry from import -> public -> backup
[Sep  2 15:52:35] [INFO] [PostGIS] backup of osm_road_geometry, to backup
[Sep  2 15:52:35] [INFO] [PostGIS] Rotating osm_admin_linestring from import -> public -> backup
[Sep  2 15:52:35] [INFO] [PostGIS] backup of osm_admin_linestring, to backup
[Sep  2 15:52:35] [INFO] [PostGIS] Rotating osm_barrier_linestring from import -> public -> backup
[Sep  2 15:52:35] [INFO] [PostGIS] backup of osm_barrier_linestring, to backup
[Sep  2 15:52:35] [INFO] [PostGIS] Rotating osm_airport_polygon from import -> public -> backup
[Sep  2 15:52:35] [INFO] [PostGIS] backup of osm_airport_polygon, to backup
[Sep  2 15:52:35] [INFO] [PostGIS] Rotating osm_water_polygon from import -> public -> backup
[Sep  2 15:52:35] [INFO] [PostGIS] backup of osm_water_polygon, to backup
[Sep  2 15:52:35] [INFO] [PostGIS] Rotating osm_place_point from import -> public -> backup
[Sep  2 15:52:35] [INFO] [PostGIS] backup of osm_place_point, to backup
[Sep  2 15:52:35] [INFO] [PostGIS] Rotating osm_poi_point from import -> public -> backup
[Sep  2 15:52:35] [INFO] [PostGIS] backup of osm_poi_point, to backup
[Sep  2 15:52:35] [INFO] [PostGIS] Rotating osm_barrier_polygon from import -> public -> backup
[Sep  2 15:52:35] [INFO] [PostGIS] backup of osm_barrier_polygon, to backup
[Sep  2 15:52:35] [INFO] [PostGIS] Rotating osm_building_polygon from import -> public -> backup
[Sep  2 15:52:35] [INFO] [PostGIS] backup of osm_building_polygon, to backup
[Sep  2 15:52:35] [INFO] [PostGIS] Rotating osm_poi_polygon from import -> public -> backup
[Sep  2 15:52:35] [INFO] [PostGIS] backup of osm_poi_polygon, to backup
[Sep  2 15:52:35] [INFO] [PostGIS] Rotating osm_aero_polygon from import -> public -> backup
[Sep  2 15:52:35] [INFO] [PostGIS] backup of osm_aero_polygon, to backup
[Sep  2 15:52:35] [INFO] [PostGIS] Rotating osm_landuse_polygon from import -> public -> backup
[Sep  2 15:52:35] [INFO] [PostGIS] backup of osm_landuse_polygon, to backup
[Sep  2 15:52:35] [INFO] [PostGIS] Rotating osm_water_linestring from import -> public -> backup
[Sep  2 15:52:35] [INFO] [PostGIS] backup of osm_water_linestring, to backup
[Sep  2 15:52:35] [INFO] [PostGIS] Rotating osm_building_polygon_gen0 from import -> public -> backup
[Sep  2 15:52:35] [INFO] [PostGIS] backup of osm_building_polygon_gen0, to backup
[Sep  2 15:52:35] [INFO] [PostGIS] Rotating osm_landuse_polygon_gen0 from import -> public -> backup
[Sep  2 15:52:35] [INFO] [PostGIS] backup of osm_landuse_polygon_gen0, to backup
[Sep  2 15:52:35] [INFO] [PostGIS] Rotating osm_landuse_polygon_gen1 from import -> public -> backup
[Sep  2 15:52:35] [INFO] [PostGIS] backup of osm_landuse_polygon_gen1, to backup
[Sep  2 15:52:35] [INFO] [PostGIS] Rotating osm_water_polygon_gen0 from import -> public -> backup
[Sep  2 15:52:35] [INFO] [PostGIS] backup of osm_water_polygon_gen0, to backup
[Sep  2 15:52:35] [INFO] [PostGIS] Rotating tables took: 186.611485ms
[Sep  2 15:52:35] [INFO] Imposm took: 5.151895206s
SELECT count(*) as count FROM  osm_place_point
 count 
-------
   149
(1 row)

 ----  diff ----
[Sep  2 15:52:35] [WARN] [diff] cannot find state file osmdiff_all_del.state.txt
[Sep  2 15:52:35] [WARN] [osc parser] unhandled XML tag bounds in OSC
[Sep  2 15:53:04] [INFO] [diff] Parsing changes, updating cache and removing elements took: 28.254639201s
[Sep  2 15:53:04] [INFO] [   28s] C:   16000/s (217471) N:       0/s (0) W:    2200/s (33974) R:      0/s (331)
[Sep  2 15:53:04] [INFO] [PostGIS] Updating generalized tables took: 36.137µs
[Sep  2 15:53:04] [INFO] [diff] Writing added/modified elements took: 8.874008ms
[Sep  2 15:53:04] [INFO] [diff] Processing osmdiff_all_del.osc.gz took: 28.288979705s
[Sep  2 15:53:04] [INFO] [     0] C:       0/s (0) N:       0/s (0) W:       0/s (0) R:      0/s (0)
[Sep  2 15:53:04] [INFO] [diff] Wrote list of expired tiles to _tiles_all_del.txt
SELECT count(*) as count FROM  osm_place_point
 count 
-------
     0
(1 row)

 ----  import ----
[Sep  2 15:53:04] [INFO] removing existing cache /data/cache
[Sep  2 15:53:04] [INFO] Reading OSM data took: 131.405361ms
[Sep  2 15:53:04] [INFO] [     0] C:       0/s (0) N:       0/s (0) W:       0/s (0) R:      0/s (0)
[Sep  2 15:53:05] [INFO] [     0] C:       0/s (0) N:       0/s (0) W:       0/s (0) R:      0/s (0)
[Sep  2 15:53:05] [INFO] Writing OSM data took: 851.435137ms
[Sep  2 15:53:05] [INFO] [PostGIS] Generalizing osm_water_polygon into osm_water_polygon_gen0 took: 24.521224ms
[Sep  2 15:53:05] [INFO] [PostGIS] Generalizing osm_landuse_polygon into osm_landuse_polygon_gen1 took: 27.46293ms
[Sep  2 15:53:05] [INFO] [PostGIS] Generalizing osm_building_polygon into osm_building_polygon_gen0 took: 36.349724ms
[Sep  2 15:53:05] [INFO] [PostGIS] Generalizing osm_landuse_polygon into osm_landuse_polygon_gen0 took: 15.831368ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating generalized tables took: 52.619678ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating OSM id index on osm_aero_polygon took: 16.989354ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating OSM id index on osm_barrier_linestring took: 18.096932ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating OSM id index on osm_airport_point took: 18.616069ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating geometry index on osm_aero_polygon took: 3.28056ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating OSM id index on osm_housenumber_polygon took: 20.268663ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating geometry index on osm_airport_point took: 3.37615ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating OSM id index on osm_motorway_junction_point took: 10.366815ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating OSM id index on osm_place_point took: 15.056665ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating geometry index on osm_housenumber_polygon took: 17.050807ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating geometry index on osm_barrier_linestring took: 18.929574ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating geometry index on osm_motorway_junction_point took: 8.357616ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating geometry index on osm_place_point took: 3.391488ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating OSM id index on osm_poi_polygon took: 15.503316ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating OSM id index on osm_water_linestring took: 18.648711ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating OSM id index on osm_water_polygon took: 20.407572ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating OSM id index on osm_barrier_polygon took: 17.221219ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating geometry index on osm_poi_polygon took: 3.613052ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating geometry index on osm_water_linestring took: 3.654526ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating geometry index on osm_barrier_polygon took: 4.777135ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating OSM id index on osm_airport_polygon took: 11.393987ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating geometry index on osm_water_polygon took: 15.233153ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating OSM id index on osm_mountain_peak_point took: 15.089054ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating geometry index on osm_airport_polygon took: 3.457863ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating OSM id index on osm_housenumber_point took: 12.280564ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating geometry index on osm_housenumber_point took: 4.442983ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating OSM id index on osm_building_polygon took: 10.727934ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating OSM id index on osm_rail_station_point took: 13.125202ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating geometry index on osm_building_polygon took: 5.802474ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating geometry index on osm_mountain_peak_point took: 16.634903ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating OSM id index on osm_road_geometry took: 10.487429ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating geometry index on osm_rail_station_point took: 3.574817ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating OSM id index on osm_poi_point took: 10.921429ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating OSM id index on osm_landuse_polygon took: 10.352764ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating OSM id index on osm_aero_linestring took: 12.451846ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating geometry index on osm_poi_point took: 3.294218ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating geometry index on osm_aero_linestring took: 3.656332ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating geometry index on osm_landuse_polygon took: 4.132441ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating geometry index on osm_road_geometry took: 17.813097ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating OSM id index on osm_admin_linestring took: 12.355721ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating OSM id index on osm_landuse_polygon_gen0 took: 10.351254ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating OSM id index on osm_building_polygon_gen0 took: 13.548493ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating OSM id index on osm_water_polygon_gen0 took: 13.817524ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating geometry index on osm_admin_linestring took: 3.867186ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating geometry index on osm_landuse_polygon_gen0 took: 3.498288ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating geometry index on osm_building_polygon_gen0 took: 3.565813ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating geometry index on osm_water_polygon_gen0 took: 4.612475ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating OSM id index on osm_landuse_polygon_gen1 took: 11.089756ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating geometry index on osm_landuse_polygon_gen1 took: 10.82357ms
[Sep  2 15:53:05] [INFO] [PostGIS] Creating geometry indices took: 143.206857ms
[Sep  2 15:53:05] [INFO] Importing OSM data took: 1.047455723s
[Sep  2 15:53:05] [INFO] [PostGIS] Rotating osm_barrier_polygon from import -> public -> backup
[Sep  2 15:53:05] [INFO] [PostGIS] backup of osm_barrier_polygon, to backup
[Sep  2 15:53:05] [INFO] [PostGIS] Rotating osm_mountain_peak_point from import -> public -> backup
[Sep  2 15:53:05] [INFO] [PostGIS] backup of osm_mountain_peak_point, to backup
[Sep  2 15:53:05] [INFO] [PostGIS] Rotating osm_airport_polygon from import -> public -> backup
[Sep  2 15:53:05] [INFO] [PostGIS] backup of osm_airport_polygon, to backup
[Sep  2 15:53:05] [INFO] [PostGIS] Rotating osm_rail_station_point from import -> public -> backup
[Sep  2 15:53:05] [INFO] [PostGIS] backup of osm_rail_station_point, to backup
[Sep  2 15:53:05] [INFO] [PostGIS] Rotating osm_road_geometry from import -> public -> backup
[Sep  2 15:53:05] [INFO] [PostGIS] backup of osm_road_geometry, to backup
[Sep  2 15:53:05] [INFO] [PostGIS] Rotating osm_poi_point from import -> public -> backup
[Sep  2 15:53:05] [INFO] [PostGIS] backup of osm_poi_point, to backup
[Sep  2 15:53:05] [INFO] [PostGIS] Rotating osm_housenumber_point from import -> public -> backup
[Sep  2 15:53:05] [INFO] [PostGIS] backup of osm_housenumber_point, to backup
[Sep  2 15:53:05] [INFO] [PostGIS] Rotating osm_building_polygon from import -> public -> backup
[Sep  2 15:53:05] [INFO] [PostGIS] backup of osm_building_polygon, to backup
[Sep  2 15:53:05] [INFO] [PostGIS] Rotating osm_aero_linestring from import -> public -> backup
[Sep  2 15:53:05] [INFO] [PostGIS] backup of osm_aero_linestring, to backup
[Sep  2 15:53:05] [INFO] [PostGIS] Rotating osm_landuse_polygon from import -> public -> backup
[Sep  2 15:53:05] [INFO] [PostGIS] backup of osm_landuse_polygon, to backup
[Sep  2 15:53:05] [INFO] [PostGIS] Rotating osm_admin_linestring from import -> public -> backup
[Sep  2 15:53:05] [INFO] [PostGIS] backup of osm_admin_linestring, to backup
[Sep  2 15:53:05] [INFO] [PostGIS] Rotating osm_place_point from import -> public -> backup
[Sep  2 15:53:05] [INFO] [PostGIS] backup of osm_place_point, to backup
[Sep  2 15:53:05] [INFO] [PostGIS] Rotating osm_water_polygon from import -> public -> backup
[Sep  2 15:53:05] [INFO] [PostGIS] backup of osm_water_polygon, to backup
[Sep  2 15:53:05] [INFO] [PostGIS] Rotating osm_water_linestring from import -> public -> backup
[Sep  2 15:53:05] [INFO] [PostGIS] backup of osm_water_linestring, to backup
[Sep  2 15:53:05] [INFO] [PostGIS] Rotating osm_aero_polygon from import -> public -> backup
[Sep  2 15:53:05] [INFO] [PostGIS] backup of osm_aero_polygon, to backup
[Sep  2 15:53:05] [INFO] [PostGIS] Rotating osm_barrier_linestring from import -> public -> backup
[Sep  2 15:53:05] [INFO] [PostGIS] backup of osm_barrier_linestring, to backup
[Sep  2 15:53:05] [INFO] [PostGIS] Rotating osm_airport_point from import -> public -> backup
[Sep  2 15:53:05] [INFO] [PostGIS] backup of osm_airport_point, to backup
[Sep  2 15:53:05] [INFO] [PostGIS] Rotating osm_housenumber_polygon from import -> public -> backup
[Sep  2 15:53:05] [INFO] [PostGIS] backup of osm_housenumber_polygon, to backup
[Sep  2 15:53:05] [INFO] [PostGIS] Rotating osm_motorway_junction_point from import -> public -> backup
[Sep  2 15:53:05] [INFO] [PostGIS] backup of osm_motorway_junction_point, to backup
[Sep  2 15:53:05] [INFO] [PostGIS] Rotating osm_poi_polygon from import -> public -> backup
[Sep  2 15:53:05] [INFO] [PostGIS] backup of osm_poi_polygon, to backup
[Sep  2 15:53:05] [INFO] [PostGIS] Rotating osm_building_polygon_gen0 from import -> public -> backup
[Sep  2 15:53:05] [INFO] [PostGIS] backup of osm_building_polygon_gen0, to backup
[Sep  2 15:53:05] [INFO] [PostGIS] Rotating osm_landuse_polygon_gen0 from import -> public -> backup
[Sep  2 15:53:05] [INFO] [PostGIS] backup of osm_landuse_polygon_gen0, to backup
[Sep  2 15:53:05] [INFO] [PostGIS] Rotating osm_landuse_polygon_gen1 from import -> public -> backup
[Sep  2 15:53:05] [INFO] [PostGIS] backup of osm_landuse_polygon_gen1, to backup
[Sep  2 15:53:05] [INFO] [PostGIS] Rotating osm_water_polygon_gen0 from import -> public -> backup
[Sep  2 15:53:05] [INFO] [PostGIS] backup of osm_water_polygon_gen0, to backup
[Sep  2 15:53:05] [INFO] [PostGIS] Rotating tables took: 192.592302ms
[Sep  2 15:53:05] [INFO] Imposm took: 1.494441192s
SELECT count(*) as count FROM  osm_place_point
 count 
-------
     0
(1 row)

 ----  diff ----
[Sep  2 15:53:06] [WARN] [diff] cannot find state file osmdiff_all_add.state.txt
[Sep  2 15:53:06] [WARN] [osc parser] unhandled XML tag bounds in OSC
[Sep  2 15:53:16] [INFO] [diff] Parsing changes, updating cache and removing elements took: 9.876559229s
[Sep  2 15:53:16] [INFO] [    9s] C:   31000/s (217471) N:     500/s (3752) W:   13400/s (33974) R:      0/s (331)
[Sep  2 15:53:39] [INFO] [PostGIS] Updating generalized tables took: 2.466763764s
[Sep  2 15:53:39] [INFO] [diff] Writing added/modified elements took: 23.15890386s
[Sep  2 15:53:39] [INFO] [diff] Processing osmdiff_all_add.osc.gz took: 33.060206072s
[Sep  2 15:53:39] [INFO] [   23s] C:       0/s (0) N:    2500/s (3752) W:    1700/s (33974) R:    540/s (330)
[Sep  2 15:53:39] [INFO] [diff] Wrote list of expired tiles to _tiles_all_add.txt
SELECT count(*) as count FROM  osm_place_point
 count 
-------
   149
(1 row)

-rw-r--r-- 1 root root 4195 Sep  2 15:53 _tiles_all_add.txt
-rw-r--r-- 1 root root    0 Sep  2 15:53 _tiles_all_del.txt

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment