{"action":"closed","issue":{"url":"https://api.github.com/repos/pgRouting/osm2pgrouting/issues/114","labels_url":"https://api.github.com/repos/pgRouting/osm2pgrouting/issues/114/labels{/name}","comments_url":"https://api.github.com/repos/pgRouting/osm2pgrouting/issues/114/comments","events_url":"https://api.github.com/repos/pgRouting/osm2pgrouting/issues/114/events","html_url":"https://github.com/pgRouting/osm2pgrouting/issues/114","id":103641257,"number":114,"title":"Incomplete data imported","user":{"login":"mtleung","id":6822353,"avatar_url":"https://avatars.githubusercontent.com/u/6822353?v=3","gravatar_id":"","url":"https://api.github.com/users/mtleung","html_url":"https://github.com/mtleung","followers_url":"https://api.github.com/users/mtleung/followers","following_url":"https://api.github.com/users/mtleung/following{/other_user}","gists_url":"https://api.github.com/users/mtleung/gists{/gist_id}","starred_url":"https://api.github.com/users/mtleung/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mtleung/subscriptions","organizations_url":"https://api.github.com/users/mtleung/orgs","repos_url":"https://api.github.com/users/mtleung/repos","events_url":"https://api.github.com/users/mtleung/events{/privacy}","received_events_url":"https://api.github.com/users/mtleung/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-08-28T03:41:38Z","updated_at":"2015-08-29T12:51:00Z","closed_at":"2015-08-29T12:51:00Z","body":"Originally posted on http://gis.stackexchange.com/questions/159842/incomplete-data-lines-missing-from-osm2pgrouting\r\n\r\nI am importing OSM data into PostGIS using the latest version of osm2pgrouting but some data is missing/did not import. I am using the default mapconfig.xml and this appears to work for most roads.\r\nRunning on:\r\nPostGIS version 2.1.7\r\nPostgreSQL version 9.4.4\r\nUbuntu 14.04\r\n\r\nFor example in below screencap, blue is the ways created by osm2pgrouting, and red is the line when the data is imported using osm2pgsql (using default.style and red filtered on \"highway\" = 'motorway' for this questions purposes). The missing section is a bridge, however other bridges have imported correctly, and some other roads (like 'service') are also missing.\r\n\r\n![missing_line](https://cloud.githubusercontent.com/assets/6822353/9538692/b3306b3a-4d79-11e5-93ce-c85a480f3015.png)\r\n\r\nThe osm id of one of the missing lines in the pic is 158307203 if that helps, data sourced from Mapzen. The line has this tag so I am not sure why it is not being imported.\r\n\r\nBelow is the log when I imported the data:\r\n```\r\n$osm2pgrouting -file ~/osm2pgrouting/mapconfig.xml -dbname gis -user gisuser -passwd gisuser -clean\r\nhost=127.0.0.1 user=gisuser dbname=gis port=5432 password=gisuser\r\nconnection success\r\nTrying to load config file /path/to/mapconfig.xml\r\nTrying to parse config\r\nTrying to load data\r\nTrying to parse data\r\nunknown maxspeed value: 56; 72; 72\r\nunknown maxspeed value: 56;108\r\nunknown maxspeed value: 56;108\r\nSplit ways\r\nDropping tables...\r\nCreating tables...\r\nNodes table created\r\n2create ways failed:\r\nTypes table created\r\nWay_tag table created\r\nRelations table created\r\nRelation_ways t\r\n![missing_line](https://cloud.githubusercontent.com/assets/6822353/9538688/aac4f678-4d79-11e5-8bdd-9fecd863b323.png)\r\nable created\r\nClasses table created\r\nAdding tag types and classes to database...\r\nAdding relations to database...\r\nAdding nodes to database...\r\nAdding ways to database...\r\nCreating topology...\r\nNOTICE:  PROCESSING:\r\nNOTICE:  pgr_createTopology('ways',1e-05,'the_geom','gid','source','target','tru\r\nNOTICE:  Performing checks, pelase wait .....\r\nNOTICE:  Creating Topology, Please wait...\r\nNOTICE:  1000 edges processed\r\n...\r\nNOTICE:  282000 edges processed\r\nNOTICE:  -------------> TOPOLOGY CREATED FOR  282284 edges\r\nNOTICE:  Rows with NULL geometry or NULL id: 0\r\nNOTICE:  Vertices table for table osm2pgr.ways is: osm2pgr.ways_vertices_pgr\r\nNOTICE:  ----------------------------------------------\r\nCreate Topology success\r\n```\r\nI noticed the \"2create ways failed\" message but not sure why no error message was generated."}}