search

omniscale / imposm3

Imposm imports OpenStreetMap data into PostGIS
http://imposm.org/docs/imposm3/latest/
Apache License 2.0
726 stars 159 forks source link

MultiPolygon and Polygon #42

Closed h4ck3rm1k3 closed 9 years ago

h4ck3rm1k3 commented 10 years ago

Howdy, I am setting up a docker instance to run imposm and postgis I thought you might be interested in this.

importing http://download.geofabrik.de/north-america/us/kansas-latest.osm.pbf from 2014-11-02T21:22:01Z in this command : https://github.com/h4ck3rm1k3/docker-postgis/blob/master/splitter/north-america/us/kansas/runimport.sh in this container :

based on imposm built here : https://github.com/h4ck3rm1k3/docker-postgis/blob/master/imposm3/Dockerfile based on https://github.com/h4ck3rm1k3/docker-postgis/blob/master/splitter/Dockerfile

Using this database server :https://github.com/h4ck3rm1k3/docker-postgis/blob/master/Dockerfile

I get these errors on the database backend :

2014-11-03 09:00:30 UTC [33-1] docker@routing WARNING:  Could not convert 'geometry' in 'import.osm_landusages_gen1' to use typmod with srid 3857, type Polygon: Geometry type (MultiPolygon) does not match column type (Polygon)
2014-11-03 09:00:30 UTC [32-1] docker@routing WARNING:  Could not convert 'geometry' in 'import.osm_waterareas_gen1' to use typmod with srid 3857, type Polygon: Geometry type (MultiPolygon) does not match column type (Polygon)
2014-11-03 09:00:33 UTC [32-2] docker@routing WARNING:  Could not convert 'geometry' in 'import.osm_landusages_gen0' to use typmod with srid 3857, type Polygon: Geometry type (MultiPolygon) does not match column type (Polygon)
2014-11-03 09:00:33 UTC [33-2] docker@routing WARNING:  Could not convert 'geometry' in 'import.osm_waterareas_gen0' to use typmod with srid 3857, type Polygon: Geometry type (MultiPolygon) does not match column type (Polygon)

No errors on the import :

