Le portail francophone de la géomatique

Bonjour,

J'ai extrait des données OSM de taille 53 Mo, j'ai besoin d'importer mes données sur postgresql.

Avec Qgis j'ai eu des erreurs lors de l'import de la couche multipolygones.

Du coup j'ai essayé avec osm2pgsql (ci-dessous l'output de la commande),  mais si je connecte qgis et postgresql et j'affiche le table planet_osm_polygon pour visualiser les polygones je vois qu'il y'a des polygones maquants. Si vous pouvez m'aider slvp:


Using built-in tag processing pipeline
Using projection SRS 3857 (Spherical Mercator)
Setting up table: planet_osm_point
Setting up table: planet_osm_line
Setting up table: planet_osm_polygon
Setting up table: planet_osm_roads
Allocating memory for dense node cache
Allocating dense node cache in one big chunk
Allocating memory for sparse node cache
Sharing dense sparse
Node-cache: cache=800MB, maxblocks=12800*65536, allocation method=11
Mid: pgsql, cache=800
Setting up table: planet_osm_nodes
Setting up table: planet_osm_ways
Setting up table: planet_osm_rels

Reading in file: /media/sf_partageL/ppp/extracted-montrouge.osm
Using XML parser.
  parse time: 0s
Node stats: total(2209), max(4416271548) in 0s
Way stats: total(378), max(427651579) in 0s
Relation stats: total(29), max(6361972) in 0s
Committing transaction for planet_osm_point
Committing transaction for planet_osm_line
Committing transaction for planet_osm_polygon
Committing transaction for planet_osm_roads
Setting up table: planet_osm_nodes
Setting up table: planet_osm_ways
Setting up table: planet_osm_rels
Using built-in tag processing pipeline

Going over pending ways...
    286 ways are pending

Using 1 helper-processes
Finished processing 286 ways in 0 s

Committing transaction for planet_osm_point
Committing transaction for planet_osm_line
Committing transaction for planet_osm_polygon
Committing transaction for planet_osm_roads

Going over pending relations...
    0 relations are pending

Using 1 helper-processes
Finished processing 0 relations in 0 s

Committing transaction for planet_osm_point
WARNING:  there is no transaction in progress
Committing transaction for planet_osm_line
WARNING:  there is no transaction in progress
Committing transaction for planet_osm_polygon
WARNING:  there is no transaction in progress
Committing transaction for planet_osm_roads
WARNING:  there is no transaction in progress
Sorting data and creating indexes for planet_osm_roads
Sorting data and creating indexes for planet_osm_polygon
Sorting data and creating indexes for planet_osm_line
Sorting data and creating indexes for planet_osm_point
Copying planet_osm_point to cluster by geometry finished
Creating geometry index on planet_osm_point
Copying planet_osm_line to cluster by geometry finished
Creating geometry index on planet_osm_line
Copying planet_osm_roads to cluster by geometry finished
Creating geometry index on planet_osm_roads
Creating osm_id index on planet_osm_point
Copying planet_osm_polygon to cluster by geometry finished
Creating geometry index on planet_osm_polygon
Creating osm_id index on planet_osm_roads
Creating osm_id index on planet_osm_line
Creating osm_id index on planet_osm_polygon
Creating indexes on planet_osm_point finished
Creating indexes on planet_osm_roads finished
Creating indexes on planet_osm_polygon finished
Creating indexes on planet_osm_line finished
All indexes on planet_osm_point created in 0s
Completed planet_osm_point
All indexes on planet_osm_line created in 0s
Completed planet_osm_line
All indexes on planet_osm_roads created in 0s
Completed planet_osm_roads
All indexes on planet_osm_polygon created in 0s
Completed planet_osm_polygon
Stopping table: planet_osm_nodes
Stopped table: planet_osm_nodes in 0s
Stopping table: planet_osm_ways
Building index on table: planet_osm_ways
Stopped table: planet_osm_ways in 0s
Stopping table: planet_osm_rels
Building index on table: planet_osm_rels
Stopped table: planet_osm_rels in 0s
node cache: stored: 2209(100.00%), storage efficiency: 17.52% (dense blocks: 1, sparse nodes: 2208), hit rate: 81.95%

Osm2pgsql took 1s overall

Merci

Dernière modification par tati (Tue 06 June 2017 15:34)