I'm using OSgeo 6.5 dvd and studing pgrouting workshop for get shortest path.I created database call "routing" and used "template_routing" for create tables but only 3 tables created. So then I executed following commands
# become user "user" (or run as user "user")sudo su user# create routing databasecreatedb routingcreatelang plpgsql routing# add PostGIS functionspsql -d routing -f /usr/share/postgresql/8.4/contrib/postgis-1.5/postgis.sqlpsql -d routing -f /usr/share/postgresql/8.4/contrib/postgis-1.5/spatial_ref_sys.sql# add pgRouting core functionspsql -d routing -f /usr/share/postlbs/routing_core.sqlpsql -d routing -f /usr/share/postlbs/routing_core_wrappers.sqlpsql -d routing -f /usr/share/postlbs/routing_topology.sqlthen 7 tables created but few tables are missing when compare to workshop..
Workshop output;
List of relationsSchema | Name | Type | Owner--------+---------------------+----------+----------public | classes | table | postgrespublic | geometry_columns | table | postgrespublic | nodes | table | postgrespublic | spatial_ref_sys | table | postgrespublic | types | table | postgrespublic | vertices_tmp | table | postgrespublic | vertices_tmp_id_seq | sequence | postgrespublic | ways | table | postgres(8 rows) My output;
List of relationsSchema | Name | Type | Owner --------+-------------------+-------+-------public | classes | table | userpublic | geography_columns | view | userpublic | geometry_columns | view | userpublic | nodes | table | userpublic | spatial_ref_sys | table | userpublic | types | table | userpublic | ways | table | user(7 rows)I got error like this
NOTICE: CREATE TABLE will create implicit sequence "vertices_tmp_id_seq" for serial column "vertices_tmp.id"CONTEXT: SQL statement "CREATE TABLE vertices_tmp (id serial)"PL/pgSQL function "assign_vertex_id" line 15 at EXECUTE statement#########################size of streets: 4093size of splitted ways : 17328finishedwhen executing this command
osm2pgrouting -file "data/sampledata.osm" \ -conf "/usr/share/osm2pgrouting/mapconfig.xml" \ -dbname routing \ -user user \ -cleanhow do I get create missing tables
أكثر...
# become user "user" (or run as user "user")sudo su user# create routing databasecreatedb routingcreatelang plpgsql routing# add PostGIS functionspsql -d routing -f /usr/share/postgresql/8.4/contrib/postgis-1.5/postgis.sqlpsql -d routing -f /usr/share/postgresql/8.4/contrib/postgis-1.5/spatial_ref_sys.sql# add pgRouting core functionspsql -d routing -f /usr/share/postlbs/routing_core.sqlpsql -d routing -f /usr/share/postlbs/routing_core_wrappers.sqlpsql -d routing -f /usr/share/postlbs/routing_topology.sqlthen 7 tables created but few tables are missing when compare to workshop..
Workshop output;
List of relationsSchema | Name | Type | Owner--------+---------------------+----------+----------public | classes | table | postgrespublic | geometry_columns | table | postgrespublic | nodes | table | postgrespublic | spatial_ref_sys | table | postgrespublic | types | table | postgrespublic | vertices_tmp | table | postgrespublic | vertices_tmp_id_seq | sequence | postgrespublic | ways | table | postgres(8 rows) My output;
List of relationsSchema | Name | Type | Owner --------+-------------------+-------+-------public | classes | table | userpublic | geography_columns | view | userpublic | geometry_columns | view | userpublic | nodes | table | userpublic | spatial_ref_sys | table | userpublic | types | table | userpublic | ways | table | user(7 rows)I got error like this
NOTICE: CREATE TABLE will create implicit sequence "vertices_tmp_id_seq" for serial column "vertices_tmp.id"CONTEXT: SQL statement "CREATE TABLE vertices_tmp (id serial)"PL/pgSQL function "assign_vertex_id" line 15 at EXECUTE statement#########################size of streets: 4093size of splitted ways : 17328finishedwhen executing this command
osm2pgrouting -file "data/sampledata.osm" \ -conf "/usr/share/osm2pgrouting/mapconfig.xml" \ -dbname routing \ -user user \ -cleanhow do I get create missing tables
أكثر...