Nous utilisons des cookies pour vous garantir la meilleure expérience sur notre site. Si vous continuez à utiliser ce dernier, nous considèrerons que vous acceptez l'utilisation des cookies. J'ai compris ! ou En savoir plus !.
banniere

Le portail francophone de la géomatique


Toujours pas inscrit ? Mot de passe oublié ?
Nom d'utilisateur    Mot de passe              Toujours pas inscrit ?   Mot de passe oublié ?

Annonce

Suite à un problème technique intervenu entre le 22 et le 23 mars, nous avons du procéder dans la soirée du 25 mars, à la restauration de la base de données du 24 mars (matinée).

En clair, nous avons perdu vos contributions et inscriptions du dimanche 24 et du lundi 25 mars.
Nous vous prions de nous excuser.

#1 Tue 06 June 2017 14:19

tati
Participant occasionnel
Date d'inscription: 6 Jun 2017
Messages: 27

Warning lors de l'import des données OSM2pgsql

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)

Hors ligne

 

Pied de page des forums

Powered by FluxBB