sudo docker run  -i -t --link pgroute:db osmsplitter_north-america_us_kansas /bin/bash /var/lib/splitter/north-america/us/kansas/runimport.sh
[Nov  3 08:59:18] [INFO] [reader] reading /var/lib/splitter/north-america/us/kansas/kansas-latest.osm.pbf with data till 2014-11-01 21:22:02 +0000 UTC
[Nov  3 08:59:31] [INFO] [   12s] C:  459000/s (4111660) N:   11900/s (101148) W:  116900/s (423309) R:      0/s (1398)
[Nov  3 08:59:31] [INFO] Reading OSM data took: 14.042693849s
[Nov  3 09:00:28] [INFO] Writing OSM data took: 56.737238561s
[Nov  3 09:00:28] [INFO] [   56s] C:       0/s ( 0.0%) N:   17100/s (100.0%) W:   11100/s (100.0%) R:   1200/s (100.0%)
[Nov  3 09:00:30] [INFO] [PostGIS] Generalizing osm_landusages into osm_landusages_gen1 took: 1.922886368s
[Nov  3 09:00:30] [INFO] [PostGIS] Generalizing osm_waterareas into osm_waterareas_gen1 took: 2.302896905s
[Nov  3 09:00:31] [INFO] [PostGIS] Generalizing osm_waterways into osm_waterways_gen1 took: 3.18118259s
[Nov  3 09:00:32] [INFO] [PostGIS] Generalizing osm_roads into osm_roads_gen1 took: 4.157985867s
[Nov  3 09:00:33] [INFO] [PostGIS] Generalizing osm_landusages into osm_landusages_gen0 took: 453.898759ms
[Nov  3 09:00:33] [INFO] [PostGIS] Generalizing osm_waterareas into osm_waterareas_gen0 took: 731.503489ms
[Nov  3 09:00:34] [INFO] [PostGIS] Generalizing osm_waterways into osm_waterways_gen0 took: 1.342761914s
[Nov  3 09:00:34] [INFO] [PostGIS] Generalizing osm_roads into osm_roads_gen0 took: 1.632728236s
[Nov  3 09:00:34] [INFO] [PostGIS] Creating generalized tables took: 5.790997736s
[Nov  3 09:00:34] [INFO] [PostGIS] Creating OSM id index on osm_aeroways took: 230.879345ms
[Nov  3 09:00:34] [INFO] [PostGIS] Creating OSM id index on osm_admin took: 241.486531ms
[Nov  3 09:00:34] [INFO] [PostGIS] Creating OSM id index on osm_places took: 286.035037ms
[Nov  3 09:00:34] [INFO] [PostGIS] Creating OSM id index on osm_landusages took: 286.355584ms
[Nov  3 09:00:34] [INFO] [PostGIS] Creating OSM id index on osm_waterareas took: 286.557933ms
[Nov  3 09:00:34] [INFO] [PostGIS] Creating OSM id index on osm_barrierpoints took: 286.460844ms
[Nov  3 09:00:34] [INFO] [PostGIS] Creating OSM id index on osm_barrierways took: 286.986406ms
[Nov  3 09:00:34] [INFO] [PostGIS] Creating geometry index on osm_admin took: 57.560808ms
[Nov  3 09:00:34] [INFO] [PostGIS] Creating geometry index on osm_aeroways took: 69.354566ms
[Nov  3 09:00:34] [INFO] [PostGIS] Creating geometry index on osm_places took: 114.842205ms
[Nov  3 09:00:34] [INFO] [PostGIS] Creating geometry index on osm_barrierways took: 141.705018ms
[Nov  3 09:00:34] [INFO] [PostGIS] Creating OSM id index on osm_transport_areas took: 130.788944ms
[Nov  3 09:00:34] [INFO] [PostGIS] Creating geometry index on osm_waterareas took: 145.772625ms
[Nov  3 09:00:34] [INFO] [PostGIS] Creating geometry index on osm_barrierpoints took: 147.23383ms
[Nov  3 09:00:35] [INFO] [PostGIS] Creating geometry index on osm_transport_areas took: 161.075767ms
[Nov  3 09:00:35] [INFO] [PostGIS] Creating OSM id index on osm_transport_points took: 312.624297ms
[Nov  3 09:00:35] [INFO] [PostGIS] Creating OSM id index on osm_buildings took: 489.033558ms
[Nov  3 09:00:35] [INFO] [PostGIS] Creating OSM id index on osm_housenumbers_interpolated took: 487.70113ms
[Nov  3 09:00:35] [INFO] [PostGIS] Creating OSM id index on osm_housenumbers took: 622.170667ms
[Nov  3 09:00:35] [INFO] [PostGIS] Creating geometry index on osm_landusages took: 636.430073ms
[Nov  3 09:00:35] [INFO] [PostGIS] Creating OSM id index on osm_amenities took: 494.578158ms
[Nov  3 09:00:35] [INFO] [PostGIS] Creating geometry index on osm_transport_points took: 268.434797ms
[Nov  3 09:00:35] [INFO] [PostGIS] Creating OSM id index on osm_waterways took: 389.832715ms
[Nov  3 09:00:35] [INFO] [PostGIS] Creating geometry index on osm_waterways took: 219.083402ms
[Nov  3 09:00:35] [INFO] [PostGIS] Creating geometry index on osm_housenumbers_interpolated took: 279.650344ms
[Nov  3 09:00:35] [INFO] [PostGIS] Creating OSM id index on osm_landusages_gen0 took: 350.92288ms
[Nov  3 09:00:35] [INFO] [PostGIS] Creating geometry index on osm_amenities took: 560.321394ms
[Nov  3 09:00:36] [INFO] [PostGIS] Creating OSM id index on osm_landusages_gen1 took: 1.334473201s
[Nov  3 09:00:36] [INFO] [PostGIS] Creating geometry index on osm_landusages_gen0 took: 922.887585ms
[Nov  3 09:00:36] [INFO] [PostGIS] Creating OSM id index on osm_waterareas_gen0 took: 1.343517614s
[Nov  3 09:00:36] [INFO] [PostGIS] Creating OSM id index on osm_roads_gen0 took: 1.062252385s
[Nov  3 09:00:36] [INFO] [PostGIS] Creating OSM id index on osm_waterareas_gen1 took: 1.344338129s
[Nov  3 09:00:37] [INFO] [PostGIS] Creating geometry index on osm_landusages_gen1 took: 399.866041ms
[Nov  3 09:00:37] [INFO] [PostGIS] Creating OSM id index on osm_roads_gen1 took: 494.987734ms
[Nov  3 09:00:37] [INFO] [PostGIS] Creating geometry index on osm_waterareas_gen1 took: 204.691613ms
[Nov  3 09:00:37] [INFO] [PostGIS] Creating geometry index on osm_waterareas_gen0 took: 207.057655ms
[Nov  3 09:00:37] [INFO] [PostGIS] Creating OSM id index on osm_roads took: 2.753701721s
[Nov  3 09:00:37] [INFO] [PostGIS] Creating OSM id index on osm_waterways_gen0 took: 540.553719ms
[Nov  3 09:00:37] [INFO] [PostGIS] Creating OSM id index on osm_waterways_gen1 took: 510.084386ms
[Nov  3 09:00:37] [INFO] [PostGIS] Creating geometry index on osm_waterways_gen0 took: 169.196429ms
[Nov  3 09:00:37] [INFO] [PostGIS] Creating geometry index on osm_waterways_gen1 took: 256.142312ms
[Nov  3 09:00:38] [INFO] [PostGIS] Creating geometry index on osm_buildings took: 3.289217304s
[Nov  3 09:00:38] [INFO] [PostGIS] Creating geometry index on osm_roads_gen0 took: 1.775864035s
[Nov  3 09:00:38] [INFO] [PostGIS] Creating geometry index on osm_roads_gen1 took: 1.569991802s
[Nov  3 09:00:39] [INFO] [PostGIS] Creating geometry index on osm_housenumbers took: 4.529998377s
[Nov  3 09:00:48] [INFO] [PostGIS] Creating geometry index on osm_roads took: 11.45576913s
[Nov  3 09:00:48] [INFO] [PostGIS] Creating geometry indices took: 14.210301828s
[Nov  3 09:00:48] [INFO] Importing OSM data took: 1m16.738773229s
[Nov  3 09:00:48] [INFO] Imposm took: 1m30.781823904s
olt commented 9 years ago

These warnings should not appear anymore since e29be21f51bff9228585ff753c912f48e6663d3e