New answers tagged osm2po
Your taiwan-latest.osm.pbf only contains raw OpenStreetMap-Data in a structured compressed binary format (pbf). It must be converted in order to produce a routable graph-file (*.gph) for osm2po or for pgRouting (*.sql). Please read the online-help or start the demo.bat / demo.sh to see how it works and to generate your first *.gph-File you can play with.
In PgRouting 2.0 there is a pgr_analyzeGraph function that will identify isolated segments. Isolated segments will have a dead-end at each end so a query like this against your network and vertices tables: SELECT * FROM mytab a, mytab_vertices_pgr b, mytab_vertices_pgr c WHERE a.source=b.id AND b.cnt=1 AND a.target=c.id AND c.cnt=1; will identify ...
GDAL can only read pbf files, so no chance to write it with GDAL or QGIS. Osmosis is able to read from a postgis database and write to pbf, but only for its own snapshot or simple data scheme. These schemes use nodes, ways and relations (like they are stored in the OSM database), while a "usual" Postgis data scheme uses points, lines, multilines, polygons ...
Top 50 recent answers are included